The Arcive of vBulletin Modifications Site.

Almax1 · #1 09-17-2003, 03:03 PM

Parse error: parse error in /xxx/xxx/xxx/topp.php on line 17

================================================== =

PHP Code:


			
<?php





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")."\");");

?>

=========================================

trying to display thread starters in 2 forums 10 & 11
in a template
a simple guideline would be great please

SmEdD · #2 09-17-2003, 06:00 PM

try

PHP Code:


			
<?php

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")."\");");

?>

Almax1 · #3 09-17-2003, 06:21 PM

Parse error: parse error in /xxx/xxx/xxx/topp.php on line 15

had tried that bit of code earlier already

thanks for trying though

any clues ??

filburt1 · #4 09-17-2003, 06:25 PM

Quote:

Originally Posted by Almax1

Parse error: parse error in /xxx/xxx/xxx/topp.php on line 15

had tried that bit of code earlier already

thanks for trying though

any clues ??

You're missing a closing brace for the loop. If you indent this way, it is far easier to read:

PHP Code:


			
while ($topposters = mysql_fetch_array($postsresult))

{

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

    { 

        $bc=$bc1; 

    }

    else

    { 

        $bc=$bc2; 

    }

}

Almax1 · #5 09-17-2003, 06:50 PM

No joy filburt1

inserted this code

PHP Code:


			
<?php 



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")."\");"); 

?>

result= Unable to complete query

could this be the template ??

filburt1 · #6 09-17-2003, 06:55 PM

Quote:

Originally Posted by Almax1

No joy filburt1

inserted this code

PHP Code:


			
<?php 



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")."\");"); 

?>

result= Unable to complete query

could this be the template ??

Don't include a semicolon in the query; only do that in the mysql command-line client.

Almax1 · #7 09-17-2003, 07:10 PM

Thanks for your time filburt1
i took the semicolon out from the end of the query with no joy

Almax1 · #8 09-17-2003, 07:53 PM

stuck completley now
/me *cries* for HELP :P

Logician · #9 09-18-2003, 09:24 AM

assign a value for "$maxposters". It is blank in your code so query has a syntax error.

Almax1 · #10 09-18-2003, 11:51 AM

Thanks Logician but still no luck

changed the code to this

PHP Code:


			
<?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")."\");"); 

?>

Fatal error: Call to undefined function: gettemplate() in /xxx/xxx/xxx/xxx/xxx/topp.php on line 28

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08972 seconds Memory Usage 4,761KB 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 (6)bbcode_php (2)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: