[EPIC C++] GUILD HOUSING Script + SQL Query

[tekkeryole]

Guild Housing Script V.4.0
Updated From AC WEB Thread

WARNING! THIS SCRIPT HAS BEEN FULLY TESTED WITH ASPIRE HEARTHSTONE. CONVERSIONS WILL BE MADE AS FAST AS I CAN GET TO THEM, UNLESS THE COMMUNITY WANTS TO PUT IN THEIR CONVERSIONS, I WOULD BE MORE THEN HAPPY TO LOOK THEM OVER
ARCEMU SHOULD HAVE SUPPORT ON THIS SCRIPT VERSION IN THE NEXT FEW DAYS.

What it Does:

Allows Guild Masters to Purchase Zones.
Once purchased, Guild Masters and Guild members can port to your designated Guild House location set for that Zone.
2 Announcement scripts on Guild Join and Guild Creation
Upon either of those 2 functions above players will either recieve the Guild Master Control item or the Member Item.




Updates:
One more column addition to the table, please update yours in the characters db
I want to start slimming this down a bit... Instead of Zones (e.g. Dun Morgh = 1 Zone)
I'm going to be working into Area ID's, areas are smaller places (e.g. Westfall = 1 Area)
Changed the script to an Item due to more then a few suggestions.
This makes my range of movement alot farther
If your guild owns a house in any of the available zones you can be ported to it.
Now... the tricky part I'm trying to work around is the fact that, while i'm using
the players coords at time of purchase to mark the location of the house...
I need to figure out a different way of locating houses i guess.
Fixed an issue I didn't notice for Port Option... now removes correct amount
before it did nothing on port option to take away the gold.
Lowbies now have an item upon Joining a Guild
I went ahead and threw in a world announcement for this to go along
with the announcement on Guild Creation

This one took me awhile to finish, so I hope you guys like it. Feed back is appreciated


And on with the Download link -

DOWNLOAD


* Written by Tekkeryole / AKA / WHOS / Galv
* Copyright (C)2009 <http://wowtek.servegame.org/> WoWTek Realms
* Feel free to modify as you wish - Give Credits if you
* Repost this anywhere else and/or modify and re-release.
* I will not tolerate
* Leechers and / or code stealers
* So for the sake of Open Source, give Credits please.
* Cheers

[lick_z]

Nice script ! GJ +Rep

[tekkeryole]

##EDIT##
removed update from this post to put at top post instead.

[Linkn]

Would edit the main post for the update On topic, nice job. +Rep

[Wheeze201]

This has been done before but nice contribution. +rep x3

[tekkeryole]

This has been done before but nice contribution. +rep x3

It might have been done before, but definately not the way Im doing it. This is still not finished and will be alot more in depth in the next few weeks. It started out as a housing script and is now moving into a similar system as Global WoWs real estate setup without the core edits with more then a simple Guild War script added to it. Hopefully in the next few days I'll have my hostility system in place to change players factions on zone entry when they dont own it.

[92eatos]

nice script i think i might it compile

[Ascelyn]

Screenshots please?

[Namor]

:worthless:

[Ascelyn]

Yes it kinda is, But still I'd love to see the pics tho, Guild housing is nice But alot of guild houses have the same prob, When theres like something extra spawned it is spawned for all guild houses ( if it's like an instance or so) is it the same with this?

[tekkeryole]

:worthless:

no offense, but not everybody has the time to do all those screenshots. I work 40 hours a week, take care of an Iguana, 2 cars, worry about my actual real life bills and plenty of other reasons that I don't care to mention, because if you were interested in the script, you would just try it out. What are the screenshots supposed to be? Pics of me typing in all the chat commands? Yer nuts dude, get a life, compile the script and try it out. OR you could just keep looking through the releases section, and OMG! Same page as this thread, holy bejesus batman,
http://www.mmowned.com/forums/emulat...much-more.html
And it even has pics! *gasps*
No thread is worthless because it has no pics. Thats why you are able to view the code when you look through the downloaded files OR just browse thru the SVN, OR you could go to the 6.0 release page, and OMG! The link for the Arc Forums thread where many Arc Users have already updated the scripts with their own code, added their own pics, and other useful info.

Now if you don't mind, I'm still in Cali for one more day, so I'm going to enjoy the rest of my only vacation in the last 8 years. Pics... I swear, I can't believe you actually thought you were cool with your little smileys holding signs like its never been done before. I'm getting drunk now, later beetchez. Btw, your mom was useless last night, tell her I said to Douche, she don't need another kid that just might end up like you. Apparently smoking all that crack affected your child birth.

Yes it kinda is, But still I'd love to see the pics tho, Guild housing is nice But alot of guild houses have the same prob, When theres like something extra spawned it is spawned for all guild houses ( if it's like an instance or so) is it the same with this?

And you do realize that you could have actually read the post.... Right? I mean, no offense, but I explained what the whole damn thing does in the top of the thread. (keywords being, your Guild House "LOCATION" as in where your #zone port is set... Its a Land System controlled by Guilds dude, just read the post, or go to the new release, its really up to you, but everybody needs to stop assuming the way the script works and just read the damn thread.


Apologies for offending anybody with my harshness, but seriously guys, think first, type later. Plus I do get a little irritated when I'm not around my green bag of goodies.

[Heliumz]

well good job +rep for your hard work

[Dominatrixx]

Really good work dude +Rep

[92eatos]

your script dont work this is what it gives for me

GuildSystem.cpp
..\..\..\..\GuildSystem.cpp(51) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(52) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(53) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(62) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(63) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(64) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(70) : error C2065: 'PlayerPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(70) : error C2146: syntax error : missing ')' before identifier 'Plr'
..\..\..\..\GuildSystem.cpp(70) : error C2182: 'AddItem' : illegal use of type 'void'
..\..\..\..\GuildSystem.cpp(70) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(71) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(71) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(103) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(103) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(103) : error C2761: 'void H_MANAGER::GossipHello(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(103) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(104) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(104) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(147) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(147) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(147) : error C2761: 'void H_MANAGER::GossipSelectOption(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(147) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(148) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(148) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(217) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(217) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(217) : error C2761: 'void LOWB_ITEM::GossipHello(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(217) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(218) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(218) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(250) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(250) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(250) : error C2761: 'void LOWB_ITEM::GossipSelectOption(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(250) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(251) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(251) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(290) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(290) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(290) : error C2761: 'void H_MANAGER::GossipEnd(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(290) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(291) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(291) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(294) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(294) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(294) : error C2761: 'void LOWB_ITEM::GossipEnd(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(294) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(295) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(295) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(298) : error C2065: 'PlayerPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(298) : error C2146: syntax error : missing ')' before identifier 'Plr'
..\..\..\..\GuildSystem.cpp(298) : error C2182: 'OnNewGuild' : illegal use of type 'void'
..\..\..\..\GuildSystem.cpp(298) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(299) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(299) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(305) : error C2065: 'PlayerPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(305) : error C2146: syntax error : missing ')' before identifier 'Plr'
..\..\..\..\GuildSystem.cpp(305) : error C2182: 'OnJoinGuild' : illegal use of type 'void'
..\..\..\..\GuildSystem.cpp(305) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(306) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(306) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(319) : error C2664: 'ScriptMgr::register_hook' : cannot convert parameter 2 from 'int' to 'void *'
        Conversion from integral type to pointer type requires reinterpret_cast, C-style cast or function-style cast
..\..\..\..\GuildSystem.cpp(320) : error C2664: 'ScriptMgr::register_hook' : cannot convert parameter 2 from 'int' to 'void *'
        Conversion from integral type to pointer type requires reinterpret_cast, C-style cast or function-style cast
PvPToken.cpp
Portals.cpp
L80etc.cpp
Insta80.cpp
Build log was saved at "file://c:\Documents and Settings\eatos\Desktop\2830\src\scripts\projects\2008_int_release_extrascripts\BuildLog.htm"
ExtraScripts - 62 error(s), 2 warning(s)
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========

[92eatos]

your script dont work this is what it gives for me

GuildSystem.cpp
..\..\..\..\GuildSystem.cpp(51) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(52) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(53) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(62) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(63) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(64) : error C2061: syntax error : identifier 'ObjectPointer'
..\..\..\..\GuildSystem.cpp(70) : error C2065: 'PlayerPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(70) : error C2146: syntax error : missing ')' before identifier 'Plr'
..\..\..\..\GuildSystem.cpp(70) : error C2182: 'AddItem' : illegal use of type 'void'
..\..\..\..\GuildSystem.cpp(70) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(71) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(71) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(103) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(103) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(103) : error C2761: 'void H_MANAGER::GossipHello(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(103) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(104) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(104) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(147) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(147) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(147) : error C2761: 'void H_MANAGER::GossipSelectOption(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(147) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(148) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(148) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(217) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(217) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(217) : error C2761: 'void LOWB_ITEM::GossipHello(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(217) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(218) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(218) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(250) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(250) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(250) : error C2761: 'void LOWB_ITEM::GossipSelectOption(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(250) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(251) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(251) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(290) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(290) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(290) : error C2761: 'void H_MANAGER::GossipEnd(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(290) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(291) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(291) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(294) : error C2065: 'ObjectPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(294) : error C2146: syntax error : missing ')' before identifier 'Ob'
..\..\..\..\GuildSystem.cpp(294) : error C2761: 'void LOWB_ITEM::GossipEnd(void)' : member function redeclaration not allowed
..\..\..\..\GuildSystem.cpp(294) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(295) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(295) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(298) : error C2065: 'PlayerPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(298) : error C2146: syntax error : missing ')' before identifier 'Plr'
..\..\..\..\GuildSystem.cpp(298) : error C2182: 'OnNewGuild' : illegal use of type 'void'
..\..\..\..\GuildSystem.cpp(298) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(299) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(299) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(305) : error C2065: 'PlayerPointer' : undeclared identifier
..\..\..\..\GuildSystem.cpp(305) : error C2146: syntax error : missing ')' before identifier 'Plr'
..\..\..\..\GuildSystem.cpp(305) : error C2182: 'OnJoinGuild' : illegal use of type 'void'
..\..\..\..\GuildSystem.cpp(305) : error C2059: syntax error : ')'
..\..\..\..\GuildSystem.cpp(306) : error C2143: syntax error : missing ';' before '{'
..\..\..\..\GuildSystem.cpp(306) : error C2447: '{' : missing function header (old-style formal list?)
..\..\..\..\GuildSystem.cpp(319) : error C2664: 'ScriptMgr::register_hook' : cannot convert parameter 2 from 'int' to 'void *'
        Conversion from integral type to pointer type requires reinterpret_cast, C-style cast or function-style cast
..\..\..\..\GuildSystem.cpp(320) : error C2664: 'ScriptMgr::register_hook' : cannot convert parameter 2 from 'int' to 'void *'
        Conversion from integral type to pointer type requires reinterpret_cast, C-style cast or function-style cast
PvPToken.cpp
Portals.cpp
L80etc.cpp
Insta80.cpp
Build log was saved at "file://c:\Documents and Settings\eatos\Desktop\2830\src\scripts\projects\2008_int_release_extrascripts\BuildLog.htm"
ExtraScripts - 62 error(s), 2 warning(s)
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========