[ABD] Featured Topic Mod 0.2.0

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
Adrian1
Registered User
Posts: 630
Joined: Tue Jul 15, 2008 11:21 am
Contact:

[ABD] Featured Topic Mod 0.2.0

Post by Adrian1 »

Modification Name: Featured Topic Mod
Author: Adrian1

Modification Description: A Featured Topic Mod for phpbb3
Modification Version: [BETA] 0.2.0

Requirements:
  • phpBB 3.0.x
Features:
Allow you to set topics as fetured and display them on the main index.
Created by request of http://www.phpbb.com/community/viewtopi ... &t=1637325

Screenshot:
Image
Image

Image

Modification Download: http://www.phpbbmods.org/viewtopic.php?f=9&t=14
Last edited by Adrian1 on Tue Aug 09, 2011 10:44 pm, edited 5 times in total.
RPG MOD for phpbb3
User avatar
Jessica
Former Team Member
Posts: 4342
Joined: Sun Jul 18, 2010 2:53 pm
Location: Pennsylvania, USA
Name: Jessica
Contact:

Re: [BETA] Featured Topic Mod 0.1.0

Post by Jessica »

you should fix the description, because it's not a RPG mod :P just saying
Pro-choice, Atheist, Pro-LGBT rights
Everybody is a genius. But if you judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid. - Albert Einstein
Adrian1
Registered User
Posts: 630
Joined: Tue Jul 15, 2008 11:21 am
Contact:

Re: [BETA] Featured Topic Mod 0.1.0

Post by Adrian1 »

jesschen wrote:you should fix the description, because it's not a RPG mod :P just saying
OMG, how can i have forget to do that?!
Thanks!
RPG MOD for phpbb3
0dd0ne
Registered User
Posts: 123
Joined: Thu Aug 14, 2008 1:27 pm

Re: [BETA] Featured Topic Mod 0.1.0

Post by 0dd0ne »

Sounds like a good mod idea, especially seeing it was a hit on phpbb2. Is there a demo or screenshot? :)
Adrian1
Registered User
Posts: 630
Joined: Tue Jul 15, 2008 11:21 am
Contact:

Re: [BETA] Featured Topic Mod 0.1.0

Post by Adrian1 »

0dd0ne wrote:Sounds like a good mod idea, especially seeing it was a hit on phpbb2. Is there a demo or screenshot? :)
I will add some screenshot because i am to lazy to setup up a demo :)
RPG MOD for phpbb3
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21284
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: [BETA] Featured Topic Mod 0.1.0

Post by RMcGirr83 »

Code: Select all

$forum = 'SELECT forum_name FROM ' . FORUMS_TABLE . ' 
            WHERE forum_id = '.$topics_row['forum_id'];
$resultf = $db->sql_query($forum);
$forum_name  = $db->sql_fetchfield('forum_name');
$db->sql_freeresult($resultf);
$db->sql_freeresult($resultf);
query in loop (choosing 5 topics in ACP will generate 6 sql queries...better to do a left join on the forums table) and you are freeresulting twice.
Appreciate the extensions/mods/support then buy me a beer Image
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions | My extensions are updated regularly on github
All requests for support via PM will be ignored
Adrian1
Registered User
Posts: 630
Joined: Tue Jul 15, 2008 11:21 am
Contact:

Re: [BETA] Featured Topic Mod 0.1.0

Post by Adrian1 »

RMcGirr83 wrote:

Code: Select all

$forum = 'SELECT forum_name FROM ' . FORUMS_TABLE . ' 
            WHERE forum_id = '.$topics_row['forum_id'];
$resultf = $db->sql_query($forum);
$forum_name  = $db->sql_fetchfield('forum_name');
$db->sql_freeresult($resultf);
$db->sql_freeresult($resultf);
query in loop (choosing 5 topics in ACP will generate 6 sql queries...better to do a left join on the forums table) and you are freeresulting twice.
Thank you for suggstion, i will change that today.

Also i have added the scrrenshots.
RPG MOD for phpbb3
Adrian1
Registered User
Posts: 630
Joined: Tue Jul 15, 2008 11:21 am
Contact:

Re: [BETA] Featured Topic Mod 0.1.1

Post by Adrian1 »

Mod Updated to 0.1.1, thanks to RMcGirr83 for suggestion.
RPG MOD for phpbb3
0dd0ne
Registered User
Posts: 123
Joined: Thu Aug 14, 2008 1:27 pm

Re: [BETA] Featured Topic Mod 0.1.1

Post by 0dd0ne »

Thanks for posting the screenshots! I plan to use it on the main page of my site rather than the forum index, hopefully this won't oppose too many problems?!:) Thanks for creating this onwards with notepad++ ;)
0dd0ne
Registered User
Posts: 123
Joined: Thu Aug 14, 2008 1:27 pm

Re: [BETA] Featured Topic Mod 0.1.1

Post by 0dd0ne »

I get this error when running the install file:
Featured Topic Mod
PHP Version: 5.2.14
DBMS: MySQL 5.0.92-community
phpBB3 Version: 3.0.4

Adding a new column named topic_featured to table TOPICS_TABLE
SQL ERROR Table 'XXXXXXXXX.TOPICS_TABLE' doesn't exist
(XXXXXXXXX = my site's account name)

I had a look in phpMyAdmin, and it's right I can't find TOPICS_TABLE. What's the best way to create it?

Thanks! :D
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21284
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: [BETA] Featured Topic Mod 0.1.1

Post by RMcGirr83 »

[SNIP] see below
Appreciate the extensions/mods/support then buy me a beer Image
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions | My extensions are updated regularly on github
All requests for support via PM will be ignored
0dd0ne
Registered User
Posts: 123
Joined: Thu Aug 14, 2008 1:27 pm

Re: [BETA] Featured Topic Mod 0.1.1

Post by 0dd0ne »

RMcGirr83 wrote:It means the edits to the constants.php file are missing.
Thanks for the reply. :)

constants.php hasn't been changed afaik, there's nothing within the featured topics instructions to edit that file. I must be missing something just not sure what. :? Any help appreciated. :D
0dd0ne
Registered User
Posts: 123
Joined: Thu Aug 14, 2008 1:27 pm

Re: [BETA] Featured Topic Mod 0.1.1

Post by 0dd0ne »

Just as a follow up, I've looked inside my constants.php file and this is the only line I can see relating to TOPICS_TABLE

Code: Select all

define('TOPICS_TABLE',				$table_prefix . 'topics');
I'm guessing this is how it's meant to be? :idea:
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21284
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: [BETA] Featured Topic Mod 0.1.1

Post by RMcGirr83 »

Open the topic_feature_install.php file and change this

array('TOPICS_TABLE', 'topic_featured', array('BOOL', '0')),

to this

array('phpbb_topics', 'topic_featured', array('BOOL', '0')),
Appreciate the extensions/mods/support then buy me a beer Image
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions | My extensions are updated regularly on github
All requests for support via PM will be ignored
0dd0ne
Registered User
Posts: 123
Joined: Thu Aug 14, 2008 1:27 pm

Re: [BETA] Featured Topic Mod 0.1.1

Post by 0dd0ne »

Absolutely spot on, and working 100% fine!

I really appreciate the help! Thanks :D
Locked

Return to “[3.0.x] Abandoned MODs”