PDA

View Full Version : Miscellaneous Hacks - Activity Modification


Pages : 1 [2]

simmer1974
01-12-2009, 07:31 PM
i am using it with 3.80 have not found any problems yet

Works fine with me too...

lostguy
01-12-2009, 10:19 PM
postbit_legacy (default location)

find
<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon] $post[skypeicon]</div>

above it, insert

$WWU002_statblock

After i done add this..I have Double Stats ..! 2 rows .

Can anyone help and why ?

postbit_legacy (alternate location) < Should i add this options too ? Cause i already did the default setting .

WetWired
01-13-2009, 02:03 AM
Did you turn off the automatic alteration? The manual edits are for if you have trouble with the automatic ones and need to turn them off.

lostguy
01-13-2009, 03:44 AM
Seriouslly no idea what is alteration ...I have forum with Skin too..Should i manual edit those ? If i didnt edit those manual postbit will effect it ?

lg

WetWired
01-13-2009, 11:31 AM
The mod automatically performs all the inserts using template hooks unless you tell it not to in Display Settings under Activity Settings. The instructions for manual modification are for users who have styles without hooks, who have styles the JS doesn't like and want the alternate location, or who plan to see what the changes are and do it a bit diffferently. In all cases, they need to go to the Activity Display Settings and set "Automatic postbit alteration" to none.

KempoMRK
01-13-2009, 10:38 PM
I just upgraded to vB 3.8.0 and now the Stats link in the navbar has a blue background for some reason.

Is it possible to fix this?

WetWired
01-14-2009, 11:24 AM
The stats template probably just doesn't match your navbar template. If you could attach your navbar template, I can try to figure out what needs to change.

KempoMRK
01-14-2009, 12:53 PM
Ah, nice, that's appreciated.

Ok, I put it in a text file and attached it.

WetWired
01-15-2009, 01:31 AM
Your navigation links aren't in your navbar template where they belong, apparently. You'll need to find them by using the search in templates feature to find the template containing$template_hook[navbar_buttons_left], then post it.

flup
01-23-2009, 09:56 AM
Looks good :) Definitly a way to kinda push people to post more and get their bars full :D

XanderZone
01-24-2009, 10:37 PM
Will you upgrade this product for 3.8.x?
I would love to use it on my forums.

Joppe111
01-28-2009, 05:59 PM
I was attempting to upgrade from 2.8 on a 3.8 board to 3.03.


Whenever I try to import the product (with overwrite set to yes) I get this MySQL error:


Database error in vBulletin 3.8.0:

Invalid SQL:
ALTER TABLE `vb_user` ADD `wwu002activity` INT UNSIGNED NOT NULL ,
ADD `wwu002activitydate` INT UNSIGNED NOT NULL ,
ADD `wwu002memberlevel` TINYINT UNSIGNED DEFAULT "1" NOT NULL ,
ADD `wwu002fullmemberdate` INT UNSIGNED NOT NULL ,
ADD `wwu002lastvisit` INT UNSIGNED NOT NULL;

MySQL Error : Duplicate column name 'wwu002activity'
Error Number : 1060
Request Date : Wednesday, January 28th 2009 @ 01:58:51 PM
Error Date : Wednesday, January 28th 2009 @ 01:58:51 PM
Script : http://www.experiencefestival.com/3_8_dev/admincp/plugin.php?do=productimport
Referrer : http://www.experiencefestival.com/3_8_dev/admincp/plugin.php?do=productadd
MySQL Version : 4.1.22-log

dmknights
01-28-2009, 06:04 PM
this i will install later

HaS?R
01-29-2009, 01:58 AM
Thanks.

WetWired
02-02-2009, 11:49 AM
I was attempting to upgrade from 2.8 on a 3.8 board to 3.03.
Whenever I try to import the product (with overwrite set to yes) I get this MySQL error:
This means that for some reason, vB thinks you do not have the mod installed already when you do.

The attached file has the install code removed so you can upgrade from 2.8 to 3.03. This file is for update only and cannot perform a new install!

Ethelbert
02-07-2009, 12:17 PM
I have a problem > please check it> http://www.vb.verejnadiskusia.sk/showthread.php?t=309
why is this happenig? When this mod is disabled, everything looks good.

Thank you

Fynnon
02-09-2009, 01:12 PM
This is a must have mod so i installed it on vB 3.8.0 and it seems to work ok only sometimes it displays the data above the mod picture like in the screenshot i took:

94461

zorag
02-11-2009, 02:53 PM
On the Top Activity page is there any way to include the previous 3 months of data (in 3 links Dec, Jan, Feb) - I'm more than willing to pay for this function.

WetWired
02-11-2009, 05:03 PM
I have a problem > please check it> http://www.vb.verejnadiskusia.sk/showthread.php?t=309
why is this happenig? When this mod is disabled, everything looks good.

Thank you
This is a problem with the style you are using. It would seem the style places the template hook where this mod adds its information outside any cells.

I suggest editing your postbit_legacy template.
Find
$template_hook[postbit_userinfo_right]
Replace with
<tr><td colspan="2">$template_hook[postbit_userinfo_right]</td></tr>

WetWired
02-11-2009, 05:07 PM
This is a must have mod so i installed it on vB 3.8.0 and it seems to work ok only sometimes it displays the data above the mod picture like in the screenshot i took:Most likely this is due to a JS error preventing the JS that moves the information from running correctly. If this is a major annoyance, there are instructions for manually changing your postbit template so JS is not required in activity_mod_customization.html in the zip file, at the bottom of the file. You would want to follow the changes for "postbit_legacy (alternate location)", then set Activity Display Settings->Automatic postbit alteration to None

WetWired
02-11-2009, 05:28 PM
On the Top Activity page is there any way to include the previous 3 months of data (in 3 links Dec, Jan, Feb) - I'm more than willing to pay for this function.
I'm not sure what exactly you want. If you want separate lists for separate months, a skilled modder should have little trouble converting the "Top Activity" "forumhome_start" hook into a standalone PHP file providing the functionality you want. Key points for the modder are: The current code contains optimizations to exclude people that could not appear in the top X; these optimizations are completely irrelevent to this task and will need to be removed for proper functioning The $WWU002startOfDay and $WWU002startOfCycle variables are used in the queries for determining when the data is relative to. startOfDay should be at midnight GMT of the relevant day; startOfCycle should be adjusted based on the activity mod time zone setting. The caching of the data will obviously need to be done differently. Realisticly, each month needs only be calculated once and stored.

I have no intention of adding this feature to the mod because I do not believe that referencing activity levels at discrete points in time (other than the present) is of great value. I do not do commission work. I hope that the information I have provided is sufficent for you to get a good result from someone who does.

ilovevbull
02-12-2009, 08:49 PM
I didn't know once you installed this,it would get rid of how many post my members had is there anyway i can get that back AND still have the activity modification?

WetWired
02-12-2009, 10:32 PM
This mod displays that number itself. You can tell it to leave the old number from the display settings.

lussos
03-02-2009, 02:26 PM
Is there a way of removing certain usergroups in the "Activity Page"? example: banned user groups.

WetWired
03-03-2009, 07:29 AM
Currently there is not, though obviously a banned member's activity will fall.

I assume that this is an automated news poster you're trying to deal with? If it always posts in the same forum, you can make posts in that forum not count to reduce activity level.

I suppose it would be easy enough to add some sort of usergroup check, though it would disturb the optimizations that prevent checking everyone's activity each day for the list.

adamskiii
03-05-2009, 11:50 PM
Hi there. I just need some help. I have installed successfully :D and want to change the location so the mod shows up right under my avatar. I added the code in the postbit legacy template but now I get two of the mods showing up. One in the default location and the other showing up under my avatar. Could you please help me fix this so I only have the one under the avatar showing up?

Thanks

adamskiii
03-07-2009, 05:58 PM
I got it to work under the avatar :D, just one more thing, how do I make a box around it in the postbit_legacy?

thanks

WetWired
03-07-2009, 06:53 PM
I suppose you could wrap it in<div style="border:1px solid black"></div>

adamskiii
03-07-2009, 06:58 PM
where would I add the code? I am not good at coding things, :P

thanks

WetWired
03-09-2009, 04:22 AM
Arround what you added to move what you moved.

BigJohnny
03-10-2009, 11:00 AM
Thanks for this cool mod! Features Request:

1. Enable finding today's activity in postbit for specific usergroups. This would be allow only special groups (ie: VIPs) to have their activity calculated so the # of extra queries in showthread would be limited.

2. Display Visit Activity% and Post Activity% in the Activity Statistics page.

3. Enable activity points to be given for profile visitor messages and social group messages, and display activity %'s for them in the statistics page.
I have to second these ideas..... that would be great if it could be done.

I suppose you could wrap it in<div style="border:1px solid black"></div>

You should also be able to just use:

<div class="info">code</div>


I think vbulletin has that setup by default, and it will add a box around stuff in the postbit.

I could be wrong though, i might just have it defined due to my styles.

vidan
03-13-2009, 02:02 PM
i got Warning: unserialize() expects parameter 1 to be string, array given in [path]/index.php(67) : eval()'d code on line 21 in index.php?do=activitystat
im using 3.8.1 pl1

anyone got the same message too?

RTMdotORG
03-29-2009, 04:01 PM
todays activity only works for my username...everyone elses is not moving up, and ideas?

WetWired
03-31-2009, 01:10 AM
It's off by default because it brings a large load increase. You need to enable "Find today's activity for all users"

luckid
04-03-2009, 03:06 PM
On profile user not appare location but only: Current Activity: Viewing home page :confused:

This error on: VB 3.81 and 3.82

Tnx in advance for you reply ;)

WetWired
04-08-2009, 12:23 PM
I'm not sure I understand. You're saying that when a user is viewing a user profile that they show as viewing the home page on the who's online?

Are you sure this mod is responsible? I don't do anything that should effect the locations there.

Also note that it will display that location when the location isn't known, such as when an AJAX script or dynamic image script runs if it isn't properly setup not to show in the who's online. Since AJAX scripts and images are loaded after the main page, these would clobber the location.

Silver Tiger
04-14-2009, 04:10 PM
I installed it, but I can't get the images to show up. I see the stuff in the post bit, but the images don't show up.

WetWired
04-15-2009, 03:33 AM
Did you put the images in the correct place? It's a different place for each style. Right click the broken image and get the path where the browser is looking from the properties. That should help you figure out where the images belong.

robby-gr
04-28-2009, 09:08 AM
Hello I need a help if someone have the experience of this happen.
When I am pressing stats on the navbar I am getting this error on the top of the statistic page:
Warning: unserialize() expects parameter 1 to be string, array given in [path]/index.php(67) : eval()'d code on line 79
I am appreciated for any idea or help
Thanks
Robby-gr

WetWired
04-28-2009, 11:32 AM
Are you using the default datastore code, or are you using memcache or another alternative?
What vB version are you using?

robby-gr
04-28-2009, 11:48 AM
Hello WetWired thanks for reply me.
I use VB3.8.2 and xcache and you have right!! I disabled the vB_Datastore_XCache and came back to vbulletin default vB_Datastore_Filecache and now is working ok.
But if you know (neither no):) a way to work with xcache too I will appreciated you, so much.
With respect
Robby

EmilGH
05-03-2009, 03:51 PM
Hey -- GREAT mod -- it's become the lifeblood of a site I co-run. Two quick questions:

1. Is there a way to modify the "Top Activity" page to show last login instead of join date?

2. Is there a way to modify the "Top Activity" page to hide banned users (or users that are in a specific usergroup)?

We have an activity-based site, and when people fall below a certain activity level they get put into an inactive group. I'd like to be able to hide those folks from the top activity page so we see only the actives.

Thanks!

dbirosel
05-03-2009, 07:43 PM
Is this compatible with v3.8 yet? I would love to use this mod.

WetWired
05-04-2009, 04:38 AM
Hey -- GREAT mod -- it's become the lifeblood of a site I co-run. Two quick questions:

1. Is there a way to modify the "Top Activity" page to show last login instead of join date?

2. Is there a way to modify the "Top Activity" page to hide banned users (or users that are in a specific usergroup)?

We have an activity-based site, and when people fall below a certain activity level they get put into an inactive group. I'd like to be able to hide those folks from the top activity page so we see only the actives.

Thanks!The problem with mucking with the top activity is that when you do it, the optimization to prevent checking everyone's activity breaks... since you are interested in the activity of a limited group of people, perhaps that is something you can deal with.

in the plugin marked "Top Activity" (for forumhome), find
//****************************************
// How old are we? how many users do we need to process?
if(MAX_NUM==0){
$querylimit=1;
}else{//(MAX_NUM==0)
$daysold=($WWU002startOfDay-$statdata[0])/WWU002_ONE_DAY;
if(($daysold>=($vbulletin->options['WWU002weeks']*3.5))||($_REQUEST['oldway'])){
//A complete reversal of activity is possible in this time period, we must check everyone
$querylimit='1';
}else{//($daysold>=($vbulletin->options['WWU002weeks']*3.5))
//What is the lowest activity that could surpass the lowest activity on the old list?
$acc=0;
DEVDEBUG('Days old='.$daysold);
for($i=1;$i<=$daysold;$i++){
$acc+=$WWU002maxDay*$WWU002weekWeights[floor($i/7)];
}//endfor($i=1;$i<$daysold;$i++)
$temp=$statdata[1];
$temp=array_pop($temp);
DEVDEBUG('Activity lower limit='.$temp[3].'-'.($acc*2).'='.($temp[3]-($acc*2)));
$acc=$temp[3]-($acc*2);
if($acc<=0){
//just use the simple where clause
$querylimit='1';
}else{//($acc<=0)
$querylimit='wwu002activity>='.$acc;
}//endif($acc<=0)
}//endif($daysold>=($vbulletin->options['WWU002weeks']*3.5))
}//endif(MAX_NUM==0)

replace with
$querylimit='usergroupid<>100';

This should (I'm not testing any of this) remove the optimization and instead only include people whose primary group is not group 100.

For the date thing, I think you should be able to
find (in the same plugin)
$longresult=$db->query_read('SELECT userid,username,joindate FROM '.TABLE_PREFIX.'user WHERE userid IN ('.$ids.')');
and replace with
$longresult=$db->query_read('SELECT userid,username,lastvisit AS joindate FROM '.TABLE_PREFIX.'user WHERE userid IN ('.$ids.')');

WetWired
05-04-2009, 04:39 AM
Is this compatible with v3.8 yet? I would love to use this mod.It's my understanding that it is.

robby-gr
05-04-2009, 06:22 AM
Hello WetWired can you drop me one line answer?

I use VB3.8.2 and xcache and you have right!! I disabled the vB_Datastore_XCache and came back to vbulletin default vB_Datastore_Filecache and now is working ok.
But if you know (neither no) a way to work with xcache too I will appreciated you, so much.
With respect
Robby

WetWired
05-04-2009, 01:34 PM
I don't know anything about xcache or why it messes up the top activity caching. The error you gave was related to the datastore, so that was the prime suspect. TBH, if you're getting that error I'm not sure how anything can work on your forum, since everything uses the datastore. The top activity uses it in a non-standard way, though, since the usual way would require a separate file for the top activity page.

There are two relatively easy ways to solve the problem: Don't cache the top activity information This is a very simple edit, but probably not one you'd want to make, as you'd be re-calculating the activity for the entire forum with each view. Roll the updates back into the standalone file version (https://vborg.vbsupport.ru/showthread.php?t=123860) While straight forward, this would still take some time to do. Ideally, this would include changes to the rest of the mod to allow the administrator to choose whether or not to use the external file.

The third option would be to find out what xcache is doing, but as I said I know nothing about it.

robby-gr
05-05-2009, 01:37 PM
Hello WetWired thanks for your answering me.
I understud these you wrote me.
I dont have other problems using xcache, datastore is working ok.
I will search and make some other combinations to find a way to work with xcache without this message on the top of page, I hope to find an answer :)
I like your mod very much, is good clever and clean job.
Thanks a lot.
Robby

EmilGH
05-05-2009, 03:49 PM
The problem with mucking with the top activity is that when you do it, the optimization to prevent checking everyone's activity breaks... since you are interested in the activity of a limited group of people, perhaps that is something you can deal with.

in the plugin marked "Top Activity" (for forumhome), find
//****************************************
// How old are we? how many users do we need to process?
if(MAX_NUM==0){
$querylimit=1;
}else{//(MAX_NUM==0)
$daysold=($WWU002startOfDay-$statdata[0])/WWU002_ONE_DAY;
if(($daysold>=($vbulletin->options['WWU002weeks']*3.5))||($_REQUEST['oldway'])){
//A complete reversal of activity is possible in this time period, we must check everyone
$querylimit='1';
}else{//($daysold>=($vbulletin->options['WWU002weeks']*3.5))
//What is the lowest activity that could surpass the lowest activity on the old list?
$acc=0;
DEVDEBUG('Days old='.$daysold);
for($i=1;$i<=$daysold;$i++){
$acc+=$WWU002maxDay*$WWU002weekWeights[floor($i/7)];
}//endfor($i=1;$i<$daysold;$i++)
$temp=$statdata[1];
$temp=array_pop($temp);
DEVDEBUG('Activity lower limit='.$temp[3].'-'.($acc*2).'='.($temp[3]-($acc*2)));
$acc=$temp[3]-($acc*2);
if($acc<=0){
//just use the simple where clause
$querylimit='1';
}else{//($acc<=0)
$querylimit='wwu002activity>='.$acc;
}//endif($acc<=0)
}//endif($daysold>=($vbulletin->options['WWU002weeks']*3.5))
}//endif(MAX_NUM==0)

replace with
$querylimit='usergroupid<>100';

This should (I'm not testing any of this) remove the optimization and instead only include people whose primary group is not group 100.

For the date thing, I think you should be able to
find (in the same plugin)
$longresult=$db->query_read('SELECT userid,username,joindate FROM '.TABLE_PREFIX.'user WHERE userid IN ('.$ids.')');
and replace with
$longresult=$db->query_read('SELECT userid,username,lastvisit AS joindate FROM '.TABLE_PREFIX.'user WHERE userid IN ('.$ids.')');

All worked perfectly -- thanks!!!

WetWired
05-06-2009, 03:42 AM
Hello WetWired thanks for your answering me.
I understud these you wrote me.
I dont have other problems using xcache, datastore is working ok.
I will search and make some other combinations to find a way to work with xcache without this message on the top of page, I hope to find an answer :)
I like your mod very much, is good clever and clean job.
Thanks a lot.
Robby
Try this:
Upload the attached file to your forum directory and access activitystat.php with xcache on. See if it works without giving an error message. If it doesn't give an error message, I will follow up with the template changes to integrate it propperly.

lav0s
05-09-2009, 04:28 PM
any chance we see this mod as a 3.8 mod??

WetWired
05-09-2009, 11:17 PM
From what I'm told, it works fine with 3.8.

hinomaru
05-12-2009, 03:07 AM
hello Wetwired,

i have the different show statistic of "Today Activity" between member list page and showtrhread page...
At the memberlist page,the "Today activity" Show zero bar...but at the showthread page show 1 bar...
What wrong with my setting?

WetWired
05-12-2009, 11:20 AM
You must manually enable showing activity for each location in the Activity Display settings page.

algert
06-12-2009, 09:23 AM
Can you give me the link of the activity page, as I just changed my forum's theme, and its not showing on the nav bar anymore, so i suppose i think i should add it manually.. in the navbar templates.

Thanks

Edited:- anyway got it fixed. thanks

mallutribes
07-09-2009, 06:08 PM
Installed and working... but there is a problem with me..

How can change color of texts Activity, longetivity, Today & Posts.. since my back ground is white. i need to change this to black or something..

WetWired
07-13-2009, 12:20 PM
Installed and working... but there is a problem with me..

How can change color of texts Activity, longetivity, Today & Posts.. since my back ground is white. i need to change this to black or something..

You used the wrong set of images. There is one for dark backgrounds and one for light backgrounds.

alexan1252
07-20-2009, 03:50 PM
can somebody tell me, where i upload the folders light and dark please?

i dont know where's it

WetWired
07-22-2009, 04:51 AM
Why don't the images don't show up?/Why does the postcount have 's's in front of it?
Be sure to upload one of the activity directories from activityimages.zip to the misc directory for each of your styles. To find a style's misc directory, goto the Style Manager, then from the dropdown next to the style, choose Stylevars. The setting Miscellaneous Images Folder contains the path to that style's misc directory, where you need to upload the activity directory
The location depends on (and is different for each) the style you are using. Follow the instructions above to find the correct location. Alternately, in most browsers, you can right click the missing image, choose properties, and it will tell you where it is looking, which will help you figure it out.

MrSir
07-24-2009, 11:18 PM
i have this product running on 3.8.2...everything seems to be working, however no one is getting promoted after the initial calculation of stats b/c the stats are not updating. the cron is set for once an hour, and it has been installed for a few hours now. i have also tried to manually do the memberlevel promotions...but no luck.

i am running it for a contest, and set the start of board time at noon on thursday.

WetWired
07-25-2009, 07:19 AM
The cron? There is no cron.

The stats update once a day. The amount that activity can rise in a day is limited; that's the point of this mod: you can't artificially raise the activity figure in one day, you must be continually active.

Also, the start of board time only effects longevity, which is how long a user has been a member compared to how long the forum has been arround.

Brathamike
07-26-2009, 06:44 PM
Nice mod and thanks for answering everyones questions. Need more customer service like you..

Good job i like this mod works nice

Also how did you put your mod in the table that is shown on ur sig?

MrSir
07-27-2009, 12:51 AM
thanks wetwired.

Brathamike
07-28-2009, 04:14 AM
Hello i was wondering if this is correct. When i put my cursor over "Post" it dosent show post count it only shows a letter "s". Should this give me a post count?

spartan1123
08-03-2009, 01:18 AM
Will this mod run in x3.8?

WetWired
08-03-2009, 01:41 PM
Hello i was wondering if this is correct. When i put my cursor over "Post" it dosent show post count it only shows a letter "s". Should this give me a post count?
The postcount should be composed of several images, one for each digit. The alternate text for each image is the part of the image name that changes; spacer digits are indicated with "s". Originally, there was no tooltip, but some people complained about validation problems (in valid HTML, all images have alt attributes).

WetWired
08-03-2009, 01:42 PM
Will this mod run in x3.8?
Yes, it runs on vB3.8 with no known issues.

spartan1123
08-04-2009, 12:48 PM
Yes, it runs on vB3.8 with no known issues.

Good stuff, installed.

Zaki Shafqat
08-06-2009, 06:19 PM
i didn't understand where to upload the images folder?

somebody help please

WetWired
08-07-2009, 09:08 PM
Inside the zip file, there are two folders, "light" and "dark". You want to put the "activity" folder from the one that describes your site's style (light styles use the light folder) in the "misc" folder for the style that you are using. If you are using the default style, this would be forum/images/misc . Otherwise, it should be pretty easy to figure out by right clicking where the images should be in the postbit, going to properties, and looking at where the browser is trying to get the image; upload the activity folder in the place where the browser will find the images where it is looking.

davoodblack
08-12-2009, 06:25 PM
very thanks for this usefull Mods...

i install this mode but when i go to index of forum got this error


Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT unid FROM vb_wwu002visitlog WHERE (userid="1")AND(dateline="1250035200") LIMIT 1;

MySQL Error : Table 'bootiran_bootiran.vb_wwu002visitlog' doesn't exist
Error Number : 1146
Request Date : Wednesday, August 12th 2009 @ 11:50:39 PM
Error Date : Wednesday, August 12th 2009 @ 11:50:39 PM
Script : http://www.bootiran.org/forum/
Referrer :
IP Address : 91.99.224.64
Username : __DavoodBlack__
Classname : vB_Database
MySQL Version : 5.0.81-community-log

Sunka
08-13-2009, 08:27 AM
Hi WetWired,

Today this database error come to my e-mail.
What is wrong?

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT count(*) as num,floor((1250121599-dateline)/604800) as week FROM wwu002visitlog WHERE (userid=994)AND(dateline>=1246492800) GROUP BY week ORDER BY week;

MySQL Error : Can't open file: './pijanitv_vbulletin/wwu002visitlog.frm' (errno: 24)
Error Number : 1016
Request Date : Thursday, August 13th 2009 @ 01:11:44 AM
Error Date : Thursday, August 13th 2009 @ 01:11:48 AM
Script : http://www.pijanitvor.com/forum/showthread.php?t=824
Referrer : http://www.google.com/url?sa=t&source=web&ct=res&cd=4&url=http%3A%2F%2Fwww.pijanitvor.com%2Fforum%2Fshow thread.php%3Ft%3D824&ei=4EqDSsqfL8iGsAbLnZHQCQ&rct=j&q=primame+i+mamci+za+amura+na+jezerima&usg=AFQjCNFrr9U-km__kfO2nE-vfRALqjsfIw
IP Address : *******
Username : Unregistered
Classname : vB_Database
MySQL Version :

davoodblack
08-14-2009, 08:04 PM
no one not Help ME???????????????????????

WetWired
08-17-2009, 03:47 AM
very thanks for this usefull Mods...

i install this mode but when i go to index of forum got this error


Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT unid FROM vb_wwu002visitlog WHERE (userid="1")AND(dateline="1250035200") LIMIT 1;

MySQL Error : Table 'bootiran_bootiran.vb_wwu002visitlog' doesn't exist
Error Number : 1146
Request Date : Wednesday, August 12th 2009 @ 11:50:39 PM
Error Date : Wednesday, August 12th 2009 @ 11:50:39 PM
Script : http://www.bootiran.org/forum/
Referrer :
IP Address : 91.99.224.64
Username : __DavoodBlack__
Classname : vB_Database
MySQL Version : 5.0.81-community-log

This means that the activity mod failed to propperly install. Since it failed to install, to uninstall it and try it again, you will probably first need to remove the uninstall code (by first selecting "Edit" from the product menu).

WetWired
08-17-2009, 03:50 AM
Hi WetWired,

Today this database error come to my e-mail.
What is wrong?

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT count(*) as num,floor((1250121599-dateline)/604800) as week FROM wwu002visitlog WHERE (userid=994)AND(dateline>=1246492800) GROUP BY week ORDER BY week;

MySQL Error : Can't open file: './pijanitv_vbulletin/wwu002visitlog.frm' (errno: 24)
Error Number : 1016
Request Date : Thursday, August 13th 2009 @ 01:11:44 AM
Error Date : Thursday, August 13th 2009 @ 01:11:48 AM
Script : http://www.pijanitvor.com/forum/showthread.php?t=824
Referrer : http://www.google.com/url?sa=t&source=web&ct=res&cd=4&url=http%3A%2F%2Fwww.pijanitvor.com%2Fforum%2Fshow thread.php%3Ft%3D824&ei=4EqDSsqfL8iGsAbLnZHQCQ&rct=j&q=primame+i+mamci+za+amura+na+jezerima&usg=AFQjCNFrr9U-km__kfO2nE-vfRALqjsfIw
IP Address : *******
Username : Unregistered
Classname : vB_Database
MySQL Version :

As it says, for one reason or another, you were missing or otherwise unable to open a database file. I am no expert in the files that MySQL uses, so I couldn't tell you what the implications of a missing .frm file are. If this is an isolated incident, I would ignore it (perhaps an automated backup had the file locked at that moment, for instance).

Brathamike
08-17-2009, 08:25 AM
hello great mod i have installed this mod about a week ago and i notice that my activity is moving up very fast
for 8 post i notice that the activity is at

Overal Activity 21%
visti Activity 24%
Post Activity 20%
Today 20%
Post Count 8

Board only been active for 2 weeks

I would like to slow this down..I want something like.

10,000 post at 80% for activity

it seems like with my post count at 8 i will hit that 100 mark very soon

so is it possable to slow this down or change some settings

thanks
love your mod

WetWired
08-21-2009, 06:05 AM
You can have it count up to 6 weeks and count up to 10 posts per day.
The activity statistic is a measure of the level of activity within the past x weeks. Weeks are weighted so that the most recent weeks are most important.
Visiting counts toward activity, also.

What are your current settings for the mod?

Brathamike
08-21-2009, 02:08 PM
You can have it count up to 6 weeks and count up to 10 posts per day.
The activity statistic is a measure of the level of activity within the past x weeks. Weeks are weighted so that the most recent weeks are most important.
Visiting counts toward activity, also.

What are your current settings for the mod?


Hello thank you sir for your response.

here are my settings at the moment
weeks Reflected 2
visit weight .5
counted post per day 2

What im trying to do is set this so it will be hard to reach the 100% mark. What settings do you recommend

thanks for your resposne

WetWired
08-21-2009, 04:21 PM
Okay, 100% activity means that a user has met all your required visits and posts.

With your settings of 2 weeks, and counting 2 posts per day, the requirement for 100% activity is to visit each day and post twice each day for two weeks.

With the default setting of 4 weeks, and counting 4 posts per day, the requirement for 100% activity is to visit each day and post four times each day for four weeks.

If you set it to the maximum settings of 6 weeks, and counting 10 posts per day, the requirement for 100% activity is to visit each day and post 10 times each day for six weeks.

The visit weight has no effect on difficulty to get 100% (because to get 100%, you have to get all your visits regardless what they are worth), but setting it to .5 does increase the difficulty to get to activity levels below 100%.

Brathamike
08-21-2009, 05:03 PM
Okay, 100% activity means that a user has met all your required visits and posts.

With your settings of 2 weeks, and counting 2 posts per day, the requirement for 100% activity is to visit each day and post twice each day for two weeks.

With the default setting of 4 weeks, and counting 4 posts per day, the requirement for 100% activity is to visit each day and post four times each day for four weeks.

If you set it to the maximum settings of 6 weeks, and counting 10 posts per day, the requirement for 100% activity is to visit each day and post 10 times each day for six weeks.

The visit weight has no effect on difficulty to get 100% (because to get 100%, you have to get all your visits regardless what they are worth), but setting it to .5 does increase the difficulty to get to activity levels below 100%.

Great! thank you for your time. I understand now

pavpavpav
09-03-2009, 01:15 AM
I tried to uninstall this and it screwed up my whole server

WetWired
09-10-2009, 12:25 AM
There's nothing special about the uninstall for this mod. It just removes the tables and fields it added on installation. Would you care to explain exactly what happened?

chick
09-12-2009, 12:11 PM
The GARS fix for [novPostTD novStats] works great, thank you

crouzmind
09-29-2009, 05:21 PM
hello coder i have installed and also upload the images dark files all is fine but after successfully installed the mod when i click on any thread to view i got this error .

Fatal error: Call to undefined function WWU002processUser() in /home/ihfun/public_html/includes/class_postbit.php(265) : eval()'d code on line 185

Jimbolosey
10-13-2009, 01:23 PM
Fatal error: Call to undefined function WWU002processUser() in /home/user/public_html/mysite.com/vb/forums/includes/class_postbit.php(265) : eval()'d code on line 8

What do I need to fix?

WetWired
10-15-2009, 03:14 PM
This means that there are errors (in any mod) processing global_start. Since errors at that point are supressed, it's hard to debug. Actually, you may be able to see them in your apache error log. They would show as happening in global.php.

Jimbolosey
10-31-2009, 09:28 PM
hmmm, this sucks. I looks like a really good mod, but I just can't find out how to fix it.

Tilly
10-31-2009, 11:36 PM
How do you change when your board started...for some reason mine says 1969 lol

sebil
11-27-2009, 06:30 PM
I am getting this error.. whil installing the productt

What shall i do.. :(

Database error in vBulletin 3.8.4:

Invalid SQL:
ALTER TABLE `user` ADD `wwu002activity` INT UNSIGNED NOT NULL ,
ADD `wwu002activitydate` INT UNSIGNED NOT NULL ,
ADD `wwu002memberlevel` TINYINT UNSIGNED DEFAULT "1" NOT NULL ,
ADD `wwu002fullmemberdate` INT UNSIGNED NOT NULL ,
ADD `wwu002lastvisit` INT UNSIGNED NOT NULL;

MySQL Error : Duplicate column name 'wwu002activity'
Error Number : 1060
Request Date : Friday, November 27th 2009 @ 02:28:52 PM
Error Date : Friday, November 27th 2009 @ 02:28:52 PM
Script : http://www.malludreams.com/admincp/plugin.php?do=productimport
Referrer : http://www.malludreams.com/admincp/plugin.php?do=productadd
IP Address :
Username : MalluDreams
Classname : vB_Database
MySQL Version : 5.0.85-community

sebil
11-27-2009, 06:33 PM
Plzz help.. i need this mod soo despertlyy..

Brennan Portz
12-08-2009, 01:10 PM
u all know that when u post on the forums u get bars on your activity on the day but what about when you message people. that i think should still be considered activity but i message people all the time and that bar refuses to move lol. so what do you guys think about seeing if we could have that considered activity also. and please no one take this as me complaining i was just wondering if it was possible.
thanks

R3V

JamesGunner
12-23-2009, 09:08 PM
Are there any plans on porting this to vb 4?

J105C
01-25-2010, 11:27 AM
I love this MOD, I am asking too if this will be updated for vb4.x!

jobbe
02-03-2010, 10:57 AM
And me too!

Masked Crusader
02-13-2010, 09:57 PM
Question for everyone:

I had the mod working and now it is outputting some error text such as: novStats. If you go to your activity_headinclude template file, you will see about 10-15 lines down. What does this error mean?

I am not getting any activity items to show up.

Thanks!

maf1973
02-16-2010, 09:31 AM
a port to vb4 would be very nice

Inferno Dragon
03-01-2010, 12:32 AM
any update regarding vb4 version?

SorentoUltimate
03-24-2010, 10:23 PM
Very Good and work perfect with 3.8.4

Thanks
SorentoUltimate

BigJohnny
09-17-2010, 11:35 PM
I might be stupid here, but I want to organize my cpnav a little bit. I cannot for the life of me figure out where the activity mod cpnav menu comes from to change it's display order.

Can someone tell me how I can move it up or down in my cpnav?

kamakazy_kid
11-29-2010, 01:41 PM
How do you stop it from posting usertitle twice?

WetWired
12-01-2010, 10:39 PM
How do you stop it from posting usertitle twice?

In the "Activity Rank and Promotion Settings", set "Output Ranktext" to no

crYme
12-19-2010, 10:26 AM
Thanks everything works like a charm. Awesome mod! :)

qubed
02-21-2011, 10:47 AM
Would love this for vb4.

luckid
07-16-2011, 02:48 AM
Would love this for vb4.

Any news for VB 4 ???

Tnx in advace......:rolleyes:

wolfe
05-27-2012, 07:11 AM
any update on vb4 port

vBMerkezi
06-06-2012, 06:08 PM
thank you

ChiNa
08-20-2012, 04:06 PM
This is such a clean Addon, I never had any problems running this, Thank you very much, I have used it on my vB 3.8.6 Version, and 3.8.7 now and never struck me any problem! We need more products like this,,,

EuroPk
11-26-2012, 11:35 PM
MySQL Error : BIGINT UNSIGNED value is out of range

this happened out of no where?
Database error in vBulletin 3.8.5:

Invalid SQL:
SELECT count(*) as num,floor((1353887999-dateline)/604800) as week FROM wwu002visitlog WHERE (userid=1)AND(dateline>=1351468800) GROUP BY week ORDER BY week;

MySQL Error : BIGINT UNSIGNED value is out of range in '(1353887999 - `teamihpk_ihpkvb`.`wwu002visitlog`.`dateline`)'
Error Number : 1690
Request Date : Monday, November 26th 2012 @ 05:17:06 PM
Error Date : Monday, November 26th 2012 @ 05:17:06 PM
Script : http://www.ihpk.net/forums.php
Referrer :
IP Address : XXX.XXX.XX.XXX
Username : R.I.P
Classname : vB_Database
MySQL Version : 5.5.28-log

Why?

Wizzup
01-29-2013, 03:52 AM
I would also love to see a vB4 update for this!

Sockpuppet
04-17-2013, 08:41 PM
MySQL Error : BIGINT UNSIGNED value is out of range

this happened out of no where?
Database error in vBulletin 3.8.5:

Invalid SQL:
SELECT count(*) as num,floor((1353887999-dateline)/604800) as week FROM wwu002visitlog WHERE (userid=1)AND(dateline>=1351468800) GROUP BY week ORDER BY week;

MySQL Error : BIGINT UNSIGNED value is out of range in '(1353887999 - `teamihpk_ihpkvb`.`wwu002visitlog`.`dateline`)'
Error Number : 1690
Request Date : Monday, November 26th 2012 @ 05:17:06 PM
Error Date : Monday, November 26th 2012 @ 05:17:06 PM
Script : http://www.ihpk.net/forums.php
Referrer :
IP Address : XXX.XXX.XX.XXX
Username : R.I.P
Classname : vB_Database
MySQL Version : 5.5.28-log

Why?


Run the following mysql command in Admin -> Maintenance -> Execute SQL Query -> Manual Query

ALTER TABLE `wwu002visitlog` CHANGE `dateline` `dateline` INT(10) NOT NULL;

That fixed it for me. :)