connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']); $refguid = $sqlm->result($sqlm->query('SELECT InvitedBy FROM point_system_invites WHERE PlayersAccount = \''.$user_id.'\''), 0, 'InvitedBy'); $referred_by = $sqlc->result($sqlc->query('SELECT name FROM characters WHERE guid = \''.$refguid.'\''), 0, 'name'); unset($refguid); if ($acc = $sqlc->fetch_assoc($sqlr->query('SELECT email, gmlevel, joindate, expansion, last_ip FROM account WHERE username = \''.$user_name.'\''))) { $output .= '
'.$lang_edit['edit_acc'].'
'; if ($expansion_select) { $output .= ' '; } $output .= ' '; $realms = $sqlr->query('SELECT id, name FROM realmlist'); if ( $developer_test_mode && $multi_realm_mode && ( 1 < $sqlr->num_rows($realms) && (1 < count($server)) && (1 < count($characters_db)) ) ) { while ($realm = $sqlr->fetch_assoc($realms)) { $sqlc->connect($characters_db[$realm['id']]['addr'], $characters_db[$realm['id']]['user'], $characters_db[$realm['id']]['pass'], $characters_db[$realm['id']]['name']); $result = $sqlc->query('SELECT guid, name, race, class, level, gender FROM characters WHERE account = '.$user_id.''); $output .= ' '; while ($char = $sqlc->fetch_assoc($result)) { $output .= ' '; } } unset($realm); } else { $result = $sqlc->query('SELECT guid, name, race, class, level, gender FROM characters WHERE account = '.$user_id.''); $output .= ' '; while ($char = $sqlc->fetch_assoc($result)) { $output .= ' '; } } unset($result); unset($realms); $output .= '
'.$lang_edit['id'].' '.$user_id.'
'.$lang_edit['username'].' '.$user_name.'
'.$lang_edit['password'].'
'.$lang_edit['mail'].'
'.$lang_edit['invited_by'].': '; if ($referred_by == NULL) $output .= ' '; else $output .= ' '.$referred_by.''; $output .= '
'.$lang_edit['gm_level'].' '.id_get_gm_level($acc['gmlevel']).' ( '.$acc['gmlevel'].' )
'.$lang_edit['join_date'].' '.$acc['joindate'].'
'.$lang_edit['last_ip'].' '.$acc['last_ip'].'
'.$lang_edit['client_type'].':
'.$lang_edit['tot_chars'].' '.$sqlr->result($sqlr->query('SELECT SUM(numchars) FROM realmcharacters WHERE acctid = '.$user_id.''), 0).'
'.$lang_edit['characters'].' '.$realm['name'].' '.$sqlc->num_rows($result).'
      \'---> '.$char['name'].' - - lvl '.char_get_level_color($char['level']).'
'.$lang_edit['characters'].' '.$sqlc->num_rows($result).'
      \'---> '.$char['name'].' - - lvl '.char_get_level_color($char['level']).'
'; makebutton($lang_edit['update'], 'javascript:do_submit_data()" type="wrn', 130); $output .= ' '; makebutton($lang_global['back'], 'javascript:window.history.back()" type="def', 130); $output .= '

'.$lang_edit['theme_options'].'

'; } else error($lang_global['err_no_records_found']); } //############################################################################################################# // DO EDIT USER //############################################################################################################# function doedit_user(&$sqlr, &$sqlc) { global $output, $user_name; if ( (empty($_POST['pass'])||($_POST['pass'] === '')) && (empty($_POST['mail'])||($_POST['mail'] === '')) && (empty($_POST['expansion'])||($_POST['expansion'] === '')) && (empty($_POST['referredby'])||($_POST['referredby'] === '')) ) redirect('edit.php?error=1'); $new_pass = ($sqlr->quote_smart($_POST['pass']) == sha1(strtoupper($user_name).':******')) ? '' : 'sha_pass_hash=\''.$sqlr->quote_smart($_POST['pass']).'\', '; $new_mail = $sqlr->quote_smart(trim($_POST['mail'])); $new_expansion = $sqlr->quote_smart(trim($_POST['expansion'])); $referredby = $sqlr->quote_smart(trim($_POST['referredby'])); //make sure the mail is valid mail format require_once 'libs/valid_lib.php'; if ((valid_email($new_mail)) && (strlen($new_mail) < 225)); else redirect('edit.php?error=2'); $sqlr->query('UPDATE account SET email = \''.$new_mail.'\', '.$new_pass.' v=0, s=0, expansion = \''.$new_expansion.'\' WHERE username = \''.$user_name.'\''); if (doupdate_referral($referredby, $sqlr, $sqlc) || $sqlr->affected_rows()) redirect('edit.php?error=3'); else redirect('edit.php?error=4'); } function doupdate_referral($referredby, &$sqlr, &$sqlc) { global $mmfpm_db, $user_id; $sqlm = new SQL; $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']); if (NULL == $sqlm->result($sqlm->query('SELECT InvitedBy FROM point_system_invites WHERE PlayersAccount = \''.$user_id.'\''), 0)) { $referred_by = $sqlc->result($sqlc->query('SELECT guid FROM characters WHERE name = \''.$referredby.'\''), 0); if ($referred_by == NULL); else { $char = $sqlc->result($sqlc->query('SELECT account FROM characters WHERE guid = \''.$referred_by.'\''), 0, 'account'); $result = $sqlr->result($sqlr->query('SELECT id FROM account WHERE id = \''.$char.'\''), 0, 'id'); if ($result == $user_id); else { $sqlm->query('INSERT INTO point_system_invites (PlayersAccount, InvitedBy, InviterAccount) VALUES (\''.$user_id.'\', \''.$referred_by.'\', \''.$result.'\')'); return true; } } } return false; } //############################################################################################################### // SET DEFAULT INTERFACE LANGUAGE //############################################################################################################### function lang_set() { if (empty($_GET['lang'])) redirect('edit.php?error=1'); else $lang = addslashes($_GET['lang']); if ($lang) { setcookie('lang', $lang, time()+60*60*24*30*6); //six month redirect('edit.php'); } else redirect('edit.php?error=1'); } //############################################################################################################### // SET DEFAULT INTERFACE THEME //############################################################################################################### function theme_set() { if (empty($_GET['theme'])) redirect('edit.php?error=1'); else $tmpl = addslashes($_GET['theme']); if ($tmpl) { setcookie('theme', $tmpl, time()+3600*24*30*6); //six month redirect('edit.php'); } else redirect('edit.php?error=1'); } //############################################################################################################### // MAIN //############################################################################################################### $err = (isset($_GET['error'])) ? $_GET['error'] : NULL; $output .= '
'; $lang_edit = lang_edit(); if(1 == $err) $output .= '

'.$lang_global['empty_fields'].'

'; else if(2 == $err) $output .= '

'.$lang_edit['use_valid_email'].'

'; else if(3 == $err) $output .= '

'.$lang_edit['data_updated'].'

'; else if(4 == $err) $output .= '

'.$lang_edit['error_updating'].'

'; else if(5 == $err) $output .= '

'.$lang_edit['del_error'].'

'; else $output .= '

'.$lang_edit['edit_your_acc'].'

'; unset($err); $output .= '
'; $action = (isset($_GET['action'])) ? $_GET['action'] : NULL; if ('doedit_user' == $action) doedit_user($sqlr, $sqlc); else if('lang_set' == $action) lang_set(); else if('theme_set' == $action) theme_set(); else edit_user($sqlr, $sqlc); unset($action); unset($action_permission); unset($lang_edit); require_once 'footer.php'; ?>