![]() |
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 ? |
*Sigh*
I guess I need to use a table prefix on my test forums so that I can easily check for propperly compatable queries. Updated activity.php with AS phrases. |
Cool hack .. installed on 3.0.6 with only a few problems.
Had to set it up showing information as text .. the images provided are in the buttons directory but refuse to show. Problem solved .. had to place button in my skin, button directory .. duh Clicked install :) |
Just a question, can the activty percent..be used to enable promotions?
Is there a way to do that? Thank you |
No, it cannot.
|
Thank you
|
Will this work on 3.0.8 ?
Will it show how manu active users i have had ix X (variable) days/weeks ? |
This should work on 3.0.8
|
Quote:
Thanks for that answer What about my second question active users in X days/weeks ? |
This hack doesn't do that, but WW did create a small custom mod on his site. http://zelaron.com/forum/zelstat.php?num=50
|
great works for 3.0.9 one thing to point out is that..when images are enabled to show it looks for longevityX.gif instead of longX.gif
other than that great one! thanks |
I Want to use the image bars files but i dont know what i have to do so, any help?
|
Quote:
|
I tried to install, accessing acthackinstall.php results in a blank page on vbulletin 3.6.4.
Can someone make this into a product working on 3.6.x? Joe |
Quote:
|
All times are GMT. The time now is 04:42 PM. |
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:
|