Anyone can explain me how these MuOnline SQL tables work?

i dont understand the following tables:

MANG_INFO (PRIORITY PLEASE)

MEMB_STAT_GJ

MgItemLog

MEMB_DETA

also table QUESTIONS which has like 22000 rows of ??????

all in MuOnline DB

Quote:

---

Originally Posted by anapse

i dont understand the following tables:

MANG_INFO (PRIORITY PLEASE)

MEMB_STAT_GJ

MgItemLog

MEMB_DETA

also table QUESTIONS which has like 22000 rows of ??????

all in MuOnline DB

---

Well i dont know much but you'll need to think logically of what a each table means by viewing it and understanding it that way.
lets say memb_stat its like status of connection each player/character
if u open in properties mang_info u can see few columns like mang_guid , guid is like ID i think since in memb_info the memb__guid is the number id of each account, then mang___id = like the ID and mang__pwd = password, mang_name is nickname obviously, auth_code thats auth code also, appl_day when it has been applied, and perm = permission, honestly i dont think you wil need this anywhere ?

anyawys as matter of memb_stats_gj its like memb_stat but seems like not usable and has fewer details, its like i said, status of your server when players connected connectstats 0 = offline 1 = online, which ip, what time connected etc etc.

same with mgitemlog, something u dont need to play with, and dont know why its there, i mean try to Delete those stuff, and recheck if there will be any issues, if there will be u will directly find out what they are :)

Quote:

---

Originally Posted by KarLi

Well i dont know much but you'll need to think logically of what a each table means by viewing it and understanding it that way.
lets say memb_stat its like status of connection each player/character
if u open in properties mang_info u can see few columns like mang_guid , guid is like ID i think since in memb_info the memb__guid is the number id of each account, then mang___id = like the ID and mang__pwd = password, mang_name is nickname obviously, auth_code thats auth code also, appl_day when it has been applied, and perm = permission, honestly i dont think you wil need this anywhere ?

anyawys as matter of memb_stats_gj its like memb_stat but seems like not usable and has fewer details, its like i said, status of your server when players connected connectstats 0 = offline 1 = online, which ip, what time connected etc etc.

same with mgitemlog, something u dont need to play with, and dont know why its there, i mean try to Delete those stuff, and recheck if there will be any issues, if there will be u will directly find out what they are :)

---

thank you a lot karli but i was just curious because i've been playing on my own server testing stuff, also friends played and did stuff, there were like 10 accounts created testing everything and some of these tables were empty, thats why i couldnt perceive what was going on there, anyway, perfect answer. i am still curious what "QUESTIONS" table is, have you checked your MuOnline db to see if that table is there? i thas 22000 rows of chinese stuff for what i can tell because its filled with ????? and sometimes you can see a random word, it looks like a questionary with answers. maybe Mu Online event related?

if u mean on muonlkine tables, ofcourse its muonline related, those tables make things work in game, lets say accounts creating characters,making resets, those things connect also with your exdb/dataserver and the rest of your files, mostly with gameserver, also ur website connect withit, and the rest tables are just other stuff, lets say without Character table you couldnt make character in game.
and the list goes on.....