Solved QUERY; delete all players without acc manager?

[Ghazer]

I want query to delete all players on my server without account manager
its possible?

 

[Xon vanetta]

("DELETE FROM `players` WHERE id != '1' ")

1 should be your account manager

atleast this is from the php

 

[Ninja]

Deletes all players except Account Manager and Samples.

DELETE FROM `players` WHERE NOT `players`.`name` IN ("Account Manager", "Rook Sample", "Sorcerer Sample", "Druid Sample", "Paladin Sample", "Knight Sample");

 

[Ghazer]

I use SQLliteStudio

@Ninja, I have error

 

[Ninja]

I made a minor change to the query, please try again.

 

[Ghazer]

The same error

 

[Ethrex]

Its because one info in table guilds is usin something from players, you must delete (empty) other player related things also i think.

 

[Nottinghster]

Bro, you'll have to delete alot of things (player items, player depot items, player storages and other things)

Here's an example of how to set level 1 to all players and set all skills to 10

//Players
UPDATE players SET level = 1, experience = 0, maglevel = 0, health = 150, healthmax = 150, mana = 0, manamax = 0, manaspent = 0, redskulltime = 0, soul = 100, town_id = 0, cap = 400, vocation = 0, posx = 32097, posy = 32219, posz = 7, lastlogin = 0, lastlogout = 0, lastip = 0, rank_id = 0, guildnick = '', bless1 = 0, bless2 = 0, bless3 = 0, bless4 = 0, bless5 = 0, bank_balance = 0;

//Skills
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 0;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 1;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 2;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 3;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 4;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 5;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 6;

 

[Ghazer]

@Nottinghster I need delete because I have a war server for that reason mages, paladins and knights have differents HP and some differences...

PD: Are you the real Nottinghster from empera? He's a legend

 

[Nottinghster]

No, I'm an old owner ;]
Nottinghster had alot of players, and yes, we (old owners) was a legend ;]

 

[Ghazer]

Anyone have a idea?

 

[Ethrex]

Just mark all players, unmark samples and acc manager then press delete? xD

 

[Ghazer]

When I try this I have error lol

 

[Ethrex]

Delete all guilds first, everything that matches with players.

 

[Loney]

Can't see the error image above me, you need to delete guilds, houses, and that stuff and THEN the accounts/players.

 

[Ghazer]

but I cant delete guilds, houses I need querys to do

- - - Updated - - -

 

[Pheenix]

Why dont you just make a new database, export what you want to save and import it to the new database?

 

[Ghazer]

I delete my database and use default database but now I have problems with war tables... check this http://otland.net/f16/sqlite-error-no-such-colum-help-177792/

 

[Herpicus]

xd wtb truncate