HElP - Sql/Lua Portal | Error

[dongel]

Hey there guys , i found many many guides , about custom portal by Sql & Lua .
--
I did few , but all they WONT WORK .
The portal is spawnable , but when i click on him , it write - World recall port (old)
Load, and nothing ......
--
Here is the SQL and LUA that i used :
INSERT INTO gameobject_names (entry, Type, DisplayID, Name, spellfocus) VALUES (1231231, 22, 1327, 'Gurubashi-Arena', 0)
________________
LUA :
function Teleport_onUse500 (pUnit, Event, pMisc)
pMisc:Teleport (0, -13265.500000, 155.837997, 35.63001)
end
RegisterGameObjectEvent (1231231, 2, 'Teleport_onUse500')
__________
PS :
function Teleport_onUse500 <- is 500 for first time .
I hope some1 of you is gonna help me.. Ill +rep ofc :P
Tnx guys , im waiting your opinion .
Regards
Dongel
:wave:

[Yamajee]

If you need for main cities, here are some .gobjects

All you have to do is .gobject add

Undercity - 183327
Thunder bluff - 183326
Orgrimmar - 183323
Ironforge - 183322
Darnassus - 183317
Stormwind - 183325

+rep me if helped

[dongel]

I dont need main cityes , its custom GUrubashi Arena Portal :< I have more ids for normal citys. Tnx anyway , im waiting another helper :<

[Reflection]

Hey there guys , i found many many guides , about custom portal by Sql & Lua .
--
I did few , but all they WONT WORK .
The portal is spawnable , but when i click on him , it write - World recall port (old)
Load, and nothing ......
--
Here is the SQL and LUA that i used :
INSERT INTO gameobject_names (entry, Type, DisplayID, Name, spellfocus) VALUES (1231231, 22, 1327, 'Gurubashi-Arena', 0)
________________
LUA :
function Teleport_onUse500 (pUnit, Event, pMisc)
pMisc:Teleport (0, -13265.500000, 155.837997, 35.63001)
end
RegisterGameObjectEvent (1231231, 2, 'Teleport_onUse500')
__________
PS :
function Teleport_onUse500 <- is 500 for first time .
I hope some1 of you is gonna help me.. Ill +rep ofc :P
Tnx guys , im waiting your opinion .
Regards
Dongel
:wave:

Try change 'Teleport_onUse500'
to "Teleport_onUse500"

And to Yamajee, never, ever, ask for rep.

[dongel]

Reflection , i did it but nothing changed.. its same :<
More ideas? :-s

[yrref]

Yes, use Sipex's Portal Creator =3 Does the trick everytime for me

[kreegoth]

This seems like ALOT of work to me for what your doing...

INSERT INTO gameobject_names (entry, Type, DisplayID, Name, spellfocus) VALUES (1231231, 22, 1327, 'Gurubashi-Arena', 0)
________________
LUA :
function Teleport_onUse500 (pUnit, Event, pMisc)
pMisc:Teleport (0, -13265.500000, 155.837997, 35.63001)
end
RegisterGameObjectEvent (1231231, 2, 'Teleport_onUse500')


When i make a custom portal i simply go into the Teleport_Coords table in database..

Using .GPS in game i get the loc of the place i wish to Teleport to..

FIND the Teleport to a area using a Portal IE portal to "XXXXXX" move down to the right til you get to the XYZ area and imput the GPS you got ingame..

Now go ingame and spawn that GO that you changed the portal for..

IE if you change the portal for G arena.. Go to Orgrimmar click the portal thats there type .go sel and then .go info. It gives you the spawn ID. Then go where you want the portal and type .GO spawn "XXXXXX"

[dongel]

Tnx
Im gonna try , + rep for your work .