• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[REQUEST]TFS 1.0 War System

Sort by date Sort by votes
@Ninja when I try to execute this query
Code: 
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
Code: 
#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
 
Upvote 0 Downvote
Code: 
ALTER TABLE `guild_wars` ADD `frags` int(10) unsigned NOT NULL DEFAULT 0, ADD `payment` bigint(20) unsigned NOT NULL DEFAULT 0
 
Upvote 0 Downvote
@Ninja http://pastebin.com/TZrvhtAc This send a error in console when I try to invite a war...

Code: 
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.
 
Upvote 0 Downvote
Code: 
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).

Code: 
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 .. ");")
 
Last edited:
Upvote 0 Downvote
Back
Top