PHP [phpMyAdmin] Commands to edit database.

[Bintzer]

can anybody help me?

 

[Znote]

If i want to remove all items from character name "Playername" or player id "1234".

Is it possible? To remove all his items in backpack, depot etc..?

 

[Chris]

DELETE FROM `player_depotitems` , `player_items` WHERE `player_id` = '1234'

 

[Bintzer]

heyy i was wondering if theres a way to make a trigger that when a char gets a certain level it will change its loss experience mana and skills.
didn't know if this was possible.

Also if you can do that i would need a way to update all players above that level to change their loss experience.

TIA

 

[EvulMastah]

heyy i was wondering if theres a way to make a trigger that when a char gets a certain level it will change its loss experience mana and skills.
didn't know if this was possible.

Yea, but it has nothing to do with phpMyAdmin commands.
Use LuaSQL.

 

[Bintzer]

Do you know how to do it in that then? Script please xD

 

[dabaflow]

umm, how do i actually create a account with mysql? and create characters.. like editing data.

 

[Gregor]

Do you guys have command that change outfit for everyplayer that have account 2 ? :>

 

[EvulMastah]

UPDATE players SET looktype = x, lookhead = x, looklegs = x, lookbody = x, lookfeet = x, lookaddons = x WHERE account_id = 2;

 

[Pietia]

do u guys have a simple code to delete from database 130 ddosers attackers characters ? i have a nicknames in notepad but don't want to delete them all via phpmyadmin and delete yes lol ;p

 

[Bintzer]

heyy i was wondering if theres a way to make a trigger that when a char gets a certain level it will change its loss experience mana and skills.
didn't know if this was possible.

Also if you can do that i would need a way to update all players above that level to change their loss experience.

TIA

Nobody can help me with this?

 

[Cykotitan]

UPDATE players SET loss_experience = 5, loss_mana = 5, loss_skils = 5 WHERE level > 249

 

[Bintzer]

Well yes that works, but what I'm looking for is like a trigger or somethin automatically changes your exp loss to that when you reach a certain level. That would only work for existing players above that level, not ones that will reach it in the future.

 

[Bintzer]

Hey I'm still needing help on this. x.x
Also, I need a new command, I need it to change all items of an id in player_items to a different id but only for a certain vocation. Is this possible?

 

[Pietia]

hello how to check which players got the most items in dp ?

 

[Jester]

hello how to check which players got the most items in dp ?

I don't know if it's possible.

 

[Znote]

DELETE FROM `player_depotitems` , `player_items` WHERE `player_id` = '1234'

Ahh thanks, sorry for slow response.

 

[Chris]

No worries mate. :] Glad I could help.

 

[Nooben nr1]

Quick quest!

WHERE level < 50 AND lastlogin < UNIX_TIMESTAMP() - 20*24*60*60

How does that work? if I close th server, it wont keep counting the days until I start it again right?

 

[Pitufo™]

@up

No, doesnt matter if you close server the lastlogin will not be changed!