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]

Wymietek can u make guild names alphabetically the order

 

[LucasFerraz]

Not working?
Errors in console?

 

[Mauzim]

working now but this from Wymietek
http://otland.net/f132/onlogn-war-points-127353/index4.html#post1294635

 

[Wymietek]

Omg alphabetic?
What's diffrence?
It will be much work, u need to write it into table, then sort, another loop...

 

[Mauzim]

ok well if it is hard to do is let it be so.
thanks to everyone who helped
SOLVED
//CLOSE

 

[LucasFerraz]

Tibia rl have alpabetical :'(

 

[Wymietek]

so go to rl tibia it's kinda annoying.

 

[LucasFerraz]

This script is working, missing only display in alphabetic order if more than 1 enemies.

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
	local msg, enemyName, _tmp = ""
	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
		enemyName, _tmp = "", db.getResult("SELECT `name` FROM `guilds` WHERE `id` = " .. enemy)
		if(_tmp:getID() ~= -1) then
			enemyName = _tmp:getDataString("name")
			_tmp:free()
		end
		if msg == "" then
			msg = "Your guild is currently in war with the ".. enemyName.." ("..guildFrags..":"..enemyFrags.." frags, limit "..tmp:getDataInt("frags")..")"
		else
			msg = msg.. " and " .. enemyName.." ("..guildFrags..":"..enemyFrags.." frags, limit "..tmp:getDataInt("frags")..")"
		end
	until not tmp:next()
        msg = msg .. "."
	doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, msg)
	tmp:free()

EDIT: Bug found, when war finish (Guild X win) then Guild Y(losers) still get message on login that are in fight.

 

[Wymietek]

It's because they must still have status = 1 in db...?

 

[LucasFerraz]

What is wrong? Script or War System?

 

[Mauzim]

lucas u must restart server

 

[LucasFerraz]

Already made this and it's working but if guild lose the war and member os losers relog he will receive message like before.

 

[VirrageS]

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 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
 
	doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, warString .. ".")
end

Here is script with alphabetic sort. Not sure about working.

 

[Mauzim]

lucas can u check?

 

[LucasFerraz]

Working fine, just one problem:
When war finish then everytime losers login they receive message that are in war with (winers).(It must be fixed)
Winers do not receive(It's 100%)

 

[Wymietek]

I'm agree with Mauzim, I think that you must restart ur server or do that query (after war ends).
db.executeQuery("UPDATE `guild_wars` SET `status` = 5, `end` = " .. os.time() .. " WHERE `status` = 1 AND `end` > 0 AND `end` < " .. os.time() .. ";")
It's propably bug in war system

 

[LucasFerraz]

Where I have to add this?

PS.: It's already in globalevents/script/init.lua

 

[LucasFerraz]

bump

 

[4Tech]

I do not work. There is no error in the console. As calling war, then accept it and re-login nothing is displayed.

 

[LucasFerraz]

Are you sure that you have war system by elf?



PS.:
Wymietek,

Where I have to add this?

db.executeQuery("UPDATE `guild_wars` SET `status` = 5, `end` = " .. os.time() .. " WHERE `status` = 1 AND `end` > 0 AND `end` < " .. os.time() .. ";")

PS.: It's already in globalevents/script/init.lua