[BETA] Category Title & link in Crumb Trail mod - UPDATE

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Jimi D
Registered User
Posts: 19
Joined: Mon Sep 08, 2003 1:56 pm

[BETA] Category Title & link in Crumb Trail mod - UPDATE

Post by Jimi D »

UPDATE - This will be my final version before submission unless someone comes up with some additions/bugs. :-)

The new version improves the SQL syntax and integration to include the required queries in a given script page's original SQL statement(s) where possible (this involved changes to the code on all three *.php pages), and cleans up the mod instructions some...


This mod places the Category Title in the Crumb Trail that builds at the top and bottom of the page as you drill down into the forums to read specific posts, and creates a link back to the Index page with the category specified in the query string. It works best in tandem with Adrian's excellent Cat Index Alternative (CIA) Mod, but it can be used alone. When you use it with CIA, clicking on the link sends you to a category specific index page, while using it without CIA sends you back to the index page with all other categories collapsed.

This zip the latest MOD Template with instructions on what changes to make...

http://www3.sympatico.ca/jimi_d/cat_crumb_mod.zip
Last edited by Jimi D on Tue Sep 30, 2003 12:18 am, edited 3 times in total.
Jimi D
Registered User
Posts: 19
Joined: Mon Sep 08, 2003 1:56 pm

Re: [BETA] Category Title & link in Crumb Trail mod

Post by Jimi D »

In the interests of making it easier for people to see the code, here's the entire mod:

Code: Select all

############################################################## 
## MOD Title: Category Crumb Trail  
## MOD Author: Jimi D < [email protected] > (Jim Einarson) N/A 
## MOD Description: Adds the Category Title and a link back to the Index page with category-specific query
## 			to the Crumb Trail at page top and bottom...
## MOD Version: 0.9.2b 
## 
## Installation Level: Easy
## Installation Time: 10 Minutes 
## Files To Edit: viewforum.php, viewtopic.php, viewforum_body.tpl, viewtopic_body.tpl, posting.php, posting_body.tpl 
## Included Files: n/a
############################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/ 
############################################################## 
## Author Notes: Category in crumb trail mod... This modification puts the category title in the crumb trail that
## builds at the top and bottom of the page as you drill down into the forums to read specific posts, and creates
## a link back to the Index page with the category specified in the query string. It works best in tandem with 
## Adrian Cockburn's excellent Cat Index Alternative (CIA) Mod, but it can be used alone.
############################################################## 
## MOD History: 
## 
##   2003-09-28 - Version 0.9.2b 
##      - improved the SQL syntax and integration to include the required queries in a given page script's 
##	original SQL statement(s) where possible (involved changes to the code on all *.php pages)
##      - improved/clarified the MOD instructions in the template, adding commented code where reasonable
##   2003-09-22 - Version 0.9.0b 
##      - works on my deployment of phpBB 2.0.6 but was developed for use in-house... No obvious
##         bugs but I don't know how the SQL will hold up under heavy use... caveat emptor :-)
## 
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 

# 
#-----[ OPEN ]------------------------------------------ 
# 
viewforum.php

#
#-----[ FIND ]------------------------------------------
#
	$sql = "SELECT *
		FROM " . FORUMS_TABLE . "
		WHERE forum_id = $forum_id";

# 
#-----[ REPLACE WITH ]------------------------------------
#  

// original SQL before Category Title mod
/*	$sql = "SELECT *
		FROM " . FORUMS_TABLE . "
		WHERE forum_id = $forum_id";
*/ 
//
// Category Title in Crumb Trail mod... 
//
	$sql = "SELECT f.* , c.cat_title
		FROM " . FORUMS_TABLE . " f , " . CATEGORIES_TABLE . " c 
		WHERE forum_id = $forum_id AND f.cat_id = c.cat_id";
//
// End of Category Title in Crumb Trail mod
//


# 
#-----[ FIND ]------------------------------------------ 
#  
	'POST_IMG' => ( $forum_row['forum_status'] == FORUM_LOCKED ) ? $images['post_locked'] : $images['post_new'],


# 
#-----[ AFTER, ADD ]------------------------------------
#  
	// Category Title in Crumb Trail Mod...
	'CATEGORY_NAME' => $forum_row['cat_title'],
	// End of Category Title in Crumb Trail Mod

# 
#-----[ FIND ]------------------------------------------ 
#  
	'U_VIEW_FORUM' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL ."=$forum_id"),


# 
#-----[ AFTER, ADD ]------------------------------------
#  
	// Category Title in Crumb Trail Mod...
	'U_VIEW_CATEGORY' => append_sid("index.$phpEx?c=" . $forum_row['cat_id']),
	// End of Category Title in Crumb Trail Mod


# 
#-----[ OPEN ]------------------------------------------ 
# 
viewtopic.php

# 
#-----[ FIND ]------------------------------------------ 
#  

$sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments" . $count_sql . "
	FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f" . $join_sql_table . "
	WHERE $join_sql
		AND f.forum_id = t.forum_id
		$order_sql";

# 
#-----[ REPLACE WITH ]---------------------------------- 
#  

// original SQL before Category Title mod
/* $sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments" . $count_sql . "
	FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f" . $join_sql_table . "
	WHERE $join_sql
		AND f.forum_id = t.forum_id
		$order_sql";
*/ 
//
// Category Title in Crumb Trail mod... 
//
$sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, c.cat_title, f.forum_name, f.forum_status, f.forum_id, f.cat_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments" . $count_sql . "
	FROM " . TOPICS_TABLE . " t, " . CATEGORIES_TABLE. " c," . FORUMS_TABLE . " f" . $join_sql_table . "
	WHERE $join_sql
		AND f.forum_id = t.forum_id
		AND f.cat_id = c.cat_id
		$order_sql";
//
// End of Category Title in Crumb Trail mod
//


# 
#-----[ FIND ]------------------------------------------ 
#  

$forum_id = intval($forum_topic_data['forum_id']);


# 
#-----[ AFTER, ADD ]---------------------------- 
#

// Category Title in Crumb Trail Mod... 
$cat_id = intval($forum_topic_data['cat_id']);
$cat_name = $forum_topic_data['cat_title'];
// End of Category Title in Crumb Trail Mod 


# 
#-----[ FIND ]------------------------------------------ 
#  

	'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / intval($board_config['posts_per_page']) ) + 1 ), ceil( $total_replies / intval($board_config['posts_per_page']) )),


# 
#-----[ AFTER, ADD ]------------------------------------
#  

	// Category Title in Crumb Trail Mod...
	'CATEGORY_NAME' => $cat_name,
	// End of Category Title in Crumb Trail Mod


# 
#-----[ FIND ]------------------------------------------ 
#  

	'U_VIEW_TOPIC' => append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&start=$start&postdays=$post_days&postorder=$post_order&highlight=$highlight"),


# 
#-----[ BEFORE, ADD ]------------------------------------
# 

	// Category Title in Crumb Trail Mod...
	'U_VIEW_CATEGORY' => append_sid("index.$phpEx?c=$cat_id"),
	// End of Category Title in Crumb Trail Mod


# 
#-----[ OPEN ]------------------------------------------ 
# 
posting.php


# 
#-----[ FIND ]------------------------------------------ 
# 

		$sql = "SELECT *  
			FROM " . FORUMS_TABLE . " 
			WHERE forum_id = $forum_id";

# 
#-----[ REPLACE WITH ]---------------------------- 
#

// original SQL before Category Title mod
/*		$sql = "SELECT *
			FROM " . FORUMS_TABLE . "
			WHERE forum_id = $forum_id";
*/ 
//
// Category Title in Crumb Trail mod... 
//
		$sql = "SELECT f.* , c.cat_title
			FROM " . FORUMS_TABLE . " f , " . CATEGORIES_TABLE . " c 
			WHERE forum_id = $forum_id AND f.cat_id = c.cat_id";
//
// End of Category Title in Crumb Trail mod
//


# 
#-----[ FIND ]------------------------------------------ 
# 

		$sql = "SELECT f.*, t.topic_status, t.topic_title  
			FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t
			WHERE t.topic_id = $topic_id
				AND f.forum_id = t.forum_id";

# 
#-----[ REPLACE WITH ]---------------------------- 
#

// original SQL before Category Title mod
/*		$sql = "SELECT f.*, t.topic_status, t.topic_title  
			FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t
			WHERE t.topic_id = $topic_id
				AND f.forum_id = t.forum_id";
*/ 
//
// Category Title in Crumb Trail mod... 
//
		$sql = "SELECT f.*, c.cat_title, t.topic_status, t.topic_title  
			FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c, " . TOPICS_TABLE . " t
			WHERE t.topic_id = $topic_id
				AND f.forum_id = t.forum_id
				AND f.cat_id = c.cat_id";

//
// End of Category Title in Crumb Trail mod
//


# 
#-----[ FIND ]------------------------------------------ 
# 
		$sql = "SELECT f.*, t.topic_id, t.topic_status, t.topic_type, t.topic_first_post_id, t.topic_last_post_id, t.topic_vote, p.post_id, p.poster_id" . $select_sql . " 
			FROM " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f" . $from_sql . " 
			WHERE p.post_id = $post_id 
				AND t.topic_id = p.topic_id 
				AND f.forum_id = p.forum_id
				$where_sql";

# 
#-----[ REPLACE WITH ]---------------------------- 
#

// original SQL before Category Title mod
/*		$sql = "SELECT f.*, t.topic_id, t.topic_status, t.topic_type, t.topic_first_post_id, t.topic_last_post_id, t.topic_vote, p.post_id, p.poster_id" . $select_sql . " 
			FROM " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f" . $from_sql . " 
			WHERE p.post_id = $post_id 
				AND t.topic_id = p.topic_id 
				AND f.forum_id = p.forum_id
				$where_sql";
*/ 
//
// Category Title in Crumb Trail mod... 
//
		$sql = "SELECT f.*, c.cat_title, t.topic_id, t.topic_status, t.topic_type, t.topic_first_post_id, t.topic_last_post_id, t.topic_vote, p.post_id, p.poster_id" . $select_sql . " 
			FROM " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " .CATEGORIES_TABLE. " c, " . FORUMS_TABLE . " f" . $from_sql . " 
			WHERE p.post_id = $post_id 
				AND t.topic_id = p.topic_id 
				AND f.forum_id = p.forum_id
				AND f.cat_id = c.cat_id
				$where_sql";
//
// End of Category Title in Crumb Trail mod
//



# 
#-----[ FIND ]------------------------------------------ 
# 

	$forum_id = $post_info['forum_id'];
	$forum_name = $post_info['forum_name'];

# 
#-----[ AFTER, ADD ]---------------------------- 
# 
 
	// Category Title in Crumb Trail Mod...
	$cat_id = intval($post_info['cat_id']);
	$cat_name = $post_info['cat_title'];
	// End of Category Title in Crumb Trail Mod


# 
#-----[ FIND ]------------------------------------------ 
# 

$template->assign_vars(array(
	'FORUM_NAME' => $forum_name,

# 
#-----[ AFTER, ADD ]---------------------------- 
#  

	// Category Title in Crumb Trail Mod...
	'CATEGORY_NAME' => $cat_name,
	// End of Category Title in Crumb Trail Mod

# 
#-----[ FIND ]------------------------------------------ 
# 

	'U_VIEW_FORUM' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id"))

# 
#-----[ BEFORE, ADD ]---------------------------- 
#  

	// Category Title in Crumb Trail Mod...
	'U_VIEW_CATEGORY' => append_sid("index.$phpEx?c=$cat_id"),
	// End of Category Title in Crumb Trail Mod


# 
#-----[ OPEN ]------------------------------------------ 
# 
viewforum_body.tpl

# 
#-----[ FIND ]------------------------------------------ 
# NOTE: THERE ARE TWO OF THESE ROWS, one at the top of the page and one at the bottom...
 
<td align="left" valign="middle" class="nav" ><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a> -> <a class="nav" href="{U_VIEW_FORUM}">{FORUM_NAME}</a></span></td>

# 
#-----[ IN-LINE FIND ]---------------------------------- 
#  

<a href="{U_INDEX}" class="nav">{L_INDEX}</a> ->

# 
#-----[ IN-LINE AFTER, ADD ]---------------------------- 
#  

<a class="nav" href="{U_VIEW_CATEGORY}">{CATEGORY_NAME}</a> -> 


# 
#-----[ OPEN ]------------------------------------------ 
# 
viewtopic_body.tpl

# 
#-----[ FIND ]------------------------------------------ 
# NOTE: THERE ARE TWO OF THESE ROWS, one at the top of the page and one at the bottom...
 
	<td align="left" valign="middle" width="100%"><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a> 
	  -> <a href="{U_VIEW_FORUM}" class="nav">{FORUM_NAME}</a></span></td>

# 
#-----[ IN-LINE FIND ]---------------------------------- 
#  

	-> <a href="{U_VIEW_FORUM}" class="nav">{FORUM_NAME}</a></span></td>

# 
#-----[ IN-LINE BEFORE, ADD ]---------------------------- 
#  

	-> <a class="nav" href="{U_VIEW_CATEGORY}">{CATEGORY_NAME}</a>



# 
#-----[ OPEN ]------------------------------------------ 
# 
posting_body.tpl


# 
#-----[ FIND ]------------------------------------------ 
# 

	<!-- BEGIN switch_not_privmsg --> 
	 -> <a href="{U_VIEW_FORUM}" class="nav">{FORUM_NAME}</a></span></td>
	<!-- END switch_not_privmsg -->


# 
#-----[ IN-LINE FIND ]---------------------------------- 
#  

	 -> <a href="{U_VIEW_FORUM}" class="nav">{FORUM_NAME}</a></span></td>

# 
#-----[ IN-LINE BEFORE, ADD ]---------------------------- 
#  

	-> <a class="nav" href="{U_VIEW_CATEGORY}">{CATEGORY_NAME}</a>



# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM 
Last edited by Jimi D on Mon Sep 29, 2003 4:09 pm, edited 2 times in total.
Jimi D
Registered User
Posts: 19
Joined: Mon Sep 08, 2003 1:56 pm

Post by Jimi D »

And here is the (apparently) obligatory screen shot 8)

Image

This shot was taken from a Proof of Concept deployment of phpBB on my Laptop that doubles as my development environment. There are a few cosmetic differenct to the stock subSilver template, but the most glaring in terms of this mod is that the "New Topic" button is above the crumb trail - this is my own cosmetic change to make room for the LONG category and forum names we get on a "bilingual" board; applying the mod would not make this change to a site, so the crumb trail would still be between the "New Topic" button and "Mark all topics read".

As an aside, although Forum and Category Titles must be bilingual in my workplace, Topic Titles and posts can be in the user's language of choice. My board is bilingual and uses a language-dependant graphic in the top left corner (if the user wants to view the board en français, that graphic changes along with the button graphics). phpBB graphics and copyrights are at the bottom of the page (not seen) but sans links because we are an intranet deployment with no Internet access (security).
gurukast
Registered User
Posts: 230
Joined: Fri Aug 29, 2003 4:13 pm

Post by gurukast »

neat...will take a gander at it later...
Jimi D
Registered User
Posts: 19
Joined: Mon Sep 08, 2003 1:56 pm

Post by Jimi D »

New version up today. The changes are mostly in the way the SQL queries are implemented - I've incorporated them into the existing queries to reduce the Mod's overhead. Barring any surprises, I will submit this version for consideration in the MOD db in a week or so...
wGEric
Former Team Member
Posts: 8805
Joined: Sun Oct 13, 2002 3:01 am
Location: Friday
Name: Eric Faerber
Contact:

Post by wGEric »

Before you submit it, I have some things that you need to fix.

First off, could you use INLINE commands instead of all of those REPLACE WITHs? We will probably deny it if you leave it how you do now. Other MODs might edit those lines so using INLINEs won't affect the other MODS like replacing will.

Second, you need to get rid of all the --> They look like they aren't part of the code so EasyMOD will choke on those FINDs.

Thanks.
Eric
Jimi D
Registered User
Posts: 19
Joined: Mon Sep 08, 2003 1:56 pm

Post by Jimi D »

wGEric wrote: Before you submit it, I have some things that you need to fix.

First off, could you use INLINE commands instead of all of those REPLACE WITHs? We will probably deny it if you leave it how you do now. Other MODs might edit those lines so using INLINEs won't affect the other MODS like replacing will.

Second, you need to get rid of all the --> They look like they aren't part of the code so EasyMOD will choke on those FINDs.
Will do Eric... It never occured to me that using REPLACE WITH would mess up other people's mods (silly bunt! 8O )... I guess I'll have to change all the seperators in the crumb trail? The "->" seperator between the index and forum is the the bog-standard in subSilver, and that's why I'm using it - I guess we could change them all to ">>" or something, or would it be better if I just escape them in the html? Thanks for the input... :D
netclectic
Former Team Member
Posts: 4439
Joined: Wed Mar 13, 2002 3:08 pm
Location: Omnipresent
Contact:

Post by netclectic »

Cool, nice one. 8)

I'll make a point of referring to it in the next version of CIA.


I was just about to mentiuon using the IN-LINE commands instead of the REPLACE commands when i noticed wGEric had beaten me to it.
Defend the game:
Image
wGEric
Former Team Member
Posts: 8805
Joined: Sun Oct 13, 2002 3:01 am
Location: Friday
Name: Eric Faerber
Contact:

Post by wGEric »

Jimi D wrote: I guess I'll have to change all the seperators in the crumb trail? The "->" seperator between the index and forum is the the bog-standard in subSilver, and that's why I'm using it - I guess we could change them all to ">>" or something, or would it be better if I just escape them in the html? Thanks for the input... :D


Now I see what they are. I thought they were the ends of comments or you were pointing to that line. You don't have to change those. Sorry about that.
Eric
User avatar
Haywood Jahelpme
Registered User
Posts: 475
Joined: Wed Oct 23, 2002 9:16 am
Location: San Diego
Contact:

Post by Haywood Jahelpme »

Excellent Mod jimi! That is exactly what I needed... Thanks! Can you include instructions on bumping the New/Reply buttons to a new (higher) row (as you have demonstrated in your screen shot)? I think it would be much more asthetically pleasing to do that by default. If you want to see it in action, check out a topic in a hidden Cat.

Again, thanks!!! Nice work!

[and i agree, IN-LINE REPLACE is prefered]
User avatar
Agnostik
Registered User
Posts: 145
Joined: Sat Oct 12, 2002 2:07 pm
Contact:

Post by Agnostik »

!!!THANK YOU!!!

This is something that should be standard in the 2.2 release.
User avatar
Agnostik
Registered User
Posts: 145
Joined: Sat Oct 12, 2002 2:07 pm
Contact:

Post by Agnostik »

Doh! I'm getting this error:

Could not obtain topic information

DEBUG MODE

SQL Error : Column 'f.cat_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, c.cat_title, f.forum_name, f.forum_status, f.forum_id, f.cat_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, COUNT(p2.post_id) AS prev_posts FROM phpbb_topics t, phpbb_categories c,phpbb_forums f, phpbb_posts p, phpbb_posts p2 WHERE p.post_id = 14 AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= 14 AND f.forum_id = t.forum_id AND f.cat_id = c.cat_id GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC

Line : 165
File : c:\inetpub\wwwroot\forum\viewtopic.php
User avatar
Agnostik
Registered User
Posts: 145
Joined: Sat Oct 12, 2002 2:07 pm
Contact:

Post by Agnostik »

Thanks to a friend, the problem has been solved.

I may be mistaken, but I believe your code is missing an important element for when users click the "last post by" image/link on the Index and Viewforum pages. Otherwise, I get the debug error as stated above.

Here's the fix:

Code: Select all


# 
#-----[ OPEN ]------------------------------------------ 
# 
viewtopic.php 


# 
#-----[ FIND ]------------------------------------------ 
# 


$order_sql = ( empty($post_id) ) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC";


# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 

$order_sql = ( empty($post_id) ) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.cat_id, c.cat_title ORDER BY p.post_id ASC";


# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM
Jimi D
Registered User
Posts: 19
Joined: Mon Sep 08, 2003 1:56 pm

Post by Jimi D »

Agnostik

Are you using a mod that lets you sort the messages by last post? I don't have a "last post by" image/link on my site, and have had no problems with the mod (besides the fact I'm too buzy to put the instructions into an "IN-LINE REPLACE" format - there's a lot of work there!)... :) Anyway, I'd appreciate understanding what was killing it on your deployment, but I can't see the necessity of the code changes you suggest on my board...
User avatar
Agnostik
Registered User
Posts: 145
Joined: Sat Oct 12, 2002 2:07 pm
Contact:

Post by Agnostik »

Hmmm, well whenever I clicked on the little paper icon to go to the latest post on the Index or View Forum page, I got the above error. I DO have mods installed, but not sure any of them conflicted with this mod.

I am using a Windows machine and MS SQL however, and I noticed I am having GROUP BY problems with another MOD that others using MySQL are not. Perhaps the modification is only necessary for Windows/MS SQL users?
Post Reply

Return to “[2.0.x] MODs in Development”