Can't execute my sql File for Luxury teleports

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
ADONES
Posts: 51
Joined: Sun Dec 06, 2009 10:28 pm

Can't execute my sql File for Luxury teleports

Post 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
Probe
Posts: 915
Joined: Thu Sep 03, 2009 6:36 pm
Location: Israel
Contact:

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

Post by Probe »

maybe, but just maybe, you should post the sql error
burrito
Posts: 276
Joined: Wed Apr 15, 2009 6:41 am

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

Post by burrito »

Your missing the new column that was added for item id
hope
Posts: 1160
Joined: Thu Aug 30, 2007 5:17 pm

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

Post by hope »

You should put into custom teleport table
ADONES
Posts: 51
Joined: Sun Dec 06, 2009 10:28 pm

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

Post 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
hope
Posts: 1160
Joined: Thu Aug 30, 2007 5:17 pm

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

Post 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
_DS_
L2j Veteran
L2j Veteran
Posts: 3437
Joined: Wed Apr 30, 2008 8:53 am
Location: Russia

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

Post by _DS_ »

LOL. burruto wins the prize. Others possibly unable to read english ?
Commiter of the shit
public static final int PI = 3.1415926535897932384626433832795;
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

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

Post by jurchiks »

insert statement for every row? it was mentioned a day or two ago in this forum that it's bad practice...
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
ADONES
Posts: 51
Joined: Sun Dec 06, 2009 10:28 pm

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

Post 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
hope
Posts: 1160
Joined: Thu Aug 30, 2007 5:17 pm

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

Post by hope »

here is fix for you
You do not have the required permissions to view the files attached to this post.
hope
Posts: 1160
Joined: Thu Aug 30, 2007 5:17 pm

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

Post by hope »

you had alot of mistakes all fixed now just execute batch file
hope
Posts: 1160
Joined: Thu Aug 30, 2007 5:17 pm

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

Post by hope »

if you upload full teleports as a zip file will add them for you. Only added what you have above
Post Reply