Skocz do zawartości
"Idzie nowe..." - o zmianach i nie tylko ×
Przeniesienie zakupów z IPS Marketplace / Moving bought items from IPS Marketplace ×

angel554

Użytkownik
  • Postów

    29
  • Dołączył

  • Ostatnia wizyta

Osiągnięcia angel554

Współtwórca

Współtwórca (5/14)

  • Pierwszy post
  • Współtwórca
  • Rozpoczęcie dyskusji
  • Dobre reakcje
  • Pierwszy tydzień zakończony

Najnowsze odznaki

0

Reputacja

  1. Mam wersję 3.3.4 ale błąd dalej występuje - po wejściu na skórkę mobile nie można zmienić skina na inny- jak mogę zaktualizować skórkę mobile żeby naprawić błąd?
  2. Okazuje się, że nie tylko Ty: http://forum.invisio...-ilosc-zapytan/ Wiadomo już coś bliżej w tej sprawie - IPB działa w kierunku aktualizacji? Jakieś plany na update i czy naprawili na Twoim forum problem?
  3. No i ilość zapytań spadła do 14 :/ czyli błąd IPB z reputacją ?
  4. Keye wyxxxxowane. SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'useragents','bbcode','mediatag' ) SELECT * FROM ibf_sessions WHERE id='fd33a9xxxxxxxxxxxx' SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM ibf_members m LEFT JOIN ibf_pfields_content p ON ( p.member_id=m.member_id ) LEFT JOINibf_profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN ibf_groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN ibf_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=2 SELECT t.*,xxx.* FROM ibf_topics t LEFT JOIN ibf_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=127539 SELECT f.*,p.*,itemmarking.* FROM ibf_forums f LEFT JOIN ibf_permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id ) LEFT JOIN ibf_core_item_markers itemmarking ON ( itemmarking.item_member_id=2 AND itemmarking.item_app='forums' AND itemmarking.item_app_key_1=f.id ) SELECT * FROM ibf_topic_ratings WHERE rating_tid=127539 and rating_member_id=2 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,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 ibf_posts p LEFT JOINibf_members m ON ( m.member_id=p.author_id ) LEFT JOIN ibf_profile_portal pp ON ( m.member_id=pp.pp_member_id ) LEFT JOIN ibf_members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid ) LEFT JOIN ibf_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=2 ) LEFT JOIN ibf_reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) LEFT JOIN ibf_content_cache_posts cca ON ( cca.cache_content_id=p.pid ) LEFT JOIN ibf_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE p.topic_id=127539 AND p.queued IN (0,1,2) ORDER BY p.pid asc LIMIT 20,20 SELECT SUM(rep_rating) as sum, COUNT(*) as count FROM ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2209680' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209680' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209680,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('2165814ab7332a4199fa7xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2209680,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209680' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209680,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2209803' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209803' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209803,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('bc1da551ec3959179f1xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cbxxxxxxxxxxxx',2209803,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209803' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209803,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2209927' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209927' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209927,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('76bd24f2333bf9aabxxxxxxxxxxxx','a17de1b4e5015b2ca6bxxxxxxxxxxxx',2209927,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2209927' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2209927,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2210136' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2210136' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2210136,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('4a124856804a09ff72xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2210136,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2210136' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2210136,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2212736' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212736' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212736,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('60c8861fc768e6c2099bxxxxxxxxxxxx','a17de1b4e5015b2ca6baxxxxxxxxxxxx',2212736,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212736' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212736,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2212806' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212806' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212806,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('be5f2575014112656e1xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2212806,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212806' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212806,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2212905' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212905' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212905,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('2e7ddaf9a4128xxxxxxxxxxxx','a17de1b4e5015b2ca6b6xxxxxxxxxxxx',2212905,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2212905' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2212905,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2220411' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220411' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220411,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('11c0861472d1862d70xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2220411,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220411' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220411,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2220424' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220424' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220424,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('cc38f9ee6085xxxxxxxxxxxx','a17de1b4e5015bcxxxxxxxxxxxx',2220424,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220424' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220424,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2220472' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220472' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220472,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('837875e84530xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cbxxxxxxxxxxxx',2220472,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220472' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220472,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2220507' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220507' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220507,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('3e623cf959e3xxxxxxxxxxxx','a17de1b4e5015b2ca6baxxxxxxxxxxxx',2220507,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220507' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220507,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2220520' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220520' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220520,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('b680d5dd42c196xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2220520,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2220520' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2220520,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2221304' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2221304' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2221304,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('abcc057b36d2c9xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cxxxxxxxxxxxx',2221304,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2221304' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2221304,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2221988' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2221988' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2221988,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('280fd156be2480df9bxxxxxxxxxxxx','a17de1b4e5015b2ca6bxxxxxxxxxxxx',2221988,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2221988' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2221988,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2222068' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222068' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222068,1,1351175371,'a:2:{s:10:\"cache_data\";a:6:{s:2:\"id\";s:7:\"2222068\";s:4:\"type\";s:3:\"pid\";s:3:\"app\";s:6:\"forums\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:89288;a:2:{s:1:\"n\";s:4:\"LukC\";s:1:\"s\";s:4:\"lukc\";}}s:9:\"memberIds\";a:1:{i:0;s:5:\"89288\";}}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('9211f59839xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5cb6xxxxxxxxxxxx',2222068,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222068' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222068,1,1351175371,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:6:\"forums\";s:4:\"type\";s:3:\"pid\";s:2:\"id\";s:7:\"2222068\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:89288;a:2:{s:1:\"n\";s:4:\"LukC\";s:1:\"s\";s:4:\"lukc\";}}s:9:\"memberIds\";a:1:{i:0;s:5:\"89288\";}}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2222166' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222166' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222166,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('e186008d6d759xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5xxxxxxxxxxxx',2222166,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222166' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222166,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2222826' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222826' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222826,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('b5ee81e6c4be6b87xxxxxxxxxxxx','a17de1b4e5015b2ca6bxxxxxxxxxxxx',2222826,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2222826' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2222826,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2235381' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2235381' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2235381,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('fafd0cb046f919d1xxxxxxxxxxxx','a17de1b4e5015b2ca6ba5xxxxxxxxxxxx',2235381,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2235381' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2235381,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2326213' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2326213' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2326213,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('26a328d66d47905xxxxxxxxxxxx','a17de1b4e5015b2ca6bxxxxxxxxxxxx',2326213,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2326213' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2326213,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_index WHERE app='forums' AND type='pid' AND type_id='2326250' SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2326250' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2326250,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_reputation_totals (`rt_key`,`rt_app_type`,`rt_type_id`,`rt_total`) VALUES('fb564a0802bb8d6xxxxxxxxxxxx','a17de1b4e5015b2ca6baxxxxxxxxxxxx',2326250,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 ibf_reputation_index r LEFT JOIN ibf_members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='2326250' INSERT INTO ibf_reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',2326250,0,1351175371,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1351261771;}') 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 ibf_sessions s LEFT JOIN ibf_members m ON ( m.member_id=s.member_id ) WHERE s.id='fd33a90ba2xxxxxxxxxxxxc' OR (s.current_appcomponent='forums' AND s.running_time > 1351174471 AND s.in_error=0 AND s.location_1_type='topic' AND s.location_1_id=127539) SELECT * FROM ibf_core_like_cache WHERE like_cache_id='c9da099xxxxxxxxxxxx' SELECT * FROM ibf_core_like WHERE like_id='7dfe9174xxxxxxxxxxxx' AND like_visible=1 SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM ibf_members m LEFT JOIN ibf_pfields_content p ON ( p.member_id=m.member_id ) LEFT JOINibf_profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN ibf_groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN ibf_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=43422 SELECT member_id, dp3_pb_info, dp3_pb_disabled FROM ibf_members WHERE member_id IN (74304,43422) SELECT * FROM ibf_core_editor_autosave WHERE eas_key='e91642d3xxxxxxxxxxxx' SELECT s.s_id, s_enable, s.s_items, s.s_align, s.s_sep, s.s_rotate,i.* FROM ibf_dp3_adv_sections s LEFT JOIN ibf_permission_index i ON ( i.app='advadverts' AND i.perm_type_id=s.s_id ) WHERE i.perm_view REGEXP ',4,|\\*' AND s.s_code = "mp_top" UPDATE ibf_dp3_adv_adverts SET a_views = a_views + 1 WHERE a_id = 1 INSERT INTO ibf_dp3_adv_views (`v_mid`,`v_aid`,`v_time`,`v_ip`,`v_browser`,`v_os`,`v_country`,`v_dua`) VALUES(2,1,1351175373,'178.235.20.46','chrome','windowsnt','PL','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4') SELECT s.s_id, s_enable, s.s_items, s.s_align, s.s_sep, s.s_rotate,i.* FROM ibf_dp3_adv_sections s LEFT JOIN ibf_permission_index i ON ( i.app='advadverts' AND i.perm_type_id=s.s_id ) WHERE i.perm_view REGEXP ',4,|\\*' AND s.s_code = "allp_footer" SELECT s.s_id, s_enable, s.s_items, s.s_align, s.s_sep, s.s_rotate,i.* FROM ibf_dp3_adv_sections s LEFT JOIN ibf_permission_index i ON ( i.app='advadverts' AND i.perm_type_id=s.s_id ) WHERE i.perm_view REGEXP ',4,|\\*' AND s.s_code = "tv_afr" SELECT s.s_id, s_enable, s.s_items, s.s_align, s.s_sep, s.s_rotate,i.* FROM ibf_dp3_adv_sections s LEFT JOIN ibf_permission_index i ON ( i.app='advadverts' AND i.perm_type_id=s.s_id ) WHERE i.perm_view REGEXP ',4,|\\*' AND s.s_code = "tv_ufr" SELECT s.s_id, s_enable, s.s_items, s.s_align, s.s_sep, s.s_rotate,i.* FROM ibf_dp3_adv_sections s LEFT JOIN ibf_permission_index i ON ( i.app='advadverts' AND i.perm_type_id=s.s_id ) WHERE i.perm_view REGEXP ',4,|\\*' AND s.s_code = "tv_awt" SELECT t.*,p.pid, p.start_date as poll_start_date, p.choices, p.starter_id as poll_starter_id, p.votes, p.poll_question, p.poll_only, p.poll_view_voters FROM ibf_topics t LEFT JOIN ibf_polls p ON ( p.tid=t.tid ) WHERE t.tid=127539 SELECT aa.id, aa.keywords, aa.url, aa.count, aa.type, aa.type_id, aa.second_type_id,t.title as topic_title, t.tid as topic_id, t.title_seo FROM ibf_dp3_ass_search_visitors aa LEFT JOIN ibf_topics t ON ( t.tid = aa.type_id ) WHERE aa.type_id = 127539 AND aa.type = "showtopic" ORDER BY aa.date DESC LIMIT 0,10 SELECT aa.id, aa.keywords, aa.url, aa.count, aa.type, aa.type_id, aa.second_type_id,t.title as topic_title, t.tid as topic_id, t.title_seo FROM ibf_dp3_ass_search_visitors aa LEFT JOIN ibf_topics t ON ( t.tid = aa.type_id ) WHERE ( aa.type_id IN (173,174,215,218,48) OR aa.second_type_id IN (173,174,215,218,48) ) AND ( aa.type = "showforum" OR aa.type = "showtopic" ) ORDER BY aa.date DESC LIMIT 0,10 SELECT blog_id FROM ibf_blog_blogs WHERE FIND_IN_SET(2, blog_authorized_users) SELECT blog_id FROM ibf_blog_blogs WHERE FIND_IN_SET(2, blog_authorized_users) SELECT blog_id FROM ibf_blog_blogs WHERE FIND_IN_SET(2, blog_authorized_users) SELECT * FROM ibf_blog_this WHERE bt_app='forums' AND bt_id1=127539 SHUTDOWN: UPDATE ibf_topics SET views=views+1 WHERE tid=127539
  5. No tak. Tylko jak wydobyć tą listę zapytań dla danej strony
  6. Witam, zauważyłem że przy przeglądaniu postów na moim forum wykonywane są GIGANTYCZNE ilości zapytań - np. przy załadowaniu kolejnej strony tematu przyciskiem "dalej" strona generuje się ponad 3 sekundy i wymagała ponad 150 zapytań! Czy nowe IPB 3.3.x jest aż tak mySQLo-żerne?! Dodam że podana ilość zapytań jest generowana przy wyłączonych wszystkich Aplikacjach i rozszerzeniach nie będących pochodzenia IPS.
  7. Czy zmiana kodowania forum na UTF-8 zlikwiduje problem? ewentualnie czy nie pomoże przejście do starszej wersji?
  8. Witam, po aktualizacji z IPB 3.2x do 3.3x mam problem w postaci krzaków (a dokładniej wyświetlają się encje) w polskich znakach w nowych wpisach na forum. Poradziłem sobie z tym problemem włączając funkcję "Disable AJAX for text" niestety problem dalej występuje w zakładce Shoutboxa, na stronie głównej wpisy w SB są dodawane poprawnie. Czym różni się wstawianie postów w zakładce SB od tego na stronie głównej? Ktoś może zna rozwiązanie problemu? Kodowanie na stronie to ISO-8859-2. Pozdrawiam
  9. Witam, po ataku spamerów, muszę usunąć około 10 000 postów jednego usera ;/ Problemem w tym że z poziomu ACP idzie to jak krew z nosa, zanim w ogóle rozpocznie się procedura kasowania (po 50 postów) mija kilkanaście minut - zwykle nie doczekuję tego, a w efekcie końcowym i tak się wszystko wiesza. Próbowałem usunąć całość zawartości danego działu - ale jest podobnie - strasznie wolno. Znacie jakieś rozwiązanie z tej sytuacji? Ewentualnie w której wersji IPB jest to jakoś poprawione, korzystam z 3.1.4.
  10. witam, od jakiegoś czasu mam problem z nie ładującymi się do końca wszystkimi obrazkami na forum. Wchodzę na podstrony i wiele obrazków pozostaje niezaładowanych. Sprawdzałem na kilku pc i sieciach, pod różnymi przeglądarkami. Problem jest taki że na kolejnych podstronach zawsze kilka avatarów, standardowych obrazków ze skina itp. pozostaje niezaładowanych (puste miejsce), po kilku odświeżeniach strony sytuacja się poprawia - ale nie o to chodzi... Co można zrobić aby te obrazki ładowały się prawidłowo? chmody ustawione dobrze, łącze śmiga, najczęściej nie ładują się emotikonki z listy wyboru - pokazuje że obrazek ma 0kb i 0x0 px (wtedy pomaga jedynie wejście na bezpośrednią ścieżkę emotikonki w osobnej zakładce i ponowne odświeżenie strony...). Pozdrawiam
  11. Witam, czy ktoś się orientuje czy jest takowa modyfikacja, która umożliwia usunięcie konta użytkownika bezpośrednio z poziomu profilu UCP? Z możliwościami pozostawienia IP i innych danych do wglądu admina w razie potrzeby? Bez kasowania postów i tematów założonych?
  12. Witam, chciałem zapytać - gdyż nie znalazłem na nurtujące mnie pytanie nigdzie w sieci i wyszukiwarce forumowej odp. na problem wyświetlania dziennej daty w shoutboxie tzn. "Dzisiaj" / "Wczoraj" itp. Mam shoutboxa 1.2.3 - czy ktoś się orientuje czy mogę w łatwy sposób dodać takie oznaczenia na forum????
×
×
  • Dodaj nową pozycję...

Powiadomienie o plikach cookie

Umieściliśmy na Twoim urządzeniu pliki cookie, aby pomóc Ci usprawnić przeglądanie strony. Możesz dostosować ustawienia plików cookie, w przeciwnym wypadku zakładamy, że wyrażasz na to zgodę.