[SQL] Query to add a new custom Teleport with options very easy and very fast

How i can make Teleport From Jangan To B3 Teleport Not A new Teleport

check refteleport and get the code of which room and get a line of JG to any place then edit the number

Thx But I Set A Teleport From Jangan To B3 But The New Teleport Haven't A Teleport to Jangan Why?

i got this error

Msg 137, Level 15, State 2, Line 35
Must declare the scalar variable "@link".
Msg 137, Level 15, State 2, Line 40
Must declare the scalar variable "@link".

hmm

everytime when i teleport the the selected area, i get a client crash.
Ichecked it many times, i included the media strings completely and correct with correct spaces(tabulators).

The sql query is working very nice but the crash when iam in the teleported area is terrible.

I used two different characters names: teleport1 and teleport2
I used two different places where they stay (around 3-5 meters away from each other)

anyone is able to say me why this isnt working ?

Greetz

I'm sorry, but I get this :

Msg 544, Level 16, State 1, Line 60
Cannot insert explicit value for identity column in table '_RefTeleport' when IDENTITY_INSERT is set to OFF.

Quote:

---

Originally Posted by dimkasuperf

I'm sorry, but I get this :

Msg 544, Level 16, State 1, Line 60
Cannot insert explicit value for identity column in table '_RefTeleport' when IDENTITY_INSERT is set to OFF.

---

Right click on "_RefTeleport" -> "Design".
Click on "ID", under you can find "Column Proterties".
Scroll down till you find "Identity Specification", click on the >Plus<.
Now click on "(Is Identity)"-> *switch* NO -> YES.

If it don't work now too, you must do first click on "Tools"->"Options"
Then click on "Designers" and take away the arrow on "Prevent saving changes that require table re-creation"

Good luck (Click thank you if i could help you*

Already did that.
Identity keeps automatically switching to off, I don't know even why.

Quote:

---

Originally Posted by dimkasuperf

I'm sorry, but I get this :

Msg 544, Level 16, State 1, Line 60
Cannot insert explicit value for identity column in table '_RefTeleport' when IDENTITY_INSERT is set to OFF.

---

You can add this line before inserting to '_RefTeleport' table

Code:

---

SET IDENTITY_INSERT _RefTeleport ON

---

And set it OFF when you done.

Could anybody tell me how to know the ID of Ownerteleport and Targetteleport?

Forexample, which table shows that the ID for Jangan is 1 and Constantinople is 20?

Thanks!

MrJKerl, that's what I get after executing your line :

Quote:

---

Msg 8106, Level 16, State 1, Line 1
Table '_RefTeleport' does not have the identity property. Cannot perform SET operation.

---

Quote:

---

Originally Posted by dimkasuperf

MrJKerl, that's what I get after executing your line :

Quote:

---

Msg 8106, Level 16, State 1, Line 1
Table '_RefTeleport' does not have the identity property. Cannot perform SET operation.

---

---

It seems that the IDENTITY property was removed on the ID column.
My previous line is just applied when you want to insert new row(s) on the table that has a column with IDENTITY property.
So please check your table design again.

thnx alot working fine

I Got Crash When I Start The Char In The Area
We Didn't Add Any lines In Characterdataxxxx
i think we have to

Quote:

---

Originally Posted by thebigbody

I Got Crash When I Start The Char In The Area
We Didn't Add Any lines In Characterdataxxxx
i think we have to

---

u RocStorM?
anyway see in DMP file for loading failed

Msg 515, Level 16, State 2, Line 34
Cannot insert the value NULL into column 'RegionID', table 'SRO_VT_SHARD.dbo._RefObjCommon'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Quote:

---

Originally Posted by InsaneDev

u RocStorM?
anyway see in DMP file for loading failed

---

This Fixed But The Teleport Became between the place i want and JG not the two places i made :S

Msg 137, Level 15, State 2, Line 35
Must declare the scalar variable "@link".
Msg 137, Level 15, State 2, Line 40
Must declare the scalar variable "@link".

soo its error, if i run client, and be near new teleport get crash...

Add all to Media.pk2
No error in querty
...

Since it's using the char location; does that means that everytime when I move that char to a different location; the teleport will move along with it too?

Msg 544, Level 16, State 1, Line 60
Cannot insert explicit value for identity column in table '_RefTeleport' when IDENTITY_INSERT is set to OFF.

worked good
but when teleport from jangan to teleport place
take crash

Quote:

---

Originally Posted by LeMbo

Msg 544, Level 16, State 1, Line 60
Cannot insert explicit value for identity column in table '_RefTeleport' when IDENTITY_INSERT is set to OFF.

worked good
but when teleport from jangan to teleport place
take crash

---

the code you get inside Refobjcommon Add it to characterdata45000 and you should no longer get any crash ;)

Quote:

---

Originally Posted by aqua2to

soo its error, if i run client, and be near new teleport get crash...

Add all to Media.pk2
No error in querty
...

---

Any solution to this problem? i got the same.

awesome

I added it in. stand succefull i added links to media but when i press start client close instantly. why ? :P

works fine!

i have an entry in jangan teleporter when i teleport to the area it works fine. but if i go to the teleporter in the new area der is an blank page. how to set an back teleportlink to jangan?