Tuto Para poner peinados y libros en los guardianes

dantox

1)ir a navicat meterse en player y darle query /new query /y copiar esto

INSERT INTO `shop` VALUES (1021, 'Noname', 20300);
INSERT INTO `shop` VALUES (1022, 'Noname', 20301);
INSERT INTO `shop` VALUES (1023, 'Noname', 20302);
INSERT INTO `shop` VALUES (1024, 'Noname', 20303);
INSERT INTO `shop` VALUES (1025, 'Noname', 20304);
INSERT INTO `shop` VALUES (1026, 'Noname', 20305);
INSERT INTO `shop` VALUES (1027, 'Noname', 20306);
INSERT INTO `shop` VALUES (1028, 'Noname', 20307);
INSERT INTO `shop` VALUES (1031, 'Noname', 20320);
INSERT INTO `shop` VALUES (1032, 'Noname', 20321);
INSERT INTO `shop` VALUES (1033, 'Noname', 20322);
INSERT INTO `shop` VALUES (1034, 'Noname', 20323);
INSERT INTO `shop` VALUES (1035, 'Noname', 20324);
INSERT INTO `shop` VALUES (1036, 'Noname', 20325);
INSERT INTO `shop` VALUES (1037, 'Noname', 20326);
INSERT INTO `shop` VALUES (1038, 'Noname', 20327);
INSERT INTO `shop` VALUES (1041, 'Noname', 20340);
INSERT INTO `shop` VALUES (1042, 'Noname', 20341);
INSERT INTO `shop` VALUES (1043, 'Noname', 20342);
INSERT INTO `shop` VALUES (1044, 'Noname', 20343);
INSERT INTO `shop` VALUES (1045, 'Noname', 20344);
INSERT INTO `shop` VALUES (1046, 'Noname', 20345);
INSERT INTO `shop` VALUES (1047, 'Noname', 20346);
INSERT INTO `shop` VALUES (1048, 'Noname', 20347);

de nuevo new query y copiar esto

INSERT INTO shop_item VALUES (1021, 50401, 1);
INSERT INTO shop_item VALUES (1021, 50402, 1);
INSERT INTO shop_item VALUES (1021, 50403, 1);
INSERT INTO shop_item VALUES (1021, 50404, 1);
INSERT INTO shop_item VALUES (1021, 50405, 1);
INSERT INTO shop_item VALUES (1021, 50513, 1);
INSERT INTO shop_item VALUES (1021, 71001, 200);
INSERT INTO shop_item VALUES (1021, 71094, 200);
INSERT INTO shop_item VALUES (1021, 73001, 1);
INSERT INTO shop_item VALUES (1021, 73002, 1);
INSERT INTO shop_item VALUES (1021, 73003, 1);
INSERT INTO shop_item VALUES (1021, 73004, 1);
INSERT INTO shop_item VALUES (1021, 73005, 1);
INSERT INTO shop_item VALUES (1021, 73006, 1);
INSERT INTO shop_item VALUES (1021, 73007, 1);
INSERT INTO shop_item VALUES (1021, 73008, 1);
INSERT INTO shop_item VALUES (1021, 73009, 1);
INSERT INTO shop_item VALUES (1021, 73010, 1);
INSERT INTO shop_item VALUES (1021, 73011, 1);
INSERT INTO shop_item VALUES (1021, 73012, 1);
INSERT INTO shop_item VALUES (1022, 50416, 1);
INSERT INTO shop_item VALUES (1022, 50417, 1);
INSERT INTO shop_item VALUES (1022, 50418, 1);
INSERT INTO shop_item VALUES (1022, 50419, 1);
INSERT INTO shop_item VALUES (1022, 50420, 1);
INSERT INTO shop_item VALUES (1022, 50513, 1);
INSERT INTO shop_item VALUES (1022, 71001, 200);
INSERT INTO shop_item VALUES (1022, 71094, 200);
INSERT INTO shop_item VALUES (1022, 75001, 1);
INSERT INTO shop_item VALUES (1022, 75002, 1);
INSERT INTO shop_item VALUES (1022, 75003, 1);
INSERT INTO shop_item VALUES (1022, 75004, 1);
INSERT INTO shop_item VALUES (1022, 75005, 1);
INSERT INTO shop_item VALUES (1022, 75006, 1);
INSERT INTO shop_item VALUES (1022, 75007, 1);
INSERT INTO shop_item VALUES (1022, 75008, 1);
INSERT INTO shop_item VALUES (1022, 75009, 1);
INSERT INTO shop_item VALUES (1022, 75010, 1);
INSERT INTO shop_item VALUES (1022, 75011, 1);
INSERT INTO shop_item VALUES (1022, 75012, 1);
INSERT INTO shop_item VALUES (1023, 50431, 1);
INSERT INTO shop_item VALUES (1023, 50432, 1);
INSERT INTO shop_item VALUES (1023, 50433, 1);
INSERT INTO shop_item VALUES (1023, 50434, 1);
INSERT INTO shop_item VALUES (1023, 50435, 1);
INSERT INTO shop_item VALUES (1023, 50513, 1);
INSERT INTO shop_item VALUES (1023, 71001, 200);
INSERT INTO shop_item VALUES (1023, 71094, 200);
INSERT INTO shop_item VALUES (1023, 75201, 1);
INSERT INTO shop_item VALUES (1023, 75202, 1);
INSERT INTO shop_item VALUES (1023, 75203, 1);
INSERT INTO shop_item VALUES (1023, 75204, 1);
INSERT INTO shop_item VALUES (1023, 75205, 1);
INSERT INTO shop_item VALUES (1023, 75206, 1);
INSERT INTO shop_item VALUES (1023, 75207, 1);
INSERT INTO shop_item VALUES (1023, 75208, 1);
INSERT INTO shop_item VALUES (1023, 75209, 1);
INSERT INTO shop_item VALUES (1023, 75210, 1);
INSERT INTO shop_item VALUES (1023, 75211, 1);
INSERT INTO shop_item VALUES (1023, 75212, 1);
INSERT INTO shop_item VALUES (1024, 50446, 1);
INSERT INTO shop_item VALUES (1024, 50447, 1);
INSERT INTO shop_item VALUES (1024, 50448, 1);
INSERT INTO shop_item VALUES (1024, 50449, 1);
INSERT INTO shop_item VALUES (1024, 50450, 1);
INSERT INTO shop_item VALUES (1024, 50513, 1);
INSERT INTO shop_item VALUES (1024, 71001, 200);
INSERT INTO shop_item VALUES (1024, 71094, 200);
INSERT INTO shop_item VALUES (1024, 73251, 1);
INSERT INTO shop_item VALUES (1024, 73252, 1);
INSERT INTO shop_item VALUES (1024, 73253, 1);
INSERT INTO shop_item VALUES (1024, 73254, 1);
INSERT INTO shop_item VALUES (1024, 73255, 1);
INSERT INTO shop_item VALUES (1024, 73256, 1);
INSERT INTO shop_item VALUES (1024, 73257, 1);
INSERT INTO shop_item VALUES (1024, 73258, 1);
INSERT INTO shop_item VALUES (1024, 73259, 1);
INSERT INTO shop_item VALUES (1024, 73260, 1);
INSERT INTO shop_item VALUES (1024, 73261, 1);
INSERT INTO shop_item VALUES (1024, 73262, 1);
INSERT INTO shop_item VALUES (1025, 50461, 1);
INSERT INTO shop_item VALUES (1025, 50462, 1);
INSERT INTO shop_item VALUES (1025, 50463, 1);
INSERT INTO shop_item VALUES (1025, 50464, 1);
INSERT INTO shop_item VALUES (1025, 50465, 1);
INSERT INTO shop_item VALUES (1025, 50466, 1);
INSERT INTO shop_item VALUES (1025, 50513, 1);
INSERT INTO shop_item VALUES (1025, 71001, 200);
INSERT INTO shop_item VALUES (1025, 71094, 200);
INSERT INTO shop_item VALUES (1025, 73501, 1);
INSERT INTO shop_item VALUES (1025, 73502, 1);
INSERT INTO shop_item VALUES (1025, 73503, 1);
INSERT INTO shop_item VALUES (1025, 73504, 1);
INSERT INTO shop_item VALUES (1025, 73505, 1);
INSERT INTO shop_item VALUES (1025, 73506, 1);
INSERT INTO shop_item VALUES (1025, 73507, 1);
INSERT INTO shop_item VALUES (1025, 73508, 1);
INSERT INTO shop_item VALUES (1025, 73509, 1);
INSERT INTO shop_item VALUES (1025, 73510, 1);
INSERT INTO shop_item VALUES (1025, 73511, 1);
INSERT INTO shop_item VALUES (1025, 73512, 1);
INSERT INTO shop_item VALUES (1026, 50476, 1);
INSERT INTO shop_item VALUES (1026, 50477, 1);
INSERT INTO shop_item VALUES (1026, 50478, 1);
INSERT INTO shop_item VALUES (1026, 50479, 1);
INSERT INTO shop_item VALUES (1026, 50480, 1);
INSERT INTO shop_item VALUES (1026, 50481, 1);
INSERT INTO shop_item VALUES (1026, 50513, 1);
INSERT INTO shop_item VALUES (1026, 71001, 200);
INSERT INTO shop_item VALUES (1026, 71094, 200);
INSERT INTO shop_item VALUES (1026, 75401, 1);
INSERT INTO shop_item VALUES (1026, 75402, 1);
INSERT INTO shop_item VALUES (1026, 75403, 1);
INSERT INTO shop_item VALUES (1026, 75404, 1);
INSERT INTO shop_item VALUES (1026, 75405, 1);
INSERT INTO shop_item VALUES (1026, 75406, 1);
INSERT INTO shop_item VALUES (1026, 75407, 1);
INSERT INTO shop_item VALUES (1026, 75408, 1);
INSERT INTO shop_item VALUES (1026, 75409, 1);
INSERT INTO shop_item VALUES (1026, 75410, 1);
INSERT INTO shop_item VALUES (1026, 75411, 1);
INSERT INTO shop_item VALUES (1026, 75412, 1);
INSERT INTO shop_item VALUES (1027, 50491, 1);
INSERT INTO shop_item VALUES (1027, 50492, 1);
INSERT INTO shop_item VALUES (1027, 50493, 1);
INSERT INTO shop_item VALUES (1027, 50494, 1);
INSERT INTO shop_item VALUES (1027, 50495, 1);
INSERT INTO shop_item VALUES (1027, 50496, 1);
INSERT INTO shop_item VALUES (1027, 50513, 1);
INSERT INTO shop_item VALUES (1027, 71001, 200);
INSERT INTO shop_item VALUES (1027, 71094, 200);
INSERT INTO shop_item VALUES (1027, 75601, 1);
INSERT INTO shop_item VALUES (1027, 75602, 1);
INSERT INTO shop_item VALUES (1027, 75603, 1);
INSERT INTO shop_item VALUES (1027, 75604, 1);
INSERT INTO shop_item VALUES (1027, 75605, 1);
INSERT INTO shop_item VALUES (1027, 75606, 1);
INSERT INTO shop_item VALUES (1027, 75607, 1);
INSERT INTO shop_item VALUES (1027, 75608, 1);
INSERT INTO shop_item VALUES (1027, 75609, 1);
INSERT INTO shop_item VALUES (1027, 75610, 1);
INSERT INTO shop_item VALUES (1027, 75611, 1);
INSERT INTO shop_item VALUES (1027, 75612, 1);
INSERT INTO shop_item VALUES (1028, 50506, 1);
INSERT INTO shop_item VALUES (1028, 50507, 1);
INSERT INTO shop_item VALUES (1028, 50508, 1);
INSERT INTO shop_item VALUES (1028, 50509, 1);
INSERT INTO shop_item VALUES (1028, 50510, 1);
INSERT INTO shop_item VALUES (1028, 50511, 1);
INSERT INTO shop_item VALUES (1028, 50513, 1);
INSERT INTO shop_item VALUES (1028, 71001, 200);
INSERT INTO shop_item VALUES (1028, 71094, 200);
INSERT INTO shop_item VALUES (1028, 73751, 1);
INSERT INTO shop_item VALUES (1028, 73752, 1);
INSERT INTO shop_item VALUES (1028, 73753, 1);
INSERT INTO shop_item VALUES (1028, 73754, 1);
INSERT INTO shop_item VALUES (1028, 73755, 1);
INSERT INTO shop_item VALUES (1028, 73756, 1);
INSERT INTO shop_item VALUES (1028, 73757, 1);
INSERT INTO shop_item VALUES (1028, 73758, 1);
INSERT INTO shop_item VALUES (1028, 73759, 1);
INSERT INTO shop_item VALUES (1028, 73760, 1);
INSERT INTO shop_item VALUES (1028, 73761, 1);
INSERT INTO shop_item VALUES (1028, 73762, 1);
INSERT INTO shop_item VALUES (1030, 11256, 1);
INSERT INTO shop_item VALUES (1030, 11456, 1);
INSERT INTO shop_item VALUES (1030, 11656, 1);
INSERT INTO shop_item VALUES (1030, 11856, 1);
INSERT INTO shop_item VALUES (1030, 27102, 200);
INSERT INTO shop_item VALUES (1030, 27105, 200);
INSERT INTO shop_item VALUES (1030, 50052, 1);
INSERT INTO shop_item VALUES (1030, 50053, 1);
INSERT INTO shop_item VALUES (1030, 70038, 200);
INSERT INTO shop_item VALUES (1030, 71095, 5);
INSERT INTO shop_item VALUES (1031, 50401, 1);
INSERT INTO shop_item VALUES (1031, 50402, 1);
INSERT INTO shop_item VALUES (1031, 50403, 1);
INSERT INTO shop_item VALUES (1031, 50404, 1);
INSERT INTO shop_item VALUES (1031, 50405, 1);
INSERT INTO shop_item VALUES (1031, 50513, 1);
INSERT INTO shop_item VALUES (1031, 71001, 200);
INSERT INTO shop_item VALUES (1031, 71094, 200);
INSERT INTO shop_item VALUES (1031, 73001, 1);
INSERT INTO shop_item VALUES (1031, 73002, 1);
INSERT INTO shop_item VALUES (1031, 73003, 1);
INSERT INTO shop_item VALUES (1031, 73004, 1);
INSERT INTO shop_item VALUES (1031, 73005, 1);
INSERT INTO shop_item VALUES (1031, 73006, 1);
INSERT INTO shop_item VALUES (1031, 73007, 1);
INSERT INTO shop_item VALUES (1031, 73008, 1);
INSERT INTO shop_item VALUES (1031, 73009, 1);
INSERT INTO shop_item VALUES (1031, 73010, 1);
INSERT INTO shop_item VALUES (1031, 73011, 1);
INSERT INTO shop_item VALUES (1031, 73012, 1);
INSERT INTO shop_item VALUES (1032, 50416, 1);
INSERT INTO shop_item VALUES (1032, 50417, 1);
INSERT INTO shop_item VALUES (1032, 50418, 1);
INSERT INTO shop_item VALUES (1032, 50419, 1);
INSERT INTO shop_item VALUES (1032, 50420, 1);
INSERT INTO shop_item VALUES (1032, 50513, 1);
INSERT INTO shop_item VALUES (1032, 71001, 200);
INSERT INTO shop_item VALUES (1032, 71094, 200);
INSERT INTO shop_item VALUES (1032, 75001, 1);
INSERT INTO shop_item VALUES (1032, 75002, 1);
INSERT INTO shop_item VALUES (1032, 75003, 1);
INSERT INTO shop_item VALUES (1032, 75004, 1);
INSERT INTO shop_item VALUES (1032, 75005, 1);
INSERT INTO shop_item VALUES (1032, 75006, 1);
INSERT INTO shop_item VALUES (1032, 75007, 1);
INSERT INTO shop_item VALUES (1032, 75008, 1);
INSERT INTO shop_item VALUES (1032, 75009, 1);
INSERT INTO shop_item VALUES (1032, 75010, 1);
INSERT INTO shop_item VALUES (1032, 75011, 1);
INSERT INTO shop_item VALUES (1032, 75012, 1);
INSERT INTO shop_item VALUES (1033, 50431, 1);
INSERT INTO shop_item VALUES (1033, 50432, 1);
INSERT INTO shop_item VALUES (1033, 50433, 1);
INSERT INTO shop_item VALUES (1033, 50434, 1);
INSERT INTO shop_item VALUES (1033, 50435, 1);
INSERT INTO shop_item VALUES (1033, 50513, 1);
INSERT INTO shop_item VALUES (1033, 71001, 200);
INSERT INTO shop_item VALUES (1033, 71094, 200);
INSERT INTO shop_item VALUES (1033, 75201, 1);
INSERT INTO shop_item VALUES (1033, 75202, 1);
INSERT INTO shop_item VALUES (1033, 75203, 1);
INSERT INTO shop_item VALUES (1033, 75204, 1);
INSERT INTO shop_item VALUES (1033, 75205, 1);
INSERT INTO shop_item VALUES (1033, 75206, 1);
INSERT INTO shop_item VALUES (1033, 75207, 1);
INSERT INTO shop_item VALUES (1033, 75208, 1);
INSERT INTO shop_item VALUES (1033, 75209, 1);
INSERT INTO shop_item VALUES (1033, 75210, 1);
INSERT INTO shop_item VALUES (1033, 75211, 1);
INSERT INTO shop_item VALUES (1033, 75212, 1);
INSERT INTO shop_item VALUES (1034, 50446, 1);
INSERT INTO shop_item VALUES (1034, 50447, 1);
INSERT INTO shop_item VALUES (1034, 50448, 1);
INSERT INTO shop_item VALUES (1034, 50449, 1);
INSERT INTO shop_item VALUES (1034, 50450, 1);
INSERT INTO shop_item VALUES (1034, 50513, 1);
INSERT INTO shop_item VALUES (1034, 71001, 200);
INSERT INTO shop_item VALUES (1034, 71094, 200);
INSERT INTO shop_item VALUES (1034, 73251, 1);
INSERT INTO shop_item VALUES (1034, 73252, 1);
INSERT INTO shop_item VALUES (1034, 73253, 1);
INSERT INTO shop_item VALUES (1034, 73254, 1);
INSERT INTO shop_item VALUES (1034, 73255, 1);
INSERT INTO shop_item VALUES (1034, 73256, 1);
INSERT INTO shop_item VALUES (1034, 73257, 1);
INSERT INTO shop_item VALUES (1034, 73258, 1);
INSERT INTO shop_item VALUES (1034, 73259, 1);
INSERT INTO shop_item VALUES (1034, 73260, 1);
INSERT INTO shop_item VALUES (1034, 73261, 1);
INSERT INTO shop_item VALUES (1034, 73262, 1);
INSERT INTO shop_item VALUES (1035, 50461, 1);
INSERT INTO shop_item VALUES (1035, 50462, 1);
INSERT INTO shop_item VALUES (1035, 50463, 1);
INSERT INTO shop_item VALUES (1035, 50464, 1);
INSERT INTO shop_item VALUES (1035, 50465, 1);
INSERT INTO shop_item VALUES (1035, 50466, 1);
INSERT INTO shop_item VALUES (1035, 50513, 1);
INSERT INTO shop_item VALUES (1035, 71001, 200);
INSERT INTO shop_item VALUES (1035, 71094, 200);
INSERT INTO shop_item VALUES (1035, 73501, 1);
INSERT INTO shop_item VALUES (1035, 73502, 1);
INSERT INTO shop_item VALUES (1035, 73503, 1);
INSERT INTO shop_item VALUES (1035, 73504, 1);
INSERT INTO shop_item VALUES (1035, 73505, 1);
INSERT INTO shop_item VALUES (1035, 73506, 1);
INSERT INTO shop_item VALUES (1035, 73507, 1);
INSERT INTO shop_item VALUES (1035, 73508, 1);
INSERT INTO shop_item VALUES (1035, 73509, 1);
INSERT INTO shop_item VALUES (1035, 73510, 1);
INSERT INTO shop_item VALUES (1035, 73511, 1);
INSERT INTO shop_item VALUES (1035, 73512, 1);
INSERT INTO shop_item VALUES (1036, 50476, 1);
INSERT INTO shop_item VALUES (1036, 50477, 1);
INSERT INTO shop_item VALUES (1036, 50478, 1);
INSERT INTO shop_item VALUES (1036, 50479, 1);
INSERT INTO shop_item VALUES (1036, 50480, 1);
INSERT INTO shop_item VALUES (1036, 50481, 1);
INSERT INTO shop_item VALUES (1036, 50513, 1);
INSERT INTO shop_item VALUES (1036, 71001, 200);
INSERT INTO shop_item VALUES (1036, 71094, 200);
INSERT INTO shop_item VALUES (1036, 75401, 1);
INSERT INTO shop_item VALUES (1036, 75402, 1);
INSERT INTO shop_item VALUES (1036, 75403, 1);
INSERT INTO shop_item VALUES (1036, 75404, 1);
INSERT INTO shop_item VALUES (1036, 75405, 1);
INSERT INTO shop_item VALUES (1036, 75406, 1);
INSERT INTO shop_item VALUES (1036, 75407, 1);
INSERT INTO shop_item VALUES (1036, 75408, 1);
INSERT INTO shop_item VALUES (1036, 75409, 1);
INSERT INTO shop_item VALUES (1036, 75410, 1);
INSERT INTO shop_item VALUES (1036, 75411, 1);
INSERT INTO shop_item VALUES (1036, 75412, 1);
INSERT INTO shop_item VALUES (1037, 50491, 1);
INSERT INTO shop_item VALUES (1037, 50492, 1);
INSERT INTO shop_item VALUES (1037, 50493, 1);
INSERT INTO shop_item VALUES (1037, 50494, 1);
INSERT INTO shop_item VALUES (1037, 50495, 1);
INSERT INTO shop_item VALUES (1037, 50496, 1);
INSERT INTO shop_item VALUES (1037, 50513, 1);
INSERT INTO shop_item VALUES (1037, 71001, 200);
INSERT INTO shop_item VALUES (1037, 71094, 200);
INSERT INTO shop_item VALUES (1037, 75601, 1);
INSERT INTO shop_item VALUES (1037, 75602, 1);
INSERT INTO shop_item VALUES (1037, 75603, 1);
INSERT INTO shop_item VALUES (1037, 75604, 1);
INSERT INTO shop_item VALUES (1037, 75605, 1);
INSERT INTO shop_item VALUES (1037, 75606, 1);
INSERT INTO shop_item VALUES (1037, 75607, 1);
INSERT INTO shop_item VALUES (1037, 75608, 1);
INSERT INTO shop_item VALUES (1037, 75609, 1);
INSERT INTO shop_item VALUES (1037, 75610, 1);
INSERT INTO shop_item VALUES (1037, 75611, 1);
INSERT INTO shop_item VALUES (1037, 75612, 1);
INSERT INTO shop_item VALUES (1038, 50506, 1);
INSERT INTO shop_item VALUES (1038, 50507, 1);
INSERT INTO shop_item VALUES (1038, 50508, 1);
INSERT INTO shop_item VALUES (1038, 50509, 1);
INSERT INTO shop_item VALUES (1038, 50510, 1);
INSERT INTO shop_item VALUES (1038, 50511, 1);
INSERT INTO shop_item VALUES (1038, 50513, 1);
INSERT INTO shop_item VALUES (1038, 71001, 200);
INSERT INTO shop_item VALUES (1038, 71094, 200);
INSERT INTO shop_item VALUES (1038, 73751, 1);
INSERT INTO shop_item VALUES (1038, 73752, 1);
INSERT INTO shop_item VALUES (1038, 73753, 1);
INSERT INTO shop_item VALUES (1038, 73754, 1);
INSERT INTO shop_item VALUES (1038, 73755, 1);
INSERT INTO shop_item VALUES (1038, 73756, 1);
INSERT INTO shop_item VALUES (1038, 73757, 1);
INSERT INTO shop_item VALUES (1038, 73758, 1);
INSERT INTO shop_item VALUES (1038, 73759, 1);
INSERT INTO shop_item VALUES (1038, 73760, 1);
INSERT INTO shop_item VALUES (1038, 73761, 1);
INSERT INTO shop_item VALUES (1038, 73762, 1);
INSERT INTO shop_item VALUES (1040, 11256, 1);
INSERT INTO shop_item VALUES (1040, 11456, 1);
INSERT INTO shop_item VALUES (1040, 11656, 1);
INSERT INTO shop_item VALUES (1040, 11856, 1);
INSERT INTO shop_item VALUES (1040, 27102, 200);
INSERT INTO shop_item VALUES (1040, 27105, 200);
INSERT INTO shop_item VALUES (1040, 50052, 1);
INSERT INTO shop_item VALUES (1040, 50053, 1);
INSERT INTO shop_item VALUES (1040, 70038, 200);
INSERT INTO shop_item VALUES (1040, 71095, 5);
INSERT INTO shop_item VALUES (1041, 50401, 1);
INSERT INTO shop_item VALUES (1041, 50402, 1);
INSERT INTO shop_item VALUES (1041, 50403, 1);
INSERT INTO shop_item VALUES (1041, 50404, 1);
INSERT INTO shop_item VALUES (1041, 50405, 1);
INSERT INTO shop_item VALUES (1041, 50513, 1);
INSERT INTO shop_item VALUES (1041, 71001, 200);
INSERT INTO shop_item VALUES (1041, 71094, 200);
INSERT INTO shop_item VALUES (1041, 73001, 1);
INSERT INTO shop_item VALUES (1041, 73002, 1);
INSERT INTO shop_item VALUES (1041, 73003, 1);
INSERT INTO shop_item VALUES (1041, 73004, 1);
INSERT INTO shop_item VALUES (1041, 73005, 1);
INSERT INTO shop_item VALUES (1041, 73006, 1);
INSERT INTO shop_item VALUES (1041, 73007, 1);
INSERT INTO shop_item VALUES (1041, 73008, 1);
INSERT INTO shop_item VALUES (1041, 73009, 1);
INSERT INTO shop_item VALUES (1041, 73010, 1);
INSERT INTO shop_item VALUES (1041, 73011, 1);
INSERT INTO shop_item VALUES (1041, 73012, 1);
INSERT INTO shop_item VALUES (1042, 50416, 1);
INSERT INTO shop_item VALUES (1042, 50417, 1);
INSERT INTO shop_item VALUES (1042, 50418, 1);
INSERT INTO shop_item VALUES (1042, 50419, 1);
INSERT INTO shop_item VALUES (1042, 50420, 1);
INSERT INTO shop_item VALUES (1042, 50513, 1);
INSERT INTO shop_item VALUES (1042, 71001, 200);
INSERT INTO shop_item VALUES (1042, 71094, 200);
INSERT INTO shop_item VALUES (1042, 75001, 1);
INSERT INTO shop_item VALUES (1042, 75002, 1);
INSERT INTO shop_item VALUES (1042, 75003, 1);
INSERT INTO shop_item VALUES (1042, 75004, 1);
INSERT INTO shop_item VALUES (1042, 75005, 1);
INSERT INTO shop_item VALUES (1042, 75006, 1);
INSERT INTO shop_item VALUES (1042, 75007, 1);
INSERT INTO shop_item VALUES (1042, 75008, 1);
INSERT INTO shop_item VALUES (1042, 75009, 1);
INSERT INTO shop_item VALUES (1042, 75010, 1);
INSERT INTO shop_item VALUES (1042, 75011, 1);
INSERT INTO shop_item VALUES (1042, 75012, 1);
INSERT INTO shop_item VALUES (1043, 50431, 1);
INSERT INTO shop_item VALUES (1043, 50432, 1);
INSERT INTO shop_item VALUES (1043, 50433, 1);
INSERT INTO shop_item VALUES (1043, 50434, 1);
INSERT INTO shop_item VALUES (1043, 50435, 1);
INSERT INTO shop_item VALUES (1043, 50513, 1);
INSERT INTO shop_item VALUES (1043, 71001, 200);
INSERT INTO shop_item VALUES (1043, 71094, 200);
INSERT INTO shop_item VALUES (1043, 75201, 1);
INSERT INTO shop_item VALUES (1043, 75202, 1);
INSERT INTO shop_item VALUES (1043, 75203, 1);
INSERT INTO shop_item VALUES (1043, 75204, 1);
INSERT INTO shop_item VALUES (1043, 75205, 1);
INSERT INTO shop_item VALUES (1043, 75206, 1);
INSERT INTO shop_item VALUES (1043, 75207, 1);
INSERT INTO shop_item VALUES (1043, 75208, 1);
INSERT INTO shop_item VALUES (1043, 75209, 1);
INSERT INTO shop_item VALUES (1043, 75210, 1);
INSERT INTO shop_item VALUES (1043, 75211, 1);
INSERT INTO shop_item VALUES (1043, 75212, 1);
INSERT INTO shop_item VALUES (1044, 50446, 1);
INSERT INTO shop_item VALUES (1044, 50447, 1);
INSERT INTO shop_item VALUES (1044, 50448, 1);
INSERT INTO shop_item VALUES (1044, 50449, 1);
INSERT INTO shop_item VALUES (1044, 50450, 1);
INSERT INTO shop_item VALUES (1044, 50513, 1);
INSERT INTO shop_item VALUES (1044, 71001, 200);
INSERT INTO shop_item VALUES (1044, 71094, 200);
INSERT INTO shop_item VALUES (1044, 73251, 1);
INSERT INTO shop_item VALUES (1044, 73252, 1);
INSERT INTO shop_item VALUES (1044, 73253, 1);
INSERT INTO shop_item VALUES (1044, 73254, 1);
INSERT INTO shop_item VALUES (1044, 73255, 1);
INSERT INTO shop_item VALUES (1044, 73256, 1);
INSERT INTO shop_item VALUES (1044, 73257, 1);
INSERT INTO shop_item VALUES (1044, 73258, 1);
INSERT INTO shop_item VALUES (1044, 73259, 1);
INSERT INTO shop_item VALUES (1044, 73260, 1);
INSERT INTO shop_item VALUES (1044, 73261, 1);
INSERT INTO shop_item VALUES (1044, 73262, 1);
INSERT INTO shop_item VALUES (1045, 50461, 1);
INSERT INTO shop_item VALUES (1045, 50462, 1);
INSERT INTO shop_item VALUES (1045, 50463, 1);
INSERT INTO shop_item VALUES (1045, 50464, 1);
INSERT INTO shop_item VALUES (1045, 50465, 1);
INSERT INTO shop_item VALUES (1045, 50466, 1);
INSERT INTO shop_item VALUES (1045, 50513, 1);
INSERT INTO shop_item VALUES (1045, 71001, 200);
INSERT INTO shop_item VALUES (1045, 71094, 200);
INSERT INTO shop_item VALUES (1045, 73501, 1);
INSERT INTO shop_item VALUES (1045, 73502, 1);
INSERT INTO shop_item VALUES (1045, 73503, 1);
INSERT INTO shop_item VALUES (1045, 73504, 1);
INSERT INTO shop_item VALUES (1045, 73505, 1);
INSERT INTO shop_item VALUES (1045, 73506, 1);
INSERT INTO shop_item VALUES (1045, 73507, 1);
INSERT INTO shop_item VALUES (1045, 73508, 1);
INSERT INTO shop_item VALUES (1045, 73509, 1);
INSERT INTO shop_item VALUES (1045, 73510, 1);
INSERT INTO shop_item VALUES (1045, 73511, 1);
INSERT INTO shop_item VALUES (1045, 73512, 1);
INSERT INTO shop_item VALUES (1046, 50476, 1);
INSERT INTO shop_item VALUES (1046, 50477, 1);
INSERT INTO shop_item VALUES (1046, 50478, 1);
INSERT INTO shop_item VALUES (1046, 50479, 1);
INSERT INTO shop_item VALUES (1046, 50480, 1);
INSERT INTO shop_item VALUES (1046, 50481, 1);
INSERT INTO shop_item VALUES (1046, 50513, 1);
INSERT INTO shop_item VALUES (1046, 71001, 200);
INSERT INTO shop_item VALUES (1046, 71094, 200);
INSERT INTO shop_item VALUES (1046, 75401, 1);
INSERT INTO shop_item VALUES (1046, 75402, 1);
INSERT INTO shop_item VALUES (1046, 75403, 1);
INSERT INTO shop_item VALUES (1046, 75404, 1);
INSERT INTO shop_item VALUES (1046, 75405, 1);
INSERT INTO shop_item VALUES (1046, 75406, 1);
INSERT INTO shop_item VALUES (1046, 75407, 1);
INSERT INTO shop_item VALUES (1046, 75408, 1);
INSERT INTO shop_item VALUES (1046, 75409, 1);
INSERT INTO shop_item VALUES (1046, 75410, 1);
INSERT INTO shop_item VALUES (1046, 75411, 1);
INSERT INTO shop_item VALUES (1046, 75412, 1);
INSERT INTO shop_item VALUES (1047, 50491, 1);
INSERT INTO shop_item VALUES (1047, 50492, 1);
INSERT INTO shop_item VALUES (1047, 50493, 1);
INSERT INTO shop_item VALUES (1047, 50494, 1);
INSERT INTO shop_item VALUES (1047, 50495, 1);
INSERT INTO shop_item VALUES (1047, 50496, 1);
INSERT INTO shop_item VALUES (1047, 50513, 1);
INSERT INTO shop_item VALUES (1047, 71001, 200);
INSERT INTO shop_item VALUES (1047, 71094, 200);
INSERT INTO shop_item VALUES (1047, 75601, 1);
INSERT INTO shop_item VALUES (1047, 75602, 1);
INSERT INTO shop_item VALUES (1047, 75603, 1);
INSERT INTO shop_item VALUES (1047, 75604, 1);
INSERT INTO shop_item VALUES (1047, 75605, 1);
INSERT INTO shop_item VALUES (1047, 75606, 1);
INSERT INTO shop_item VALUES (1047, 75607, 1);
INSERT INTO shop_item VALUES (1047, 75608, 1);
INSERT INTO shop_item VALUES (1047, 75609, 1);
INSERT INTO shop_item VALUES (1047, 75610, 1);
INSERT INTO shop_item VALUES (1047, 75611, 1);
INSERT INTO shop_item VALUES (1047, 75612, 1);
INSERT INTO shop_item VALUES (1048, 50506, 1);
INSERT INTO shop_item VALUES (1048, 50507, 1);
INSERT INTO shop_item VALUES (1048, 50508, 1);
INSERT INTO shop_item VALUES (1048, 50509, 1);
INSERT INTO shop_item VALUES (1048, 50510, 1);
INSERT INTO shop_item VALUES (1048, 50511, 1);
INSERT INTO shop_item VALUES (1048, 50513, 1);
INSERT INTO shop_item VALUES (1048, 71001, 200);
INSERT INTO shop_item VALUES (1048, 71094, 200);
INSERT INTO shop_item VALUES (1048, 73751, 1);
INSERT INTO shop_item VALUES (1048, 73752, 1);
INSERT INTO shop_item VALUES (1048, 73753, 1);
INSERT INTO shop_item VALUES (1048, 73754, 1);
INSERT INTO shop_item VALUES (1048, 73755, 1);
INSERT INTO shop_item VALUES (1048, 73756, 1);
INSERT INTO shop_item VALUES (1048, 73757, 1);
INSERT INTO shop_item VALUES (1048, 73758, 1);
INSERT INTO shop_item VALUES (1048, 73759, 1);
INSERT INTO shop_item VALUES (1048, 73760, 1);
INSERT INTO shop_item VALUES (1048, 73761, 1);
INSERT INTO shop_item VALUES (1048, 73762, 1);
INSERT INTO shop_item VALUES (3169, 50053, 1);

Ir a mob_proto y buskar npc 20300 a 20347 y en la columna k dice oneclick y cambiarle el 2 por 1

No c si ya estaba Pero aki la puseee todavia soy n00b

PD: los peinados estan sin poder osea no ay peinados con 10% contra....

Aquiles94

pues yo no lo habia viso posteado, y aunque es algo que ya muchos debemos saber nunca esta demastener la guía para los que no sepan.

Mikikiller

hoy me estais alegrando el dia eh?? xDDDDD

Aportazo, por lo menos es lo que yo mas queria cuando tenía el servidor, me va a servir mucho, y aprovecho para deciros que esto tambien sierve para poner otros items, que yo tambien le quería poner armas xDDDDDD

leandro4578

bueno pues empezaste super bien gracias men muy buena guia!!!

Zed

esto lo hacia yo, en ves de modificar manualmente la tabla creaba querys ya que me resultaba mas facil xD

P.D: esto es super super antiguo solo que nadie lo habia posteado, pero por lo menos pon creditos, nose de donde lo habras sacado, ya que es tan viejo que esta en epvp,inforge,UG,turkmmo, GFO, etc..

P.D: si alguien quiere los comandos de los peinados con defensa contra las razas aqui se los dejo
74001
74002
74003
74004
74005
74006
74007
74008
74009
74010
74011
74012
74251
74252
74253
74254
74255
74256
74257
74258
74259
74260
74261
74262
74501
74502
74503
74504
74505
74506
74507
74508
74509
74510
74511
74512
74751
74752
74753
74754
74755
74756
74757
74758
74759
74760
74761
74762
75001
75002
75003
75004
75005
75006
75007
75008
75009
75010
75011
75012
75201
75202
75203
75204
75205
75206
75207
75208
75209
75210
75211
75212
75401
75402
75403
75404
75405
75406
75407
75408
75409
75410
75411
75412
75601
75602
75603
75604
75605
75606
75607
75608
75609
75610
75611
75612

Danibonilla1

Esta muy bien, pero como dijo DjZed, ya lo he visto implementado en unos cuantos servers, pero con un intermediario de una quest por medio, es decir, que te da a elegir, peinado, o libros.

lucasman99

Esto es super util i tambien me dava palo ir al google traductor a traducir gracias de todsa formas +1 ,pero pon la fuente

cojonudo

pss a mi no m va :T.T:

PoseidonMt2Kill

Gracias era justo lo que estaba buscando :wiii:

Joakin47

Aportazo ahora no lo nesesito porq tengo el files de ahynoa pero cuando empiese a hacer un server sin hamachi con files 2011 te dare las gracias...Ah nadie se lo ubiera ocurrido,pero a muxos nos servira (me incluyo) :charm: