Sql

[mocoba]

Hello
i have this error and idk how to fix please tell me how
Rep++

 mysql_real_query(): SELECT `id`, `guild_id`, `enemy_id` FROM `guild_wars` WHERE `status` IN (1,4) AND `end` > 0 AND `end` < 1298392379 - MYSQL ERROR: Table 'tibia.guild_wars' doesn't exist (1146)

Thanks Best Ppl

 

[amiroslo2]

u dont have this table= tibia.guild_wars

Table 'tibia.guild_wars' doesn't exist

u need to add it

 

[mocoba]

i made it and found this error

mysql_real_query(): SELECT `id`, `guild_id`, `enemy_id` FROM `guild_wars` WHERE `status` IN (1,4) AND `end` > 0 AND `end` < 1298397105 - MYSQL ERROR: Unknown column 'status' in 'where clause' (1054)

anyone help me will get Rep++

 

[ruda]

the field `status` is missing in your table

 

[mocoba]

can u tell me the table please cuz iam noob in sql

 

[Cykotitan]

You shouldn't be using Elf's war system if you haven't paid for it

 

[mocoba]

just need the table if u know tell me and i will rep++

 

[mocoba]

it is hard to help me guys ?

 

[Evil Puncker]

it is hard to buy elf war system?

 

[rudger]

Same problem here, can anyone post or pm me the sql query?

 

[rudger]

bump!