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) {
