- Joined
- Aug 19, 2007
- Messages
- 4,941
- Solutions
- 11
- Reaction score
- 352
Hi.
My post is number 1000 in this thread.
Good work. <- had to be on topic.
Bye.
My post is number 1000 in this thread.
Good work. <- had to be on topic.
Bye.
Hi.
My post is number 1000 in this thread.
Good work. <- had to be on topic.
Bye.
Error
SQL query:
DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `account` = OLD.`id` ;
MySQL said: Documentation
#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
Save isnt working (crashes server) neither are npcs (trade menu is empty) on patch 17-gui also debugs randomly and rarely
Thanks for it. Btw, my server crashed one time since i added the files that changed on Patch 17.
I want to ask u one thing. Can be possible that if i use this TFS version, people can got kick without any kind of explain? It's strange, for that reason i am asking about it. Thanks.
Save isnt working (crashes server) neither are npcs (trade menu is empty) on patch 17-gui also debugs randomly and rarely
For me, the GUI has always been a bit buggy, kicking a player with GUI *sometimes* crashes the server.
Reloading *NPCS* seems to in most cases crash the server (Only when reloading from GUI)
<?xml version="1.0" encoding="UTF-8"?>
<npc name="Rashid" script="data/npc/scripts/SellEliteLoot.lua" walkinterval="2000" floorchange="0">
<health now="100" max="100"/>
<look type="146" head="12" body="101" legs="122" feet="115" addons="2"/>
<parameters>
<parameter key="message_greet" value="Ahh! Welcome my best customer! I buy and sell items say trade" />
<parameter key="module_keywords" value="1" />
<parameter key="keywords" value="sell;help;buy"/>
<parameter key="keyword_reply1" value="say trade to buy or sell items!" />
<parameter key="keyword_reply2" value="say trade to buy or sell items!" />
<parameter key="keyword_reply3" value="say trade to buy or sell items!"/>
</parameters>
</npc>
local keywordHandler = KeywordHandler:new()
local npcHandler = NpcHandler:new(keywordHandler)
NpcSystem.parseParameters(npcHandler)
function onCreatureAppear(cid) npcHandlernCreatureAppear(cid) end
function onCreatureDisappear(cid) npcHandlernCreatureDisappear(cid) end
function onCreatureSay(cid, type, msg) npcHandlernCreatureSay(cid, type, msg) end
function onThink() npcHandlernThink() end
local shopModule = ShopModule:new()
npcHandler:addModule(shopModule)
shopModule:addSellableItem({'wyvern fang'}, 7408, 2000, 'wyvern fang')
shopModule:addSellableItem({'war axe'}, 2454, 9000, 'war axe')
shopModule:addSellableItem({'sapphire hammer'}, 7437, 7000, 'sapphire hammer')
shopModule:addSellableItem({'dragonbone staff'}, 7430, 3000, 'dragonbone staff')
shopModule:addSellableItem({'diamond sceptre'}, 7387, 3000, 'diamond sceptre')
shopModule:addSellableItem({'mammoth whopper'}, 7381, 3000, 'mammoth whopper')
shopModule:addSellableItem({'demonrage sword'}, 7382, 10000, 'demonrage sword')
shopModule:addSellableItem({'amber staff'}, 7426, 8000, 'amber staff')
shopModule:addSellableItem({'brutetamers staff'}, 7379, 5000, 'brutetamers staff')
shopModule:addSellableItem({'crystal sword'}, 7449, 3000, 'crystal sword')
shopModule:addSellableItem({'daramanian mace'}, 2439, 1000, 'daramanian mace')
shopModule:addSellableItem({'daramanian waraxe'}, 2440, 3000, 'daramanian waraxe')
shopModule:addSellableItem({'dragon slayer'}, 7402, 15000, 'dragon slayer')
shopModule:addSellableItem({'furry club'}, 7432, 3000, 'furry club')
shopModule:addSellableItem({'heavy machete'}, 2442, 200, 'heavy machete')
shopModule:addSellableItem({'lunar staff'}, 7424, 7000, 'lunar staff')
shopModule:addSellableItem({'silver dagger'}, 2402, 400, 'silver dagger')
shopModule:addSellableItem({'taurus mace'}, 7425, 1000, 'taurus mace')
shopModule:addSellableItem({'beholder helmet'}, 3972, 10000, 'beholder helmet')
shopModule:addSellableItem({'skull helmet'}, 5741, 30000, 'skull helmet')
shopModule:addSellableItem({'ragnir helmet'}, 7462, 4000, 'ragnir helmet')
shopModule:addSellableItem({'pirate hat'}, 6096, 2000, 'pirate hat')
shopModule:addSellableItem({'devil helmet'}, 2462, 3000, 'devil helmet')
shopModule:addSellableItem({'Krimhorn Helmet'}, 7461, 2000, 'Krimhorn Helmet')
shopModule:addSellableItem({'dragon scale mail', 'dsm'}, 2492, 40000, 'dragon scale mail')
shopModule:addSellableItem({'golden armor'}, 2466, 30000, 'golden armor')
shopModule:addSellableItem({'dwarven armor'}, 2503, 30000, 'dwarven armor')
shopModule:addSellableItem({'leopard armor'}, 3968, 2000, 'leopard armor')
shopModule:addSellableItem({'mammoth fur cape'}, 7463, 6000, 'mammoth fur cape')
shopModule:addSellableItem({'Pirate Knee Breeches'}, 5918, 3000, 'Pirate Knee Breeches')
shopModule:addSellableItem({'demon shield'}, 2520, 30000, 'demon shield')
shopModule:addSellableItem({'tortoise shield'}, 6131, 2000, 'tortoise shield')
shopModule:addSellableItem({'medusa shield'}, 2536, 9000, 'medusa shield')
shopModule:addSellableItem({'bone shield'}, 2541, 1000, 'bone shield')
shopModule:addSellableItem({'dark shield'}, 2521, 2000, 'dark shield')
shopModule:addSellableItem({'castle shield'}, 2535, 10000, 'castle shield')
shopModule:addSellableItem({'scarab shield'}, 2540, 2000, 'scarab shield')
shopModule:addSellableItem({'crocodile boots', 'croco'}, 3982, 1000, 'crocodile boots')
shopModule:addSellableItem({'pirate boots'}, 5462, 4000, 'pirate boots')
shopModule:addSellableItem({'fur boots'}, 7457, 2000, 'fur boots')
shopModule:addSellableItem({'steel boots', 'steel boot'}, 2645, 30000, 'steel boots')
shopModule:addSellableItem({'platinum amulet'}, 2171, 5000, 'platinum amulet')
shopModule:addBuyableItem({'stone skin amulet'}, 2197, 2000, 'stone skin amulet')
shopModule:addBuyableItem({'axe ring'}, 2208, 500, 'axe ring')
shopModule:addBuyableItem({'club ring'}, 2209, 500, 'club ring')
shopModule:addBuyableItem({'dwarven ring'}, 2213, 500, 'dwarven ring')
shopModule:addBuyableItem({'energy ring'}, 2167, 500, 'energy ring')
shopModule:addBuyableItem({'life ring'}, 2168, 900, 'life ring')
shopModule:addBuyableItem({'might ring'}, 2164, 5000, 'might ring')
shopModule:addBuyableItem({'ring of healing'}, 2214, 2000, 'ring of healing')
shopModule:addBuyableItem({'stealth ring'}, 2165, 5000, 'stealth ring')
shopModule:addBuyableItem({'sword ring'}, 2207, 500, 'sword ring')
shopModule:addBuyableItem({'time ring'}, 2169, 2000, 'time ring')
npcHandler:addModule(FocusModule:new())
I've addressed the save crash, a blessings issue and I'm looking into the NPC now (confirmed that trade window is empty so far...). 0.2pl18 will be released later today.