Solved Deleted data

[Testerus]

Hello everyone!
I deleted the Sorcerer/Druid/Knight/Paladin samples by mistake.
Do you know how I can recover them or undo this action?
Any help is considered.

Kind regards.

 

[filipus]

are you talking about the vocations?
You can probably download the things again. Doubt you can undo.

 

[Testerus]

I think it's obvious.
But How can I do that?

 

[Himii]

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `cast`, `castViewers`, `castDescription`, `comment`, `create_ip`, `create_date`, `hide_char`) VALUES
(1, 'Rook Sample', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 1000, 999, 7, '', 400, 0, 1394244448, 1389881178, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', '', 0, 0, 0),
(2, 'Sorcerer Sample', 0, 1, 1, 1, 1, 150, 150, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 1000, 999, 7, '', 400, 0, 1394244448, 1389881178, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', '', 0, 0, 0),
(3, 'Druid Sample', 0, 1, 1, 1, 2, 150, 150, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 1000, 999, 7, '', 400, 0, 1394244448, 1389881178, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', '', 0, 0, 0),
(4, 'Paladin Sample', 0, 1, 1, 1, 3, 150, 150, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 1000, 999, 7, '', 400, 0, 1394244448, 1389881178, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', '', 0, 0, 0),
(5, 'Knight Sample', 0, 1, 1, 1, 4, 150, 150, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 1000, 999, 7, '', 400, 0, 1394244448, 1389881178, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', '', 0, 0, 0);

This?

 

[Testerus]

Can you tell me an exact path for where to put this?
And what's the file's name? And Is it .php?
Thanks.

 

[Limos]

Run the query in your database (click on SQL, paste the query and click on Go).



Problem solved in teamviewer with the query Himii posted (with a few edits because of difference in colomns and used ids).
http://pastebin.com/5ftPg0Sh