[HELP]SQL, C++ - Item Gossip

OK ... I made a gossip item ... really wanna know ? heres source :

Code:

---

class SCRIPT_DECL MasterGuildStone : 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 MasterGuildStone::GossipHello(Object* pObject, Player * Plr, bool AutoSend)

    {

        GossipMenu *Menu;

        objmgr.CreateGossipMenuForPlayer(&Menu, pObject->GetGUID(), 2593, Plr);
        Menu->AddItem(0, "Create Guild Stone", 1);
        Menu->AddItem(0, "Take me to my Guild City", 2);
       
        if(AutoSend)
            Menu->SendTo(Plr);

    }

void MasterGuildStone::GossipSelectOption(Object* pObject, Player* Plr, uint32 Id, uint32 IntId, const char * Code)

    {

        GossipMenu * Menu;

        switch(IntId)

        {
        case 1:
            {
                Plr->GetItemInterface()->SafeAddItem(90003, INVENTORY_SLOT_NOT_SET, 23);
                Plr->Gossip_Complete();
            }break;
        case 2:
            {
                if(Plr->GetItemInterface()->GetItemCount(2838) >= 1 && Plr->GetSession()->HasGMPermissions())
                {
                    Plr->EventTeleport(0, -4816.450195, -984.530029, 464.709015);
                }
                Plr->Gossip_Complete();
            }break;

        }

}

void MasterGuildStone::GossipEnd(Object * pObject, Player* Plr)

{
GossipScript::GossipEnd(pObject, Plr);
}

---

Well ... I dont think my problem lies in the script ... it compiles perfectly ... but the item doesnt show a gossip menu ... what I'd like to know is what is the Flag for a Gossip item ... coz I think thats my problem : /
Can someone maby paste an SQL here for an item they use as a wishing stone or something ?

~Mizu~

Quote:

---

Originally Posted by Kira90

OK ... I made a gossip item ... really wanna know ? heres source :

Code:

---

class SCRIPT_DECL MasterGuildStone : 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 MasterGuildStone::GossipHello(Object* pObject, Player * Plr, bool AutoSend)

    {

        GossipMenu *Menu;

        objmgr.CreateGossipMenuForPlayer(&Menu, pObject->GetGUID(), 2593, Plr);
        Menu->AddItem(0, "Create Guild Stone", 1);
        Menu->AddItem(0, "Take me to my Guild City", 2);
       
        if(AutoSend)
            Menu->SendTo(Plr);

    }

void MasterGuildStone::GossipSelectOption(Object* pObject, Player* Plr, uint32 Id, uint32 IntId, const char * Code)

    {

        GossipMenu * Menu;

        switch(IntId)

        {
        case 1:
            {
                Plr->GetItemInterface()->SafeAddItem(90003, INVENTORY_SLOT_NOT_SET, 23);
                Plr->Gossip_Complete();
            }break;
        case 2:
            {
                if(Plr->GetItemInterface()->GetItemCount(2838) >= 1 && Plr->GetSession()->HasGMPermissions())
                {
                    Plr->EventTeleport(0, -4816.450195, -984.530029, 464.709015);
                }
                Plr->Gossip_Complete();
            }break;

        }

}

void MasterGuildStone::GossipEnd(Object * pObject, Player* Plr)

{
GossipScript::GossipEnd(pObject, Plr);
}

---

Well ... I dont think my problem lies in the script ... it compiles perfectly ... but the item doesnt show a gossip menu ... what I'd like to know is what is the Flag for a Gossip item ... coz I think thats my problem : /
Can someone maby paste an SQL here for an item they use as a wishing stone or something ?

~Mizu~

---

um am i blind? but i dont think you have your item 90003 bound to the script, its in the additem to player, but the gossipt script doesnt know that item 90003 is bound to the script

lol I just dint add that part ;) heres my complete script *SNIF* im not SUCH a noob XD - Just dint feel like adding irelavent stuff :p ...

Code:

---

#include "StdAfx.h"

#include "Setup.h"



#ifdef WIN32

#pragma warning(disable:4305)        // warning C4305: 'argument' : truncation from 'double' to 'float'

#endif



  //Start of Script

class SCRIPT_DECL MasterGuildStone : 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 MasterGuildStone::GossipHello(Object* pObject, Player * Plr, bool AutoSend)

    {

        GossipMenu *Menu;

        objmgr.CreateGossipMenuForPlayer(&Menu, pObject->GetGUID(), 2593, Plr);
            Menu->AddItem(0, "Create Guild Stone", 1);
                Menu->AddItem(0, "Take me to my Guild City", 2);
               
                if(AutoSend)
                        Menu->SendTo(Plr);

        }

void MasterGuildStone::GossipSelectOption(Object* pObject, Player* Plr, uint32 Id, uint32 IntId, const char * Code)

    {

        GossipMenu * Menu;

        switch(IntId)

        {
                case 1:
                        {
                                Plr->GetItemInterface()->SafeAddItem(90003, INVENTORY_SLOT_NOT_SET, 23);
                                Plr->Gossip_Complete();
                        }break;
                case 2:
                        {
                                if(Plr->GetItemInterface()->GetItemCount(2838) >= 1 && Plr->GetSession()->HasGMPermissions())
                                {
                                        Plr->EventTeleport(*CENSORED*);
                                }
                                Plr->Gossip_Complete();
                        }break;

                }

}

void MasterGuildStone::GossipEnd(Object * pObject, Player* Plr)

{
GossipScript::GossipEnd(pObject, Plr);
}




class SCRIPT_DECL GuildStone : 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 GuildStone::GossipHello(Object* pObject, Player * Plr, bool AutoSend)

    {

        GossipMenu *Menu;

        objmgr.CreateGossipMenuForPlayer(&Menu, pObject->GetGUID(), 2593, Plr);
            //Menu->AddItem(0, "Create Guild Stone", 1);
                Menu->AddItem(0, "Take me to my Guild City", 2);
               
                if(AutoSend)
                        Menu->SendTo(Plr);

        }

void GuildStone::GossipSelectOption(Object* pObject, Player* Plr, uint32 Id, uint32 IntId, const char * Code)

    {

        GossipMenu * Menu;

        switch(IntId)

        {
                case 1:
                        {
                                //Plr->GetItemInterface()->SafeAddItem(90003, INVENTORY_SLOT_NOT_SET, 23);
                                Plr->Gossip_Complete();
                        }break;
                case 2:
                        {
                                if(Plr->GetItemInterface()->GetItemCount(2838) >= 1 && Plr->GetSession()->HasGMPermissions())
                                {
                                        Plr->EventTeleport(*CENSORED*);
                                }
                                Plr->Gossip_Complete();
                        }break;

                }

}

void GuildStone::GossipEnd(Object * pObject, Player* Plr)

{
GossipScript::GossipEnd(pObject, Plr);
}






void SetupGossipItems(ScriptMgr * mgr)

{
GossipScript * mgs = (GossipScript*) new MasterGuildStone();
GossipScript * gs = (GossipScript*) new GuildStone();

mgr->register_item_gossip_script(90002, mgs);
mgr->register_item_gossip_script(90003, gs);
}

---

Im almost certain its my item causing the problems ... im good @ C++ but dont ask me 2 do SQL XD so could someone plz just show me their items sql plz ? I dunno what the items flags and properties should be XD

Code:

---

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ReqDisenchantSkill, unk2)
VALUES (60001,8,-1,-1,'VCN Control Panel','VCN Control Panel','VCN Control Panel','VCN Control Panel',42629,5,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,'What is it, Wish? Here is your Wishing Stone.',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,0);

---

thats a gossip item for our control panel

Thanx :) It works :) Type 8 ^^ YeY!

Np Kira,. glad it worked