The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 09-08-2001

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!

tubedogg · #32 09-10-2001, 09:12 AM

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 · #33 09-10-2001, 10:51 AM

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 · #34 09-10-2001, 11:01 AM

It should exactly like this:

Code:

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 · #35 09-10-2001, 11:11 AM

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 · #36 09-10-2001, 11:14 AM

faq_entry:

Code:

<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

Code:

<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

Code:

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

faq

Code:

{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 · #37 09-10-2001, 11:55 AM

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 · #38 09-10-2001, 12:34 PM

What versions of PHP & MySQL are you using?

tubedogg · #39 09-10-2001, 12:46 PM

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

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

webhost · #40 09-10-2001, 01:15 PM

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

#41 09-10-2001, 02:24 PM

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)

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04733 seconds Memory Usage 2,321KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (5)bbcode_code (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!