Turtle Dollars (includes addons)

Note: there is one installation step specific to vB 2.3.0. If you are using an earlier version it might require some creativity on your part to install this hack.

Addons: Top 10 List

This hack is based on Sun's Java support forums' "Duke Dollars." This allows you to place a "dollar" offer when posting a thread, and when you get a helpful reply, give that member some of your "money." If memory serves, this can equate to buying trinkets at Sun's store. In vB it's mostly for pride although it may be possible to integrate this into other hacks like the infamous Store hack. The user's funds are always stored in $bbuserinfo['dollars'].

User-side, the user can offer a given number of dollars for any thread they post. If nobody replies or only they reply, they can retract the offer (this can be changed from the user CP). To award a user with the dollars, he has to click the "Award" button in the postbit. The thread will then be marked has having no dollar offer. Threads with dollar offers are marked in forumdisplay with an icon. When the award is given, the funds are subtracted from the thread poster's account and added to the awardee's funds. The user's funds are shown in his user CP.

Admin-side, an admin can designate which forums can allow dollar offers (by default they all will when installing this hack; when changing this setting only future threads are affected). An admin can also manually edit user accounts and can view the top 10 richest members. In addition, a given user's account can be completely emptied (useful when banning). There are also options for minimum allowed, maximum allowed, and default dollar awards.

Moderators, supermoderators, and administrators can always override some options. They can cancel offers by any member. However they are subject to the same "rules of economics" as any member (rewarding a member will always deduct from their funds and give to the member).

All images included have their PSD counterparts included in layered form and are based on the vBulletin graphics developer kit.

Screenshots are included in a zip below.

This hack comes with a powerful install script that runs the necessary queries for you. It also creates all custom templates. However it is up to you to do the file edits and template edits (included in the instructions).

Please reply with any comments you have. Just a "it's working" is appreciated.

[DPoole]

nothing it does nothing

I click start installtion and it does nothing when i click it
any reason for this ?

I have now even upgraded to 2.3 as well

SO a text version would be appreciated then i can do it manual

[filburt1]

A text version is next to impossible the way the setup works.

I'm going to debug this on a completely different server (my laptop) right now although I believe it still works perfectly. Make sure you're running at least PHP 4.2.0.

[filburt1]

The installer works absolutely perfectly for me. I tested both of these on PHP 4.3.0 (this most recently on a Mac) with vB 2.3.0 RC2 or RC3. Personally I bet the problem is on your side because every computer I've tried the install script on works.

"Turtle Dollars" Installation Script
Script based on filburt1's standard install script. Back up your database and files before installing this hack/mod.
This script runs queries to help install "Turtle Dollars." This script can only create templates and run queries. It does not touch files or existing templates.

Creating Settings...
Getting current highest + 1 displayorder for settings...
query_first: SELECT MAX(settinggroupid) + 1 AS newdisplayorder FROM setting
Creating settings group...
query: INSERT INTO settinggroup (title, displayorder) VALUES ("Turtle Dollars", 33)
Getting newly created settinggroupid...
Writing script to create individual settings...
Caching highest settingid + 1...
query_first: SELECT MAX(settingid) + 1 AS sidplusone FROM setting
Creating setting "Default dollar allocation to new members"...
query: INSERT INTO setting (settinggroupid, title, varname, value, description, optioncode, displayorder)
VALUES (33,
"Default dollar allocation to new members",
"tddefault",
"20",
"Enter a number of dollars that you want new members to get by default. Don\'t use decimal or negative numbers. This only affects new registrations.",
"",
0)

Creating setting "Allow users to revoke dollar offers after no replies?"...
query: INSERT INTO setting (settinggroupid, title, varname, value, description, optioncode, displayorder)
VALUES (33,
"Allow users to revoke dollar offers after no replies?",
"tdallowrevoke",
"1",
"If a user posts a thread with an offer attached to it but nobody replies, allow them to retract their offer? Moderators,
supermoderators, and administrators can always retract offers, including other users\' offers.",
"yesno",
1)

Creating setting "Minimum dollar offer"...
query: INSERT INTO setting (settinggroupid, title, varname, value, description, optioncode, displayorder)
VALUES (33,
"Minimum dollar offer",
"tdmin",
"1",
"Minimum dollar amount required to make an offer",
"",
2)

Creating setting "Maximum dollar offer"...
query: INSERT INTO setting (settinggroupid, title, varname, value, description, optioncode, displayorder)
VALUES (33,
"Maximum dollar offer",
"tdmax",
"20",
"Maximum dollar amount required to make an offer (granted the user has that many dollars to begin with)",
"",
3)

Running extra queries...
Running extra query 1 of 3...
query: ALTER TABLE user ADD dollars INT(10) UNSIGNED DEFAULT 20 NOT NULL AFTER posts
Running extra query 2 of 3...
query: ALTER TABLE thread ADD dollaroffer INT(10) UNSIGNED NOT NULL AFTER open
Running extra query 3 of 3...
query: ALTER TABLE forum ADD allowdollaroffers TINYINT(4) DEFAULT 1 NOT NULL AFTER allowposting
Creating custom templates...
Caching directory contents...
Caching custom template "error_baddollaroffer" (1 of 10)...
Caching custom template "error_badfunds" (2 of 10)...
Caching custom template "error_cantawardself" (3 of 10)...
Caching custom template "error_nodollarsoffered" (4 of 10)...
Caching custom template "newthread_makedollaroffer" (5 of 10)...
Caching custom template "postbit_awardbutton" (6 of 10)...
Caching custom template "redirect_dollaroffercancelled" (7 of 10)...
Caching custom template "redirect_transfercomplete" (8 of 10)...
Caching custom template "showthread_dollaroffer" (9 of 10)...
Caching custom template "showthread_dollaroffer_cancel" (10 of 10)...
Getting templatesetid for styleid 6...
query_first: SELECT templatesetid FROM style WHERE styleid = 6
Adding custom template "error_baddollaroffer" (1 of 10; 602 chars)...
query: INSERT INTO template (templatesetid, title, template) VALUES (6, "error_baddollaroffer", "Your dollar offer of $$dollaroffer cannot be accepted for one or more of the following reasons:

Low funds: you have $$bbuserinfo[dollars] in your account and you offered $$dollaroffer


Too low of an offer: the minimum allowed offer is $$tdmin


Too high of an offer: the maximum allowed offer is $$tdmax


Forum not accepting dollar offers: this forum may not accept dollar offers


Please use your browser\'s "Back" button to remedy the problem. If you do not want to offer any dollars, leave the Dollar Offer field blank.")
Adding custom template "error_badfunds" (2 of 10; 268 chars)...
query: INSERT INTO template (templatesetid, title, template) VALUES (6, "error_badfunds", "You do not have enough dollars to offer the required award.

You have: $$bbuserinfo[dollars] in your profile


Thread requires: $$thread[dollaroffer] award


Try to get more awards so you can "afford" the award yourself.")
Adding custom template "error_cantawardself" (3 of 10; 38 chars)...
query: INSERT INTO template (templatesetid, title, template) VALUES (6, "error_cantawardself", "You cannot offer an award to yourself.")
Adding custom template "error_nodollarsoffered" (4 of 10; 75 chars)...
query: INSERT INTO template (templatesetid, title, template) VALUES (6, "error_nodollarsoffered", "The specified thread does not exist or its starter did not offer any award.")
Adding custom template "newthread_makedollaroffer" (5 of 10; 420 chars)...
query: INSERT INTO template (templatesetid, title, template) VALUES (6, "newthread_makedollaroffer", "

This forum allows you to make dollar offers!
You have $$bbuserinfo[dollars] in your "account." The administrator has required that if you choose to make a dollar offer, it must be from $$tdmin to $$tdmax (inclusive).

Your dollar offer (leave blank for no offer): ")
Adding custom template "postbit_awardbutton" (6 of 10; 132 chars)...
query: INSERT INTO template (templatesetid, title, template) VALUES (6, "postbit_awardbutton", "")
Adding custom template "redirect_dollaroffercancelled" (7 of 10; 93 chars)...
query: INSERT INTO template (templatesetid, title, template) VALUES (6, "redirect_dollaroffercancelled", "The dollar offer for the thread has been cancelled. You will now be taken back to the thread.")
Adding custom template "redirect_transfercomplete" (8 of 10; 175 chars)...
query: INSERT INTO template (templatesetid, title, template) VALUES (6, "redirect_transfercomplete", "You have successfully transferred $$thread[dollaroffer] from your previous "account" of $$bbuserinfo[dollars] to the requested user. Taking you back to the thread...")
Adding custom template "showthread_dollaroffer" (9 of 10; 786 chars)...
query: INSERT INTO template (templatesetid, title, template) VALUES (6, "showthread_dollaroffer", "






$thread[postusername] has offered $$thread[dollaroffer] in this thread!
Typically, the "money" will be rewarded to the person who provides the best answer to the question in the post below. However it is up to the thread starter to how it is distributed.

$canceldollaroffer




")
Adding custom template "showthread_dollaroffer_cancel" (10 of 10; 291 chars)...
query: INSERT INTO template (templatesetid, title, template) VALUES (6, "showthread_dollaroffer_cancel", "

If you would like to retract the offer of $$thread[dollaroffer], click the link below. You cannot offer dollars once you cancel the offer!

Cancel Dollar Offer")

All done! Errors are highlighted above, if any occured. Now:

Delete this install script (/~filburt1/testvb/admin/install_turtledollars.php)


Delete the directory "templates_turtledollars" if you chose to install custom templates


Continue with the included installation instructions

[djr]

Filburt,

Love the concept! Not yet installed, because I've two questions:

• Is there a timer for the offer available? (see explanation below)
• Is there a Top 10 page available in the hack?

Reason for item 1 is my main concern authors will wait forever for an even better answer to appear than one which was probably already posted.

- djr

[filburt1]

1. No
2. No, but I can easily write one in less than an hour.

[filburt1]

This displays a "Top 10" list for who has the most Turtle Dollars, along with some statistics about outstanding threads and dollar distribution among members.

You must have installed the Turtle Dollars hack for this to work.

[filburt1]

Screenshot:

[N9ne]

Nice addon, keep up the good work filby .

[Brad]

Hey all, im editing the scripts so they will work with the store hack (as requested), ill try to have it out by tonight .

[Brad]

Add-on: Store hack Intergration.

Ive edited the scripts/template included in the "Turtle Dollars" zip file to work with the ever propular store hack.

Both files (minus the install script) where edited for the intergration, also a number of templates where changed and of course the "editing files" part of the readme.txt was changed.

You will need to have the store hack fully working before trying to install this.

If you already have both turtle dollars and the store hack installed but wish to use this, i sugest that you uninstall turtle dollars then re-install it using the file below.

This has not been tested! so ill mark it as unstable until someone trys it out and gets back to me.

enjoy and report bugs please :bunny: