function ResetPassword() { global $template, $DB; $t = new Template(); // Form submitted if ($_SERVER['REQUEST_METHOD'] == 'POST') { $password = RandomPassword(); $domain = preg_replace('~^www\\.~', '', $_SERVER['HTTP_HOST']); $t->assign('password', $password); $t->assign('control_panel', "http://{$_SERVER['HTTP_HOST']}" . dirname($_SERVER['REQUEST_URI']) . "/index.php"); $DB->Update('DELETE FROM lx_administrators WHERE username=?', array('administrator')); $DB->Update('INSERT INTO lx_administrators VALUES (?,?,?,?,?,?,?,?,?,?)', array('administrator', sha1($password), '', 0, 'Administrator', 'webmaster@$domain', 'administrator', '', 0, 0)); $DB->Disconnect(); $t->assign('mode', 'confirmed'); } else { $t->assign('mode', 'confirm'); } echo $t->parse($template); }
function lxPasswordReset() { global $DB, $C, $t, $L; $confirmation = $DB->Row('SELECT * FROM lx_user_confirms WHERE confirmation_id=?', array($_REQUEST['id'])); if ($confirmation) { $DB->Update('DELETE FROM lx_user_confirms WHERE confirmation_id=?', array($_REQUEST['id'])); $account = $DB->Row('SELECT * FROM lx_users WHERE username=?', array($confirmation['username'])); if (!$account) { $t->assign('error', $L['INVALID_CONFIRMATION']); } else { $account['password'] = RandomPassword(); $DB->Update('UPDATE lx_users SET password=?,session=?,session_start=? WHERE username=?', array(sha1($account['password']), null, 0, $account['username'])); $t->assign_by_ref('account', $account); SendMail($account['email'], 'email-account-password.tpl', $t); } } else { $t->assign('error', $L['INVALID_CONFIRMATION']); } $t->display('account-forgot-confirmed.tpl'); }
function InitializeTables() { global $DB; $tables = GetDBTables(); foreach ($tables as $table) { $create = GetDBCreate($table); $DB->Update($create); } $password = RandomPassword(); $DB->Update('DELETE FROM `tbx_administrator` WHERE `username`=?', array('administrator')); $DB->Update('INSERT INTO `tbx_administrator` VALUES (?,?,?,?,?,?)', array('administrator', sha1($password), 'webmaster@' . preg_replace('~^www\\.~', '', $_SERVER['HTTP_HOST']), 'Administrator', 'Superuser', 0)); $DB->Update('DELETE FROM `tbx_user_level` WHERE `name` IN (?,?)', array('Guest', 'Standard')); $DB->Update('INSERT INTO `tbx_user_level` VALUES (NULL,?,0,0,1,0)', array('Guest')); $DB->Update('INSERT INTO `tbx_user_level` VALUES (NULL,?,0,0,0,1)', array('Standard')); return $password; }
function tlxPasswordResetConfirmed($errors = null) { global $C, $DB, $L, $t; // Delete old confirmations $DB->Update('DELETE FROM `tlx_account_confirms` WHERE `date_sent` < DATE_ADD(?, INTERVAL -1 DAY)', array(MYSQL_NOW)); $confirmation = $DB->Row('SELECT * FROM `tlx_account_confirms` WHERE `confirm_id`=?', array($_REQUEST['id'])); if ($confirmation) { $DB->Update('DELETE FROM `tlx_account_confirms` WHERE `confirm_id`=?', array($_REQUEST['id'])); $account = $DB->Row('SELECT * FROM `tlx_accounts` WHERE `username`=?', array($confirmation['username'])); if (!$account) { $t->assign('error', $L['INVALID_CONFIRMATION']); } else { $account['password'] = RandomPassword(); $DB->Update('UPDATE `tlx_accounts` SET `password`=? WHERE `username`=?', array(sha1($account['password']), $account['username'])); $DB->Update('DELETE FROM `tlx_account_logins` WHERE `username`=?', array($account['username'])); $t->assign_by_ref('account', $account); SendMail($account['email'], 'email-account-password-confirmed.tpl', $t); } } else { $t->assign('error', $L['INVALID_CONFIRMATION']); } $t->display('accounts-password-reset-confirmed.tpl'); }
function txPartnerApprove() { global $DB, $json, $C; VerifyPrivileges(P_PARTNER_ADD, TRUE); $t = new Template(); $t->assign_by_ref('config', $C); $result = GetWhichPartners(); $amount = $DB->NumRows($result); while ($partner = $DB->NextRow($result)) { $data = $_REQUEST['partner'][$partner['username']]; $password = RandomPassword(); if (!in_array('__ALL__', $data['categories'])) { $data['categories'] = serialize($data['categories']); } else { $data['categories'] = null; } NullIfEmpty($data['date_start']); NullIfEmpty($data['date_end']); $DB->Update('UPDATE `tx_partners` SET ' . '`name`=?, ' . '`password`=?, ' . '`date_start`=?, ' . '`date_end`=?, ' . '`per_day`=?, ' . '`weight`=?, ' . '`categories`=?, ' . '`status`=?, ' . '`allow_redirect`=?, ' . '`allow_norecip`=?, ' . '`allow_autoapprove`=?, ' . '`allow_noconfirm`=?, ' . '`allow_blacklist`=? ' . 'WHERE `username`=?', array($data['name'], sha1($password), $data['date_start'], $data['date_end'], $data['per_day'], $data['weight'], $data['categories'], 'active', intval($data['allow_redirect']), intval($data['allow_norecip']), intval($data['allow_autoapprove']), intval($data['allow_noconfirm']), intval($data['allow_blacklist']), $partner['username'])); // Update user defined fields UserDefinedUpdate('tx_partner_fields', 'tx_partner_field_defs', 'username', $partner['username'], $data); $partner = array_merge($DB->Row('SELECT * FROM `tx_partners` WHERE `username`=?', array($partner['username'])), $DB->Row('SELECT * FROM `tx_partner_fields` WHERE `username`=?', array($partner['username']))); $partner['password'] = $password; // Send confirmation e-mail $t->assign_by_ref('partner', $partner); SendMail($partner['email'], 'email-partner-added.tpl', $t); } $DB->Free($result); echo $json->encode(array('status' => JSON_SUCCESS, 'message' => "{$amount} partner" . ($amount == 1 ? ' has' : 's have') . " been approved")); }
function CreateTables() { global $t; $DB = new DB($_REQUEST['db_hostname'], $_REQUEST['db_username'], $_REQUEST['db_password'], $_REQUEST['db_name']); $DB->Connect(); $tables = array(); IniParse("{$GLOBALS['BASE_DIR']}/includes/tables.php", TRUE, $tables); foreach ($tables as $name => $create) { $DB->Update("CREATE TABLE IF NOT EXISTS {$name} ( {$create} ) TYPE=MyISAM"); } $password = RandomPassword(); $domain = preg_replace('~^www\\.~', '', $_SERVER['HTTP_HOST']); $t->assign('password', $password); $DB->Update('DELETE FROM lx_administrators WHERE username=?', array('administrator')); $DB->Update('INSERT INTO lx_administrators VALUES (?,?,?,?,?,?,?,?,?,?)', array('administrator', sha1($password), '', 0, 'Administrator', "webmaster@{$domain}", 'administrator', '', 0, 0)); $DB->Disconnect(); }
http://www.oscommerce.com Copyright (c) 2002 - 2003 osCommerce ---------------------------------------------------------------------- Released under the GNU General Public License ---------------------------------------------------------------------- */ /** ensure this file is being included by a parent file */ defined('OOS_VALID_MOD') or die('Direct Access to this location is not allowed.'); function RandomPassword($passwordLength) { $newkey = ""; for ($index = 1; $index <= $passwordLength; $index++) { // Pick random number between 1 and 62 $randomNumber = rand(1, 62); // Select random character based on mapping. if ($randomNumber < 11) { $newkey .= Chr($randomNumber + 48 - 1); } else { if ($randomNumber < 37) { $newkey .= Chr($randomNumber + 65 - 10); } else { $newkey .= Chr($randomNumber + 97 - 36); } } // [37,62] => [a,z] } return $newkey; } $passwordLength = 24; $newkey = RandomPassword($passwordLength); $dbconn->Execute("UPDATE " . $oostable['manual_info'] . " SET man_key = '" . $newkey . "', man_key2 = '', man_key3 = '' WHERE man_info_id = '1' ");
function tbxDisplayResetConfirm() { global $t; $DB = GetDB(); $v = Validator::Create(); // Remove expired codes $DB->Update('DELETE FROM `tbx_user_reset_code` WHERE `timestamp` < ?', array(time() - 3600)); $confirmation = $DB->Row('SELECT * FROM `tbx_user` JOIN `tbx_user_reset_code` USING (`username`) WHERE `reset_code`=?', array($_REQUEST['code'])); $v->Register(empty($confirmation), Validator_Type::IS_FALSE, _T('Validation:Invalid confirmation code')); if (!$v->Validate()) { $t->Assign('g_errors', $v->GetErrors()); } else { $DB->Update('DELETE FROM `tbx_user_reset_code` WHERE `username`=?', array($confirmation['username'])); $user = $DB->Row('SELECT * FROM `tbx_user` JOIN `tbx_user_custom` USING (`username`) JOIN `tbx_user_stat` USING (`username`) WHERE `tbx_user`.`username`=?', array($confirmation['username'])); $password = RandomPassword(); DatabaseUpdate('tbx_user', array('username' => $user['username'], 'password' => sha1($password))); $t->AssignByRef('g_user', $user); $t->Assign('g_password', $password); $m = new Mailer(); $m->Mail('email-user-reset.tpl', $t, $user['email'], $user['name']); } $t->Display('user-reset-confirmed.tpl'); }
function CreateTables() { global $t, $DB; $DB = new DB($_REQUEST['db_hostname'], $_REQUEST['db_username'], $_REQUEST['db_password'], $_REQUEST['db_name']); $DB->Connect(); $tables = array(); IniParse("{$GLOBALS['BASE_DIR']}/includes/tables.php", TRUE, $tables); foreach ($tables as $name => $create) { $DB->Update("CREATE TABLE IF NOT EXISTS {$name} ( {$create} ) TYPE=MyISAM"); } $password = RandomPassword(); $domain = preg_replace('~^www\\.~', '', $_SERVER['HTTP_HOST']); $t->assign('password', $password); // Setup default user defined partner account fields $columns = $DB->GetColumns('tx_partner_fields'); if (in_array('sample_url_1', $columns) && $DB->Count('SELECT COUNT(*) FROM `tx_partner_field_defs` WHERE `name`=?', array('sample_url_1')) < 1) { $DB->Update("INSERT INTO `tx_partner_field_defs` VALUES (NULL,'sample_url_1','Sample URL 1','Text','size=\"80\"','',2,'','Sample URL 1 is not properly formatted',1,1,1,0,0)"); } if (in_array('sample_url_2', $columns) && $DB->Count('SELECT COUNT(*) FROM `tx_partner_field_defs` WHERE `name`=?', array('sample_url_2')) < 1) { $DB->Update("INSERT INTO `tx_partner_field_defs` VALUES (NULL,'sample_url_2','Sample URL 2','Text','size=\"80\"','',2,'','Sample URL 2 is not properly formatted',1,1,1,0,0)"); } if (in_array('sample_url_3', $columns) && $DB->Count('SELECT COUNT(*) FROM `tx_partner_field_defs` WHERE `name`=?', array('sample_url_3')) < 1) { $DB->Update("INSERT INTO `tx_partner_field_defs` VALUES (NULL,'sample_url_3','Sample URL 3','Text','size=\"80\"','',0,'','Sample URL 3 is not properly formatted',1,1,1,0,0)"); } // Setup default category and initial thumbnail preview dimensions $dimensions = array('180x150', '120x150'); $category = array('per_day' => '-1', 'pics_allowed' => 1, 'pics_extensions' => 'jpg,jpeg,bmp,png', 'pics_minimum' => 10, 'pics_maximum' => 30, 'pics_file_size' => 12288, 'pics_preview_allowed' => 1, 'pics_preview_size' => $dimensions[1], 'movies_allowed' => 1, 'movies_extensions' => 'avi,mpg,mpeg,rm,wmv,mov,asf', 'movies_minimum' => 5, 'movies_maximum' => 30, 'movies_file_size' => 102400, 'movies_preview_allowed' => 1, 'movies_preview_size' => $dimensions[0]); StoreValue('default_category', serialize($category)); Storevalue('preview_sizes', serialize($dimensions)); // Setup administrator account $DB->Update('DELETE FROM `tx_administrators` WHERE `username`=?', array('administrator')); $DB->Update('INSERT INTO `tx_administrators` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', array('administrator', sha1($password), '', 0, 'Administrator', "webmaster@{$domain}", 'administrator', null, null, null, null, 0, 0, 0, 0, 0, null, null)); $DB->Disconnect(); }
// // Unless required by applicable law or agreed to in writing, software // distributed under the License is distributed on an "AS IS" BASIS, // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. // See the License for the specific language governing permissions and // limitations under the License. if (!preg_match('~/admin$~', realpath(dirname(__FILE__)))) { echo "This file must be located in the admin directory of your TubeX installation"; exit; } define('TUBEX_CONTROL_PANEL', true); require_once 'includes/cp-global.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { $DB = GetDB(); $reset = true; $password = RandomPassword(); $cp_url = "http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['REQUEST_URI']) . "/index.php"; $DB->Update('DELETE FROM `tbx_administrator` WHERE `username`=?', array('administrator')); $DB->Update('INSERT INTO `tbx_administrator` VALUES (?,?,?,?,?,?)', array('administrator', sha1($password), 'webmaster@' . preg_replace('~^www\\.~', '', $_SERVER['HTTP_HOST']), 'Administrator', 'Superuser', 0)); } $fp = fopen(__FILE__, 'r'); fseek($fp, __COMPILER_HALT_OFFSET__); eval(stream_get_contents($fp)); fclose($fp); __halt_compiler();?> <html> <head> <title>Reset TubeX Control Panel Access</title> </head> <body>
function txShPasswordResetConfirm() { global $DB, $C, $t, $L, $domain; // Delete old confirmations $DB->Update('DELETE FROM `tx_partner_confirms` WHERE `date_sent` < ?', array(gmdate(DF_DATETIME, TIME_NOW - 86400))); $confirmation = $DB->Row('SELECT * FROM `tx_partner_confirms` WHERE `confirm_id`=?', array($_REQUEST['id'])); if ($confirmation) { $DB->Update('DELETE FROM `tx_partner_confirms` WHERE `confirm_id`=?', array($_REQUEST['id'])); $partner = $DB->Row('SELECT * FROM `tx_partners` WHERE `username`=?', array($confirmation['username'])); if (!$partner) { $t->assign('error', $L['INVALID_CONFIRMATION']); } else { $partner['password'] = RandomPassword(); $DB->Update('UPDATE `tx_partners` SET `password`=?,`session`=?,`session_start`=? WHERE `username`=?', array(sha1($partner['password']), null, 0, $partner['username'])); $t->assign_by_ref('partner', $partner); SendMail($partner['email'], $domain['template_prefix'] . 'email-partner-reset-confirmed.tpl', $t); } } else { $t->assign('error', $L['INVALID_CONFIRMATION']); } $t->display($domain['template_prefix'] . 'partner-reset-confirmed.tpl'); }
function CreateTables() { global $t, $DB; $DB = new DB($_REQUEST['db_hostname'], $_REQUEST['db_username'], $_REQUEST['db_password'], $_REQUEST['db_name']); $DB->Connect(); $tables = array(); IniParse("{$GLOBALS['BASE_DIR']}/includes/tables.php", TRUE, $tables); foreach ($tables as $name => $create) { $DB->Update("CREATE TABLE IF NOT EXISTS {$name} ( {$create} ) TYPE=MyISAM"); } $password = RandomPassword(); $domain = preg_replace('~^www\\.~', '', $_SERVER['HTTP_HOST']); $t->assign('password', $password); // Setup administrator account $DB->Update('DELETE FROM `tlx_administrators` WHERE `username`=?', array('administrator')); $DB->Update('INSERT INTO `tlx_administrators` VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)', array('administrator', sha1($password), '', 0, 'Administrator', "webmaster@{$domain}", 'administrator', null, null, null, null, 0, 0)); if (($last_updates = GetValue('last_updates')) === null) { $last_updates = array(); $last_updates['daily'] = date('Y-m-d'); $last_updates['hourly'] = null; StoreValue('last_updates', serialize($last_updates)); } $DB->Update('INSERT INTO `tlx_skim_ratio` VALUES (0,0)'); $DB->Update('DELETE FROM `tlx_ip2country`'); $DB->Update('DELETE FROM `tlx_countries`'); $DB->Update('DELETE FROM `tlx_country_stats`'); $countries = file('../includes/countries.php'); foreach ($countries as $line) { $DB->Update($line); } //$DB->Disconnect(); }
$mail->FromName = "MMM solutions"; //$add = array("*****@*****.**"); $usernames = array("coe11b001", "coe11b012", "coe11b014", "coe11b027"); $con_error = "cannot be connected"; $mysql_host = "localhost"; $mysql_user = "******"; $mysql_pass = ""; $mysql_db = "users"; $i = 0; if (!mysql_connect($mysql_host, $mysql_user, $mysql_pass) || !mysql_select_db($mysql_db)) { die($con_error); } else { for ($i = 1; $i <= count($usernames); $i = $i + 1) { $user = $usernames[$i]; //echo $user; $rand = RandomPassword(); //echo $rand; $query = "Insert into userinfo(`id`,`username`,`password`,`view`) values('{$i}+1','{$user}','{$rand}','0')"; $query_run = mysql_query($query); if ($query_run) { echo "query Succeeded"; } else { echo "Query Failed"; } } } $query2 = "select username,password from userinfo "; $query_run2 = mysql_query($query2); if ($query_run2) { $j = 0; while ($row = mysql_fetch_assoc($query_run2)) {