vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   FAQ Edit v3 (https://vborg.vbsupport.ru/showthread.php?t=27733)

tubedogg 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 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 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 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 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 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 09-10-2001 12:34 PM

What versions of PHP & MySQL are you using?

tubedogg 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 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

Skwowwy 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)


All times are GMT. The time now is 08:39 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01204 seconds
  • Memory Usage 1,756KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete