![]() |
This is a setting in the options.
AdminCP>vBulletin Options>Activity Hack>Find today's activity for all users If you don't put the ranktext part into the memberinfo or postbit templates, then noone will see or be affected by the ranking system. |
Greetings
Has put this code But at me the problem with date base writes that At me date the base is with Prefix\Table vb3_mos_ ****** That to me to do what to correct a code ================ Database error in vBulletin 3.0.5: Invalid SQL: UPDATE user SET activity='54',activitydate='1115856000' WHERE userid=127 mysql error: Table 'grusper_ryzom.user' doesn't exist mysql error number: 1146 |
Anybody help me ? pl ppl :)
|
I have updated the activity.php in the original post. Redownload this file and upload it to your server, and the problem should go away.
|
Database error in vBulletin 3.0.5:
Invalid SQL: SELECT COUNT(*) AS num FROM vb3_mos_post LEFT JOIN thread on post.threadid=thread.threadid LEFT JOIN forum on thread.forumid=forum.forumid WHERE ((forum.options&4096))AND(post.userid=1)AND(post.d ateline>=1116028800) mysql error: Table 'grusper_ryzom.thread' doesn't exist mysql error number: 1146 :disappointed: :cry: |
Updated again. Apparently I missed the TABLE_PREFIXes on the joins. It should work now.
|
Cool thx - all works :)
big thx WetWired |
no :( no cool :)
on bug here ---- At attempt of viewing of a subject where ALREADY there is YOUR answer base gives out a mistake. ---------- Database error in vBulletin 3.0.5: Invalid SQL: SELECT COUNT(*) AS num FROM vb3_mos_post LEFT JOIN vb3_mos_thread on post.threadid=thread.threadid LEFT JOIN vb3_mos_forum on thread.forumid=forum.forumid WHERE ((forum.options&4096))AND(post.userid=117)AND(post .dateline>=1116201600) mysql error: Unknown table 'forum' in where clause mysql error number: 1109 |
In your activity.php, find:
PHP Code:
PHP Code:
PHP Code:
PHP Code:
|
$poststoday=...........
And what picture should be in today1.gif ? |
All times are GMT. The time now is 05:18 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|