• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Bug Sample DB

T

tatiana

Sexy Girl
Joined
Mar 30, 2009
Messages
215
Reaction score
8
I'd like to know why my Sample chares are being erased after 15 days to 30 days, I can not say for sure, but what can cause this? Script that uses the database? Could someone give me a hand?
 
Sort by date Sort by votes
For tfs 1.x
Account Manager
Code: 
INSERT INTO `Nome Da Sua Tabela`.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('1', 'Account Manager', '1', '1', '1', '0', '150', '150', '0', '0', '0', '0', '0', '128', '0', '0', '5', '5', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
Rook Sample
Code: 
INSERT INTO ` Nome Da Sua Tabela `.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('2', 'Rook Sample', '1', '1', '1', '0', '150', '150', '0', '0', '0', '0', '0', '128', '0', '0', '5', '5', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
Sorcerer Sample
Code: 
INSERT INTO ` Nome Da Sua Tabela `.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('3', 'Sorcerer Sample', '1', '1', '8', '1', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
Druid Sample
Code: 
INSERT INTO ` Nome Da Sua Tabela `.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('4', 'Druid Sample', '1', '1', '8', '2', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
Paladin Sample
Code: 
INSERT INTO ` Nome Da Sua Tabela `.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('5', 'Paladin Sample', '1', '1', '8', '3', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
knight Sample
Code: 
INSERT INTO ` Nome Da Sua Tabela `.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('6', 'Knight Sample', '1', '1', '8', '4', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
 
Upvote 0 Downvote
_M4G0_ said:
For tfs 1.x
Account Manager
Code: 
INSERT INTO `Nome Da Sua Tabela`.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('1', 'Account Manager', '1', '1', '1', '0', '150', '150', '0', '0', '0', '0', '0', '128', '0', '0', '5', '5', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
Rook Sample
Code: 
INSERT INTO ` Nome Da Sua Tabela `.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('2', 'Rook Sample', '1', '1', '1', '0', '150', '150', '0', '0', '0', '0', '0', '128', '0', '0', '5', '5', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
Sorcerer Sample
Code: 
INSERT INTO ` Nome Da Sua Tabela `.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('3', 'Sorcerer Sample', '1', '1', '8', '1', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
Druid Sample
Code: 
INSERT INTO ` Nome Da Sua Tabela `.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('4', 'Druid Sample', '1', '1', '8', '2', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
Paladin Sample
Code: 
INSERT INTO ` Nome Da Sua Tabela `.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('5', 'Paladin Sample', '1', '1', '8', '3', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
knight Sample
Code: 
INSERT INTO ` Nome Da Sua Tabela `.`players` (`id`, `name`, `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`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`) VALUES ('6', 'Knight Sample', '1', '1', '8', '4', '185', '185', '4200', '0', '0', '0', '0', '128', '0', '0', '35', '35', '0', '100', '1', '32369', '32241', '7', '500', '1', '1464634466', '1678343099', '1', '0', '0', '1464634617', '30', '168', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '100', '44028', '10', '0', '10', '0', '83', '29878', '10', '0', '0', '', '', '2130706433', '1459558722', '0', '0');
Click to expand...
and about otx 7.72?
 
Upvote 0 Downvote
Back
Top