В 2 раза больше.
1 ответов104 просмотровСейчас просматривают: 1
· 02.10.2009, 16:48
Тестилось на la2base.1.1.7 Interlude
UPDATE `char_templates` SET `STR`='80' WHERE (SELECT ClassId) AND (str = '40');
UPDATE `char_templates` SET `STR`='44' WHERE (SELECT ClassId) AND (str = '22');
UPDATE `char_templates` SET `STR`='72' WHERE (SELECT ClassId) AND (str = '36');
UPDATE `char_templates` SET `STR`='42' WHERE (SELECT ClassId) AND (str = '21');
UPDATE `char_templates` SET `STR`='46' WHERE (SELECT ClassId) AND (str = '23');
UPDATE `char_templates` SET `STR`='54' WHERE (SELECT ClassId) AND (str = '27');
UPDATE `char_templates` SET `STR`='78' WHERE (SELECT ClassId) AND (str = '39');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `con`='54' WHERE (SELECT ClassId) AND (con = '27');
UPDATE `char_templates` SET `con`='72' WHERE (SELECT ClassId) AND (con = '36');
UPDATE `char_templates` SET `con`='50' WHERE (SELECT ClassId) AND (con = '25');
UPDATE `char_templates` SET `con`='64' WHERE (SELECT ClassId) AND (con = '32');
UPDATE `char_templates` SET `con`='48' WHERE (SELECT ClassId) AND (con = '24');
UPDATE `char_templates` SET `con`='94' WHERE (SELECT ClassId) AND (con = '47');
UPDATE `char_templates` SET `con`='62' WHERE (SELECT ClassId) AND (con = '31');
UPDATE `char_templates` SET `con`='90' WHERE (SELECT ClassId) AND (con = '45');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (SELECT ClassId) AND (_int = '21');
UPDATE `char_templates` SET `_int`='82' WHERE (SELECT ClassId) AND (_int = '41');
UPDATE `char_templates` SET `_int`='46' WHERE (SELECT ClassId) AND (_int = '23');
UPDATE `char_templates` SET `_int`='74' WHERE (SELECT ClassId) AND (_int = '37');
UPDATE `char_templates` SET `_int`='50' WHERE (SELECT ClassId) AND (_int = '25');
UPDATE `char_templates` SET `_int`='88' WHERE (SELECT ClassId) AND (_int = '44');
UPDATE `char_templates` SET `_int`='36' WHERE (SELECT ClassId) AND (_int = '18');
UPDATE `char_templates` SET `_int`='62' WHERE (SELECT ClassId) AND (_int = '31');
UPDATE `char_templates` SET `_int`='40' WHERE (SELECT ClassId) AND (_int = '20');
UPDATE `char_templates` SET `men`='52' WHERE (SELECT ClassId) AND (men = '26');
UPDATE `char_templates` SET `men`='80' WHERE (SELECT ClassId) AND (men = '40');
UPDATE `char_templates` SET `men`='74' WHERE (SELECT ClassId) AND (men = '37');
UPDATE `char_templates` SET `men`='54' WHERE (SELECT ClassId) AND (men = '27');
UPDATE `char_templates` SET `men`='84' WHERE (SELECT ClassId) AND (men = '42');
UPDATE `char_templates` SET `men`='78' WHERE (SELECT ClassId) AND (men = '39');
UPDATE `char_templates` SET `men`='50' WHERE (SELECT ClassId) AND (men = '25');
UPDATE `char_templates` SET `STR`='80' WHERE (ClassId = '0') AND (str = '40');
UPDATE `char_templates` SET `con`='86' WHERE (ClassId = '0') AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (ClassId = '0') AND (_int = '21');
UPDATE `char_templates` SET `dex`='60' WHERE (ClassId = '0') AND (dex = '30');
UPDATE `char_templates` SET `wit`='22' WHERE (ClassId = '0') AND (wit = '11');
UPDATE `char_templates` SET `wit`='22' WHERE (SELECT ClassId) AND (wit = '11');
UPDATE `char_templates` SET `wit`='40' WHERE (SELECT ClassId) AND (wit = '20');
UPDATE `char_templates` SET `wit`='28' WHERE (SELECT ClassId) AND (wit = '14');
UPDATE `char_templates` SET `wit`='46' WHERE (SELECT ClassId) AND (wit = '23');
UPDATE `char_templates` SET `wit`='24' WHERE (SELECT ClassId) AND (wit = '12');
UPDATE `char_templates` SET `wit`='38' WHERE (SELECT ClassId) AND (wit = '19');
UPDATE `char_templates` SET `wit`='30' WHERE (SELECT ClassId) AND (wit = '15');
UPDATE `char_templates` SET `wit`='20' WHERE (SELECT ClassId) AND (wit = '10');
UPDATE `char_templates` SET `dex`='60' WHERE (SELECT ClassId) AND (dex = '30');
UPDATE `char_templates` SET `dex`='42' WHERE (SELECT ClassId) AND (dex = '21');
UPDATE `char_templates` SET `dex`='70' WHERE (SELECT ClassId) AND (dex = '35');
UPDATE `char_templates` SET `dex`='48' WHERE (SELECT ClassId) AND (dex = '24');
UPDATE `char_templates` SET `dex`='68' WHERE (SELECT ClassId) AND (dex = '34');
UPDATE `char_templates` SET `dex`='46' WHERE (SELECT ClassId) AND (dex = '23');
UPDATE `char_templates` SET `dex`='52' WHERE (SELECT ClassId) AND (dex = '26');
UPDATE `char_templates` SET `dex`='58' WHERE (SELECT ClassId) AND (dex = '29');
UPDATE `char_templates` SET `STR`='44' WHERE (SELECT ClassId) AND (str = '22');
UPDATE `char_templates` SET `STR`='72' WHERE (SELECT ClassId) AND (str = '36');
UPDATE `char_templates` SET `STR`='42' WHERE (SELECT ClassId) AND (str = '21');
UPDATE `char_templates` SET `STR`='46' WHERE (SELECT ClassId) AND (str = '23');
UPDATE `char_templates` SET `STR`='54' WHERE (SELECT ClassId) AND (str = '27');
UPDATE `char_templates` SET `STR`='78' WHERE (SELECT ClassId) AND (str = '39');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `con`='54' WHERE (SELECT ClassId) AND (con = '27');
UPDATE `char_templates` SET `con`='72' WHERE (SELECT ClassId) AND (con = '36');
UPDATE `char_templates` SET `con`='50' WHERE (SELECT ClassId) AND (con = '25');
UPDATE `char_templates` SET `con`='64' WHERE (SELECT ClassId) AND (con = '32');
UPDATE `char_templates` SET `con`='48' WHERE (SELECT ClassId) AND (con = '24');
UPDATE `char_templates` SET `con`='94' WHERE (SELECT ClassId) AND (con = '47');
UPDATE `char_templates` SET `con`='62' WHERE (SELECT ClassId) AND (con = '31');
UPDATE `char_templates` SET `con`='90' WHERE (SELECT ClassId) AND (con = '45');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (SELECT ClassId) AND (_int = '21');
UPDATE `char_templates` SET `_int`='82' WHERE (SELECT ClassId) AND (_int = '41');
UPDATE `char_templates` SET `_int`='46' WHERE (SELECT ClassId) AND (_int = '23');
UPDATE `char_templates` SET `_int`='74' WHERE (SELECT ClassId) AND (_int = '37');
UPDATE `char_templates` SET `_int`='50' WHERE (SELECT ClassId) AND (_int = '25');
UPDATE `char_templates` SET `_int`='88' WHERE (SELECT ClassId) AND (_int = '44');
UPDATE `char_templates` SET `_int`='36' WHERE (SELECT ClassId) AND (_int = '18');
UPDATE `char_templates` SET `_int`='62' WHERE (SELECT ClassId) AND (_int = '31');
UPDATE `char_templates` SET `_int`='40' WHERE (SELECT ClassId) AND (_int = '20');
UPDATE `char_templates` SET `men`='52' WHERE (SELECT ClassId) AND (men = '26');
UPDATE `char_templates` SET `men`='80' WHERE (SELECT ClassId) AND (men = '40');
UPDATE `char_templates` SET `men`='74' WHERE (SELECT ClassId) AND (men = '37');
UPDATE `char_templates` SET `men`='54' WHERE (SELECT ClassId) AND (men = '27');
UPDATE `char_templates` SET `men`='84' WHERE (SELECT ClassId) AND (men = '42');
UPDATE `char_templates` SET `men`='78' WHERE (SELECT ClassId) AND (men = '39');
UPDATE `char_templates` SET `men`='50' WHERE (SELECT ClassId) AND (men = '25');
UPDATE `char_templates` SET `STR`='80' WHERE (ClassId = '0') AND (str = '40');
UPDATE `char_templates` SET `con`='86' WHERE (ClassId = '0') AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (ClassId = '0') AND (_int = '21');
UPDATE `char_templates` SET `dex`='60' WHERE (ClassId = '0') AND (dex = '30');
UPDATE `char_templates` SET `wit`='22' WHERE (ClassId = '0') AND (wit = '11');
UPDATE `char_templates` SET `wit`='22' WHERE (SELECT ClassId) AND (wit = '11');
UPDATE `char_templates` SET `wit`='40' WHERE (SELECT ClassId) AND (wit = '20');
UPDATE `char_templates` SET `wit`='28' WHERE (SELECT ClassId) AND (wit = '14');
UPDATE `char_templates` SET `wit`='46' WHERE (SELECT ClassId) AND (wit = '23');
UPDATE `char_templates` SET `wit`='24' WHERE (SELECT ClassId) AND (wit = '12');
UPDATE `char_templates` SET `wit`='38' WHERE (SELECT ClassId) AND (wit = '19');
UPDATE `char_templates` SET `wit`='30' WHERE (SELECT ClassId) AND (wit = '15');
UPDATE `char_templates` SET `wit`='20' WHERE (SELECT ClassId) AND (wit = '10');
UPDATE `char_templates` SET `dex`='60' WHERE (SELECT ClassId) AND (dex = '30');
UPDATE `char_templates` SET `dex`='42' WHERE (SELECT ClassId) AND (dex = '21');
UPDATE `char_templates` SET `dex`='70' WHERE (SELECT ClassId) AND (dex = '35');
UPDATE `char_templates` SET `dex`='48' WHERE (SELECT ClassId) AND (dex = '24');
UPDATE `char_templates` SET `dex`='68' WHERE (SELECT ClassId) AND (dex = '34');
UPDATE `char_templates` SET `dex`='46' WHERE (SELECT ClassId) AND (dex = '23');
UPDATE `char_templates` SET `dex`='52' WHERE (SELECT ClassId) AND (dex = '26');
UPDATE `char_templates` SET `dex`='58' WHERE (SELECT ClassId) AND (dex = '29');
[attachment=4245:______WinRAR.rar]
0
Войдите или зарегистрируйтесь чтобы ответить

