X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fpool-update.php;h=6f1fc8f9f90a89988d918316f2dd3c3d0c574254;hb=7e977ea8d28b05219b02727fcca35150d9c8fcbe;hp=509e04b75461a3cbf8ac9de61426bbc8cf865d36;hpb=254afbdb1fa4699a98667bad4e792ad803a0d535;p=mailer.git

diff --git a/inc/pool-update.php b/inc/pool-update.php
index 509e04b754..6f1fc8f9f9 100644
--- a/inc/pool-update.php
+++ b/inc/pool-update.php
@@ -117,7 +117,7 @@ if (SQL_NUMROWS($result_main) > 0)
 					if (SQL_NUMROWS($result_stats) == 0)
 					{
 						// No entry was found, so we add him!
-						$result_stats = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_stats (pool_id , userid, cat_id, payment_id, subject, url , max_rec , timestamp_ordered, timestamp_sstart) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s' , UNIX_TIMESTAMP())",
+						$result_stats = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_stats (pool_id , userid, cat_id, payment_id, subject, url , max_rec , timestamp_ordered, timestamp_sstart) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s' , UNIX_TIMESTAMP())",
 						 array(bigintval($DATA[0]), bigintval($DATA[1]), bigintval($DATA[9]), bigintval($DATA[5]), $DATA[2], $DATA[7], $DATA[8], bigintval($DATA[6])), __FILE__, __LINE__);
 
 						// Receive it's ID for the links table
@@ -275,16 +275,7 @@ if (SQL_NUMROWS($result_main) > 0)
 						{
 							// User does not exists, pay points back
 							$points = GET_PAY_POINTS($DATA[5]);
-							$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+%s WHERE userid=%s AND ref_depth=0 LIMIT 1",
-							 array($points, bigintval($DATA[1])), __FILE__, __LINE__);
-
-							// Update mediadata as well
-							if (GET_EXT_VERSION("mediadata") >= "0.0.4")
-							{
-								// Update database
-								//* DEBUG: */ echo "*MEDIA/L:".__LINE__."/".$points."*<br />";
-								MEDIA_UPDATE_ENTRY(array("total_points"), "add", $points);
-							}
+							ADD_POINTS_REFSYSTEM($DATA[1], $points, false, "0", false, "direct");
 
 							// Add points together and remove user
 							$points_BACK[$DATA[1]] += $points;