vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Miscellaneous Hacks - Activity Modification (https://vborg.vbsupport.ru/showthread.php?t=177366)

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;

Code:

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?

Code:

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%2Fshowthread.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

Quote:

Originally Posted by davoodblack (Post 1866041)
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;

Code:

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

Quote:

Originally Posted by Sunka (Post 1866362)
Hi WetWired,

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

Code:

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%2Fshowthread.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

Quote:

Originally Posted by WetWired (Post 1871459)
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

Quote:

Originally Posted by WetWired (Post 1871707)
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.. :(

Quote:

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/p...=productimport
Referrer : http://www.malludreams.com/admincp/p...?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

Quote:

Originally Posted by kamakazy_kid (Post 2127148)
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

Quote:

Originally Posted by qubed (Post 2164915)
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?
Code:

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

Quote:

Originally Posted by EuroPk (Post 2385437)
MySQL Error : BIGINT UNSIGNED value is out of range

this happened out of no where?
Code:

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

[sql]ALTER TABLE `wwu002visitlog` CHANGE `dateline` `dateline` INT(10) NOT NULL;[/sql]

That fixed it for me. :)


All times are GMT. The time now is 01:16 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.02248 seconds
  • Memory Usage 1,833KB
  • 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
  • (6)bbcode_code_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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