Forgottenserver.sql

[Cm Himen]

i was wondering if i would have to type some code of something in to get a access on my sql. Since there is absolutly no way i can get a gm/cm on my server. ive tried many times if i have to do it in forgottenserver.sql can you give me one that works

 

[bobx]

hi..

edit your groupid = 3
see ur commands.xml and look what access level to GM/CM
i think is tree... then use phpmyadmin edit players.. ur player
and set groupID to 3 or what u want!

CREATE TABLE `players`
(
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`group_id` INT NOT NULL DEFAULT 1,

example to create an GM with access 3:

INSERT INTO `players` VALUES (1, 'GameMaster on YourServer', 1, 1, 3, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 10, 10, 10, 0);

 

[Avarian]

http://localhost/phpmyadmin

easiest way to edit SQL databases.

 

[Cm Himen]

that did not help at all avarian check pm + you have said that several times.. its not working check the ss's i sent on forgottenserver 0.2.6

 

[Samurai-lord]

The thing i know abot tgf is that it's sqlite. the best thing you can do is download sqlite admin. a free program where you c easily edit the tables.