The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
|||||||
[DBTech] vBActivity & Awards v3 (vB4) Details »»
|
|||||||||||||||||||||||||||||||||||||||
|
[DBTech] vBActivity & Awards v3 (vB4)
Developer Last Online: Mar 2023 
DragonByte Technologies are proud to present vBActivity & Awards Lite v2: The most advanced, most feature-rich and most professional Activity tracking system ever.
Why vBActivity? vBActivity is Brought to you by the Designer of products such as RPG Inferno and Inferno vBShout and the programmer of RPG Integration v3. vBActivity Lite from DragonByte Tech is a modification designed to allow yourself and your members to keep track of their activity, and be rewarded for it. Give points for many different actions - Posting, Starting threads, Voting, Referrals... Furthermore, your members get rewarded for creating content which is popular! Gain points for every post in a thread you created, points for high thread ratings, for having a good reputation and more! You can utilise vBA to encourage members to do certain things on your forum. Lack of new threads? Increase the points given for starting a thread and watch as the thread count rises. Need an influx of new members? Give a boost to referral points and watch as people try to collect more points. Set Achievement targets for your members to encourage them to get more posts, start more threads, or do any one of a number of things! Is quality more important to your forum than quantity? Use our Awards system. Manually allocate medals to users for things like the most thoughtful post, the best thread or even things like the most unique signature! vBActivity v2 has been almost completely rewritten to provide a faster and more scalable activity tracking platform. Already it's showing great potential in the feature requests our Pro users have realised they can now request and see implemented. This is a major update that solves every performance problem, as well as many of the design problems. ------------------------------------------------------------------------------------------- If you like this mod please hit the  button to the right ---->Please remember to click the,  button to the right if you installed the mod ---->What does 'Marking As Installed' do ? * It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available. * For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention. * Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications. We appreciate the support! ------------------------------------------------------------------------------------------- Priority support is handled at the Developers Website. ------------------------------------------------------------------------------------------- Major Features Activity Tracking & Stats: Dedicated activity tracking pages lets you see how many points members have gained for each action, and a browseable archive of aquired activity points lets you see exactly when the points were gained. Achievements: A powerful engine for creating new achievements lets you create Achievements matching just about any criteria you can think of based on the list of actions (full list of actions can be found in the Complete Feature List below). Awards: For the moments that deserve something special, you can create and hand out special awards separately from Achievements, acting as unique merit badges. Professional Only Benefits Trophies: Give members trophies for being the best at something! Most posts? Trophy! Most threads? Trophy! Only one member can hold a trophy at a time, meaning lots of competition to be *THE ONE*! Backups: Want to share your carefully put together collection of Achievements, Medals and Trophies with other vBActivity Pro owners? Want to re-install vBActivity on a fresh forum without losing your configuration? Use the backup and import system to achieve this. Snapshots: Do you want to give double points for a week to encourage activity? With our Snapshot system it's as easy as a click of a button. Take a snapshot of your current settings, change it to what you want for the week, then switch back to your old settings instantly! Complete Feature List Lite
Fine-Grained ModCP Permissions
Points for Attachments
Points for [DBTech] DragonByte Gallery Uploads
Duplicate Achievements
Points Alongside Awards
PM User At X Posts
PM User When Receiving Awards
PM User When Receiving Achievements
Define PM Senders
Awards Setting: Postbit Display Order
General / Other
Command-Line Maintenance Script
Increased Postbit Control
Pro
(Pro) Per-Forum Criteria
(Pro) Recurring Contests
(Pro) Recalculate Winners
(Pro) "Current Standing" Display
(Pro) Front-End Contest Management
(Pro) PM User When Receiving Awards
(Pro) PM User When Receiving Achievements
(Pro) PM User When Receiving Promotions
(Pro) New Contest Type: Raffle Tickets (Threshold)
(Pro) Per-User Toggle: Disable Achievements
(Pro) Per-User Toggle: Disable Awards
(Pro) Per-User Toggle: Disable Trophies
(Pro) General / Other
(Pro) Global Toggle: Disable "View Activity" Link
(Pro) New Contest Type: Raffle Tickets (Thread Replies)
------------------------------------------------------------------------------------------- This mod displays a copyright notification in the footer of pages generated by this mod which includes:
Download Now
Screenshots
Show Your Support
|
|||||||||||||||||||||||||||||||||||||||
About Developer
Visit Web Site
DB Changes 
No support by the author.
| 3 благодарности(ей) от: | ||
| jimsflies, mohammadxxx, nokturno | ||
| Comments |
|
#72
03-02-2010, 08:14 PM
|
||||
|
||||
Could you please show me the result of your slow query log? I'll try to have it fixed for the next version
 Fillip 
|
|
#73
03-02-2010, 08:15 PM
|
||||
|
||||
|
Hmm... how many members does your forum have?
A 30x increase in load doesn't sound normal at all... Iain
|
|
#74
03-02-2010, 10:13 PM
|
||||
|
||||
|
Quote:
 Not used to this kind of quick response. I do appreciate it and will come back with data for you. Quote:
About 1.5 million posts. Quote:
I finally enabled the slow query log to see what was putting such load on my processors and it was this mod, which really surprised me.
|
|
#75
03-02-2010, 10:41 PM
|
||||
|
||||
|
Ok, I just tested again. This is in a very slow time of the day with only 100 +/- connections to the site.
Prior to enabling mod: 0.47 0.43 0.38 | 112 Users Online (74 members and 38 guests) Immediately after enabling mod: 1.18 0.63 0.45 | 118 Users Online (78 members and 40 guests) a few minutes after enabling mod: 2.12 1.36 0.80 | 113 Users Online (72 members and 41 guests) This trend will continue until server load goes out of control and connections start getting throttled. After mod is disabled for a few minutes: 0.57 0.81 0.76 | 111 Users Online (70 members and 41 guests) My slow query threshold is set to 10 seconds. The mod is pumping queries that take 10 seconds or more into the queue every 2 seconds, this causes MySQL to backlog severely until the entire site runs like molasses. Eventually the system starts rejecting connections due to high processor load because MySQL is running away with all 4 processors. Attached find the slow query log after just a couple of minutes of running with the mod enabled. It pumps an entry like the following into the log about every 2 seconds: Code:
# Time: 100302 18:29:40 # User@Host: databasename[databasename] @ localhost [] # Query_time: 13.313781 Lock_time: 0.000048 Rows_sent: 4 Rows_examined: 368738 SET timestamp=1267576180; SELECT SUM(points) AS newpoints, userid FROM dbtech_vbactivity_pointslog WHERE userid IN( SELECT userid FROM post AS post WHERE post.postid IN (0967161,967167,967177,967178,967194,967203,967204,967232,967238,967243) ) AND points > 0 GROUP BY userid;
|
|
#76
03-02-2010, 11:09 PM
|
||||
|
||||
|
I've just re-uploaded the zip file without the offending query.
What this means for the product is, for the next 24 hours your Activity rating might spike a bit higher (  ) but your forums shouldn't bog down like that again.If it does, please let us know and we will fix it as soon as possible. Your feedback is quite invaluable in this, none of us have access to such a huge forums as yours, so it's great that you're willing to help out  Just re-upload all the files, no need to do anything with the XML Fillip
|
|
#77
03-02-2010, 11:54 PM
|
||||
|
||||
|
I have uploaded the zip and it has been enabled for about 30 minutes.
Load averages are 0.80 0.76 0.60 Looks like you got it. Thanks! Also, is it possible to add userid= as a criteria - with that one feature, your mod can completely replace the other "awards" system I have running.
|
|
#78
03-03-2010, 12:14 AM
|
||||
|
||||
|
There's a feature for making awards and giving them to users in the Pro version (we call them Medals)
That system's due for an overhaul in v1.1 as well, when it'll be able to give the same award to the same user multiple times. Glad to hear the problem has been solved, in the next version we'll take care of the Activity formula problem, which should bring this mod out of Beta. Btw, could you leave the Slow Query Log on overnight, so that it can log the "Daily Points" Cron job? I worry that that's a performance hit, and you're the only big-board user I know of  Thanks in advance Fillip
|
|
#79
03-03-2010, 12:36 AM
|
||||
|
||||
|
I've left it on for exactly that reason - I'll post it up tomorrow.
|
|
#80
03-03-2010, 12:40 AM
|
||||
|
||||
|
Thanks
The cron job runs at midnight GMT though, so it may need to be left on for another 24 hours to be fully sure. But at least leaving it on will catch any other potential resource predators xP Fillip
|
 |
«
Previous Thread
|
Next Thread
»
|
|
All times are GMT. The time now is 04:38 AM.