Quote:
Originally Posted by saifi
jo ich mache dir schnell ein object ok? also ich mache dir die sql schnell und yoa :D
|
jop super danke --> *fettes lob* ^^
ps: passt jez net so dazu hab aber grad nen navicat error vl kannst du rauslesen was da nicht passt:
---------------------------------------------------------------
INSERT INTO gossip_menu (entry, text_id, cond_1, cond_1_val_1, cond_1_val_2, cond_2, cond_2_val_1, cond_2_val_2)
VALUES (8000260, 10000, 0, 0, 0, 0, 0, 0)
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded,box_money, box_text, cond_1, cond_1_val_1, cond_1_val_2, cond_2, cond_2_val_1, cond_2_val_2, cond_3, cond_3_val_1, cond_3_val_2)
VALUES (60000, 1, 2, 'Sturmwind', 1, 1, 0, 0, 60000, 0, 0, Willst du wirklich nach Sturmwind?, 0, 0, 0, 0, 0, 0, 0, 0, 0)
----------------------------------------------------------------
---> wenn ich das einbatch kommt der error :
[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 'INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id' at line 4
[Err] INSERT INTO gossip_menu (entry, text_id, cond_1, cond_1_val_1, cond_1_val_2, cond_2, cond_2_val_1, cond_2_val_2)
VALUES (8000260, 10000, 0, 0, 0, 0, 0, 0)
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, box_text, cond_1, cond_1_val_1, cond_1_val_2, cond_2, cond_2_val_1, cond_2_val_2, cond_3, cond_3_val_1, cond_3_val_2)
VALUES (60000, 1, 2, 'Sturmwind', 1, 1, 0, 0, 60000, 0, 0, Willst du wirklich nach Sturmwind?, 0, 0, 0, 0, 0, 0, 0, 0, 0)
[Msg] Finished - Unsuccessfully
--------------------------------------------------
hmm.... iwas mit "line 4 xD "