s = 2bb89c631ad6c5facbb4a48d1ba03455
showforum = 117
prune_day = 100
sort_by = Z-A
sort_key = last_post
st = 30
IP_ADDRESS = 3.12.107.29
request_method = get
act = SF
f = 117
Privacy =
last_visit =

SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='2bb89c631ad6c5facbb4a48d1ba03455' and ip_address='3.12.107.29'

---

DELETE FROM ibf_sessions WHERE running_time < 1714319681 or ip_address='3.12.107.29' or id='2bb89c631ad6c5facbb4a48d1ba03455'

---

INSERT INTO ibf_sessions (id, member_name, member_id, ip_address, browser, running_time, location, login_type, member_group) VALUES ('930a360394c39749a0d3d52063ebf89a', '', '0', '3.12.107.29', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko;', '1714323281', ',,', '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 (s.css_id=c.cssid) WHERE s.default_set=1

---

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=117

---

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=117 and approved=1 and (pinned=1 or last_post > 0)

---

SELECT * from ibf_topics WHERE forum_id=117 and approved=1 and (last_post > 0 OR pinned=1) ORDER BY pinned DESC, last_post DESC LIMIT 30,15

---

SELECT s.member_id, s.member_name, s.login_type, s.location, g.suffix, g.prefix, g.g_perm_id, t.forum_id, m.org_perm_id FROM ibf_sessions s LEFT JOIN ibf_groups g ON (g.g_id=s.member_group) LEFT JOIN ibf_topics t ON (t.tid=s.in_topic) LEFT JOIN ibf_members m on (s.member_id=m.id) WHERE (s.in_forum=117 OR t.forum_id=117) AND s.running_time > 1714322381 ORDER BY s.running_time DESC

---

SELECT macro_value, macro_replace FROM ibf_macro WHERE macro_set=9

---