The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#11
|
||||
|
||||
Quote:
Code:
SELECT postuserid,postusername,replycount FROM thread WHERE forumid=14 ORDER BY replycount DESC LIMIT 10 |
#12
|
|||
|
|||
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] |
#13
|
||||
|
||||
OK, before we go any further. What exactly are you trying to do? What do you want a top ten list of?
|
#14
|
||||
|
||||
Well until my forum is back up I'm kind of guessing here, but try this.
PHP Code:
|
#15
|
|||
|
|||
v
|
#16
|
|||
|
|||
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 |
#17
|
|||
|
|||
»
» is what i get were i inserted the $top10post and $top10name |
#18
|
||||
|
||||
Well the "forumid = #" part you have to put in the number of the forum id you want it to use.
|
#19
|
|||
|
|||
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?
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|