• 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.2 (Mystic Spirit)

Status
Not open for further replies.
Hi.

My post is number 1000 in this thread.
Good work. <- had to be on topic.

Bye.
 
This happened while uploading forgotten.sql to PHPmyadmin.

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
Click to expand...




Also, when I try logging in 1/1, the client debugs, know why?
 
Save isnt working (crashes server) neither are npcs (trade menu is empty) on patch 17-gui also debugs randomly and rarely
 
Another said:
Save isnt working (crashes server) neither are npcs (trade menu is empty) on patch 17-gui also debugs randomly and rarely
Click to expand...

Please post the XML file and the script of the NPC this happens with so that I can try to reproduce it.
 
Arlaxis said:
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.
Click to expand...

i think is that possible on my ots when u kick player with skull he will lose his pz after kick and autommatly he will be kicked.
 
Another said:
Save isnt working (crashes server) neither are npcs (trade menu is empty) on patch 17-gui also debugs randomly and rarely
Click to expand...

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)
 
Rizz said:
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)
Click to expand...

Yeah same for me, always been random crashes when reloading stuff with GUI.
 
Yep, server crashed if u save by the gui. Also there are debugs and kicks for some players. Trade is empty.

An example:

-Rashid.xml:

<?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>
Click to expand...

-.lua:

local keywordHandler = KeywordHandler:new()
local npcHandler = NpcHandler:new(keywordHandler)
NpcSystem.parseParameters(npcHandler)

function onCreatureAppear(cid) npcHandler:eek:nCreatureAppear(cid) end
function onCreatureDisappear(cid) npcHandler:eek:nCreatureDisappear(cid) end
function onCreatureSay(cid, type, msg) npcHandler:eek:nCreatureSay(cid, type, msg) end
function onThink() npcHandler:eek:nThink() 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())
Click to expand...


See u.
 
Last edited:
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.

EDIT: Addressed the NPC trade window issue, releasing 0.2pl18 soon!
 
Talaturen said:
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.
Click to expand...

When will buying bps of items work?
Or is it already working ^.-

Edit: If it is can someone post a sample of 1 npc selling a bp of something
 
To avoid new bugs, we don't add any new features to 0.2 unless we believe it will make us lose users if we don't add that feature (like protocol 8.3 support could). For new features, use 0.3 but expect bugs which could ruin your server.
 
0.2 Patch 18 has been released. View first post for more information.
 
Please try to explain that better, why shouldn't you be able to kill someone who is training? .. and what do you mean with that there aren't windows? :eek:
 
Status
Not open for further replies.
Back
Top