Solved guild wars table

[kilirt]

hello, sorry ask for it but i've a problem with my war script

[08/07/2013 02:32:05] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: guild_wars (SELECT "guild_id", "status" FROM "guild_wars" WHERE "guild_id" IN (1,3) AND "enemy_id" IN (3,1) AND "status" IN (0, 1))

[08/07/2013 02:32:05] [Error - TalkAction Interface] 
[08/07/2013 02:32:05] data/talkactions/scripts/war.lua:onSay
[08/07/2013 02:32:05] Description: 
[08/07/2013 02:32:05] data/talkactions/scripts/war.lua:133: attempt to call field 'executeQuery' (a nil value)
[08/07/2013 02:32:05] stack traceback:
[08/07/2013 02:32:05] 	data/talkactions/scripts/war.lua:133: in function <data/talkactions/scripts/war.lua:1>

i understand it miss guild_wars table, but i must work on sqlite and i don't found how to add on it...


Sorry for my bad english
i'm french
thank for help

 

[tetra20]

i can help you with the sql tables..if you are using 0.3 then it won't work...
if you are using 0.4 i can sadly say
http://otland.net/f16/no-support-private-svn-forgotten-server-0-4-here-132978/
for your error just change db.executeQuery to db.Query(if it didn't work replace the capital Q with a normal one)

CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` INT,
  `guild_id` INT NOT NULL,
  `enemy_id` INT NOT NULL,
  `begin` BIGINT NOT NULL DEFAULT 0,
  `end` BIGINT NOT NULL DEFAULT 0,
  `frags` INT NOT NULL DEFAULT 0,
  `payment` BIGINT NOT NULL DEFAULT 0,
  `guild_kills` INT NOT NULL DEFAULT 0,
  `enemy_kills` INT NOT NULL DEFAULT 0,
  `status` TINYINT(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)  
)

Code

 

[kilirt]

i use version 0.3.6 of TFS
and for the code you give me it don't work i need the same but for sqlite console not mysql

Thank for help

i try db.Query and db.query but still same error

 

[tetra20]

1-the code i gave to you work for sqlite and i am using it
2-if you are using 0.3.6 don't change db.executeQuery
3-Hi

- - - Updated - - -

it won't work because 0.3.6 doesn't have war system you need to source edit and change lots of thing

 

[kilirt]

ok, thank for help i will try on 4.X
thank for help.

ps: i said hello on my first post

 

[tetra20]

just rep++ me if i helped