X-Git-Url: https://git.harvie.cz/?a=blobdiff_plain;f=wwwroot%2Finc%2Fubik.inc;h=0b896bbbd576f0e092b17a28ee1d05ad58d14895;hb=9a7d7230f8f104337eccdf8413e61e9ea44a2775;hp=edb1b4c06e4c8eda07b47b89d7397f1464818ebb;hpb=51ff32267c4949bad6a8dddc502cbc01ed56edc8;p=mirrors%2FKyberia-bloodline.git diff --git a/wwwroot/inc/ubik.inc b/wwwroot/inc/ubik.inc index edb1b4c..0b896bb 100644 --- a/wwwroot/inc/ubik.inc +++ b/wwwroot/inc/ubik.inc @@ -30,12 +30,13 @@ class ubik { else return false; if (!empty($params['mail_text'])) $mail_text=addslashes($params['mail_text']); else return false; - $q="insert into mail set mail_from='".UBIK_ID."',mail_to='$mail_to',mail_user='$mail_to',mail_timestamp=NOW(),mail_text='$mail_text'"; - $db->query($q); - $db->query("update users set -user_mail_name='ubik',user_mail_id=".UBIK_ID.",user_mail=user_mail+1 where -user_id='$mail_to'"); + + $q_i = sprintf('insert into mail set mail_user = %2$d, mail_from = %1$d, mail_to = %2$d, mail_timestamp = NOW(), mail_text = "%3$s"' + ,UBIK_ID, $mail_to, $mail_text); + $db->update($q_i); + $q_u = sprintf('update users set user_mail = user_mail + 1, user_mail_id = %1$d where user_id = %2$d', UBIK_ID, $mail_to); + $db->update($q_u); } }