AAC Reset my accounts Znote

[ralke]

Using: ZNOTE AAC/ OTX 2.5 (tfs 0_3)

Hi again, i found this mysql query to reset my accounts

DELETE FROM houses; DELETE FROM house_auctions; DELETE FROM house_data; DELETE FROM house_lists;
UPDATE players SET posx = 1160, posy = 1084, posz = 7, town_id = 1
update players set level=8, health=185, healthmax=185, mana=35, manamax=35, manaspent=0, maglevel= 0, stamina=151200000, cap=470, balance=0, promotion=0;
update player_skills set value=10, count=0;
truncate player_items;
truncate player_depotitems;
truncate player_storage;
truncate houses;
truncate tiles;
truncate tile_items;

but i have this error when execute

Also need to add that i have this errors when i write the query:

- urecognized statemen type (near truncate)
- the type of clause was previously parsed (near update)

can you help me? thanks in advance!!

 

[Xikini]

I'm assuming that ";" is missing from the end of that line.
I don't know much about mysql query's though

 

[ralke]

Also need to add that i have this errors when i write the query:

- urecognized statemen type (near truncate)
- the type of clause was previously parsed (near update)

@Xikini thanks for responding as always!!

EDIT: i added ; symbol on line 2 but now got this error on truncate houses

1 errors were found during analysis.
Unrecognized statement type. (near "truncate" at position 0)

SQL query:

truncate houses

MySQL said:

#1701 - Cannot truncate a table referenced in a foreign key constraint (`zkdata`.`house_auctions`, CONSTRAINT `house_auctions_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `zkdata`.`houses` (`id`, `world_id`))

also need to clean my highscores tables!! exp points have not been reset but level reset is working

 

[ralke]

bump!! need to reset this too

 

[ralke]

solved

 

[Itutorial]

Post solution please for other users. Im sure you had to add a ignore for certain keys.

 

[ralke]

Post solution please for other users. Im sure you had to add a ignore for certain keys.

ok i added experience=4800 for the experience issue with this final code

DELETE FROM houses; DELETE FROM house_auctions; DELETE FROM house_data; DELETE FROM house_lists;
UPDATE players SET posx = 1160, posy = 1084, posz = 7, town_id = 1
update players set level=8, health=185, experience=4800, healthmax=185, mana=35, manamax=35, manaspent=0, maglevel= 0, stamina=151200000, cap=470, balance=0, promotion=0;
update player_skills set value=10, count=0;
truncate player_items;
truncate player_depotitems;
truncate player_storage;
truncate houses;
truncate tiles;
truncate tile_items;

also i understand that using truncate is the query to reset any table, example:

truncate house_auctions;
truncate player_killers;
truncate guild_invites;
truncate guild_wars;
etc..

also, this error did not affect the query i send, and the reset of tables was succeed

1 errors were found during analysis.
Unrecognized statement type. (near "truncate" at position 0)
SQL query:
truncate houses
MySQL said:
#1701 - Cannot truncate a table referenced in a foreign key constraint (`zkdata`.`house_auctions`, CONSTRAINT `house_auctions_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `zkdata`.`houses` (`id`, `world_id`))

thanks @Znote for helping me with this issue!!