PHP [phpMyAdmin] Commands to edit database.

[Jester]

You're welcome.

 

[Kiman]

Very useful indeed, makes life easier for most of us.

Jester has made it again

 

[Donio]

This is very usefull, thanks alot mate! :>

 

[Besegnar]

Thanks, great help!

 

[dervin13]

How can i delete guilds that owner is not premium more??

ty

 

[widnet]

2x premium points for players

UPDATE `accounts` SET premium_points=premium_points*2;

 

[Gaposi]

Is there any way to replace all crown backpacks (10522)from players/dps with normal backpacks (1988) ?

 

[EvulMastah]

Is there any way to replace all crown backpacks (10522)from players/dps with normal backpacks (1988) ?

UPDATE `player_items`, `player_depotitems`, `tile_items` SET `itemtype` = '1988' WHERE `itemtype` = '10522';

 

[Gaposi]

Thanks!

Edit:

I get this error when trying the command in the post above this:

#1052 - Column 'itemtype' in field list is ambiguous

What does this mean?

 

[EvulMastah]

Thanks!

Edit:

I get this error when trying the command in the post above this:

#1052 - Column 'itemtype' in field list is ambiguous

What does this mean?

UPDATE `player_items` SET `itemtype` = '1988' WHERE `itemtype` = '10522';
UPDATE `player_depotitems` SET `itemtype` = '1988' WHERE `itemtype` = '10522';
UPDATE `tile_items` SET `itemtype` = '1988' WHERE `itemtype` = '10522';

 

[Gaposi]

That worked. Thanks!

 

[Amare Aeternam]

I need a query to remove all items in game by actionId

 

[Matheus2020]

what if i only want to delete items that have 100x charges.
DELETE FROM player_depotitems WHERE itemtype = 2160,100;
DELETE FROM player_items WHERE itemtype = 2160,100;
DELETE FROM tile_items WHERE itemtype = 2160,100;

Is it like that?

 

[Chris]

AND `count` = 100;

 

[Cykotitan]

AND `count` = 100;

I thought attributes (in this case charges) were stored in blob
They are, but it seems like charges are count here.

 

[Chris]

I thought attributes (in this case charges) were stored in blob
They are, but it seems like charges are count here.

Hmm yeah might be true, I have no idea actually since I have never really worked with the item tables.

 

[Archez]

What about this: remove house ownership if player is not on database.

 

[EvulMastah]

What about this: remove house ownership if player is not on database.

UPDATE `houses` SET `owner` = '0' WHERE `houses`.`owner` NOT IN ( SELECT `players`.`id` FROM `players` WHERE `players`.`id` = `houses`.`owner` );

 

[Rith]

UPDATE players SET posx = 932, posy = 932, posz = 7 WHERE account_id = 1;
It doesn't work. It changes position for all players, not only with acccount id 1

 

[dgprado]

Help plz:
i am using this query:
DELETE FROM player_items WHERE player_id NOT IN (SELECT id FROM players)

But nothing is deletd:
0 row(s) deleted.

i had deleted a lot of players.
if this heapends because some trigger ploblem, is there some way to fix it ?