[Realese] Teleporting Items [Made by Illidan1]

[diogolinheiro]

wow thanks i really needed this

[mEtzG3r]

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `teleport_coords` SET `mapId`=0,`x`=-8913.23,`y`=554.633,`z`=93.7944,`tot' at line 2 [This is not working ...]

And the "del UPDATE" from the sql file in the 2nd row or anywhere not working !!!!

Im installed the heidi sql, but anyway dont working ...

Use the edit button. -Errage

[Gastricpenguin]

Lol i would fix all this, but im on a shit-tastic labtop.
:<

[mEtzG3r]

So anybody or illidan1 can tell me whats the problem? hm?

[Illidan1]

You can go into database and just copy it all in the database your self
Or maybe my sql format is to custom

[Gastricpenguin]

Yea illidan, you're using a sql function that pretty much all other server managers DONT use.
You include the ''s around the fields (example: 'accounts') and then nothing on the numbers (ex: 'accounts'=1)
When most Managers dont accept that.
It should look like this:

INSERT INTO `accounts` VALUES ('1', '2', '3', '4');

and

UPDATE FROM `accounts` SET (`gm` = 'az') WHERE (`entry` = '112233');

Notice the difference between ` and '

[Illidan1]

ahh i see i will fix when im home

[mEtzG3r]

UPDATE FROM `teleport_coords` SET (`mapId`='530',`x`='-1863.03',`y`='4998.05',`z`='-21.1847') WHERE (`id`='12510');

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `teleport_coords` SET (`mapId`='530',`x`='-1863.03',`y`='4998.05',`z`='-21.' at line 1
[Msg] Finished - Unsuccessfully But where is the problem? Im using mysql 5...

[fireguild1]

I Want a Item Like This Do Some One Know How To Creat It?

That's pretty cool. If you want your firends to come to you it should send them a message like when you mass summon people, like "<Name> wants to summon you to <Location>"

Accept Cancel

But yea thats an awesome thing there.

[Illidan1]

I know you guys are going to get an Error i will fix when i get home
At school 1 hour and a half till im home

[mEtzG3r]

Ok,sry, but i have a new emu and database, and a server what is full of bugs, and i want to change the emu and the db to another whith this items, because the db has no portals to the main cities..., and i don't want to script all of the portals So im waiting for you

[Illidan1]

Ok guys, i have now Fixed them They will work for your Database

[mEtzG3r]

And can you upload somewhere or write down here? pls

[Succy]

Cool +Rep!...When I can...

[mEtzG3r]

Oh my god :O This is really works :O Im lovin it, oh man are you god? Thx Illidan1