[Release] Guild Housing Item + SQL

[scott07]

Hey Everyone =] This Is My First Release On Mmowned So.. I Hope You Enjoy. Ok Well Ill Put Up The Source Code + SQLs Needed To Be Executed Here And Also A Pre-Compiled Pack With VCPROJ , DLL , Source Files and The SQL File Needed.

DO NOT POST MY PACKS ANYWHERE ELSE!!! IF YOU DO SO I WILL TRACK YOU DOWN AND KILL YOUR PERSONALLY!

GuildPortItem.cpp

#include "StdAfx.h"
#include "Setup.h"

class SCRIPT_DECL GuildPortItem : public GossipScript{
public:
void GossipHello(Object * pObject, Player* Plr, bool AutoSend);
void GossipSelectOption(Object * pObject, Player* Plr, uint32 Id, uint32 IntId, const char * Code);
void GossipEnd(Object * pObject, Player* Plr);
void Destroy()
{
delete this;
}
};
void GuildPortItem::GossipHello(Object * pObject, Player* Plr, bool AutoSend)
{
GossipMenu * Menu;
uint32 TextID = 820;
objmgr.CreateGossipMenuForPlayer(&Menu, pObject->GetGUID(), TextID, Plr);
if(Plr->GetGuildId() > 0)
{
Menu->AddItem(5, "Go to your Guild Location", 1);
}
else
{
Menu->AddItem(5, "You know what, never mind", 2);
}
if(AutoSend)
Menu->SendTo(Plr);
}
void GuildPortItem::GossipSelectOption(Object * pObject, Player * Plr, uint32 Id, uint32 IntId, const char * Code)
{
Item * pItem = (pObject->GetTypeId()==TYPEID_ITEM)?((Item*)pObject):NULL;
if(pItem==NULL)
return;
switch(IntId)
{
case 0:
{
GossipHello(pItem, Plr, true);
}
break;
case 1:
{
QueryResult * result = WorldDatabase.Query( "SELECT * FROM guildlocations WHERE `GuildID`=%u",Plr->GetGuildId() );
if(result)
{
do
{
Field * fields = result->Fetch();
uint32 locmap = fields[1].GetUInt32();
float x = fields[2].GetFloat();
float y = fields[3].GetFloat();
float z = fields[4].GetFloat();
Plr->SafeTeleport(locmap, 0, LocationVector(x, y, z));
}
while (result->NextRow());
delete result;
}
else
{
sChatHandler.SystemMessage(Plr->GetSession(),"No location found in the database");
}
Plr->Gossip_Complete();
}
break;
case 2:
{
Plr->Gossip_Complete();
}
break;
}
}
void GuildPortItem::GossipEnd(Object * pObject, Player* Plr)
{
GossipScript::GossipEnd(pObject, Plr);
}
void SetupGuildPortItem(ScriptMgr * mgr)
{
GossipScript * gpItem = (GossipScript*) new GuildPortItem();
mgr->register_item_gossip_script(34583, gpItem); //GP Item
}

Setup.cpp

#include "StdAfx.h"
#include "Setup.h"

#include <ScriptSetup.h>

extern "C" SCRIPT_DECL uint32 _exp_get_script_type()
{
    return SCRIPT_TYPE_MISC;
}

extern "C" SCRIPT_DECL void _exp_script_register(ScriptMgr* mgr)
{
SetupGuildPortItem(mgr);

}

#ifdef WIN32

BOOL APIENTRY DllMain( HANDLE hModule, DWORD  ul_reason_for_call, LPVOID lpReserved )
{
    return TRUE;
}

#endif

Setup.h

#ifndef GuildPortItem_SETUP_H
#define GuildPortItem_SETUP_H

void SetupGuildPortItem(ScriptMgr * mgr);

#endif

Guildlocations Structure

CREATE TABLE `guildlocations` (
  `GuildID` int(10) unsigned NOT NULL default '0',
  `locmap` int(10) unsigned NOT NULL default '0',
  `x` float NOT NULL default '0',
  `y` float NOT NULL default '0',
  `z` float NOT NULL default '0',
  UNIQUE KEY `GuildID` (`GuildID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Guild Item SQL

INSERT INTO `items` VALUES ('34583', '8', '-1', '-1', 'Guild Item', 'Guild Item', 'Guild Item', 'Guild Item', '42629', '1', '0', '0', '0', '0', '1503', '1791', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '33208', '0', '579', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'Let The Guild Battles Begin!', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, '0', null, '0', '0', '0', '0', '0', '0', '0', null, null, '0', '-1', '0');

The DLL Included Is Compiled With Ascent Revision4289

Download Here!!

Password - MMOWNED
Pack Download Guide -
1.Download Via The Link
2.Place The DLL Inside Your Script_Bin Folder Where Your Ascent Is Located
3.Execute The SQL Which Is Included In The Download
4.Restart Your Server
Ok Well Your Done.

To Add Guild Locations
1.Find Out The ID Of The Guild You Want In The Guilds Table
2.Put The Id Number Into The Section Id In Your Guildlocations Table
3.Go To The Place You Want And Type .gps
4.Now adding the x,y,z in the right places in The Guildlocations Table
5.Restart Your Server And Your Done
(You Have To Be In That Guild To Be Teleported To Your Chosen Location)


REMEMBER THE DLL WILL ONLY WORK WITH ASCENT REVISION 4289!

Credits:
Meh for Making it a Pack
People Off Ascent Emu for the coding

[volitle]

kewl nice release +Rep

EDIT/ w00t first post hehe

[scott07]

Thanks alot =]

[volitle]

np nice to know your not a leecher hehe

[SectorSeven]

+Rep x2
Even though parts of code were released on ascentemu

[Lich King]

Nice release, +Rep

[scott07]

Thanks for the +Rep, im nearly out of leecher

[Lich King]

You are out of leecher Congrats!

[volitle]

you are your on 6 rep gratz

[doublehex]

lol basic yet effective script, im still workin on my stuff, + rep

[scott07]

Yeh man your script(s) are gonna own hope it all goes good with it !

[doublehex]

im workin on setting up server for 2.4 atm with sec7 so ill have to finish them later

[scott07]

=O im jealous xD i could maybe help ya, just gimme a buzz on msn.

Corporal!!

[nbhfam]

so Great work !! thx scott07

[Anarchy [RD]]

i know ur a good guy +Rep and u get a cookie too