onlogn war points

[Mauzim]

how to make msg on login with guild war
example.
Your guild is currently at war with the Perfect Insanity (522:309 frags, limit 1000).

 

[Mauzim]

bump

 

[Mauzim]

bump

 

[Mauzim]

bump

 

[DukeeH]

BUMP is allower only once every 24 hours since last post.
Respect the rules.

 

[Mauzim]

Oh realy ? So what are u doing here? Why u read my thread? I think many ppls need this script ;S so..

 

[Mauzim]

Bump

 

[Mauzim]

bump

 

[LucasFerraz]

Amazing

 

[Wymietek]

local guild, enemy, guildFrags, enemyFrags = getPlayerGuildId(cid)
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 ~= -1 then
	if getDataInt("guild_id") == guild then
		enemy = getDataInt("enemy_id")
		guildFrags = getDataInt("guild_kills")
		enemyFrags = getDataInt("enemy_kills")
	else
		enemy = getDataInt("guild_id")
		guildFrags = getDataInt("enemy_kills")
		enemyFrags = 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
	doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "Your guild is currently in war with ".. enemyName.." ("..guildFrags..":"..enemyFrags..", limit "..getDataInt("frags")..").")
	tmp:free()
end

in login.lua, didnt tested, but should work.
i'm not sure about status...

 

[LucasFerraz]

Mauzin, test that and post here if works

Only backup xD

local guild, enemy, guildFrags, enemyFrags = getPlayerGuildId(cid)
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 ~= -1 then
	if getDataInt("guild_id") == guild then
		enemy = getDataInt("enemy_id")
		guildFrags = getDataInt("guild_kills")
		enemyFrags = getDataInt("enemy_kills")
	else
		enemy = getDataInt("guild_id")
		guildFrags = getDataInt("enemy_kills")
		enemyFrags = 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
	doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Your guild is currently in war with the ".. enemyName.." ("..guildFrags..":"..enemyFrags.." frags, limit "..getDataInt("frags")..").")
	tmp:free()
end

PS.:
Look this tibiarl screen

 

[Mauzim]

[16:39:57.119] [Error - CreatureScript Interface]
[16:39:57.120] data/creaturescripts/scripts/login.luanLogin
[16:39:57.120] Description:
[16:39:57.121] data/creaturescripts/scripts/login.lua:43: attempt to call global
'getDataInt' (a nil value)
[16:39:57.121] stack traceback:
[16:39:57.122] data/creaturescripts/scripts/login.lua:43: in function <data/cre
aturescripts/scripts/login.lua:26>

error getDataInt

 

[Wymietek]

local guild, enemy, guildFrags, enemyFrags = getPlayerGuildId(cid)
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
	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
	doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Your guild is currently in war with the ".. enemyName.." ("..guildFrags..":"..enemyFrags.." frags, limit "..getDataInt("frags")..").")
	tmp:free()

 

[LucasFerraz]

		local guild, enemy, guildFrags, enemyFrags = getPlayerGuildId(cid)
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
	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
	doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Your guild is currently in war with the ".. enemyName.." ("..guildFrags..":"..enemyFrags.." frags, limit "..tmp:getDataInt("frags")..").")
	tmp:free()

 

[Wymietek]

Wtf?
Just add my code to login.lua...

 

[LucasFerraz]

Both works (i think )

Check: http://otland.net/f132/talkaction-guild-members-133832/

 

[Mauzim]

wymietek your code work but u forgot

about doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Your guild is currently in war with the ".. enemyName.." ("..guildFrags..":"..enemyFrags.." frags, limit "..tmp:getDataInt("frags")..").")

SOLVED
//CLOSE

 

[LucasFerraz]

Will it work if add 'tmp;' ?

Here is:

		local guild, enemy, guildFrags, enemyFrags = getPlayerGuildId(cid)
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
	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
	doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Your guild is currently in war with the ".. enemyName.." ("..guildFrags..":"..enemyFrags.." frags, limit "..tmp:getDataInt("frags")..").")
	tmp:free()

 

[Mauzim]

yes it work but u need add end after tmp:free()

 

[Wymietek]

Will i get some rep or smth for wasting 10 min of my life?