Reset My ot problem

[deivil70]

Hey guys i need to reset players data,lvl,house owners, everything like i want to make the server back to 0 without deleting my account manager
Iam also using sqlite (sqlite studio etc) not Mysql or phpmyadmin or any of these
any ideas please ?

 

[HalfAway]

If you use a server with account manager the manager should be included in the sqlite database file.
Just whipe whole database and import the regular file again.

http://stackoverflow.com/questions/...latest-per-user-having-a-certain-column-value
http://www.tutorialspoint.com/sqlite/sqlite_truncate_table.htm

 

[deivil70]

If you use a server with account manager the manager should be included in the sqlite database file.
Just whipe whole database and import the regular file again.

http://stackoverflow.com/questions/...latest-per-user-having-a-certain-column-value
http://www.tutorialspoint.com/sqlite/sqlite_truncate_table.htm

whipe the databaste?

 

[Snavy]

RESET CHARACTERS back to level 8:

UPDATE players SET level=8, health=150, healthmax=150, experience=0, looktype=128, mana=100, manamax=100, posx=1003, posy=996, posz=7, loss_experience=10, deleted=0;

reset accounts(premium points & premium days)

UPDATE accounts SET premdays=0, premium_points=0;

Reset houses:

UPDATE houses SET owner=0;

Clear 'Kills','Deaths','Dp Items','killers','namelocks','storages','items','shop history':

DELETE * FROM killers;
DELETE * FROM player_deaths;
DELETE * FROM player_depotitems;
DELETE * FROM player_killers;
DELETE * FROM player_namelocks;
DELETE * FROM player_storage;
DELETE * FROM player_items;
DELETE * FROM z_shop_history_item;

 

[deivil70]

RESET CHARACTERS back to level 8:

UPDATE players SET level=8, health=150, healthmax=150, experience=0, looktype=128, mana=100, manamax=100, posx=1003, posy=996, posz=7, loss_experience=10, deleted=0;

reset accounts(premium points & premium days)

UPDATE accounts SET premdays=0, premium_points=0;

Reset houses:

UPDATE houses SET owner=0;

Clear 'Kills','Deaths','Dp Items','killers','namelocks','storages','items','shop history':

DELETE * FROM killers;
DELETE * FROM player_deaths;
DELETE * FROM player_depotitems;
DELETE * FROM player_killers;
DELETE * FROM player_namelocks;
DELETE * FROM player_storage;
DELETE * FROM player_items;
DELETE * FROM z_shop_history_item;

sorry but iam a new bie where do i put these?

 

[Andréew]

Do you use sqlite or mySQL?

if you use sqlite and forgotten server, try to delete "forgotten.s3db?? " or something like that.
if you have a clean backup of it ofcourse! always have clean backups mate

if you use mySQL i dont actually know i guess its the same tho, delete" schema.sql?? " and do a new database with a fresh schema.sql

 

[Snavy]

@deivil70 visit your PhpMyAdmin page ( http://localhost/phpmyadmin ) or ( http://yourSERVERipaddress/phpmyadmin )http://localhost/phpmyadmin
1. Login on your PhpMyAdmin page.

2. Choose your database (where all accounts and players are saved.)

3. Go to SQL tab.

4. Paste the code & click RUN.

 

[ghettobird]

@deivil70 visit your PhpMyAdmin page ( http://localhost/phpmyadmin ) or ( http://yourSERVERipaddress/phpmyadmin )
1. Login on your PhpMyAdmin page.

2. Choose your database (where all accounts and players are saved.)

3. Go to SQL tab.

4. Paste the code & click RUN.

he said he uses sqlite studio ^_^ so this won't work

ontopic: search for keyword "query" or "sql" and paste the codes provided above, they should work

 

[Snavy]

@ghettobird Heh You got a point bro. I must've missed that part