VIP accounts

[Le Froid]

All credit goes to Mesmer of ascentemu for this


Execute this .sql to your account table

alter table accounts add column `vip` INTEGER(11) not null default 0;

If the vip column is 0 they get nothing if 1 they get the item.

Then compile this

/***********************************************************
VIP account Addon
--- Basic Addon Add-er
by: Mesmer
License: Attribution-NonCommercial-ShareAlike 3.0 United States
- Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States
Script Version: 0.0.1
****************************************************/
#include "Setup.h"
#include "StdAfx.h"

#define VIP_ITEM_ID 10000 // change this item accordingly for the item that needs to be added

void VIPCheck (Player *plr)
{
    static unsigned acct = NULL;
    static unsigned vip = NULL;
    static QueryResult *getVip = NULL;
    static QueryResult *getAcct = NULL;
    getAcct = CharacterDatabase.Query("SELECT `acct` FROM `characters` WHERE `guid` = '%i'", plr->GetGUIDLow());
    acct = getAcct->Fetch()[0].GetUInt32();
    getVip = CharacterDatabase.Query("SELECT `vip` FROM `accounts` WHERE `acct` = '%i'", acct);
    vip = getVip->Fetch()[0].GetUInt32();
    if (vip == 1){
        Item *item;
        item = objmgr.CreateItem( VIP_ITEM_ID, plr);
        if(!plr->GetItemInterface()->AddItemToFreeSlot(item)){delete item;}
    }
}

extern "C" SCRIPT_DECL void _exp_script_register(ScriptMgr* mgr)
{
    mgr->register_hook(SERVER_HOOK_EVENT_ON_CHARACTER_CREATE, &VIPCheck);
}

OR download it from http://www.wowdelight.com/filehost/VIP.rar ( from ritualist)

the item ID they get is 10000

Place it in the script_bin

When the VIP player logs in they will recieve an extra item in their inventory

[L'Lawliet]

what is the item?

[Le Froid]

what is the item?

Anything you want it to be. The ID is 10000

[L'Lawliet]

cool ty +rep..... hey you klnow any way to fix a scratched halo 3 disk?

[EcHoEs]

Just a idea : You can also add more items, by entering another

#define VIP_ITEM_ID #number

[Cursed]

Just change the id in the text you want to compile to your item ID ( its the #define VIP_ITEM_ID 10000 // change this item accordingly for the item that needs to be added thing)

[Le Froid]

cool ty +rep..... hey you know any way to fix a scratched halo 3 disk?

disc cleaner?

[L'Lawliet]

you sure those work? it was made by the machine and its a circle

[Le Froid]

you sure those work? it was made by the machine and its a circle

I've used one on a foo fighters CD and it worked.
Never tried on a game but same thing.

Depends on how scratched it is.

[EcHoEs]

Omgz get back on topic.
Back on topic! :
Ummh.. I didn't download this.

[Le Froid]

Omgz get back on topic.
Back on topic! :
Ummh.. I didn't download this.

lol
(filler)