vb.org Archive - Major Additions - vBCredits

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Major Additions - vBCredits - Ultimate Points System (https://vborg.vbsupport.ru/showthread.php?t=172399)

Quote:

Originally Posted by lafsunlmtd (Post 1845271)

hmmm.... it won't install on my master/slave server environ as is. it keeps trying to write to my slaves. I will try some other stuff and let you know if anything works.

do you have problems with other hacks or vbulletin not obeying this setting?

Quote:

Originally Posted by Saviour (Post 1845300)

Not sure if this has been covered before...too many posts to search.

Anyway...

When purchasing raffle tickets, I noticed that you will receive an error if you hit the Enter key instead of clicking on Purchase. It causes a database error with the below message:

Code:

Database error in vBulletin 3.8.3:

 

Invalid SQL:

SELECT * FROM vb_credits_lottery WHERE lotteryid =;

 

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Error Number : 1064

Request Date : Wednesday, July 8th 2009 @ 02:43:33 PM

Error Date : Wednesday, July 8th 2009 @ 02:43:34 PM

Script : http://xxxxxxxx.com/forums/credits.php?do=lottery

Referrer : http://xxxxxxxx.com/forums/credits.php?do=manage

IP Address : [removed]

Username : xxxxxx

Classname : vB_Database

MySQL Version : 5.0.67-log

Is this a bug? Is there a fix?

continued at support ticket

Quote:

Originally Posted by bluecamosis (Post 1847406)

Hi, I have a question about this hack. I've successfully installed it on my forums and it's working perfectly fine. But I have a query.

Is there a way to calculate the total amount of credits for a particular user group? I have 4 different "teams" in my forum, and I'm thinking of displaying the total amount of credits each group has accumulated, but I'm not sure how to do that. Help will be greatly appreciated thanks! =)

this isnt implemented by vbcredits no, but if you were making something custom you can query the user table based on usergroupid for a sum of the credits column

FWIW: We don't get this dB error when someone purchases a lottery ticket by hitting the "Enter Key" versus the "Purchase Button". I just tried it and it works fine.

ah ok, i think i know what you're saying, but i've never done such coding before. if there's a site or a tutorial on writing queries somewhere? i dont mind trying to write the code... better learn it now or never right, lol, yeah well. whatever help i can get is greatly appreciated.

(oh and i'm actually intending to show the accumulated sums on forumhome, i hope this query thing will work!!)

Im confused, on my loan box it says

Quote:

Amount must be between 200,000 and 1,000 Credits, and may be moderated. Minimum payments of 3.0% need to be paid back every 30 days to avoid late fees. Interest on outstanding balances is 19.5%. You may set up automatic payment plans. Your credibility rating may impact your interest rates or spending abilities.

now i dont know math well, but 1000 is smaller then 200,000.

How do I change the word credit, i went in global, but dont find it.
also what are "add-ons" for this addon?

Thanks

nice mod, I'll give it a try

I need to edit the files in the instalation.txt file?

Hello,

My name is Ray and I have recently installed vBcredits. I'm some what dumb when it comes to setting it up. I'm trying to figure out how to run a simple awards promotion based on points given for posting, starting threads, and referrals. I don't want to allow donations either. Do I simply set this up in "Manage Usergroup Awards" or do I need to change settings else were on the program?

Also, it say I can choose multiple groups in "Manage Usergroup Awards" but not sure how to choose multiples?

Thanks, and sorry for the noob question.

Ray

Quote:

Originally Posted by imported_silkroad (Post 1848285)

FWIW: We don't get this dB error when someone purchases a lottery ticket by hitting the "Enter Key" versus the "Purchase Button". I just tried it and it works fine.

ive been getting secondhand reports of this error for a long time and have never been able to reproduce it. this latest one went nowhere fast as well :(

Quote:

Originally Posted by bluecamosis (Post 1848646)

it would probably be a small job you would have to pay to make custom. the query part is pretty simple (stuff like: SELECT SUM(credits) FROM user WHERE usergroupid = X) but the actual arranging nicely on your homepage with templates and such is more in depth.

Quote:

Originally Posted by pandoros (Post 1850297)

Im confused, on my loan box it says

now i dont know math well, but 1000 is smaller then 200,000.

How do I change the word credit, i went in global, but dont find it.
also what are "add-ons" for this addon?

Thanks

your usergroup loan limit is 1000 but your global loan minimum is 200k - fix one or the other to make a valid range otherwise any attempt to get a loan will fail.

In the very first global setting for vbcredits, look in the description and theres a direct link to it. (the setting to enable vbcredits)

Some addons are listed here: http://www.vbcredits.com/projects/vbcredits/ along the left sidebar. However theres plenty of other addons that have variable settings to configure to use with vbcredits, plus third party addons that may be using vbcredits but didnt have to notify me

Quote:

Originally Posted by motorola (Post 1851041)

I need to edit the files in the instalation.txt file?

The templates it lists in the second half of the file.

Quote:

Originally Posted by 50calray (Post 1851113)

You can use that link yes, to choose multiple groups from that list hold down ctrl while you click additional groups.

This is awesome! Thanks!

And what I should do with these,, The templates it lists in the second half of the file.'' ?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02553 seconds Memory Usage 1,757KB 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 (1)bbcode_code_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: