vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   The Activity Hack v2.1 (https://vborg.vbsupport.ru/showthread.php?t=73145)

WetWired 05-12-2005 02:22 AM

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.

GrusPer 05-12-2005 02:37 PM

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

GrusPer 05-12-2005 11:59 PM

Anybody help me ? pl ppl :)

WetWired 05-14-2005 06:44 AM

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.

GrusPer 05-14-2005 08:54 PM

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:

WetWired 05-15-2005 03:51 AM

Updated again. Apparently I missed the TABLE_PREFIXes on the joins. It should work now.

GrusPer 05-15-2005 06:49 PM

Cool thx - all works :)
big thx WetWired

GrusPer 05-16-2005 04:12 AM

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

Marco van Herwaarden 05-16-2005 09:07 AM

In your activity.php, find:
PHP Code:

      $visitlog=$DB_site->query_first("SELECT COUNT(*) AS num FROM '.TABLE_PREFIX.'post LEFT JOIN '.TABLE_PREFIX.'thread on post.threadid=thread.threadid LEFT JOIN '.TABLE_PREFIX.'forum on thread.forumid=forum.forumid WHERE ((forum.options&$_FORUMOPTIONS[countposts]))AND(post.userid=".$userid.")AND(post.dateline>=".($checkend-($days+1)*ACTHACK_ONE_WEEK).")AND(post.dateline<".($checkend-$days*ACTHACK_ONE_WEEK).")"); 

and replace by:
PHP Code:

      $visitlog=$DB_site->query_first("SELECT COUNT(*) AS num FROM '.TABLE_PREFIX.'post AS post LEFT JOIN '.TABLE_PREFIX.'thread AS thread on post.threadid=thread.threadid LEFT JOIN '.TABLE_PREFIX.'forum AS forum on thread.forumid=forum.forumid WHERE ((forum.options&$_FORUMOPTIONS[countposts]))AND(post.userid=".$userid.")AND(post.dateline>=".($checkend-($days+1)*ACTHACK_ONE_WEEK).")AND(post.dateline<".($checkend-$days*ACTHACK_ONE_WEEK).")"); 

Find:
PHP Code:

        $poststoday=$DB_site->query_first('SELECT COUNT(*) AS num FROM '.TABLE_PREFIX.'post LEFT JOIN '.TABLE_PREFIX.'thread on post.threadid=thread.threadid LEFT JOIN '.TABLE_PREFIX.'forum on thread.forumid=forum.forumid WHERE ((forum.options&'.$_FORUMOPTIONS[countposts].'))AND(post.userid='.$post['userid'].')AND(post.dateline>='.$startofday.')'); 

and replace by:
PHP Code:

        $poststoday=$DB_site->query_first('SELECT COUNT(*) AS num FROM '.TABLE_PREFIX.'post AS post LEFT JOIN '.TABLE_PREFIX.'thread AS thread on post.threadid=thread.threadid LEFT JOIN '.TABLE_PREFIX.'forum AS forum on thread.forumid=forum.forumid WHERE ((forum.options&'.$_FORUMOPTIONS[countposts].'))AND(post.userid='.$post['userid'].')AND(post.dateline>='.$startofday.')'); 


GrusPer 05-16-2005 11:48 AM

$poststoday=...........

And what picture should be in
today1.gif ?

WetWired 05-16-2005 12:30 PM

*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.

TTG 06-07-2005 10:20 PM

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 :)

dcarr 08-13-2005 08:23 PM

Just a question, can the activty percent..be used to enable promotions?
Is there a way to do that? Thank you

WetWired 08-13-2005 09:46 PM

No, it cannot.

dcarr 08-13-2005 10:32 PM

Thank you

Anonymous999 08-26-2005 05:31 PM

Will this work on 3.0.8 ?

Will it show how manu active users i have had ix X (variable) days/weeks ?

Logikos 08-26-2005 05:51 PM

This should work on 3.0.8

Anonymous999 08-26-2005 05:54 PM

Quote:

Originally Posted by Live Wire
This should work on 3.0.8


Thanks for that answer

What about my second question active users in X days/weeks ?

Logikos 08-26-2005 07:37 PM

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

adill420 10-06-2005 11:51 PM

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

panraf 11-14-2005 08:56 PM

I Want to use the image bars files but i dont know what i have to do so, any help?

WetWired 11-14-2005 09:12 PM

Quote:

Originally Posted by panraf
I Want to use the image bars files but i dont know what i have to do so, any help?

First, DL the images and put them in the "Button images" folder for each style that will use them; you'll need to rename them from longx.gif to longevityx.gif. You can find out where this is by selecting "Stylevars" from the drop down next to the style. After that, follow the install instructions under "TEMPLATES FOR INFORMATION AS IMAGES" instead of following the instructions under "TEMPLATES FOR INFORMATION AS TEXT". You will, of course, need to follow the code modification instructions and run the installer if you havn't already.

jarosciak 01-10-2007 11:59 PM

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

WetWired 01-12-2007 12:03 PM

Quote:

Originally Posted by First line of first post
There will be no additional releases of the vB3/hack version; this mod has moved on to vB3.5 as a plugin (see here)

This is the thread for the vB3.0 version. You want the 3.5 version indicated in the link in the first post, and yes it works fine with 3.6.


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
  • Page Generation 0.01148 seconds
  • Memory Usage 1,779KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (24)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete