Create Character 600,300 Error

[silkbotter]

Originally Posted by Bigshow107

ya UG admin had same problem i helped him for that bt dk ... if he fixed xD
=======
oh
lol if u said u wont release it why the fu** you made anti gm ? ....

i never said that.. please check the date of this topic:
i released it long time ago ^^
maybe you misunderstood something

[Bigshow107]

Originally Posted by silkbotter

i never said that.. please check the date of this topic:
i released it long time ago ^^
maybe you misunderstood something

lol
i was not talking to u ....
i was talking to lolly0001
since he said he wont release hes server so why he need anti gm /

[lol2k1]

here is the currect anti gm hack with DEVS .
*you just need to change the GM chars to ur GMs names .

DELETE FROM character.dbo.user_character
WHERE character_name < '['
AND character_name <> '[DEV]SUMMONER' 
AND character_name <> '[DEV]HUNTER' 
AND character_name <> '[DEV]WARRIOR'
AND character_name <> '[DEV]KNIGHT'
AND character_name <> '[DEV]SEGNALLE'
AND character_name <> '[DEV]MAGICIAN'
AND character_name <> '[GM][B]YourNameHere[/B]'
AND character_name <> '[GM][B]YourNameHere[/B]'
AND character_name <> '[GM][B]YourNameHere[/B]'

Leave Thanks If I Helped

[lolly0001]

Do I just need to add the [DEV]'Names in the anti gm job? I don't have to 'recreate' them right?
Does the Siege work with the Database of janvier123 or doesn't it has to do anything with that, because trane.'s topic says something with database working siege etc.
(and yes big show, i am not releasing, i am trying and learning with all these, I would like to have them...)

[*JayKay*]

Restore your database character is to query analizer select the character database and run the following script that will stop the error 600.300


use character;
DELETE FROM C_EVENT_ITEM_OP
DELETE FROM c_restword;
DELETE FROM c_sequence;
DELETE FROM char_connlog;
DELETE FROM CHAR_CONNLOG_KEY;
DELETE FROM DEL_USER_CHAR_LIST;
DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
DELETE FROM GM_ITEM_MST;
DELETE FROM GUILD_CHAR_INFO;
DELETE FROM GUILD_INFO
WHERE guild_code NOT LIKE 'MASTERCODE';
DELETE FROM GUILD_INFO_SECEDE;
DELETE FROM GUILD_PEERAGE
WHERE guild_code NOT LIKE 'MASTERCODE';
DELETE FROM MSSNGR_CHAR_LIST;
DELETE FROM SIEGE_INFO;
DELETE FROM SIEGE_RESULT_LOG;
DELETE FROM user_bag
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_bag_copy;
DELETE FROM user_bag_secede;
DELETE FROM user_character
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_character_secede;
DELETE FROM USER_POSTBOX;
DELETE FROM USER_POSTBOX_SECEDE;
DELETE FROM User_Quest_Doing;
DELETE FROM user_quest_doing_secede;
DELETE FROM User_Quest_Done;
DELETE FROM user_quest_done_secede;
DELETE FROM user_skill
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_skill_secede
DELETE FROM user_slot
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_storage;
DELETE FROM user_storage_copy;
DELETE FROM USER_STORE;
DELETE FROM USER_STORE_copy;
DELETE FROM USER_STORE_SECEDE;
DELETE FROM user_suit
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_suit_copy;
DELETE FROM user_suit_secede;

enjoy!!!!

[Zombe]

Originally Posted by arthurvalenca

Restore your database character is to query analizer select the character database and run the following script that will stop the error 600.300


use character;
DELETE FROM C_EVENT_ITEM_OP
DELETE FROM c_restword;
DELETE FROM c_sequence;
DELETE FROM char_connlog;
DELETE FROM CHAR_CONNLOG_KEY;
DELETE FROM DEL_USER_CHAR_LIST;
DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
DELETE FROM GM_ITEM_MST;
DELETE FROM GUILD_CHAR_INFO;
DELETE FROM GUILD_INFO
WHERE guild_code NOT LIKE 'MASTERCODE';
DELETE FROM GUILD_INFO_SECEDE;
DELETE FROM GUILD_PEERAGE
WHERE guild_code NOT LIKE 'MASTERCODE';
DELETE FROM MSSNGR_CHAR_LIST;
DELETE FROM SIEGE_INFO;
DELETE FROM SIEGE_RESULT_LOG;
DELETE FROM user_bag
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_bag_copy;
DELETE FROM user_bag_secede;
DELETE FROM user_character
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_character_secede;
DELETE FROM USER_POSTBOX;
DELETE FROM USER_POSTBOX_SECEDE;
DELETE FROM User_Quest_Doing;
DELETE FROM user_quest_doing_secede;
DELETE FROM User_Quest_Done;
DELETE FROM user_quest_done_secede;
DELETE FROM user_skill
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_skill_secede
DELETE FROM user_slot
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_storage;
DELETE FROM user_storage_copy;
DELETE FROM USER_STORE;
DELETE FROM USER_STORE_copy;
DELETE FROM USER_STORE_SECEDE;
DELETE FROM user_suit
WHERE character_no NOT LIKE 'DEKARON_000001';
DELETE FROM user_suit_copy;
DELETE FROM user_suit_secede;

Leeched from Zombe's tutorial,
enjoy!!!!

Fixed.

[lolly0001]

lol! let's see if it works

[Zombe]

Originally Posted by lolly0001

lol! let's see if it works

It won't work. That's my script, but what it does is delete everything from the DB except what is required to run (GM parameters, DEVs and the guild MASTERCODE). Ugh. People need to learn SQL if they want to host a server. You didn't think that all the DELETE lines are suspicious? It keeps the DEVs, but it doesn't create them. Sorry.

[lolly0001]

I know, I know.
It's np, just made a new Database.
Thanks! =)