Create Character 600,300 Error

Page 2 of 2 1 2
09/27/2009 20:14 silkbotter#16
Quote:
Originally Posted by Bigshow107 View Post
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: [Only registered and activated users can see links. Click Here To Register...]
i released it long time ago ^^
maybe you misunderstood something :)
09/27/2009 21:20 Bigshow107#17
Quote:
Originally Posted by silkbotter View Post
i never said that.. please check the date of this topic: [Only registered and activated users can see links. Click Here To Register...]
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 /
09/27/2009 21:21 lol2k1#18
here is the currect anti gm hack with DEVS .
*you just need to change the GM chars to ur GMs names .

Code:
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 :D
09/27/2009 22:48 lolly0001#19
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...)
09/28/2009 02:37 *JayKay*#20
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!!!!
09/28/2009 07:38 Zombe#21
Quote:
Originally Posted by arthurvalenca View Post
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.
09/28/2009 13:49 lolly0001#22
lol! let's see if it works
09/28/2009 15:46 Zombe#23
Quote:
Originally Posted by lolly0001 View Post
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.
09/28/2009 19:25 lolly0001#24
I know, I know.
It's np, just made a new Database.
Thanks! =)
Page 2 of 2 1 2