cid789's Profile -

SELECT id, url, url_format, directory_id, page_order, update_date, update_users, last_users, views_today, parent_id, directory_id, theme_id FROM page INNER JOIN page_statistics ON page_statistics.page_id = id WHERE id=139816 /*()*/

/* get_browser Start /* /*()*/

/* get_browser End /* /*()*/

SELECT count(*) FROM ipbans WHERE INSTR('XXXXXXXXXXXXXXXXX',ip)=1 /*()*/

SELECT count(*) FROM ipbans WHERE INSTR('XXXXXXXXXXXXXXXXX',ip)=1 /*()*/

SELECT count(*) FROM ipbans WHERE INSTR('18.205.96.39',ip)=1 /*()*/

SELECT ip FROM logs_11_14_19 ORDER BY id DESC LIMIT 2 /*()*/

SELECT id FROM log_2019_11_14 LIMIT 1 /*()*/

SELECT * FROM log_browser WHERE browser_details='CCBot/2.0 (https://commoncrawl.org/faq/)' /*()*/

SELECT * FROM log_device WHERE device='unknown' /*()*/

SELECT * FROM log_os WHERE os='unknown' /*()*/

INSERT INTO log_2019_11_14_details( log_id, url, title, referral_url, variables_post, variables_get ) VALUES( 8701, '//www.vizzed.com/user/index.php?id=602570&type=profile', '', '', '', '{\"id\":\"602570\",\"type\":\"profile\"}' ) /*()*/

SELECT * FROM boardconfig /*()*/

SELECT name,posts,sex,powerlevel,id FROM users,postradar WHERE postradar.user=0 AND users.id=postradar.comp ORDER BY posts DESC /*()*/

SELECT * FROM users_group INNER JOIN users_group_user ON users_group_user.group_id = users_group.id WHERE type=8 /*()*/

SELECT * FROM users_customization /*()*/

SELECT * FROM tourdevizzedmonthly WHERE year=2019 AND month=10 /*()*/

/* Get File Contents from information.php */ /*()*/

SELECT COUNT(id) as total FROM game_user_collection WHERE user_id=602570 /*()*/

SELECT SUM(quantity) as total FROM market_user_items WHERE user_id=602570 /*()*/

SELECT SUM(quantity) as total FROM market_vizzed WHERE userid=602570 AND active=1 /*()*/

SELECT useranks,currency FROM users WHERE name='cid789' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='602570' /*()*/

SELECT text FROM ranks WHERE num<=15 AND rset=1 ORDER BY num DESC LIMIT 1 /*()*/

UPDATE page_statistics SET views_today=views_today+1, views=views+1 WHERE page_id=943388 /*()*/

UPDATE page_statistics SET views_today=0, update_daily=18214 WHERE page_id=943388 /*()*/

SELECT * FROM `page_variables_theme_variables` WHERE page_variables_theme_id=1 /*()*/

SELECT * FROM `page_variables` WHERE page_id=139816 /*()*/

SELECT * FROM `page_variables` WHERE page_id=139816 /*()*/

SELECT COUNT(id) as total FROM page_content WHERE cantremovefrompage=139816 /*()*/

SELECT COUNT(page_content.id) as total FROM page_content LEFT JOIN page_content_url ON page_content_url.page_content_id=page_content.id WHERE page_content_url.page_id=943388 AND cantremovefrompage=139816 /*()*/

SELECT id FROM guests WHERE ip = '18.205.96.39' ORDER BY date DESC LIMIT 1 /*()*/

SELECT allkeywords,id FROM page_indexes WHERE url='/user/index.php?id=602570&type=profile' /*()*/

SELECT distinct keywords, SUM(total) as counttotal, searchengine FROM searchkeywords WHERE url='/user/index.php?id=602570&type=profile' AND keywords <> '' GROUP BY keywords ORDER BY counttotal DESC, date DESC LIMIT 10 /*()*/

UPDATE misc SET views=2534774826 /*()*/

SELECT title FROM announcements ORDER BY date DESC LIMIT 5 /*()*/

SELECT id FROM guests WHERE date >= 1573713425-900 AND last_page_id=943388 /*()*/

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1573713425-900 AND (last_directory_id=139816 OR last_page_id=139816) /*()*/

SELECT COUNT(*) as total FROM guests WHERE date >= 1573713425-900 /*()*/

SELECT page_admin.power, users_group.name as group_name, group_id, user_id as userid , users.birthday as userbirthday, users.name as username, users.regdate as userregdate, users.posts as userposts, users.sex as usersex, users.powerlevel as userpowerlevel, users.postsToday as userpostsToday, users.picture as userpic FROM `page_admin` LEFT JOIN users ON users.id=page_admin.user_id LEFT JOIN users_group ON users_group.id=page_admin.group_id WHERE page_id=943388 OR page_id=139816 OR page_id=139816 ORDER BY power DESC /*()*/

SELECT * FROM page_content WHERE title='Miscellaneous Stats and Links' /*()*/

SELECT * FROM page_content WHERE title='Post Layout' /*()*/

SELECT * FROM page_content WHERE title='Friend List' /*()*/

SELECT * FROM page_content WHERE title='Reverse Friend List' /*()*/

SELECT * FROM page_content WHERE title='Referrals' /*()*/

SELECT id FROM log_2019_11_14 LIMIT 1 /*()*/

UPDATE log_2019_11_14 SET rendered='87', queries='72', queries_slow='', queries_errors='' WHERE id=8701 /*()*/