Sql Для Dynasty

[Happy13 27]

Если у кого есть Sql для династи армора, дайте пожалуйста.

Изменено 26 ноября, 2013 пользователем Happy13

[Mefestofel163 1333]

Если у кого есть Sql для династи армора, дайте пожалуйста.

 

под какую сборку то)?

[Happy13 27]

спасибо, я уже сам переделал)

[doda 96]

Пож кто небуд переделайте его на сборку frozendev.

 

INSERT INTO `weapon` VALUES
('9376','Dynasty Rapier','rhand','true','1280','1','1','steel','s','278','1','sword','12','0.00000','0','0','0','433','0','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9377','Dynasty Rapier - Focus','rhand','true','1280','1','1','steel','s','278','1','sword','12','0.00000','0','0','0','433','0','140','-1','0','3500','true','true','true','true','3050','1','0','0','0','0','0','0','0','0'),
('9378','Dynasty Rapier - Health','rhand','true','1280','1','1','steel','s','278','1','sword','12','0.00000','0','0','0','433','0','140','-1','0','3500','true','true','true','true','3013','1','0','0','0','0','0','0','0','0'),
('9379','Dynasty Rapier - Light','rhand','true','1280','1','1','steel','s','278','1','sword','12','0.00000','0','0','0','433','0','140','-1','0','3500','true','true','true','true','1257','1','0','0','0','0','0','0','0','0'),
('9380','Dynasty Ancient Sword','lrhand','true','1800','1','1','steel','s','332','1','bigsword','8','0.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9381','Dynasty Ancient Sword - Focus','lrhand','true','1800','1','1','steel','s','332','1','bigsword','8','0.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','3050','1','0','0','0','0','0','0','0','0'),
('9382','Dynasty Ancient Sword - Health','lrhand','true','1800','1','1','steel','s','332','1','bigsword','8','0.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','3013','1','0','0','0','0','0','0','0','0'),
('9383','Dynasty Ancient Sword - Light','lrhand','true','1800','1','1','steel','s','332','1','bigsword','8','0.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','1257','1','0','0','0','0','0','0','0','0'),
('9384','Dynasty Crossbow','lrhand','true','1580','1','1','bone','s','389','1','bow','12','-3.00000','0','0','0','293','9','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9385','Dynasty Crossbow - Cheap Shot','lrhand','true','1580','1','1','bone','s','389','1','bow','12','-3.00000','0','0','0','293','9','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9386','Dynasty Crossbow - Guidance','lrhand','true','1580','1','1','bone','s','389','1','bow','12','-3.00000','0','0','0','293','9','140','-1','0','3500','true','true','true','true','3064','1','0','0','0','0','0','0','0','0'),
('9387','Dynasty Crossbow - Evasion','lrhand','true','1580','1','1','bone','s','389','1','bow','12','-3.00000','0','0','0','293','9','140','-1','0','3500','true','true','true','true','3009','3','0','0','0','0','0','0','0','0'),
('9441','Dynasty Shield','lhand','false','1390','0','0','bone','s','0','0','none','0','0.00000','-8','310','20','0','0','0','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9529','Dynasty Shield - Evasion','lhand','true','1390','0','0','bone','s','0','0','none','0','0.00000','-8','310','20','0','0','0','-1','0','3500','true','true','true','true','3009','3','0','0','0','0','0','0','0','0'),
('9442','Dynasty Blade','rhand','true','1520','1','1','mithril','s','307','1','sword','12','0.00000','0','0','0','379','0','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9854','Dynasty Blade - Focus','rhand','true','1520','1','1','mithril','s','307','1','sword','12','0.00000','0','0','0','379','0','140','-1','0','3500','true','true','true','true','3050','1','0','0','0','0','0','0','0','0'),
('9855','Dynasty Blade - Health','rhand','true','1520','1','1','mithril','s','307','1','sword','12','0.00000','0','0','0','379','0','140','-1','0','3500','true','true','true','true','3013','1','0','0','0','0','0','0','0','0'),
('9856','Dynasty Blade - Light','rhand','true','1520','1','1','mithril','s','307','1','sword','12','0.00000','0','0','0','379','0','140','-1','0','3500','true','true','true','true','1257','1','0','0','0','0','0','0','0','0'),
('9443','Dynasty Two Handed Sword','lrhand','true','1520','1','1','mithril','s','374','1','bigsword','8','0.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9857','Dynasty Two Handed Sword - Focus','lrhand','true','1740','1','1','mithril','s','374','1','bigsword','8','0.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','3050','1','0','0','0','0','0','0','0','0'),
('9858','Dynasty Two Handed Sword - Health','lrhand','true','1740','1','1','mithril','s','374','1','bigsword','8','0.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','3013','1','0','0','0','0','0','0','0','0'),
('9859','Dynasty Two Handed Sword - Light','lrhand','true','1740','1','1','mithril','s','374','1','bigsword','8','0.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','1257','1','0','0','0','0','0','0','0','0'),
('9444','Dynasty Magic Sword','rhand','true','1520','1','1','mithril','s','246','1','sword','12','0.00000','0','0','0','379','0','186','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9860','Dynasty Magic Sword - Acumen','rhand','true','1520','1','1','mithril','s','246','1','sword','12','0.00000','0','0','0','379','0','186','-1','0','3500','true','true','true','true','3047','3','0','0','0','0','0','0','0','0'),
('9861','Dynasty Magic Sword - Mana Up','rhand','true','1520','1','1','mithril','s','246','1','sword','12','0.00000','0','0','0','379','0','186','-1','0','3500','true','true','true','true','3014','2','0','0','0','0','0','0','0','0'),
('9862','Dynasty Magic Sword - Conversion','rhand','true','1520','1','1','mithril','s','246','1','sword','12','0.00000','0','0','0','379','0','186','-1','0','3500','true','true','true','true','3048','2','0','0','0','0','0','0','0','0'),
('9445','Dynasty Bow','lrhand','true','1520','1','1','bone','s','634','1','bow','12','-3.00000','0','0','0','293','9','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9863','Dynasty Bow - Cheap Shot','lrhand','true','1520','1','1','bone','s','634','1','bow','12','-3.00000','0','0','0','293','9','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9864','Dynasty Bow - Guidance','lrhand','true','1520','1','1','bone','s','634','1','bow','12','-3.00000','0','0','0','293','9','140','-1','0','3500','true','true','true','true','3064','1','0','0','0','0','0','0','0','0'),
('9865','Dynasty Bow - Evasion','lrhand','true','1520','1','1','bone','s','634','1','bow','12','-3.00000','0','0','0','293','9','140','-1','0','3500','true','true','true','true','3009','3','0','0','0','0','0','0','0','0'),
('9446','Dynasty Dagger','rhand','true','1520','1','1','mithril','s','269','1','dagger','12','-3.00000','0','0','0','433','0','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9866','Dynasty Dagger - Focus','rhand','true','1520','1','1','mithril','s','269','1','dagger','12','-3.00000','0','0','0','433','0','140','-1','0','3500','true','true','true','true','3050','1','0','0','0','0','0','0','0','0'),
('9867','Dynasty Dagger - Evasion','rhand','true','1520','1','1','mithril','s','269','1','dagger','12','-3.00000','0','0','0','433','0','140','-1','0','3500','true','true','true','true','3009','3','0','0','0','0','0','0','0','0'),
('9868','Dynasty Dagger - Critical Damage','rhand','true','1520','1','1','mithril','s','269','1','dagger','12','-3.00000','0','0','0','433','0','140','-1','0','3500','true','true','true','true','3023','3','0','0','0','0','0','0','0','0'),
('9447','Dynasty Spear','lrhand','true','2010','1','1','mithril','s','307','1','pole','8','-3.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9869','Dynasty Spear - Anger','lrhand','true','2010','1','1','mithril','s','307','1','pole','8','-3.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','3012','4','0','0','0','0','0','0','0','0'),
('9870','Dynasty Spear - Critical Stun','lrhand','true','2010','1','1','mithril','s','307','1','pole','8','-3.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','3016','3','0','0','0','0','0','0','0','0'),
('9871','Dynasty Spear - Light','lrhand','true','2010','1','1','mithril','s','307','1','pole','8','-3.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','1257','1','0','0','0','0','0','0','0','0'),
('9448','Dynasty Hammer','rhand','true','1740','1','1','mithril','s','307','1','blunt','4','4.00000','0','0','0','379','0','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9872','Dynasty Hammer - Anger','rhand','true','1740','1','1','mithril','s','307','1','blunt','4','4.00000','0','0','0','379','0','140','-1','0','3500','true','true','true','true','3012','4','0','0','0','0','0','0','0','0'),
('9873','Dynasty Hammer - Health','rhand','true','1740','1','1','mithril','s','307','1','blunt','4','4.00000','0','0','0','379','0','140','-1','0','3500','true','true','true','true','3013','1','0','0','0','0','0','0','0','0'),
('9874','Dynasty Hammer - Risk Focus','rhand','true','1740','1','1','mithril','s','307','1','blunt','4','4.00000','0','0','0','379','0','140','-1','0','3500','true','true','true','true','3027','3','0','0','0','0','0','0','0','0'),
('9449','Dynasty Staff','lrhand','true','1080','1','1','bone','s','299','1','bigblunt','4','4.00000','0','0','0','325','0','186','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9875','Dynasty Staff - Mana Up','lrhand','true','1080','1','1','bone','s','299','1','bigblunt','4','4.00000','0','0','0','325','0','186','-1','0','3500','true','true','true','true','3014','2','0','0','0','0','0','0','0','0'),
('9876','Dynasty Staff - Conversion','lrhand','true','1080','1','1','bone','s','299','1','bigblunt','4','4.00000','0','0','0','325','0','186','-1','0','3500','true','true','true','true','3048','2','0','0','0','0','0','0','0','0'),
('9877','Dynasty Staff - Acumen','lrhand','true','1080','1','1','bone','s','299','1','bigblunt','4','4.00000','0','0','0','325','0','186','-1','0','3500','true','true','true','true','3047','3','0','0','0','0','0','0','0','0'),
('9450','Dynasty Fist','lrhand','true','1550','1','1','adamantaite','s','374','1','dualfist','4','4.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9878','Dynasty Fist - Risk Haste','lrhand','true','1550','1','1','adamantaite','s','374','1','dualfist','4','4.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','3032','2','0','0','0','0','0','0','0','0'),
('9879','Dynasty Fist - Risk Evasion','lrhand','true','1550','1','1','adamantaite','s','374','1','dualfist','4','4.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','3028','2','0','0','0','0','0','0','0','0'),
('9880','Dynasty Fist - Haste','lrhand','true','1550','1','1','adamantaite','s','374','1','dualfist','4','4.00000','0','0','0','325','0','140','-1','0','3500','true','true','true','true','3036','3','0','0','0','0','0','0','0','0'),
('9700','Devil Spear','lrhand','true','1800','1','1','adamantaite','s','334','10','pole','8','-3','0','0','0','325','0','152','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9701','Medusa Blade','rhand','true','1420','2','2','adamantaite','s','325','10','sword','8','0','0','0','0','379','0','152','-1','0','3500','true','true','true','true','3050','1','0','0','0','0','0','0','0','0'),
('9702','Hades Dagger','rhand','true','970','1','1','adamantaite','s','271','5','dagger','12','-3','0','0','0','433','0','148','-1','0','3500','true','true','true','true','3023','3','0','0','0','0','0','0','0','0'),
('9703','Thor Hammer','rhand','true','1730','3','3','adamantaite','s','316','20','blunt','4','4','0','0','0','379','0','149','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9704','Odin Cleaver','rhand','true','1380','1','1','adamantaite','s','381','10','bigsword','8','0','0','0','0','325','0','151','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9705','Artemis Bow','lrhand','true','1650','1','1','adamantaite','s','624','5','bow','12','-3','0','0','0','293','11','147','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9706','Zeus Mace','rhand','true','1300','1','1','adamantaite','s','285','20','blunt','4','4','0','0','0','379','0','202','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9707','Ares Fists','lrhand','true','1350','1','1','adamantaite','s','374','5','dualfist','4','4','0','0','0','352','0','152','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9708','Aphrodite Staff','lrhand','true','930','1','1','adamantaite','s','294','20','blunt','4','4','0','0','0','325','0','208','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('9709','Dual Medusa Blade','lrhand','true','2080','1','1','adamantaite','s','382','10','dual','8','0','0','0','0','325','0','159','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0');
INSERT INTO `weapon` VALUES
('18001','Dynasty Rapier*Dynasty Rapier','lrhand','true','2080','1','1','adamantaite','s','378','40','dual','8','0.00000','0','0','0','325','0','129','-1','78800000','5500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('18002','Dynasty Dagger*Dynasty Dagger','lrhand','true','2080','1','1','adamantaite','s','302','40','dual','8','0.00000','0','0','0','325','0','172','-1','78800000','5500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('18003','Dynasty Blade*Dynasty Blade','lrhand','true','2080','1','1','adamantaite','s','365','40','dual','8','0.00000','0','0','0','325','0','151','-1','78800000','5500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('18004','Dynasty Magic Sword*Dynasty Magic Sword','lrhand','true','2080','1','1','adamantaite','s','332','40','dual','8','0.00000','0','0','0','325','0','220','-1','78800000','5500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('18005','Dynasty Magic Sword*Dynasty Rapier','lrhand','true','2080','1','1','adamantaite','s','378','40','dual','8','0.00000','0','0','0','325','0','220','-1','78800000','5500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),
('18006','Dynasty Blade*Dynasty Magic Sword','lrhand','true','2080','1','1','adamantaite','s','365','40','dual','8','0.00000','0','0','0','325','0','220','-1','78800000','5500','true','true','true','true','0','0','0','0','0','0','0','0','0','0');

Изменено 9 февраля, 2014 пользователем doda

[doda 96]

Пож помогите переделать

[localnet 3]

Пож помогите переделать

скинь любой sql который ты залил в базу

[localnet 3]

если не ошибаюсь то вот так будет правильно

 

 

('9376','Dynasty Rapier','rhand','true','1280','1','1','steel','s','278','1','sword','12','0.00000','0','0','0','433','0','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

 

То что выделено красным удаляешь и заливаешь в базу

[doda 96]

спс

[godzil 0]

я думаю что вот так

('9376','Dynasty Rapier','rhand','true','1280','1','1','steel','s','278','1','sword','12','0.00000','0','0','0','433','0','140','-1','0','3500','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

Изменено 9 февраля, 2014 пользователем godzil