PHP [phpMyAdmin] Commands to edit database.

RazorBlade

Retired Snek
Joined
Nov 7, 2009
Messages
2,030
Reaction score
590
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
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
Reaction score
71
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