PHP [phpMyAdmin] Commands to edit database.

[Saj]

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 'WHERE itemtype = 6119' at line 1

I tried to use:

DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = 6119

 

[Chris]

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 'WHERE itemtype = 6119' at line 1

I tried to use:

DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = 6119

Try doing:

DELETE FROM player_depotitems WHERE itemtype = 6119
DELETE FROM player_items WHERE itemtype = 6119
DELETE FROM tile_items WHERE itemtype = 6119

 

[yunior]

could you add a command to make players know all the spells? i can't find it anywhere.

 

[Chris]

In your data/spells/spells.xml, replace all the needLearn="1" against needLearn="0".

 

[yunior]

works. great, thanks

 

[Chris]

Anytime, feel free to give me a reputation point! : )

 

[f@bio]

@ Jester / Jonern

>> Have you a command to add itens on player in table???

-- Exemple... give 10k all player >= level 20

Many thx...

 

[MartyX]

there is no any command to be able to remove this ...

http://img518.imageshack.us/img518/261/48459837bi0.jpg

This error is repeated in more than half of my players ..
I think that by removing the player to player would be very slow and boring

 

[Rizz]

Would this work?

DELETE
FROM accounts
WHERE id NOT
IN (
SELECT account_id
FROM players
);

(Delete all accounts with no players in it).

 

[Jonern]

Replace "DELETE" with "SELECT *" and you will find your answer.
But yes, it looks like it to me.

 

[husam]

I thing somone want this?
UPDATE players SET `town_id` = 2
to make all player got 2 town id
u can change it.

 

[AGS]

Thanks, I wasn't sure on how to delete inactive players.

 

[NilssoN]

UPDATE players SET loss_experience = 6, loss_mana = 6, loss_skills = 6;

Does this one work? ;p

 

[mike]

Hey!! God Commands.

You can post more? Please :]

 

[Jano]

love you, saved my life

 

[Migxxx]

Thanks a lot!

 

[Jonern]

Hey!! God Commands.

You can post more? Please :]

Just come with suggestions on things you want to a queries for and maybe I'll make them

 

[Chris]

DROP USER 'pma'@'localhost';

Probably the most important these day.

 

[Bintzer]

Hey I was wondering if it was possible to add skills to all players the same way the trigger would do? The reason for this is the at first, my triggers werent working, but I got them working now, but all the characters created before I put in the oncreate_player trigger have no skills. What would I use to add them?

 

[Morak]

I think everybody knows these commands, they are basic information about SQL.