vb.org Archive - View Single Post

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>

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01501 seconds Memory Usage 1,804KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post 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 showpost_complete
Messages: