The Arcive of vBulletin Modifications Site.

help with secondary usergroups · **Released**: 02-11-2005

How do I restrict which secondary usergroups a member can purchase?

kall · #2 02-11-2005, 05:40 PM

Quote:

Originally Posted by carolmyt

How do I restrict which secondary usergroups a member can purchase?

Scroll to the bottom of the Action's settings page, there is a field in the Action Specific Variables section to enter the usergroupid.

carolmyt · #3 02-11-2005, 08:43 PM

Can you be more specific? Are you talking about in the php file?

kall · #4 02-11-2005, 11:16 PM

Quote:

Originally Posted by carolmyt

Can you be more specific? Are you talking about in the php file?

Uttstore Admin - Action Manager - Select the Secondary Usergroup action - Edit - Scroll to the bottom.

carolmyt · #5 02-12-2005, 04:56 PM

Isn't that to restrict which groups can purchase the option, not which groups they can purchase?

carolmyt · #6 02-13-2005, 05:55 PM

Ok, my problems with this part of the shop are blossoming. When I first installed this hack, I deleted this option. Now that I'm trying to use it, I've reinstalled it as is (I haven't tried to change the code at all yet), I'm getting an SQL error when I try to purchase the option:

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT * FROM usergroup WHERE usergroupid IN ()
mysql error: You have an error in your SQL syntax near ')' at line 1

mysql error number: 1064

Any help with this?