[Chaosua]

Сообщение от YuruY

Нужно на форум кидать, чтоб другим не парится с темже.

я могу сделать выборку по спеллам с флагом 1, там будут те что в базе давно + те что я поправил с 0 на 1, иначе никак, фильтровать мне влом

Вышло не много, у кого есть желание сравните с чистой БД и удалите лишние запросы

REPLACE INTO `waypoint_scripts` VALUES (233, 0, 15, 55244, 1, 0, 0, 0, 0, 0, 875);
REPLACE INTO `waypoint_scripts` VALUES (234, 0, 15, 55244, 1, 0, 0, 0, 0, 0, 876);
REPLACE INTO `waypoint_scripts` VALUES (235, 0, 15, 55244, 1, 0, 0, 0, 0, 0, 877);
REPLACE INTO `waypoint_scripts` VALUES (342, 0, 15, 29122, 1, 0, 0, 0, 0, 0, 878);
REPLACE INTO `waypoint_scripts` VALUES (343, 0, 15, 29122, 1, 0, 0, 0, 0, 0, 879);
REPLACE INTO `waypoint_scripts` VALUES (344, 0, 15, 29122, 1, 0, 0, 0, 0, 0, 880);
REPLACE INTO `waypoint_scripts` VALUES (345, 0, 15, 29122, 1, 0, 0, 0, 0, 0, 881);
REPLACE INTO `waypoint_scripts` VALUES (346, 0, 15, 29122, 1, 0, 0, 0, 0, 0, 882);
REPLACE INTO `waypoint_scripts` VALUES (347, 0, 15, 29120, 1, 0, 0, 0, 0, 0, 883);
REPLACE INTO `waypoint_scripts` VALUES (348, 0, 15, 29120, 1, 0, 0, 0, 0, 0, 884);
REPLACE INTO `waypoint_scripts` VALUES (349, 0, 15, 29120, 1, 0, 0, 0, 0, 0, 885);
REPLACE INTO `waypoint_scripts` VALUES (350, 0, 15, 29120, 1, 0, 0, 0, 0, 0, 886);
REPLACE INTO `waypoint_scripts` VALUES (361, 0, 15, 8293, 1, 0, 0, 0, 0, 0, 887);
REPLACE INTO `waypoint_scripts` VALUES (365, 0, 15, 8293, 1, 0, 0, 0, 0, 0, 888);
REPLACE INTO `waypoint_scripts` VALUES (374, 0, 15, 8293, 1, 0, 0, 0, 0, 0, 889);
REPLACE INTO `waypoint_scripts` VALUES (383, 0, 15, 8293, 1, 0, 0, 0, 0, 0, 890);
REPLACE INTO `waypoint_scripts` VALUES (407, 0, 15, 29121, 1, 0, 0, 0, 0, 0, 891);
REPLACE INTO `waypoint_scripts` VALUES (408, 0, 15, 29121, 1, 0, 0, 0, 0, 0, 892);
REPLACE INTO `waypoint_scripts` VALUES (409, 0, 15, 29121, 1, 0, 0, 0, 0, 0, 893);
REPLACE INTO `waypoint_scripts` VALUES (410, 0, 15, 29121, 1, 0, 0, 0, 0, 0, 894);
REPLACE INTO `waypoint_scripts` VALUES (411, 0, 15, 29121, 1, 0, 0, 0, 0, 0, 895);
REPLACE INTO `waypoint_scripts` VALUES (509, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 898);
REPLACE INTO `waypoint_scripts` VALUES (510, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 899);
REPLACE INTO `waypoint_scripts` VALUES (511, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 900);
REPLACE INTO `waypoint_scripts` VALUES (512, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 901);
REPLACE INTO `waypoint_scripts` VALUES (513, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 902);
REPLACE INTO `waypoint_scripts` VALUES (514, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 903);
REPLACE INTO `waypoint_scripts` VALUES (515, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 904);
REPLACE INTO `waypoint_scripts` VALUES (516, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 905);
REPLACE INTO `waypoint_scripts` VALUES (517, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 906);
REPLACE INTO `waypoint_scripts` VALUES (518, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 907);
REPLACE INTO `waypoint_scripts` VALUES (519, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 908);
REPLACE INTO `waypoint_scripts` VALUES (520, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 909);
REPLACE INTO `waypoint_scripts` VALUES (521, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 910);
REPLACE INTO `waypoint_scripts` VALUES (522, 0, 15, 33808, 1, 0, 0, 0, 0, 0, 911);
REPLACE INTO `waypoint_scripts` VALUES (523, 0, 15, 33806, 1, 0, 0, 0, 0, 0, 912);
REPLACE INTO `waypoint_scripts` VALUES (524, 0, 15, 33806, 1, 0, 0, 0, 0, 0, 913);
REPLACE INTO `waypoint_scripts` VALUES (525, 0, 15, 33806, 1, 0, 0, 0, 0, 0, 914);
REPLACE INTO `waypoint_scripts` VALUES (526, 0, 15, 33806, 1, 0, 0, 0, 0, 0, 915);
REPLACE INTO `waypoint_scripts` VALUES (527, 0, 15, 33805, 1, 0, 0, 0, 0, 0, 916);
REPLACE INTO `waypoint_scripts` VALUES (528, 0, 15, 33805, 1, 0, 0, 0, 0, 0, 917);
REPLACE INTO `waypoint_scripts` VALUES (529, 0, 15, 33805, 1, 0, 0, 0, 0, 0, 918);
REPLACE INTO `waypoint_scripts` VALUES (593, 0, 15, 51256, 1, 0, 0, 0, 0, 0, 923);
REPLACE INTO `waypoint_scripts` VALUES (650, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 924);
REPLACE INTO `waypoint_scripts` VALUES (651, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 925);
REPLACE INTO `waypoint_scripts` VALUES (652, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 926);
REPLACE INTO `waypoint_scripts` VALUES (653, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 927);
REPLACE INTO `waypoint_scripts` VALUES (654, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 928);
REPLACE INTO `waypoint_scripts` VALUES (655, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 929);
REPLACE INTO `waypoint_scripts` VALUES (656, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 930);
REPLACE INTO `waypoint_scripts` VALUES (657, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 931);
REPLACE INTO `waypoint_scripts` VALUES (658, 0, 15, 51616, 1, 0, 0, 0, 0, 0, 932);
REPLACE INTO `waypoint_scripts` VALUES (659, 0, 15, 51616, 1, 0, 0, 0, 0, 0, 933);
REPLACE INTO `waypoint_scripts` VALUES (660, 0, 15, 51616, 1, 0, 0, 0, 0, 0, 934);
REPLACE INTO `waypoint_scripts` VALUES (661, 0, 15, 51616, 1, 0, 0, 0, 0, 0, 935);
REPLACE INTO `waypoint_scripts` VALUES (662, 0, 15, 51616, 1, 0, 0, 0, 0, 0, 936);
REPLACE INTO `waypoint_scripts` VALUES (663, 0, 15, 52837, 1, 0, 0, 0, 0, 0, 937);
REPLACE INTO `waypoint_scripts` VALUES (664, 0, 15, 51616, 1, 0, 0, 0, 0, 0, 938);
REPLACE INTO `waypoint_scripts` VALUES (665, 0, 15, 51616, 1, 0, 0, 0, 0, 0, 939);
REPLACE INTO `waypoint_scripts` VALUES (666, 0, 15, 51616, 1, 0, 0, 0, 0, 0, 940);
REPLACE INTO `waypoint_scripts` VALUES (667, 0, 15, 52833, 1, 0, 0, 0, 0, 0, 941);
REPLACE INTO `waypoint_scripts` VALUES (725, 0, 15, 52686, 1, 0, 0, 0, 0, 0, 981);
REPLACE INTO `waypoint_scripts` VALUES (726, 0, 15, 52686, 1, 0, 0, 0, 0, 0, 982);
REPLACE INTO `waypoint_scripts` VALUES (727, 0, 15, 52681, 1, 0, 0, 0, 0, 0, 983);
REPLACE INTO `waypoint_scripts` VALUES (728, 0, 15, 52686, 1, 0, 0, 0, 0, 0, 984);
REPLACE INTO `waypoint_scripts` VALUES (729, 0, 15, 52686, 1, 0, 0, 0, 0, 0, 985);
REPLACE INTO `waypoint_scripts` VALUES (730, 0, 15, 52681, 1, 0, 0, 0, 0, 0, 986);
REPLACE INTO `waypoint_scripts` VALUES (731, 0, 15, 52681, 1, 0, 0, 0, 0, 0, 987);
REPLACE INTO `waypoint_scripts` VALUES (732, 0, 15, 52681, 1, 0, 0, 0, 0, 0, 988);
REPLACE INTO `waypoint_scripts` VALUES (733, 0, 15, 51577, 1, 0, 0, 0, 0, 0, 989);
REPLACE INTO `waypoint_scripts` VALUES (734, 0, 15, 51579, 1, 0, 0, 0, 0, 0, 990);
REPLACE INTO `waypoint_scripts` VALUES (735, 0, 15, 52834, 1, 0, 0, 0, 0, 0, 991);
REPLACE INTO `waypoint_scripts` VALUES (736, 0, 15, 52838, 1, 0, 0, 0, 0, 0, 992);
REPLACE INTO `waypoint_scripts` VALUES (737, 0, 15, 51606, 1, 0, 0, 0, 0, 0, 993);
REPLACE INTO `waypoint_scripts` VALUES (738, 0, 15, 51607, 1, 0, 0, 0, 0, 0, 994);
REPLACE INTO `waypoint_scripts` VALUES (739, 0, 15, 48293, 1, 0, 0, 0, 0, 0, 995);
REPLACE INTO `waypoint_scripts` VALUES (740, 0, 15, 48293, 1, 0, 0, 0, 0, 0, 996);
REPLACE INTO `waypoint_scripts` VALUES (751, 0, 15, 46685, 1, 0, 0, 0, 0, 0, 1001);
REPLACE INTO `waypoint_scripts` VALUES (752, 0, 15, 51616, 1, 0, 0, 0, 0, 0, 1002);
REPLACE INTO `waypoint_scripts` VALUES (753, 0, 15, 51616, 1, 0, 0, 0, 0, 0, 1003);
REPLACE INTO `waypoint_scripts` VALUES (754, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 1004);
REPLACE INTO `waypoint_scripts` VALUES (755, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 1005);
REPLACE INTO `waypoint_scripts` VALUES (756, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 1006);
REPLACE INTO `waypoint_scripts` VALUES (757, 0, 15, 55419, 1, 0, 0, 0, 0, 0, 1007);
REPLACE INTO `waypoint_scripts` VALUES (758, 0, 15, 48213, 1, 0, 0, 0, 0, 0, 1008);
REPLACE INTO `waypoint_scripts` VALUES (759, 0, 15, 48213, 1, 0, 0, 0, 0, 0, 1009);
REPLACE INTO `waypoint_scripts` VALUES (760, 0, 15, 48213, 1, 0, 0, 0, 0, 0, 1010);
REPLACE INTO `waypoint_scripts` VALUES (761, 0, 15, 48213, 1, 0, 0, 0, 0, 0, 1011);
REPLACE INTO `waypoint_scripts` VALUES (781, 0, 15, 55796, 1, 0, 0, 0, 0, 0, 1063);
REPLACE INTO `waypoint_scripts` VALUES (782, 0, 15, 54112, 1, 0, 0, 0, 0, 0, 1064);
REPLACE INTO `waypoint_scripts` VALUES (783, 0, 15, 51256, 1, 0, 0, 0, 0, 0, 1014);
REPLACE INTO `waypoint_scripts` VALUES (784, 0, 15, 46400, 1, 0, 0, 0, 0, 0, 1065);