[C++] Guild Wars v0.5

[The-Eradicator]

Updated the script a bit, Added the system of checks please post bugs on the forums.

Still working on a way to make the guilds hostile to each other

Requires a core patch. On player sight, send hostile faction ID if at war, while still sending a friendly faction to non-guild members. You'll have to patch the combat handler as well.

[mager1794]

=( dang was hoping for no core work

[Cardell]

nice +rep , would be nice if you keep sharing this kind of stuff

[mager1794]

I always share my work =D

[Taconaco]

Epic +rep hope you can make it so there hostile

[Dr. Livingstone]

Would seem like this will have to really be done right in the core. Maybe the factions.cpp? Would seem like the best fit there. For example adding something like this right to the faction.cpp right at the top of it:

	if(aguild = vguild)
		return false;
	QueryResult * res = WorldDatabase.Query("SELECT * FROM `guild_wars` WHERE `aguild` = '%s' AND `bguild` = '%s';", aguild, vguild);
	if(res == NULL)
		return false;
	Field * guilds = res->Fetch();
	if(guilds == NULL)
		return false;
	else
		return true;

[Skovisen]

Ima try this script, it looks awesome!

[mager1794]

Thanks i'm glad all of you like this script

[[pwn]age]

nice job, +rep

[LilleCarl]

well its not very nice sry but use summons... so guilds will fight...
or phases :P

[tekkeryole]

I'm having alot of trouble with this one, I've converted it to Aspire, it compiles fine, no errors, however in game when I open the options to declare war or peace and type in the guild name I want to be hostile or peaceful with it crashes the server. Something wrong with the MYSQL functions maybe?

[server1]

When i run this SQL i get this error

[Err] 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 '"guildwars"' at line 1
[Err] CREATE DATABASE "guildwars";
[Msg] Finished - Unsuccessfully
--------------------------------------------------

and when i make the database my self and just run

CREATE TABLE "guild_wars" (
  "aguild" text,
  "bguild" text
);

LOCK TABLES "guild_wars" WRITE;
UNLOCK TABLES;

i get this error

[Err] 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 '"guild_wars" (
  "aguild" text,
  "bguild" text
)' at line 1
[Err] CREATE TABLE "guild_wars" (
  "aguild" text,
  "bguild" text
);
[Msg] Finished - Unsuccessfully
--------------------------------------------------