Advanced-Guild-War-System {Count in site the frags!} Now Edited with tables of DB!

[Kubik213]

yea, i don't know how to install this, so ;s it sucks

I would see full tutorial of install this with database table ; o and all

 

[tyngaste]

Tables:

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'
);

great rep+

 

[Kubik213]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tfs.wars' doesn't exist' in D:\xampp\htdocs\accmaker\guildwar.php:6 Stack trace: #0 D:\xampp\htdocs\accmaker\guildwar.php(6): PDO->query('SELECT * FROM w...') #1 D:\xampp\htdocs\accmaker\index.php(148): include('D:\xampp\htdocs...') #2 {main} thrown in D:\xampp\htdocs\accmaker\guildwar.php on line 6

What thing i did wrong ;/? help plx

 

[tyngaste]

Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\war.php on line 6

$wars = $SQL->query("SELECT * FROM wars WHERE status = 1 ORDER BY date DESC;");

[09/04/2009 15:27:45] Lua Script Error: [GlobalEvent Interface]
[09/04/2009 15:27:45] data/globalevents/scripts/wars.lua

[09/04/2009 15:27:45] cannot open ./GuildWar.lua: No such file or directory
[09/04/2009 15:27:45] [Warning - Event::loadScript] Can not load script (data/globalevents/scripts/wars.lua)
how to fix this?

 

[Kubik213]

i have the same as you....

 

[ExibeR]

What thing i did wrong ;/? help plx

Use phpmyadmin and insert:

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'
);

into your database.

 

[ExibeR]

Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\war.php on line 6

$wars = $SQL->query("SELECT * FROM wars WHERE status = 1 ORDER BY date DESC;");

[09/04/2009 15:27:45] Lua Script Error: [GlobalEvent Interface]
[09/04/2009 15:27:45] data/globalevents/scripts/wars.lua

[09/04/2009 15:27:45] cannot open ./GuildWar.lua: No such file or directory
[09/04/2009 15:27:45] [Warning - Event::loadScript] Can not load script (data/globalevents/scripts/wars.lua)
how to fix this?

I'm working on that problem. I will release all my solutions etc.

 

[Kubik213]

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` )
);# MySQL zwrócił pusty wynik (zero rekordów).
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'
);# MySQL zwrócił pusty wynik (zero rekordów).

And all is the same as earlier...
The same error

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tfs.wars' doesn't exist' in D:\xampp\htdocs\accmaker\guildwar.php:6 Stack trace: #0 D:\xampp\htdocs\accmaker\guildwar.php(6): PDO->query('SELECT * FROM w...') #1 D:\xampp\htdocs\accmaker\index.php(148): include('D:\xampp\htdocs...') #2 {main} thrown in D:\xampp\htdocs\accmaker\guildwar.php on line 6

When will you make your own solution? i will still waiting for this

 

[ExibeR]

And all is the same as earlier...
The same error



When will you make your own solution? i will still waiting for this

Try this one then

CREATE TABLE IF NOT EXISTS `wars` (
  `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'
);

You forgot to change your table name:

wars_list changed to wars

 

[tyngaste]

waiting for your updates , btw by doing this in begining

in that php file released

go to first line <?PHP change to <?PHP?>

then you will start getting tables and such but ALOT OF ERRORS

i cant come further then that dunno if that helped

 

[ExibeR]

waiting for your updates , btw by doing this in begining

in that php file released

go to first line <?PHP change to <?PHP?>

then you will start getting tables and such but ALOT OF ERRORS

i cant come further then that dunno if that helped

I like that you share your solutions as well.
Your one of them who understands that we have to work together to make it work.

People who fixed this, and refuse to tell it,
will have problems later when others find the solution to
something and doesn't share it.

Sharing Is Caring

 

[tyngaste]

I like that you share your solutions as well.
Your one of them who understands that we have to work together to make it work.

People who fixed this, and refuse to tell it,
will have problems later when others find the solution to
something and doesn't share it.

Sharing Is Caring

np

 

[Kubik213]

ExibeR, it shows me other error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'' in D:\xampp\htdocs\accmaker\guildwar.php:6 Stack trace: #0 D:\xampp\htdocs\accmaker\guildwar.php(6): PDO->query('SELECT * FROM w...') #1 D:\xampp\htdocs\accmaker\index.php(148): include('D:\xampp\htdocs...') #2 {main} thrown in D:\xampp\htdocs\accmaker\guildwar.php on line 6

 

[krankthefunk]

just scan through the thread and i gotta say all these kids dat selfish n dont want release your KOOOL scripts to the community, well just leave the community and dont post anything ever. Also wow your script is so kool. If ELF were like you kids then u wouldn't even have a chance to create this system? he's kind enough to even release the distro to everyone.

@Topic even though I dont use dis still ty for sharin it with everyone

 

[tyngaste]

Bump

 

[Mazen]

Nice scripts!

 

[Kubik213]

yea but i don't know where i can paste this scripts... 4? scripts dont have a description of name and where i must paste this...


but, for me, only .php script is wrong... can anybody paste here a good working php script? I will give reputation point!

 

[cirtaboy]

Thank you, rep+

 

[tyngaste]

bump

 

[Kubik213]

bump too,

I HAVE THAT PROBLEM:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause'' in D:\xampp\htdocs\accmaker\guildwar.php:6 Stack trace: #0 D:\xampp\htdocs\accmaker\guildwar.php(6): PDO->query('SELECT * FROM w...') #1 D:\xampp\htdocs\accmaker\index.php(148): include('D:\xampp\htdocs...') #2 {main} thrown in D:\xampp\htdocs\accmaker\guildwar.php on line 6

Please help me =/, i dont know what i did wrong;/