![[Release] UppItemShop Querry](https://www.elitepvpers.com/forum/iconimages/metin2-pserver-guides-strategies/release-uppitemshop-querry_ltr.gif){kind=small}
Keine Lust alle Items in Navicat einzutragen?
Hier ist die Lösung!
(Die Shops "18" und "19" müsst ihr manuell ändern)
Shop 1:
PHP Code:
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30003', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30004', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30005', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30006', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30077', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30007', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30076', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30008', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30078', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30009', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30083', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30010', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30071', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30011', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30015', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30086', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30014', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30089', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30016', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30087', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30017', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30019', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30020', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30021', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30022', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30082', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30023', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30024', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30025', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30026', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30027', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30070', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30028', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30069', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30029', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30030', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30031', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30032', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30074', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18', '30033', '2');
PHP Code:
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30034', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30073', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30035', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30036', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30037', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30038', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30039', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30085', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30040', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30041', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30075', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30042', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30045', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30046', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30081', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30044', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30043', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30047', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30080', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30048', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30088', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30049', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30050', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30090', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30051', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30084', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30052', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30053', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30072', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30055', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30056', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30057', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30058', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30059', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30060', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30061', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30139', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30091', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30092', '2');
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19', '30063', '2');
xkamarun
