Major Additions - [DBTech] vBActivity & Awards v3 (vB4)

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

• Achievement Targets
  • Shows latest earned Achievement in each category and what we're lacking for the next Achievement
    • Shows 1 category
• Integration
  • vBShout Shouts
  • Advanced @User Tagging - Tag
  • Advanced @User Tagging - Mention
• Define Points for Actions:
  • Points Per Post
  • Points Per Post (Own Threads)
  • Points Per Thread
  • Points Per Thread Rating
  • Points Per Thread Rating Received
  • Points Per Visitor Message Given
  • Points Per Visitor Message Received
  • Points Per Poll Posted
  • Points Per Poll Vote
  • Points Per Day Registered
  • Points Per Confirmed Friend
  • Points Per Reputation Point Given
  • Points Per Reputation Point Received
  • Points Per Infraction Point Given
  • Points Per Infraction Point Received
  • Points Per Referral
  • Points Per Social Group Message Posted
  • Points Per Social Group Discussion Started
  • Points Per Calendar Event Created
• Activity Page
  • Ranking
    • How members stack up against eachother
  • Achievements
    • Shows a list of all earned Achievements.
  • Activity
    • Shows a list of all points gains / losses
  • Leaderboards
    • Shows who's got the most points of each type
  • Awards
    • Shows gained Awards
• Member Profiles
  • Activity Information
    • Shows a detailed breakdown of a member's Activity information
    • Shows a breakdown of a member's total points of each type
  • Achievements
    • Shows a collapsable list of all this user's earned Achievements
  • Awards
    • Shows a collapsable list of all held Awards
• Postbit
  • Activity Stats
    • Shows some core details about an user's activity
  • Achievements
    • Shows the last X Achievements earned.
  • Awards
    • Shows the last x earned Awards
• AdminCP:
  • Integration
    • vBShout
      • Points Per Shout
    • Advanced @User Tagging
      • Points Per Tag
      • Points Per Mention
  • Manage Achievements
    • Add
    • Edit
    • Delete
    • Change Display Order
  • Manage Awards
    • Add
    • Edit
    • Delete
    • Award
  • Manage Categories
    • Add
    • Edit
    • Delete
  • Criteria
    • Used for Achievements, Criteria are certain conditions that need to be fulfilled.
    • Manage Criteria
      • Add
      • Edit
      • Delete
  • Maintenance
    • Recalculate Points
      • Erases all accumulated points and re-calculates them
    • Recalculate Achievements
      • Erases all accumulated Achievements and re-calculates them

Fine-Grained ModCP Permissions

• Separate usergroup permission required for each page
• Separates add/edit/delete and ability to hand out awards
• Complete List:
  • Can Manage Achievements
  • Can Manage Categories
  • Can Manage Criteria
  • Can Manage Awards
  • Can Grant Awards
  • Can Manage Maintenance Options
  • Can Manage Trophies
  • Can Manage Contests
  • Can Manage Promotions
  • Can Manage Backups
  • Can Manage System Snapshots
  • Can Import / Export
  • Can Manage Points Settings
  • Can Manage Global Permissions
  • Can Manage vBulletin Options

Points for Attachments

• Ability to grant points for attachment uploads
• Works when attachments are stored in the File System, not in the database
• Allows re-calculation for past attachments uploaded

Points for [DBTech] DragonByte Gallery Uploads

• Ability to grant points for DragonByte Gallery uploads
• Works when attachments are stored in the File System, not in the database
• Allows re-calculation for past images uploaded

Duplicate Achievements

• Ability to copy Achievements when creating a new Achievement
• Copies all settings including Criteria chosen

Points Alongside Awards

• Users can be given points alongside Awards
• Works with "Recalculate Points" maintenance action

PM User At X Posts

• Ability to define different thresholds to PM a user
• Translatable PM title / text

PM User When Receiving Awards

• Sends a PM to users when they receive a new Award
• Translatable PM title / text
• Global toggle via vBulletin Options

PM User When Receiving Achievements

• Sends a PM to users when they receive a new Achievement
• Translatable PM title / text
• Global toggle via vBulletin Options
• Doesn't trigger on recalculate, to avoid spam

Define PM Senders

• Add separate users as the sender of several vBAA PMs
• Reverts to "same as recipient" if no users are specified
• Complete List:
  • Post PM Threshold
  • New Achievement
  • New Award
  • (Pro) New Promotion
  • (Pro) New Trophy
  • (Pro) New Contest Winner Admin Notification
  • (Pro) New Contest Winner User Notification

Awards Setting: Postbit Display Order

• Choose between three display orders
  • Awarded (Ascending)
  • Awarded (Descending)
  • AdminCP Display Order

General / Other

• Points for Posts is now more compatible with 3rd party modifications that generate posts
• Who's Online support
• (vB4) The profile block has been updated to support profile customisation

Command-Line Maintenance Script

• Deploy script anywhere on your server and run it securely
• Allows running all maintenance actions otherwise found in the AdminCP
• Ideal for very large forums that cannot reliably run the features via the web browser

Increased Postbit Control

• Allows for various postbit items to be deployed individually
• Complete List:
  • Activity Points
  • Activity Level
  • Daily Activity
  • Daily Activity Bar
  • (Pro) Weekly Activity
  • (Pro) Weekly Activity Bar
  • (Pro) Monthly Activity
  • (Pro) Monthly Activity Bar

Pro

• Awards
  • Request / Nominate Awards with reason input
• Record
  • Displays permanent record of who won each week/day/month etc.
• Achievement Targets
  • Shows latest earned Achievement in each category and what we're lacking for the next Achievement
    • Shows all categories
• Integration
  • vB Blog Entry
  • vB Blog Comment
• Activity Page
  • Promotions
    • Shows all Promotions handed by the system
  • Trophies
    • Shows gained / lost trophies
  • Contests
    • Overview past contests and who won them.
• Member Profiles
  • Ability to toggle notifications
  • Currently Held Trophies
    • Shows a collapsable list of all currently held trophies
    • Shows how many times these trophies have been held
  • Previously Held Trophies
    • Shows a collapsable list of all previously held trophies
    • Shows how many times these trophies have been held
• AdminCP
  • Awards
    • Reason for granting Awards
  • Integration
    • Points per Blog Entry
    • Points per Blog Comment
  • Importer
    • YAAS awards
  • Manage Trophies
    • Add
    • Edit
    • Delete
  • Contests
    • Toggle public contest
    • Contests Won criteria for Achievements / Promotions
    • Ability to give points along with awards to winners
    • Set number of winners
    • 2 contest types, "first to reach points target" and "total points in time period"
    • Exclude certain sources from counting towards contest goal
    • Banner support (small and big size for preview and full view)
    • Winner PMs
    • Admin notifications on winners
    • Link to contest discussion thread
    • Ability to show or hide current standing for ongoing contests
  • Backups
    • Take backups of all vBActivity information
    • Manage Backups
      • Add
      • Edit
      • Delete
      • Load
  • Snapshots
    • Take a snapshot of points settings
    • Manage Snapshots
      • Add
      • Edit
      • Delete
      • Load
  • Recurring schedules of various snapshot configurations
    • Manage Snapshot Schedules
      • Add
      • Edit
      • Delete
  • Statistics
    • Who's what level
    • Who's earned each Achievement
    • Who's been awarded each Award

(Pro) Per-Forum Criteria

• Ability to set certain Criteria as only applying to certain forums
• Works with the following Criteria types:
  • Posts
  • Posts (Own Threads)
  • Threads
  • Thread Ratings Given
  • Thread Ratings Received
  • Polls Posted
  • Poll Votes
  • Reputation Given
  • Reputation Received
  • Infractions Given
  • Infractions Received
  • [DBTech] Advanced User Tagging: Mentions Given
  • [DBTech] Advanced User Tagging: Mentions Received
  • [DBTech] Advanced User Tagging: Tags Given
  • [DBTech] Advanced User Tagging: Tags Received

(Pro) Recurring Contests

• Can be set to recur
  • Never
  • Daily
  • Weekly
  • Monthly
  • Yearly
• Preserves your "Hour" and "Minute" configurations for the new contest

(Pro) Recalculate Winners

• Contests that ended without any winners can be re-calculated
• Best used after recalculating points
• Reads from the Points Log to determine who wins each contest type

(Pro) "Current Standing" Display

• Display more or less users than there are scheduled winners for each contest
• Doesn't decrease when one or more winners are added to an in-progress contest
• Works with contests currently in progress

(Pro) Front-End Contest Management

• Separate usergroup permission required
• Allows add/edit of contests
• Prevents deletion for security purposes
• Full contest management interface nearly identical to the AdminCP

(Pro) PM User When Receiving Awards

• Per-User toggle via UserCP

(Pro) PM User When Receiving Achievements

• Per-User toggle via UserCP

(Pro) PM User When Receiving Promotions

• Sends a PM to users when they receive a new Promotion
• Translatable PM title / text
• Per-User toggle via UserCP

(Pro) New Contest Type: Raffle Tickets (Threshold)

• Specifies a "Target" similar to the existing contest type
• Users who pass the target will gain raffle tickets (pass it two times over for 2 tickets, etc)
• X number of winners are drawn randomly from the list of eligible winners

(Pro) Per-User Toggle: Disable Achievements

• Users can hide Achievements from their view of their own and others' posts
• De-clutters the postbit without affecting other users' view
• Defaults to visible

(Pro) Per-User Toggle: Disable Awards

• Users can hide Awards from their view of their own and others' posts
• De-clutters the postbit without affecting other users' view
• Defaults to visible

(Pro) Per-User Toggle: Disable Trophies

• Users can hide Trophies from their view of their own and others' usernames
• De-clutters the postbit without affecting other users' view
• Defaults to visible

(Pro) General / Other

• AdminCP: There's now a "Check All" box in the Contests management screen under Criteria Settings and Forum Settings
• Front-End: Contest information that would previously be populated by "N/A" will now simply be hidden when you switch contests

(Pro) Global Toggle: Disable "View Activity" Link

• Administrators can hide the "View Activity" link in the "member action" drop-down menu when clicking a user name
• Option located next to other integration options
• Defaults to visible

(Pro) New Contest Type: Raffle Tickets (Thread Replies)

• A thread is designated as the "ticket thread".
• Each reply from a member is considered 1 ticket.
• Optional restriction of how often a member can reply (in minutes)
• X number of winners are drawn randomly from the list of eligible winners

-------------------------------------------------------------------------------------------

This mod displays a copyright notification in the footer of pages generated by this mod which includes:

• 1 Link to DragonByte Technologies homepage
• 1 Link to Product Description page of this modification

[RoG Aftermath]

This may sound like a dumb question but how do users go about requesting and award?

[DragonByte Tech]

As per the first post, that is a Pro-only feature


Fillip

[RoG Aftermath]

Originally Posted by DragonByte Tech

As per the first post, that is a Pro-only feature


Fillip

Ok thanks, if i were to upgrade to the pro version would i lose all the achievements and awards and images i have already uploaded? or will they stay there?

[DragonByte Tech]

Upgrading to Pro is seamless and no data loss occurs, as you already have the complete database structure required for the Pro version - Pro is just added code, pretty much


Fillip

[RoG Aftermath]

Originally Posted by DragonByte Tech

Upgrading to Pro is seamless and no data loss occurs, as you already have the complete database structure required for the Pro version - Pro is just added code, pretty much


Fillip

Ok thanks for you help its much appreciated.

[DragonByte Tech]

vBActivity v3.0.0:
Feature: "Reason" field can be filled out when granting awards.
Feature: Criteria / Points: Profile Completed (when all required profile fields are filled out)
Feature: It is now possible to hide vBActivity features from Guests in the postbit for SEO reasons
Change: Granting an award to a user via the "Manage Users" link now has the award pre-selected
Change: All "List" pages that display usernames now also show a miniature avatar

Majority of this release was focused on improving Activity Contests for the Pro version. More information can be found in the Complete Feature List section of the release post.


Fillip

[Baltar]

I'm installing for the first time. It starts off fine then I'm getting an error message here:

Updating

Version Number To: 1.0.2

Altered Table: vb_user
Database Error Database error
The Vinylmation Kingdom Forums database has encountered a problem.

Then it tells me this:

Invalid SQL:

UPDATE vb_user AS user
SET dbtech_vbactivity_pointscache = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1321725343
),
dbtech_vbactivity_pointscache_day = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1321747200
),
dbtech_vbactivity_pointscache_week = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1321747200
),
dbtech_vbactivity_pointscache_month = (
SELECT SUM(points) AS numpoints
FROM vb_dbtech_vbactivity_pointslog
WHERE userid = user.userid
AND dateline >= 1320105600
);

MySQL Error : Column 'dbtech_vbactivity_pointscache' cannot be null
Error Number : 1048
Request Date : Sunday, November 20th 2011 @ 05:55:43 PM
Error Date : Sunday, November 20th 2011 @ 05:55:53 PM
Script : http://www.vinylmationkingdom.com/fo...=productimport
Referrer : ...
IP Address : ...
Username : ...
Classname : vB_Database_MySQLi
MySQL Version : 5.1.30-log

Any advice?

[DragonByte Tech]

Try editing /dbtech/vbactivity/install/110.php and remove the following code:

PHP Code:

self::$db->query_write("
    UPDATE " . TABLE_PREFIX . "user AS user
    SET dbtech_vbactivity_pointscache = (
        SELECT SUM(points) AS numpoints
        FROM " . TABLE_PREFIX . "dbtech_vbactivity_pointslog 
        WHERE userid = user.userid
            AND dateline >= " . (TIMENOW - 86400) . "
    ),
    dbtech_vbactivity_pointscache_day = (
        SELECT SUM(points) AS numpoints
        FROM " . TABLE_PREFIX . "dbtech_vbactivity_pointslog
        WHERE userid = user.userid
            AND dateline >= $today
    ),
    dbtech_vbactivity_pointscache_week = (
        SELECT SUM(points) AS numpoints
        FROM " . TABLE_PREFIX . "dbtech_vbactivity_pointslog
        WHERE userid = user.userid
            AND dateline >= $week
    ),
    dbtech_vbactivity_pointscache_month = (
        SELECT SUM(points) AS numpoints
        FROM " . TABLE_PREFIX . "dbtech_vbactivity_pointslog
        WHERE userid = user.userid
            AND dateline >= $month
    )
"); 


Fillip

[Baltar]

removing everything you quoted, correct?

[DragonByte Tech]

Yeah that's what I said


Fillip