[REQUEST]TFS 1.0 War System

[putamerda]

As the title says, someone got an WarSystem talkaction for TFS 1.0?

 

[putamerda]

up

 

[Xavicrak]

up

 

[Danger II]

is it allowed to post that here?

 

[Ninja]

http://otland.net/threads/znote-1-0-guild-war-system.204588/page-2#post-1994985

 

[Tovar]

@Ninja when I try to execute this query

ALTER TABLE `guild_wars` ADD COLUMN `frags` int(10) unsigned NOT NULL DEFAULT '0',
ALTER TABLE `guild_wars` ADD COLUMN `payment` bigint(20) unsigned NOT NULL DEFAULT '0',

It sends

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE `guild_wars` ADD COLUMN `payment` bigint(20) unsigned NOT NULL DEFAULT '0'' at line 2

 

[Ninja]

ALTER TABLE `guild_wars` ADD `frags` int(10) unsigned NOT NULL DEFAULT 0, ADD `payment` bigint(20) unsigned NOT NULL DEFAULT 0

 

[Tovar]

@Ninja http://pastebin.com/TZrvhtAc This send a error in console when I try to invite a war...

Attemp to call field 'explode' a nil value stack traceback
[C:] In function 'explode'

War.lua
Line 16

also I want to know if after fix that if this work 100% you are agree if I post it as new thread, all clear and working.

 

[Ninja]

Change

local t = string.explode(param, ",")

to

local t = param:split(",")

 

[Tovar]

@Ninja

 

[Ninja]

ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL DEFAULT 0

- - - Edit - - -

You might wanna add the fields name1, name2 to the invitation query since they're currently left out (otherwise it won't display guild names on your website).

db.query("INSERT INTO `guild_wars` (`guild1`, `guild2`, `name1`, `name2`, `started`, `ended`, `frags`, `payment`) VALUES (" .. guild .. ", " .. enemy .. ", " .. db.escapeString(getPlayerGuildName(cid)) .. ", " .. db.escapeString(enemyName) .. ", " .. begining .. ", " .. ending .. ", " .. frags .. ", " .. payment .. ");")

 

[rodrilois]

bump

 

[pitis91]

bump

 

[Ninja]

You can find the talkactions here and "fixes" in this thread?