The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#11
|
|||
|
|||
no
I get this error Database error in vBulletin 2.2.5: Invalid SQL: SELECT userid AS users,MAX(userid) AS max FROM user mysql error: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause mysql error number: 1140 |
#12
|
|||
|
|||
any ideas?
|
#13
|
||||
|
||||
Quote:
PHP Code:
|
#14
|
|||
|
|||
^^^^ That gives me users = 0 ..
|
#15
|
||||
|
||||
After adding the line, you should use this variable in your templates:
$numbersmembers['max'] |
#16
|
|||
|
|||
tried it .. still showed "0"
|
#17
|
||||
|
||||
If you add the line:
PHP Code:
PHP Code:
|
#18
|
|||
|
|||
Quote:
i get this error on my index.php i use Code:
Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' here is what i got in my index.php Code:
// get total posts ever $count_maxx_posts=$DB_site->query_first('SELECT postid AS posts FROM post ORDER BY postid DESC LIMIT 1' ); $count_maxx_posts=number_format($count_maxx_posts['posts']); $count_maxx_threads=$DB_site->query_first('SELECT threadid AS threads FROM thread ORDER BY threadid DESC LIMIT 1'); $count_maxx_posts=number_format($count_maxx_threads['threads']); |
#19
|
||||
|
||||
Quote:
$count_maxx_threads=$count_maxx_threads+1000; also make sure you dont get the error because of any other line in your code.. I strongly believe if you use only this code in index.php and $count_maxx_threads and $count_maxx_posts in forumhome template, you will not get ant errors.. |
#20
|
||||
|
||||
NONE of this works for 2.2.8
for the MEMBERS part have the Post counts working..need a working members count..600 members got removed acidentaly |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|