Support ⇒ CPG-BB (forum) ⇒ [solved] Change Sort Order Announcments ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum Index Modules & Blocks CPG-BB (forum)

[solved] Change Sort Order Announcments Reply to topic


Hi,
can someone please give me the right direction...

I try to change the sort order of Announcements Topics from "last posted" to "Topic Titel"

in viewforum.php on line 212
// // All announcement data, this keeps announcements // on each viewforum page ... // $sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username FROM ".TOPICS_TABLE." t, ".USERS_TABLE." u, ".POSTS_TABLE." p, ".USERS_TABLE." u2 WHERE t.forum_id = $forum_id AND t.topic_poster = u.user_id AND p.post_id = t.topic_last_post_id AND p.poster_id = u2.user_id AND t.topic_type = ".POST_ANNOUNCE." ORDER BY t.topic_last_post_id DESC "; $result = $db->sql_query($sql);

i tried to change "ORDER BY t.topic_last_post_id" to "ORDER BY t.topic_titel"
but i get: the following error occured: Unknown column 't.topic_titel' in 'order clause'

How can i call it right?
It shoud sort the Topics in Announcments to the Titel Name...

Thank you
Jolinar

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
OS / Apache / MySQL 5.0.27 / PHP 5.1.6 / DF 9.3.3.1


t.topic_titel should be t.topic_title

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4


ooops
im emberrased,
please remove the Topic if possible
THANKS
Jolinar

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
OS / Apache / MySQL 5.0.27 / PHP 5.1.6 / DF 9.3.3.1


Hehe, we've all been there! Laughing

No worries.

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4

All times are UTC


Jump to: