function submit_tao_du_an_buoc_3() { try { if (isset($_POST['duan_id']) == false) { die('ERROR_SYSTEM'); } $duan_id = $_POST['duan_id']; $this->duan->id = $duan_id; $this->duan->where(' and active=-1'); $data = $this->duan->search('id,tenduan,alias'); if (empty($data)) { die('ERROR_SYSTEM'); } $tenduan = $data['duan']['tenduan']; $alias = $data['duan']['alias']; $email = $_POST['duan_email']; $sodienthoai = $_POST['duan_sodienthoai']; $thongtinchitiet = $_POST['duan_thongtinchitiet']; $file_id = $_POST['duan_filedinhkem']; $validate = new Validate(); if ($validate->check_submit(1, array('duan_email', 'duan_sodienthoai')) == false) { die('ERROR_SYSTEM'); } if ($validate->check_null(array($email, $sodienthoai)) == false) { die('ERROR_SYSTEM'); } if (!$validate->check_email($email)) { die('ERROR_SYSTEM'); } $account_id = null; $flagSendmail = 1; global $cache; include ROOT . DS . 'library' . DS . 'sendmail.php'; $priSenders = $cache->get('priSenders'); $sender = $priSenders[mt_rand(0, count($priSenders) - 1)]; if (isset($_SESSION['account'])) { $account_id = $_SESSION['account']['id']; if ($email != $_SESSION['account']['username']) { //Post du an dum nguoi khac $flagSendmail = 2; } } else { $this->setModel('account'); $strWhere = "AND username='******'"; $this->account->where($strWhere); $data2 = $this->account->search('id'); if (!empty($data2)) { die('ERROR_EXIST'); } $this->account->id = null; $this->account->username = $email; $this->account->timeonline = 0; $this->account->role = 2; $this->account->active = 0; $account_id = $this->account->insert(true); $this->account->id = $account_id; $data2 = $this->account->search(); $_SESSION['account'] = $data2['account']; $active_code = genString(); $this->setModel('activecode'); $this->activecode->id = null; $this->activecode->account_id = $account_id; $this->activecode->active_code = $active_code; $this->activecode->insert(); //Send active code $linkactive = BASE_PATH . "/webmaster/doActive/true&account_id={$account_id}&active_code={$active_code}"; $linkactive = "<a href='{$linkactive}'>{$linkactive}</a>"; $content = $cache->get('mail_verify'); $search = array('#LINKACTIVE#', '#ACTIVECODE#', '#USERNAME#'); $replace = array($linkactive, $active_code, $email); $content = str_replace($search, $replace, $content); $mail = new sendmail(); $mail->send($email, 'JobBid.vn - Mail Xác Nhận Đăng Ký Tài Khoản!', $content, $sender); } $this->setModel('data'); $sIndex = "{$tenduan} " . strip_tags($thongtinchitiet); $sIndex = strtolower(remove_accents($sIndex)); $this->data->id = null; $this->data->data = $sIndex; $data_id = $this->data->insert(true); $this->setModel('duan'); $this->duan->id = $duan_id; $this->duan->duan_email = $email; $this->duan->duan_sodienthoai = $sodienthoai; $this->duan->thongtinchitiet = $thongtinchitiet; if ($file_id != 0) { $this->duan->file_id = $file_id; } $this->duan->account_id = $account_id; $this->duan->prior = '0'; $currentDate = GetDateSQL(); $this->duan->timeupdate = $currentDate; $this->duan->views = '0'; $this->duan->bidcount = '0'; $this->duan->averagecost = '0'; $this->duan->isnew = 1; $this->duan->data_id = $data_id; $this->duan->approve = '0'; $editcode = genString(20); $this->duan->editcode = $editcode; if (isset($_SESSION['account']) && $_SESSION['account']['active'] == 1) { if ($flagSendmail == 1) { $this->duan->active = 1; } else { $this->duan->active = '0'; } } $this->duan->update(); if ($flagSendmail == 2) { //Send approve email to employer $linkview = BASE_PATH . "/duan/view/{$duan_id}/{$alias}&editcode={$editcode}"; $linkview = "<a href='{$linkview}'>{$tenduan}</a>"; $linkdongy = BASE_PATH . "/duan/permission/{$duan_id}/{$editcode}/1"; $linkdongy = "<a href='{$linkdongy}'><font color='green'>ĐỒNG Ý</font></a>"; $linkodongy = BASE_PATH . "/duan/permission/{$duan_id}/{$editcode}/0"; $linkodongy = "<a href='{$linkodongy}'><font color='red'>KHÔNG ĐỒNG Ý</font></a>"; $content = $cache->get('mail_permission'); $search = array('#LINKDUAN#', '#DONGY#', '#KHONGDONGY#'); $replace = array($linkview, $linkdongy, $linkodongy); $content = str_replace($search, $replace, $content); $subject = "[EMAIL XIN PHÉP] Đăng công việc [{$tenduan}] lên JobBid.vn!!!"; $mail = new sendmail(); $mail->send($email, $subject, $content, $sender); } else { //Send approve email to admin $linkview = BASE_PATH . "/duan/view/{$duan_id}/{$alias}"; $linkview = "<a href='{$linkview}'>{$linkview}</a>"; $linkdongy = BASE_PATH . "/duan/approve/{$duan_id}/{$editcode}/1"; $linkdongy = "<a href='{$linkdongy}'><font color='green'>ĐỒNG Ý</font></a>"; $linkodongy = BASE_PATH . "/duan/approve/{$duan_id}/{$editcode}/0"; $linkodongy = "<a href='{$linkodongy}'><font color='red'>KHÔNG ĐỒNG Ý</font></a>"; $content = $cache->get('mail_approve'); $search = array('#TENDUAN#', '#EMAIL1#', '#EMAIL#', '#SDT#', '#THONGTINCHITIET#', '#LINK#', '#DONGY#', '#KHONGDONGY#'); $replace = array($tenduan, $email, $email, $sodienthoai, $thongtinchitiet, $linkview, $linkdongy, $linkodongy); $content = str_replace($search, $replace, $content); $mail = new sendmail(); $mail->send(GLOBAL_EMAIL, 'Hệ Thống - Email Approve Dự Án Mới!', $content, $sender); } $myprojects = array(); if (isset($_SESSION['myprojects'])) { $myprojects = $_SESSION['myprojects']; } array_push($myprojects, $duan_id); $_SESSION['myprojects'] = $myprojects; if (isset($_SESSION['account'])) { if ($_SESSION['account']['active'] == 1) { echo 'OK'; } else { echo 'NOT_ACTIVE'; } } else { echo 'NOT_ACTIVE'; } } catch (Exception $e) { echo 'ERROR_SYSTEM'; } }
<td><select name="dbName" onchange=submit();>'; foreach ($dbList as $dbName) { if ($_POST[dbName] == $dbName) { $pick = 'selected'; } else { $pick = ''; } $qContent .= '<option value="' . $dbName . '" ' . $db_sel[$dbName] . ' ' . $pick . '>' . $dbName . '</option>'; } $qContent .= '</select> Table ' . $tableList . ' </td> </tr><tr> <td>Query </td><td><textarea name="sql" rows=' . $rows . ' cols=' . $cols . '>' . stripslashes($_POST['sql']) . '</textarea></td> </tr><tr> <td></td><td><input type="submit" name="subQuery" value="Submit Query"> <a href="./query.php?h=' . genString(8) . '" target=_blank><input type=button value="Open New Session"></a> <a href="./query.php?h=' . $_GET['h'] . '&reset=1"><input type=button value="Reset Query History"></a> </td> </tr><tr> <td>Query History</td> <td><select name="previous_queries" onChange="copyQuery(this.value)"> <option value="">---Query History----</option>' . $history_opt . '</select> </td> </tr> </table> </td><td> <table border=0 height=100%> <tr valign=top> <td> <input type="radio" name="ck_csv" value="" checked> Not Delimited<br> <input type="radio" name="ck_csv" value="," ' . $ck_csv[','] . '> Comma Delimited<br>
function query_builder() { $this->load->helper('query_builder'); $campaign = $this->mdl_campaign->query_builder(); $id_type = $this->mdl_individual->query_builder('id_type'); $city = $this->mdl_individual->query_builder('city'); $curr_brand = $this->mdl_individual->query_builder('brand'); $sec_brand = $this->mdl_individual->query_builder('brand_'); $source_type = $this->mdl_individual->query_builder('source_type'); $status_verifikasi = $this->mdl_individual->query_builder('status_verifikasi'); $data[] = genSelect('campaign_id', 'Campaign', $campaign); $data[] = genString('id', 'Individual ID'); $data[] = genString('mop_id', 'MOP ID'); $data[] = genString('firstname', 'Firstname'); $data[] = genString('lastname', 'Lastname'); $data[] = genString('nickname', 'Nickname'); $data[] = genSelect('sex', 'Sex', array("M" => "MALE", "F" => "FEMALE")); $data[] = genDate('dob', 'Day of Birth'); $data[] = genInteger("DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(dob)), '%Y')", 'Age'); $data[] = genSelect('id_type', 'ID Type', $id_type); $data[] = genString('id_number', 'ID Number'); $data[] = genString('tlp', 'Telephone'); $data[] = genString('email', 'Email'); $data[] = genString('fb', 'Facebook'); $data[] = genString('tw', 'Twitter'); $data[] = genString('address', 'Address'); $data[] = genSelect('city', 'City', $city); $data[] = genString('pos_code', 'Pos Code'); $data[] = genSelect('brand', 'Current Brand', $curr_brand); $data[] = genSelect('brand_', 'Second Brand', $sec_brand); $data[] = genSelect('source_type', 'Source Type', $source_type); $data[] = genString('source_user', 'Source User'); $data[] = genDate('survey_date', 'Survey Date'); $data[] = genDate('upload_date', 'Upload Date'); $data[] = genDate('entry_date', 'Entry Date'); $data[] = genDate('verifikasi_date', 'Verification Date'); $data[] = genString('referred', 'Referred by'); $data[] = genSelect('status_verifikasi', 'Status Verification', $status_verifikasi); echo json_encode($data); }
$type = 1; } if (isset($_POST['runas'])) { $runas = 1; } else { $runas = 0; } foreach ($targets as $target) { if ($error != 1) { //Maintenace VS Scheduling - For notification messages consistency $category = 'maintenance'; $target = trim($target); $command = trim($command); $arguments = trim($arguments); //GENERATE RANDOM KEY - USED AS PRIMARY KEY TO ASSOCIATE THIS SPECIFIC TASK WITH SPECIFIC TARGET $key = base64_encode(genString(10)); $opentime = time(); //UPDATE CB PERIOD if ($type == 5) { //ADD TASK TO QUEUE $opentime = time(); DB::insert('tasks', array('type' => '5', 'id' => $target, 'command' => $command, 'arguments' => '', 'key' => $key, 'status' => '0', 'results' => '', 'opentime' => $opentime, 'closetime' => '')); } else { if ($type == 20) { DB::update('parameters', array('name' => $command), '`id`=%s', $target); } else { if ($type == 6) { //ADD TASK TO QUEUE $opentime = time(); DB::insert('tasks', array('type' => '6', 'id' => $target, 'command' => $command, 'arguments' => $arguments, 'key' => $key, 'status' => '0', 'results' => '', 'opentime' => $opentime, 'closetime' => '')); } else {
$expireSeconds = $p['expires'] * 60 * 60; if ($today <= $expiresDate + $expireSeconds) { $downloadLinkStatus = 'Active'; $disExtend = 'disabled'; } else { $downloadLinkStatus = 'Expired'; } //get the download link $folder = $p['folder']; if ($folder == '') { $downloadLink = '../?action=download&id=' . $s[transID]; } else { $downloadLink = '../' . $folder . '/?action=download&id=' . $s[transID]; } if ($_POST[makeAccount]) { $dbOptions = array('tableName' => 'users', 'dbFields' => array('paypal' => $s[payerEmail], 'email' => $s[contactEmail], 'fname' => $s[firstName], 'lname' => $s[lastName], 'joinDate' => $s[purchased], 'username' => genString(8), 'password' => genString(8))); if (dbInsert($dbOptions)) { $newID = mysql_insert_id(); $msg = 'Added affiliate account: <a href="updateProfile.php?id=' . $newID . '">click here to view account</a>'; } } if ($_POST[updateNotes]) { $dbOptions = array('tableName' => 'sales', 'dbFields' => array('notes' => $_POST[notes]), 'cond' => 'where id="' . $_GET[id] . '"'); if (dbUpdate($dbOptions)) { $msg = 'Updated notes for this sale'; } else { $msg = 'Failed to update this sale'; } } //members account $selU = 'select * from users where paypal="' . $s[payerEmail] . '" || email="' . $s[payerEmail] . '"';
function submit_dang_tin_rao_vat() { try { $max_raovat = isset($_SESSION['MAX_RAOVAT']) ? $_SESSION['MAX_RAOVAT'] : 0; if ($max_raovat >= MAX_RAOVAT) { die('MAX_RAOVAT'); } $tieude = $_POST['raovat_tieude']; $alias = $_POST['raovat_alias']; $email = $_POST['raovat_email']; $sodienthoai = $_POST['raovat_sodienthoai']; $noidung = $_POST['raovat_noidung']; $validate = new Validate(); if ($validate->check_submit(1, array('raovat_email', 'raovat_sodienthoai', 'raovat_tieude', 'raovat_alias', 'raovat_noidung')) == false) { die('ERROR_SYSTEM'); } if ($validate->check_null(array($email, $sodienthoai, $tieude, $noidung)) == false) { die('ERROR_SYSTEM'); } if ($validate->check_length($tieude, 101)) { die('ERROR_SYSTEM'); } if (!$validate->check_email($email)) { die('ERROR_SYSTEM'); } $account_id = null; global $cache; $status = 0; if (isset($_SESSION['account'])) { $account_id = $_SESSION['account']['id']; $status = 1; } else { $this->setModel('account'); $strWhere = "AND username='******'"; $this->account->where($strWhere); $data2 = $this->account->search('id'); if (!empty($data2)) { die('ERROR_EXIST'); } $this->account->id = null; $this->account->username = $email; $this->account->timeonline = 0; $this->account->role = 2; $this->account->active = 0; $account_id = $this->account->insert(true); $this->account->id = $account_id; $data2 = $this->account->search(); $_SESSION['account'] = $data2['account']; $active_code = genString(); $this->setModel('activecode'); $this->activecode->id = null; $this->activecode->account_id = $account_id; $this->activecode->active_code = $active_code; $this->activecode->insert(); //Send active code $linkactive = BASE_PATH . "/webmaster/doActive/true&account_id={$account_id}&active_code={$active_code}"; $linkactive = "<a href='{$linkactive}'>{$linkactive}</a>"; $content = $cache->get('mail_verify'); $search = array('#LINKACTIVE#', '#ACTIVECODE#', '#USERNAME#'); $replace = array($linkactive, $active_code, $email); $content = str_replace($search, $replace, $content); $priSenders = $cache->get('priSenders'); $sender = $priSenders[mt_rand(0, count($priSenders) - 1)]; include ROOT . DS . 'library' . DS . 'sendmail.php'; $mail = new sendmail(); $mail->send($email, 'JobBid.vn - Mail Xác Nhận Đăng Ký Tài Khoản!', $content, $sender); } $this->setModel('raovat'); $this->raovat->id = null; $this->raovat->raovat_email = $email; $this->raovat->raovat_sodienthoai = $sodienthoai; $this->raovat->noidung = $noidung; $this->raovat->tieude = $tieude; $this->raovat->alias = $alias; $currentDate = GetDateSQL(); $this->raovat->ngaypost = $currentDate; $this->raovat->ngayupdate = $currentDate; $this->raovat->views = 0; $this->raovat->account_id = $account_id; $this->raovat->status = $status; $this->raovat->insert(); $this->updatecache(); $max_raovat++; $_SESSION['MAX_RAOVAT'] = $max_raovat; if (isset($_SESSION['account'])) { if ($_SESSION['account']['active'] == 1) { echo 'OK'; } else { echo 'NOT_ACTIVE'; } } else { echo 'NOT_ACTIVE'; } } catch (Exception $e) { echo 'ERROR_SYSTEM'; } }
function resetpassword() { try { if (!isset($_GET['username'])) { die('ERROR_SYSTEM'); } if (!isset($_SESSION['sendresetpass'])) { $_SESSION['sendresetpass'] = 0; } if ($_SESSION['sendresetpass'] >= MAX_SENDRESETPASS) { die('ERROR_MANYTIMES'); } $username = $_GET['username']; if ($username == null) { die('ERROR_SYSTEM'); } $username = mysql_real_escape_string($username); $this->account->where(" and active>=0 and username='******'"); $data = $this->account->search('id'); if (empty($data)) { die('ERROR_NOTEXIST'); } $account_id = $data[0]['account']['id']; $this->setModel('resetpassword'); $this->resetpassword->where(" and account_id={$account_id}"); $data = $this->resetpassword->search('id,times'); $verify = genString(); if (!empty($data)) { //da gui reset password truoc day $times = $data[0]['resetpassword']['times'] + 1; if ($times > MAX_TIMESRESETPASS) { die('ERROR_LOCKED'); } $this->resetpassword->id = $data[0]['resetpassword']['id']; $this->resetpassword->times = $times; $this->resetpassword->verify = $verify; $this->resetpassword->update(); } else { //gui reset password lan dau tien $this->resetpassword->id = null; $this->resetpassword->account_id = $account_id; $this->resetpassword->times = 1; $this->resetpassword->verify = $verify; $this->resetpassword->insert(); } //Send mail url : /webmaster/changepass/resetpassword_id/resetpassword_verify $linkresetpass = BASE_PATH . "/webmaster/changepass/{$account_id}/{$verify}"; $linkresetpass = "******"; global $cache; $content = $cache->get('mail_resetpass'); $search = array('#RESETPASSLINK#'); $replace = array($linkresetpass); $content = str_replace($search, $replace, $content); $priSenders = $cache->get('priSenders'); $sender = $priSenders[mt_rand(0, count($priSenders) - 1)]; include ROOT . DS . 'library' . DS . 'sendmail.php'; $mail = new sendmail(); $mail->send($username, 'JobBid.vn - Mail Xác Nhận Khôi Phục Mật Khẩu Đăng Nhập!', $content, $sender); $_SESSION['sendresetpass'] = $_SESSION['sendresetpass'] + 1; echo 'DONE'; } catch (Exception $e) { echo 'ERROR_SYSTEM'; } }
if ($sales > 0) { //check for expiration date $today = time(); $expiresDate = strtotime($expiresDate); $expireSeconds = $expires * 60 * 60; if ($transID == 'vipuser') { $today = 0; $expiresDate = 0; } if ($today <= $expiresDate + $expireSeconds) { //check for existing account $selU = 'select * from users where email="' . $payerEmail . '" or paypal="' . $payerEmail . '"'; $resU = mysql_query($selU, $conn) or die(mysql_error()); if (mysql_num_rows($resU) == 0) { //generate random password $password = genString(8); //insert email & password into db $ins = 'insert into users ( paypal, email, password, joinDate ) values ( "' . $payerEmail . '", "' . $payerEmail . '", "' . $password . '", now() )'; mysql_query($ins, $conn) or die(mysql_error()); } else { $u = mysql_fetch_assoc($resU); $password = $u[password];