PROBLEM TO FIX PrivateSRO

HELLO, i have some problem to fix some bugs for run my PrivateSro
ex:
Cant create a new char error (S1030) ----> [Only registered and activated users can see links. Click Here To Register...]
Cant log in char created from Database, when i select the char and i click on ''START'' nothing appen (no DC no CRASH)

i need help from Skype or TeamViewer.

Skype: Madara8000 ----> add me and pm me please!


TNX.

clean your database maybe..

Quote:

Originally Posted by MissinGDeaTh clean your database maybe..

tnx for the answer, im new in this sector, can you explain me how clean the db or link me a guide how do it?

Probably this error happens cause of 2 things
1-The area where it should spawn(The character) is disabled.
2-Something wrong in _AddNewChar for example the procedure gives the character something which does not exist.
I suggest you to use a clean Database.

Quote:

Originally Posted by xfilesman tnx for the answer, im new in this sector, can you explain me how clean the db or link me a guide how do it?

Quote:

truncate table _GuildChest DELETE FROM _Guild WHERE ID > 0 delete from _AlliedClans where ID > 0 truncate table _GuildMember truncate table _SiegeFortressStoneState truncate table _SiegeFortressRequest truncate table _SiegeFortressObject truncate table _SiegeFortressItemForge truncate table _SiegeFortressBattleRecord truncate table _SiegeFortressStruct delete from _SiegeFortress truncate table _OpenMarket DELETE FROM _CharAlchemy_MK_Recipe DELETE FROM _TradeBagInventory DELETE FROM _TradeEquipInventory truncate table _CharSkill truncate table _CharSkillMastery truncate table _BlockedWhisperers truncate table _Inventory truncate table _InventoryForAvatar truncate table _InventoryForLinkedStorage truncate table _TrainingCampMember truncate table _TrainingCampSubMentorHonorPoint truncate table _TrainingCampHonorRank truncate table _TrainingCampBuffStatus delete from _TrainingCamp truncate table _StaticAvatar truncate table _User truncate table _Friend truncate table _Memo truncate table _TimedJob truncate table _CharTrijobSafeTrade delete from _CharTrijob truncate table _InvCOS delete from _CharCOS where ID > 0 delete from _Char where charid > 0 truncate table _Chest truncate table _ChestInfo truncate table _ItemPool delete from _Items where ID64 > 0 delete from _AccountJID update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 truncate table _GuildWar truncate table _CharNameList truncate table _CharQuest truncate table _ClientConfig truncate table _DeletedChar

try this

ok database cleaned and the problem is the same..

Quote:

Originally Posted by Crayon ™ Probably this error happens cause of 2 things 1-The area where it should spawn(The character) is disabled. 2-Something wrong in _AddLogChar for example the procedure gives the character something which does not exist. I suggest you to use a clean Database.

dont exist AddLogChar

SRO_VT_SHARD -> Stored Procedures -> dbo._AddNewChar
Edit account database name to your current one.
Hint: the last 4/3 lines on the procedure.

Quote:

Originally Posted by Eric1337* SRO_VT_SHARD -> Stored Procedures -> dbo._AddNewChar Edit account database name to your current one. Hint: the last 4/3 lines on the procedure.

thx it's fixed
#request_close