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

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

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

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

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

INSERT INTO log_2019_11_16_details( log_id, url, title, referral_url, variables_post, variables_get ) VALUES( 340001, '//www.vizzed.com/user/index.php?id=408688&type=profile', '', '', '', '{\"id\":\"408688\",\"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 SUM(quantity) as total FROM market_user_items WHERE user_id=408688 /*()*/

/* TEST */ /*()*/

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

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

SELECT count(id) AS cnt FROM threads WHERE user=408688 /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_16','340001',' 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=408688 ORDER BY posts.date DESC LIMIT 1 /*()*/ ','46') /*()*/

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

UPDATE page_statistics SET views_today=0, update_daily=18216 WHERE page_id=306230 /*()*/

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=306230 AND cantremovefrompage=139816 /*()*/

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

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

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

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

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

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

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

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=306230 OR page_id=139816 OR page_id=139816 ORDER BY power DESC /*()*/

SELECT * FROM page WHERE page_order <= 2 ORDER BY page_order ASC, page_title ASC /*()*/

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' /*()*/

UPDATE log_2019_11_16 SET rendered='120', queries='73', queries_slow='1', queries_errors='' WHERE id=340001 /*()*/