I deleted Samples, How to fix it?rep++

[Ezak]

I deleted my samples from Database, anyone knows how to get them back ?

 

[Cloudy]

You do not have backup from your db?;o

 

[Ezak]

I have but how shall i Copy it to database/players ?

 

[frankfarmer]

Open config.ini

change

install="no"

to

install="yes"

after that just run the install trough http://localhost/install.php

and the samples will be added again

 

[Ezak]

Open config.ini

change

install="no"

to

install="yes"

after that just run the install trough http://localhost/install.php

and the samples will be added again

I freakin' love you <3

 

[frankfarmer]

I freakin' love you <3

this is also a solution, an easier one.

 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`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`, `exphist_lastexp`, `exphist1`, `exphist2`, `exphist3`, `exphist4`, `exphist5`, `exphist6`, `exphist7`, `onlinetimetoday`, `onlinetime1`, `onlinetime2`, `onlinetime3`, `onlinetime4`, `onlinetime5`, `onlinetime6`, `onlinetime7`, `onlinetimeall`) VALUES
(3, 'Sorcerer Sample', 0, 1, 1, 13, 1, 210, 210, 23200, 87, 114, 0, 114, 130, 0, 10, 185, 185, 0, 100, 1, 95, 117, 7, '', 560, 1, 1250337481, 16777343, 1, 0, 0, 0, '', 1250337505, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, '', 23200, 0, 23200, 0, 0, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 120),
(4, 'Druid Sample', 0, 1, 1, 13, 2, 210, 210, 23200, 116, 114, 82, 44, 128, 0, 10, 185, 185, 0, 100, 1, 95, 117, 7, '', 560, 1, 1250337423, 16777343, 1, 0, 0, 0, '', 1250337425, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, '', 23200, 0, 23200, 0, 0, 0, 0, 0, 0, 0, 1140, 0, 0, 0, 0, 0, 1140),
(5, 'Paladin Sample', 0, 1, 1, 13, 3, 235, 235, 23200, 0, 116, 116, 76, 129, 0, 0, 110, 110, 0, 100, 1, 95, 117, 7, '', 660, 1, 1250337299, 16777343, 1, 0, 0, 0, '', 1250337301, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, '', 23200, 0, 23200, 0, 0, 0, 0, 0, 0, 0, 1440, 0, 0, 0, 0, 0, 1440),
(6, 'Knight Sample', 0, 1, 1, 13, 4, 260, 260, 23200, 119, 78, 39, 116, 131, 0, 0, 60, 60, 0, 100, 1, 95, 117, 7, '', 720, 1, 1250337301, 16777343, 1, 0, 0, 0, '', 1250337304, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, '', 23200, 0, 23200, 0, 0, 0, 0, 0, 0, 0, 780, 0, 0, 0, 0, 0, 780);