database: 2 simple questions
hi, i need two simple answers, but no scripts.
1. what must i change in the [ACCOUNT_TBL] to ban the account? i guess its [member], to what it needs to be changed then?
2. do removed characters are still exist in the [CHARACTER_TBL]? if yes, i prolly have to check the [CHARACTER_TBL_DEL] to check a character is removed, right?
sry i cant just try it out, cuz i cant run a pserver in this machine. :s
thank you.
Re: database: 2 simple questions
1. In ACCOUNT_TBL_DETAIL, you need to put a date in the BlockTime column to ban the account. It can function as a temporary ban, or permanent (if you set it to a ridiculously high date).
2. Characters are considered deleted if the "isblock" column in CHARACTER_TBL is set to D. It doesn't actually remove any data though, it just changes that column.
Re: database: 2 simple questions
1. ouh, i didnt care the ACCOUNT_TBL_DETAIL until now, so i have to edit my register script and put a dataset into this too? can u tell me which columns in the [ACCOUNT_TBL_DETAIL] are expected to be filled out by the game? although which values are default? ofc i do not need information about [account], [regdate], [isuse] and [email].
2. thx, which letter is used if the character is not deleted on [isblock] at [CHARACTER_TBL]?
Re: database: 2 simple questions
1. [gamecode] = "A000", [tester] = 2, [m_chLoginAuthority] = "F", [BlockTime] = "20010101", [EndTime] = "20990101", [WebTime] = "20050101", and [secession] = NULL
The 3 date values don't have to be that exactly. BlockTime can be anytime before the current date. EndTime I'm guessing determines when their account is no longer valid. and I have no idea what the purpose of WebTime is.
2. "F" is the default value.
Re: database: 2 simple questions
Quote:
Originally Posted by
ShadowDragon42
1. [gamecode] = "A000", [tester] = 2, [m_chLoginAuthority] = "F", [BlockTime] = "20010101", [EndTime] = "20990101", [WebTime] = "20050101", and [secession] = NULL
The 3 date values don't have to be that exactly. BlockTime can be anytime before the current date. EndTime I'm guessing determines when their account is no longer valid. and I have no idea what the purpose of WebTime is.
2. "F" is the default value.
oh great that makes sense and helps alot, thank you. http://www.greensmilies.com/smile/sm...ns_thumbs1.gif
Re: database: 2 simple questions
maybe you need a ban script :)
Re: database: 2 simple questions
Quote:
Originally Posted by
Levixavier
maybe you need a ban script :)
no, thx. i wont profit from ripping anything. i prefer program it myself to improve my skills =)
although the website im working on got a more complex system due more features and a strict class hierarchy.