• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

The Forgotten Server v0.3 beta 1

Status
Not open for further replies.
well i have an error when i try to change the atack speed on vocation.xml
it dont make any efect only when you are moving step to step ex;; if i put a vocation to atack at speedatack "600" it will atack at the same speed of "1000" but if you move it will atack faster is there any way to fix it?
 
I noticed you changed a lot of return values in talkactions, how do they work?

Before it was:
TRUE, made the player say the word and param.
FALSE, did nothing
 
Last edited:
I still got an error on the schema.mysql

Code: 
CREATE TABLE `tiles`
(
    `id` INT UNSIGNED 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;
There... i dont know why (i tryed changing:

Code: 
PRIMARY KEY (`id`)
to

Code: 
PRIMARY KEY (`id`),
and when i change that i got another error (cant create tile_items))
 
Using pl1.
Code: 
Query:
CREATE TABLE `tiles`
(
	`id` INT UNSIGNED 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

Error occured at:2008-11-30 23:33:28
Line no.:327
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY (`x`, `y`, `z`)
) ENGINE = InnoDB' at line 8
Now, after putting a comma after PRIMARY KEY (`id`)
Code: 
Query:
CREATE TABLE `tile_items`
(
	`tile_id` INT NOT NULL,
	`sid` INT NOT NULL,
	`pid` INT NOT NULL DEFAULT 0,
	`itemtype` INT NOT NULL,
	`count` INT NOT NULL DEFAULT 0,
	`attributes` BLOB NOT NULL,
	KEY (`sid`),
	FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB

Error occured at:2008-11-30 23:39:56
Line no.:339
Error Code: 1005 - Can't create table
'.\theforgottenserver\tile_items.frm' (errno: 150)

Jo3
 
Last edited:
Elf, thanks. Can I have changelog, from svn repository? xD thanks again:>

p.s. my post num 600 ;D
 
In the tile_items table, in the schema file, I changed
Code: 
`tile_id` INT NOT NULL,
to
Code: 
`tile_id` INT UNSIGNED NOT NULL,
and it works, would that have been the problem since id in the tiles table is unsigned?

Jo3
 
#1005 - Can't create table '.\lwot\tile_items.frm' (errno: 150)


i'm Getting it after put the ',' at the end of PRIMARY KEY (`id`)

FIXED ------ Another

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
' at line 1
 
Last edited:
Jo3Bingham said:
In the tile_items table, in the schema file, I changed
Code: 
`tile_id` INT NOT NULL,
to
Code: 
`tile_id` INT UNSIGNED NOT NULL,
and it works, would that have been the problem since id in the tiles table is unsigned?

Jo3
Click to expand...

MrLipzZz said:
#1005 - Can't create table '.\lwot\tile_items.frm' (errno: 150)


i'm Getting it after put the ',' at the end of PRIMARY KEY (`id`)
Click to expand...


=) it works (for me)
 
btw does /addskill ~,magic or m work? (i get all the skills working but magic not)
 
Doonrak said:
try magiclevel/magiclvl.
Click to expand...

Nothing works, even "m" should work because I checked the sources.
Code: 
else if(skill[0] == 'm')
		target->addManaSpent(player->getVocation()->getReqMana(target->getMagicLevel() + 1) - target->getSpentMana());
We'll just have to wait for elf to fix it in pl2.

Jo3
 
So..
I Think i need some help
I have a Tfs 0.3.0 alpha3 , and i love him.
But, i wanna merge it on this version
How i can merge old version in new version?
 
Status
Not open for further replies.
Back
Top