auto vip r63b

[St4nley]

how do i set auto vip when someone has registered in r63b i set it to 1 in design table under users but it would bounce back to 0 after saving.......

thanks

 

[Evilsmoothie]

Uhh.. ?? If I understand you correctly, you tried to set vip to 1 by default in the database?

Which cms are you using?

 

[St4nley]

Uhh.. ?? If I understand you correctly, you tried to set vip to 1 by default in the database?

What cms are you using?

yes sir, and its ubercms, i meant to say deafult vip 1, also the database is in fucking spanish cause

You must be registered for see links

is a mexican and i cant find anything else so i have to translate it....


but on topic how do i set vip 1 deafult?

 

[Evilsmoothie]

Try to run this:

ALTER TABLE  `users` CHANGE  `vip`  `vip` ENUM(  '0',  '1' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT  '1'

If that is what you tried earlier, then I'd like to have a link to the cms so I can actually look in the files.

 

[St4nley]

Try to run this:

ALTER TABLE  `users` CHANGE  `vip`  `vip` ENUM(  '0',  '1' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT  '1'

If that is what you tried earlier, then I'd like to have a link to the cms so I can actually look in the files.

it worked, thanks sql king has done it again. Appreciate it

Close thread.

 

[Legion]

Problem Solved.

Thread closed