TIP: Přetáhni ikonu na hlavní panel pro připnutí webu
Duch
mysql verze 5.6 PHP verze 5.3
Tohle mi to hlásí
A Mysql error has occurred while running the script:
The query you are trying to run is invalid
Mysql Error Output: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 20' at line 9
SQL Query: SELECT u.user_id, u.name, u.username, u.email, u.active, u.approved, u.reg_date, u.payment_mode, u.balance, u.tax_account_type, u.tax_reg_number, u.tax_apply_exempt, u.tax_exempted, u.is_seller, u.preferred_seller, u.auction_approval, u.seller_verified, u.preferred_seller_exp_date, u.tax_company_name, c.name AS country_name, s.name AS state_name, u.mail_activated, u.bidder_verified FROM probid_users u LEFT JOIN probid_countries c ON u.country=c.id LEFT JOIN probid_countries s ON u.state=s.id WHERE u.balance>0 AND u.payment_mode=2 ORDER BY u.reg_date DESC LIMIT , 20
PHP KÓD
<?
session_start();
define ('IN_ADMIN', 1);
define ('IN_SITE', 1);
include_once ('../includes/global.php');
include_once ('../includes/class_formchecker.php');
include_once ('../includes/class_custom_field.php');
include_once ('../includes/class_item.php');
include_once ('../includes/class_user.php');
include_once ('../includes/functions_login.php');
if ($session->value('adminarea')!='Active')
{
header_redirect('login.php');
}
else
{
include_once ('header.php');
$value = intval($_REQUEST['value']);
$user_id = intval($_REQUEST['user_id']);
(string) $management_box = NULL;
(string) $page_handle = 'register';
$msg_changes_saved = '<p align="center" class="contentfont">' . AMSG_CHANGES_SAVED . '</p>';
$form_submitted = false;
$user = new user();
$user->setts = &$setts;
$tax = new tax();
$tax->setts = &$setts;
$balance_v2 = 1; ## balance limit (debit balance option)
if ($_REQUEST['do'] == 'user_details')
{
$row_user = $db->get_sql_row("SELECT u.user_id, u.username, u.email, u.active, u.approved, u.reg_date,
u.payment_mode, u.tax_account_type, u.tax_reg_number, u.tax_apply_exempt, u.tax_exempted,
u.name, u.address, u.city, u.zip_code, u.phone, u.birthdate, u.birthdate_year,
u.tax_company_name, c.name AS country_name, s.name AS state_name, u.state FROM
" . DB_PREFIX ."users u
LEFT JOIN " . DB_PREFIX . "countries s ON u.state=s.id
LEFT JOIN " . DB_PREFIX . "countries c ON u.country=c.id WHERE u.user_id=" . $user_id);
$user_details_print_link = ' [ <a rel="nofollow" rel="nofollow" href="javascript:popUp(\'popup_user_details.php?user_id=' . $row_user['user_id'] . '\');">' . AMSG_PRINT_VIEW . '</a> ]';
$template->set('user_details_print_link', $user_details_print_link);
$user->save_edit_vars($user_id, $page_handle);
$template->set('user_details', $row_user);
$template->set('user_full_address', $user->full_address($row_user));
$template->set('user_birthdate', $user->show_birthdate($row_user));
$template->set('tax_account_type', field_display($row_user['tax_account_type'], GMSG_INDIVIDUAL, GMSG_BUSINESS));
$custom_sections_table = $user->display_sections($row_user, $page_handle, true, $user_id);
$template->set('custom_sections_table', $custom_sections_table);
(string) $ip_address_history_content = null;
$sql_select_iphistory = $db->query("SELECT time1, time2, ip FROM " . DB_PREFIX . "iphistory WHERE
memberid='" . $user_id . "' ORDER by time1 DESC");
if ($db->num_rows($sql_select_iphistory) > 0)
{
while ($iphistory_details = $db->fetch_array($sql_select_iphistory))
{
if ($iphistory_details['time2'] < 1)
{
$iphistory_details['time2'] = $iphistory_details['time1'];
}
$background = ($counter++%2) ? 'c1' : 'c2';
$ip_address_history_content .= '<tr class="' . $background . '"> '.
' <td align="center">' . $iphistory_details['ip'] . '</td> '.
' <td align="center">' . show_date($iphistory_details['time1']) . '</td> '.
' <td align="center">' . show_date($iphistory_details['time2']) . '</td> '.
'</tr> ';
}
}
else
{
$ip_address_history_content .= '<tr class="' . $background . '"> '.
' <td align="center" colspan="3">' . AMSG_USER_HASNT_LOGGED_IPS . '</td> '.
'</tr> ';
}
$template->set('ip_address_history_content', $ip_address_history_content);
$management_box = $template->process('list_site_users_user_details.tpl.php');
}
else if ($_REQUEST['do'] == 'add_user')
{
$template->set('do', $_REQUEST['do']);
$user->save_vars($_POST);
if ($_REQUEST['operation'] == 'submit')
{
define ('FRMCHK_USER', 1);
(bool) $frmchk_user_edit = 0;
$frmchk_details = $_POST;
include ('../includes/procedure_frmchk_user.php'); /* Formchecker for user creation/edit */
if ($fv->is_error())
{
$template->set('display_formcheck_errors', $fv->display_errors());
}
else
{
$form_submitted = true;
$template->set('msg_changes_saved', $msg_changes_saved);
$insert_user_id = $user->insert($_POST);
/**
* since admin creates the user, the user will be automatically activated no matter the site settings.
*/
$sql_update_user = $db->query("UPDATE " . DB_PREFIX . "users SET
active=1, approved=1, payment_status='confirmed', mail_activated=1 WHERE user_id=" . $insert_user_id);
}
}
if (!$form_submitted)
{
$template->set('user_details', $_POST);
$template->set('proceed_button', GMSG_REGISTER_BTN);
$template->set('do', $_REQUEST['do']);
$header_registration_message = '<table width="100%" border="0" cellpadding="3" cellspacing="3" class="border"> ' .
'<tr><td class="c3"><b>' . AMSG_ADD_SITE_USER . '</b></td></tr></table>';
$template->set('header_registration_message', $header_registration_message);
$template->set('register_post_url', 'list_site_users.php');
$template->set('proceed_button', GMSG_REGISTER_BTN);
$post_country = ($_POST['country']) ? $_POST['country'] : $db->get_sql_field("SELECT c.id FROM " . DB_PREFIX . "countries c WHERE
c.parent_id=0 ORDER BY c.country_order ASC, c.name ASC LIMIT 1", 'id');
$template->set('country_dropdown', $tax->countries_dropdown('country', $post_country, 'registration_form'));
$template->set('state_box', $tax->states_box('state', $_POST['state'], $post_country));
$template->set('birthdate_box', $user->birthdate_box($_POST));
$custom_sections_table = $user->display_sections($_POST, $page_handle);
$template->set('custom_sections_table', $custom_sections_table);
$template->set('path_relative', '../');
$template->set('display_direct_payment_methods', $user->direct_payment_methods_edit($_POST));
$template->change_path('../templates/');
$management_box = $template->process('register.tpl.php');
$template->change_path('templates/');
}
}
else if ($_REQUEST['do'] == 'edit_user')
{
$row_user = $db->get_sql_row("SELECT * FROM
" . DB_PREFIX . "users WHERE user_id=" . $user_id);
$username = $row_user['username']; /* the readonly field will not be altered */
if ($_POST['edit_refresh'] == 1)
{
$row_user = $_POST;
$row_user['username'] = $username;
}
if ($_REQUEST['operation'] == 'submit')
{
$user->save_vars($_POST);
define ('FRMCHK_USER', 1);
(bool) $frmchk_user_edit = 1;
$frmchk_details = $_POST;
$row_user = $_POST;
$row_user['username'] = $username; /* the readonly field will not be altered */
include ('../includes/procedure_frmchk_user.php'); /* Formchecker for user creation/edit */
if ($fv->is_error())
{
$template->set('display_formcheck_errors', $fv->display_errors());
}
else
{
$form_submitted = true;
$template->set('msg_changes_saved', $msg_changes_saved);
$new_password = ($_POST['password'] == $_POST['password2'] && !empty($_POST['password'])) ? $_POST['password'] : null;
$user->update($_POST['user_id'], $_POST, $new_password, $page_handle, true);
}
}
if (!$form_submitted)
{
if ($_REQUEST['operation'] != 'submit')
{
$user->save_edit_vars($user_id, $page_handle);
}
if (empty($row_user['first_name']) && empty($row_user['last_name'])) // backward compatibility
{
list($row_user['first_name'], $row_user['last_name']) = @explode(' ', $row_user['name']);
}
$template->set('edit_user', 1);
$template->set('edit_disabled', 'disabled'); /* some fields in the registration will be disabled for editing */
$email_check_value = ($_POST['email_check']) ? $_POST['email_check'] : $row_user['email'];
$template->set('email_check_value', $email_check_value);
if (isset($_POST['tax_account_type']))
{
$row_user['tax_account_type'] = $_POST['tax_account_type'];
}
$template->set('user_details', $row_user);
$template->set('do', $_REQUEST['do']);
$header_registration_message = '<table width="100%" border="0" cellpadding="3" cellspacing="3" class="border"> ' .
'<tr><td class="c3"><b>' . AMSG_EDIT_SITE_USER . '</b></td></tr></table>';
$template->set('header_registration_message', $header_registration_message);
$template->set('register_post_url', 'list_site_users.php');
$template->set('proceed_button', GMSG_UPDATE_BTN);
$template->set('country_dropdown', $tax->countries_dropdown('country', $row_user['country'], 'registration_form'));
$template->set('state_box', $tax->states_box('state', $row_user['state'], $row_user['country']));
$custom_sections_table = $user->display_sections($row_user, $page_handle);
$template->set('custom_sections_table', $custom_sections_table);
$template->set('path_relative', '../');
$template->set('display_direct_payment_methods', $user->direct_payment_methods_edit($row_user));
$template->change_path('../templates/');
$management_box = $template->process('register.tpl.php');
$template->change_path('templates/');
}
}
else if ($_REQUEST['do'] == 'delete_user')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$user = new user();
$user->setts = &$setts;
$user->delete($user_id);
}
else if ($_REQUEST['do'] == 'activate_user')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$user_approved = $db->get_sql_field("SELECT approved FROM " . DB_PREFIX . "users WHERE user_id=" . $user_id, 'approved');
$approved = ($user_approved) ? 1 : $value;
if ($approved)
{## PHP Pro Bid v6.00 users counter - activate/inactivate all the user's auctions## PHP Pro Bid v6.00 but only if his account is approved - also activate/suspend the user's auctions
user_account_management(intval($user_id), $value);
}
if (!$user_approved && $approved)
{
$mail_input_id = intval($user_id);
include('../language/' . $setts['site_lang'] . '/mails/register_success_no_fee_user_notification.php');
}
$db->query("UPDATE " . DB_PREFIX . "users SET
active='" . $value . "', approved='" . $approved . "', suspension_date=0 WHERE
user_id=" . $user_id);
}
else if ($_REQUEST['do'] == 'tax_exempt')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$db->query("UPDATE " . DB_PREFIX . "users SET
tax_exempted='" . $value . "' WHERE
user_id=" . $user_id);
}
else if ($_REQUEST['do'] == 'can_sell')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$db->query("UPDATE " . DB_PREFIX . "users SET
is_seller='" . $value . "' WHERE
user_id=" . $user_id);
}
else if ($_REQUEST['do'] == 'verify_seller')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$db->query("UPDATE " . DB_PREFIX . "users SET
seller_verified='" . $value . "', seller_verif_next_payment=0 WHERE
user_id=" . $user_id);
}
else if ($_REQUEST['do'] == 'verify_bidder')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$db->query("UPDATE " . DB_PREFIX . "users SET
bidder_verified='" . $value . "', bidder_verif_next_payment=0 WHERE
user_id=" . $user_id);
}
else if ($_REQUEST['do'] == 'preferred_seller')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$expiration_date = ($setts['preferred_days'] > 0 && $value) ? (CURRENT_TIME + $setts['preferred_days'] * 24 * 60 * 60) : 0;
$db->query("UPDATE " . DB_PREFIX . "users SET
preferred_seller='" . $value . "', preferred_seller_exp_date='" . intval($expiration_date) . "' WHERE
user_id=" . $user_id);
}
else if ($_REQUEST['do'] == 'is_seller')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$db->query("UPDATE " . DB_PREFIX . "users SET
is_seller='" . $value . "' WHERE
user_id=" . $user_id);
}
else if ($_REQUEST['do'] == 'auction_approval')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$db->query("UPDATE " . DB_PREFIX . "users SET
auction_approval='" . $value . "' WHERE
user_id=" . $user_id);
}
else if ($_REQUEST['do'] == 'payment_mode')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$db->query("UPDATE " . DB_PREFIX . "users SET
payment_mode='" . $value . "' WHERE
user_id=" . $user_id);
}
else if ($_REQUEST['do'] == 'store_default_account')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$db->query("UPDATE " . DB_PREFIX . "users SET
shop_active='1', shop_account_id='0', shop_next_payment='0' WHERE
user_id=" . $user_id);
}
else if ($_REQUEST['do'] == 'payment_reminder')
{
$template->set('msg_changes_saved', '<p align="center">' . AMSG_INVOICE_SENT_SUCCESS . '</p>');
$mail_input_id = $user_id;
include('../language/' . $setts['site_lang'] . '/mails/user_payment_reminder.php');
}
else if ($_REQUEST['do'] == 'payment_reminder_v2')
{
$template->set('msg_changes_saved', '<p align="center">' . AMSG_INVOICES_SENT_SUCCESS . '</p>');
$sql_src_filter = null;
if ($setts['account_mode'] == 2 || $setts['account_mode_personal'] == 1)
{
$sql_src_filter .= (($sql_src_filter) ? ' AND' : ' WHERE') . " u.balance>=" . $balance_v2;
if ($setts['account_mode_personal'] == 1)
{
$sql_src_filter .= (($sql_src_filter) ? ' AND' : ' WHERE') . " u.payment_mode=2";
}
}
else
{
$sql_src_filter .= (($sql_src_filter) ? ' AND' : ' WHERE') . " u.user_id=0";
}
$sql_select_debit_users = $db->query("SELECT u.user_id FROM " . DB_PREFIX . "users u " . $sql_src_filter);
while($balance_user = $db->fetch_array($sql_select_debit_users))
{
$mail_input_id = $balance_user['user_id'];
include('../language/' . $setts['site_lang'] . '/mails/user_payment_reminder.php');
}
}
else if ($_REQUEST['do'] == 'mail_activated')
{
$template->set('msg_changes_saved', $msg_changes_saved);
$db->query("UPDATE " . DB_PREFIX . "users SET
mail_activated='1' WHERE
user_id=" . $user_id);
}
$template->set('management_box', $management_box);
$limit = 20;
$order_field = ($_REQUEST['order_field']) ? $_REQUEST['order_field'] : 'u.reg_date';
$order_type = ($_REQUEST['order_type']) ? $_REQUEST['order_type'] : 'DESC';
$additional_vars = '&keywords_name=' . $_REQUEST['keywords_name'] . '&keywords_email=' . $_REQUEST['keywords_email'];
$order_link = '&order_field=' . $order_field . '&order_type=' . $order_type;
$limit_link = '&start=' . $start . '&limit=' . $limit;
$show_link = '&show=' . $_REQUEST['show'];
(string) $search_filter = null;
if ($_REQUEST['keywords_name'])
{
//$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " MATCH(u.username) AGAINST ('".$_REQUEST['keywords_name']."' WITH QUERY EXPANSION)";
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.username LIKE '%".$_REQUEST['keywords_name']."%'";
$template->set('keywords_name', $_REQUEST['keywords_name']);
}
if ($_REQUEST['keywords_email'])
{
// $search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " MATCH(u.email) AGAINST ('".$_REQUEST['keywords_email']."*' IN BOOLEAN MODE)";
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.email LIKE '%".$_REQUEST['keywords_email']."%'"; /* slow query - will need a workaround */
$template->set('keywords_email', $_REQUEST['keywords_email']);
}
if ($_REQUEST['show'] == 'active')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.active=1 AND u.approved=1";
}
else if ($_REQUEST['show'] == 'suspended')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " (u.active=0 OR u.approved=0)";
}
else if ($_REQUEST['show'] == 'individual')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.tax_account_type=0";
}
else if ($_REQUEST['show'] == 'business')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.tax_account_type=1";
}
else if ($_REQUEST['show'] == 'tax_apply_exempt')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.tax_apply_exempt=1 AND u.tax_exempted=0";
}
else if ($_REQUEST['show'] == 'tax_exempted')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.tax_exempted=1";
}
else if ($_REQUEST['show'] == 'accounting_overdue')
{
if ($setts['account_mode'] == 2 || $setts['account_mode_personal'] == 1)
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.balance>0";
if ($setts['account_mode_personal'] == 1)
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.payment_mode=2";
}
}
else
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.user_id=0";
}
}
else if ($_REQUEST['show'] == 'accounting_overdue_v2')
{
if ($setts['account_mode'] == 2 || $setts['account_mode_personal'] == 1)
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.balance>=" . $balance_v2;
if ($setts['account_mode_personal'] == 1)
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.payment_mode=2";
}
}
else
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.user_id=0";
}
}
else if ($_REQUEST['show'] == 'mail_activated')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.mail_activated=0";
}
else if ($_REQUEST['show'] == 'sellers')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.is_seller=1";
}
else if ($_REQUEST['show'] == 'verified')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.seller_verified=1";
}
else if ($_REQUEST['show'] == 'verified_bidders')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.bidder_verified=1";
}
else if ($_REQUEST['show'] == 'preferred')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.preferred_seller=1";
}
else if ($_REQUEST['show'] == 'store_owners')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.shop_active=1";
}
else if ($_REQUEST['show'] == 'awaiting_approval')
{
$search_filter .= (($search_filter) ? ' AND' : ' WHERE') . " u.approved=0 AND u.mail_activated=1";
}
$nb_users = $db->count_rows('users u', $search_filter);
$template->set('query_results_message', display_pagination_results($start, $limit, $nb_users));
$sql_select_users = $db->query("SELECT u.user_id, u.name, u.username, u.email, u.active, u.approved, u.reg_date,
u.payment_mode, u.balance, u.tax_account_type, u.tax_reg_number, u.tax_apply_exempt, u.tax_exempted,
u.is_seller, u.preferred_seller, u.auction_approval, u.seller_verified, u.preferred_seller_exp_date,
u.tax_company_name, c.name AS country_name, s.name AS state_name, u.mail_activated, u.bidder_verified FROM
" . DB_PREFIX ."users u
LEFT JOIN " . DB_PREFIX . "countries c ON u.country=c.id
LEFT JOIN " . DB_PREFIX . "countries s ON u.state=s.id
" . $search_filter . "
ORDER BY " . $order_field . " " . $order_type . " LIMIT " . $start . ", " . $limit);
while ($user_details = $db->fetch_array($sql_select_users))
{
$background = ($counter++%2) ? 'c1' : 'c2';
$user_country = $tax->show_country($user_details['country_name'], $user_details['state_name']);
$is_seller = $user->can_sell($user_details['is_seller']);
$site_users_content .= '<tr class="' . $background . '"> '.
' <td valign="top">' . $user_details['username'] . user_pics($user_details['user_id']) . '<br>' .
' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=user_details&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '">' . AMSG_USER_DETAILS . '</a> ]<br>'.
' [ <a rel="nofollow" rel="nofollow" href="list_user_bids.php?user_id=' . $user_details['user_id'] . '">' . AMSG_VIEW_BIDS . '</a> ]<br>'.
' [ <a rel="nofollow" rel="nofollow" href="email_user.php?user_id=' . $user_details['user_id'] . '">' . AMSG_EMAIL_USER . '</a> ]';
if ($is_seller)
{
$site_users_content .= '<br>[ <a rel="nofollow" rel="nofollow" href="list_auctions.php?status=open&owner_id=' . $user_details['user_id'] . '">' . AMSG_VIEW_OPEN_AUCTIONS . '</a> ]';
}
$site_users_content .= '</td> '.
' <td valign="top">' . AMSG_NAME . ': ' . $user_details['name'] . '<br>' .
' ' . AMSG_COUNTRY . ': ' . $user_country . '<br>' .
' ' . AMSG_EMAIL_ADDR . ': ' . $user_details['email'] . '<br>' .
' ' . AMSG_REG_DATE . ': ' . show_date($user_details['reg_date']) .
(($setts['enable_pref_sellers'] && $user_details['preferred_seller_exp_date'] > 0) ? '<br><br>' . GMSG_PREFERRED_SELLER_EXP_DATE . ':<br> ' . show_date($user_details['preferred_seller_exp_date']) : '') .
' </td> ' .
' <td valign="top">' . GMSG_ACCOUNT_STATUS . ': <b>' . $user->account_status($user_details['active'], $user_details['approved']) . '</b>';
// get user payment mode.
$user_payment_mode_display = $user->payment_mode_desc($user_details['payment_mode']);
$user_payment_mode = $tax->user_payment_mode($user_details['user_id']);
if ($setts['account_mode_personal'] == 1)
{
$live_payment_mode = ($user_payment_mode == 1) ? 1 : 0;
$payment_mode_live_link = $user_payment_mode_display . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=payment_mode&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=2">' . GMSG_CHANGE_TO_ACCOUNT . '</a> ]';
$payment_mode_account_link = $user_payment_mode_display . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=payment_mode&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=1">' . GMSG_CHANGE_TO_LIVE . '</a> ]';
$payment_mode_link = field_display($live_payment_mode, $payment_mode_account_link, $payment_mode_live_link);
}
else
{
$payment_mode_link = $user_payment_mode_display;
}
$site_users_content .= '<br><br>' . AMSG_PAYMENT_MODE . ': <b>' . $payment_mode_link . '</b>';
if ($user_payment_mode == 2)
{
$site_users_content .= '<br>' . GMSG_BALANCE . ': <b>' . $user->show_balance($user_details['balance'], $setts['currency']) . '</b><br>'.
'[ <a rel="nofollow" rel="nofollow" href="accounting.php?user_id=' . $user_details['user_id'] . '">' . AMSG_VIEW_ACCOUNT_HISTORY . '</a> ]';
if ($user_details['balance'] > 0)
{
$site_users_content .= '<br>[ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=payment_reminder&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '">' . AMSG_SEND_PAYMENT_REMINDER . '</a> ]';
}
}
$site_users_content .= '<br>';
$verified_bidder_enable_link = GMSG_NO . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=verify_bidder&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=1">' . GMSG_VERIFY . '</a> ]';
$verified_bidder_disable_link = GMSG_YES . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=verify_bidder&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=0">' . GMSG_UNVERIFY . '</a> ]';
$site_users_content .= '<br>' . AMSG_VERIFIED_BIDDER .': <b>' . field_display($user_details['bidder_verified'], $verified_bidder_enable_link, $verified_bidder_disable_link) . '</b>';
if ($setts['enable_private_site'])
{
$can_sell_enable_link = GMSG_NO . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=can_sell&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=1">' . GMSG_ENABLE . '</a> ]';
$can_sell_disable_link = GMSG_YES . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=can_sell&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=0">' . GMSG_DISABLE . '</a> ]';
$site_users_content .= '<br>' . AMSG_SELLING_CAPABILITIES .': <b>' . field_display($user_details['is_seller'], $can_sell_enable_link, $can_sell_disable_link) . '</b>';
}
$verified_seller_enable_link = GMSG_NO . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=verify_seller&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=1">' . GMSG_VERIFY . '</a> ]';
$verified_seller_disable_link = GMSG_YES . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=verify_seller&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=0">' . GMSG_UNVERIFY . '</a> ]';
$site_users_content .= '<br>' . AMSG_VERIFIED_SELLER .': <b>' . field_display($user_details['seller_verified'], $verified_seller_enable_link, $verified_seller_disable_link) . '</b>';
if ($setts['enable_pref_sellers'])
{
$pref_seller_enable_link = GMSG_NO . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=preferred_seller&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=1">' . GMSG_ENABLE . '</a> ]';
$pref_seller_disable_link = GMSG_YES . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=preferred_seller&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=0">' . GMSG_DISABLE . '</a> ]';
$site_users_content .= '<br>' . AMSG_PREF_SELLER .': <b>' . field_display($user_details['preferred_seller'], $pref_seller_enable_link, $pref_seller_disable_link) . '</b>';
}
if (!$setts['enable_auctions_approval'])
{
$auct_approval_enable_link = GMSG_NO . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=auction_approval&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=1">' . GMSG_ENABLE . '</a> ]';
$auct_approval_disable_link = GMSG_YES . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=auction_approval&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=0">' . GMSG_DISABLE . '</a> ]';
$site_users_content .= '<br>' . AMSG_REQUIRE_AUCT_APPROVAL .': <b>' . field_display($user_details['auction_approval'], $auct_approval_enable_link, $auct_approval_disable_link) . '</b>';
}
if ($setts['enable_stores'])
{
$site_users_content .= '<br>' . AMSG_ASSIGN_DEFAULT_STORE_ACCOUNT .': <b>[ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=store_default_account&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '">' . GMSG_PROCEED . '</a> ]</b>';
}
$site_users_content .= '</td> ';
if ($setts['enable_tax'])
{
$tax_exempt_enable_link = GMSG_NO . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=tax_exempt&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=1">' . GMSG_ENABLE . '</a> ]';
$tax_exempt_disable_link = GMSG_YES . ' [ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=tax_exempt&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=0">' . GMSG_DISABLE . '</a> ]';
$site_users_content .= '<td valign="top">' . AMSG_REGISTERED_AS . ': <b>' . field_display($user_details['tax_account_type'], GMSG_INDIVIDUAL, GMSG_BUSINESS) . '</b><br>' .
AMSG_APPLIED_FOR_TAX_EXEMPT . ': <b>' . field_display($user_details['tax_apply_exempt'], GMSG_NO, GMSG_YES) . '</b><br>' .
AMSG_COMPANY_NAME . ': ' . field_display($user_details['tax_company_name']) . '<br>' .
AMSG_TAX_REG_NUMBER . ': <b>' . field_display($user_details['tax_reg_number']) . '</b><br>' .
AMSG_TAX_EXEMPTED .': <b>' . field_display($user_details['tax_exempted'], $tax_exempt_enable_link, $tax_exempt_disable_link) . '</b></td> ';
}
(string) $site_user_options = null;
if ($user_details['approved'])
{
if ($user_details['active'])
{
$site_user_options .= '[ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=activate_user&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=0">' . AMSG_SUSPEND . '</a> ]';
}
else
{
$site_user_options .= '[ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=activate_user&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=1">' . AMSG_ACTIVATE . '</a> ]';
}
}
else
{
$site_user_options .= '[ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=activate_user&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '&value=1">' . AMSG_APPROVE . '</a> ]';
}
$site_user_options .= '<br>[ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=edit_user&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '">' . AMSG_EDIT . '</a> ] '.
'[ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=delete_user&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '" onclick="return confirm(\'' . AMSG_DELETE_CONFIRM . '\');">' . AMSG_DELETE . '</a> ]';
if (!$user_details['mail_activated'])
{
$site_user_options .= '<br>[ <a rel="nofollow" rel="nofollow" href="list_site_users.php?do=mail_activated&user_id=' . $user_details['user_id'] . $additional_vars . $order_link . $limit_link . $show_link . '">' . AMSG_VERIFY_EMAIL_ADDRESS . '</a> ] ';
}
$site_users_content .= '<td align="center">' . $site_user_options . ' </td>'.
'</tr> ';
}
$template->set('site_users_content', $site_users_content);
$template->set('show', $_REQUEST['show']);
(string) $filter_users_content = null;
$filter_users_content .= display_link('list_site_users.php', GMSG_ALL, ((!$_REQUEST['show']) ? false : true)) . ' | ';
$filter_users_content .= display_link('list_site_users.php?show=active', GMSG_ACTIVE, (($_REQUEST['show'] == 'active') ? false : true)) . ' | ';
$filter_users_content .= display_link('list_site_users.php?show=suspended', GMSG_SUSPENDED, (($_REQUEST['show'] == 'suspended') ? false : true)) . ' | ';
$filter_users_content .= display_link('list_site_users.php?show=accounting_overdue', AMSG_ACCOUNTING_OVERDUE, (($_REQUEST['show'] == 'accounting_overdue') ? false : true)) . ' | ';
$filter_users_content .= display_link('list_site_users.php?show=accounting_overdue_v2', AMSG_DEBIT_BALANCE_LIMIT, (($_REQUEST['show'] == 'accounting_overdue_v2') ? false : true)) . ' | ';
$filter_users_content .= display_link('list_site_users.php?show=mail_activated', AMSG_MAIL_UNVERIFIED, (($_REQUEST['show'] == 'mail_activated') ? false : true)) . ' | ';
$filter_users_content .= display_link('list_site_users.php?show=awaiting_approval', AMSG_AWAITING_APPROVAL, (($_REQUEST['show'] == 'awaiting_approval') ? false : true));
if ($setts['enable_tax'])
{
$filter_users_content .= '<br>';
$filter_users_content .= display_link('list_site_users.php?show=individual', GMSG_INDIVIDUAL, (($_REQUEST['show'] == 'individual') ? false : true)) . ' | ';
$filter_users_content .= display_link('list_site_users.php?show=business', GMSG_BUSINESS, (($_REQUEST['show'] == 'business') ? false : true)) . ' | ';
$filter_users_content .= display_link('list_site_users.php?show=tax_apply_exempt', AMSG_APPLIED_FOR_TAX_EXEMPT, (($_REQUEST['show'] == 'tax_apply_exempt') ? false : true)) . ' | ';
$filter_users_content .= display_link('list_site_users.php?show=tax_exempted', AMSG_TAX_EXEMPTED, (($_REQUEST['show'] == 'tax_exempted') ? false : true));
}
$filter_users_content .= '<br>';
if ($setts['enable_private_site'])
{
$filter_users_content .= display_link('list_site_users.php?show=sellers', AMSG_SELLERS, (($_REQUEST['show'] == 'sellers') ? false : true)) . ' | ';
}
if ($setts['enable_pref_sellers'])
{
$filter_users_content .= display_link('list_site_users.php?show=preferred', AMSG_PREF_SELLERS, (($_REQUEST['show'] == 'preferred') ? false : true)) . ' | ';
}
if ($setts['enable_stores'])
{
$filter_users_content .= display_link('list_site_users.php?show=store_owners', AMSG_STORE_OWNERS, (($_REQUEST['show'] == 'store_owners') ? false : true)) . ' | ';
}
if ($setts['enable_seller_verification'])
{
$filter_users_content .= display_link('list_site_users.php?show=verified', AMSG_VERIFIED_SELLERS, (($_REQUEST['show'] == 'verified') ? false : true)) . ' | ';
}
if ($setts['enable_bidder_verification'])
{
$filter_users_content .= display_link('list_site_users.php?show=verified_bidders', AMSG_VERIFIED_BIDDERS, (($_REQUEST['show'] == 'verified') ? false : true));
}
$template->set('filter_users_content', $filter_users_content);
$pagination = paginate($start, $limit, $nb_users, 'list_site_users.php', $additional_vars . $order_link . $show_link);
$template->set('pagination', $pagination);
$template->set('header_section', AMSG_USERS_MANAGEMENT);
$template->set('subpage_title', AMSG_USERS_MANAGEMENT);
$template->set('page_order_username', page_order('list_site_users.php', 'u.username', $start, $limit, $additional_vars . $show_link, AMSG_USERNAME));
$template->set('page_order_reg_date', page_order('list_site_users.php', 'u.reg_date', $start, $limit, $additional_vars . $show_link, AMSG_REG_DATE));
$template_output .= $template->process('list_site_users.tpl.php');
include_once ('footer.php');
echo $template_output;
}
?>
Nevím kde je chyba :(
Nahlásit jako SPAM
IP: 95.85.212.–
Guru
Zjistit počet nových příspěvků
