Make your own custom Sign

[Warriar]

Just a simple guide, I'll give y'all a template, Be careful if you change the display ID, I think youll need to change the type too!

INSERT INTO `gameobject_names`(`entry`, `Type`, `DisplayID`, `Name`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`) VALUES
('EntryID!', '2', '717', 'What you want your sign to say!', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

Edit Blue - For Entry ID
Edit Red - For What you want the sign to say and just execute into world table and your done!

Very Simple to do and very easy.

Yeah Arc-Emu

[The-Eradicator]

I'd assume ArcCrap, but please state what emulator this is for.

[Glorianglorre]

Great guide man.

[alj03]

Pretty easy. Good work.

[Hanpuch]

good work!

[shadowknight513]

Thanks, been lookin' real hard for this. Now my players can easily check the prices of a certain token they need. (The price changes when they don't vote enough, or there has been behavioral issues etc etc...)

[Toffster]

Sounds good Shadowknight513,

Nice guide mate. I've wanted to know how to do this for my server's in the past. Unfortunately it's to late for me now, as I have given up on making my own servers. One popular one was enough for me. Anyhow, +Rep for a nice guide.

Perhaps you could add a section telling the reader how to execute the sql into their world db?

[shadowknight513]

Way ahead of you, publishing a video of how to execute it right now.


There yah go!

+rep if you like my video please! )

[shadowknight513]

No one likes my video?

[Link_S]

No one likes my video?

You steal rep from his thread, no I don't like your video, I don't like you either >.>

[Toffster]

Link_S I wouldn't say that was stealing rep... he was simply being helpful, Warriar should learn to post in his own thread more than the original time. The fact that Shadow went out and wasted his own time to get a video and improve this thread. I think it was the right thing to do and why don't you like him Link_S, what's he done to you?

Please don't ask for rep though Shadow Knight, i'l let you off this once

[shadowknight513]

Alright cool, thanks for the heads up. And thanks for defending my video, I did go out of my way to post it, but hey, I'm no longer a lazy leecher!

And Ling_S, why don't you like me I haven't done anything to you, this is the first post of yours I've ever seen.

[demonise123]

How do you make this work on a Trinity Core? I'm getting this error: [Err] 1146 - Table 'world.gameobject_names' doesn't exist

+ Rep to whoever can help me on this one, Thanks in advance!

[Zazi529]

Easy but good job.