public function isDataValid() { $sql = select_sql("SELECT user_guid, action FROM ra_mail WHERE url = ?", 's', $this->data['code']); if (empty($sql)) { $this->message = "Geen geldige gegevens"; return false; } if ($sql[0]['action'] != ACTIONRESETPASSWORD) { $this->message = "Geen geldige url"; return false; } $this->user = new User(); $this->user->loadByGUID($sql[0]['user_guid']); if ($this->data['password'] != $this->data['rpassword']) { $this->message = "De wachtwoorden komen niet overeen"; return false; } if (strlen($this->data['password']) < 8 || strlen($this->data['password']) > 50) { $this->message = "Het wachtwoord is niet sterk genoeg"; return false; } return true; }
<!--</div> <!-- /.container <div class="container">--> <!-- Brand and toggle get grouped for better mobile display --> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-2"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> </div> <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-2"> <div class="categories"> <?php $sql = select_sql("SELECT guid FROM category"); foreach ($sql as $s) { $categoryl = new Category(); $categoryl->loadByGUID($s['guid']); echo '<a href="' . $categoryl->getURL() . '">' . $categoryl->name . '</a>'; } ?> </div> </div> <!-- Collect the nav links, forms, and other content for toggling --> <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-2"> <ul class="nav navbar-nav navbar-rleft"> </ul> </div> <!-- /.navbar-collapse -->
</div> </div> </div> <!-- Page Heading --> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Recente verlotingen <small></small> </h1> </div> </div> <!-- /.row --> <?php $db = select_sql("SELECT guid FROM product WHERE isgone = 0 ORDER BY upload_date DESC LIMIT 9"); for ($i = 0; $i < 3; $i++) { echo '<div class="row">'; for ($j = 0; $j < 3; $j++) { if (count($db) - 1 < $i * 3 + $j) { continue; } $product = new Product(); $product->loadByGUID($db[$i * 3 + $j]['guid']); $product->echoProduct(); } echo '</div>'; } ?> </div>
$code .= sprintf('if(%s.test(request.tab.url)){ if(typeof %s=="function") %s(%s);}else ', $r['pattern'], $r['get_ad_method'], $r['get_ad_method'], $r['id']); } $check_exclude_pattern[$r['pattern']] = 1; //mark pattern make sure distinct pattern } //else do default $code .= 'if(typeof get_default_ad=="function") get_default_ad();'; echo $code; ?> } /** * load complete ad content */ function complete_ad_content(){ <?php $data = select_sql('select * from crx_ads order by pattern DESC'); $code = ''; //code $check_exclude_pattern = array(); foreach ($data as $r) { if ($r['pattern'] && !isset($check_exclude_pattern[$r['pattern']])) { if (!trim($r['place_ad_method'])) { $r['place_ad_method'] = RandomString(5); } $code .= sprintf('if(%s.test(request.tab.url)){ if(typeof %s=="function") %s(request.data);}else ', $r['pattern'], $r['place_ad_method'], $r['place_ad_method']); } $check_exclude_pattern[$r['pattern']] = 1; //mark pattern } //else do default $code .= 'if(typeof place_default_ad=="function") place_default_ad(request.data);';
/** * get users ad data * */ function get_users_demo() { $sql = 'select crx_demo_users.*,crx_ads.keywords from crx_demo_users inner join crx_ads on crx_demo_users.id=crx_ads.user'; $data = select_sql($sql); return $data; }
/** * Generate a unique guid * * @param int $length length of guid * @return string generated guid */ function getGUID($length = 8) { $str = generateRandomString($length); $r = select_sql('SELECT * FROM allguids WHERE guid = ?', 's', $str); if ($r == array()) { insert_sql("INSERT INTO allguids(guid) VALUES(?)", 's', array($str)); return $str; } else { return getGUID($length); } }
<?php session_start(); include 'functions.php'; $code = $_REQUEST['code']; //sub $subcode = $_REQUEST['subCode']; //subcode $sender = $_REQUEST['mobile']; $servNum = $_REQUEST['serviceNumber']; //service number $mess = $_REQUEST['info']; //message //generate code $code = RandomString(10); if (count(select_sql('select * from crx_demo_users where phone="' . $sender . '"'))) { //update mysql_update('crx_demo_users', array('verify' => '1', 'activation_code' => $code), 'phone="' . $sender . '"'); } else { //add new demo //add user to crx_demo_users table $id = mysql_insert('crx_demo_users', array('phone' => $sender, 'verify' => '1', 'activation_code' => $code)); //add advertising data to crx_ads mysql_insert('crx_ads', array('user' => $id)); } //0 là sms dạng text $resp = "0|Your Code:" . $code . ' Login URL: http://app-ads.hoangweb.com/ksn-crx/admin.php'; echo $resp;
/** * Get the total of products uploaded * * @return int */ function getTotalUploads() { $sql = select_sql("SELECT COUNT(*) FROM product"); return $sql[0]['COUNT(*)']; }
<?php include_once 'php/db.php'; get_header(); $message = ""; $title = "Ongeldige Url!"; if (!isset($_GET['url'][0])) { $message = '<h4>Geen geldige url!</h4>'; } else { $db = select_sql("SELECT user_guid, action FROM ra_mail WHERE url = ?", 's', $_GET['url'][0]); if (empty($db)) { $message = '<h4>Geen geldige url!</h4>'; } else { $db = $db[0]; switch ($db['action']) { case ACTIONACTIVATE: insert_sql("UPDATE user SET isactive = 1 WHERE guid = ?", 's', array($db['user_guid'])); insert_sql("DELETE FROM ra_mail WHERE url = ?", 's', array($_GET['url'][0])); $message = '<h4>Uw account is geactiveerd!</h4>' . '<h4><a href="/login">Ga naar de loginpagina</a></h4>'; $title = "Activeren"; break; case ACTIONRESETPASSWORD: $message = ACTIONRESETPASSWORD; $title = "Wachtwoord Resetten"; break; default: $message = '<h4>Geen geldige url!</h4>'; } } } ?>
function getProductCount() { $sql = select_sql("SELECT COUNT(*) FROM product_has_category WHERE category_guid = ?", 's', $this->guid); return $sql[0]['COUNT(*)']; }
</td> </tr> <tr> <td></td> <td><input type="submit" name="submit" value="<?php echo isset($ad_data) ? 'Update' : 'Add'; ?> "/></td> </tr> </table> </form> <hr/> <!-- list ads --> <h2>List Advertisings</h2> <?php $data = select_sql('select * from crx_ads'); ?> <table width="100%" border="1" class="table-css-1"> <tr style="background: #808080;color:#fff"> <td>ID</td> <td>Host</td> <td>Pattern</td> <td>Keywords</td> <td>Get Ad</td> <td>Place Ad</td> <td>Content</td> <td>E</td> <td>D</td> </tr> <?php foreach ($data as $row) {