Tuto Para poner peinados y libros en los guardianes

Topic created · 10 Posts · 3762 Views
  • 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);
    
    1. 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....

  • 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.

  • 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

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

  • 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

  • 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.

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

  • pss a mi no m va :T.T:

  • Gracias era justo lo que estaba buscando 🙂 :wiii:

  • 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:

Log in to reply