vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   hello, need some help with php vs. vb (https://vborg.vbsupport.ru/showthread.php?t=160605)

maoreactor 10-19-2007 08:48 PM

hello, need some help with php vs. vb
 
hey.

i'm using vb 3.6.8.

i'm struggling with this code:

maor.php:
Code:

<?php

$query="SELECT * FROM mst_forum";
$result=mysql_query($query);
$num=mysql_numrows($result);



$i=0;
while ($i > $num)
{

$forumid=mysql_result($result,$i,"forumid");
$title=mysql_result($result,$i,"title");
$lastpost=mysql_result($result,$i,"lastthread");
$lastposter=mysql_result($result,$i,"lastposter");
$lastpostid=mysql_result($result,$i,"lastpostid");

eval('$home["$mods[modid]"][\'content\'] = "' . fetch_template('adv_portal_hehe') . '";');


$i++;

}

?>

template adv_portal_hehe:
Code:

<a href=forumdisplay.php?f=$forumid><strong>$title</a><br>
<small>lastpost: <a href=showthread.php?goto=newpost&t=$lastpostid><strong>$lastpost</strong></a> by: <strong>$lastposter</strong></small><BR><BR>

on vBa CMPS i added it as a PHP module integrated with the template above.
as you can guess it does not work. it show that:

http://www.kts.co.il/bah.JPG

if i dont use a template and put an "echo" on the PHP file, it shows what it is supposed to but on the top of my page above the logo, so that's not good either...

thanks for your help ;)

Opserty 10-20-2007 09:13 AM

Are you using the global.php file from vBulletin forum root?

If so:
PHP Code:

<?php

$forums 
$db->query_read("SELECT * FROM mst_forum");

while (
$row $db->fetch_array($forums))
{
    eval(
'$home["$mods[modid]"][\'content\'] .= "' fetch_template('adv_portal_hehe') . '";');

}

?>

and in your template:
Code:

<a href=forumdisplay.php?f=$row[forumid]><strong>$row[title]</a><br>
<small>lastpost: <a href=showthread.php?goto=newpost&t=$row[lastpostid]><strong>$row[lastpost]</strong></a> by: <strong>$row[lastposter]</strong></small><BR><BR>


maoreactor 10-20-2007 02:44 PM

yep, that works.

thanks alot :)

maoreactor 10-25-2007 07:05 AM

hmm another question, as i see, in order to recognize a catagory, it looks like this:

childlist: 1-,10,4,5
as i dont know what 1- says, the 2nd parameter is the current forumid and 4 and 5 is the child forums of this catagory.

now, how do i make the script know that this forumid has child forums? like,
if ($row['childlist] ?HAS MORE THEN 2 PARAMS?)
{
$num=number of childforums;
$parentid = forumdid of parent;
$childforum[1] = forumid;
$childforum[2] = forumid;
...
}

i have read $array guide at php.net and dont seem to get it...

my main idea is that it will look like this:

CATAGORY: CATAGORY:
forum1 forum1
forum2 forum2
forum3 forum3

CATAGORY: CATAGORY:
forum1 forum1
forum2 forum2
forum3 forum3

thanks for your help :)


All times are GMT. The time now is 03:28 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
  • Page Generation 0.00957 seconds
  • Memory Usage 1,724KB
  • 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
  • (3)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete