FAQ Edit v3

I have made some modifications to the hack by Stasik, which is located here.
New features:

• Edit display order from the list of questions/groups
• Got the display code into templates and out of misc.php
• Removed some extra queries
• Added support for vB Code and fixed support for smilies
• Various small cosmetic/coding fixes

The base hack is © 2001 by Stasik.
Portions, including the installer, are © 2001 Kevin Schumacher.
Portions of the installer were created by Bane.
The hack and its' installer may not be redistributed, edited or not, without this copyright notice attached.

For version: 2.0.3

Files needed: faq_install.php, faq.php

Files to edit: admin/index.php, root/misc.php

Templates to edit: None.

Instructions: Upload and run faq_install.php from your admin directory. Follow the on-screen directions.

Upgrading from Stasik's hack: Upload and run faq_install.php from your admin directory and choose the option to upgrade from v2 of the hack.

Upgrading from a previous version of *this* hack (e.g. from this thread): Upload and run faq_install.php from your admin directory and choose the option to upgrade from "v3, v31, or v32" of the hack.

Please DO NOT contact me via PM, IM, email, or otherwise outside this thread about this hack.

Thanks to Stasik for the great hack!

[webhost]

I had a question that I wanted to edit, adding a link to the right of the question so I did but when I did that I put in " when I shouldn't have,I noticed it after I saved the question in the control panel faq section where you see questions you have installed, so I tried to edit it to take this out "
When I selected edit it took me to a blank page, so I said I will go into database and just modify that field for the question and take that out, The table for the questions will let you edit the answer but not the question, so I ended up deleting that question and answer and putting them in again. So there is a bug somewhere and also we need to be able to modify title/question field in database.

[tubedogg]

I'm still not sure what the problem is. I just tried adding and then editing a question with multiple " in it and it worked fine...?

[tubedogg]

I've added support for vB Code if you want to use it. Select your option for each entry on the Add or Edit screen. All entries are set to use HTML for now, since the original entries put in your database when installing previous versions of this hack had HTML in them.

Updated zip file is in the first post. There are three upgrade paths, a new installation path, and an uninstallation path:
To Upgrade from Stasik's version of the hack, follow the link to upgrade from v2.
To Upgrade from a previous version of *my* hack, e.g. you got it from this thread, follow the link to upgrade from v3, v31, or v32 (it's all the same link).
To just see the file changes (if you are upgrading vB itself) follow the link for upgrading from a previous version of vB.

[floleb7]

Warning: Cannot add header information - headers already sent by (output started at f:\latriade\site\forum_test\upload\admin\adminfunc tions.php:18) in f:\latriade\site\forum_test\upload\admin\faq.php on line 281

when i try to add a question

[tubedogg]

Fixed. Download the zip and reupload faq.php. Don't run faq_install.php again.

[floleb7]

little bug

in faq.php search dobbcode (8 to find) replace by dovbcode

[tubedogg]

Actually, no, it's supposed to be dobbcode. If you replace it with dovbcode it won't work I guarantee it.

[floleb7]

so there is a prob my table is dovbcode
and in faq_install i got this

// ######################################## STEP 3 # install SQL
if ($step==3) {
echo("<b>Creating/Altering Tables</b><br><br>");

$DB_site->query('create table faqentries (
entryid int(10) not null auto_increment,
faqid int(10) not null,
title blob not null,
text mediumtext not null,
showorder int(10) not null,
dohtml smallint(6) not null DEFAULT 0,
dovbcode smallint(6) not null DEFAULT 0,
dosmilies smallint(6) not null DEFAULT 0,
primary key (entryid))');
echo('FAQ`s entries table has been successfully created.<br>');

[webhost]

well here is a problem I have now, I have upgraded and now I can not edit any of my existing questions I get this error on all of them.
Also I have code showing up in all of my questions what has happened with this thing?


There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin Control Panel: Invalid SQL: SELECT title,text,dohtml,dobbcode,dosmilies FROM faqentries WHERE entryid='2'
mysql error: Unknown column 'dohtml' in 'field list'
mysql error number: 1054
Date: Monday 10th of September 2001 03:32:37 PM
Script: /admin/faq.php?action=editquestion&questionid=2&faqid=1
Referer: http://forums.realwebhost.net/admin/...odify&expand=1

[tubedogg]

OK floleb run this query:
ALTER TABLE faqentries CHANGE dovbcode dobbcode smallint(6) NOT NULL DEFAULT '0';

Webhost: What did you click on when you ran the installer again? Cause whatever you did you skipped the step where it alters your database...