Jump to content

[GUILDSTORAGE] Help


Recommended Posts

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Hello :)

First of all remove your personal skype ID from this topic or you're gonna have a problem if a Moderator sees it. Second, do NOT follow the guid on epvp, it's a fake and really buggy system that doesn't even work, has missing parts and lack of source code parts. For example, this is normal game storage function from db/src/ClientManager.cpp

Spoiler

char szQuery[512];
        snprintf(szQuery, sizeof(szQuery), 
                "SELECT id, window+0, pos, count, vnum, socket0, socket1, socket2, "
                "attrtype0, attrvalue0, "
                "attrtype1, attrvalue1, "
                "attrtype2, attrvalue2, "
                "attrtype3, attrvalue3, "
                "attrtype4, attrvalue4, "
                "attrtype5, attrvalue5, "
                "attrtype6, attrvalue6 "
                "FROM item%s WHERE owner_id=%d AND window='%s'",
                GetTablePostfix(), pi->account_id, pi->ip[0] == 0 ? "SAFEBOX" : "MALL");

What this function does is selecting a specific item stored inside the safebox (storage) where owner_id is the id of the account's player. This is a MySQL query and it's in the source part. Without these functions, the system can't remember any item stored in the safebox. Now, I'm not a professional programmer but I don't think epvp's guild storage will work, not without source part, which it hasn't

Your best chance is to wait for a release or a good programmer to develop this as a system and start selling it.

Hope I helped :)

Kind regards ~ Mind Rapist

Link to comment
Share on other sites

Spoiler

            char szItemQuery[512];
            snprintf(szItemQuery, sizeof(szItemQuery), "SELECT id, pos, count, vnum, is_gm_owner%s, socket0, socket1, socket2, "
                "attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, "
                "attrtype5, attrvalue5, attrtype6, attrvalue6 FROM item WHERE window = %u AND owner_id = %u",
                szQueryExtra, GUILD_SAFEBOX, dwGuildID);

That's with the GuildID not to create a whole new table the creator used the player.item table.

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.