Lissy_S's Beiträge

Erzeugt in 0.01754 Sekunden mit 22 Abfragen
Nettolaufzeit: 0.01754 Cps: 57
SELECT typ,item,value FROM system_sys_vars
SELECT released FROM riddle_questions WHERE released>'2025-04-30 15:38:59' AND ok=1 LIMIT 0,1
UPDATE system_users SET user_online=0 WHERE user_online=1 AND user_last_action < 1746019139
DELETE FROM system_sessions WHERE session_bot=1 OR session_time < 1745933939
SELECT count(*) FROM system_sessions WHERE uid=0 AND session_bot = 0 AND session_time > 1746019139
SELECT count(*) FROM system_users WHERE user_online=1
INSERT INTO system_sessions (sid,uid,gid,session_ip,session_time,session_bot) VALUES ('1165fd3dd7d4edacd7623ac43266b8e4',0,99,'0381d131',1746020339,1)
SELECT * FROM system_sessions WHERE sid='1165fd3dd7d4edacd7623ac43266b8e4'
SELECT * FROM system_users WHERE uid=0
SELECT * FROM system_users WHERE uid=15897
SELECT count(*) FROM forum_categories c,forum_posts p WHERE p.post_deleted=0 AND p.post_poster=15897 AND c.cid=p.cid AND c.categorie_auth>=99
SELECT pid FROM forum_categories c,forum_posts p WHERE p.post_deleted=0 AND p.post_poster=15897 AND c.cid=p.cid AND c.categorie_auth>=99 ORDER BY post_time desc LIMIT 225,15
SELECT p.pid,p.tid,p.fid,p.fid_parent,p.cid, p.post_time,p.post_subject,p.post_uid,p.post_text,t.thread_title,f.forum_title,f1.forum_title AS parentforum_title,c.categorie_count_foren+c.categorie_count_subforen AS categorie_count_allforen,c.categorie_title,count(p2.pid) AS post_page FROM forum_categories c,forum_foren f1,forum_foren f, forum_threads t,forum_posts p,forum_posts p2 WHERE p.pid in (424170,424160,424151,424009,423948,423891,423886,423873,423866,423820,423813,423810,423804,423597,423042) AND t.tid=p.tid AND f.fid=p.fid AND f1.fid=p.fid_parent AND c.cid=p.cid AND p2.post_deleted=0 AND p2.tid=p.tid AND p2.pid<=p.pid GROUP BY p.pid,t.tid,f.fid,f1.fid,c.cid ORDER BY post_time desc
SELECT r.rid,r.riddle_name,q.level,q.released FROM riddle_riddles r,riddle_questions q WHERE r.riddle_launched=1 AND q.riddle=r.rid AND q.ok=1 AND q.released>="2025-04-30 15:38:59" ORDER BY released LIMIT 0,1
SELECT r.rid,r.riddle_name,q.level,q.released FROM riddle_riddles r,riddle_questions q WHERE r.riddle_launched=1 AND q.riddle=r.rid AND q.ok=1 AND q.released>="2025-04-30 15:38:59" ORDER BY released LIMIT 0,1
SELECT count(*) FROM riddle_riddles r, riddle_questions q WHERE r.riddle_launched=1 AND q.riddle=r.rid AND q.ok=1 AND q.released < "2025-04-30 15:38:59"
UPDATE system_sessions SET session_page = 'userposts',session_time = 1746020339 ,session_data='b:0;' WHERE sid='1165fd3dd7d4edacd7623ac43266b8e4'
INSERT INTO stats_bot_ip SET date='2025-04-30',ip='0381d131',agent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',page='userposts',count=1 ON DUPLICATE KEY UPDATE count=count+1
UPDATE system_sys_vars SET value='1746020399|0|0|-' WHERE typ='V' AND item='countdown'
UPDATE system_sys_vars SET value='1746020339' WHERE typ='V' AND item='session_auto_logout_lastcheck'
UPDATE system_sys_vars SET value='7' WHERE typ='V' AND item='system_count_online_guests'
INSERT INTO stats_counter_pi (id,count_bot,date,hour) VALUES ('userposts','1','2025-04-30','15') ON DUPLICATE KEY UPDATE count_bot=count_bot+1