this should be very simple.....

[FWC]

Originally posted by TaP
same error..... cant you show a complete peice? im still a bit confused

This will give you the ten most replied to threads in forum 14:

SELECT postuserid,postusername,replycount FROM thread WHERE forumid=14 ORDER BY replycount DESC LIMIT 10

I am not sure what you are really looking for, though.

[TaP]

ok that worked i dont get error any more

but in the templates when i add

$top10thread

it doesnt show any thing

i also tried

$top10thread[posts]

[FWC]

OK, before we go any further. What exactly are you trying to do? What do you want a top ten list of?

[mr e]

Well until my forum is back up I'm kind of guessing here, but try this.

PHP Code:

// Top 10 Posters in a certain thread 
$top10 = $DB_site->query('SELECT postuserid,forumid,postusername,posts FROM thread WHERE forumid = # ORDER BY posts DESC LIMIT 10'); 
while ($top10thread = mysql_fetch_array($top10)): 
++$top10threadnbsp; 
$top10name .= "? <a href=member.php?s=$session[sessionhash]&action=getinfo&userid=$top10thread[userid]>$top10thread[username]</a><br>"; 
$top10post .= "$top10thread[posts]<br>"; 
endwhile; 
// End Top 10 Posters in a certain thread 


Then put $top10post and $top10name on your index.php

[TaP]

v

[TaP]

Database error in vBulletin 2.2.4:

Invalid SQL: SELECT postuserid,forumid,postusername,posts FROM thread WHERE forumid = # ORDER BY posts DESC LIMIT 10
mysql error: You have an error in your SQL syntax near '' at line 1

[TaP]

»
»

is what i get were i inserted the $top10post and $top10name

[mr e]

Well the "forumid = #" part you have to put in the number of the forum id you want it to use.

[TaP]

i did and i got the above..... is there any way you can just make the first hack on the back on the first page incorperate into the second hack?