• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

PHP [phpMyAdmin] Commands to edit database.

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..?
 
DELETE FROM `player_depotitems` , `player_items` WHERE `player_id` = '1234'
 
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 :D
 
Last edited:
Bintzmeister said:
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.
Click to expand...

Yea, but it has nothing to do with phpMyAdmin commands.
Use LuaSQL.
 
umm, how do i actually create a account with mysql? and create characters.. like editing data.
 
PHP: 
UPDATE players SET looktype = x, lookhead = x, looklegs = x, lookbody = x, lookfeet = x, lookaddons = x WHERE account_id = 2;
 
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
 
Bintzmeister said:
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 :D
Click to expand...

Nobody can help me with this?
 
PHP: 
UPDATE players SET loss_experience = 5, loss_mana = 5, loss_skils = 5 WHERE level > 249
 
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.
 
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?
 
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?
 

Similar threads

P
Add mana to the pet
Replies
2
Views
279
poncex
P
Back
Top