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

[ZeAphexTwin]

1 question it creates an npc teleport? or it just adds new teleport to an npc teleport near it?

you can change the name in textdata_object media pk2. and be sure the numbers are the same from db and media

 

[serend]

'_Refobjcommon' table
- Unable to create index 'PK__Refobjcommon_1'.  
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._Refobjcommon' and the index name 'PK__Refobjcommon_1'. The duplicate key value is (33805).
Could not create constraint. See previous errors.
The statement has been terminated.

any fix for this >?

 

[boraq0000]

my client is crash after teleport
and before i see teleport building i crashed

 

[mody2644]

I CAN NOT UNDERSTAND ANY THING FROM THIS Query

 

[InsaneDev]

'_Refobjcommon' table
- Unable to create index 'PK__Refobjcommon_1'.  
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._Refobjcommon' and the index name 'PK__Refobjcommon_1'. The duplicate key value is (33805).
Could not create constraint. See previous errors.
The statement has been terminated.

any fix for this >?

try This
1:Set primary key for "ID" in _RefTeleport and it shall work

 

[adminsxza]

Error i need help plesss

'_RefObjCommon' table
- Unable to create index 'PK__RefObjCommon_1'.
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._RefObjCommon' and the index name 'PK__RefObjCommon_1'. The duplicate key value is (41845).
Could not create constraint. See previous errors.
The statement has been terminated.

 

[arabianfox]

go to your _Refobjcommon table and search ID 41845 you will find 2 records with this ID ,you must remove one of them or change ID for one of them to be able to set identity on for this table.

 

[johnfaiz]

when i import text files i get crash i think cause it have spaces or something could u give me php codes of txt media and thx

 

[adminsxza]

you have Query for change it ?

 

[GiannyRockZ]

Awesome work !
Tested and working ! Thanks a Lot I have been searching for this ^^

 

[VanSoR]

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

 

[InsaneDev]

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

 

[VanSoR]

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

 

[Hex1337]

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".

 

[Luukn]

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

 

[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.

 

[Jason1990]

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*

 

[dimkasuperf]

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

 

[MrJKerl]

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

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!

 

[dimkasuperf]

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

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