database_query($sSql); $SETT = array(); while($aSetting = $database->database_fetch_assoc($rSql)) { $SETT[$aSetting['setting_code']] = $aSetting['setting_value']; } switch ($task) { case "create": $iColDays = intVal($_POST['col_days']); $fPrice = floatVal($_POST['price']); if($_POST['price'] == '') $fPrice = -1; $error_message = ''; if ($fPrice>=0 && $iColDays>0) { if($database->database_num_rows($database->database_query('SELECT true FROM `se_ats_tracking_price` WHERE col_days = '.$iColDays.' LIMIT 1'))>0) { $is_error = 1; $error_message .= '
'.$admin_ats_tracking_prices['count_exists'].'
'; }else{ $database->database_query('INSERT INTO `se_ats_tracking_price` (col_days, price) VALUES ('.$iColDays.','.$fPrice.')'); } }else{ $is_error = 1; if ($fPrice<=0) $error_message .= '
'.$admin_ats_tracking_prices['price_must_be_positive'].'
'; if ($iColDays<=0) $error_message .= '
'.$admin_ats_tracking_prices['days_must_be_positive'].'
'; } echo ""; exit(); case "edit": $iColDays = intVal($_POST['col_days']); $iPrice = floatVal($_POST['price']); if (!$item_id) { exit(); } if($iPrice>0 && $iColDays>0) { if($database->database_num_rows($database->database_query('SELECT true FROM `se_ats_tracking_price` WHERE col_days = '.$iPrice.' LIMIT 1'))>0) { $is_error = 1; $error_message = $admin_ats_tracking_prices['count_exists']; }else{ $database->database_query('UPDATE `se_ats_tracking_price` SET price = "'.$iPrice.'", col_days = "'.$iColDays.'" WHERE id = '.$item_id); } }else{ $is_error = 1; $error_message = $admin_ats_tracking_prices['price_must_be_positive']; } echo ""; break; case "delete": if($item_id) { $database->database_query('DELETE FROM `se_ats_tracking_price` WHERE id = '.$item_id); } cheader($page.'.php'); break; } $rSql = $database->database_query('SELECT * FROM `se_ats_tracking_price` ORDER BY col_days, price'); $aItems = array(); while($aItem = $database->database_fetch_assoc($rSql)) { $aItems[] = $aItem; } // **** PAYMENTS **** $sSql = 'SELECT p.*,u.user FROM se_ats_tracking_payment AS p INNER JOIN se_users AS u USING(user_id) ORDER BY payment_to_date DESC '; $rSql = $database->database_query($sSql); $aPayment = array(); while($aPayments[] = $database->database_fetch_assoc($rSql)); $smarty->assign( array( 'items' => $aItems, 'aPayments' => $aPayments, 'sCurrency' => $SETT['currency'] )); include "admin_footer.php"; ?>