Account type s8 ( al0-al1-al2-al3)

how i can configure each account , lets say for some ppl ( VIP ) to be al1,and normal ppl 0
i found a way thru MSSQL but..i have to search the exact name account....each time....or there is a sql command for it?

i dont understand whats al0 al1 al2 al3

well, if you have 1 server,and 1 sub server,the subserver you will change it in configs at 1,instead of 0 ( 0 its for everyone) 1 its for AL1, 2 its for AL2, like VIP, if a normal account try to join a VIP subserver,it gives you "no charge info"

i think u are confusing it, if u want to have same server type u just copy and use the same configs/gs folders and just change ports/ser code number


Sent from my iPhone.

i did, i have the same DB for 2 servers :) one its normal, one its VIP , for VIP i have to change ur account type so you can login ! but i need to search for each account i want to make VIP, i was thinking maybe there is a SQL command like "Execute "account name" accounty type 1 or something like that

ofcourse you can create a sql query... its easy .. but i dont know your SQL character Tables how they look like so i cant help u and which exact db

a printscreen will help? tell me what to tell you..oh and ofcourse "Expiration date" for that VIP account...

Sure a print screen of the database>muonline>MEMB_INFO and Character table.
also if you have VIP tables that you update manually there make screenshots of them too and ill try to make a query for ya.

member - if you see at member,account leve,that one its for VIP, i mean 0 its normal, 1 its VIP
http://i64.tinypic.com/egaljs.png
character
http://i64.tinypic.com/2pqvxg5.png

- - - Updated - - -

hmm...i edited that thing manualy, with expiration date and so on...and it didn't saved..i had to close the server,and save it,and then open it...

sorry i wasn't home please show me what table says VIP and vip expiration date i didnt see that i see only accountlevel and account expiriation thing on memb_info?

there is no VIP and VIP expiration table...look at first photo, it says account lvl ( 0 normal - 1 VIP ) and expiration date i have to add the date,hour,min,seconds... but i'm not sure if it's working..because after the day/hour/min/seconds pass, it wont return to account lv 0 , stays at account lv 1