War System For Websites (Now With Php Files)

kokorec · Feb 15, 2009

This is quote from Gesior.I am added website php files but i am not try.i hope it will work

PHP:

Credits:
gesior.pl - Script
kokorec - Edited Some Things
Talaturen - Idea ; Thanks

LUA script to count team and player frags:

Code:

local fragTime = getConfigInfo('timeToDecreaseFrags')

function onKill(cid, target)
    local team = 0
    local id = 0
    if isPlayer(target) == TRUE and getPlayerGuildId(cid) > 0 and getPlayerGuildId(target) > 0 then
        local inWar_team1 = db.getResult("SELECT * FROM `wars_list` WHERE `team_1` like '%,".. getPlayerGuildId(cid) ..",%' AND `team_2` like '%,".. getPlayerGuildId(target) ..",%';")
        if(inWar_team1:getID() ~= -1) then
            id = tonumber(inWar_team1:getDataInt("id"))
            team = 1
            inWar_team1:free()
        else
            local inWar_team2 = db.getResult("SELECT * FROM `wars_list` WHERE `team_1` like '%,".. getPlayerGuildId(target) ..",%' AND `team_2` like '%,".. getPlayerGuildId(cid) ..",%';")
            if(inWar_team2:getID() ~= -1) then
                id = tonumber(inWar_team2:getDataInt("id"))
                team = 2
                inWar_team2:free()
            end
        end
        if team > 0 then
            db.executeQuery("INSERT INTO `war_deaths` (`war_id`, `team`, `from_guild`, `to_guild`, `player_id`, `killed_by`) VALUES (" .. id .. ", " .. team .. ", " .. getPlayerGuildId(cid) .. ", " .. getPlayerGuildId(target) .. ", " .. getPlayerGUID(target) .. ", " .. getPlayerGUID(cid) .. ");")
            doPlayerSetRedSkullTicks(cid, getPlayerRedSkullTicks(cid)-fragTime)
        end
    end
    return TRUE
end

PHP:

CREATE TABLE IF NOT EXISTS `wars_list` (
  `id` int(11) NOT NULL auto_increment,
  `team_1` varchar(255) NOT NULL,
  `team_2` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
);
CREATE TABLE IF NOT EXISTS `war_deaths` (
  `war_id` int(11) NOT NULL,
  `team` int(11) NOT NULL,
  `from_guild` int(11) NOT NULL default '0',
  `to_guild` int(11) NOT NULL default '0',
  `player_id` int(11) NOT NULL default '0',
  `killed_by` int(11) NOT NULL default '0'
);

Example of war:

PHP:

INSERT INTO `wars_list` (`id`, `team_1`, `team_2`) VALUES
(1, '3,', '38,');

(guild ID 3 vs. guild ID 38)

PHP:

INSERT INTO `wars_list` (`id`, `team_1`, `team_2`) VALUES
(1, '3,6,', '38,23,');

(guild ID 3 and guild ID 6 vs. guild ID 38 and guild ID 23 )
Always "," at end of guilds list.
Script save info:

PHP:

INSERT INTO `war_deaths` (`war_id`, `team`, `from_guild`, `to_guild`, `player_id`, `killed_by`) VALUES
(1, 1, 3, 38, 17797, 15422),
(1, 1, 3, 38, 17797, 15422);

1 - war id = 1
1 - frag for team 1
3 - killer was from guild id 3
38 - killed player was from guild id 38
17797 - id of killed player
15422 - id of killer
with this table you can generate any stats of war.. like:
- top 5 fragers from 1 team (or 1 guild)

PHP:

SELECT `players`.`name`, COUNT(`war_deaths`.`killed_by`) frags FROM `war_deaths`, `players` WHERE `war_deaths`.`war_id` = 1 AND `players`.`id` = `war_deaths`.`killed_by` AND `war_deaths`.`team` = 1 GROUP BY `war_deaths`.`killed_by` ORDER BY COUNT(`war_deaths`.`killed_by`) DESC

- number of frags of teams from 'war id 1'

PHP:

SELECT `team`, COUNT(`war_deaths`.`team`) frags FROM `war_deaths` WHERE `war_deaths`.`war_id` = 1 GROUP BY `war_deaths`.`team` ORDER BY COUNT(`war_deaths`.`team`) DESC

Script remove frags (can't get more then 1 frag if kill only enemy team members)

Now someone must write PHP scripts to invite guilds and show stats on page.
EDIT:
First page - informations about teams

REP+++??

Victor · Feb 15, 2009

Where can I find php files?

#Edit:
"Now someone must write PHP scripts to invite guilds and show stats on page."

Ehe.

kokorec · Feb 15, 2009

players need contact with God for war

Gsp · Feb 15, 2009

come on guys it shouldnt be too hard
make the php

HeberPcL · Feb 15, 2009

Create NPC for active war and PHP files for website.

kokorec · Feb 15, 2009

i will talk with Gesior.pl for PHP files.

Dalale · Feb 15, 2009

Water Fighter · Feb 16, 2009

tae · Feb 16, 2009

Finally someone who isn't stingy.

richux · Feb 17, 2009

Looks nice. Ill try it later.

Alexo · Feb 17, 2009

and were i have to put all that?
would be great if someone can tell me with out spaming

Inteligentny · Feb 17, 2009

Code:

02/2009 15:46:28] Lua Script Error: [CreatureScript Interface] 
[17/02/2009 15:46:28] data/creaturescripts/scripts/kill.lua:onKill

[17/02/2009 15:46:28] data/lib/database.lua:39: [Result:getDataInt]: Result not set!
[17/02/2009 15:46:28] stack traceback:
[17/02/2009 15:46:28] 	[C]: in function 'error'
[17/02/2009 15:46:28] 	data/lib/database.lua:39: in function 'getDataInt'
[17/02/2009 15:46:28] 	data/creaturescripts/scripts/kill.lua:15: in function <data/creaturescripts/scripts/kill.lua:3>

edit: to make it work without those errors 1st guild vs 2nd guild we have to make something like:

Code:

INSERT INTO `wars_list` (`id`, `team_1`, `team_2`) VALUES
(1, '1,', '2,');

and second time

Code:

INSERT INTO `wars_list` (`id`, `team_1`, `team_2`) VALUES
(2, '2,', '1,');

other way if we just make first one, when someone from guild with id 2 kill someone from guild id 1 errors apears in console and scripts dont work at all

Gesior.pl · Feb 18, 2009

fixed (in line 15 was "...inWar_team1:getDataInt...", not 2)lua script (its not final version of lua script):

PHP:

local fragTime = getConfigInfo('timeToDecreaseFrags')

function onKill(cid, target)
	local team = 0
	local id = 0
	if isPlayer(target) == TRUE and getPlayerGuildId(cid) > 0 and getPlayerGuildId(target) > 0 then
		local inWar_team1 = db.getResult("SELECT * FROM `wars_list` WHERE `team_1` like '%,".. getPlayerGuildId(cid) ..",%' AND `team_2` like '%,".. getPlayerGuildId(target) ..",%';")
		if(inWar_team1:getID() ~= -1) then
			id = tonumber(inWar_team1:getDataInt("id"))
			team = 1
			inWar_team1:free()
		else
			local inWar_team2 = db.getResult("SELECT * FROM `wars_list` WHERE `team_1` like '%,".. getPlayerGuildId(target) ..",%' AND `team_2` like '%,".. getPlayerGuildId(cid) ..",%';")
			if(inWar_team2:getID() ~= -1) then
				id = tonumber(inWar_team2:getDataInt("id"))
				team = 2
				inWar_team2:free()
			end
		end
		if team > 0 then
			db.executeQuery("INSERT INTO `war_deaths` (`war_id`, `team`, `from_guild`, `to_guild`, `player_id`, `killed_by`) VALUES (" .. id .. ", " .. team .. ", " .. getPlayerGuildId(cid) .. ", " .. getPlayerGuildId(target) .. ", " .. getPlayerGUID(target) .. ", " .. getPlayerGUID(cid) .. ");")
			doPlayerSetRedSkullTicks(cid, getPlayerRedSkullTicks(cid)-fragTime)
		end
	end
	return TRUE
end

No more errors. Invities system should not allow to make 2 wars where guild ID 1 fight against guild ID 2
and now to invite guild you must add:

INSERT INTO `wars_list` (`id`, `team_1`, `team_2`) VALUES
(2, ',2,', ',1,');

or:

INSERT INTO `wars_list` (`id`, `team_1`, `team_2`) VALUES
(2, ',2,5,', ',1,66,');

in old version it could load war of guild '151' as '1', because '151,' cointains '1,'

Master-m · Feb 18, 2009

Gesior.pl said:

fixed lua script (its not final version of lua script):

PHP:

local fragTime = getConfigInfo('timeToDecreaseFrags')

function onKill(cid, target)
	local team = 0
	local id = 0
	if isPlayer(target) == TRUE and getPlayerGuildId(cid) > 0 and getPlayerGuildId(target) > 0 then
		local inWar_team1 = db.getResult("SELECT * FROM `wars_list` WHERE `team_1` like '%,".. getPlayerGuildId(cid) ..",%' AND `team_2` like '%,".. getPlayerGuildId(target) ..",%';")
		if(inWar_team1:getID() ~= -1) then
			id = tonumber(inWar_team1:getDataInt("id"))
			team = 1
			inWar_team1:free()
		else
			local inWar_team2 = db.getResult("SELECT * FROM `wars_list` WHERE `team_1` like '%,".. getPlayerGuildId(target) ..",%' AND `team_2` like '%,".. getPlayerGuildId(cid) ..",%';")
			if(inWar_team2:getID() ~= -1) then
				id = tonumber(inWar_team2:getDataInt("id"))
				team = 2
				inWar_team2:free()
			end
		end
		if team > 0 then
			db.executeQuery("INSERT INTO `war_deaths` (`war_id`, `team`, `from_guild`, `to_guild`, `player_id`, `killed_by`) VALUES (" .. id .. ", " .. team .. ", " .. getPlayerGuildId(cid) .. ", " .. getPlayerGuildId(target) .. ", " .. getPlayerGUID(target) .. ", " .. getPlayerGUID(cid) .. ");")
			doPlayerSetRedSkullTicks(cid, getPlayerRedSkullTicks(cid)-fragTime)
		end
	end
	return TRUE
end

No more errors. Invities system should not allow to make 2 wars where guild ID 1 fight against guild ID 2

Thanks

Zonet · Feb 18, 2009

Gesior when are you going to make the PHP files so everything works?

btq i already got one

kokorec · Feb 18, 2009

updated script.now no errors

Froit · Feb 18, 2009

WTF!!!! is awesome
thx rep++

Alexo · Feb 18, 2009

Zonet said:
Gesior when are you going to make the PHP files so everything works?

btq i already got one

i want to know it to

Richi Garza · Feb 21, 2009

Realy good job Gesior!! but my acc maker dosnt work...

elf · Feb 21, 2009

Add to credits: Idea- Talaturen; thanks.

War System For Websites (Now With Php Files)

Tavon Online - Soon

Attachments

New Member

Tavon Online - Soon

RP

[PowerOT.com.br]

Tavon Online - Soon

GX

New Member

Active Member

Tibera.org

New Member

Im not.

Mega Noob&LOL 2012

Need help? Just ask!

Web Developer

Tavon Online - Soon

New Member

New Member

YeYe

Sing, sing blue silver

Similar threads