SELECT * FROM ibps_cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','chatting','ccs_menu' )
DELETE FROM ibps_sessions WHERE ip_address='3.91.19.28'
SELECT t.*,xxx.* FROM ibps_topics t LEFT JOIN ibps_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=59933
SELECT f.*,p.* FROM ibps_forums f LEFT JOIN ibps_permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id )
SELECT * FROM ibps_skin_cache WHERE cache_set_id=4 AND cache_type IN ('css', 'replacements')
SELECT banned_members FROM ibps_topics WHERE tid = 59933
SELECT * FROM ibps_topic_ratings WHERE rating_tid=59933 and rating_member_id=0
SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ( SELECT pid, post_date FROM ibps_posts WHERE topic_id=59933 AND queued=0 ORDER BY pid asc LIMIT 0,20 ) z LEFT JOIN ibps_posts p ON ( p.pid=z.pid )
LEFT JOIN ibps_members m ON ( m.member_id=p.author_id )
LEFT JOIN ibps_profile_portal pp ON ( m.member_id=pp.pp_member_id )
LEFT JOIN ibps_members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid )
LEFT JOIN ibps_pfields_content pc ON ( pc.member_id=p.author_id )
LEFT JOIN ibps_reputation_index rep_index ON ( rep_index.app='forums' AND
rep_index.type='pid' AND
rep_index.type_id=p.pid AND
rep_index.member_id=0 )
LEFT JOIN ibps_reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid )
LEFT JOIN ibps_content_cache_posts cca ON ( cca.cache_content_id=p.pid )
LEFT JOIN ibps_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) ORDER BY z.pid asc
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598230'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598230'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598230,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('7ec910154e0b257c70d11c1d9ba91f5a','a17de1b4e5015b2ca6ba5cb6ca3b488d',598230,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598230'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598230,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598233'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598233'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598233,1,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598233\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}}s:9:\"memberIds\";a:1:{i:0;s:2:\"31\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('fb21e2c24c54779d1ac5ef8a50add02d','a17de1b4e5015b2ca6ba5cb6ca3b488d',598233,1) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598233'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598233,1,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598233\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}}s:9:\"memberIds\";a:1:{i:0;s:2:\"31\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598236'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598236'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598236,3,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598236\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:3;s:11:\"memberNames\";a:3:{i:55;a:2:{s:1:\"n\";s:11:\"HappyViking\";s:1:\"s\";s:11:\"happyviking\";}i:583;a:2:{s:1:\"n\";s:9:\"Havoc1649\";s:1:\"s\";s:9:\"havoc1649\";}i:1498;a:2:{s:1:\"n\";s:9:\"Vikefever\";s:1:\"s\";s:9:\"vikefever\";}}s:9:\"memberIds\";a:3:{i:0;s:2:\"55\";i:1;s:3:\"583\";i:2;s:4:\"1498\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('020713061fba1a065cd96a66a744371a','a17de1b4e5015b2ca6ba5cb6ca3b488d',598236,3) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598236'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598236,3,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598236\";s:5:\"count\";i:3;s:11:\"memberNames\";a:3:{i:55;a:2:{s:1:\"n\";s:11:\"HappyViking\";s:1:\"s\";s:11:\"happyviking\";}i:583;a:2:{s:1:\"n\";s:9:\"Havoc1649\";s:1:\"s\";s:9:\"havoc1649\";}i:1498;a:2:{s:1:\"n\";s:9:\"Vikefever\";s:1:\"s\";s:9:\"vikefever\";}}s:9:\"memberIds\";a:3:{i:0;s:2:\"55\";i:1;s:3:\"583\";i:2;s:4:\"1498\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598238'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598238'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598238,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('f8248c3e50ca647c16dfde2916df51f2','a17de1b4e5015b2ca6ba5cb6ca3b488d',598238,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598238'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598238,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598239'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598239'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598239,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('99e1ed9a50735ea097b42c673515bd82','a17de1b4e5015b2ca6ba5cb6ca3b488d',598239,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598239'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598239,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598241'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598241'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598241,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('ea7e51abf0fa609f2dec6477762e22aa','a17de1b4e5015b2ca6ba5cb6ca3b488d',598241,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598241'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598241,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598242'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598242'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598242,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598242\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:30;a:2:{s:1:\"n\";s:9:\"A1Janitor\";s:1:\"s\";s:9:\"a1janitor\";}i:528;a:2:{s:1:\"n\";s:7:\"psblake\";s:1:\"s\";s:7:\"psblake\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"30\";i:1;s:3:\"528\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('49a13485fd85857dbe78012437b65f52','a17de1b4e5015b2ca6ba5cb6ca3b488d',598242,2) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598242'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598242,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598242\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:30;a:2:{s:1:\"n\";s:9:\"A1Janitor\";s:1:\"s\";s:9:\"a1janitor\";}i:528;a:2:{s:1:\"n\";s:7:\"psblake\";s:1:\"s\";s:7:\"psblake\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"30\";i:1;s:3:\"528\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598251'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598251'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598251,5,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598251\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:5;s:11:\"memberNames\";a:5:{i:8;a:2:{s:1:\"n\";s:11:\"Purple Czar\";s:1:\"s\";s:11:\"purple-czar\";}i:23;a:2:{s:1:\"n\";s:9:\"JimmyinSD\";s:1:\"s\";s:9:\"jimmyinsd\";}i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:533;a:2:{s:1:\"n\";s:7:\"Minny65\";s:1:\"s\";s:7:\"minny65\";}i:1484;a:2:{s:1:\"n\";s:10:\"Riphawkins\";s:1:\"s\";s:10:\"riphawkins\";}}s:9:\"memberIds\";a:5:{i:0;s:1:\"8\";i:1;s:2:\"23\";i:2;s:2:\"31\";i:3;s:3:\"533\";i:4;s:4:\"1484\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('85fe16dbf71cc573c823711fc00d8317','a17de1b4e5015b2ca6ba5cb6ca3b488d',598251,5) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598251'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598251,5,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598251\";s:5:\"count\";i:5;s:11:\"memberNames\";a:5:{i:8;a:2:{s:1:\"n\";s:11:\"Purple Czar\";s:1:\"s\";s:11:\"purple-czar\";}i:23;a:2:{s:1:\"n\";s:9:\"JimmyinSD\";s:1:\"s\";s:9:\"jimmyinsd\";}i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:533;a:2:{s:1:\"n\";s:7:\"Minny65\";s:1:\"s\";s:7:\"minny65\";}i:1484;a:2:{s:1:\"n\";s:10:\"Riphawkins\";s:1:\"s\";s:10:\"riphawkins\";}}s:9:\"memberIds\";a:5:{i:0;s:1:\"8\";i:1;s:2:\"23\";i:2;s:2:\"31\";i:3;s:3:\"533\";i:4;s:4:\"1484\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598254'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598254'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598254,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598254\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:1484;a:2:{s:1:\"n\";s:10:\"Riphawkins\";s:1:\"s\";s:10:\"riphawkins\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"31\";i:1;s:4:\"1484\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('d5dc5c07c40d39d1bb5f061dd2c8f50b','a17de1b4e5015b2ca6ba5cb6ca3b488d',598254,2) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598254'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598254,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598254\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:1484;a:2:{s:1:\"n\";s:10:\"Riphawkins\";s:1:\"s\";s:10:\"riphawkins\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"31\";i:1;s:4:\"1484\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598262'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598262'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598262,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598262\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:1346;a:2:{s:1:\"n\";s:11:\"IDVikingfan\";s:1:\"s\";s:11:\"idvikingfan\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"31\";i:1;s:4:\"1346\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('3359b8cc491b687a8fe5f4a15e3989f3','a17de1b4e5015b2ca6ba5cb6ca3b488d',598262,2) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598262'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598262,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598262\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:1346;a:2:{s:1:\"n\";s:11:\"IDVikingfan\";s:1:\"s\";s:11:\"idvikingfan\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"31\";i:1;s:4:\"1346\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598264'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598264'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598264,3,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598264\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:3;s:11:\"memberNames\";a:3:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:1075;a:2:{s:1:\"n\";s:10:\"Viking Bob\";s:1:\"s\";s:10:\"viking-bob\";}i:1335;a:2:{s:1:\"n\";s:13:\"Purplemachine\";s:1:\"s\";s:13:\"purplemachine\";}}s:9:\"memberIds\";a:3:{i:0;s:2:\"31\";i:1;s:4:\"1075\";i:2;s:4:\"1335\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('a4e2554fb7ab908555d0d95803aac26f','a17de1b4e5015b2ca6ba5cb6ca3b488d',598264,3) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598264'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598264,3,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598264\";s:5:\"count\";i:3;s:11:\"memberNames\";a:3:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:1075;a:2:{s:1:\"n\";s:10:\"Viking Bob\";s:1:\"s\";s:10:\"viking-bob\";}i:1335;a:2:{s:1:\"n\";s:13:\"Purplemachine\";s:1:\"s\";s:13:\"purplemachine\";}}s:9:\"memberIds\";a:3:{i:0;s:2:\"31\";i:1;s:4:\"1075\";i:2;s:4:\"1335\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598268'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598268'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598268,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598268\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:1335;a:2:{s:1:\"n\";s:13:\"Purplemachine\";s:1:\"s\";s:13:\"purplemachine\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"31\";i:1;s:4:\"1335\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('ac7a0d834ca6c1a0d6d3e23e41ec0342','a17de1b4e5015b2ca6ba5cb6ca3b488d',598268,2) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598268'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598268,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598268\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:1335;a:2:{s:1:\"n\";s:13:\"Purplemachine\";s:1:\"s\";s:13:\"purplemachine\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"31\";i:1;s:4:\"1335\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598294'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598294'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598294,1,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598294\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:30;a:2:{s:1:\"n\";s:9:\"A1Janitor\";s:1:\"s\";s:9:\"a1janitor\";}}s:9:\"memberIds\";a:1:{i:0;s:2:\"30\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('9011d4abedeb06ae5d3e3e94feded14e','a17de1b4e5015b2ca6ba5cb6ca3b488d',598294,1) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598294'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598294,1,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598294\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:30;a:2:{s:1:\"n\";s:9:\"A1Janitor\";s:1:\"s\";s:9:\"a1janitor\";}}s:9:\"memberIds\";a:1:{i:0;s:2:\"30\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598325'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598325'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598325,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598325\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:23;a:2:{s:1:\"n\";s:9:\"JimmyinSD\";s:1:\"s\";s:9:\"jimmyinsd\";}i:1335;a:2:{s:1:\"n\";s:13:\"Purplemachine\";s:1:\"s\";s:13:\"purplemachine\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"23\";i:1;s:4:\"1335\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('efa0e56e064bcd46b499455fa8d67ae0','a17de1b4e5015b2ca6ba5cb6ca3b488d',598325,2) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598325'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598325,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598325\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:23;a:2:{s:1:\"n\";s:9:\"JimmyinSD\";s:1:\"s\";s:9:\"jimmyinsd\";}i:1335;a:2:{s:1:\"n\";s:13:\"Purplemachine\";s:1:\"s\";s:13:\"purplemachine\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"23\";i:1;s:4:\"1335\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598330'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598330'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598330,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('ebeebe3913d80e45d6918e86617eccba','a17de1b4e5015b2ca6ba5cb6ca3b488d',598330,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598330'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598330,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598339'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598339'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598339,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('b496c7d7cccfaeb868b8f5c6cec12c40','a17de1b4e5015b2ca6ba5cb6ca3b488d',598339,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598339'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598339,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598343'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598343'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598343,1,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598343\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:1335;a:2:{s:1:\"n\";s:13:\"Purplemachine\";s:1:\"s\";s:13:\"purplemachine\";}}s:9:\"memberIds\";a:1:{i:0;s:4:\"1335\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('b19cdb8fe81c923a00c6b7ba0dddaefc','a17de1b4e5015b2ca6ba5cb6ca3b488d',598343,1) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598343'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598343,1,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598343\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:1335;a:2:{s:1:\"n\";s:13:\"Purplemachine\";s:1:\"s\";s:13:\"purplemachine\";}}s:9:\"memberIds\";a:1:{i:0;s:4:\"1335\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598344'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598344'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598344,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('d8217f76b2a21e16649f9443ede01a11','a17de1b4e5015b2ca6ba5cb6ca3b488d',598344,0) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598344'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598344,0,1711642375,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598346'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598346'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598346,1,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598346\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:1239;a:2:{s:1:\"n\";s:11:\"purplewhizz\";s:1:\"s\";s:11:\"purplewhizz\";}}s:9:\"memberIds\";a:1:{i:0;s:4:\"1239\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('d29d6a80587c4b9b6dc6cdef384c58c6','a17de1b4e5015b2ca6ba5cb6ca3b488d',598346,1) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598346'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598346,1,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598346\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:1239;a:2:{s:1:\"n\";s:11:\"purplewhizz\";s:1:\"s\";s:11:\"purplewhizz\";}}s:9:\"memberIds\";a:1:{i:0;s:4:\"1239\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibps_reputation_index WHERE app='forums' AND type='pid' AND type_id='598348'
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598348'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598348,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:6:\"598348\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:1335;a:2:{s:1:\"n\";s:13:\"Purplemachine\";s:1:\"s\";s:13:\"purplemachine\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"31\";i:1;s:4:\"1335\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
INSERT INTO ibps_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('68794fc510fa3a171c2ad671e0d50ee9','a17de1b4e5015b2ca6ba5cb6ca3b488d',598348,2) ON DUPLICATE KEY UPDATE rt_key=VALUES(rt_key),rt_app_type=VALUES(rt_app_type),rt_type_id=VALUES(rt_type_id),rt_total=VALUES(rt_total)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibps_reputation_index r LEFT JOIN ibps_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='598348'
INSERT INTO ibps_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',598348,2,1711642375,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:6:\"598348\";s:5:\"count\";i:2;s:11:\"memberNames\";a:2:{i:31;a:2:{s:1:\"n\";s:5:\"pumpf\";s:1:\"s\";s:5:\"pumpf\";}i:1335;a:2:{s:1:\"n\";s:13:\"Purplemachine\";s:1:\"s\";s:13:\"purplemachine\";}}s:9:\"memberIds\";a:2:{i:0;s:2:\"31\";i:1;s:4:\"1335\";}}s:12:\"cache_expire\";i:1711728775;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT s.*, s.id as row_session_id,m.* FROM ibps_sessions s LEFT JOIN ibps_members m ON ( m.member_id=s.member_id ) WHERE s.id='a8c124c7ea797f341295a59d9972dbae' OR (s.current_appcomponent='forums' AND s.running_time > 1711641476 AND s.in_error=0 AND s.location_1_type='topic' AND s.location_1_id=59933)
SELECT * FROM ibps_core_like_cache WHERE like_cache_id='ee4d99aaac5118d93e4fcd2bc6bb1276'
SELECT f.*,p.* FROM ibps_forums f LEFT JOIN ibps_permission_index p ON ( p.perm_type_id=f.id AND p.app='forums' AND p.perm_type='forum' ) WHERE f.id=0
SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM ibps_core_tags tg LEFT JOIN ibps_topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN ibps_members m ON (last_poster_id=m.member_id) LEFT JOIN ibps_profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN ibps_core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=59933 AND tg.tag_text IN ('on topic') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM ibps_core_tags_perms WHERE ( ( FIND_IN_SET(2,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100
SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM ibps_members m LEFT JOIN ibps_pfields_content p ON ( p.member_id=m.member_id )
LEFT JOIN ibps_profile_portal pp ON ( pp.pp_member_id=m.member_id )
LEFT JOIN ibps_groups g ON ( g.g_id=m.member_group_id )
LEFT JOIN ibps_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id IN (6,36,1806)
SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM ibps_members m LEFT JOIN ibps_pfields_content p ON ( p.member_id=m.member_id )
LEFT JOIN ibps_profile_portal pp ON ( pp.pp_member_id=m.member_id )
LEFT JOIN ibps_groups g ON ( g.g_id=m.member_group_id )
LEFT JOIN ibps_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=1262
SELECT b.*,t.tpb_name FROM ibps_ccs_blocks b LEFT JOIN ibps_ccs_template_blocks t ON ( t.tpb_id=b.block_template ) WHERE b.block_active=1
SELECT * FROM ibps_ccs_template_blocks WHERE tpb_name='block__custom_50'
UPDATE ibps_ccs_template_blocks SET tpb_content='<php>ob_start();\n$this->DB->query( \"SELECT * from ibps_topics where ibps_topics.forum_id in (2,15) and ibps_topics.starter_id = 58 order by start_date DESC limit 15\" );\r\n\r\nprint \"\r\n\r\n <style>\r\n #newsMarquee A{\r\n color: #ffffff;\r\n }\r\n\r\n </style>\r\n <marquee id=\'newsMarquee\' behavior=\'scroll\' direction=\'left\' \r\n onmouseover=\'this.stop();\' \r\n onmouseout=\'this.start();\'\r\n SCROLLamount=3\r\n \r\n bgcolor=\'#000000\'\r\n>\r\n\";\r\n\r\nwhile( $r = $this->DB->fetch() )\r\n{\r\n\r\n $url=\"http://{parse block=\'siteurl\'}/index.php?/topic/\".$r[\'tid\'].\"-\".$r[\'title_seo\'];\r\n print \"<a href=\'\".$url.\"\' target=\'_blank\'>\".$r[\'title\'].\"</a> \";\r\n}\r\nprint \"\r\n </marquee>\r\n\";\n$IPBHTML .= ob_get_contents();\nob_end_clean();</php>' WHERE tpb_id=64
INSERT INTO ibps_ccs_template_cache (`cache_type`,`cache_type_id`,`cache_content`) VALUES('block',64,'/* -- block__custom_50 --*/\nfunction block__custom_50($title=\"\",$content=\"\") {\n$IPBHTML = \"\";\n\nob_start();\n$this->DB->query( \"SELECT * from ibps_topics where ibps_topics.forum_id in (2,15) and ibps_topics.starter_id = 58 order by start_date DESC limit 15\" );\r\n\r\nprint \"\r\n\r\n <style>\r\n #newsMarquee A{\r\n color: #ffffff;\r\n }\r\n\r\n </style>\r\n <marquee id=\'newsMarquee\' behavior=\'scroll\' direction=\'left\' \r\n onmouseover=\'this.stop();\' \r\n onmouseout=\'this.start();\'\r\n SCROLLamount=3\r\n \r\n bgcolor=\'#000000\'\r\n>\r\n\";\r\n\r\nwhile( $r = $this->DB->fetch() )\r\n{\r\n\r\n $url=\"http://{parse block=\'siteurl\'}/index.php?/topic/\".$r[\'tid\'].\"-\".$r[\'title_seo\'];\r\n print \"<a href=\'\".$url.\"\' target=\'_blank\'>\".$r[\'title\'].\"</a> \";\r\n}\r\nprint \"\r\n </marquee>\r\n\";\n$IPBHTML .= ob_get_contents();\nob_end_clean();\n$IPBHTML .= \"\";\nreturn $IPBHTML;\n}\n') ON DUPLICATE KEY UPDATE cache_type=VALUES(cache_type),cache_type_id=VALUES(cache_type_id),cache_content=VALUES(cache_content)
SELECT cache_content FROM ibps_ccs_template_cache WHERE cache_type='full'
SELECT * from ibps_topics where ibps_topics.forum_id in (2,15) and ibps_topics.starter_id = 58 order by start_date DESC limit 15
SELECT * FROM ibps_ccs_template_blocks WHERE tpb_name='block__custom_53'
UPDATE ibps_ccs_template_blocks SET tpb_content='<php>ob_start();\necho\"www.vikefans.com\";\n$IPBHTML .= ob_get_contents();\nob_end_clean();</php>' WHERE tpb_id=67
INSERT INTO ibps_ccs_template_cache (`cache_type`,`cache_type_id`,`cache_content`) VALUES('block',67,'/* -- block__custom_53 --*/\nfunction block__custom_53($title=\"\",$content=\"\") {\n$IPBHTML = \"\";\n\nob_start();\necho\"www.vikefans.com\";\n$IPBHTML .= ob_get_contents();\nob_end_clean();\n$IPBHTML .= \"\";\nreturn $IPBHTML;\n}\n') ON DUPLICATE KEY UPDATE cache_type=VALUES(cache_type),cache_type_id=VALUES(cache_type_id),cache_content=VALUES(cache_content)
SELECT * FROM ibps_cache_store WHERE cs_key IN ( 'blogmods' )
SELECT * FROM ibps_blog_this WHERE bt_app='forums' AND bt_id1=59933
SHUTDOWN: INSERT INTO ibps_sessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('a8c124c7ea797f341295a59d9972dbae','',0,2,0,1711642375,'3.91.19.28','claudebot',0,'forums','forums','topics','topic',59933,'forum',0,'',0,'__NONE__',0,'',0)
SHUTDOWN: INSERT INTO ibps_topic_views (`views_tid`) VALUES(59933)