Solved TFS 0.3.6 problem ; /

[Lord Ast]

Hello Everyone.

I'm newbie in TFS but i wanna create my own OTS, not for money but for players..

When i run ots i get Error in TFS:

ERROR: Failed to load players record!

What i should do with that error? ; /

I can't find answer on Otland ehh


Sorry for my English.

Regards!

 

[Mesmeroo]

do you have this in the globalevents > scripts?


record.lua

function onRecord(current, old, cid)
	db.executeQuery("INSERT INTO `server_record` (`record`, `world_id`, `timestamp`) VALUES (" .. current .. ", " .. getConfigValue('worldId') .. ", " .. os.time() .. ");")
	addEvent(doBroadcastMessage, 150, "New record: " .. current .. " players are logged in.", MESSAGE_STATUS_DEFAULT)
end

 

[Lord Ast]

Yeap

 

[Mesmeroo]

try to replace it with this one

record.lua

function onRecord(current, old, cid)
	db.executeQuery("INSERT INTO `server_record` (`record`, `world_id`, `timestamp`) VALUES (" .. current .. ", " .. getConfigValue('worldId') .. ", " .. os.time() .. ");")
	addEvent(doBroadcastMessage, 150, "New record: " .. current .. " players are logged in.", MESSAGE_STATUS_DEFAULT)
end

and tell me if it worked please.

 

[Lord Ast]

It not worked ; /

 

[Loney]

Do you have this entry added to creaturescripts.xml/login.lua?

 

[Mesmeroo]

execute this in your database and try again.

TRUNCATE TABLE `server_record`

Let me know if it worked.

 

[Lord Ast]

This is my login.lua

local config = {
loginMessage = getConfigValue('loginMessage'),
useFragHandler = getBooleanFromString(getConfigValue('useFragHandler'))
}

function onLogin(cid)
local loss = getConfigValue('deathLostPercent')
if(loss ~= nil) then
doPlayerSetLossPercent(cid, PLAYERLOSS_EXPERIENCE, loss * 10)
end

local accountManager = getPlayerAccountManager(cid)
if(accountManager == MANAGER_NONE) then
local lastLogin, str = getPlayerLastLoginSaved(cid), config.loginMessage
if(lastLogin > 0) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_DEFAULT, str)
str = "Your last visit was on " .. os.date("%a %b %d %X %Y", lastLogin) .. "."
else
str = str .. " Please choose your outfit."
doPlayerSendOutfitWindow(cid)
end

doPlayerSendTextMessage(cid, MESSAGE_STATUS_DEFAULT, str)
elseif(accountManager == MANAGER_NAMELOCK) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, it appears that your character has been namelocked, what would you like as your new name?")
elseif(accountManager == MANAGER_ACCOUNT) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, type 'account' to manage your account and if you want to start over then type 'cancel'.")
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, type 'account' to create an account or type 'recover' to recover an account.")
end

if(not isPlayerGhost(cid)) then
doSendMagicEffect(getCreaturePosition(cid), CONST_ME_TELEPORT)
end

registerCreatureEvent(cid, "Mail")
registerCreatureEvent(cid, "GuildMotd")

registerCreatureEvent(cid, "Idle")
if(config.useFragHandler) then
registerCreatureEvent(cid, "SkullCheck")
end

registerCreatureEvent(cid, "ReportBug")
registerCreatureEvent(cid, "AdvanceSave")
return true
end

- - - Updated - - -

execute this in your database and try again.

TRUNCATE TABLE `server_record`

Let me know if it worked.

I don't understand what i must do.. ; /

 

[Mesmeroo]

what i ment was this:

• Go to phpadmin
• open your database
• press the sql button and execute this command

TRUNCATE TABLE `server_record`

 

[Lord Ast]

ehh i still get this error...

[25/02/2013 21:51:36] > ERROR: Failed to load players record!

- - - Updated - - -

I try to change Log folder and login.lua from another tfs but i still get this fck error...

Anybody can Help Me?.

- - - Updated - - -

oh Come On !

- - - Updated - - -

Nobody don't know how fix this error?

 

[Lord Ast]

!refresh

!refresh

 

[Lord Ast]

Refresh

 

[Lord Ast]

Refresh...
Nobody can't help me?...

 

[Lord Ast]

Refresh...

 

[EvulMastah]

You are probably missing table from database.

CREATE TABLE `server_record`
(
        `record` INT NOT NULL,
        `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
        `timestamp` BIGINT NOT NULL,
        UNIQUE (`record`, `world_id`, `timestamp`)
) ENGINE = InnoDB;

INSERT INTO `server_record` VALUES (0, 0, 0);

 

[Lord Ast]

thx for answer but now i don't have time becouse i move to new house u understand... But when i find sec for check it i give answer here.

Regards.

Sorry for my English ^^

 

[xapokis]

You are probably missing table from database.

CREATE TABLE `server_record`
(
        `record` INT NOT NULL,
        `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
        `timestamp` BIGINT NOT NULL,
        UNIQUE (`record`, `world_id`, `timestamp`)
) ENGINE = InnoDB;

INSERT INTO `server_record` VALUES (0, 0, 0);

Worked on Avesta 0.64
Thx =D

 

[Lord Ast]

Hello Back.

I have table "server_record"
I try to create "player_record" and "players_record" and i still have this problem fck ; /

I have new idea, i try and give answer here

- - - Updated - - -

YEA I DO IT !

Thread can be closed.

Regards and ths for asnswers.