Цитата (verbatim1992)
Устанавливает уровень SP персонажей согласно их уровнямCode
UPDATE`characters`SET`sp`='1000'WHERE CONCAT(`level`)=1;
[code]UPDATE`characters`SET`sp`='1000'WHERE CONCAT(`level`)=2;
UPDATE`characters`SET`sp`='1000'WHERE CONCAT(`level`)=3;
UPDATE`characters`SET`sp`='1000'WHERE CONCAT(`level`)=4;
UPDATE`characters`SET`sp`='3000'WHERE CONCAT(`level`)=5;
UPDATE`characters`SET`sp`='3000'WHERE CONCAT(`level`)=6;
UPDATE`characters`SET`sp`='3000'WHERE CONCAT(`level`)=7;
UPDATE`characters`SET`sp`='3000'WHERE CONCAT(`level`)=8;
UPDATE`characters`SET`sp`='3000'WHERE CONCAT(`level`)=9;
UPDATE`characters`SET`sp`='6000'WHERE CONCAT(`level`)=10;
UPDATE`characters`SET`sp`='6000'WHERE CONCAT(`level`)=11;
UPDATE`characters`SET`sp`='6000'WHERE CONCAT(`level`)=12;
UPDATE`characters`SET`sp`='8000'WHERE CONCAT(`level`)=13;
UPDATE`characters`SET`sp`='8000'WHERE CONCAT(`level`)=14;
UPDATE`characters`SET`sp`='8000'WHERE CONCAT(`level`)=15;
UPDATE`characters`SET`sp`='16000'WHERE CONCAT(`level`)=16;
UPDATE`characters`SET`sp`='16000'WHERE CONCAT(`level`)=17;
UPDATE`characters`SET`sp`='20000'WHERE CONCAT(`level`)=18;
UPDATE`characters`SET`sp`='20000'WHERE CONCAT(`level`)=19;
UPDATE`characters`SET`sp`='400000'WHERE CONCAT(`level`)=20;
UPDATE`characters`SET`sp`='400000'WHERE CONCAT(`level`)=21;
UPDATE`characters`SET`sp`='800000'WHERE CONCAT(`level`)=22;
UPDATE`characters`SET`sp`='800000'WHERE CONCAT(`level`)=23;
UPDATE`characters`SET`sp`='800000'WHERE CONCAT(`level`)=24;
UPDATE`characters`SET`sp`='1600000'WHERE CONCAT(`level`)=25; UPDATE`characters`SET`sp`='1600000'WHERE CONCAT(`level`)=26; UPDATE`characters`SET`sp`='1600000'WHERE CONCAT(`level`)=27; UPDATE`characters`SET`sp`='3000000'WHERE CONCAT(`level`)=28; UPDATE`characters`SET`sp`='3000000'WHERE CONCAT(`level`)=29; UPDATE`characters`SET`sp`='3000000'WHERE CONCAT(`level`)=30; UPDATE`characters`SET`sp`='3000000'WHERE CONCAT(`level`)=31; UPDATE`characters`SET`sp`='3000000'WHERE CONCAT(`level`)=32; UPDATE`characters`SET`sp`='3000000'WHERE CONCAT(`level`)=33; UPDATE`characters`SET`sp`='4000000'WHERE CONCAT(`level`)=34; UPDATE`characters`SET`sp`='4000000'WHERE CONCAT(`level`)=35; UPDATE`characters`SET`sp`='4000000'WHERE CONCAT(`level`)=36; UPDATE`characters`SET`sp`='4000000'WHERE CONCAT(`level`)=37; UPDATE`characters`SET`sp`='6000000'WHERE CONCAT(`level`)=38; UPDATE`characters`SET`sp`='6000000'WHERE CONCAT(`level`)=39; UPDATE`characters`SET`sp`='12000000'WHERE CONCAT(`level`)=40; UPDATE`characters`SET`sp`='12000000'WHERE CONCAT(`level`)=41; UPDATE`characters`SET`sp`='12000000'WHERE CONCAT(`level`)=42; UPDATE`characters`SET`sp`='20000000'WHERE CONCAT(`level`)=43; UPDATE`characters`SET`sp`='20000000'WHERE CONCAT(`level`)=44; UPDATE`characters`SET`sp`='20000000'WHERE CONCAT(`level`)=45; UPDATE`characters`SET`sp`='40000000'WHERE CONCAT(`level`)=46; UPDATE`characters`SET`sp`='40000000'WHERE CONCAT(`level`)=47; UPDATE`characters`SET`sp`='60000000'WHERE CONCAT(`level`)=48; UPDATE`characters`SET`sp`='60000000'WHERE CONCAT(`level`)=49; UPDATE`characters`SET`sp`='60000000'WHERE CONCAT(`level`)=50; UPDATE`characters`SET`sp`='60000000'WHERE CONCAT(`level`)=51; UPDATE`characters`SET`sp`='80000000'WHERE CONCAT(`level`)=52; UPDATE`characters`SET`sp`='80000000'WHERE CONCAT(`level`)=53; UPDATE`characters`SET`sp`='80000000'WHERE CONCAT(`level`)=54; UPDATE`characters`SET`sp`='80000000'WHERE CONCAT(`level`)=55; UPDATE`characters`SET`sp`='90000000'WHERE CONCAT(`level`)=56; UPDATE`characters`SET`sp`='90000000'WHERE CONCAT(`level`)=57; UPDATE`characters`SET`sp`='90000000'WHERE CONCAT(`level`)=58; UPDATE`characters`SET`sp`='90000000'WHERE CONCAT(`level`)=59; UPDATE`characters`SET`sp`='90000000'WHERE CONCAT(`level`)=60; UPDATE`characters`SET`sp`='90000000'WHERE CONCAT(`level`)=61; UPDATE`characters`SET`sp`='200000000'WHERE CONCAT(`level`)=62; UPDATE`characters`SET`sp`='200000000'WHERE CONCAT(`level`)=63; UPDATE`characters`SET`sp`='200000000'WHERE CONCAT(`level`)=64; UPDATE`characters`SET`sp`='200000000'WHERE CONCAT(`level`)=65; UPDATE`characters`SET`sp`='200000000'WHERE CONCAT(`level`)=66; UPDATE`characters`SET`sp`='200000000'WHERE CONCAT(`level`)=67; UPDATE`characters`SET`sp`='200000000'WHERE CONCAT(`level`)=68; UPDATE`characters`SET`sp`='200000000'WHERE CONCAT(`level`)=69; UPDATE`characters`SET`sp`='200000000'WHERE CONCAT(`level`)=70; UPDATE`characters`SET`sp`='200000000'WHERE CONCAT(`level`)=71; UPDATE`characters`SET`sp`='500000000'WHERE CONCAT(`level`)=72; UPDATE`characters`SET`sp`='500000000'WHERE CONCAT(`level`)=73; UPDATE`characters`SET`sp`='500000000'WHERE CONCAT(`level`)=74; UPDATE`characters`SET`sp`='500000000'WHERE CONCAT(`level`)=75; UPDATE`characters`SET`sp`='500000000'WHERE CONCAT(`level`)=76; UPDATE`characters`SET`sp`='500000000'WHERE CONCAT(`level`)=77; UPDATE`characters`SET`sp`='500000000'WHERE CONCAT(`level`)=78; UPDATE`characters`SET`sp`='500000000'WHERE CONCAT(`level`)=79; UPDATE`characters`SET`sp`='1000000000'WHERE CONCAT(`level`)=80;
А это для чего? как его использовать то?) точнее я даж не могу представить накой он нужен.Добавлено (07.04.2013, 13:01)
---------------------------------------------
Цитата (HtmlSqlXml)
UPDATE`characters`SET`sp`='1000'WHERE CONCAT(`level`)=3;UPDATE`characters`SET`sp`='1000'WHERE CONCAT(`level`)=4;
