The Arcive of Official vBulletin Modifications Site.

Logician · #11 09-18-2003, 01:02 PM

you didnt include vb's global.php in your code so your code does not recognize gettemplate function which is a vbulletin function.

Almax1 · #12 09-18-2003, 05:09 PM

thank you very much Logician

got it working ;P

[edit: spoke to soon]

Almax1 · #13 09-18-2003, 06:43 PM

This is simply frustrating me now thank you to all that have helped
i can get the template to show now but no results from either forum ??
Any help or guidelines would be great thanks

PHP Code:


			
<?php



include("./global.php");





/////////////// CONFIG /////////////// 

// 

$maxposters = "10"; // change this to the number of posters you want to show. 

$bc1 = "#777777"; // change to first alternating color. 

$bc2 = "#555555"; // change to second alternating color. 

///////////// END CONFIG ///////////// 





require("admin/config.php"); 

$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Unable to connect to database"); 

mysql_select_db($dbname) or die("Unable to select database $dbname"); 





$postsresult = mysql_query("SELECT COUNT(*) AS count,postuserid,postusername FROM thread WHERE forumid IN (10,11) GROUP BY postuserid ORDER BY count DESC LIMIT $maxposters;") or die("Unable to complete query"); 

while ($topposters = mysql_fetch_array($postsresult)) 

{ 

    if (($counter++ % 2) != 0) 

    { 

        $bc=$bc1; 

    } 

    else 

    { 

        $bc=$bc2; 

    } 

} 

eval("dooutput(\"".gettemplate("topp")."\");"); 

?>

Template Named: topp

PHP Code:


			
 {htmldoctype} 

<html> 



<head> 

<title>test</title> 

$headinclude 

</head> 



<body> 

$header 



<table cellpadding="10" cellspacing="0" border="0" bgcolor="{pagebgcolor}" width="100%"><tr><td>

<table cellpadding="4" cellspacing="1" border="0" bgcolor="{tablebordercolor}" width="100%">

<tr>

    <td colspan="2" bgcolor="{categorybackcolor}">

    <p align="center"><normalfont color="{categoryfontcolor}"><b>Gambling 

    Addicts:</b></normalfont></td>

</tr>

<tr>

    <td bgcolor="{tableheadbgcolor}" width="100%">

    <p align="center"><smallfont color="{tableheadtextcolor}">User</smallfont></td>

    <td bgcolor="{tableheadbgcolor}">

    <p align="center"><smallfont color="{tableheadtextcolor}">Threads</smallfont></td>

</tr>

<tr>

    <td bgcolor="{tableheadbgcolor}" width="100%"><center><a href="$bburl/xxx/xxx/member.php?&action=getinfo&userid=$topposters[postuserid]">

<smallfont>$topposters[postusername]</a></smallfont></td>

    <td bgcolor="{tableheadbgcolor}"><center>$topposters[count]</td>

</tr>



</tr>

</table>

</td></tr></table>

</body>

</html>

assassingod · #14 09-18-2003, 06:45 PM

require global.php instead of include.

Also, if this is for vBulletin, no need to require admin/config.php

Almax1 · #15 09-18-2003, 06:51 PM

Thanks for the speedy reply assasingod i tried that but......

Quote:

Originally Posted by Almax1

i can get the template to show now but no results from either forum ??
Any help or guidelines would be great thanks

assassingod · #16 09-18-2003, 06:57 PM

try:

PHP Code:


			
<?php

error_reporting(7);

require('./global.php'); 





/////////////// CONFIG /////////////// 

// 

$maxposters = "10"; // change this to the number of posters you want to show. 

$bc1 = "#777777"; // change to first alternating color. 

$bc2 = "#555555"; // change to second alternating color. 

///////////// END CONFIG ///////////// 



$postsresult = $DB_site->query("SELECT COUNT(*) AS count,postuserid,postusername FROM thread WHERE forumid IN (10,11) GROUP BY postuserid ORDER BY count DESC LIMIT $maxposters;") or die("Unable to complete query"); 

while ($topposters = $DB_site->fetch_array($postsresult)) 

{ 

    if (($counter++ % 2) != 0) 

    { 

        $bc=$bc1; 

    } 

    else 

    { 

        $bc=$bc2; 

    } 

} 

eval("dooutput(\"".gettemplate("topp")."\");"); 

?>

Almax1 · #17 09-18-2003, 07:03 PM

already tried that m8
tried a few ways but it wont show the results of the forums specified

script & template is in https://vborg.vbsupport.ru/showpost....1&postcount=13

Link14716 · #18 09-19-2003, 07:13 PM

You can't do it with one template, you must add another gettemplate function in the loop, setting it to a variable. Then add a template that does loop over and over, and put the variable in its correct spot in the main template.

Almax1 · #19 09-20-2003, 12:32 AM

Then add a template that does loop over and over

example would be great

assassingod · #20 09-20-2003, 02:00 AM

PHP Code:


			
while ($postresults = $DB_site->fetch_array($postsresult)) 

{ 

eval ("\$var.= \"".gettemplate("templatename")."\";");



}

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07262 seconds Memory Usage 2,284KB Queries Executed 11 (?)
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 (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (4)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)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!