Major Additions - Realm Conquest System

This Conquest System is very similar to the vBarmy system, except it has a few specific fundamental changes. Instead of every player working alone to fight other players, players work together as a single nation to fight other players who are members of different nations. Everything else in the system is pretty much self-explanitory.

Product Demo:

http://www.8wayrun.com/conquest.php

Installation Procedure:

1. Upload all files in the "upload" directory to your forum root.
2. CHMOD /conquest/nations to 777.
3. Import the product "product-conquest.xml" in your Product Manager.

Upgrade Procedure:

1. Upload all files in the "upload" directory to your forum root.
2. Import the product "product-conquest.xml" in your Product Manager.

Don't forget to click INSTALL!

If you want to donate, I'm all for it... as I'm an unemployed computer programmer...

[NakedCrook]

A trading system would be nice...and an option for admins to edit the race of other players (in case someone wants to change). A Player deletion tool would also be nice.

[JasonReynolds]

Oh so this is not for 4? X.X found in 4 mods. it messes up my screen

[weedheaven]

How can i delete somebody from this system? As i cant find it anywhere, and how can i disable the attacking messages if somebody doesnt want it.

[Digital Jedi]

Originally Posted by weedheaven

How can i delete somebody from this system? As i cant find it anywhere, and how can i disable the attacking messages if somebody doesnt want it.

I'm afraid it's not that finite. Not to mention, users are just created based on your members.

[GoBoiano]

Hi. I seem to get this problem when one of my members try to post in the forum section, but I tested it on other members accounts and it seems to work for them. His account was the only account that it didn't work for. This error always came up:

Database error in vBulletin 3.8.5:

Invalid SQL:
INSERT IGNORE INTO vb_conquest_comments (nationID, playerID, userID, username, cDate, cState, cText, cIPAdd, cSmilies)
		VALUES ('3', '5', '3', 'Poppin' Dragon', '1277150409', 'visible',	'test', '66.188.67.166', '1');

MySQL Error   : 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 'Dragon', '1277150409', 'visible',	'test', '66.188.67.166', '1')' at line 2
Error Number  : 1064
Request Date  : Monday, June 21st 2010 @ 01:00:09 PM
Error Date    : Monday, June 21st 2010 @ 01:00:09 PM
Script        : http://www.goboiano.com/conquest.php?do=comments
Referrer      : http://www.goboiano.com/conquest.php?do=comments
IP Address    : 66.188.67.166
Username      : Poppin' Dragon
Classname     : vB_Database
MySQL Version : 5.0.91-log

[Digital Jedi]

Originally Posted by GoBoiano

Hi. I seem to get this problem when one of my members try to post in the forum section, but I tested it on other members accounts and it seems to work for them. His account was the only account that it didn't work for. This error always came up:

Database error in vBulletin 3.8.5:

Invalid SQL:
INSERT IGNORE INTO vb_conquest_comments (nationID, playerID, userID, username, cDate, cState, cText, cIPAdd, cSmilies)
		VALUES ('3', '5', '3', 'Poppin' Dragon', '1277150409', 'visible',	'test', '66.188.67.166', '1');

MySQL Error   : 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 'Dragon', '1277150409', 'visible',	'test', '66.188.67.166', '1')' at line 2
Error Number  : 1064
Request Date  : Monday, June 21st 2010 @ 01:00:09 PM
Error Date    : Monday, June 21st 2010 @ 01:00:09 PM
Script        : http://www.goboiano.com/conquest.php?do=comments
Referrer      : http://www.goboiano.com/conquest.php?do=comments
IP Address    : 66.188.67.166
Username      : Poppin' Dragon
Classname     : vB_Database
MySQL Version : 5.0.91-log

It's probably the single quote in his screen name. It's breaking the SQL syntax.

[Dribbles]

The ' in Poppin' Dragon might be messing things up. Try it as Poppin Dragon without the '

[GoBoiano]

Originally Posted by Digital Jedi

It's probably the single quote in his screen name. It's breaking the SQL syntax.

Originally Posted by Dribbles

The ' in Poppin' Dragon might be messing things up. Try it as Poppin Dragon without the '

Yes. That was the problem. Thanks guys

[tigrattack]

Originally Posted by weedheaven

How can i delete somebody from this system? As i cant find it anywhere, and how can i disable the attacking messages if somebody doesnt want it.

Run Query:

DELETE FROM conquest_players WHERE forumID = <userid on forums itsself>

[sticky]

Originally Posted by session-one

is a vb4 launch planned?

Same question.