The Forgotten Server v0.2rc4

[Arppa]

Yeh I got the error while adding the .sql file, even I downloaded the new one:

SQL query:

DROP TRIGGER IF EXISTS `oncreate_players` ;



MySQL said:

#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 'IF EXISTS `oncreate_players`' at line 1

 

[Jonern]

If your database is clean without any tables there already, you can just remove the two DROP parts on top.

 

[Arppa]

Just try downloading my forgottenserver.sql in upper post, beacuse it work good for me, and try updating your phpmyadmin

I got version 2.9.1.1
Is that good enough?

 

[Mark]

No, you need v2.11.

 

[Arppa]

I downloaded 2.11.0, still with the same results. The same error appears.

 

[Mark]

You downloaded 2.11, but did you replace your old phpMyAdmin with it? Are you sure it's being used? Which MySQL version do you have?

 

[Arppa]

Of course I made sure I'm using the new version; I replaced phpmyadmin folder with the new 2.11 files, and restarted whole thing. Then, it says "Welcome to phpmyadmin 2.11"

but I still do have the prob

SQL query:

DROP TRIGGER IF EXISTS `oncreate_players` ;



MySQL said:

#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 'IF EXISTS `oncreate_players`' at line 1

btw, the serv is running like normal when I put 'sqlite' on config.lua..even though I don't know what is sqlite, or how to use it >

Edit: Where can I see MySQL version?

 

[mandalock1]

Whats wrong with this?

SQL query:

INSERT INTO `accounts`
VALUES ( 1, '1', 1, 65535, 0, '0', '', 0, 0 ) ;

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1 w 1

This popped out when I tryed to import forgottenserver.sql
(Im using newest phpmyadmin)

 

[Hadeshell]

im getting the same problem as you mandalock

 

[Hadeshell]

could somebody scan it

 

[LajNuZ]

Hey!

could somebody scan it

LoL its safe... i have downlod it ...

 

[Scarlet Ayleid]

where can I download TFS sources?

 

[ntmr]

The blessing npc doesn't work

Error:

Lua Script Error: [Npc interface]
data/npc/scripts/bless.luanCreatureSay

data/npc/scripts/bless.lua:32: attempt to compare number with nil

The script:

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

function creatureSayCallback(cid, type, msg)
if(npcHandler.focus ~= cid) then
return FALSE
end
if msgcontains(msg, 'blessing') or msgcontains(msg, 'blessings') or msgcontains(msg, 'help') or msgcontains(msg, 'offer') then
selfSay("I can provide you with five blessings... the 'first bless', 'second bless', 'third bless', 'fourth bless' and the 'fifth bless', they cost 10000 gold coins each.")
talkState = 0
elseif msgcontains(msg, 'first bless') then
selfSay("Do you want to buy the first blessing for 10000 gold?")
talkState = 1
elseif msgcontains(msg, 'second bless') then
selfSay("Do you want to buy the second blessing for 10000 gold?")
talkState = 2
elseif msgcontains(msg, 'third bless') then
selfSay("Do you want to buy the third blessing for 10000 gold?")
talkState = 3
elseif msgcontains(msg, 'fourth bless') then
selfSay("Do you want to buy the fourth blessing for 10000 gold?")
talkState = 4
elseif msgcontains(msg, 'fifth bless') then
selfSay("Do you want to buy the fifth blessing for 10000 gold?")
talkState = 5
elseif talk_state > 0 then
if msgcontains(msg, 'yes') then
if getPlayerBlessing(cid, talk_state) then
selfSay("A god has already blessed you with this blessing.")
else
if getPlayerPremiumDays(cid) > 0 then
if doPlayerRemoveMoney(cid, 10000) == TRUE then
doPlayerAddBlessing(cid, talk_state)
selfSay("You have been blessed by one of the five gods!")
else
selfSay("You don't have enough money.")
end
else
selfSay("You need a premium account to buy blessings.")
end
end
elseif msgcontains(msg, 'no') then
selfSay("Then not.")
end
talk_state = 0
end
return TRUE
end

npcHandler:setCallback(CALLBACK_MESSAGE_DEFAULT, creatureSayCallback)
npcHandler:addModule(FocusModule:new())

Please, can you fix it Talatuen?

 

[GoD Aro]

@Talaturen

I update the sources and you change alot of things!
And you add the /clean command.
Good Work!

Now it works the deathlosepercent?

 

[chul1do]

i cant wait to download the v.0.2.5

 

[Lord Gogeta]

Goto your Database and set the correct temple possition on your account manager

i did that still nothing i went threw everything u think i should try installing new version of the server and mysql and phpmyadmin and change it all from the get go

and what about the gms and gods not being able to attack any way to fix that?

 

[Lord Gogeta]

idk where to post but does anyone know how to configure mysql server from mysql.com and phpmyadmin and the server all together the mysql help in server folder only for xampp


Sorry for the double post
Thanks from,
Lord Gogeta

 

[Mokerhamer]

Wicked!!! I hope in the next update there's some new things =)

 

[gahspy]

hello my npc's wont load :S whats the problem

 

[Jonern]

i cant wait to download the v.0.2.5

Compile it your self!
Most of the functions are already done in the sources!