Sprawy forum - zbiorczo

[Bajtuś]

na szybko coś podłubałem
UPDATE smf_log_activity SET topics='19', posts='175', registers='0', most_on='15', hits='5724' WHERE date="2015-07-01";
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-02', '$$b', '93', '0', '$$e', '4836');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-03', '$$b', '345', '1', '$$e', '9491');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-04', '$$b', '73', '0', '$$e', '3964');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-05', '$$b', '116', '0', '$$e', '6034');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-06', '$$b', '151', '1', '$$e', '6414');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-07', '$$b', '74', '0', '$$e', '4237');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-08', '$$b', '102', '1', '$$e', '5860');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-09', '$$b', '106', '0', '$$e', '4178');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-10', '$$b', '60', '0', '$$e', '5370');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-11', '$$b', '35', '0', '$$e', '3183');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-12', '$$b', '70', '1', '$$e', '3927');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-13', '$$b', '50', '0', '$$e', '9916');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-14', '$$b', '41', '0', '$$e', '15362');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-15', '$$b', '120', '1', '$$e', '15353');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-16', '$$b', '79', '0', '$$e', '6426');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-17', '$$b', '66', '2', '$$e', '4503');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-18', '$$b', '148', '0', '$$e', '7440');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-19', '$$b', '60', '0', '$$e', '13783');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-20', '$$b', '125', '0', '$$e', '16486');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-21', '$$b', '67', '1', '$$e', '10378');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-22', '$$b', '57', '0', '$$e', '5088');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-23', '$$b', '135', '1', '$$e', '7075');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-24', '$$b', '79', '0', '$$e', '6661');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-25', '$$b', '71', '0', '$$e', '8647');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-26', '$$b', '94', '1', '$$e', '8766');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-27', '$$b', '108', '0', '$$e', '11329');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-28', '$$b', '137', '0', '$$e', '14243');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-29', '$$b', '134', '0', '$$e', '12711');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-30', '$$b', '91', '2', '$$e', '8238');
INSERT INTO smf_log_activity(date,topics,posts,registers,most_on,hits) VALUES ('2015-07-31', '$$b', '118', '0', '$$e', '8086');
oprócz pierwszej linii resztę robi skrypt
Jeśli bedziesz chciał podrzuce go
w notatniku trzeba zamienić tabulatory na średniki i bedzie hulać... jutro pomyśle o zrobieniu pierwszej linii z update.