X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=mailid_top.php;h=60ee8099668a28aeeeebde88d44924f13278699b;hp=33c4acad41ffe3c0626fe2a3b65dec34a21fe4be;hb=5f8c1a333627cd0145f778a6eebdb251f5bb40b6;hpb=59949615f7fc6926f07fe65f9dac9436d124b40e diff --git a/mailid_top.php b/mailid_top.php index 33c4acad41..60ee809966 100644 --- a/mailid_top.php +++ b/mailid_top.php @@ -175,7 +175,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) switch ($ltype) { case "NORMAL": - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_stats SET clicks=clicks+1 WHERE id=%s LIMIT 1", + $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_stats SET clicks=clicks + 1 WHERE id=%s LIMIT 1", array($url_mid), __FILE__, __LINE__); // Update mediadata as well @@ -187,7 +187,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) break; case "BONUS": - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_bonus SET clicks=clicks+1 WHERE id=%s LIMIT 1", + $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_bonus SET clicks=clicks + 1 WHERE id=%s LIMIT 1", array($url_bid), __FILE__, __LINE__); // Update mediadata as well @@ -206,8 +206,15 @@ if (isBooleanConstantAndTrue('mxchange_installed')) // Only when user extension = v0.1.2: Update mails-confirmed counter if (GET_EXT_VERSION("user") >= "0.1.2") { // Update counter - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET mails_confirmed=mails_confirmed+1 WHERE userid=%s LIMIT 1", - array($url_uid), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET mails_confirmed=mails_confirmed + 1 WHERE userid=%s LIMIT 1", + array($url_uid), __FILE__, __LINE__); + + // Update random confirmed as well? + if (GET_EXT_VERSION("user") >= "0.3.4") { + // Update second counter + SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET rand_confirmed=rand_confirmed + 1 WHERE userid=%s LIMIT 1", + array($url_uid), __FILE__, __LINE__); + } // END - if } // Insert stats record