Level-SQL Fehler...

06/05/2011 19:54 Flochecka#1

Hallo Leute,

Da ich bei meinem Server das Level h�her stellen wollte auf 350 habe ich eine SQL geschrieben:

Code:

INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('80', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('81', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('82', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('83', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('84', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('85', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('86', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('87', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('88', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('89', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('90', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('91', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('92', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('93', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('94', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('95', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('96', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('97', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('98', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('99', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('100', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('101', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('102', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('103', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('104', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('105', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('106', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('107', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('108', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('109', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('110', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('111', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('112', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('113', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('114', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('115', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('116', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('117', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('118', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('119', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('120', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('121', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('122', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('123', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('124', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('125', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('126', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('127', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('128', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('129', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('130', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('131', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('132', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('133', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('134', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('135', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('136', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('137', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('138', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('139', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('140', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('141', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('142', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('143', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('144', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('145', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('146', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('147', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('148', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('149', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('150', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('151', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('152', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('153', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('154', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('155', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('156', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('157', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('158', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('159', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('160', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('161', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('162', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('163', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('164', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('165', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('166', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('167', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('168', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('169', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('170', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('171', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('172', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('173', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('174', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('175', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('176', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('177', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('178', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('179', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('180', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('181', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('182', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('183', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('184', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('185', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('186', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('187', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('188', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('189', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('190', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('191', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('192', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('193', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('194', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('195', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('196', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('197', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('198', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('199', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('200', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('201', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('202', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('203', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('204', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('205', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('206', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('207', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('208', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('209', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('210', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('211', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('212', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('213', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('214', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('215', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('216', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('217', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('218', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('219', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('220', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('222', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('223', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('224', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('225', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('226', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('227', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('228', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('229', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('230', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('231', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('232', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('233', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('234', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('235', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('236', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('237', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('238', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('239', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('240', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('241', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('242', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('243', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('244', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('245', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('246', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('247', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('248', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('249', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('250', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('251', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('252', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('253', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('254', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('255', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('256', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('257', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('258', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('259', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('260', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('261', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('262', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('263', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('264', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('265', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('266', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('267', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('268', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('269', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('270', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('271', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('272', '4500')

INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('273', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('274', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('275', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('276', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('277', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('278', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('279', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('280', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('281', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('282', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('283', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('284', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('285', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('286', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('287', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('288', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('289', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('290', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('291', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('292', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('293', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('294', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('295', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('296', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('297', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('298', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('299', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('300', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('301', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('302', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('303', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('304', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('305', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('306', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('307', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('308', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('309', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('310', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('311', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('312', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('313', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('314', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('315', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('316', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('317', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('318', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('319', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('320', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('321', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('322', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('323', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('324', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('325', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('326', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('327', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('328', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('329', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('330', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('331', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('332', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('333', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('334', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('335', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('336', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('337', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('338', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('339', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('340', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('341', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('342', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('343', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('344', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('345', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('346', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('347', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('348', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('349', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('350', '4500')

is das Falsch? weil ich bekomme einen Fehler:

Code:

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''80', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('81',' at line 1
[Err] INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('80', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('81', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('82', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('83', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('84', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('85', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('86', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('87', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('88', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('89', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('90', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('91', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('92', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('93', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('94', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('95', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('96', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('97', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('98', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('99', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('100', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('101', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('102', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('103', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('104', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('105', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('106', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('107', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('108', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('109', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('110', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('111', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('112', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('113', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('114', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('115', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('116', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('117', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('118', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('119', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('120', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('121', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('122', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('123', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('124', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('125', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('126', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('127', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('128', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('129', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('130', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('131', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('132', '4500')
INSERT INTO `player_xp_for_level` (lvl, xp_for_next_level) ('133', '4500')
INSERT
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Bitte helft mir...

Danke im vorraus.

MFG

Flochecka

06/05/2011 20:01 Verluzus#2

Hey vielleicht hilft dort der Post von Crazy [Only registered and activated users can see links. Click Here To Register...]

06/05/2011 20:21 Flochecka#3

nep bringt nix weil die noch nicht eingetragen sind also ich trag die grad frisch ein

06/05/2011 22:04 n1_Roxxer#4

In meiner TrinityDB sieht die Table Charakters wie folgt aus :

Code:

CREATE TABLE `characters` (
	`guid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
	`account` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Account Identifier',
	`name` VARCHAR(12) NOT NULL DEFAULT '',
	`race` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`class` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`gender` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`xp` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`money` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`playerBytes` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`playerBytes2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`playerFlags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`position_x` FLOAT NOT NULL DEFAULT '0',
	`position_y` FLOAT NOT NULL DEFAULT '0',
	`position_z` FLOAT NOT NULL DEFAULT '0',
	`map` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
	`instance_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`instance_mode_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`orientation` FLOAT NOT NULL DEFAULT '0',
	`taximask` TEXT NOT NULL,
	`online` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`cinematic` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`totaltime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`leveltime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`logout_time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`is_logout_resting` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`rest_bonus` FLOAT NOT NULL DEFAULT '0',
	`resettalents_cost` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`resettalents_time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`trans_x` FLOAT NOT NULL DEFAULT '0',
	`trans_y` FLOAT NOT NULL DEFAULT '0',
	`trans_z` FLOAT NOT NULL DEFAULT '0',
	`trans_o` FLOAT NOT NULL DEFAULT '0',
	`transguid` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	`extra_flags` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
	`stable_slots` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`at_login` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
	`zone` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
	`death_expire_time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`taxi_path` TEXT NULL,
	`arenaPoints` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`totalHonorPoints` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`todayHonorPoints` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`yesterdayHonorPoints` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`totalKills` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`todayKills` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
	`yesterdayKills` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
	`chosenTitle` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`knownCurrencies` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
	`watchedFaction` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`drunk` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
	`health` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`power1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`power2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`power3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`power4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`power5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`power6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`power7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`latency` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	`speccount` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1',
	`activespec` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`exploredZones` LONGTEXT NULL,
	`equipmentCache` LONGTEXT NULL,
	`ammoId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`knownTitles` LONGTEXT NULL,
	`actionBars` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`deleteInfos_Account` INT(10) UNSIGNED NULL DEFAULT NULL,
	`deleteInfos_Name` VARCHAR(12) NULL DEFAULT NULL,
	`deleteDate` INT(10) UNSIGNED NULL DEFAULT NULL,
	PRIMARY KEY (`guid`),
	INDEX `idx_account` (`account`),
	INDEX `idx_online` (`online`),
	INDEX `idx_name` (`name`)
)

06/07/2011 10:25 Globalsocialist#5

Damit sollte es klappen:

Code:

INSERT INTO `player_xp_for_level` VALUES ('80', '4500');
INSERT INTO `player_xp_for_level` VALUES ('81', '4500');
INSERT INTO `player_xp_for_level` VALUES ('82', '4500');
INSERT INTO `player_xp_for_level` VALUES ('83', '4500');
INSERT INTO `player_xp_for_level` VALUES ('84', '4500');
INSERT INTO `player_xp_for_level` VALUES ('85', '4500');
INSERT INTO `player_xp_for_level` VALUES ('86', '4500');
INSERT INTO `player_xp_for_level` VALUES ('87', '4500');
INSERT INTO `player_xp_for_level` VALUES ('88', '4500');
INSERT INTO `player_xp_for_level` VALUES ('89', '4500');
INSERT INTO `player_xp_for_level` VALUES ('90', '4500');
INSERT INTO `player_xp_for_level` VALUES ('91', '4500');
INSERT INTO `player_xp_for_level` VALUES ('92', '4500');
INSERT INTO `player_xp_for_level` VALUES ('93', '4500');
INSERT INTO `player_xp_for_level` VALUES ('94', '4500');
INSERT INTO `player_xp_for_level` VALUES ('95', '4500');
INSERT INTO `player_xp_for_level` VALUES ('96', '4500');
INSERT INTO `player_xp_for_level` VALUES ('97', '4500');
INSERT INTO `player_xp_for_level` VALUES ('98', '4500');
INSERT INTO `player_xp_for_level` VALUES ('99', '4500');
INSERT INTO `player_xp_for_level` VALUES ('100', '4500');
INSERT INTO `player_xp_for_level` VALUES ('101', '4500');
INSERT INTO `player_xp_for_level` VALUES ('102', '4500');
INSERT INTO `player_xp_for_level` VALUES ('103', '4500');
INSERT INTO `player_xp_for_level` VALUES ('104', '4500');
INSERT INTO `player_xp_for_level` VALUES ('105', '4500');
INSERT INTO `player_xp_for_level` VALUES ('106', '4500');
INSERT INTO `player_xp_for_level` VALUES ('107', '4500');
INSERT INTO `player_xp_for_level` VALUES ('108', '4500');
INSERT INTO `player_xp_for_level` VALUES ('109', '4500');
INSERT INTO `player_xp_for_level` VALUES ('110', '4500');

u.s.w. ;)

06/07/2011 16:38 �"Crazy"�#6

Code:

DROP TABLE IF EXISTS `player_xp_for_level`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `player_xp_for_level` (
  `lvl` int(3) unsigned NOT NULL,
  `xp_for_next_level` int(10) unsigned NOT NULL,
  PRIMARY KEY (`lvl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

Von der Sache her ist es richtig.

Probier mal mit den folgenden Code:

Code:

REPLACE INTO `player_xp_for_level` VALUES ('80', '4500'),
  ('81', '4500'),
  ('82', '4500'),
  ('83', '4500'),
  ('84', '4500'),
  ('85', '4500'),
  ('86', '4500'),
  ('87', '4500'),
  ('88', '4500'),
  ('89', '4500'),
  ('90', '4500'),
  ('91', '4500'),
  ('92', '4500'),
  ('93', '4500'),
  ('94', '4500'),
  ('95', '4500'),
  ('96', '4500'),
  ('97', '4500'),
  ('98', '4500'),
  ('99', '4500'),
  ('100', '4500'),
  ('101', '4500'),
  ('102', '4500'),
  ('103', '4500'),
  ('104', '4500'),
  ('105', '4500'),
  ('106', '4500'),
  ('107', '4500'),
  ('108', '4500'),
  ('109', '4500'),
  ('110', '4500'),
  ('111', '4500'),
  ('112', '4500'),
  ('113', '4500'),
  ('114', '4500'),
  ('115', '4500'),
  ('116', '4500'),
  ('117', '4500'),
  ('118', '4500'),
  ('119', '4500'),
  ('120', '4500'),
  ('121', '4500'),
  ('122', '4500'),
  ('123', '4500'),
  ('124', '4500'),
  ('125', '4500'),
  ('126', '4500'),
  ('127', '4500'),
  ('128', '4500'),
  ('129', '4500'),
  ('130', '4500'),
  ('131', '4500'),
  ('132', '4500'),
  ('133', '4500'),
  ('134', '4500'),
  ('135', '4500'),
  ('136', '4500'),
  ('137', '4500'),
  ('138', '4500'),
  ('139', '4500'),
  ('140', '4500'),
  ('141', '4500'),
  ('142', '4500'),
  ('143', '4500'),
  ('144', '4500'),
  ('145', '4500'),
  ('146', '4500'),
  ('147', '4500'),
  ('148', '4500'),
  ('149', '4500'),
  ('150', '4500'),
  ('151', '4500'),
  ('152', '4500'),
  ('153', '4500'),
  ('154', '4500'),
  ('155', '4500'),
  ('156', '4500'),
  ('157', '4500'),
  ('158', '4500'),
  ('159', '4500'),
  ('160', '4500'),
  ('161', '4500'),
  ('162', '4500'),
  ('163', '4500'),
  ('164', '4500'),
  ('165', '4500'),
  ('166', '4500'),
  ('167', '4500'),
  ('168', '4500'),
  ('169', '4500'),
  ('170', '4500'),
  ('171', '4500'),
  ('172', '4500'),
  ('173', '4500'),
  ('174', '4500'),
  ('175', '4500'),
  ('176', '4500'),
  ('177', '4500'),
  ('178', '4500'),
  ('179', '4500'),
  ('180', '4500'),
  ('181', '4500'),
  ('182', '4500'),
  ('183', '4500'),
  ('184', '4500'),
  ('185', '4500'),
  ('186', '4500'),
  ('187', '4500'),
  ('188', '4500'),
  ('189', '4500'),
  ('190', '4500'),
  ('191', '4500'),
  ('192', '4500'),
  ('193', '4500'),
  ('194', '4500'),
  ('195', '4500'),
  ('196', '4500'),
  ('197', '4500'),
  ('198', '4500'),
  ('199', '4500'),
  ('200', '4500'),
  ('201', '4500'),
  ('202', '4500'),
  ('203', '4500'),
  ('204', '4500'),
  ('205', '4500'),
  ('206', '4500'),
  ('207', '4500'),
  ('208', '4500'),
  ('209', '4500'),
  ('210', '4500'),
  ('211', '4500'),
  ('212', '4500'),
  ('213', '4500'),
  ('214', '4500'),
  ('215', '4500'),
  ('216', '4500'),
  ('217', '4500'),
  ('218', '4500'),
  ('219', '4500'),
  ('220', '4500'),
  ('222', '4500'),
  ('223', '4500'),
  ('224', '4500'),
  ('225', '4500'),
  ('226', '4500'),
  ('227', '4500'),
  ('228', '4500'),
  ('229', '4500'),
  ('230', '4500'),
  ('231', '4500'),
  ('232', '4500'),
  ('233', '4500'),
  ('234', '4500'),
  ('235', '4500'),
  ('236', '4500'),
  ('237', '4500'),
  ('238', '4500'),
  ('239', '4500'),
  ('240', '4500'),
  ('241', '4500'),
  ('242', '4500'),
  ('243', '4500'),
  ('244', '4500'),
  ('245', '4500'),
  ('246', '4500'),
  ('247', '4500'),
  ('248', '4500'),
  ('249', '4500'),
  ('250', '4500'),
  ('251', '4500'),
  ('252', '4500'),
  ('253', '4500'),
  ('254', '4500'),
  ('255', '4500'),
  ('256', '4500'),
  ('257', '4500'),
  ('258', '4500'),
  ('259', '4500'),
  ('260', '4500'),
  ('261', '4500'),
  ('262', '4500'),
  ('263', '4500'),
  ('264', '4500'),
  ('265', '4500'),
  ('266', '4500'),
  ('267', '4500'),
  ('268', '4500'),
  ('269', '4500'),
  ('270', '4500'),
  ('271', '4500'),
  ('272', '4500'),

  ('273', '4500'),
  ('274', '4500'),
  ('275', '4500'),
  ('276', '4500'),
  ('277', '4500'),
  ('278', '4500'),
  ('279', '4500'),
  ('280', '4500'),
  ('281', '4500'),
  ('282', '4500'),
  ('283', '4500'),
  ('284', '4500'),
  ('285', '4500'),
  ('286', '4500'),
  ('287', '4500'),
  ('288', '4500'),
  ('289', '4500'),
  ('290', '4500'),
  ('291', '4500'),
  ('292', '4500'),
  ('293', '4500'),
  ('294', '4500'),
  ('295', '4500'),
  ('296', '4500'),
  ('297', '4500'),
  ('298', '4500'),
  ('299', '4500'),
  ('300', '4500'),
  ('301', '4500'),
  ('302', '4500'),
  ('303', '4500'),
  ('304', '4500'),
  ('305', '4500'),
  ('306', '4500'),
  ('307', '4500'),
  ('308', '4500'),
  ('309', '4500'),
  ('310', '4500'),
  ('311', '4500'),
  ('312', '4500'),
  ('313', '4500'),
  ('314', '4500'),
  ('315', '4500'),
  ('316', '4500'),
  ('317', '4500'),
  ('318', '4500'),
  ('319', '4500'),
  ('320', '4500'),
  ('321', '4500'),
  ('322', '4500'),
  ('323', '4500'),
  ('324', '4500'),
  ('325', '4500'),
  ('326', '4500'),
  ('327', '4500'),
  ('328', '4500'),
  ('329', '4500'),
  ('330', '4500'),
  ('331', '4500'),
  ('332', '4500'),
  ('333', '4500'),
  ('334', '4500'),
  ('335', '4500'),
  ('336', '4500'),
  ('337', '4500'),
  ('338', '4500'),
  ('339', '4500'),
  ('340', '4500'),
  ('341', '4500'),
  ('342', '4500'),
  ('343', '4500'),
  ('344', '4500'),
  ('345', '4500'),
  ('346', '4500'),
  ('347', '4500'),
  ('348', '4500'),
  ('349', '4500'),
  ('350', '4500');

MfG