From: short <> Date: Fri, 25 Feb 2005 21:46:35 +0000 (+0000) Subject: +Comment of crontab(5) entry for automatic per-year "VarSym" generation. X-Git-Url: http://git.jankratochvil.net/?p=www.energie.vellum.cz.git;a=commitdiff_plain;h=8c0eacf1422b908194932bed87c3f47c112a67e5 +Comment of crontab(5) entry for automatic per-year "VarSym" generation. --- diff --git a/inzerat-submit.php b/inzerat-submit.php index 01ae365..5a6c20c 100644 --- a/inzerat-submit.php +++ b/inzerat-submit.php @@ -120,6 +120,8 @@ if (!isset($confirm)) { create table energie_inzerat (varsym int not null auto_increment primary key,contents text null); alter table energie_inzerat add index (varsym); insert into energie_inzerat (varsym) values (20025000); + *** crontab(5) entry: + 0 0 1 1 * mysql -ushort -p`cat ~/priv/mysql.short.pwd ` -e 'insert into energie_inzerat (varsym) values (year(curdate())*10000+5000);' short ***/ db_query("insert into $tb_inzerat (contents) values('".addslashes($out)."')");