[2.0.6] Topic Description MOD

The cleanup is complete. This forum is now read only.

Rating:

Excellent!
32
47%
Very Good
17
25%
Good
5
7%
Fair
4
6%
Poor
10
15%
 
Total votes: 68

mistnlove
Registered User
Posts: 63
Joined: Sat Oct 22, 2005 1:00 am

Post by mistnlove »

I tried installing this mod with easymod and received this error

Code: Select all

SQL ERROR 
  
SQL PROCESSING HALTED

An error was encountered while processing the SQL commands. Further SQL processing has been halted. You may choose to complete the MOD installation anyway and perform the SQL commands manually yourself. However, at this point EM cannot guarantee the MOD will work correctly so you are best off seeking support from the Author before continuing further.

The failed line was:
ALTER TABLE phpbb_topics ADD topic_description VARCHAR(60) NULL DEFAULT NULL;;
 

SQL ERROR: 1060
Duplicate column name 'topic_description' 

The following SQL was attempted: Allow 
   ALTER TABLE phpbb_topics ADD topic_description VARCHAR(60) NULL DEFAULT NULL;;
 
Any thoughts?
FaKeOnE-rSe
Registered User
Posts: 31
Joined: Wed Jul 27, 2005 7:49 am
Location: Greece, Thessaloniki
Contact:

Post by FaKeOnE-rSe »

seems like there is noone active to support this MOD here..
I asked for help too and noone responded :(
User avatar
GulRanek
Registered User
Posts: 211
Joined: Wed Jul 12, 2006 11:49 am
Location: Rijeka, Croatia
Contact:

Post by GulRanek »

I installed this mod without much problem. But - the topic descriptions aren't shown in viewforum.php. Can someone take a look at my viewforum.php.txt?

I've checked the test post to which I added the description and it's still there, so the problem isn't in the database but in the way the description should be displayed.
TheEkim
Registered User
Posts: 16
Joined: Thu Nov 30, 2006 9:37 pm

Installed mod- Cant post now

Post by TheEkim »

Hi, I just installed this mod on an already heavily modded forum. I used easy mod for most of the installation and it only encountered an error editing the posting.php file. I edited the posting.php file by hand.
Now the topic descriptions are working in forum perfectly but i cannot post or reply to messages. I get a blank white screen. I can view messages and see the descriptions and tooltips and PM's are working fine.
I tried going to back to the backup of posting.php but even after uploading this I still cant post. I tried re-editing that file from the base with mod but mod still isnt functioning and i dont even know how to uninstall this mod or get back to a stable version of my forum.
Any help or insights would be greatly appreciated.
Affected forum- poker forum site
Thanks
Ekim
TheEkim
Registered User
Posts: 16
Joined: Thu Nov 30, 2006 9:37 pm

All is well that ends well

Post by TheEkim »

Forum is functioning perfectly. Had to reload backups and try a second time but apparently did something um righter.... cause its working perfectly now.

Great Mod!

Thanks
Ekim
SkillinBizkit
Registered User
Posts: 41
Joined: Thu Dec 07, 2006 3:30 am

Post by SkillinBizkit »

My Desciption is next to the topic not under it, how do i fix it?
Sgt.Taichi[JP]
Registered User
Posts: 15
Joined: Sat Jan 27, 2007 11:27 pm

Post by Sgt.Taichi[JP] »

Excellent mod!

Is there any way to add the topic description to view topic? I've tried modifying viewtopic_body.tpl but couldn't get the description to show.

Thanks.
SkillinBizkit
Registered User
Posts: 41
Joined: Thu Dec 07, 2006 3:30 am

Post by SkillinBizkit »

Sgt, does your topic description appear next to the topic title or underneath?
SeanBrockest
Registered User
Posts: 43
Joined: Thu Oct 26, 2006 11:38 pm

Post by SeanBrockest »

Seems to be a lot of problems in this thread. If i use this with the latest version of PHPBB, and Easymod 0.3.0, what are the chances it wont mess up?

Are there other versions of this mod around?
User avatar
Sr X
Registered User
Posts: 202
Joined: Wed Feb 07, 2007 9:25 am

Post by Sr X »

how could the Search to find the result to this description mod?
is morpheus2matrix author of this mod working in this mod too?
murnauvsbuñuel
Registered User
Posts: 177
Joined: Mon Jun 20, 2005 9:49 am

Post by murnauvsbuñuel »

how to include the topic description in the search results? to make it part of the search criteria
murnauvsbuñuel
Registered User
Posts: 177
Joined: Mon Jun 20, 2005 9:49 am

Post by murnauvsbuñuel »

i dont want show the emoticons, how i can do this?

Image

Edit: solved
morpheus2matrix wrote: yes, in viewforum.php, find

Code: Select all

if ( !empty($topic_rowset[$i]['topic_desc']))
                {
                    $topic_desc = $topic_rowset[$i]['topic_desc'];
                    $template->assign_block_vars('topicrow.switch_topic_desc', array(
                               'TOPIC_DESCRIPTION' => smilies_pass($topic_desc))
                    );
                }
replace with

Code: Select all

if ( !empty($topic_rowset[$i]['topic_desc']))
                {
                    $topic_desc = $topic_rowset[$i]['topic_desc'];
                    $template->assign_block_vars('topicrow.switch_topic_desc', array(
                               'TOPIC_DESCRIPTION' => $topic_desc)
                    );
                }

Code: Select all

and dont put this:
include_once($phpbb_root_path . 'includes/bbcode.'.$phpEx);

thanks morpheus2matrix, where are you from? how are you?
Last edited by murnauvsbuñuel on Tue Feb 27, 2007 8:27 am, edited 2 times in total.
murnauvsbuñuel
Registered User
Posts: 177
Joined: Mon Jun 20, 2005 9:49 am

Post by murnauvsbuñuel »

Here's how to include the topic description in the search results

Code: Select all

OPEN
search.php
FIND
			$topic_id = $searchset[$i]['topic_id'];
AFTER, ADD
			$topic_desc = $searchset[$i]['topic_desc'];
			
			
FIND
					'TOPIC_TITLE' => $topic_title,
AFTER, ADD
					'TOPIC_DESC' => $topic_desc,
					
FIND
					'TOPIC_TITLE' => $topic_title,
AFTER, ADD
					'TOPIC_DESC' => ( $topic_desc != '' ) ? '<br />' . $topic_desc : '',
					
					
OPEN
templates/subSilver/search_results_topics.tpl

FIND															
<td class="row2"><span class="topictitle">{searchresults.NEWEST_POST_IMG}{searchresults.TOPIC_TYPE}<a href="{searchresults.U_VIEW_TOPIC}" class="topictitle">{searchresults.TOPIC_TITLE}</a></span>
AFTER, ADD
<span class="gensmall">{searchresults.TOPIC_DESC}</span>
These changes only includes the topic description in the search display, it does not make it part of the search criteria.

Idea came from Here
User avatar
GulRanek
Registered User
Posts: 211
Joined: Wed Jul 12, 2006 11:49 am
Location: Rijeka, Croatia
Contact:

Post by GulRanek »

I installed this mod months ago and it works perfectly.

Recently, an idea came to my mind - a lot of my forum members actually navigate the forum using the New Posts Since Last Visit function.

Can someone help me and tell me how to incorporate the topic descriptions in search.php?
murnauvsbuñuel
Registered User
Posts: 177
Joined: Mon Jun 20, 2005 9:49 am

Post by murnauvsbuñuel »

GulRanek wrote: I installed this mod months ago and it works perfectly.

Recently, an idea came to my mind - a lot of my forum members actually navigate the forum using the New Posts Since Last Visit function.

Can someone help me and tell me how to incorporate the topic descriptions in search.php?

ainsss :evil: yes GulRanek, you can watch this addon in my previous post
sorry for my bad english i am spanish.
ImagemxBB Portal the best portal to phpBB2
Post Reply

Return to “[2.0.x] MOD Database Cleanup”