[uShop] Mass-Give Points

What this will do is it will enable you to mass-give points to your users if you use the uShop system. I have tested this with uShop 0.93.

To install, upload gimme.php into either your modcp or admincp directory.

If you want a different usergroup to access it other than usergroup ID 6 (administrators), then look for this in gimme.php and then change the red number to the desired usergroup ID:

// ###################################################################
// ## CHANGE THIS SETTING
// ##	 Make this the usergroup ID that will have access to this 
// ##    script. All other usergroups will be denied.
// ###################################################################

define('CAN_ACCESS_UGROUP', 6);

[ThaEbilSlaya]

i am having a lil trouble with this when i add a name to the input and add the number of points to give when i click to add them i get a database error

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM user WHERE username = 'ThaEbilSlaya'
mysql error: Table 'twh1980_vb.user' doesn't exist

mysql error number: 1146

can anyone help with how to fix this

[scriptjunkie]

Click...Click...Click!

[neila]

Originally Posted by ThaEbilSlaya

i am having a lil trouble with this when i add a name to the input and add the number of points to give when i click to add them i get a database error

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM user WHERE username = 'ThaEbilSlaya'
mysql error: Table 'twh1980_vb.user' doesn't exist

mysql error number: 1146

can anyone help with how to fix this

I'm having an almost identical error. Can anyone help?

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE user SET uttpoints=uttpoints+100 WHERE userid IN('60')
mysql error: Table 'flyguyc_forums.user' doesn't exist

mysql error number: 1146

Date: Thursday 09th of December 2004 05:46:08 PM

[Celtic_Mad]

Is there any way I could get this to work with vBookie to give vCash if I'm not using uShop?

[bahawolf]

Is there a way to give every member points for say, Christmas?

[trackpads]

A usergroup addition would be awesome! Nice work!

[docvader]

Originally Posted by trackpads

A usergroup addition would be awesome! Nice work!

Yes, that would be the way to go. Typing in all those names is a bit time consuming, LOL.

[rob_daemon]

Alright, the usergroup select is now ready .

Happy holidays!

[docvader]

Awesome. Works great. Just in time to give out cash.

Thanks,
rich

[Kalomax]

sometime i get this error

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM user WHERE username = 'nhoclx'
mysql error: Table 'ldpit_dtlxit.user' doesn't exist

mysql error number: 1146

Date: Sunday 02nd of January 2005 12:29:55 AM
Script: http://x.x.x/forums/admincp/gimme.php
Referer: http://x.x.x/forums/admincp/gimme.php
Username: admin
IP Address: x.x.x.x

I'm in group 6 and my forum uses uShop 0.95b


And when it runs, i can add point for user group, but not for some username i put. I got "No users were requested."