Custom Titles / Solid Objects / item Packs

[Gastricpenguin]

Gastricpenguin's 3 in 1 Guide!

How to give players a custom title!

:Step 1:
Open up your DB editing tool. (Navicat, SqlYog, HeidiSQL)
Locate and open the 'characters' Table

:Step 2:
Double click in the 'name' field and change it to whatever your heart desires.

NOTE! The name can only be 21 characters long!

:Step 3:
Restart Your server and Log in!

Samples:
My Favorite: http://img488.imageshack.us/img488/2...rtitle1eg3.png
Sample 2: http://i121.photobucket.com/albums/o.../hobagname.png

Making a Solid Game Object

:Step 1:
Open your DB editing tool. (Stated Above) and connect to your database.
Browse around for a gameobject that you want to create that is solid, and does not have a highlight effect. This can also be applied to objects that have one in place. (lets say a campfire)

:Step 2:
Once you have found your object, I will be using a campfire, look for its DisplayID.
Now decide whether or not you want to create a new object, or just change the one already in the database.

:Step 2.1:
Regardless, once you have gotten your DisplayID (mine is 192), you can now create a new row, or edit the fields i am about to tell you.

So i assume you want to create a new object all together, so enter in a new row in your Gameobject_Names table.
For entryid, choose a number that is not in use.
For type, you can either put in 14 - 15 - or 5.
For DisplayID, put in the one you found while browsing, (mine is 192)
For name, put in any god damn thing you want :P
Everything else can be left at 0

:Step 3:
Restart your server and log in. Then spawn your object by using the command .go sp <ID>

Results: (Obviously no highlight effects)

Creating Item Packs! (Items in a bag)

:Step 1: Creating your bag.
Connect to your DB and open the `items` table.
Make a new row and create an item with the following details:
Entry = Anything
Class = 15
Subclass = 0
Field4 = -1
Name = Anything you want
DisplayID = Anything really, i will use the lockbox ID of 9632
Flags = 4
InventoryType = 0
Allowable Race + Class = -1
Maxcount = 1
Lock_ID = 0
Lock_material = 1
Any field i DID NOT mention, can be left at 0 or your will. But REMEMBER your Entry ID!

:Step 2: The contents of the Bag
Open up the table `itemloot`
Create a new row with the following information:
index: Any number that has not been used
entryid: Your bag id (The one that you made above)
Itemid: The id of the item you want in the bag
percentchance: The % chance that your item will appear. I like to use 100

:Step 3: Restarting the server
Restart your server and spawn your new bag!

Results:
http://img530.imageshack.us/img530/5...xoftoysbw7.png


All credits go to GASTRICPENGUIN. If this guide is posted anywhere else but mmowned. Expect to be in some serious shit.

[Demonkunga]

Top notch quality stuff Gastric. Thank you.

[Sahdrani]

Top notch, to quote DK. Well done.

Sahdrani

[zumzar]

I have a problem with the name change
1. I cant make my name long like: <High Lord> Admin
2. How do i make the <High Lord> stand above Admin?


Zumzar

[Dragut]

Omg! +rep!

[EcHoEs]

Way too nice Gastric
+rep

[Chris-h11]

Really great guide, thanks for this.

[Banksey]

Was looking forward to this when you said you were gonna make it in another thread, Lived right up to my expectations and more have 2 rep

[ironman2173]

Thanks Alot! Another Great Guide By Gastric!!! +REP

[Gastricpenguin]

Shameless Bump!

[crwilborn]

does this same idea work with items like such things as items sets like the T6 raid sets and like change the name a bit and stats on it while keeping the item set bonuses and making them legendary item as well with my signature at the bottom like these guys did here in the piture?

[crwilborn]

oh noes i just posted a question here and not suypose my appologies

[Mesmoras]

The custom name isn't working for me. Whenever I change it in the name cell, it won't stay to what I changed it to. It's like I never made the attempt... Any idea what I'm doing wrong? By the way, before I change it, the name in the cell is Renji. So I double click on the cell, and delete the Renji part to turn it into Admin Renji Abarai. If that helps any.

[Snowflake]

That happen's to me as well, im using SQLYog

[Gastricpenguin]

Did you save after making the changes?