
Discusión abierta (nuevas respuestas)

Discusión abierta (sin nuevas respuestas)

Discusión viva (nuevas respuestas)

Discusión viva (sin nuevas respuestas)
Queries Used
DELETE FROM ibf_sessions WHERE running_time < 1284156745 or ip_address='38.107.191.105'
INSERT INTO ibf_sessions (id, member_name, member_id, ip_address, browser, running_time, location, login_type, member_group) VALUES ('70daaf106e2bb5bd7bccfc0255586a85', '', '0', '38.107.191.105', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', '1284160345', ',,', '0', 2)
SELECT * from ibf_groups WHERE g_id='2'
SELECT s.*, t.template, c.css_text
FROM ibf_skins s
LEFT JOIN ibf_templates t ON (t.tmid=s.tmpl_id)
LEFT JOIN ibf_css c ON (c.cssid=s.css_id)
WHERE s.sid=0
SELECT f.*, c.id as cat_id, c.name as cat_name
FROM ibf_forums f
LEFT JOIN ibf_categories c ON (c.id=f.category)
WHERE f.id=3
SELECT f.id as forum_id, f.parent_id, f.subwrap, f.sub_can_post, f.name as forum_name, f.position, f.redirect_on, f.read_perms, c.id as cat_id, c.name
FROM ibf_forums f
LEFT JOIN ibf_categories c ON (c.id=f.category)
WHERE c.state IN (1,2)
ORDER BY c.position, f.position
SELECT COUNT(tid) as max FROM ibf_topics WHERE forum_id=3 and approved=1 and (pinned=1 or last_post > 0)
SELECT * from ibf_topics WHERE forum_id=3 and approved=1 and (last_post > 0 OR pinned=1) ORDER BY pinned DESC, last_post DESC LIMIT 0,30
SELECT macro_value, macro_replace FROM ibf_macro WHERE macro_set=1