Level-SQL Fehler...

Flochecka · 06/05/2011, 19:54

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

Verluzus · 06/05/2011, 20:01

Hey vielleicht hilft dort der Post von Crazy

Flochecka · 06/05/2011, 20:21

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

n1_Roxxer · 06/05/2011, 22:04

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`)
)

Globalsocialist · 06/07/2011, 10:25

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.

°"Crazy"° · 06/07/2011, 16:38

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