[Solved] - Should not be used anymore | I don't understand how to....?

Go down

[Solved] - Should not be used anymore | I don't understand how to....?

Post by cristian0s on Sun Oct 10, 2010 3:46 am

Hello , i'm very noob at DB edit ...
I don't know how to edit it. I want to put all Alliance cities in "Alliance Cities" and all Horde Cities in "Horde Cities"...
and if you can tell me how i put a teleport "Alliance Mall"/"Horde Mall"....

cristian0s

Viestien lukumäärä : 3
Join date : 2010-10-10

Back to top Go down

Re: [Solved] - Should not be used anymore | I don't understand how to....?

Post by Rochet2 on Sun Oct 10, 2010 5:52 am

First of all I should know what core you are using.

Also I need to know do you want the "Alliance Cities" and "Horde Cities" and/or "Alliance Mall"/"Horde Mall" show up for both factions?
avatar
Rochet2
Admin

Viestien lukumäärä : 196
Join date : 2010-02-04

http://emuproject.bbflash.net

Back to top Go down

Re: [Solved] - Should not be used anymore | I don't understand how to....?

Post by Rochet2 on Sun Oct 10, 2010 6:31 am

This should do it all
But this is only for MaNGOS.

Note that you MUST read the comments before trying to add this to the database.

Else you will get an error.

http://pastebin.com/raw.php?i=XguPM54P



* note that the buttons may get slightly .. off
This happens since there is nothing that will order the buttons and is unavoidable.
avatar
Rochet2
Admin

Viestien lukumäärä : 196
Join date : 2010-02-04

http://emuproject.bbflash.net

Back to top Go down

Re: [Solved] - Should not be used anymore | I don't understand how to....?

Post by cristian0s on Sun Oct 10, 2010 7:50 pm

thank you for your answer , i use Trinity Core ...
i want ally to see only ally cities , and horde only horde ...
but i want other teleports too ...
i make a SS to see what plan i have because my english is bad Sad...

cristian0s

Viestien lukumäärä : 3
Join date : 2010-10-10

Back to top Go down

Re: [Solved] - Should not be used anymore | I don't understand how to....?

Post by Rochet2 on Mon Oct 11, 2010 4:37 am

This should be good enough:
This is only for Trinity.

Note that you MUST read the comments before trying to add this to the database.

Else you will get an error.

http://pastebin.com/raw.php?i=60m8vsq9


Pics:

avatar
Rochet2
Admin

Viestien lukumäärä : 196
Join date : 2010-02-04

http://emuproject.bbflash.net

Back to top Go down

Re: [Solved] - Should not be used anymore | I don't understand how to....?

Post by cristian0s on Mon Oct 11, 2010 5:06 am

Thank you :X:X This works great now Very Happy

cristian0s

Viestien lukumäärä : 3
Join date : 2010-10-10

Back to top Go down

tele npc dont tele

Post by dark on Mon Jan 03, 2011 1:27 pm

hi im using trinity core i downloaded your tele npc put it in game but it dont teleport you to anywhere...plz help thnx Sad

dark
Guest


Back to top Go down

Re: [Solved] - Should not be used anymore | I don't understand how to....?

Post by Rochet2 on Mon Jan 03, 2011 11:45 pm

When downloading, did you select that you want options and scripts?
Can you show me what you executed to your database?

Do you know if the sql ran succesfully or with errors?
avatar
Rochet2
Admin

Viestien lukumäärä : 196
Join date : 2010-02-04

http://emuproject.bbflash.net

Back to top Go down

tele npc dont tele

Post by dark on Tue Jan 04, 2011 1:04 am

sql installed fine no errors this what installed:
ALTER TABLE gameobject AUTO_INCREMENT=200000;
 INSERT INTO gameobject (id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation2, rotation3, spawntimesecs, state) VALUES (@RUNE, 1, 1, 1, 1601.08, -4378.69, 9.9846, 2.14362, 0.878068, 0.478536, 25, 1), (@RUNE, 0, 1, 1, -14281.9, 552.564, 8.90382, 0.860144, 0.416936, 0.908936, 25, 1), (@RUNE, 0, 1, 1, -8842.09, 626.358, 94.0868, 3.61363, 0.972276, -0.233836, 25, 1), (@RUNE, 0, 1, 1, -4900.47, -962.585, 501.455, 5.40538, 0.424947, -0.905218, 25, 1), (@RUNE, 1, 1, 1, 9869.91, 2493.58, 1315.88, 5.9462, 0.167696, -0.985839, 25, 1), (@RUNE, 530, 1, 1, -3864.92, -11643.7, -137.644, 2.38273, 0.928875, 0.370392, 25, 1), (@RUNE, 530, 1, 1, -1887.62, 5359.09, -12.4279, 4.40435, 0.758205, 0.652017, 25, 1), (@RUNE, 571, 1, 1, 5809.55, 503.975, 657.526, 5.54461, 0.360952, -0.932584, 25, 1), (@RUNE, 530, 1, 1, 9738.28, -7454.19, 13.5605, 3.14231, 1, -0.000358625, 25, 1), (@RUNE, 0, 1, 1, 1633.75, 240.167, -43.1034, 3.13147, 0.999987, 0.00506132, 25, 1), (@RUNE, 0, 1, 1, -13181.8, 339.356, 42.9805, 1.18013, 0.556415, 0.830904, 25, 1), (@RUNE, 1, 1, 1, -1274.45, 71.8601, 128.159, 2.80623, 0.985974, 0.166898, 25, 1);
 /* Portal Master By Rochet2 Downloaded from Bugs and contact with E-mail: Rochet2@post.com */ ;
/* 106,931 rows affected, 0 rows found. Duration for 23 queries: 4.015 sec. */

dark
Guest


Back to top Go down

tele npc dont tele

Post by dark on Tue Jan 04, 2011 1:24 am

im probley missing something im sorry im still new to this :s

dark
Guest


Back to top Go down

Re: [Solved] - Should not be used anymore | I don't understand how to....?

Post by Rochet2 on Tue Jan 04, 2011 3:42 am

That code you posted above would only add in the rune circles (pink circles)

You need to run a code that looks like this:
(this is the default code)
http://pastebin.com/raw.php?i=F3Eg7NDy
avatar
Rochet2
Admin

Viestien lukumäärä : 196
Join date : 2010-02-04

http://emuproject.bbflash.net

Back to top Go down

tele npc dont tele

Post by dark on Wed Jan 05, 2011 3:17 am

ahh thank you, works now ^_^ good job btw Laughing

dark
Guest


Back to top Go down

Re: [Solved] - Should not be used anymore | I don't understand how to....?

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum