Fel
SQL-fråga:
DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` !=1 AND `type` !=2 AND `value` = OLD.`id` ;
MySQL sa: Dokumentation
#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`
FOR ' at line 1
I get this error when importing schema.mysql
Code:Fel SQL-fråga: DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` !=1 AND `type` !=2 AND `value` = OLD.`id` ; MySQL sa: Dokumentation #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` FOR ' at line 1
N1 knows the problem? (Using the unnamed acc)
NO not necessarilly all u gotta do is update to the neweest phpmyadmin...... phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.netUse XAMPP 1.6.7 and will work.
I wrote this on the main TFS release aswell, but here we go again
A few things that I noticed in wich I believe should be made easier/fixed to work from start even if I know how to solve a few of those.
So here we go:
- Raids are coming to often.
Example of how it could be solved:
- Its not possible for an NPC to sell Oil. Ain't seem like it realy exists.Code:<raid name="RatRaid" file="Ratraid.xml" chance="10" interval2="60" margin="0" /> Each 60 minutes there is a 10% chance that the raid is executed... />
- Magic Walls won't appear if you shot them on a "Field". (Fire Field etc)
- Monsters avoids/run around fields even if they are imune.
- Monsters will not spawn on fields even if they are imune.
- Players sometimes get debug when a GameMaster uses "invisible" and walk trough.
- Fields dissapears even if they are set out by the MapEditor. "Decay".
Besides that, thank you for a wonderfull server.
Keep it up guys, Open Tibia is nothing without you.
Kind Regards,
Eldin.
I can't wait 'til 09th of November :/! xd
Could You post it as feature request? I'll add that (/r <amount>) when /r will be moved to Lua.Well so far ive encountered 2 odd errors with this server revision.
First is a small bug, which involves the /r command, if you use it on a stackable object on the floor, it removes stack-count, rather than the entire "tile item".
(A good example is, place 100 plat coins on the floor, and use /r on it, it dosnt remove the entire stack, but rather only removes 1 plat coin, leaving you with a 99 plat coin stack on the floor)
Nice, I didn't notice that! Could you also post it in tracker? As bug, please.Oh and i dont know if this should be blamed on CIP, or if the TFS devs have missed this (I dont know wether the server sends a packet to display a pre-defined message, or if the server actually sends the string message), but upon writing the wrong password and/or account name, the client displays "Incorrect account number or password.".
(And like we all know, tibia uses account names now, not numbers)
Elf, what about loosing connections to mysql? Have u found reason what this happends? :/ I lost already 7 times since one week
A second bug would be an odd login error, ive only encountered it once, so i dont know if its anything serious, but today i tried logging into my server, and the server kept saying "Incorrect account number or password" (Yes i tried a multiple of accounts from my server, none worked), and when i checked the server window, it was spammed with that "More than 100 listen errors" notice. Also upon checking my database it claimed that 13 players was online (`online` = 1) while server status (Using server-status-ping on website aswell as talaurens ipchanger) claimed there was 0 players online, and this even though the server had been saving multiple times already.
Like i said, i dont know if its anything serious or whatnot, and it only happened once, but its still odd.
Every time we sweep this version the loosing connection.
Money Bug said:Put 100CC in your arrow slot and a shovel and a rope in both hands, then use a backpack with 1 slot free/left as main backpack. Then just buy something using the trade system and you'll be it for free, then just sell it to npc again.