Making god character

[XouruS]

Hello, im having trouble making a god character..
When i go to my character in the sql database it dosent offer me to make it group id 6..

I tried making it with this quarry

UPDATE `forgottenserver`.`players` SET `group_id` = '6' WHERE `players`.`id` =12

and i got this error

#1452 - Cannot add or update a child row: a foreign key constraint fails (`forgottenserver`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`))

 

[Amiroslo]

lol
just go to players and chose the player and edit and write in group id 6

 

[XouruS]

I know man, but look..
It dosent offer me to make it group 6

 

[Fyruz]

UPDATE players SET group_id = 6 WHERE id = 12;

 

[Cykotitan]

UPDATE players SET group_id = 6 WHERE id = 12;

No LIMIT on end of query? TRIPLE SHITLISTED!

#thread
If OP is using TFS 0.2.X, group_id should be 3 and not 6.

 

[XouruS]

UPDATE players SET group_id = 6 WHERE id = 12;

error again..

#1452 - Cannot add or update a child row: a foreign key constraint fails (`forgottenserver`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`))
UPDATE players SET group_id =6 WHERE id =12

 

[XouruS]

Cyko,give me a query.

 

[Cykotitan]

UPDATE `players` SET `group_id` = 3 WHERE `id` = 12 LIMIT 1;
UPDATE `accounts` SET `type` = 5, `group_id` = 3 WHERE `id` = (SELECT `account_id` FROM `players` WHERE `id` = 12 LIMIT 1) LIMIT 1;

 

[Amiroslo]

no in the tfs he is using make it -2
then try if didnt work try -3

 

[Cykotitan]

2 = GM

 

[Amiroslo]

the -3

 

[XouruS]

UPDATE `players` SET `group_id` = 3 WHERE `id` = 12 LIMIT 1;
UPDATE `accounts` SET `type` = 5, `group_id` = 3 WHERE `id` = (SELECT `account_id` FROM `players` WHERE `id` = 12 LIMIT 1) LIMIT 1;

Fel
SQL-fråga:  

UPDATE `accounts` SET `type` =5,
`group_id` =3 WHERE `id` = ( SELECT `account_id` 
FROM `players` 
WHERE `id` =12
LIMIT 1 ) 
LIMIT 1 ;



MySQL sa:  

#1054 - Unknown column 'type' in 'field list'

 

[XouruS]

the -3

tried all..

 

[Amiroslo]

use tfs 0.3.6pl1

 

[XouruS]

use tfs 0.3.6pl1

where to get it?

 

[Erik]

Ey collz

 

[Amiroslo]

http://otland.net/f18/8-54-forgotten-server-0-3-6pl1-crying-damson-59924/
here

 

[XouruS]

Same thing with that tfs.

 

[Cykotitan]

No, you must create a new database because you had a wrong schema

This time, import file "schemas/mysql.sql" into the database.