[Darkwaltz4]

Originally Posted by lafsunlmtd

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?

Originally Posted by Saviour

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:

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

Originally Posted by bluecamosis

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