![]() |
I have made some modifications to the hack by Stasik, which is located here.
New features:
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! :) |
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 --< |
Fixed.
I also added an upgrade path from v2 of the hack (Stasik's version). |
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 PHP Code:
PHP Code:
|
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 |
this is a must-have hack,
Thanks everyone ! |
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. |
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. |
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.
|
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. :( |
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. |
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...?
|
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. |
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 |
Fixed. Download the zip and reupload faq.php. Don't run faq_install.php again.
|
little bug
in faq.php search dobbcode (8 to find) replace by dovbcode |
Actually, no, it's supposed to be dobbcode. If you replace it with dovbcode it won't work I guarantee it.
|
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>'); |
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 |
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... |
i change the table name before my post but you need to look faq_install.php
|
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 |
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.
|
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 |
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).
|
OK I uninstalled and reinstalled and I get the same error as above.
|
Then there is something wrong with your server. It works *perfectly* for me.
|
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. |
Tubedogg any ideas on this?
|
same problem
|
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... |
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/
|
It should exactly like this:
Code:
if ($action=="faq") { |
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.
|
faq_entry:
Code:
<br> Code:
<br> Code:
<li><a href="misc.php?s=$session[sessionhash]&action=faq&page=$question[faqid]#$question[entryid]">$question[title]</a></li> Code:
{htmldoctype} |
Kevin I installed eveything new including templates all works except the code still shows up in the answers to the questions on the board.
|
What versions of PHP & MySQL are you using?
|
Also run this query and tell me what it returns...
SELECT dohtml FROM faqentries WHERE faqid IN (1,2,3); |
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 |
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)
|
All times are GMT. The time now is 04:50 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|