Tails the Fox's Profile -

/* 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('34.231.21.123',ip)=1 /*()*/

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

SELECT id FROM vizzed_logs.log_ip WHERE ip=INET_ATON('34.231.21.123') /*()*/

SELECT * FROM log_ip WHERE ip=INET_ATON('34.231.21.123') /*()*/

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_19( user_id, ip_id, page_id, browser_id, device_id, os_id, unique_id, security, date ) VALUES( '', '1527189', '300793', '23586', '2', '2', '23670069', '', 1574223246 ) /*()*/

INSERT INTO log_2019_11_19_details( log_id, url, title, referral_url, variables_post, variables_get ) VALUES( 339278, '//www.vizzed.com/user/index.php?id=6765&type=profile', '', '', '', '{\"id\":\"6765\",\"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 */ /*()*/

/* TEST */ /*()*/

SELECT useranks,currency FROM users WHERE name='Tails the Fox' /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_19','339278',' SELECT threads.id, threads.title, forums.minpower, posts.date FROM posts INNER JOIN threads ON threads.id = posts.thread INNER JOIN forums ON forums.id = threads.forum WHERE posts.user=6765 ORDER BY posts.date DESC LIMIT 1 /*()*/ ','391') /*()*/

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

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 id FROM guests WHERE ip = '34.231.21.123' ORDER BY date DESC LIMIT 1 /*()*/

UPDATE guests SET date=1574223247, last_page_id=300793,last_parent_id=139816,last_directory_id=139816 WHERE ip = '34.231.21.123' /*()*/

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

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

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1574223247-900 AND last_page_id=300793 /*()*/

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

SELECT id FROM guests WHERE date >= 1574223247-900 AND (last_directory_id=139816 OR last_page_id=139816) /*()*/

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1574223247-900 /*()*/

SELECT COUNT(*) as total FROM guests WHERE date >= 1574223247-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=300793 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_19 LIMIT 1 /*()*/

UPDATE log_2019_11_19 SET rendered='451', queries='72', queries_slow='1', queries_errors='' WHERE id=339278 /*()*/