Adding text to an NPC when you talk to it.[No Scripting Needed]

[Mr FlySquirrel]

Tired of players coming online to your server and automaticly asking "Hey dood whats server rates?". Say goodbye to that question and many others. This guide will show you how to add text to an NPC when you right click it.

Things you`ll need:

Computer
Database Access
Ability to restart server.

This guide will make a Server Rates NPC when you are finished it will come out as pictured below:



Now we will start. You do not have to make an NPC that will display Server rates this is just what I decided to make the guide on making.I premade the Server rates NPC but you can change/modify him/her in anyw ay you would like.Teh download link to download the Server rates NPC is located here: Filebeam - Free Fast File Hosting Execute this sql file into your world database.

Things you`ll need to know:

Npc ID is 60033

Things you can change:

NPC ID, NPC Displayid, The NPC`s Name.

What you need to do now:

1. Open Npc_gossip_textid table in your world database.Make a new Query suing the + symbol if your using Navicat for MySQL. For this guide the creatureid will be 60033 if you change the ID you will need to put the new id of your creature there instead.For textid this is the ID of the etxt that your creature will say. For this guide we will put 60033 in textid. You can choose what ever number you would like.

2. Open Npc_text table in your world database. Make a new Query using the + symbol if your using Navicat for MySQL. Now put the textid you chose in the previous step and put that in the field called "entry" if you did not change your textid then enter 60033 in the entry field. If your suing the guide to make a server rate npc I would do something like this Server Rates: then go into your Ascent-world or arcemu-world config file and find your server rates. it will look like this <Rates Health="1"

  Power1="1"
       Power2="1"
       Power3="1"
       QuestReputation="1"
       KillReputation="1"
       Honor="1"
       PvPTimer="300000"
       Compression="1"
       XP="135"
       QuestXP="60"
       RestXP="150"
       DropGrey="30"
       DropWhite="30"
       DropGreen="30"
       DropBlue="30"
       DropPurple="30"
       DropOrange="30"
       DropArtifact="30"
       DropMoney="40"
       Save="1000"
       SkillChance="1"
       SkillRate="15"
       ArenaMultiplier2x="1"
       ArenaMultiplier3x="1"
       ArenaMultiplier5x="1">

now copy that from your config file and paste it into where it says text0_0 . If your not making a server rate NPC you can put anything you want in that field. What you put in that field is what the NPC will say when you write click it.Fill in the field next to it called text0_1 with a 0. scroll over until you find text1_0 and text1_1 fill thosein with 0 also.
Do this step until every field thats ays text soemthing has a 0 besides the field you filled in with text (text0_0) After you do that you are done!

Exit out save your server by typing .saveall and restart your realm. Login spawn your creature using the id you chose or the id i gave for this guide which is 60033 and test out your creature. Hopefully this hasnt been posted before i searched but it wasnt that i could see. Have fun! Post a comment or PM me if you need help.

[Lightorius]

Hi there, nice work on this..

One slight thing..

It pays to add a semi-colon at the end of each sql statement - that way the sql compiler is able to distinguish between the end of one SQL operation and the beginning of the next

[Mr FlySquirrel]

o kk thanx man. =]

[kreegoth]

Nice guide here useful for explaining what is customized on your server to new players as well..+rep

[phantom5992]

So they acually say that stuff, and you can make it say whatever you want?

[fantom727]

Nice one .. Works!

[Mr FlySquirrel]

thanx =] i figured id post it cus it seamed pretty cool