SQL problem. Please help!

[Azoria]

Hiya,
i got a problem , http://data.fuskbugg.se/skalman01/sqlfailz.JPG

Anyone know's why i get that error? :/


thansk / Azoria

 

[EvulMastah]

CREATE TABLE `tiles`
(
	`id` INT NOT NULL AUTO_INCREMENT,
	`x` INT(5) UNSIGNED NOT NULL,
	`y` INT(5) UNSIGNED NOT NULL,
	`z` TINYINT(2) UNSIGNED NOT NULL,
	PRIMARY KEY (`id`),
	KEY (`x`, `y`, `z`)
) ENGINE = InnoDB;

 

[Azoria]

CREATE TABLE `tiles`
(
	`id` INT NOT NULL AUTO_INCREMENT,
	`x` INT(5) UNSIGNED NOT NULL,
	`y` INT(5) UNSIGNED NOT NULL,
	`z` TINYINT(2) UNSIGNED NOT NULL,
	PRIMARY KEY (`id`),
	KEY (`x`, `y`, `z`)
) ENGINE = InnoDB;

In the "Forgotten.db"?

SQL is not my speciality so a little "guide" would be nice

:wub:

 

[EvulMastah]

localhost/phpmyadmin -> table otserv -> SQL (querywindow) -> Execute.

 

[Azoria]

localhost/phpmyadmin -> table otserv -> SQL (querywindow) -> Execute.

Well, I get this error , http://data.fuskbugg.se/skalman01/sqlfail2.JPG

And when im gonna create a user at the homepage i get this error ;

http://data.fuskbugg.se/skalman01/err0z.JPG

 

[EvulMastah]

http://otland.net/f258/updating-phpmyadmin-15801/

 

[Azoria]

http://otland.net/f258/updating-phpmyadmin-15801/

The server is up and running, but i get this error when im going to login at my accoumt - http://data.fuskbugg.se/skalman01/failaxcc.JPG

Thanks for quick answer !

 

[EvulMastah]

Using TFS Beta with Gesiors AAC?

If so, download new here: Unnamed AAC 0.3.2

 

[Azoria]

Hmms, I just tryed that .
and i'll get this error :S

http://data.fuskbugg.se/skalman01/stillhjaveproblemz.JPG

Thanks for all the help Marcinek!

 

[EvulMastah]

http://otland.net/f137/faq-gesior-acc-maker-forgotten-server-6495/

 

[Azoria]

I'm verry close now ,

This is my last problem i think, Marcinek do you know where i change my temple positon?

http://www2.speedy*****malware.localhost/data/832606289/14166964/91092894/templepostions.JPG

Thanks for quick answer!

 

[EvulMastah]

localhost/phpmyadmin/ -> otserv -> players -> Sorcerer, Druid, Knight, Paladin, Rookie(?) Sample -> town_id, posx, posy, posz.

Mapeditor -> edit -> Towns...