• 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!

Mysql @ xampp 1.6.7

maaah

New Member
Joined
Mar 5, 2009
Messages
30
Reaction score
0
Location
germany
Well, hello again my friends :)
here because i'm havin' problems with mysql and stuffs....
welll...did i downloaded xampp 1.6.7 (i heard that was the best to solve my problem cuz 1.7.0 have bugs), well... i'd searched for help and they said me to update mysql and phpmyadmin, (done) and problems still... my problem is : people can create accounts and character, people can log into game but when they log-out the skills (fist, club, sword, axe, distance, fishing) don't save....
i hope you can help me :)

thank you since now!
 
Delete everything u got in your phpmyadmin folder. And download this one:
PHP:
sourceforge.net/project/downloading.php?group_id=23067&use_mirror=surfnet&filename=phpMyAdmin-3.1.3-all-languages.7z&a=14536849

Unzip/unrar everything and copy ALL the files in there and put them in phpmyadmin folder. And now everything should work.

Rep++ if i helped u.
 
well....no, im using servfull 2.7....but in Otland Msn Chat, Talaturen said for me to use tfs.sql...after import triggers, but it wont work...
and im using tfscms
 
Execute this query in your database
PHP:
DROP TRIGGER IF EXISTS `oncreate_players`;
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 ;
 
im havin problems in import theforgottenserver.sql to my phpmyadmin, when i import the page just "loadinnng" and dont move :|
 
Back
Top