camkunimura's Profile -

SELECT * FROM page LEFT JOIN page_statistics ON page_statistics.page_id = id WHERE url = "/user?id=102014" /*()*/

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 vizzed_logs.log_ip WHERE ip=INET_ATON('18.205.96.39') /*()*/

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_14 WHERE ip_id=1562030 AND date > 1573713430 - 3 /*()*/

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_14 WHERE ip_id=1562030 AND date > 1573713430 - 60 /*()*/

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

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

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( user_id, ip_id, page_id, browser_id, device_id, os_id, unique_id, security, date ) VALUES( '', '1562030', '302201', '23586', '2', '2', '79784212', '', 1573713430 ) /*()*/

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

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

/* TEST */ /*()*/

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

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

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

SELECT * FROM banlog WHERE banUserID=102014 and banStatus='Active' ORDER BY banStartDate ASC LIMIT 1 /*()*/

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

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

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 * FROM `page_variables` WHERE page_id=302201 /*()*/

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

UPDATE guests SET date=1573713431, last_page_id=302201,last_parent_id=139816,last_directory_id=139816 WHERE ip = '18.205.96.39' /*()*/

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

SELECT views FROM misc /*()*/

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

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

SELECT COUNT(*) as total FROM guests WHERE date >= 1573713431-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=302201 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' /*()*/

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

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