PHP [phpMyAdmin] Commands to edit database.

RazorBlade

Retired Snek
Joined
Nov 7, 2009
Messages
2,030
Best answers
1
Likes
587
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.
 
Joined
Jan 12, 2017
Messages
1
Best answers
0
Likes
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...
 
Joined
Nov 13, 2018
Messages
179
Best answers
0
Likes
42
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