X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_points.php;h=2f0808e26f4f501c451e3b03d2a8e6d9a9fb5205;hb=101e5f161c0c367c022c9288398226a57f3919d7;hp=3ef48975ae67b96791e23fad8a030e22c7739790;hpb=4c221b6350439b8f91db58f142f03f79014f2eaf;p=mailer.git

diff --git a/inc/modules/admin/what-config_points.php b/inc/modules/admin/what-config_points.php
index 3ef48975ae..2f0808e26f 100644
--- a/inc/modules/admin/what-config_points.php
+++ b/inc/modules/admin/what-config_points.php
@@ -77,10 +77,9 @@ if (isFormSent()) {
 			break;
 
 		case 'ref':
-			switch (getRequestParameter('do'))
-			{
+			switch (getRequestParameter('do')) {
 				case 'add':
-					addSql("INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`, `percents`) VALUES ('".postRequestParameter('level')."','".postRequestParameter('percents')."')");
+					addSql("INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`, `percents`) VALUES ('".bigintval(postRequestParameter('level'))."','".bigintval(postRequestParameter('percents'))."')");
 					break;
 
 				case 'edit': // Change entries
@@ -94,7 +93,7 @@ if (isFormSent()) {
 						// Update entry
 						SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_refdepths` SET `level`=%s, `percents`=%s WHERE `id`=%s LIMIT 1",
 							array(bigintval($value), convertCommaToDot(postRequestParameter('percents', $id)), $id), __FILE__, __LINE__);
-					}
+					} // END - foreach
 					$message = '{--ADMIN_REFERAL_DEPTHS_SAVED--}';
 					break;
 
@@ -102,10 +101,10 @@ if (isFormSent()) {
 					foreach (postRequestParameter('id') as $id => $value) {
 						SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `id`=%s LIMIT 1",
 						array(bigintval($id)), __FILE__, __LINE__);
-					}
+					} // END - foreach
 					$message = '{--ADMIN_REFERAL_DEPTHS_DELETED--}';
 					break;
-			}
+			} // END - switch
 
 			// Update cache file
 			// @TODO Rewrite this to a filter
@@ -136,7 +135,7 @@ WHERE
 
 	if ((isSqlsValid()) && (isSqlsValid())) {
 		if (strpos($GLOBALS['sqls'][0], 'INSERT') > -1) {
-			$result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `level`='%s' LIMIT 1",
+			$result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `level`=%s LIMIT 1",
 				array(bigintval(postRequestParameter('level'))), __FILE__, __LINE__);
 			SQL_FREERESULT($result);
 		} // END - if