phpBB2 by Przemo

xlesiu · AB Rh- **Helped:** 3647 times Posts: 7847 Location: Toruń

Sortowanie alfabetyczne tematów

Opis:
Sortowanie alfabetyczne tematów

Quote:

##############################################################
## MOD Title: Sortowanie alfabetyczne tematów
## MOD Author: pentapenguin < pentapenguin@bluebottle.com > (Jeremy Conley)
## MOD Description: Sortowanie alfabetyczne tematów
## MOD Version: 0.2.0
##
## Installation Level: Easy
## Installation Time: 10 Minutes
##
## Files To Edit: 3
## viewforum.php
## langauge/lang_polish/lang_main.php
## templates/NazwaStylu/viewforum_body.tpl
##
## Included Files: n/a
##
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
##############################################################

[ Dodano: 24-06-2009, 00:57 ]

Mogą być problemy z tematami z polskimi literami

sortowanie.gif

169 Time(s) 48.24 KB

sortowanie alfabetyczne.txt

Download 97 Time(s) 8.02 KB

adrian507120 · **Helped:** 24 times Posts: 716

xlesiu, jesteś wielki dziękuje za moda

Macintosh · **Helped:** 8 times Posts: 198

Fajnie, że już jest takie coś w BB by Przemo.

#MaTeK_ · Posted: 20-11-2009, 20:07 **Forum address:** http://www.mojair.pl

Macintosh, no to pokaż .. ;x
Jest tylko układ alfabetyczny a nie sortowanie co do wskazaniej litery

#Bucu · PHP <3 **Helped:** 419 times Posts: 1930 Location: Kielce

Brakuje tematow zaczynajacych sie liczbami - dopisalem.

otwieramy viewforum.php i znajdujemy:

Code:

$letters_array = array('0-9','A', 'B', 'C', 'Ć', 'D', 'E', 'Ę', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'Ł', 'M', 'N', 'Ń', 'O', 'Ó', 'P', 'Q', 'R', 'S', '¦', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '¬', 'Ż');

i zamieniamy na:

Code:

$letters_array = array('A', 'B', 'C', 'Ć', 'D', 'E', 'Ę', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'Ł', 'M', 'N', 'Ń', 'O', 'Ó', 'P', 'Q', 'R', 'S', '¦', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '¬', 'Ż');

znajdujemy:

Code:

if ( $start_letter )
{
$sql = 'SELECT COUNT(topic_id) AS forum_topics
FROM ' . TOPICS_TABLE . "
WHERE forum_id = $forum_id
AND topic_title LIKE '$start_letter%'";

if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get topic counts for letter search', '', __LINE__, __FILE__, $sql);
}

$row = $db->sql_fetchrow($result);

$topics_count = ( $row['forum_topics'] ) ? $row['forum_topics'] : 1;

$db->sql_freeresult($result);
}

i zamieniamy na:

Code:

if ( $start_letter )
{
if ( $start_letter == '0-9' )
{
$sql = 'SELECT COUNT(topic_id) AS forum_topics
FROM ' . TOPICS_TABLE . '
WHERE `forum_id` = $forum_id
AND `topic_title` RLIKE "^[0-9]"';
}
else
{
$sql = 'SELECT COUNT(topic_id) AS forum_topics
FROM ' . TOPICS_TABLE . "
WHERE forum_id = $forum_id
AND topic_title LIKE '$start_letter%'";
}

if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get topic counts for letter search', '', __LINE__, __FILE__, $sql);
}

$row = $db->sql_fetchrow($result);

$topics_count = ( $row['forum_topics'] ) ? $row['forum_topics'] : 1;

$db->sql_freeresult($result);
}

i znajdujemy:

Code:

$sql = "SELECT " . $sql_fields . "
FROM (" . $sql_tables . ")
$ignore_topics_table
WHERE t.forum_id = $forum_id
$ignore_topics_sql
AND t.topic_poster = u.user_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id
$forum_post_text_where
AND t.topic_type <> " . POST_ANNOUNCE . "
AND t.topic_title LIKE '$start_letter%'
AND t.topic_type <> " . POST_GLOBAL_ANNOUNCE . "
$limit_topics_time $sotr_methods
LIMIT $start, $user_topics_per_page";

i zamieniamy na:

Code:

if ( $start_letter == '0-9' )
{
$sql = "SELECT " . $sql_fields . "
FROM (" . $sql_tables . ")
$ignore_topics_table
WHERE t.forum_id = $forum_id
$ignore_topics_sql
AND t.topic_poster = u.user_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id
$forum_post_text_where
AND t.topic_type <> " . POST_ANNOUNCE . "
AND t.topic_title RLIKE '^[0-9]'
AND t.topic_type <> " . POST_GLOBAL_ANNOUNCE . "
$limit_topics_time $sotr_methods
LIMIT $start, $user_topics_per_page";
}
else
{
$sql = "SELECT " . $sql_fields . "
FROM (" . $sql_tables . ")
$ignore_topics_table
WHERE t.forum_id = $forum_id
$ignore_topics_sql
AND t.topic_poster = u.user_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id
$forum_post_text_where
AND t.topic_type <> " . POST_ANNOUNCE . "
AND t.topic_title LIKE '$start_letter%'
AND t.topic_type <> " . POST_GLOBAL_ANNOUNCE . "
$limit_topics_time $sotr_methods
LIMIT $start, $user_topics_per_page";
}

[ Dodano: 20-11-2009, 20:49 ]
pierwszy fragment kodu zle dodalem - znajdujemy oczywiscie

Code:

$letters_array = array('A', 'B', 'C', 'Ć', 'D', 'E', 'Ę', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'Ł', 'M', 'N', 'Ń', 'O', 'Ó', 'P', 'Q', 'R', 'S', '¦', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '¬', 'Ż');

i zamieniamy na:

Code:

$letters_array = array('0-9','A', 'B', 'C', 'Ć', 'D', 'E', 'Ę', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'Ł', 'M', 'N', 'Ń', 'O', 'Ó', 'P', 'Q', 'R', 'S', '¦', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '¬', 'Ż')

prosze moderatora o poprawienie mojego posta.

kabar · Posts: 8

Czy to sortowanie możemy włączyć dla konkretnych for?

MagicalFire · R.I.P. **Helped:** 943 times Posts: 4234 Location: cybinka

Bucu, podaj cała instrukcje
pozatym na koncu

Code:

$letters_array = array('0-9','A', 'B', 'C', 'Ć', 'D', 'E', 'Ę', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'Ł', 'M', 'N', 'Ń', 'O', 'Ó', 'P', 'Q', 'R', 'S', '¦', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '¬', 'Ż')

bowinien byc ;