RevScripts [OTBR] Reset all info/item/skill, leave only character name.

[Scrollia]

How i can make full reset game, items, house items, depo items, chatacters eq, etc, just leaving clean 8lvl nickname?

tfs 1.3, OTBR

 

[Scrollia]

BUMP?

 

[Snavy]

Something like this

DELETE FROM `player_storage`;
DELETE FROM `player_items`;
DELETE FROM `player_depotitems`;
DELETE FROM `player_deaths`;
DELETE FROM `player_spells`;
DELETE FROM `house_lists`;
DELETE FROM `tile_store`;

UPDATE `houses` SET
    `owner` = 0,
    `paid` = 0,
    `warnings` = 0,
    `rent` = 0,
    `bid` = 0,
    `bid_end` = 0,
    `last_bid` = 0,
    `highest_bidder` = 0;

UPDATE `players` SET
    `level`                 = 8,
    `experience`            = 4200,
    `health`                = 185,
    `healthmax`             = 185,
    `mana`                  = 35,
    `manamax`               = 35,
    `maglevel`              = 0,
    `manaspent`             = 0,
    `soul`                  = 100,
    `cap`                   = 420,
    `skull`                 = 0,
    `skulltime`             = 0,
    `blessings`             = 0,
    `deletion`              = 0,
    `balance`               = 0,
    `offlinetraining_time`  = 43200,
    `stamina`               = 2520,
    `skill_fist`            = 10,
    `skill_fist_tries`      = 0,
    `skill_club`            = 10,
    `skill_club_tries`      = 0,
    `skill_sword`           = 10,
    `skill_sword_tries`     = 0,
    `skill_axe`             = 10,
    `skill_axe_tries`       = 0,
    `skill_dist`            = 10,
    `skill_dist_tries`      = 0,
    `skill_shielding`       = 10,
    `skill_shielding_tries` = 0,
    `skill_fist`            = 10,
    `skill_fist_tries`      = 0,
    `skill_fishing`         = 10,
    `skill_fishing_tries`   = 0

 

[Scrollia]

Something like this

DELETE FROM `player_storage`;
DELETE FROM `player_items`;
DELETE FROM `player_depotitems`;
DELETE FROM `player_deaths`;
DELETE FROM `player_spells`;
DELETE FROM `house_lists`;
DELETE FROM `tile_store`;

UPDATE `houses` SET
    `owner` = 0,
    `paid` = 0,
    `warnings` = 0,
    `rent` = 0,
    `bid` = 0,
    `bid_end` = 0,
    `last_bid` = 0,
    `highest_bidder` = 0;

UPDATE `players` SET
    `level`                 = 8,
    `experience`            = 4200,
    `health`                = 185,
    `healthmax`             = 185,
    `mana`                  = 35,
    `manamax`               = 35,
    `maglevel`              = 0,
    `manaspent`             = 0,
    `soul`                  = 100,
    `cap`                   = 420,
    `skull`                 = 0,
    `skulltime`             = 0,
    `blessings`             = 0,
    `deletion`              = 0,
    `balance`               = 0,
    `offlinetraining_time`  = 43200,
    `stamina`               = 2520,
    `skill_fist`            = 10,
    `skill_fist_tries`      = 0,
    `skill_club`            = 10,
    `skill_club_tries`      = 0,
    `skill_sword`           = 10,
    `skill_sword_tries`     = 0,
    `skill_axe`             = 10,
    `skill_axe_tries`       = 0,
    `skill_dist`            = 10,
    `skill_dist_tries`      = 0,
    `skill_shielding`       = 10,
    `skill_shielding_tries` = 0,
    `skill_fist`            = 10,
    `skill_fist_tries`      = 0,
    `skill_fishing`         = 10,
    `skill_fishing_tries`   = 0

Worked very well, how can i reset coins? i tried
UPDATE accounts SET
coins = 0,, but didnt work.

 

[M4rcin]

Worked very well, how can i reset coins? i tried
UPDATE accounts SET
coins = 0,, but didnt work.

try using SHOW COLUMNS FROM accounts; to get to know the column name.

 

[Scrollia]

try using SHOW COLUMNS FROM accounts; to get to know the column name.

ok now worked, btw :

Can i add that players a 'first eq' as they have at begining? Now they have nogthing. i need something like 'update eq like samples has'

 

[kamilcioo]

ok now worked, btw :

Can i add that players a 'first eq' as they have at begining? Now they have nogthing. i need something like 'update eq like samples has'

Reset last login and add them in game on first login.