[2.0.6] faq admin mod

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

Rating:

Excellent!
27
56%
Very Good
11
23%
Good
3
6%
Fair
4
8%
Poor
3
6%
 
Total votes: 48

Crazy Ducky
Registered User
Posts: 4
Joined: Wed Dec 15, 2004 1:41 am

Post by Crazy Ducky » Wed Dec 15, 2004 1:49 am

I don't get how the heck do I install it there is no install file to help me

dodgers
Registered User
Posts: 16
Joined: Sun Sep 14, 2003 3:14 pm

Post by dodgers » Mon Dec 20, 2004 11:12 pm

can someone help me please i have been trying to install this mod but when i goto my forum i get this error

Code: Select all

phpBB : Critical Error 

Could not query chat popup information 

DEBUG MODE 

SQL Error : 1146 Table 'DLS.PJIRC_TABLE' doesn't exist 

SELECT pjirc_value FROM PJIRC_TABLE WHERE pjirc_name='irc_popup_onoff' 

Line : 264 
File : /usr/local/psa/home/vhosts/herplover.co.uk/httpdocs/forum/includes/page_header.php  
i know there is a table missing but that's as far as my knowledge goes i have tryed to update the database with the db genorator on phpbbhacks.com but it is still the same ...this is line 258 - 280 of the page_header.php

Code: Select all

// PJIRC header link - pop-up or not? 
   $sql = "SELECT pjirc_value 
       FROM ".PJIRC_TABLE." 
       WHERE pjirc_name='irc_popup_onoff'"; 
   if( !($result = $db->sql_query($sql)) ) 
   { 
     message_die(CRITICAL_ERROR, "Could not query chat popup information", "", __LINE__, __FILE__, $sql); 
   } 
   while ($row = $db->sql_fetchrow($result)) { 
         $chatpopuponoff = $row['pjirc_value']; 
   } 

   if ( !$chatpopuponoff ) { 
      $chat_link = append_sid('chat.'.$phpEx); 
   } 
   else { 
      $chat_link = append_sid('chat.'.$phpEx)."\" onclick=\"window.open('".append_sid('chat.'.$phpEx)."', '_phpbbpjircpop', 'WIDTH=700,HEIGHT=508,resizable=yes,scrollbars=no');return false;\" target=\"_phpbbpjircpop\" onLoad=\"document.pjirc.focus();"; 
   }

//
// Obtain number of new private messages
// if user is logged in
//
thanks for any help Adam

dodgers
Registered User
Posts: 16
Joined: Sun Sep 14, 2003 3:14 pm

Post by dodgers » Mon Dec 20, 2004 11:14 pm

Crazy Ducky wrote: I don't get how the heck do I install it there is no install file to help me

you have to upload the install.mod then point ur browser to that file and it will come up

User avatar
wordeebird
Registered User
Posts: 141
Joined: Fri Dec 10, 2004 7:46 pm
Location: earth, most times
Contact:

I'm getting the language error, too!

Post by wordeebird » Tue Dec 28, 2004 8:34 pm

Help! I'm getting the same language error that TwinsDaily had... but does anyone know how to fix it?

zosostairwayth
Registered User
Posts: 14
Joined: Wed Dec 03, 2003 3:58 am

Post by zosostairwayth » Wed Dec 29, 2004 6:49 am

Man I need some help installing this, I am so PHP illiterate. I wish they made it for EMC. LOL

sutherlandandrew
Registered User
Posts: 7
Joined: Wed May 12, 2004 5:55 pm
Location: Kamloops BC Canada

Post by sutherlandandrew » Sat Jan 01, 2005 12:59 am

trend wrote:
Reling wrote:I have got this message. What is it?

Fatal error: Cannot redeclare get_info() in /home/pilieciu/public_html/forum/admin/admin_faq.php on line 69


same. someone?

omgs
Registered User
Posts: 3
Joined: Tue Jan 25, 2005 10:45 pm

More features

Post by omgs » Wed Jan 26, 2005 12:20 am

Because of my actual needs for a new forum (http://foros.escomposlinux.org), I'm starting to take the actual code of this mod and adapt it, which I'm not sure if are out of the scope so it's a different mod (I'd call if "Full_FAQ_MOD"), version 1.5.0 or version 2.0.0. Please somebody make like into this taking that what I'd like to add/change is:

- Better structure. Remove the limitation to phpBB FAQ and BBCode FAQ (just two "categories", and I'll call them like this from now on). Actually, there are two specific tables for every of these two categories, and I've simplified all this in three tables for unlimited categories. Every category (phpbb_faq_categories) keeps the lang field for every language, and has sections relationed (phpbb_faq_sections), also with a lang field for translation, and the last table, phpbb_faq_text, where is the text, apart from the lang field and the relationship with the section every question has. Also, extra fields per question with the question creator, creation date, last modified date and last modifier shouldn't be hard to implement to keep a minimal trace. History isn't a target, but could be handled.
- Maintain the place where the FAQs are placed, but offering a dropdown combo with all categories so one can choose what FAQ to view, regardless any default setting.
- Move the editing side away from admin panel. I find too rough to make somebody admin or moderator, and I think just _editing_ the text of any question shouldn't be done there, but in a similar way that an admin or a moderator can edit a post, that is, in the faq page itself.
- Less restrictive (custom?) permissions. I think FAQ texts are important enough to write and maintain so, apart from the forum specialization, if admins or moderators have to maintain and be aware of updates, it's a bottle neck, so at least have the chance to create an specific group at an specific minium level that can do the work. These people could only create and modify questions and answers, staying the ability for creating sections and categories for a higher level. Hopefully, these higher level shouldn't need to go to the admin panel for this.
- The admin panel still makes sense, for installing languages, initial imports, setting what users have editing access to the faqs. ACL for categories and sections is far now, but who knows :wink:

Next, I have a suggestion for phpBB team:

- I'd like to keep the languages in numbers instead of text for every ocurrence. I know this is because of the lang_<language> directory, but I think you could "standarize" a language list so there's a way to identify a language by using a unique lang_id in a phpbb_langs table, so every developer that needs to reference a language for any reason, can do it by this id (maybe the ab-CD lang code, instead). Who knows, this could lead to a phpbb_lang_text table containing the strings with their unique string_id, the lang code and the translation, being easier to supply consistent langpacks (and easily updatable). It's just an idea.

I'm not too expert at php at high levels, but I think that most basics described for multi faq suuport I can do them myself, surely this week (if I finally have enough time). I've read most of the docs and I think I could do it all myself, but in this case I don't know how long it could take, so any cooperation would be appreciated.

TIA

Nymala
Registered User
Posts: 8
Joined: Wed Aug 28, 2002 12:46 pm
Location: Delft, The Netherlands
Contact:

Post by Nymala » Mon Feb 21, 2005 3:02 pm

hiya @ all

after having installed it and (after much reading how to actually get the FAQ into the ACP) trying to use it, I have come across a little problem.

I call up the FAY ... select a section and want to change it but the moment I click on the hyperlink, I get the message
Template->make_filename(): Error - file does not exist


Can someone help me with that?

Secondly - how do I import other FAQs?
Apart from the Board FAQ and BBcode I also have one for a quiz and one for an auction.

thanks in advance

Nym
Hell was full - so they sent me back here!

zparta
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Re: Hello!

Post by zparta » Tue Mar 01, 2005 7:42 am

christop wrote:
ACherki wrote:I just came across one small thingie which annoys me very much with this mod.

I have installed it, no prob. I have created SQL tables in my DB, no prob - but when i try to get to Admin panel i find the following:

If the file admin_faq.php is in my admin folder - i got my left frame panel just blank.

If i remove it from admin folder - the frame panel apears.

And it concerns only this admin_faq.php file, the other one admin_faq_inst.php shows nicely and i have no problem with it. So can anyone make a guess what causes this trouble?

Thanks in advance for any help


I get this same thing. Love to know how to fix it. Sounds like this could be a cool mod.

the fix for this is to change the names of the function names in my admin_faq.php to something else
eg. add faq_ to the beginning of them and for every instance they are used in that file that fixed the problem for me

deepbluegeek
Registered User
Posts: 1
Joined: Thu Mar 03, 2005 12:43 am

Post by deepbluegeek » Thu Mar 03, 2005 2:11 am

If you're seeing the following error message:
Couldn't get list of Languages

DEBUG MODE

SQL Error : 1146 Table 'nation.phpbb_faq' doesn't exist

SELECT lang_id, count(faq_id) AS faq_count FROM phpbb_faq GROUP BY lang_id

Line : 177
File : /home/www/projet-civ.com/www/forum/admin/admin_faq.php


when in the mod it shows....

Code: Select all

includes/constants.php

# 
#-----[ FIND ]------------------------------------------ 
# 
?>

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
// START-faq_admin_mod
define('FAQ_TABLE', $table_prefix.'faq');
define('FAQ_TEXT_TABLE', $table_prefix.'faq_text');
define('POST_FAQ_LANG', 'l');
define('POST_FAQ_TYPE', 'type');
define('BBCODE_TABLE', $table_prefix.'bbcode');
define('BBCODE_TEXT_TABLE', $table_prefix.'bbcode_text');
// END-faq_admin_mod
change it to this.....

// START-faq_admin_mod
define('FAQ_TABLE', $table_prefix.'phpbb_faq');
define('FAQ_TEXT_TABLE', $table_prefix.'phpbb_faq_text');
define('POST_FAQ_LANG', 'l');
define('POST_FAQ_TYPE', 'type');
define('BBCODE_TABLE', $table_prefix.'phpbb_bbcode');
define('BBCODE_TEXT_TABLE', $table_prefix.'phpbb_bbcode_text');
// END-faq_admin_mod

MentalMaze
Registered User
Posts: 531
Joined: Sun Nov 23, 2003 8:22 am
Location: Seattle
Contact:

adding attach faq?

Post by MentalMaze » Wed Mar 30, 2005 4:36 pm

Hey Zparta,
I just installed this with the newest Cat-H with attach mod and it seemed to go fine. No errors :)

anyway....

I had to leave out this code modified by attach mod in the deleted section in faq.php:
//-- mod : attachmod -----------------------------------------------------------
//-- add
attach_faq_include($lang_file);
//-- fin mod : attachmod -------------------------------------------------------


I was not sure where I could replace it. I was wondering if there is an easy way to add the Attach Faq. Would it be easiest to just manually add it in the DB or can I simply add the previous line above back in somewhere and clean the DB tables and reload.

I ask first as I don't want to mess something up as it works. :)

Good work by the way. I like that it uses the DB.

Thanks

ekin_116
Registered User
Posts: 57
Joined: Mon Sep 15, 2003 8:48 am
Location: Philippines
Contact:

Post by ekin_116 » Sun Apr 17, 2005 3:31 pm

Code: Select all

Fatal error: Cannot redeclare get_lang_list() in /home2/method7/public_html/phpbb/admin/admin_faq_inst.php on line 52
the error code let me can't see the left portion of the admin control panel,
and if i delete the admin_faq.php the left portion of the admin control panel got back.
can anyone help me with this error?!

This error just appear to me on the online server,
on my local server it works fine!!!

PS:
PHP version 4.3.10
MySQL version 4.0.23-standard
Apache version 1.3.33 (Unix)
phpBB version 2.0.13

mjatas
Registered User
Posts: 270
Joined: Sat Oct 16, 2004 6:43 am
Contact:

Post by mjatas » Tue Apr 19, 2005 3:50 pm

I am sorry if this was mentioned before, but when I try to go into FAQ admin or BBcode admin I get this message.

Template->make_filename(): Error - file admin/admin_faq.tpl does not exist

what do I do?
Ontario Wedding Forum
Over 500 users now online!
http://www.mystic-m.com/forum

mjatas
Registered User
Posts: 270
Joined: Sat Oct 16, 2004 6:43 am
Contact:

Post by mjatas » Tue Apr 19, 2005 3:52 pm

now it says

Couldn't get list of Languages

DEBUG MODE

SQL Error : 1146 Table 'forum_michaeljatas_ca.FAQ_TABLE' doesn't exist

SELECT lang_id, count(faq_id) AS faq_count FROM FAQ_TABLE GROUP BY lang_id

Line : 177
File : admin_faq.php
Ontario Wedding Forum
Over 500 users now online!
http://www.mystic-m.com/forum

mjatas
Registered User
Posts: 270
Joined: Sat Oct 16, 2004 6:43 am
Contact:

Post by mjatas » Tue Apr 19, 2005 4:14 pm

sorry found it

If you're seeing the following error message:
Quote:
Couldn't get list of Languages

DEBUG MODE

SQL Error : 1146 Table 'nation.phpbb_faq' doesn't exist

SELECT lang_id, count(faq_id) AS faq_count FROM phpbb_faq GROUP BY lang_id

Line : 177
File : /home/www/projet-civ.com/www/forum/admin/admin_faq.php


when in the mod it shows....

Code:
includes/constants.php

#
#-----[ FIND ]------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// START-faq_admin_mod
define('FAQ_TABLE', $table_prefix.'faq');
define('FAQ_TEXT_TABLE', $table_prefix.'faq_text');
define('POST_FAQ_LANG', 'l');
define('POST_FAQ_TYPE', 'type');
define('BBCODE_TABLE', $table_prefix.'bbcode');
define('BBCODE_TEXT_TABLE', $table_prefix.'bbcode_text');
// END-faq_admin_mod


change it to this.....

// START-faq_admin_mod
define('FAQ_TABLE', $table_prefix.'phpbb_faq');
define('FAQ_TEXT_TABLE', $table_prefix.'phpbb_faq_text');
define('POST_FAQ_LANG', 'l');
define('POST_FAQ_TYPE', 'type');
define('BBCODE_TABLE', $table_prefix.'phpbb_bbcode');
define('BBCODE_TEXT_TABLE', $table_prefix.'phpbb_bbcode_text');
// END-faq_admin_mod
Ontario Wedding Forum
Over 500 users now online!
http://www.mystic-m.com/forum

Post Reply

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