Demo

Probiere ClanSphere aus und teste daran herum. Demo


Antworten: 5
Seite [1]
Miraculix


Going for pro




Herkunft: Füssen
Beiträge: 429
# Thema - 18.02.2009 um 01:26 Uhr
Sufu war erfolglos
Mir ist kein besserer Titel eingefallen.

Problem:
Im Forum werden bei Seite 2,3,... die Antworten immer von #1 weg gezählt anstatt #21,#41,...

Problem besteht seit Update von 2008.2.1 auf Version: 2008.3_SVN - Rev. 1766.

Einzig bearbeitete Datei:
in mods/board/ - navlist.php
in mods/users/ - keine
in mods/comments/ - keine

start geht aber. also zB: ?mod=board&action=thread&start=100&where=9

debug +-
Warning: cs_html_div - Function is marked for removal, please use themes!
Warning: cs_html_span - Function is marked for removal, please use themes!
Warning: cs_html_table - Function is marked for removal, please use themes!
Warning: cs_html_roco - Function is marked for removal, please use themes!
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime, users_ajax, users_tpl, users_pwd FROM cs_users WHERE users_id = '1' AND users_pwd = '35bc6c28bca27fbecc144761d32d09986876438f' AND users_active = 1 LIMIT 0,1
UPDATE cs_users SET users_laston='1234912411' WHERE users_id='1'
SELECT * FROM cs_access WHERE access_id = 5 LIMIT 0,1
SELECT count_id, count_time FROM cs_count WHERE count_ip = '92.229.166.178' ORDER BY count_id DESC LIMIT 0,1
UPDATE cs_count SET count_time='1234912411', count_location='board/thread' WHERE count_id='13049'
SELECT users_readtime FROM cs_users WHERE users_id = 1 LIMIT 0,1
SELECT COUNT(*) FROM cs_threads WHERE threads_id = 9
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'board' AND comments_fid = 9
SELECT frm.board_access AS board_access, frm.board_read AS board_read, frm.board_name AS board_name, frm.board_id AS board_id, thr.threads_time AS threads_time, thr.threads_text AS threads_text, thr.threads_important AS threads_important, thr.threads_headline AS threads_headline, thr.threads_view AS threads_view, thr.threads_last_time AS threads_last_time, thr.threads_id AS threads_id, thr.threads_edit AS threads_edit, thr.threads_close AS threads_close, cat.categories_name AS categories_name, cat.categories_id AS categories_id, usr.users_id AS users_id, usr.users_country AS users_country, usr.users_nick AS users_nick, usr.users_avatar AS users_avatar, usr.users_place AS users_place, usr.users_hidden AS users_hidden, usr.users_signature AS users_signature, usr.users_laston AS users_laston, usr.users_email AS users_email, usr.users_icq AS users_icq, usr.users_msn AS users_msn, usr.users_url AS users_url, usr.users_skype AS users_skype, usr.users_active AS users_active, usr.users_invisible AS users_invisible, frm.squads_id AS squads_id FROM cs_threads thr INNER JOIN cs_board frm ON thr.board_id = frm.board_id LEFT JOIN cs_users usr ON thr.users_id = usr.users_id INNER JOIN cs_categories cat ON frm.categories_id = cat.categories_id WHERE thr.threads_id = 9 LIMIT 0,1
SELECT boardranks_min, boardranks_name FROM cs_boardranks ORDER BY boardranks_min ASC
UPDATE cs_threads SET threads_view='7562' WHERE threads_id='9'
SELECT read_id FROM cs_read WHERE threads_id = 9 AND users_id = 1 LIMIT 0,1
UPDATE cs_read SET read_since='1234912411' WHERE read_id='271'
SELECT abonements_id FROM cs_abonements WHERE threads_id = 9 AND users_id = 1 LIMIT 0,1
SELECT boardmods_modpanel, boardmods_edit, boardmods_del FROM cs_boardmods WHERE users_id = 1 LIMIT 0,1
SELECT users_id FROM cs_boardmods
SELECT bdr.comments_id AS comments_id, bdr.boardreport_id AS boardreport_id, bdr.boardreport_time AS boardreport_time, bdr.boardreport_text AS boardreport_text, bdr.users_id AS users_id, usr.users_nick AS users_nick, usr.users_active AS users_active, bdr.boardreport_done AS boardreport_done FROM cs_boardreport bdr INNER JOIN cs_users usr ON bdr.users_id = usr.users_id WHERE bdr.threads_id = 9 ORDER BY bdr.comments_id ASC
SELECT boardvotes_access, boardvotes_end, boardvotes_question, boardvotes_election FROM cs_boardvotes WHERE threads_id = 9 LIMIT 0,1
SELECT comments_id, boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 9 AND comments_id = 0 ORDER BY boardfiles_id ASC
SELECT threads_id FROM cs_threads WHERE board_id = '6' AND threads_time > '1210182513' ORDER BY threads_time ASC LIMIT 0,1
SELECT users_nick, users_country, com.users_id AS users_id, users_avatar, users_laston, users_invisible, users_place, users_hidden, comments_time, comments_edit, comments_fid, comments_text, users_signature, users_email ,users_msn, users_icq, users_skype,users_active,users_url, comments_id FROM cs_comments com LEFT JOIN cs_users usr ON com.users_id = usr.users_id WHERE comments_mod = 'board' AND comments_fid = 9 ORDER BY comments_id ASC LIMIT 100,10
SELECT COUNT(*) FROM cs_comments WHERE users_id = '22'
SELECT COUNT(*) FROM cs_threads WHERE users_id = '22'
SELECT abcode_func, abcode_pattern, abcode_result, abcode_file FROM cs_abcode
SELECT boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 9 AND comments_id = 669 ORDER BY boardfiles_id ASC
SELECT COUNT(*) FROM cs_comments WHERE users_id = '32'
SELECT COUNT(*) FROM cs_threads WHERE users_id = '32'
SELECT boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 9 AND comments_id = 672 ORDER BY boardfiles_id ASC
SELECT COUNT(*) FROM cs_comments WHERE users_id = '1'
SELECT COUNT(*) FROM cs_threads WHERE users_id = '1'
SELECT boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 9 AND comments_id = 673 ORDER BY boardfiles_id ASC
SELECT boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 9 AND comments_id = 676 ORDER BY boardfiles_id ASC
SELECT boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 9 AND comments_id = 680 ORDER BY boardfiles_id ASC
SELECT COUNT(*) FROM cs_comments WHERE users_id = '2'
SELECT COUNT(*) FROM cs_threads WHERE users_id = '2'
SELECT boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 9 AND comments_id = 682 ORDER BY boardfiles_id ASC
SELECT boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 9 AND comments_id = 683 ORDER BY boardfiles_id ASC
SELECT boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 9 AND comments_id = 685 ORDER BY boardfiles_id ASC
SELECT COUNT(*) FROM cs_comments WHERE users_id = '13'
SELECT COUNT(*) FROM cs_threads WHERE users_id = '13'
SELECT boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 9 AND comments_id = 688 ORDER BY boardfiles_id ASC
SELECT boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 9 AND comments_id = 689 ORDER BY boardfiles_id ASC
SELECT users_id, comments_time FROM cs_comments WHERE comments_mod = 'board' AND comments_fid = 9 ORDER BY comments_id DESC LIMIT 0,1
SELECT abcode_pattern, abcode_file FROM cs_abcode WHERE abcode_func = 'img' LIMIT 0,9
SELECT metatags_id, metatags_name, metatags_content FROM cs_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT users_id, users_nick, users_country, users_active, users_invisible FROM cs_users WHERE users_laston > 1234912111 AND users_active = '1' AND users_invisible = '0' ORDER BY users_laston DESC LIMIT 0,8
SELECT votes_id, votes_question, votes_election, votes_several FROM cs_votes WHERE votes_access <= '5' AND votes_start <= '1234912411' AND votes_end >= '1234912411' ORDER BY RAND() LIMIT 0,1
SELECT users_age,users_nick FROM cs_users WHERE users_age LIKE '%-02-%'
SELECT wars.wars_date AS wdate,clans.clans_name AS enemy,categories.categories_name AS categorie FROM cs_wars wars INNER JOIN cs_clans clans ON (clans.clans_id = wars.clans_id) INNER JOIN cs_categories categories ON (categories.categories_id = wars.categories_id) WHERE wars.wars_date >= '1233446400' AND wars.wars_date <= '1235865599'
SELECT events_time,events_name,events_more FROM cs_events WHERE events_time >= '1233446400' AND events_time <= '1235865599'
SELECT gallery_id FROM cs_gallery WHERE gallery_access < '5' AND gallery_status = '1' ORDER BY gallery_id DESC
SELECT COUNT(*) FROM cs_count WHERE count_time > '1234912111'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1234908000'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1233439200'
SELECT count_num FROM cs_count_archiv
SELECT COUNT(*) FROM cs_count
SELECT * FROM cs_ticker tck JOIN cs_options opt ON opt.options_mod='ticker' WHERE tck.ticker_id=opt.options_value AND opt.options_name='active_id' LIMIT 0,1
SELECT news_id, news_headline, news_time FROM cs_news WHERE news_public > 0 ORDER BY news_time DESC LIMIT 0,3
SELECT users_readtime FROM cs_users WHERE users_id = '1' LIMIT 0,1
SELECT thr.threads_headline AS threads_headline, thr.threads_id AS threads_id, thr.threads_last_time AS threads_last_time FROM cs_threads thr INNER JOIN cs_board frm ON frm.board_id = thr.board_id LEFT JOIN cs_read red ON thr.threads_id = red.threads_id AND red.users_id = '1' WHERE frm.board_access <= '5' AND frm.board_pwd = '' AND thr.threads_last_time > '1233702811' AND (thr.threads_last_time > red.read_since OR red.threads_id IS NULL) ORDER BY thr.threads_last_time DESC LIMIT 0,6
...


------------------
greeetz Miraculix

Band-Page -> www.muddleheaded-scum.de
Inaktiv
duRiel ClanSphere Team


Weltmeister




Herkunft: Cambridge
Beiträge: 7300
# Antwort: 1 - 18.02.2009 um 01:46 Uhr
was meinst du mit "start geht aber"?


Inaktiv
|
Miraculix
Thread-Ersteller


Going for pro




Herkunft: Füssen
Beiträge: 429
# Antwort: 2 - 18.02.2009 um 17:58 Uhr
Das meinte ich:
?mod=board&action=thread&start=100&where=9
War vielleicht n bisschen blöd ausgedrückt.

Hab grad das noch festgestellt:
mehr... +-
das geht: ?mod=board&action=thread&start=100&where=9#com9
sollte es aber eigentlich nicht.

das geht: ?mod=board&action=thread&where=9#com9

aber das nicht: ?mod=board&action=thread&where=9#com55
sollte aber.

Und hier noch der Link (hab ich glatt vergessen):
http://www.kultis-ohne-gnade.de/debug.php?mod=board&action=thread&start=100&where=9

Es wird auf jeder Seite ganz oben # Antwort: 1 angezeigt und bis 10,20,35,50 gezählt. Je nach User-Einstellungen.

Ich hoffe dass mein Problem jetzt verständlicher ist.


------------------
greeetz Miraculix

Band-Page -> www.muddleheaded-scum.de

Inaktiv
|
duRiel ClanSphere Team


Weltmeister




Herkunft: Cambridge
Beiträge: 7300
# Antwort: 3 - 18.02.2009 um 18:30 Uhr
http://www.clansphere.de/trac/clansphere/changeset/1782/


Inaktiv
|
Miraculix
Thread-Ersteller


Going for pro




Herkunft: Füssen
Beiträge: 429
# Antwort: 4 - 18.02.2009 um 18:44 Uhr
oh das ging ja flott

vielen Dank

funzt!

ps: dachte das Prob wär nur bei mir deswegen nicht Bugtracker. Naja das nächste mal.

kann geclosed werden


------------------
greeetz Miraculix

Band-Page -> www.muddleheaded-scum.de

Inaktiv
|
duRiel ClanSphere Team


Weltmeister




Herkunft: Cambridge
Beiträge: 7300
# Antwort: 5 - 18.02.2009 um 19:07 Uhr
hab ich mir gedacht.
kann dir die coins trotzdem geben wenn du willst

gruß,

duRiel


Inaktiv
|

Dieses Thema wurde von duRiel ClanSphere Team PM geschlossen.

Antworten: 5
Seite [1]