FAQ Edit v3

[tubedogg]

I have made some modifications to the hack by Stasik, which is located here (http://www.vbulletin.com/forum/showthread.php?threadid=27713).
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 fixesThe 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]

problem in your faq_install

step 4

admin/index.php

Find:

>a href="bbcode.php?s=>?php echo $session[sessionhash]; ?>&action=modify"> Modify >/a<>br< >/td<>/tr<

Just under that add:

>!-- FAQ addon --<
>tr<>td<
>table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable"<
>?php maketableheader("FAQs"); ?<
>/table<
>a href="faq.php?s=>?php echo $session[sessionhash]; ?<&action=modify"< Edit>/a< |
>a href="faq.php?s=>?php echo $session[sessionhash]; ?<&action=addfaq"< Add>/a<
>/td<>/tr<
>!-- /FAQ addon --<

[tubedogg]

Fixed.

I also added an upgrade path from v2 of the hack (Stasik's version).

[webhost]

Couple of comments Tubedogg, first when upgrading my board from version 2, I had to comment out the parts in step2 and step21 about deleting the tables, it would not run until I did this.
Second below for upgrades we have the bottom part of code installed not what you show. so you need to change that in your script. Lastly if it can be done we need to be able to use the vb code in this if possible. I have it upgraded and running after doing the above.

Your instructions for Misc.php replacement


if ($action=="faq") {
$templatesused = ""; // Only one template used so load it when called
include("./global.php");
$page = intval($page);
if (!$page)
$page = '';
eval("dooutput(\"".gettemplate("faq$page")."\");");

}
This is what is actually in a version 2 misc.php file so I replaced it all with what you said put in.



But we have this installed from Version 2 of the hack


if ($action=="faq") {
$templatesused = ""; // Only one template used so load it when called
include("./global.php");
if(isset($page)){$sql = "WHERE faqid='$page'";}
$query = "SELECT faqid,title FROM faq $sql ORDER BY showorder";
$faqs=$DB_site->query($query);
while ($faq=$DB_site->fetch_array($faqs)) {
if (isset($page)){$title = " &gt; <a href=\"misc.php?s=$session[sessionhash]&action=faq&page=$faq[faqid]\">$faq[title]</a>";}
$faqbody .= "<br>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" bgcolor=\"#555576\" width=\"100%\" align=\"center\"><tr><td>
<table cellpadding=\"4\" cellspacing=\"1\" border=\"0\" width=\"100%\">
<tr id=\"cat\">
<td bgcolor=\"#606096\"><a href=\"misc.php?s=$session[sessionhash]&action=faq&page=$faq[faqid]\"><normalfont color=\"#FFF788\"><b>$faq[title]</b></normalfont></a></td>
</tr>
<tr>
<td bgcolor=\"#F1F1F1\"><normalfont>
<ul>";
$questions=$DB_site->query("SELECT entryid,title,faqid FROM faqentries WHERE faqid='$faq[faqid]' ORDER BY showorder");
while ($question=$DB_site->fetch_array($questions)) {
$faqbody .= "<li><a href=\"misc.php?s=$session[sessionhash]&action=faq&page=$question[faqid]#$question[entryid]\">$question[title]</a></li>\n";
}
$faqbody .= " </ul>
</normalfont></td>
</tr>
</table>
</td></tr></table>";
}
if (isset($page)) {
$entries=$DB_site->query("SELECT entryid,title,text FROM faqentries WHERE faqid='$page' ORDER BY showorder");
while($entry=$DB_site->fetch_array($entries)){
$faqbody .= "
<br>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" bgcolor=\"#555576\" width=\"100%\" align=\"center\"><tr><td>
<table cellpadding=\"4\" cellspacing=\"1\" border=\"0\" width=\"100%\">
<tr>
<td bgcolor=\"#606096\" id=\"cat\"><normalfont color=\"#FFF788\"><b><a name=\"$entry[entryid]\"></a>
$entry[title]
</b></normalfont></td>
</tr>
<tr>
<td bgcolor=\"#F1F1F1\"><normalfont>
$entry[text]
</normalfont></td>
</tr>
</table>
</td></tr></table>";
}

}
eval("dooutput(\"".gettemplate("faq")."\");");
}

[the_sisko]

Nice job (everyone of you)!!!

I tested it on my lokal machine and will start translate it into german for my board tomorrow!!!

Thanks alot

[Ruth]

this is a must-have hack,

Thanks everyone !

[tubedogg]

Webhost: You should not have been running step 2 if you were upgrading. :eek: That will uninstall my version of the hack, not Stasik's.
As for step 21 I believe there was an error in the SQL so I have changed that (and changed the step number to step==31).

I have fixed the misc.php issue you mentioned and added a step specifically for upgrading (step==41).

I also fixed a couple other minor issues.

I will add support for vB code if possible later today.

[webhost]

ok great the only reason I ran step 2 was on a test site to see if had a sql problem also, I finally like I said just commented out the delete stuff and step 21 ran fine except for the misc.php stuff. We appreicate you picking up on this and helping.
One problem I ran into today just to let you know is the following.

I was changing the title around on a question adding a link to it and put in one of these that I shouldn't -- "--
I tried to go back and edit and it gave me just a blank page, so finally I went to database to edit it there because I knew what the problem was. Well in the database you can edit the answer but not the question so you may want to change this because I finally had to delete question/answer and do over, if we were capable of editing question in database we wouldn't have to do that.

[Matt*is*thick]

Is it me or is there no step 5? When I was running the install I had to manually change 5 to 6 so that I could reach the final step.

[tubedogg]

webhost: I'm not really sure what you're saying. Could you explain it again?

Matt: I noticed that right before I uploaded the newest version. Sorry. :(

[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/faq.php?action=modify&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...

[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

[tubedogg]

I don't know what you guys are doing but I just uninstalled the hack completely and reinstalled it and it works perfectly, including the final look of the FAQ pages.

Run the query
UPDATE faqentries SET html=1;
and it should fix the exposed HTML...

[webhost]

all dohtml and all dobbcode set to 1 same problem still looks the same. same bug, maybe you should post exactly what goes in misc.php and where, see if has something to do with it, I did this right, All worked before I did the last upgrade, now it doesn't/

[tubedogg]

It should exactly like this:

if ($action=="faq") {
$templatesused = "faq_title,faq_head,faq_entry";
include("./global.php");

if(isset($page)){$sql = "WHERE faqid='$page'";}
$query = "SELECT faqid,title FROM faq $sql ORDER BY showorder";
$faqs=$DB_site->query($query);
while ($faq=$DB_site->fetch_array($faqs)) {
if (isset($page))
{$title = " &gt; <a href='misc.php?s=$session[sessionhash]&action=faq&page=$faq[faqid]'>$faq[title]</a>";
}
$questions=$DB_site->query("SELECT entryid,title,faqid FROM faqentries WHERE faqid='$faq[faqid]' ORDER BY showorder");
while ($question=$DB_site->fetch_array($questions)) {
eval ("\$faqtitles .= \"".gettemplate("faq_title")."\";");
}
eval ("\$faqhead .= \"".gettemplate("faq_head")."\";");
unset ($faqtitles);
}
if (isset($page)) {
$entries=$DB_site->query("SELECT entryid,title,text,dohtml,dobbcode,dosmilies FROM faqentries WHERE faqid='$page' ORDER BY showorder");
while($entry=$DB_site->fetch_array($entries)){
$entry[text] = bbcodeparse2($entry[text],$entry[dohtml],$entry[dobbcode],$entry[dosmilies],$entry[dobbcode]);
eval ("\$faqentries .= \"".gettemplate("faq_entry")."\";");
}
}
eval("dooutput(\"".gettemplate("faq")."\");");
}

[webhost]

Ok mind was the same, I also downloaded the faq.php file again still get the same. Maybe it is something in the templates. you can post those and I will compare them that is all that is left.

[tubedogg]

faq_entry:
<br>
<table cellpadding="{tableouterborderwidth}" cellspacing="0" border="0" bgcolor="{tablebordercolor}" {tableouterextra} width="{contenttablewidth}" align="center"><tr><td>
<table cellpadding="4" cellspacing="{tableinnerborderwidth}" border="0" {tableinnerextra} width="100%">
<tr>
<td bgcolor="{categorybackcolor}" id="cat"><normalfont color="{categoryfontcolor}"><b><a name="$entry[entryid]"></a>
$entry[title]
</b></normalfont></td>
</tr>
<tr>
<td bgcolor="{firstaltcolor}"><normalfont>
$entry[text]
</normalfont></td>
</tr>
</table>
</td></tr></table>

faq_head
<br>
<table cellpadding="{tableouterborderwidth}" cellspacing="0" border="0" bgcolor="{tablebordercolor}" {tableouterextra} width="{contenttablewidth}" align="center">
<tr><td><table cellpadding="4" cellspacing="{tableinnerborderwidth}" border="0" {tableinnerextra} width="100%">
<tr id="cat">
<td bgcolor="{categorybackcolor}"><a href="misc.php?s=$session[sessionhash]&action=faq&page=$faq[faqid]"><normalfont color="{categoryfontcolor}"><b>$faq[title]</b></normalfont></a></td>
</tr>
<tr>
<td bgcolor="{firstaltcolor}"><normalfont>
<ul>
$faqtitles
</ul>
</normalfont></td>
</tr>
</table>
</td></tr></table>

faq_title
<li><a href="misc.php?s=$session[sessionhash]&action=faq&page=$question[faqid]#$question[entryid]">$question[title]</a></li>

faq
{htmldoctype}
<html>
<head>
<title>$bbtitle Frequently Asked Questions</title>
$headinclude
</head>
<body>

$header

<table cellpadding="2" cellspacing="0" border="0" width="{contenttablewidth}" {tableinvisibleextra} align="center">
<tr>
<td width="100%"><img src="{imagesfolder}/vb_bullet.gif" alt="" border="0" align="absmiddle">
<normalfont><b><a href="index.php?s=$session[sessionhash]">$bbtitle</a> &gt;
<a href=misc.php?s=$session[sessionhash]&action=faq>Frequently Asked Questions</a>$title</b></normalfont></td>
</tr>
</table>

<br>

$faqhead

$faqentries

$footer

</body>

</html>

[webhost]

Kevin I installed eveything new including templates all works except the code still shows up in the answers to the questions on the board.

[tubedogg]

What versions of PHP & MySQL are you using?

[tubedogg]

Also run this query and tell me what it returns...

SELECT dohtml FROM faqentries WHERE faqid IN (1,2,3);

[webhost]

MySQL 3.23.39
php4.05

below when I select edit on any it of them it shows the same results on all of them. Results from that are posted below.

dohtml
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1
Edit Delete 1

Field Type Function Value
entryid int(10) ASCIICHARSOUNDEXENCRYPTLCASEUCASENOWPASSWORDENCODE DECODEMD5RANDLAST_INSERT_IDCOU NTAVGSUMCURDATECURTIMEFROM_DAYSFROM_UNIXTIMEPERIOD _ADDPERIOD_DIFFTO_DAYSUSERWEEK DAY
faqid int(10) ASCIICHARSOUNDEXENCRYPTLCASEUCASENOWPASSWORDENCODE DECODEMD5RANDLAST_INSERT_IDCOU NTAVGSUMCURDATECURTIMEFROM_DAYSFROM_UNIXTIMEPERIOD _ADDPERIOD_DIFFTO_DAYSUSERWEEK DAY
title blob Binary Binary - do not edit
text mediumtext ASCIICHARSOUNDEXENCRYPTLCASEUCASENOWPASSWORDENCODE DECODEMD5RANDLAST_INSERT_IDCOU NTAVGSUMCURDATECURTIMEFROM_DAYSFROM_UNIXTIMEPERIOD _ADDPERIOD_DIFFTO_DAYSUSERWEEK DAY 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.
showorder int(10) ASCIICHARSOUNDEXENCRYPTLCASEUCASENOWPASSWORDENCODE DECODEMD5RANDLAST_INSERT_IDCOU NTAVGSUMCURDATECURTIMEFROM_DAYSFROM_UNIXTIMEPERIOD _ADDPERIOD_DIFFTO_DAYSUSERWEEK DAY
dohtml smallint(6) ASCIICHARSOUNDEXENCRYPTLCASEUCASENOWPASSWORDENCODE DECODEMD5RANDLAST_INSERT_IDCOU NTAVGSUMCURDATECURTIMEFROM_DAYSFROM_UNIXTIMEPERIOD _ADDPERIOD_DIFFTO_DAYSUSERWEEK DAY
dobbcode smallint(6) ASCIICHARSOUNDEXENCRYPTLCASEUCASENOWPASSWORDENCODE DECODEMD5RANDLAST_INSERT_IDCOU NTAVGSUMCURDATECURTIMEFROM_DAYSFROM_UNIXTIMEPERIOD _ADDPERIOD_DIFFTO_DAYSUSERWEEK DAY
dosmilies smallint(6) ASCIICHARSOUNDEXENCRYPTLCASEUCASENOWPASSWORDENCODE DECODEMD5RANDLAST_INSERT_IDCOU NTAVGSUMCURDATECURTIMEFROM_DAYSFROM_UNIXTIMEPERIOD _ADDPERIOD_DIFFTO_DAYSUSERWEEK DAY

[Skwowwy]

I've solved the problem already. Simply replace the bbcodeparse2 with bbcodeparse (in misc.php). HTML will work, only the lay-out will be messed up a little, since <p> screws everything up due parsing issues. (like mentioned in the CP)

[webhost]

Thank You
Skwowwy
I figured it out must make links bold to stand out. Thanks Again

[Matt*is*thick]

I have installed it here : www.charmed-boards.com

Its not working though, you click on a question and it doesn't do anything. I make changes to the templates through the Cp but its not showing the changes?!?!

I have changed Misc.php as told to but its not working?

[Stasik]

Kevin? Whats about to ask Kier and onther developers to add this hack to next vb release?

[Mike Gaidin]

I like that idea. :D

[tubedogg]

The problem with running it through bbcodeparse() (which, btw, runs it through bbcodeparse2() before it's done) is that it's expecting a forum number (or it uses global options), whereas my system lets you set HTML/vB Code/smilies per question.

[tubedogg]

Originally posted by Stasik
Kevin? Whats about to ask Kier and onther developers to add this hack to next vb release?Good idea. :) There is going to be some kind of dynamic FAQ system, although AFAIK it hasn't been decided how to work it out yet.

[tubedogg]

Originally posted by Matt*is*thick
I have installed it here : www.charmed-boards.com

Its not working though, you click on a question and it doesn't do anything. I make changes to the templates through the Cp but its not showing the changes?!?!

I have changed Misc.php as told to but its not working? I just tried it on your site...it worked fine for me...?

[floleb7]

<a href="http://floleb7.dyndns.org/site/forum_test/upload/misc.php?s=&action=faq&page=1#1" target="_blank">http://floleb7.dyndns.org/site/forum...n=faq&page=1#1</a>

i have change bbparsecode2 to bbcodeparse nothing change

i have uninstall and reinstall forum last ziq allways problem with html

[[VbbFr]Elie]

I don't understand ... No one seen to have this problem ...

Please PM me !!!

Fatal error: Call to undefined function: cpheader() in c:\easyphp\www\vbb\faq_install.php on line 5

[Skwowwy]

faq_install.php belongs to the admin folder, and faq.php as well (if you didn't do that).

[[VbbFr]Elie]

Not stupid :)

It's working know ...

Thanks for your speed :p:p

[[VbbFr]Elie]

Ok ... 2nd Problem ...
all is working perfectly but just one thing do not work :(

If i use faq.php?action=addquestion to add a question, the question is not added to DB ...
I Must Use The link with the id of the FAQ : faq.php?action=addquestion&faqid=4

Why don't it work ?

[Stasik]

sure.. you must use faqid, to let script know in what hack should the queston be written

[[VbbFr]Elie]

True but ... there is a option and you can have to choose cat?gory in a select field ... and if i pass by this option the question isn't insert into the DB ... :(

Could you contact me in PM ?

Thanks :):p:):p:):p:)

[DarkReaper]

A nice fast install, but I've noticed a problem. On my FAQ pages, none of the html parses. For example:


How do I clear my cookies?
You may clear all your cookies by clicking <a href="member.php?s=&action=logout">here</a>. If you return to the main index page via the link provided and you are still logged in, you may have to remove your cookies manually.
Here are the instructions for Internet Explorer 5 on Windows:
<ol>
<li>Close all Internet Explorer windows.</li>
<li>Click the "Start" button.</li>
<li>Move upto "Find" and click "Files or Folders" from the menu that appears.</li>
<li>In the new window that appears, in the "containing text" field, type in the domain name of the board without the "http://" or "www." part. For example, if the board's address was "http://www.vbulletin.com/forum/index.php", I would type in "vbulletin.com" (without the quotes)</li>
<li>In the "look in" box, type in "C:WindowsCookies" (without the quotes) and press "Find Now"</li>
<li>After it has finished searching, highlight all files (click a file, then press CRTL+A) and delete them (press the "delete" key or SHIFT+DEL)</li>
</ol>
Your cookies should now be removed. You may want to restart the computer and revisit the board to be sure.

[DarkReaper]

I replaced bbparsecode2 with bbparsecode and it worked...I know you're saying that it should be bbparsecode2 but it doesn't work right, so you might want to fix this :)

[tpearl5]

Yeh, I'm having the same problem.. doh!

[beatbox]

tubedogg = the winnar!!!

You rule. Sweet hack. Major props.

/walks away excited and jumping.

[Stasik]

try to find the text "base hack" in hack

[Mike Gaidin]

Just installed it. Seems to be working great. :D

Good job!

[beatbox]

HTML or vB does not parse for me either.

[floleb7]

Originally posted by J-OST
Just installed it. Seems to be working great. :D

Good job!

http://www.mikegaidin.com/forums/misc.php?s=&action=faq&page=1#1


some prob ;)

[Mike Gaidin]

Well I'll be... :)

Guess I should open my eyes. LOL.

[shadowbreed]

Same here:http://www.snakepages.com/forum/misc.php?action=faq&page=4#29

html was ON
Vbcode was ON
Smilies was ON

Nothing is parsed

[DarkReaper]

Find the code you added and change bbparsecode2 to bbparsecode.

[shadowbreed]

Great thnx!

Now my vbcode and smilies are parsed.......

btw it was called bbcodeparse in my misc.php if anyone can't find it

Only still no html?????????

See url above

[Mike Gaidin]

vbcode works now, but smilies and html do not. any ideas?

[SirSteve]

Very nice work! Works perfectly!

[SirSteve]

Originally posted by J-OST
vbcode works now, but smilies and html do not. any ideas?

Same here. Using 2.03

[GetMeHosted.com]

Sounds Like a Great Hack,

We will try to add this soon.

God Bless,

[SirSteve]

Originally posted by SirSteve


Same here. Using 2.03

Anyone? Anyone? I hate seeing good hacks go to waste by not being 100% functional.

[GetMeHosted.com]

Ok, I installed, but then had to remove....

All "Default" FAQ do not parse.
<li>Red</li>
<li>Blue</li>
<li>Yellow</li>
<li>Green</li>
<li>Sky-blue pink with yellow spots</li>
</ol>

Change bbcodeparse2 to bbcodeparse, seem to fix the
"Custom FAQ" we add, but the "Default" one still did not
parse.

This looks like it could be a great feature,
Hope a fix is found soon..

[DarkReaper]

Run the following query:

UPDATE faqentries SET dohtml=1;

If that doesn't fix it, what you can do is change this:

$entry[text] = bbcodeparse2($entry[text],$entry[dohtml],$entry[dobbcode],$entry[dosmilies],$entry[dobbcode]);

to this:

$entry[text] = bbcodeparse2($entry[text],1,$entry[dobbcode],$entry[dosmilies],$entry[dobbcode]);


That solved it for me. Turns out that changing it do bbcodeparse() only made it SEEM to work, on some browsers. IE 5 loaded it fine, everything else didn't.

[SirSteve]

The HTML is still not rendering! Help! My FAQ looks bad without it!

[Dark Blaze]

Good Day,

I was wondering if the FAQ Editor works under version 2.2.1
If not, how could it be set to work for it?

Thank you,

[DarkReaper]

Its working for me, mostly.

http://www.unrealtournament.org/forums/misc.php?s=&action=faq&page=2#17

On that page, $bbuserinfo[userid] isn't parsing, and neither is {imagesfolder}.....

Help! :)

[cbloss]

Does this version not work with vB 2.2.1? I cannot get it to work with this version, I get a database error.

Anyone have any suggestions?

[Psychdrone]

hmmmm could some one clarify, if this works for vb 2.2.1?

thanks!

[Psychdrone]

could someone pleasseee tell me if this works for 2.2.1 or not??

[Lionel]

I did the change from bbparse2 to bbparse and that displays the html using vbcodes. But I cannot get images to display with vb codes.

[bira]

Kevin you have a serious mistake in your code, which is why no one here manages to parse HTML:

dohtml is $entry[dohtml] in your code. BUT YOU NEVER SELECTED IT :D


$entries=$DB_site->query("SELECT entryid,title,text FROM faqentries WHERE faqid='$page' ORDER BY showorder");


should be


$entries=$DB_site->query("SELECT * FROM faqentries WHERE faqid='$page' ORDER BY showorder");


(in misc.php)

Cheers,

Bira

[Lionel]

you are the best! :)

[Hoffi]

I changed the following:


In every SELCT-Statement in the FAQ-Section from the misc.php I set a Star instead of the different row-names. (Sample: SELECT * FROM faq $sql ORDER BY showorder).
I use bbcodeparse2.


So the HTML is parsed Good. The Smilies works too. vbCode works all, insted of the [ url ]. This creates a Link like this:
http://usercp.php/?s=

Have anyone a Idea?

And i have another Problem: The Order can't set from the CP. :stupid:

[Wolfgang]

I have the same Problem: The Order can't set from the CP.

I get the Error:

Warning: Variable passed to each() is not an array or object in
/home/sites/site479/web/forum/admin/faq.php on line 344

Order updated!


HTML, Smilies and vbCode works!

Have anyone a Idea?


THX, wolfgang :)

[Lionel]

keeps the installation as is and make the change in post 81

[Hoffi]

Originally posted by Lionel
keeps the installation as is and make the change in post 81

I did it. And the other SQL-Statement too. I wrote it before...

Or should i turn back the others?

[Lionel]

I made no change except for the one by Bira on post 81 and works fine.

[Psychdrone]

err so hey dose this work with 2.2.1?

[dotagious]

I have the same question about it working for 2.2.1

I also would like to know what this actually does. I tried to follow the link to the original hack as to find out, but it blocks me from that forum.

[Psychdrone]

grrrrrr some one!!

[bbaddons]

I have installed this on 2.2.1 and it is working fine along with 13 other hacks.

[Arathorn]

Installed in 2.2.1, and it works fine too. But the instructions in the zip file don't work for 2.2.1? In admin/index.php, instead of following the instructions,

Find:

makenavselect("Custom vB Codes","<hr>");
// *************************************************


Add directly below:

makenavoption("Add Question","faq.php?s=<?php echo $session[sessionhash]; ?>&action=addquestion","<br>");
makenavoption("Add Group","faq.php?s=<?php echo $session[sessionhash]; ?>&action=addfaq","<br>");
makenavoption("Edit","faq.php?s=<?php echo $session[sessionhash]; ?>&action=modify","<br>");
makenavselect("FAQs","<hr>");
// *************************************************



If I'm wrong, please correct me.

[Armage Bedar]

Find the following in admin/faq.php:
echo " (Order: <input type=text name=\"order[$faq[faqid]]\" size=3 value=\"$question[showorder]\">) ";

Change it to:
echo " (Order: <input type=text name=\"order[$question[entryid]]\" size=3 value=\"$question[showorder]\">) ";

Hope that helps.

[Wolfgang]

@Armage Bedar BIG THX! It's work! :D :D :D

Just now I can Order set from the CP.


Wolfgang

[Remi]

With the old FAQ templates, I was able to use variables like:

$homeurl
$bbtitle
$inboxname
$sentitemsname

with this hack they are not working any more !!

Does any one know how to fix this.

Thanks

[Remi]

Can Some one answer this please

Or at least tell me is it the way the hack works or the variables are not working for me only!!

Thanks

[SaintDog]

I would have to say that is it the way the new hack works, so you can no longer use the variables you used to use with the old hack.

As it seems, there are a few things in the hack that have not yet been fixed, but I am sure they will be fixed as soon as possible.

Again, the reason the variables you probably used do not work anymore is because of the new hack I would think. I did not make the hack so I can not really tell you, but that would be my thoughts on it.

[Remi]

Thank you very much Saint :)

I hope some hacker now can tell us how to use variable in this wounderfull hack

[mvigod]

Does this hack only modify the main vb faq or can you make a custom faq for each forum? I have many forums and in each one I want it's own individual topic specific faq. Does this hack do that or edit only the main vb faq???

thanx

marc

[Grower]

I would like to know if anybody is actually working on searchable version of this FAQ hack, so users can search through categories. Let me know because I would like to start working on it. Thank you.

[Remi]

If you are to do any thing, Please make it work with variables, just like the original FAQ. :)

$homeurl
$bbtitle
$inboxname
$sentitemsname

Thanks

[Grower]

In FAQ.PHP around line 292 in addquestion section there is
makehiddencode("faqid", "$faqid");
which prevented you from selecting own category for adding question. You have to remove that line to make it work correctly.

[Linus]

I did the hack and it worked fine for me a couple of weeks ago but now the FAQ when clicked upon is empty ... I might have done another hack that might have affected one of the files ... any opinions / advice ???

[Linus]

This is my FAQ bit in the original misc.php


if ($action=="faq") {
$templatesused = "faq_title,faq_head,faq_entry";
include("./global.php");

if(isset($page)){$sql = "WHERE faqid='$page'";}
$query = "SELECT faqid,title FROM faq $sql ORDER BY showorder";
$faqs=$DB_site->query($query);
while ($faq=$DB_site->fetch_array($faqs)) {
if (isset($page))
{$title = " > <a href='misc.php?s=$session[sessionhash]&action=faq&page=$faq[faqid]'>$faq[title]</a>";
}
$questions=$DB_site->query("SELECT entryid,title,faqid FROM faqentries WHERE faqid='$faq[faqid]' ORDER BY showorder");
while ($question=$DB_site->fetch_array($questions)) {
eval ("\$faqtitles .= \"".gettemplate("faq_title")."\";");
}
eval ("\$faqhead .= \"".gettemplate("faq_head")."\";");
unset ($faqtitles);
}
if (isset($page)) {
$entries=$DB_site->query("SELECT entryid,title,text FROM faqentries WHERE faqid='$page' ORDER BY showorder");
while($entry=$DB_site->fetch_array($entries)){
$entry[text] = bbcodeparse2($entry[text],$entry[dohtml],$entry[dobbcode],$entry[dosmilies],$entry[dobbcode]);
eval ("\$faqentries .= \"".gettemplate("faq_entry")."\";");
}
}
eval("dooutput(\"".gettemplate("faq")."\");");
}

I'm running v 2.2.1

but then when asked to find

if ($action=="faq") {
$templatesused = ""; // Only one template used so load it when called
include("./global.php");
$page = intval($page);
if (!$page)
$page = '';
eval("dooutput(\"".gettemplate("faq$page")."\");");

}

I can never find it ?

[christina]

Does this hack work on vb 2.2.2? Just curious as I'm looking to add it. :)

TIA,
Christina

[SaintDog]

FireFly or another person, could you please let me know why I am getting the below error. I have applied the fix provided by Bira as well as the one that another member provided which is supposed to fix the ordering problem, below is the error I get when trying to change the order:

Warning: Variable passed to each() is not an array or object in /path/to/my/forums/admin/faq.php on line 344

[slideboxer]

I was having parsing problems until making the change from post #81.

Problem I'm having now is that the images are not showing up. Anyone have the code fix for this one?

[SaintDog]

The images were not really working for me, I instead went in and instead of using the { images } variable I just used /path/to/image instead.

I need to find a way to correct that error :(

[christina]

Since no one answered about 2.2.2...

I installed it, and there weren't any updates to the admin control panel. If I try to run faq.php directly I get some complaint about "Fatal error: call to undefined function: cpheader() in....path\faq.php on line 13.

Chrirstina

[SaintDog]

You still would have to run the FAQ Install file to update things Christina, I think anyway (since there may be new queries or such added to the db).

I still have not figured out why I get the above error, Can anyone help out on this, I know I can not be the only one getting this, or am I? (I am using 2.2.1)

[christina]

Well, I did run faq_install first, and it showed no errors. It's just that things don't work after having done that...

[slideboxer]

The faq_install itself doesn't make the changes to the control panel. During execution of the install you will receive instructions on what lines of code to modify in your admin/index.php file. This you have to do yourself. I think the install even had some wrong code for this part... here's what I added:

// ***
makenavoption("Add Question","faq.php?s=<?php echo $session[sessionhash]; ?>&action=addquestion","|");
makenavoption("Add Group","faq.php?s=<?php echo $session[sessionhash]; ?>&action=addfaq");
makenavoption("Edit FAQs","faq.php?s=<?php echo $session[sessionhash]; ?>&action=modify");
makenavselect("FAQs");
// ***

underneath
makenavoption("Add","announcement.php?action=add","|");
makenavoption("Modify","announcement.php?action=modify");
makenavselect("Announcements");


Hope this gets it workiing for you.

[christina]

Ok, don't know how I missed that bit during the install. :/ But, since making the changes, any of the items now in the control panel just give me an "Internal Server Error" and don't provide any more info...

Thanks, btw. :)

Christina

[fonzerelli_79]

the two problems which i found with this code were
1. html not working - apply biras fix on post 81
2. images not working

edit the following faq's :-

under User Maintenance:
What are the buddy and ignore lists?

under : General Board Usage
Can I send email to other members of this board?
What is Private Messaging?

under Reading and Posting Messages :
Can I edit my own posts?

Each of these faq's have to be amended to
Allow HTML in Answer? Yes
Allow smilies in Answer? Yes

Hope this helps
fonz :stoned:

[christina]

Ok, I've gone through and uninstalled, cleaned up the files I was supposed edit, and reinstalled again. But, I always get an internal server error when trying the items in the control panel... :(

Originally posted by christina
Ok, don't know how I missed that bit during the install. :/ But, since making the changes, any of the items now in the control panel just give me an "Internal Server Error" and don't provide any more info...

Thanks, btw. :)

Christina

[SaintDog]

Well let's see, you have:

- Run faq_install.php
- Placed faq.php in your /admin/ directory
- Applied the updates from Bira
- Fixed what Fonz brought up

I am not sure why in the world you are getting an internal server error. It does not make too much sense on why you are getting it unless something other than the above have been modified on accident.

Where is Sinecure when you really! need him ;) - I am sure he could help both of us out.

[SaintDog]

You could use the below in the Admin CP, I am not sure what difference it would make, but you do not have to have the "echo" commands in the URL, it deals with the newer versions of vBulletin:


makenavoption("Edit","faq.php?s=$session[sessionhash]&action=modify","<br>");
makenavoption("Add Group","faq.php?s=$session[sessionhash]&action=addfaq","<br>");
makenavoption("Add Question","faq.php?s=$session[sessionhash]&action=addquestion","<br>");
makenavselect("F.A.Q. Editor");


Just a suggestion

[slideboxer]

The edit of the faq properties worked for me, thanks Fonz.

[fonzerelli_79]

no problem slideboxer ;)

[christina]

Thanks for the information, again.

It still doesn't work here, I've no idea why. :( I think I'm doing things right. I ended up redoing some things and made a faq.php that just calls my faq templates for me instead since I couldn't get this to work...

Christina
Originally posted by SaintDog
Well let's see, you have:

- Run faq_install.php
- Placed faq.php in your /admin/ directory
- Applied the updates from Bira
- Fixed what Fonz brought up

I am not sure why in the world you are getting an internal server error. It does not make too much sense on why you are getting it unless something other than the above have been modified on accident.

Where is Sinecure when you really! need him ;) - I am sure he could help both of us out.

[SaintDog]

The only thing I can think of now is maybe you have installed another hack that is calling something from the FAQ hack that is making it not work? I have done that before with other hacks, such as Biras, unless you look at it and make changes one by one, you can not install both the Away Hack & the Random Password hack.

[Omero]

IT doesn't work for me :(

http://forum.ngx.sm/misc.php?s=&action=faq&page=3#HTML

No matter what I do, i always get the same window with all the questions, I can't see the answers, etc...

My misc.php code is:


// FAQ EDIT HACK

if ($action=="faq") {
$templatesused = "faq_title,faq_head,faq_entry";
include("./global.php");

if(isset($page)){$sql = "WHERE faqid='$page'";}
$query = "SELECT faqid,title FROM faq $sql ORDER BY showorder";
$faqs=$DB_site->query($query);
while ($faq=$DB_site->fetch_array($faqs)) {
if (isset($page))
{$title = " > <a href='misc.php?s=$session[sessionhash]&action=faq&page=$faq[faqid]'>$faq[title]</a>";
}
$questions=$DB_site->query("SELECT entryid,title,faqid FROM faqentries WHERE faqid='$faq[faqid]' ORDER BY showorder");
while ($question=$DB_site->fetch_array($questions)) {
eval ("\$faqtitles .= \"".gettemplate("faq_title")."\";");
}
eval ("\$faqhead .= \"".gettemplate("faq_head")."\";");
unset ($faqtitles);
}
if (isset($page)) {
$entries=$DB_site->query("SELECT * FROM faqentries WHERE faqid='$page' ORDER BY showorder");
while($entry=$DB_site->fetch_array($entries)){
$entry[text] = bbcodeparse2($entry[text],$entry[dohtml],$entry[dobbcode],$entry[dosmilies],$entry[dobbcode]);
eval ("\$faqentries .= \"".gettemplate("faq_entry")."\";");
}
}
eval("dooutput(\"".gettemplate("faq")."\");");
}


AS you can I applied bira's hack, but still doesnt work... can someone help please? :(

[christina]

Ok, the only other real hack installed is the Welcome panel hack, nothing else very big really. I'm sure the hacks don't overlap. :( Only possibility is vbportal, perhaps? I wish the 'internal server error' was a little more explicative...

[LuBi]

Originally posted by christina
Does this hack work on vb 2.2.2? Just curious as I'm looking to add it. :)

TIA,
Christina

Any word on this working? Is everyone still having trouble?

[fonzerelli_79]

the hack worked fine with me

[Lars]

Where do I change the "categoryfontcolor" that the script generates for colors of the links? I know I can change the colors in CP, but I need to change it in the code.. any ideas?

Or, even better, where do I remove the link after the question on FAQ page? (As it is on this board).

[christina]

Not here, my boards are cursed. Perhabs vbportal is screwing with this somehow, I dunno. So far this is the only hack/mod I've failed at getting going. :D

Originally posted by LuBi


Any word on this working? Is everyone still having trouble?

[Xelation]

I'm running 2.2.2 and it doesn't seem to be working for me either.

[Remi]

Can't someone rewrite the instruction for the hack and release it in a new thread?

threr are so many instructons for this hack wich is very confusing

[AndyTSJ]

This doen't work properly for me. I can add a category, which shows up fine, and while I can submit a new FAQ perfectly well, the problem is that the question never appears on the list of FAQ's anywhere. No error messages or anything - it just doesn't show on the list :(

[slideboxer]

It seems to only allow you to add the questions from under the "Edit FAQS" link in admincp. Everything else, like everyone says, seems to comply but no show.

[AndyTSJ]

Gotcha... thanks for that ;)

[slideboxer]

My pleasure, now if someone could just fix that :D

[5861king]

Can any kind soul help me the order function does not work in the Admin CP I get this error message.

Warning: Variable passed to each() is not an array or object in /home/sites/site253/web/bboard/admin/faq.php on line 347

Everything else is working fine :D

[isoking]

Well After a little messing with the code (wish i know what i was doing :P)

here is the modified code for v2.2.2

Open Admin/index.php

Find:
// ***
makenavoption("Add","bbcode.php?action=add","|");
makenavoption("Modify","bbcode.php?action=modify");
makenavselect("Custom vB Codes","<hr>");

Add Directly Under that:

//**************************************************
makenavoption("Add Question","faq.php?action=addquestion");
makenavoption("Add Group","faq.php?action=addfaq");
makenavoption("Add Edit","faq.php?action=modify");
makenavselect("FAQ Database","<hr>");

Save And Upload.

Hope The Orig Authour didnt mind me adding this info,

[Mutt]

works great for me on 222

small fix though. html wasn't working

then I also noticed that the replacement vars weren't working so images were dead. It's because of the bbcodeparse. since I will be using html instead of vbcode or smiles, I just commented out the bbcode pars line in misc.php

$entry[text] = bbcodeparse2($entry[text],$entry[dohtml],$entry[dobbcode],$entry[dosmilies],$entry[dobbcode]);

add // in front of the line

this will fix html and replacement vars but you'll lose vbcode and smilies. oh well

I'm still not able to get vars like $bbtitle to work though. odd

[shadow_old]

Running fine on 2.2.4 here is my faq code from the misc.php:


// ############################### start faq ###############################
if ($action=="faq") {
$templatesused = "faq_title,faq_head,faq_entry";
include("./global.php");

if(isset($page)){$sql = "WHERE faqid='$page'";}
$query = "SELECT faqid,title FROM faq $sql ORDER BY showorder";
$faqs=$DB_site->query($query);
while ($faq=$DB_site->fetch_array($faqs)) {
if (isset($page))
{$title = " > <a href='misc.php?s=$session[sessionhash]&action=faq&page=$faq[faqid]'>$faq[title]</a>";
}
$questions=$DB_site->query("SELECT entryid,title,faqid FROM faqentries WHERE faqid='$faq[faqid]' ORDER BY showorder");
while ($question=$DB_site->fetch_array($questions)) {
eval ("\$faqtitles .= \"".gettemplate("faq_title")."\";");
}
eval ("\$faqhead .= \"".gettemplate("faq_head")."\";");
unset ($faqtitles);
}
if (isset($page)) {
$entries=$DB_site->query("SELECT * FROM faqentries WHERE faqid='$page' ORDER BY showorder");
while($entry=$DB_site->fetch_array($entries)){
$entry[text] = bbcodeparse2($entry[text],$entry[dohtml],$entry[dobbcode],$entry[dosmilies],$entry[dobbcode]);
eval ("\$faqentries .= \"".gettemplate("faq_entry")."\";");
}
}
eval("dooutput(\"".gettemplate("faq")."\");");
}


i also set dohtml to 1
my html smilies AND vbcode are working

the only thing that doesn't work is variables

[freehtml]

Originally posted by 5861king
Can any kind soul help me the order function does not work in the Admin CP I get this error message.

Warning: Variable passed to each() is not an array or object in /home/sites/site253/web/bboard/admin/faq.php on line 347

Everything else is working fine :D


I am using vb 2.2.4

Here is my FAQ (http://forums.sanguo-online.com/misc.php?s=&action=faq) section.

I had done the changes and now can display HTML as well as vb codes. But variables as pointed out by many others, is not working.

[diettalk]

I installed FAQ on 2.2.4 and I just upgraded to v2.2.5 and it works but none of the hacks I added work. I just tried to add a FAQ but it didn't work. It accepts it but it never shows up.

Is anyone else having this problem after an upgrade?

[diettalk]

I uninstalled and reistalled it again and all is working fine.

Originally posted by diettalk
I installed FAQ on 2.2.4 and I just upgraded to v2.2.5 and it works but none of the hacks I added work. I just tried to add a FAQ but it didn't work. It accepts it but it never shows up.

Is anyone else having this problem after an upgrade?

[Fallout2man]

Would it be possible in the future for this hack to be made into a vbhacker file?

[nulltone]

Changing the question order does not seem to work. Whenever I change the numbers, and press update order, the page freshes, but nothing happens. Anyone have a fix for this?

[scsa20]

ok, this sucks, HTML works and vB code works, and I think smilyles works (don't know, never tryed yet) but non of the images shows up, looking at the path of the image, I notice it is going to { imagesfolder } instead of changeing it to the image folder path....how can I fix this??

[scsa20]

anyone??

[scsa20]

^bumb^

[Mathiau]

hey m8

would love to install this!!!!!!!!!!!!!

BUT! saw alot of problems above....have they all been a added to the code already as updates? or fixes, whateva :)

will it work in 2.2.5? (perhaps time for a new updated version, if you got LotZ of free time :), or if u just want too :D

[Dark Odin]

I think this should be re-released..

[FleaBag]

The code I search for in misc.php in version 2.2.5 doesn't exist. Anyone able to help?

[scsa20]

I found the code, I just can't find a way to get my replacements code back :(

[FleaBag]

So this hack no longer works on later versions?

[FleaBag]

*Bump*

[geniuscrew]

Works like a charm on 2.2.5 ;)

[FleaBag]

Oh dear, wonder what I'm doing wrong then. I'll have to take another look later this morning. :)

[geniuscrew]

Maybe I can help GF - what's the problem?

[FleaBag]

I couldn't find the code I was looking for in misc.php, I didn't spend that long on it, admittedly, as I didn't have much time. Did you run into any problems?

[geniuscrew]

If you open it using Wordpad search for FAQ - now replace the code that is between

// ############################### start faq ###############################

and

// ############################### Popup Smilies for vbCode ################

The only problem i had was with the parsing of HTML - but that's fixed now

[FleaBag]

OK, maybe this is just me but the code in admin/index.php isn't there either, so for anyone else - this is what I did.

Find...

makenavselect("User Titles");
// ***


Below that, add...

makenavoption("Add Group","faq.php?action=addfaq","|");
makenavoption("Edit Group","faq.php?action=modify","<br>");
makenavoption("Add Question","faq.php?&action=addquestion");
makenavselect("FAQ Maintenance");
// ***


...and that should have your CP sorted. :) Seems to be running fine on 2.2.5, thanks for the tip geniuscrew and thanks for the hack tubedogg. :D

[scsa20]

Originally posted by geniuscrew
The only problem i had was with the parsing of HTML - but that's fixed now

how did you fix that?? I don't know how to fix it :(

[geniuscrew]

Firstly do EXACTLY what it tells you in the instructions - don't run any queries mentioned in this thread or change bbparsecode2 to bbparsecode

simple replace this



$entries=$DB_site->query("SELECT entryid,title,text FROM faqentries WHERE faqid='$page' ORDER BY showorder");


with


$entries=$DB_site->query("SELECT * FROM faqentries WHERE faqid='$page' ORDER BY showorder");


(in misc.php)




That's what fixed mine :)

Hope that helped!

@ GamerForums - you're welcome ;) Glad i could help

[geniuscrew]

Originally posted by GamerForums
OK, maybe this is just me but the code in admin/index.php isn't there either, so for anyone else - this is what I did.

Find...

makenavselect("User Titles");
// ***


Below that, add...

makenavoption("Add Group","faq.php?action=addfaq","|");
makenavoption("Edit Group","faq.php?action=modify","<br>");
makenavoption("Add Question","faq.php?&action=addquestion");
makenavselect("FAQ Maintenance");
// ***


...and that should have your CP sorted. :) Seems to be running fine on 2.2.5, thanks for the tip geniuscrew and thanks for the hack tubedogg. :D


Exactly - I got errors when I used the code given in the instructions

[FleaBag]

I'm really starting to get into this hacking lark, I might do something adventurous soon hehe.

[geniuscrew]

good luck lol

[scsa20]

Originally posted by geniuscrew
Firstly do EXACTLY what it tells you in the instructions - don't run any queries mentioned in this thread or change bbparsecode2 to bbparsecode

simple replace this



$entries=$DB_site->query("SELECT entryid,title,text FROM faqentries WHERE faqid='$page' ORDER BY showorder");


with


$entries=$DB_site->query("SELECT * FROM faqentries WHERE faqid='$page' ORDER BY showorder");


(in misc.php)




That's what fixed mine :)

Hope that helped!

funny, I areadly had that code for along time when I first installed it, and when I put in a location for a images as {imagesfolder }/whatever.gif, it doesn't work and I take a look and it just shows {imagesfolder }/whatever :(.

should the following lines bechanged instead??


$entry[text] = bbcodeparse2($entry[text],$entry[dohtml],$entry[dobbcode],$entry[dosmilies],$entry[dobbcode]);


if so, to what...if that's not what I so'pose to change, then what?? :( I'm so lonely without that HTML praseing :(

[Elentari]

Ive installed this hack ... but now html is showing up as raw code on the FAQ page ... Ive tried fiddling with the codes as shown above, but it doesnt seem to be solving it. Any ideas?
My forum is at www.christiansurvivors.com/forums
the FAQ page is at http://www.christiansurvivors.com/forums/misc.php?s=&action=faq

Something else I noticed is that adding questions through the 'edit group' option, works fine - but using the add a question link directly from the left hand menu in user cp, it says its added the question, but it hasnt really!!

Hoping for some ideas!!
Thanks!

El xx

[Elentari]

Anyone??

I have since tried uninstalling and reinstalling, but ended up with exactly the same result!!! :p

edit : finally got it working!! uninstalled and installed AGAIN ... did exactly the same thing and it worked LOL!! Go figure ;)

[Keyser S?ze]

[QUOTE]Originally posted by GamerForums
OK, maybe this is just me but the code in admin/index.php isn't there either, so for anyone else - this is what I did.

Find...

makenavselect("User Titles");
// ***


Below that, add...

makenavoption("Add Group","faq.php?action=addfaq","|");
makenavoption("Edit Group","faq.php?action=modify","<br>");
makenavoption("Add Question","faq.php?&action=addquestion");
makenavselect("FAQ Maintenance");
// ***


...and that should have your CP sorted. :) Seems to be running fine on 2.2.5, thanks for the tip geniuscrew and thanks for the hack tubedogg. :D

[Keyser S?ze]

got this error msg Parse error: parse error in /usr/home/emusa/emusanet.com/public_html/forums/misc.php on line 147

but theres nothing on line 147

sigh, help pls

[xeon]

I dl'd the file in post one and did a clean install. I do not see any template additions when I run the faq_install.php, just the misc.php and index.php changes . I see the templates on page 3 of this post, but shouldn't these have been in the install file zip? Upon review with phpmyadmin, I see none of my templatestid's are 1, which is something I see in the install file in relation to the templates. The install script is looking for a templatestid #1.
Edit Update
I pulled the templates and put them in the long way, everything seems to be ok except for images are not working. I had to change the line mentioned in the prev. page to get html to parse, but images don't seem to be working. Changing the path to
<img src="/images/image.gif"> seem to do the trick though. This would have been easier if not for the template problem, which was my own. Very useful hack!

[DudeSicko]

The .zip on the 1 page, is that the upgraded version for 2.5 ore the newest version of the board ?

[FleaBag]

IceMalee; then you shall call him Matthew. Heh. ;)

Just upgraded to 2.2.6, working well with the fixes. :)

[tpearl5]

I'm having a small problem. I plan on using the Referrer Link located in the FAQ. However $userid does not parse. How do I get that link to display the correct referral link?

[Dark_Wizard]

Originally posted by Elentari
Ive installed this hack ... but now html is showing up as raw code on the FAQ page ... Ive tried fiddling with the codes as shown above, but it doesnt seem to be solving it. Any ideas?
My forum is at www.christiansurvivors.com/forums
the FAQ page is at http://www.christiansurvivors.com/forums/misc.php?s=&action=faq

Something else I noticed is that adding questions through the 'edit group' option, works fine - but using the add a question link directly from the left hand menu in user cp, it says its added the question, but it hasnt really!!

Hoping for some ideas!!
Thanks!

El xx

Find this in misc.php:

$title = " &gt; &lt;a href='misc.php?s=$session[sessionhash]&action=faq&page=$faq[faqid]'&gt;$faq[title]&lt;/a&gt;";


replace with this:

$title = " &gt; <a href='misc.php?s=$session[sessionhash]&action=faq&page=$faq[faqid]'>$faq[title]</a>";

[zachb]

I got it working fine. Thanks for the hack, it's just what I needed. :)

[tpearl5]

I can get it to update the order of the faq entries.

I get this error at the top of the page:

Warning: Variable passed to each() is not an array or object in /mnt/web/guide/johnsworld/www/midi/board/admin/faq.php on line 347

[FleaBag]

Working on 2.2.7 with about 40 other hacks. :)

[Erwin]

This hack is brilliant - I've been using it for a while now. Remember to use the HTML/ bbcode fix a couple of pages back.

[yzztik]

Originally posted by tpearl5
I can get it to update the order of the faq entries.

I get this error at the top of the page:

Warning: Variable passed to each() is not an array or object in /mnt/web/guide/johnsworld/www/midi/board/admin/faq.php on line 347

I am having the same problem. I dont think I get any error, it acts as if it update the order, but the numbers and previous order stays the same.

Any ideas? :(

[Apok2002]

I have custom headers w/ my themes, and the FAQ button got taken out (not intentionally). How do I get it back so I can use the FAQ again? What is the url I should use for the link, and where should I put it? Back in the header where the rest of the buttons to navigate thru the rest of the site are?

[speedway]

For all those fighting with the faq entries and not having things like $bbtitle, { imagesfolder } and maybe even $bbuserinfo[userid] parsing or showing correctly....

I *think* I have found a solution. Determined to get this working and thinking "hey, templates come from the DB so it should work...".

Anyway, enough ranting. I did this.

in misc.php AFTER

$entry[text] = bbcodeparse2($entry[text],$entry[dohtml],$entry[dobbcode],$entry[dosmilies],$entry[dobbcode]);

put


$entry[text]=addslashes($entry[text]);
$entry[text]=str_replace("\\'","'",$entry[text]);

eval ("\$entry[text] = \"$entry[text]\";");


and BINGO, all your variables will now contain a value....

Have fun. :bunny:

Download the attached text file and copy/paste over what you have in misc.php for the faq bit. The parsing code in vB is screwing up the new PHP bit.

[FleaBag]

OK slight problem I've noticed while running this hack on 2.2.7. If you look here... http://www.gamerforums.com/board/misc.php?s=&action=faq ... You'll see that the Groups have messed up HTML, the brackets e.t.c are included in the hyperlinks [look and you'll understand what I mean]. When I edit the groups, the formatting is fine - why would it be doing this? Anyone have any ideas? Thanks in advance. :)

[speedway]

Originally posted by GamerForums
You'll see that the Groups have messed up HTML, the brackets e.t.c are included in the hyperlinks [look and you'll understand what I mean].

I haven't got a definate answer for this one however I would assume it has something to do with nested href's. If you look at the source it runs like this: <a ..............<a /a>.../a>. Now the question becomes "is this legal in HTML"?

On my board (yet to see the light of day) I have modifed this hack to have an additional title (called menutitle to be exact) that is used for "menu" parts of the display. The text in this column is just the question (no hyperlinks). The original title is then used on the "detail" part and does contain the hyperlinks. This then looks identical to the original template based version.

I may put this code up at a later date once I do the admin bit and check with Kevin that it is ok.

Sorry I couldn't be of more help.

[NexDog]

I'm running 2.2.6 and there is no FAQ mention AT ALL in misc.php. So how to replace this:

Find:

if ($action=="faq") {
$templatesused = ""; // Only one template used so load it when called
include("./global.php");
$page = intval($page);
if (!$page)
$page = '';
eval("dooutput(\"".gettemplate("faq$page")."\");");

}

Can I just add an entry anywhere in misc.php with the correct info?

[speedway]

suspect you are looking in yoursite/path-to-forum-if-any/admin/misc.php, not yoursite/path-to-forum-if-any/misc.php.

In a vanilla 2.2.6 yoursite/path-to-forum-if-any/misc.php it starts on line 96.

Oh, and don't forget to look at post #179 for the fix for variable parsing.

Cheers

[NexDog]

Damn, double files. What a crap idea. :D

Thanks man.

[NexDog]

Originally posted by GamerForums
OK, maybe this is just me but the code in admin/index.php isn't there either, so for anyone else - this is what I did.

Find...

makenavselect("User Titles");
// ***


Below that, add...

makenavoption("Add Group","faq.php?action=addfaq","|");
makenavoption("Edit Group","faq.php?action=modify","<br>");
makenavoption("Add Question","faq.php?&action=addquestion");
makenavselect("FAQ Maintenance");
// ***


...and that should have your CP sorted. :) Seems to be running fine on 2.2.5, thanks for the tip geniuscrew and thanks for the hack tubedogg. :D

But I'm confused as the installer says:

admin/index.php

Find:

<a href="bbcode.php?s=<?php echo $session[sessionhash]; ?>&action=modify"> Modify </a>
</td></tr>

Just under that add:

<!-- FAQ addon -->
<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("FAQs"); ?>
</table>
<a href="faq.php?s=<?php echo $session[sessionhash]; ?>&action=addquestion"> Add Question</a><br>
<a href="faq.php?s=<?php echo $session[sessionhash]; ?>&action=addfaq"> Add Group</a> |
<a href="faq.php?s=<?php echo $session[sessionhash]; ?>&action=modify"> Edit</a>
</td></tr>
<!-- /FAQ addon -->


I see no "makenavoption" instructions at all. Also, thewre is no:

<a href="bbcode.php?s=<?php echo $session[sessionhash]; ?>&action=modify"> Modify </a>
</td></tr>

In my admin/index.php at least.....

[NexDog]

Bumpety bump. ;)

[NexDog]

Okay, i added:


PHP:

makenavoption("Add Group","faq.php?action=addfaq","|");
makenavoption("Edit Group","faq.php?action=modify","<br>");
makenavoption("Add Question","faq.php?&action=addquestion");
makenavselect("FAQ Maintenance");
// ***


And it appears okay in the admin CP. But what about:

<!-- FAQ addon -->
<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("FAQs"); ?>
</table>
<a href="faq.php?s=<?php echo $session[sessionhash]; ?>&action=addquestion"> Add Question</a><br>
<a href="faq.php?s=<?php echo $session[sessionhash]; ?>&action=addfaq"> Add Group</a> |
<a href="faq.php?s=<?php echo $session[sessionhash]; ?>&action=modify"> Edit</a>
</td></tr>
<!-- /FAQ addon -->


I guess they are one and the same? But why the wrong instructions?

[Brad]

Originally posted by NexDog

I guess they are one and the same? But why the wrong instructions?

the way the admin cp handels links was changed some time ago, the hack was made for a older verson that still used html to make the links in the admin cp.

[Elanor]

In line ~94 I have removed "$sql" because I had trouble after installing 4Images with VB integration.

Original:
$query = "SELECT faqid,title FROM faq $sql ORDER BY showorder";

It's now:
$query = "SELECT faqid,title FROM faq ORDER BY showorder";

Everything works fine now, but I wonder if removing the $sql could cause any trouble in future (I know almost nothing about php/sql ^^; )

Just wanted to hear your opinion about this.

[FleaBag]

The code you need to find in misc.php in 2.2.8 isn't present, so I have to uninstall this hack. :( Anyone have any ideas? Thanks in advance...

[DrkFusion]

Hi, I installed this, and added a new faq catagory, but it isn't showing up in the faq. What is wrong?

Thanks for your help
-Arunan

[Bad Bunny]

I did a search for FAQ in the database, and this was the only result.
No offense, but the whole thread is filled with problems.

[FleaBag]

This hack is very out-dated, it's a shame not all hackers support their work [I realise this isn't manditory, but it would be nice].

[Mike Gaidin]

An update for this would be great.

[Keyser S?ze]

[QUOTE]02-27-03 at 10:27 PM Mike Gaidin said this in Post #194 (https://vborg.vbsupport.ru/showthread.php?postid=359308#post359308)
An update for this would be great.

[Remi]

02-28-03 at 03:27 AM Mike Gaidin said this in Post #194 (https://vborg.vbsupport.ru/showthread.php?postid=359308#post359308)
An update for this would be great.




Yes I agree with that

[S.Shady]

considering how old this hack is im not surprised its not updated but is there any way to get this to work with vb 2.3.0 it works fine in the admin cp but when viewing the faq nothing shows up as was previously stated

[PixelFx]

tried installing on 2.30 heh no luck ...

[Erwin]

It works on 2.3.0. I've had this hack from when it was released, and just upgraded my vB, and it has kept on working.

[Koutaru]

After a couple minutes of code manipulation, I have it working in 2.3 :) very nice hack

I think all I did was

in misc.php
REPLACE

$faqs=$DB_site->query($query);


WITH

$faqs=$DB_site->query("SELECT faqid,title FROM faq $sql ORDER BY showorder");


DELETE


$query = "SELECT faqid,title FROM faq $sql ORDER BY showorder";

[PixelFx]

thank you for your help, what got me was the admin index.php I wasn't used to how the admin options used to work long ago... so after some digging and help above I got it... thanks for not spelling it out, makes the learning process more fun :P

It's working great now...

Question though: how would someone go about adding access masks to the faq system? aka make it so you have to be registered before reading a faq catigory. ;)

[Koutaru]

for a specific faq categlory or all categlories?

[PixelFx]

after reading this entire thread I have everything working on 2.30 except my image code not showing up ;)

so far everything else seems to be working

seem below for error,
http://www.shukenja.com/forum/misc.php?&action=faq&page=3#27

aka image not loading,

also in the admin cp, I get the following error with the faq.php



Warning: Variable passed to each() is not an array or object in /usr/path/forum/admin/faq.php on line 344



any ideas?

[Falkware]

get this very same error..any idea how to fix it?

[engquist]

is there any way to have the instructions re-done for this. I would love to install it, but I fear the instability since it was made 2 years ago and versions ago.

[cindyd]

I also need to get a hack for the FAQ, I am running 2.30 and after spending a couple of days getting my board back in order after a bad installation I am leery.

If all I need to do is what Koutaru posted then I will go for. ANyone else running this on 2.3?

[PixelFx]

I had it working on 2.30, to get it stable you need to read the entire thread before you install then make notes on what is to be installed and what code to use from the thread.

I need to install it again so might try and put a better installer together with updated info for 2.30...

[cindyd]

Yeah, I started at the beginning and just now finished reading, getting ready to install. Crossing my fingers...

[cindyd]

edited for total stupidity

[PixelFx]

how did ya make out?

[cindyd]

I have it installed and working great! I wish the <p> command didn't cause 2 lines of white space, but I can live with that.

Now if I could only figure out another hack for uploading images I would be done! I have it basically done, but I'm stuck at the moment. Thanks for asking!

[copper]

Just installed this hack on 2.3.2 . (Fresh install) , and after a bit of modification I have it working. <Yeah !> If anyone wants the details I'll post 'em. 99.9% of the features & such work , including html & admin cp functions.

[FastAttack]

yeah post them dude! :)

[FastAttack]

Following was tested on vbulletin 2.3.0 it should work for 2.3.1 and 2.3.2
Please note follow the regular install directions from the original zip. don't follow the changes on the original readme to misc.php
This file was a compilation of bug fixes made by DarkReaper , bira, and fleabag thanks again guys, you just made it very easy for me to it! and of course thanks to tubedogg for the original hack!

[yzztik]

What if we already installed the original version? What changes do I have to make from that? I mean it works fairly well to me minus the re-ordering stuff. Does yours fix that?

[FastAttack]

Yeah this also fixes that..

to update your basicly you would just need to replace everything from the the start faq area. with my updated one..

working example is at http://www.srtforums.com/forums/misc.php

I am working on addon so that certain user groups can access this faq update as well with the lesser admin mod..

:) I will release it but first I will ask all the people that made the original scripts to let me release it

and for a example of working bbcode and smilies :

http://www.srtforums.com/forums/misc.php?s=&action=faq&page=4#28

[yzztik]

cool, that is what I thought.

ok I just did that and nothing seemed to have changed :(

I still can't re-order the entries. Are there any changes to faq.php needed for that?

[FastAttack]

what version are you running and nope I never even touched faq.php

[yzztik]

vb 2.3.0

I've always (since 2.2.8) gotten it to recognize HTML, not sure about smilies cuz I dont have any but the only thing that never worked is re-ordering the entries. Everything I change a number and submit the changes it refreshes the page as if I had just gone there for the first time and no changes are made.

[FastAttack]

most likely is a bad misc.php you have , upload a new one and do the code fix again :)

[yzztik]

I just tried that and still nothing. It lets me re-order the groups but not the questions within each group :(

[FastAttack]

oh I see what it is.. give me a moment and I will see if I can fix it

[FastAttack]

well when I do the code fix it breaks something else.. so I guess its faq.php which needs a updated callback function for the doorder..
I am not an expert programer :( so I guess some other l33t programmer can base it out of the updated code and fix the bug

[yzztik]

Well thanks for trying anyway. At least now I have vbcode and smilies :D

[FastAttack]

hehe no prob.. btw html works as well hehe

I know someone can update the faq.php to do the doorder.. like I said I am new to the programming of VBB all together.. in reality I look at other people's work and then build from that since this forum software is a tad bit complex since I am so new to programming it hehe

[carryapple]

awesome hack, thanks a LOT!

My FAQ would prolly be pretty worthless without it. BTW, it worked right away on m y 2.3.4 board - w/ the original zip and new instructions. :)

[cindyd]

I am so embarassed to even post this question, but here goes.

I installed l ast August and need to make a change in my FAQ except I have no idea how or where to do it.

I had added an extra question to my User Maintenance section and I cannot find it anywhere.

I have been through every FAQ template I have and it isn't there.

I also don't remember how to add on.

Getting old is tough.

Thanks for the assist.

I found out what the problem was: I couldn't find what I needed because something wiped out the FAQ info on the left panel of the CP. After I had uninstalled and reinstalled that section was back.

Now to go back to see if the questions can be sorted, at the present time the revert back..