GlobalEvent [MOD]Full auto WAR-TeamBattle Event(with random rewards)

[Doggynub]

time between is 20 min , then you can now be able to talk to npc too start again . Sure you waited 20 min?

 

[owned]

yea dude i waited more like an hour =p and the npc still said the message where it wouldnt allow me

 

[Doggynub]

did it worked when it was 5min?

 

[owned]

uhhh idk lemme try real quick.

 

[andrewss]

not work with npc
when say "hi"
21:37 Eventer: Hello Admin Andrewss. If you want to join the Battle just tell me.
when say "battle" nothing
please help

 

[Doggynub]

then you have made something wrong with installation lol.

 

[Doggynub]

Plzz more testers

 

[Derek Boom Boom]

shorter?

function getBlue()
    return db.getResult("SELECT `blue` FROM `Teams` WHERE `id`='" .. 1):getDataInt("blue")  
end

function getRed()
    return db.getResult("SELECT `red` FROM `Teams` WHERE `id`='" .. 1):getDataInt("red")
end

function removeRed()
    return db.executeQuery("UPDATE `Teams` SET `red` = `red` - " .. 1 .. " WHERE `id`= '" .. 1 .. "' LIMIT 1;")
end

function removeBlue()
    return db.executeQuery("UPDATE `Teams` SET `blue` = `blue` - " .. 1 .. " WHERE `id`= '" .. 1 .. "' LIMIT 1;")
end

function resetBlue()
    return db.executeQuery("UPDATE `Teams` SET `blue` = " .. 0 .. " WHERE `id`= '" .. 1 .. "' LIMIT 1;")
end

function resetRed()
    return db.executeQuery("UPDATE `Teams` SET `red` = " .. 0 .. " WHERE `id`= '" .. 1 .. "' LIMIT 1;")
end

Why didn't u add checks and why you haven't results freeying (Dunno if I spelled it correct), ye ye keep codes with memory leaks... =\

Correct one:

function something()
	local res = db.getResult("SELECT `field` FROM `table`;")
	local value = 0
	if(res:getID() ~= -1) then
		value = res:getDataInt("field")
		res:free()
	end
	return value
end

 

[Derek Boom Boom]

Actually i donno about the result freeing thing? can you explain .

My example explains everything.

 

[Doggynub]

this could be used when excuting and gettingresults?

 

[hodleo]

ye, but there won't be crash dw derek is just paranoid
well, the leak will just make server spend a bit more % ram

 

[Doggynub]

oh

 

[penivaldo]

folder

And if i dont have the mods folder? i cant have it?

 

[Derek Boom Boom]

ye, but there won't be crash dw derek is just paranoid
well, the leak will just make server spend a bit more % ram

Ye ye, I'm paranoid because I'm trying to help with fixing wrong scripts.

 

[EvulMastah]

ye, but there won't be crash dw derek is just paranoid
well, the leak will just make server spend a bit more % ram

And a bit more % ram can lead to crash on 32-bit machines, kthx.

 

[Doggynub]

Ye ye, I'm paranoid because I'm trying to help with fixing wrong scripts.

ok i know now how to use with get data..
Waht about execute ?

 

[Derek Boom Boom]

It should be, simply:

function something()
	db.executeQuery("query")
	return true
end

 

[Nefs]

tfs 0.4 gots crash with this MOD :/

 

[lycefur]

When 2 chars enter arena and they fight, one of them is at black hp, instead of teleport and giving rewards to winning team nothing happens and in console this thing appears (picture in attachement). Help please. I haz TFS 0.3.6 on tibia 8.54.

 

[owned]

@up i tested this on the same distro as u bro, works 100% perfect u must have done something wrong =o