PHP [phpMyAdmin] Commands to edit database.

[Pietia]

I don't know if it's possible.

already asked gesior for these who want to test xD

SELECT `player_id` , COUNT( `player_id` ) ilosc
FROM `player_depotitems`
GROUP BY `player_id`
ORDER BY `ilosc` DESC

 

[f@bio]

@JESTER

Hello friend, i'm using AVARIANS AAC, and this have a DELETE INACTIVE PLAYERS COMMAND, but only delete player, now i have many acc without characters, how to me delete this accs on sql command???

-- Can you help me to solve this??? Many thx...

 

[Pitufo™]

@up

Try this one:

DELETE FROM accounts WHERE lastday < UNIX_TIMESTAMP() - 20*24*60*60

 

[f@bio]

@up

Try this one:

DELETE FROM accounts WHERE lastday < UNIX_TIMESTAMP() - 20*24*60*60

Explain this plx: < UNIX_TIMESTAMP() - 20*24*60*60

 

[Pitufo™]

if lastday is less than actual time - 20days

 

[Gregor]

do anyone test this command:
DELETE FROM player_items WHERE player_id NOT IN (SELECT id FROM players);

It working good?

 

[christiandb]

It doesn't delete any line for me. I did deleted 6000 players before I executed that command.

 

[Jonern]

do anyone test this command:
DELETE FROM player_items WHERE player_id NOT IN (SELECT id FROM players);

It working good?

Test it by changing 'DELETE' with 'SELECT *'
The lines you get is what that gets deleted using that query.

 

[axxon]

Can i fix so all house dont have an owner in the database?

 

[christiandb]

Delete all the entys in scheme house in your database. Not sure check it.

 

[axxon]

Hey, do i need to have the ot off when i do this?
Becaust its just change back when its on

 

[Norix]

It depends on what you make. If you wanna remove bans OTS has to be offline. If you update players lvls or sth the players have to be offline.

Your's ballack13

 

[Belthazor]

thanks for the commands they come handy some times.

 

[lyczos]

How to clear all houses owners that belongs to player who are inactive for 20 days?

Sorry for my eng.

Ex.:
player buy house but not login for 23 days. How to delete player, his items, depot items and house(set house status to NOBODY).

thanks

 

[Yony]

Is there a way of changing x to y?
in my case depot id '0' to '1'

 

[Yony]

btw what is pid?

 

[Rizz]

@up playerID

 

[Infamous]

Is it possible to remove all addons players have received? I had a lousy addon seller, now I got a perfect one. So I want people to regain their addons.

I searched some, and found this;

DELETE FROM player_storage WHERE key > 1000000

But I got;

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key > 1000000' at line 1

Hope someone can help me fast!

 

[christiandb]

DELETE FROM player_storage WHERE key > 1000000;

 

[Infamous]

Same error when I use that one.

The correct version was;

 DELETE FROM player_storage WHERE `key` > 1000000;

-Infamous.

EDIT: Working now!