Page 1 of 1

Can't execute my sql File for Luxury teleports

Posted: Fri Sep 17, 2010 8:33 pm
by ADONES
L2J Revision Number: 4413
L2JDP Revision Number: 7664

Hallo Guys,

like i said in the topic... I cant execute my sql file for teleports of my Luxury Gk.
Maybe someone know whats wrong.

Thank u in advanced

Code: Select all

INSERT INTO `teleport` VALUES ('Dark Elven Town -> Town of Gludio', 1, -12672, 122776, -3116, 10000, 0);INSERT INTO `teleport` VALUES ('Elven Town  -> Town of Gludio', 2, -12672, 122776, -3116, 9200, 0);INSERT INTO `teleport` VALUES ('Town of Gludio -> Elven village', 3, 46934, 51467, -2977, 9200, 0);INSERT INTO `teleport` VALUES ('Town of Gludio -> Dark Elven village', 4, 9745, 15606, -4574, 10000, 0);INSERT INTO `teleport` VALUES ('Town of Gludio -> Village of Gludin', 5, -80826, 149775, -3043, 7300, 0);INSERT INTO `teleport` VALUES ('Town of Gludio -> Dion', 6, 15670, 142983, -2705, 3400, 0);INSERT INTO `teleport` VALUES ('Village of Gludin -> Orc village', 7, -44836, -112524, -235, 26000, 0);INSERT INTO `teleport` VALUES ('Village of Gludin -> Dwarven village', 8, 115113, -178212, -901, 38000, 0);INSERT INTO `teleport` VALUES ('Village of Gludin -> TI', 9, -84318, 244579, -3730, 9400, 0);INSERT INTO `teleport` VALUES ('Village of Gludin -> Elven Village', 10, 46934, 51467, -2977, 16000, 0);INSERT INTO `teleport` VALUES ('Village of Gludin -> Dark Elven Village', 11, 9745, 15606, -4574, 16000, 0);INSERT INTO `teleport` VALUES ('Village of Gludin -> Town of Gludio', 12, -12672, 122776, -3116, 7300, 0);INSERT INTO `teleport` VALUES ('Village of Gludin -> Southern entrance of wastelands', 13, -16730, 209417, -3664, 3400, 0);INSERT INTO `teleport` VALUES ('Dark Elven Town -> Southern part of dark elven forest', 14, -61095, 75104, -3356, 1100, 0);INSERT INTO `teleport` VALUES ('TI -> Village of Gludin', 15, -80826, 149775, -3043, 18000, 0);INSERT INTO `teleport` VALUES ('Dwarf Town  -> Town of Gludio', 16, -12672, 122776, -3116, 32000, 0);INSERT INTO `teleport` VALUES ('Dwarf Town -> The Northeast Coast', 17, 169008, -208272, -3504, 2400, 0);INSERT INTO `teleport` VALUES ('Dion Town -> Town of Gludio', 18, -12672, 122776, -3116, 3400, 0);INSERT INTO `teleport` VALUES ('Dion Town -> Town of Giran', 19, 83400, 147943, -3404, 6800, 0);INSERT INTO `teleport` VALUES ('Dion Town -> Giran Harbor', 20, 47942, 186764, -3485, 6500, 0);INSERT INTO `teleport` VALUES ('Cruma Tower 1st floor -> Cruma Tower Entrance', 22, 17192, 114178, -3439, 0, 0);INSERT INTO `teleport` VALUES ('Cruma Tower 1st floor -> Cruma Tower 2nd floor', 23, 17776, 108288, -9056, 0, 0);INSERT INTO `teleport` VALUES ('Cruma Tower 2nd floor -> Cruma Tower 1st floor', 24, 17781, 113999, -11672, 0, 0);INSERT INTO `teleport` VALUES ('Town of Giran -> Dion Town', 25, 15670, 142983, -2705, 6800, 0);INSERT INTO `teleport` VALUES ('Town of Giran -> Oren Town', 26, 82956, 53162, -1495, 9400, 0);INSERT INTO `teleport` VALUES ('Town of Giran -> Hunter Village', 27, 116819, 76994, -2714, 4100, 0);INSERT INTO `teleport` VALUES ('Town of Giran -> Hardin\'s Private Academy', 28, 105918, 109759, -3207, 4400, 0);INSERT INTO `teleport` VALUES ('TI Dungeon inside -> outside', 29, -113329, 235327, -3653, 0, 0);INSERT INTO `teleport` VALUES ('TI Dungeon outside -> inside', 30, 48736, 248463, -6162, 0, 0);INSERT INTO `teleport` VALUES ('Ivory Tower Basement', 31, 84915, 15969, -4294, 0, 0);INSERT INTO `teleport` VALUES ('Ivory Tower Ground Floor', 32, 85399, 16197, -3679, 0, 0); 
thats only a part of the sql file because its to long to post it here

Re: Can't execute my sql File for Luxury teleports

Posted: Fri Sep 17, 2010 9:49 pm
by Probe
maybe, but just maybe, you should post the sql error

Re: Can't execute my sql File for Luxury teleports

Posted: Fri Sep 17, 2010 9:58 pm
by burrito
Your missing the new column that was added for item id

Re: Can't execute my sql File for Luxury teleports

Posted: Fri Sep 17, 2010 10:34 pm
by hope
You should put into custom teleport table

Re: Can't execute my sql File for Luxury teleports

Posted: Sat Sep 18, 2010 2:09 am
by ADONES
i already try'd to add it to the custom_teleport list.. dont work too....

that the error i get if i try to execute it..

Code: Select all

[Err] 1136 - Column count doesn't match value count at row 1[Err] INSERT INTO `teleport` VALUES ('Dark Elven Town -> Town of Gludio', 1, -12672, 122776, -3116, 10000, 0);[Msg] Finished - Unsuccessfully
thank u in advance

Re: Can't execute my sql File for Luxury teleports

Posted: Sat Sep 18, 2010 6:13 am
by hope
That is because you already have a I'd with the same number as what you are trying to add
Change each id to the next available one

Re: Can't execute my sql File for Luxury teleports

Posted: Sat Sep 18, 2010 6:52 am
by _DS_
LOL. burruto wins the prize. Others possibly unable to read english ?

Re: Can't execute my sql File for Luxury teleports

Posted: Sat Sep 18, 2010 8:09 am
by jurchiks
insert statement for every row? it was mentioned a day or two ago in this forum that it's bad practice...

Re: Can't execute my sql File for Luxury teleports

Posted: Sat Sep 18, 2010 1:35 pm
by ADONES
mm... yes ok i thought so too about the ids but i already tryed to delete all positions in the teleport table and then to execute the file but dont work too.. same error..

and yes my english isnt that good.

thank u in advance

Re: Can't execute my sql File for Luxury teleports

Posted: Sat Sep 18, 2010 11:43 pm
by hope
here is fix for you

Re: Can't execute my sql File for Luxury teleports

Posted: Sat Sep 18, 2010 11:45 pm
by hope
you had alot of mistakes all fixed now just execute batch file

Re: Can't execute my sql File for Luxury teleports

Posted: Sun Sep 19, 2010 4:50 am
by hope
if you upload full teleports as a zip file will add them for you. Only added what you have above