Nun die WarpPortale die 1. ^^

[pachen123321]

mal wieder mal was neues von mir ^^

PHP Code:

INSERT INTO data_warpzones
   (`id`, `fromX`, `fromY`, `fromZ`, `fromWID`, `fromRadius`, `toX`, `toY`, `toZ`, `toWID`)
VALUES
   (1, 7622, 155, 4282, 1, 5, 693, 80, 683, 200);

INSERT INTO data_warpzones
   (`id`, `fromX`, `fromY`, `fromZ`, `fromWID`, `fromRadius`, `toX`, `toY`, `toZ`, `toWID`)
VALUES
   (2, 682, 80, 682, 200, 5, 7616, 155, 4275, 1); 


kritik und thx willkommen ^^

have fun

[Leines]

was sind das für Portale? Ich verstehe das Gerad nicht. Aber gute Arbeit.

bekomme diesen Fehler :

ERROR 1054 : Unknown column 'id' in 'field list'
ERROR 1054 : Unknown column 'id' in 'field list'

[pachen123321]

ups vergessen ^^

das sind die teleporter vor und in dem mass dungeon in flaris ^^

geh mal hin und teste mal ^^


EDIT:
Zeig mal deine datei: data_warpzone

[.Envy]

das problem ist das es keine id tabelle gibt^^

//fixed version

[pachen123321]

sag doch net so was böses :P

PHP Code:

-- ----------------------------
-- Table structure for data_warpzones
-- ----------------------------
DROP TABLE IF EXISTS `data_warpzones`;
CREATE TABLE `data_warpzones` (
  `id` int(11) NOT NULL auto_increment,
  `fromX` int(10) NOT NULL default '0',
  `fromY` int(10) NOT NULL default '0',
  `fromZ` int(10) NOT NULL default '0',
  `fromWID` int(10) NOT NULL default '0',
  `fromRadius` int(10) NOT NULL default '0',
  `toX` int(10) NOT NULL default '0',
  `toY` int(10) NOT NULL default '0',
  `toZ` int(10) NOT NULL default '0',
  `toWID` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; 


Have Fun

[pachen123321]

srry 4 doppelpost

Update:

flaris dungeon rein und raus
SM dungeon rein und raus
darkon raus und innnen 2 warpportale (rein per npc)


have fun

/*
MySQL Data Transfer
Source Host: localhost
Source Database: flyff
Target Host: localhost
Target Database: flyff
Date: 12.09.2008 18:39:45
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for data_warpzones
-- ----------------------------
CREATE TABLE `data_warpzones` (
  `id` int(11) NOT NULL auto_increment,
  `fromX` int(10) NOT NULL default '0',
  `fromY` int(10) NOT NULL default '0',
  `fromZ` int(10) NOT NULL default '0',
  `fromWID` int(10) NOT NULL default '0',
  `fromRadius` int(10) NOT NULL default '0',
  `toX` int(10) NOT NULL default '0',
  `toY` int(10) NOT NULL default '0',
  `toZ` int(10) NOT NULL default '0',
  `toWID` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `data_warpzones` VALUES ('1', '7622', '155', '4282', '1', '5', '693', '80', '683', '200');
INSERT INTO `data_warpzones` VALUES ('2', '682', '80', '682', '200', '5', '7616', '155', '4275', '1');
INSERT INTO `data_warpzones` VALUES ('3', '8631', '87', '2159', '1', '5', '1038', '5', '541', '204');
INSERT INTO `data_warpzones` VALUES ('4', '1044', '12', '528', '204', '5', '8630', '92', '2178', '1');
INSERT INTO `data_warpzones` VALUES ('7', '1372', '85', '648', '201', '3', '1299', '80', '614', '201');
INSERT INTO `data_warpzones` VALUES ('8', '1312', '80', '615', '201', '4', '1378', '85', '650', '201');
INSERT INTO `data_warpzones` VALUES ('6', '743', '85', '778', '201', '4', '5075', '55', '3969', '1');

[Glumanda]

Originally Posted by pachen123321

srry 4 doppelpost

Update:

flaris dungeon rein und raus
SM dungeon rein und raus
darkon raus und innnen 2 warpportale (rein per npc)


have fun

/*
MySQL Data Transfer
Source Host: localhost
Source Database: flyff
Target Host: localhost
Target Database: flyff
Date: 12.09.2008 18:39:45
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for data_warpzones
-- ----------------------------
CREATE TABLE `data_warpzones` (
  `id` int(11) NOT NULL auto_increment,
  `fromX` int(10) NOT NULL default '0',
  `fromY` int(10) NOT NULL default '0',
  `fromZ` int(10) NOT NULL default '0',
  `fromWID` int(10) NOT NULL default '0',
  `fromRadius` int(10) NOT NULL default '0',
  `toX` int(10) NOT NULL default '0',
  `toY` int(10) NOT NULL default '0',
  `toZ` int(10) NOT NULL default '0',
  `toWID` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `data_warpzones` VALUES ('1', '7622', '155', '4282', '1', '5', '693', '80', '683', '200');
INSERT INTO `data_warpzones` VALUES ('2', '682', '80', '682', '200', '5', '7616', '155', '4275', '1');
INSERT INTO `data_warpzones` VALUES ('3', '8631', '87', '2159', '1', '5', '1038', '5', '541', '204');
INSERT INTO `data_warpzones` VALUES ('4', '1044', '12', '528', '204', '5', '8630', '92', '2178', '1');
INSERT INTO `data_warpzones` VALUES ('7', '1372', '85', '648', '201', '3', '1299', '80', '614', '201');
INSERT INTO `data_warpzones` VALUES ('8', '1312', '80', '615', '201', '4', '1378', '85', '650', '201');
INSERT INTO `data_warpzones` VALUES ('6', '743', '85', '778', '201', '4', '5075', '55', '3969', '1');

Wie meinste das mit NPC o.o?

[pachen123321]

da ist ne abfrage fürs ticket in nem npc

[Glumanda]

Originally Posted by pachen123321

da ist ne abfrage fürs ticket in nem npc

welcher den o.o

[pachen123321]

log dich mal in e-flyff ein, gehe zum dungeon und schau wie der name ist :P

lach


have fun