• 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.

God Mythera

Advanced OT User
Joined
Aug 11, 2012
Messages
2,044
Best answers
2
Reaction score
213
Location
United States
Possible for sql command to delete a player? for example 'Table Players delete Player Name'?
 

RazorBlade

Retired Snek
Joined
Nov 7, 2009
Messages
2,040
Best answers
3
Reaction score
599
Location
Canada
Of course. Everything you do with the GUI is simply running SQL code in the background. You just have to learn SQL.

Edit: I'm feeling generous. Delete a player using the GUI, it might display the code it used to do so. If not, google is your friend.
 

mailonsitho

New Member
Joined
Jan 12, 2017
Messages
1
Best answers
0
Reaction score
0
Hello, im new to this kind of server, i manage to create an god character but i cant create items or execue some commands in game, i want to know if i need to change something in my database or if a have to create a new GOD acc, im using (phpMyAdmin) if is posible, i want to know where i can find the SQL program pls...
 

Vizjus

Banned User
Joined
Nov 13, 2018
Messages
266
Best answers
0
Reaction score
74
Location
TheForgottenServer
UPDATE houses SET owner = 0, paid = 0,lastwarning = 0
UPDATE players SET level = 1,vocation = 0,balance = 0, health = 185,lastlogin = 0, healthmax = 185, experience = 0,lastlogout =0, maglevel = 0, mana = 0, manamax = 0,manaspent = 0,looktype = 136, manaspent = 0, soul = 0,town_id = 12, posx = 32097, posy = 32219, posz = 7, cap = 440, skull = 0, skulltime = 0,redskull = 0, redskulltime =0, stamina = 0, loss_experience = 5, loss_mana = 3,loss_containers = 100, loss_skills = 3, loss_items = 5, blessings = 0

update player_skills set value=10
update player_skills set count=0
delete from `player_storage` where player_id between 1 and 5000
UPDATE houses SET owner = 0, paid = 0,lastwarning = 0
delete from `player_deaths` where id between 1 and 5000

update player_skills set `value`=10,`count`=0 where `skillid`=0
update player_skills set `value`=10,`count`=0 where `skillid`=1
update player_skills set `value`=10,`count`=0 where `skillid`=2
update player_skills set `value`=10,`count`=0 where `skillid`=3
update player_skills set `value`=10,`count`=0 where `skillid`=4
update player_skills set `value`=10,`count`=0 where `skillid`=5
update player_skills set `value`=10,`count`=0 where `skillid`=6
update accounts set premium_points=5 where premium_points=0

UPDATE accounts SET golden_days = 0, lastday = 0, premium_points = 0
UPDATE player_skills SET value = 10, count 0
 
Top