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!

[floleb7]

i change the table name before my post but you need to look faq_install.php

[webhost]

I selected upgrade 3 3.1 32 and I checked and all new fields are in my database
I tried to run install again and I get this

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: ALTER TABLE faq ADD dohtml smallint(6) NOT NULL DEFAULT '0'
mysql error: Duplicate column name 'dohtml'
mysql error number: 1060
Date: Monday 10th of September 2001 03:56:59 PM
Script: /admin/faq_install.php?s=&step=32
Referer: http://forums.realwebhost.net/admin/faq_install.php

[tubedogg]

They are in your database? Then something else is wrong...cause if your database was altered and you are using the newest faq.php there is something wrong that it's not finding your column...but it works for me.

[webhost]

Yea I agree there is something wrong. So what is it?

faqid int(10) No auto_increment Change Drop Primary Index Unique
title blob No Change Drop Primary Index Unique
showorder int(10) No 0 Change Drop Primary Index Unique
dohtml smallint(6) No 0 Change Drop Primary Index Unique
dobbcode smallint(6) No 0 Change Drop Primary Index Unique
dosmilies smallint(6) No 0 Change Drop Primary Index Unique

[tubedogg]

I have no idea, seeing as it works for me and the column exists in your database...try uninstalling and doing a clean install (you don't have to remove file changes, just the database stuff, via the Uninstall link in the script).

[webhost]

OK I uninstalled and reinstalled and I get the same error as above.

[tubedogg]

Then there is something wrong with your server. It works *perfectly* for me.

[webhost]

ok Tubedogg here goes first I had to change the dohtml field from smallint to int, then I got a error said that it could find dobbcode the field in database was called dovbcode that is what the script setup there, so I changed it to dobbcode and changed to int, now all works except my questions look like this

In order to fully utilise the abilitites of this board, the administrator will probably require that you register as a member. Registration is free, and allows you to do the following:
<ul>
<li>Post new threads</li>
<li>Reply to other peoples' threads</li>
<li>Edit your posts</li>
<li>Receive email notification of replies to posts and threads you specify</li>
<li>Send private messages to other members</li>
<li>Enter events in the board calendar</li>
<li>Set up a 'buddy-list' to quickly see which of your friends are currently online</li>
</ul>
To register, you will need to specify a username and password, and a valid email address. Entering your email address will not leave you open to 'spam', as you can choose to hide your email address, and messages sent to you via email do not reveal your address to the sender in any case. (To verify this, you can try sending an email message to <a href="memberlist.php?s=">another user</a>.) The administrator may have configured the board to send you the final part of the registration process by email, so ensure that the email address you provide is valid and working.
If you are under the age of 13, the administrator may require that a parent or guardian provides consent before allowing you to complete the registration process. More information about this is available during the registration process.

[webhost]

Tubedogg any ideas on this?

[floleb7]

same problem