| Startseite / Debug | Infos | Impressum | Mitglieder | Blog | Suche |
[sql] => Array
(
[0] => select * from [chat] limit 0 (Ergebnisse: -)
[1] => select * from [cms] limit 0 (Ergebnisse: -)
[2] => select * from [file] limit 0 (Ergebnisse: -)
[3] => select * from [forum] limit 0 (Ergebnisse: -)
[4] => select * from [user] limit 0 (Ergebnisse: -)
[5] => select * from [worm] limit 0 (Ergebnisse: -)
[6] => select * from [xss] limit 0 (Ergebnisse: -)
[7] => update [user] set id = 0 where 0 = 1 (Aenderungen: 0)
[8] => select count(*) from [user] (Array-Ergebnisse: 1.1)
[9] => select ifnull(r.content,ifnull(c.content,'')) as '.content',
strftime('%s',ifnull(r.change,c.change)) as change,
strftime('%s',ifnull(r.[create],c.[create])) as 'create',
ifnull(r.id,c.id) as id,
ifnull(r.name,c.name) as name,
ifnull(r.description,c.description) as title,
ifnull(ifnull(r.status,c.status)/2%4,'-1') as right,
(select username from user where status/2%2 = 1) as 'from',
'cms' as type
from [cms] as c
left join [cms] as r on r.name like c.content
where c.name like 'Debug' and c.status/2%4 <= 0 (Array-Ergebnisse: 0)
[10] => update [user] set status = (status/2%8*2), -- Autologoff
chat = null
where status = (status/2%8*2+1)
and datetime(change,'+60 minutes') < datetime('now','localtime')
and status is not null;
update user set [chat] = null -- Aufraeumen
where id = ( select a.id
from [user] as a
left join [user] as b on a.chat = b.id -- Chatpartner noch Online (Moeglicher Fehler: > 0)
where a.status is not null and a.chat > 0 and b.chat is null -- Chatter nicht gesperrt und noch Online (Moeglicher Fehler: > 0)
limit 1); -- und Chatpartner nicht im Chat
delete from [chat]
where chat = (select a.chat -- chatkanal
from [chat] as a
left join [user] as b on a.chat = b.chat -- Teilnehmer des Chatkanals
or a.chat <= 0 and a.user = b.id and status%2 = 1 -- Teilnehmer ist online
or abs(a.chat) = b.id and a.chat != b.id and (b.chat is null and status%2 = 1 or b.chat = b.id)
where b.id is null -- Keins der Bedingungen trifft zu!
group by a.chat
limit 1) (Aenderungen: 0)
[11] => select count(*)
from [forum] as f
left join [user] as u on f.userid = u.id and f.status is not null and u.status is not null
where f.mailid is null and f.status%2 = 0 and f.path is null (Array-Ergebnisse: 1.1)
[12] => select f.id as id,
f.[create] as 'create',
f.[change] as change,
f.changes as changes,
ifnull(f.status/2%2,'-1') as 'right',
strftime('%d.%m.%Y %H:%M:%S',f.[create]) as crdatum,
strftime('%d.%m.%Y %H:%M:%S',f.change) as chdatum,
f.title as title,
f.message as message,
f.status as 'f.status',
u.status as 'u.status',
s.status as 's.status',
u.username as username,
u.tagline as tagline,
f.userid as userid,
f.path as path,
r.title as rtitle,
b.username as ruser,
r.userid as ruid,
b.status as rstat,
strftime('%d.%m.%Y %H:%M:%S',r.[create]) as rdate,
t.id as 't.id',
f.mailid as mailid,
s.username as mailto
from [forum] as f
left join [forum] as r on f.path like '%/'||r.id||'/' and r.status is not null
left join [forum] as t on t.path like '%/'||f.id||'/' and t.status is not null
left join [user] as u on u.id = f.userid and f.status is not null and u.status is not null
left join [user] as b on b.id = r.userid and b.status is not null
left join [user] as s on s.id = f.mailid and s.status is not null
where f.mailid is null and f.status%2 = 0 and f.path is null
group by f.id
order by f.id
limit 10,10 (Array-Ergebnisse: 7.24)
[13] => select count(*) from [forum] where path like '%/28/%' and status is not null (Array-Ergebnisse: 1.1)
[14] => select count(*) from [forum] where path like '%/35/%' and status is not null (Array-Ergebnisse: 1.1)
[15] => select count(*) from [forum] where path like '%/36/%' and status is not null (Array-Ergebnisse: 1.1)
[16] => select count(*) from [forum] where path like '%/43/%' and status is not null (Array-Ergebnisse: 1.1)
[17] => select count(*) from [forum] where path like '%/48/%' and status is not null (Array-Ergebnisse: 1.1)
[18] => select count(*) from [forum] where path like '%/59/%' and status is not null (Array-Ergebnisse: 1.1)
[19] => select name from [cms] where name like '_%' and status%2 = 1 and status/2%4 <= 0 order by name (Array-Ergebnisse: 1.1)
[20] => select count(*),count(b.id)
from forum as a
left join forum as b on a.id = b.id and b.id is null
where a.mailid = a.userid and a.status is not null and a.status%2 = 0 (Array-Ergebnisse: 1.4)
)
| GET Array ( [page] => 2 ) | COOKIE Array ( [logsql] => 1 [debug] => 1 [sqlite3] => 1 [PHPSESSID] => un3oj64sksuiqi3kba4hv1tca6 ) | SESSION Array ( [src] => 3 ) |
| HTTP Header Array ( [HTTP_ACCEPT] => */* [HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate [HTTP_CACHE_CONTROL] => max-age=0 [HTTP_CONNECTION] => close [HTTP_COOKIE] => logsql=1; debug=1; sqlite3=1; PHPSESSID=un3oj64sksuiqi3kba4hv1tca6 [HTTP_HOST] => forum.mengelke.de [HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) [HTTP_VIA] => 1.1 squid-proxy-5b96dc6d46-n46qj (squid/6.13) [HTTP_X_FORWARDED_FOR] => 10.3.47.82 [PATH_INFO] => /Debug [REMOTE_ADDR] => 216.73.216.159 [REMOTE_PORT] => 25246 [REQUEST_METHOD] => GET [REQUEST_SCHEME] => http [REQUEST_TIME] => 1795360993 [REQUEST_URI] => /index.php5/Debug?page=2 ) | ||