Sprawy forum - zbiorczo

[Bajtuś]

poprawka wrzesień:
UPDATE smf_log_activity SET topics='9', posts='58', registers='1', most_on='16', hits='4604' WHERE date="2015-09-02";
UPDATE smf_log_activity SET topics='9', posts='105', registers='1', most_on='19', hits='5639' WHERE date="2015-09-03";
UPDATE smf_log_activity SET topics='14', posts='124', registers='1', most_on='16', hits='5722' WHERE date="2015-09-04";
UPDATE smf_log_activity SET topics='17', posts='108', registers='0', most_on='16', hits='5841' WHERE date="2015-09-05";
UPDATE smf_log_activity SET topics='11', posts='116', registers='0', most_on='17', hits='6494' WHERE date="2015-09-06";
UPDATE smf_log_activity SET topics='14', posts='93', registers='0', most_on='14', hits='4985' WHERE date="2015-09-07";
UPDATE smf_log_activity SET topics='4', posts='45', registers='0', most_on='14', hits='4951' WHERE date="2015-09-08";
UPDATE smf_log_activity SET topics='9', posts='59', registers='0', most_on='18', hits='6236' WHERE date="2015-09-09";
UPDATE smf_log_activity SET topics='9', posts='62', registers='0', most_on='16', hits='5691' WHERE date="2015-09-10";
UPDATE smf_log_activity SET topics='7', posts='77', registers='1', most_on='12', hits='6516' WHERE date="2015-09-11";
UPDATE smf_log_activity SET topics='6', posts='94', registers='3', most_on='16', hits='6600' WHERE date="2015-09-12";
UPDATE smf_log_activity SET topics='12', posts='82', registers='2', most_on='15', hits='5540' WHERE date="2015-09-13";
UPDATE smf_log_activity SET topics='14', posts='134', registers='1', most_on='19', hits='5402' WHERE date="2015-09-14";
UPDATE smf_log_activity SET topics='9', posts='82', registers='0', most_on='17', hits='5378' WHERE date="2015-09-15";
UPDATE smf_log_activity SET topics='7', posts='67', registers='1', most_on='16', hits='5037' WHERE date="2015-09-16";
UPDATE smf_log_activity SET topics='2', posts='44', registers='0', most_on='11', hits='3903' WHERE date="2015-09-17";
UPDATE smf_log_activity SET topics='3', posts='72', registers='0', most_on='14', hits='4537' WHERE date="2015-09-18";
UPDATE smf_log_activity SET topics='5', posts='62', registers='0', most_on='15', hits='4601' WHERE date="2015-09-19";
UPDATE smf_log_activity SET topics='11', posts='118', registers='0', most_on='15', hits='5906' WHERE date="2015-09-20";
UPDATE smf_log_activity SET topics='5', posts='57', registers='0', most_on='14', hits='4575' WHERE date="2015-09-21";
UPDATE smf_log_activity SET topics='4', posts='58', registers='0', most_on='14', hits='5204' WHERE date="2015-09-22";
UPDATE smf_log_activity SET topics='4', posts='66', registers='0', most_on='14', hits='14251' WHERE date="2015-09-23";
UPDATE smf_log_activity SET topics='7', posts='89', registers='1', most_on='15', hits='7420' WHERE date="2015-09-24";
UPDATE smf_log_activity SET topics='13', posts='98', registers='1', most_on='14', hits='12705' WHERE date="2015-09-25";
UPDATE smf_log_activity SET topics='14', posts='164', registers='1', most_on='19', hits='15531' WHERE date="2015-09-26";
UPDATE smf_log_activity SET topics='14', posts='146', registers='0', most_on='19', hits='15391' WHERE date="2015-09-27";
UPDATE smf_log_activity SET topics='11', posts='177', registers='1', most_on='20', hits='11419' WHERE date="2015-09-28";
UPDATE smf_log_activity SET topics='4', posts='103', registers='0', most_on='14', hits='5838' WHERE date="2015-09-29";
UPDATE smf_log_activity SET topics='6', posts='104', registers='0', most_on='16', hits='6527' WHERE date="2015-09-30";

październik jusz był dobrze.

Robota zakończona ;
I dla ciekawości skrypt robiący poprawki tych pierwszych miesięcy:
@echo off
echo. > kwer.sql
for /F "delims=; tokens=1,2,3,4,5,6" %%a IN (stat.txt) do (
echo UPDATE smf_log_activity SET topics='%%b', posts='%%c', registers='%%d', most_on='%%e', hits='%%f' WHERE date="%%a"; >> kwer.sql
)
echo koniec