Solved Error with who are enemies on login (necroots fix)....

[Xeikh]

http://otland.net/f82/war-system-who-your-enemies-onlogin-fixed-necroots-146901/


Hello, im using that system but i have this error:



data/creaturescripts/scripts/onWar.lua:3: attempt to concatenate local 'guild' (a boolean value)

heres my script:

local guild, enemy, guildFrags, enemyFrags = getPlayerGuildId(cid)
local fightingGuilds = {}
local tmp = db.getResult("SELECT `guild_id`, `enemy_id`, `guild_kills`, `enemy_kills`, `frags` FROM `guild_wars` WHERE `guild_id` = "..guild.." OR `enemy_id` = "..guild.." AND `status` = 1;")
if tmp:getID() ~= -1 then
	i = 1
	repeat
		if tmp:getDataInt("guild_id") == guild then
			enemy = tmp:getDataInt("enemy_id")
			guildFrags = tmp:getDataInt("guild_kills")
			enemyFrags = tmp:getDataInt("enemy_kills")
		else
			enemy = tmp:getDataInt("guild_id")
			guildFrags = tmp:getDataInt("enemy_kills")
			enemyFrags = tmp:getDataInt("guild_kills")
		end
		local enemyName, _tmp = "", db.getResult("SELECT `name` FROM `guilds` WHERE `id` = " .. enemy)
		if(_tmp:getID() ~= -1) then
			enemyName = _tmp:getDataString("name")
			_tmp:free()
 
		end
 
		fightingGuilds[i] = {}
		fightingGuilds[i].name = enemyName
		fightingGuilds[i].guildFrags = guildFrags
		fightingGuilds[i].enemyFrags = enemyFrags
		fightingGuilds[i].limit = tmp:getDataInt("frags")
 
		i = i + 1
	until not(tmp:next())
	tmp:free()
 
	table.sort(fightingGuilds, function (a, b)
		return (a.name < b.name)
	end)
 
	local warString = ""
 
	for k, v in pairs(fightingGuilds) do
		if (v.guildFrags < v.limit and v.enemyFrags < v.limit) then
			if not warString then
				warString = "Your guild is currently in war with the " .. v.name .. " (" .. v.guildFrags .. ":" .. v.enemyFrags .. " frags, limit ".. v.limit ..")"
			else
				warString = warString .. " and with the " .. v.name .. " (" .. v.guildFrags .. ":" .. v.enemyFrags.." frags, limit ".. v.limit .. ")"
			end
		end
	end
 
	if (warString ~= "") then 
		doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, warString .. ".")
	end
end

Can please someone help me? :3

 

[Cronox]

local guild, enemy, guildFrags, enemyFrags = getPlayerGuildId(cid)
local fightingGuilds = {}
local tmp = db.getResult("SELECT `guild_id`,  `enemy_id`, `guild_kills`, `enemy_kills`, `frags` FROM `guild_wars` WHERE `status` = 1 and (`guild_id` = "..getPlayerGuildId(cid).." or  `enemy_id` = "..getPlayerGuildId(cid).. ")  ;")
warString = ""
if tmp:getID() ~= -1 then
	i = 1
 
	repeat
 
		if tmp:getDataInt("guild_id") == guild   then
			enemy = tmp:getDataInt("enemy_id")
			guildFrags = tmp:getDataInt("guild_kills")
			enemyFrags = tmp:getDataInt("enemy_kills")
		else
			enemy = tmp:getDataInt("guild_id")
			guildFrags = tmp:getDataInt("enemy_kills")
			enemyFrags = tmp:getDataInt("guild_kills")
		end
		local enemyName, _tmp = "", db.getResult("SELECT `name` FROM `guilds` WHERE `id` = " .. enemy)
		if(_tmp:getID() ~= -1) then
			enemyName = _tmp:getDataString("name")
			_tmp:free()
 
		end
 
		fightingGuilds[i] = {}
		fightingGuilds[i].name = enemyName
		fightingGuilds[i].guildFrags = guildFrags
		fightingGuilds[i].enemyFrags = enemyFrags
		fightingGuilds[i].limit = tmp:getDataInt("frags")
 
		i = i + 1
	until not(tmp:next())
	tmp:free()
 
	table.sort(fightingGuilds, function (a, b)
		return (a.name < b.name)
	end)
 
 
 
	for k, v in pairs(fightingGuilds) do
 
		if (v.guildFrags  < v.limit and v.enemyFrags < v.limit  ) then
			if (warString == "") then
				warString = "Your guild is currently in war with the " .. v.name .. " (" .. v.guildFrags .. ":" .. v.enemyFrags .. " frags, limit ".. v.limit ..")"
			else
				warString = warString .. " and with the " .. v.name .. " (" .. v.guildFrags .. ":" .. v.enemyFrags.." frags, limit ".. v.limit .. ")"
			end
		end
	end
 
end
 
if (warString ~= "") then
		doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, warString .. ".")
end

 

[Xeikh]

Ok let me test.

Still Dont Works, same error

 

[Cronox]

your functions?
(internalGetPlayerInfo) Player not found on requesting player info #11

OldVersion*

 

[Xeikh]

Im using rev3777 ._. ehmm donator board one... (autor says its treated as 0.4)

 

[Ninja]

Use this one instead...

http://otland.net/f82/war-system-who-your-enemies-onlogin-133918/

 

[Xeikh]

Use this one instead...

http://otland.net/f82/war-system-who-your-enemies-onlogin-133918/

i did try too, but it doesnt work's... not with widnet layout, only tibiacom

 

[Ninja]

i did try too, but it doesnt work's... not with widnet layout, only tibiacom

This should be in login.lua and it does work.. Did you think this were a PHP file?

 

[Xeikh]

login.lua ... Im going to check it o:

there's nothing about layouts, etc... the problem is with the layout... :/
looks like it need pedestal or dont works.. ¬¬

 

[Elexonic]

local guild, enemy, guildFrags, enemyFrags = getPlayerGuildId(cid)
local fightingGuilds = {}
local tmp = db.getResult("SELECT `guild_id`, `enemy_id`, `guild_kills`, `enemy_kills`, `frags` FROM `guild_wars` WHERE `status` = 1 and (`guild_id` = "..getPlayerGuildId(cid).." or `enemy_id` = "..getPlayerGuildId(cid).. ") ;")
warString = ""
if tmp:getID() ~= -1 then
i = 1

repeat

if tmp:getDataInt("guild_id") == guild then
enemy = tmp:getDataInt("enemy_id")
guildFrags = tmp:getDataInt("guild_kills")
enemyFrags = tmp:getDataInt("enemy_kills")
else
enemy = tmp:getDataInt("guild_id")
guildFrags = tmp:getDataInt("enemy_kills")
enemyFrags = tmp:getDataInt("guild_kills")
end
local enemyName, _tmp = "", db.getResult("SELECT `name` FROM `guilds` WHERE `id` = " .. enemy)
if(_tmp:getID() ~= -1) then
enemyName = _tmp:getDataString("name")
_tmp:free()

end

fightingGuilds = {}
fightingGuilds.name = enemyName
fightingGuilds.guildFrags = guildFrags
fightingGuilds.enemyFrags = enemyFrags
fightingGuilds.limit = tmp:getDataInt("frags")

i = i + 1
until not(tmp:next())
tmp:free()

table.sort(fightingGuilds, function (a, b)
return (a.name < b.name)
end)



for k, v in pairs(fightingGuilds) do

if (v.guildFrags < v.limit and v.enemyFrags < v.limit ) then
if (warString == "") then
warString = "Your guild is currently in war with the " .. v.name .. " (" .. v.guildFrags .. ":" .. v.enemyFrags .. " frags, limit ".. v.limit ..")"
else
warString = warString .. " and with the " .. v.name .. " (" .. v.guildFrags .. ":" .. v.enemyFrags.." frags, limit ".. v.limit .. ")"
end
end
end

end

if (warString ~= "") then
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, warString .. ".")
end

This work nice in my server.

 

[Xeikh]

This work nice in my server.

Let me test it

Almost works, how did you add it to login.lua?

Edit:

SOLVED!!! DDD