[Freesteyelz]

I'm currently testing this mod. I think you've done an awesome job, Andreas. Is it possible to add (either in XML or SQL Query) variance in the amount of cash (default 500) by Usergroup upon registration and current registries? This is what I'm thinking:

In XML:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD vbookie_cash BIGINT UNSIGNED DEFAULT '500' AFTER pmunread WHERE usergroupid='x'");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD vbookie_cash BIGINT UNSIGNED DEFAULT '1500' AFTER pmunread WHERE usergroupid='y'");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD vbookie_cash BIGINT UNSIGNED DEFAULT '5000' AFTER pmunread WHERE usergroupid='z'");

And:

	$db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=500" WHERE usergroupid='x');
	$db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=1500" WHERE usergroupid='y');
	$db->query_write("UPDATE " . TABLE_PREFIX . "user SET vbookie_cash=5000" WHERE usergroupid='z');

Where "x", "y" and "z" are the specified UserIDs will be set. I realize that there isn't a "usergroupid" TABLE but I'm not sure of the workaround.

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

EDITED: I modified the code bit and this part worked in SQL Query. Well, sort of. It only changes curent registered members upon usergroupid definition. New registries still inherit default vcash settings:

UPDATE user SET vbookie_cash='500' WHERE usergroupid='x';
UPDATE user SET vbookie_cash='1000' WHERE usergroupid='y';
UPDATE user SET vbookie_cash='5000' WHERE usergroupid='z';

For ALTER TABLE in SQL Query I'm trying to figure out this:

ALTER TABLE vbtest_user ADD vbookie_cash BIGINT UNSIGNED DEFAULT '5000' WHERE usergroupid='z' AFTER pmunread;

I'm getting a syntax error at "WHERE usergroupid='z'". Then again, do I need this portion for new and current registries to work properly?

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

Edited Again: I could set SQL Query for userids such as:

UPDATE vbtest_user SET vbookie_cash='5000' WHERE userid='z';

Although I'd prefer doing it mass in XML or SQL Query. If it's not possible, by setting individual variance in SQL Query will it create a DB problem?