[HELP] Sql problem

[Oяacle™]

Who can make this for l2jfrozen pack?

INSERT INTO `weapon` VALUES ('9202', 'Dynasty Rapier - Focus', 'rhand', 'true', '1300', '1', '1', 'steel', 's', '278', '10', 'sword', '8', '0.00000', '0', '0', '0', '433', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3010', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9203', 'Dynasty Rapier - Health', 'rhand', 'true', '1300', '1', '1', 'steel', 's', '278', '10', 'sword', '8', '0.00000', '0', '0', '0', '433', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3013', '5', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9204', 'Dynasty Rapier - Light', 'rhand', 'true', '910', '1', '1', 'steel', 's', '278', '10', 'sword', '8', '0.00000', '0', '0', '0', '433', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9205', 'Dynasty Ancient Sword - Focus', 'rhand', 'true', '1300', '1', '1', 'steel', 's', '322', '10', 'sword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3010', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9206', 'Dynasty Ancient Sword - Health', 'rhand', 'true', '1300', '1', '1', 'steel', 's', '322', '10', 'sword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3013', '5', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9207', 'Dynasty Ancient Sword - Light', 'rhand', 'true', '910', '1', '1', 'steel', 's', '322', '10', 'sword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9208', 'Dynasty Crossbow - Cheap Shot', 'lrhand', 'true', '1640', '1', '1', 'steel', 's', '389', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '11', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9209', 'Dynasty Crossbow - Guidance', 'lrhand', 'true', '1640', '1', '1', 'steel', 's', '389', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '11', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3007', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9210', 'Dynasty Crossbow - Evasion', 'lrhand', 'true', '1640', '1', '1', 'steel', 's', '389', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '11', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9211', 'Dynasty Shield', 'lhand', 'true', '1170', '0', '0', 's', '0', '5', 'steel', 'none', '0', '0.00000', '-8', '300', '50', '0', '0', '0', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9212', 'Dynasty Shield - Evasion', 'lhand', 'true', '1170', '0', '0', 'steel', 's', '0', '5', 'none', '0', '0.00000', '0', '300', '50', '0', '0', '0', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9213', 'Dynasty Blade - Focus', 'rhand', 'true', '1300', '1', '1', 'steel', 's', '307', '10', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3010', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9214', 'Dynasty Blade - Health', 'rhand', 'true', '1300', '1', '1', 'steel', 's', '307', '10', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3013', '5', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9215', 'Dynasty Blade - Light', 'rhand', 'true', '910', '1', '1', 'steel', 's', '307', '10', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9216', 'Dynasty Two Handed Sword - Focus', 'lrhand', 'true', '1820', '1', '1', 'steel', 's', '374', '5', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3010', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9217', 'Dynasty Two Handed Sword - Health', 'lrhand', 'true', '1820', '1', '1', 'steel', 's', '374', '5', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3013', '5', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9218', 'Dynasty Two Handed Sword - Light', 'lrhand', 'true', '1274', '1', '1', 'steel', 's', '374', '5', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9219', 'Dynasty Magic Sword - Acumen', 'rhand', 'true', '1300', '1', '1', 'steel', 's', '246', '10', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '186', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3047', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9220', 'Dynasty Magic Sword - Mana Up', 'rhand', 'true', '1300', '1', '1', 'steel', 's', '246', '10', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '186', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3014', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9221', 'Dynasty Magic Sword - Conversion', 'rhand', 'true', '1300', '1', '1', 'steel', 's', '246', '10', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '186', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3048', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9222', 'Dynasty Bow - Cheap Shot', 'lrhand', 'true', '1640', '1', '1', 'steel', 's', '634', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '11', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9223', 'Dynasty Bow - Guidance', 'lrhand', 'true', '1640', '1', '1', 'steel', 's', '634', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '11', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3007', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9224', 'Dynasty Bow - Evasion', 'lrhand', 'true', '1640', '1', '1', 'steel', 's', '634', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '11', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9225', 'Dynasty Dagger - Focus', 'rhand', 'true', '930', '1', '1', 'steel', 's', '269', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3010', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9226', 'Dynasty Dagger - Evasion', 'rhand', 'true', '930', '1', '1', 'steel', 's', '269', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9227', 'Dynasty Dagger - Critical Damage', 'rhand', 'true', '930', '1', '1', 'steel', 's', '269', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3023', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9228', 'Dynasty Spear - Anger', 'lrhand', 'true', '1820', '1', '1', 'steel', 's', '307', '5', 'pole', '8', '-3.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3012', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9229', 'Dynasty Spear - Critical Stun', 'lrhand', 'true', '1820', '1', '1', 'steel', 's', '307', '5', 'pole', '8', '-3.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3016', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9230', 'Dynasty Spear - Light', 'lrhand', 'true', '1274', '1', '1', 'steel', 's', '307', '5', 'pole', '8', '-3.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9231', 'Dynasty Hammer - Anger', 'rhand', 'true', '1550', '1', '1', 'steel', 's', '307', '20', 'blunt', '4', '4.00000', '0', '0', '0', '379', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3012', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9232', 'Dynasty Hammer - Health', 'rhand', 'true', '1550', '1', '1', 'steel', 's', '307', '20', 'blunt', '4', '4.00000', '0', '0', '0', '379', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3013', '5', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9233', 'Dynasty Hammer - Risk Focus', 'rhand', 'true', '1550', '1', '1', 'steel', 's', '307', '20', 'blunt', '4', '4.00000', '0', '0', '0', '379', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3027', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9234', 'Dynasty Staff - Mana Up', 'rhand', 'true', '1510', '1', '1', 'steel', 's', '299', '20', 'sword', '4', '4.00000', '0', '0', '0', '325', '0', '186', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3014', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9235', 'Dynasty Staff - Conversion', 'rhand', 'true', '1510', '1', '1', 'steel', 's', '299', '20', 'sword', '4', '4.00000', '0', '0', '0', '325', '0', '186', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3048', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9236', 'Dynasty Staff - Acumen', 'rhand', 'true', '1510', '1', '1', 'steel', 's', '299', '20', 'sword', '4', '4.00000', '0', '0', '0', '325', '0', '186', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3047', '3', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9237', 'Dynasty Fist - Risk Haste', 'lrhand', 'true', '1330', '1', '1', 'steel', 's', '374', '5', 'dualfist', '4', '4.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3034', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9238', 'Dynasty Fist - Risk Evasion', 'lrhand', 'true', '1330', '1', '1', 'steel', 's', '374', '5', 'dualfist', '4', '4.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3028', '6', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9239', 'Dynasty Fist - Haste', 'lrhand', 'true', '1330', '1', '1', 'steel', 's', '374', '5', 'dualfist', '4', '4.00000', '0', '0', '0', '325', '0', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '3045', '20', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9240','dynasty_spellbook','rhand','true','650','1','1', 'steel','s','140','10','etc','8','0.00000','0','0','0','379','0','186','-1','24400000','2440','true','true','true','true','0','0','0','0','0','0','0','0','0','0');
INSERT INTO `weapon` VALUES ('9241','dynasty_spellbook-acumen','rhand','true','650','1','1', 'steel','s','140','10','etc','8','0.00000','0','0','0','379','0','186','-1','24400000','2440','true','true','true','true','0','0','0','0','0','0','0','0','0','0');
INSERT INTO `weapon` VALUES ('9242','dynasty_spellbook-mana up','rhand','true','650','1','1', 'steel','s','140','10','etc','8','0.00000','0','0','0','379','0','186','-1','24400000','2440','true','true','true','true','0','0','0','0','0','0','0','0','0','0');
INSERT INTO `weapon` VALUES ('9243','dynasty_spellbook-conversion','rhand','true','650','1','1', 'steel','s','140','10','etc','8','0.00000','0','0','0','379','0','186','-1','24400000','2440','true','true','true','true','0','0','0','0','0','0','0','0','0','0');
INSERT INTO `weapon` VALUES ('9244','dynasty_dual_rapiers','lrhand','true','2080','1','1', 'steel','s','140','10','dual','8','0.00000','0','0','0','379','0','186','-1','24400000','2440','true','true','true','true','0','0','0','0','0','0','0','0','0','0');
INSERT INTO `weapon` VALUES ('9245','dynasty_dual_Dagger','lrhand','true','2080','1','1', 'steel','s','140','10','dual','8','0.00000','0','0','0','379','0','186','-1','24400000','2440','true','true','true','true','0','0','0','0','0','0','0','0','0','0');
INSERT INTO `weapon` VALUES ('9246','dynasty_dual_Blades','lrhand','true','2080','1','1', 'steel','s','140','10','dual','8','0.00000','0','0','0','379','0','186','-1','24400000','2440','true','true','true','true','0','0','0','0','0','0','0','0','0','0');
INSERT INTO `weapon` VALUES ('9247','dynasty_dual_MagicSwords','lrhand','true','2080','1','1', 'steel','s','140','10','dual','8','0.00000','0','0','0','379','0','186','-1','24400000','2440','true','true','true','true','0','0','0','0','0','0','0','0','0','0');
INSERT INTO `weapon` VALUES ('9248','dynasty_dual_dms/rapier','lrhand','true','2080','1','1', 'steel','s','140','10','dual','8','0.00000','0','0','0','379','0','186','-1','24400000','2440','true','true','true','true','0','0','0','0','0','0','0','0','0','0');
INSERT INTO `weapon` VALUES ('9249','dynasty_dual_blade/dms','lrhand','true','2080','1','1', 'steel','s','140','10','dual','8','0.00000','0','0','0','379','0','186','-1','24400000','2440','true','true','true','true','0','0','0','0','0','0','0','0','0','0');
INSERT INTO `weapon` VALUES ('9250', 'Dynasty Crusher - Focus', 'lrhand', 'true', '1300', '1', '1', 'steel', 's', '361', '10', 'bigblunt', '8', '0.00000', '0', '0', '0', '325', '0', '137', '-1', '57000000', '2850', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9252', 'Dynasty Crusher - Health', 'lrhand', 'true', '1300', '1', '1', 'steel', 's', '361', '10', 'bigblunt', '8', '0.00000', '0', '0', '0', '325', '0', '137', '-1', '57000000', '2850', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9253', 'Dynasty Crusher - Light', 'lrhand', 'true', '1300', '1', '1', 'steel', 's', '361', '10', 'bigblunt', '8', '0.00000', '0', '0', '0', '325', '0', '137', '-1', '57000000', '2850', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9251', 'Dynasty Scepter - Acumen', 'lrhand', 'true', '1300', '1', '1', 'steel', 's', '290', '20', 'sword', '4', '4.00000', '0', '0', '0', '325', '0', '182', '-1', '57000000', '2850', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9254', 'Dynasty Scepter - Mana Up', 'lrhand', 'true', '1300', '1', '1', 'steel', 's', '290', '20', 'sword', '4', '4.00000', '0', '0', '0', '325', '0', '182', '-1', '57000000', '2850', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9255', 'Dynasty Scepter - Conversion', 'lrhand', 'true', '1300', '1', '1', 'steel', 's', '290', '20', 'sword', '4', '4.00000', '0', '0', '0', '325', '0', '182', '-1', '57000000', '2850', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

or tell me how to fix it

[Zake]

Βρίσκεσαι σε ελληνικό τομέα οπότε μίλα ελληνικά,

@ μια βαρετή λύση είναι να το περάσεις χειροκίνητα και μια να δεις τις στήλες μια μια και μετά από κάθε αντίστοιχο κόμμα(,) να βάζεις την κατάλληλη τιμή στο αρχείο sql.

[Oяacle™]

Βρίσκεσαι σε ελληνικό τομέα οπότε μίλα ελληνικά,

@ μια βαρετή λύση

αύτο ακριβώς.συγνώμη για τα αγγλικά..

[L2KingWorld]

den einai tpt file mou apla des pos einai sto weapon tables pos einai kataxoremena ta dikasou sql...

h alios kane Damp SQL file kane copi ke paste edo ena id apo ta weapon sou

px)

INSERT INTO `weapon` VALUES ('9224', 'Dynasty Bow - Evasion', 'lrhand', 'true', '1640', '1', '1', 'steel', 's', '634', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '11', '140', '-1', '800000000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');