[HELP] Sql problem

Oяacle™ · February 11, 2013

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 · February 11, 2013

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

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

Oяacle™ · February 11, 2013

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

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

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

L2KingWorld · February 12, 2013

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');

[HELP] Sql problem

Question

Oяacle™

3 answers to this question

Recommended Posts

Zake

Oяacle™

L2KingWorld

Posts

Topics

Browse

Activity

Store