Geisor Aac problem.

[ryan868]

I need help setting something for my ot

Im using TFS 0.3 Beta2 and AAC geisors~
(http://otland.net/f118/unnamed-acc-maker-0-3-2-beta-forgotten-server-12954/)

Everythings working exept i cant find out where to set the pos x/y/z for the towns, i know where to set town ids you can choose but if i only set that and create new character, it makes the character with that town id and x/y/x = 0/0/0.

Can anyone help me with this problem? =/

 

[Whipkickin]

Yeah i got the same problem someone help us!

B
U
M
P

 

[Whipkickin]

bump

 

[EvulMastah]

If there is town_id other than 0 and pox/y/z are nil (0), character will spawn at specified town_ids temple.

 

[ryan868]

can you explain that a little easier please?

 

[Pazzur]

You need to edit the Sample characters in your database (I think).

Check your phpMyAdmin and look in table players, Sorcerer Sample, Druid Sample, etc... Then, edit their spawn positions manually using phpMyAdmin.

Hope it helps,
Pazzur

 

[ryan868]

Ok, i fixed it but now when i create characters (on website) i get..

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\pot\OTS_Player.php:1832 Stack trace: #0 C:\xampp\htdocs\accountmanagement.php(703): OTS_Player->getSkill(0) #1 C:\xampp\htdocs\index.php(130): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1832

but it still creates character?

And my friend try create account and says empty img verfication code, but works for me? =/

 

[Don Daniello]

Img should work.
You don't have triggers properly installed !
Temple coordinates you set in map editor.
Players with coordinates 0,0,0 will be teleported

 

[ryan868]

how can i fix it so when i create a character i dont get a white page with this error?

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\pot\OTS_Player.php:1832 Stack trace: #0 C:\xampp\htdocs\accountmanagement.php(703): OTS_Player->getSkill(0) #1 C:\xampp\htdocs\index.php(130): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1832

 

[Don Daniello]

Evaluate this code:

DELIMITER |

CREATE TRIGGER `oncreate_players`
AFTER INSERT
ON `players`
FOR EACH ROW
BEGIN
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END|

DELIMITER ;

Then every char will get skills automaticaly.
You can delete samples and add them manually so that skills for them will be in database.