setPostRequestParameter('percents', array($id => convertCommaToDot(postRequestParameter('percents', $id))));
// Update entry
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_refdepths` SET `level`='%s', `percents`='%s' WHERE `id`=%s LIMIT 1",
- array(bigintval($value), postRequestParameter('percents', $id), $id), __FILE__, __LINE__);
+ 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__);
}
$message = '{--REF_DEPTHS_SAVED--}';
break;
loadTemplate('admin_config_point_settings', false, $content);
} elseif (getRequestParameter('sub') == 'ref') {
// 12 3 32 2 3 32 2 3 4 43 21
- if ((isFormSent('del')) && (isPostRequestParameterSet('sel')) && (countPostSelection() > 0)) {
+ if ((isFormSent('del')) && (isPostRequestParameterSet('sel')) && (ifPostContainsSelections())) {
// Delete entries
- $OUT = ''; $SW = 2;
+ $OUT = '';
foreach (postRequestParameter('sel') as $id => $value) {
- $result = SQL_QUERY_ESC("SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `id`=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `id`, `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `id`=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
$content = SQL_FETCHARRAY($result);
SQL_FREERESULT($result);
- // Prepare data for the row template
- $content = array(
- 'sw' => $SW,
- 'id' => $id,
- 'level' => $content['level'],
- 'percents' => translateComma($content['percents']),
- );
-
// Load row template and switch color
$OUT .= loadTemplate('admin_points_del_row', true, $content);
- $SW = 3 - $SW;
- }
+ } // END - foreach
// Load main template
loadTemplate('admin_points_del', false, $OUT);
- } elseif ((isFormSent('edit')) && (isPostRequestParameterSet('sel')) && (countPostSelection() > 0)) {
+ } elseif ((isFormSent('edit')) && (isPostRequestParameterSet('sel')) && (ifPostContainsSelections())) {
// Edit entries
- $OUT = ''; $SW = 2;
+ $OUT = '';
foreach (postRequestParameter('sel') as $id => $value) {
- $result = SQL_QUERY_ESC("SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `id`=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `id`, `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `id`=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
$content = SQL_FETCHARRAY($result);
SQL_FREERESULT($result);
- // Prepare data for the row template
- $content = array(
- 'sw' => $SW,
- 'id' => $id,
- 'level' => $content['level'],
- 'percents' => translateComma($content['percents']),
- );
-
// Load row template and switch color
$OUT .= loadTemplate('admin_points_edit_row', true, $content);
- $SW = 3 - $SW;
- }
+ } // END - foreach
// Load main template
loadTemplate('admin_points_edit', false, $OUT);
} else {
// Referal levels
$result = SQL_QUERY("SELECT `id`, `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` ORDER BY `level` ASC", __FILE__, __LINE__);
- if (SQL_NUMROWS($result) > 0) {
+ if (!SQL_HASZERONUMS($result)) {
// Make referal levels editable and deletable
- $OUT = ''; $SW = 2;
+ $OUT = '';
// List already existing categories for editing
while ($content = SQL_FETCHARRAY($result)) {
// Prepare data for the row template
- $content['sw'] = $SW;
$content['percents'] = translateComma($content['percents']);
// Load row template and switch color
$OUT .= loadTemplate('admin_points_row', true, $content);
- $SW = 3 - $SW;
- }
+ } // END - while
// Free memory
SQL_FREERESULT($result);