function name()
 {
     set_include_path(get_include_path() . PATH_SEPARATOR . BASEPATH . 'libraries/inc');
     $aql = new aql();
     $aql->set('basedir', '/etc/asterisk/');
     $db = $aql->query("insert into t9.conf set callerid=\"'99' <99>\",section='555'");
     echo $aql->errstr;
     print_r($db);
     return 'name';
 }

 function select($aql = null, $clause = null)
 {
     if ($aql) {
         $this->aql = $aql;
     }
     if ($clause) {
         $this->clause = $clause;
     }
     //pagination settings
     $default_limit = if_not($this->clause['default_limit'], 25);
     if (!$_GET['limit' . $this->i]) {
         $_GET['limit' . $this->i] = $default_limit;
     }
     $this->offset = $_GET['page' . $this->i] * $_GET['limit' . $this->i] - $_GET['limit' . $this->i];
     $this->clause['limit'] = $_GET['limit' . $this->i];
     $this->clause['offset'] = $this->offset;
     $this->rs = aql::select($this->aql, $this->clause);
     $this->first_row = $this->offset + 1;
     $this->last_row = count($this->rs) + $this->first_row - 1;
     $c = aql::sql($this->aql, $this->clause);
     $c = sql($c['sql_count']);
     $this->total_rows = $c->Fields('count');
     $this->num_pages = ceil($this->total_rows / $_GET['limit' . $this->i]);
     return $this->rs;
 }

 public function construct()
 {
     // get the fname and lname of the mod__person_id
     $r = aql::value("person{fname,lname}", $this->mod__person_id);
     $this->addProperty('modified_by');
     $this->modified_by = $r['fname'] . ' ' . $r['lname'];
     $this->addProperty('message');
     $this->message = $this->getMessage();
 }

 /**
  * Makes sure this account only has one app by this name
  * @param   string  $val
  */
 public function validate_name($val)
 {
     $t = $this->getPrimaryTable();
     $n = static::getAccountFieldName();
     $acct_id = $this->{$n} ?: ($this->isInsert() ? null : aql::value("{$t}.{$n}", $this->getID()));
     $clause = array('name' => $val);
     if ($acct_id) {
         $clause[$n] = $acct_id;
     }
     if (static::count($clause)) {
         $this->addError('duplicate_app_name');
     }
 }

 public function getList($a = array())
 {
     //. category
     //. seo_field
     //. website_id
     //. total_volume
     //. page
     //. name
     //. order_by
     $where = array();
     if (is_array($a['where'])) {
         foreach ($a['where'] as $w) {
             $where[] = $w;
         }
     }
     if ($a['category']) {
         $where[] = "category = '" . addslashes($a['category']) . "'";
     }
     if ($a['seo_field']) {
         $where[] = "seo_field = '" . addslashes($a['seo_field']) . "'";
     }
     if ($a['website_id']) {
         $where[] = "website_id = " . $a['website_id'];
     }
     if ($a['total_volume']) {
         $where[] = "total_volume >= " . $a['total_volume'];
     }
     if ($a['page']) {
         $where[] = "page = '" . addslashes($a['page']) . "'";
     }
     if ($a['name']) {
         $where[] = "name = '" . addslashes($a['name']) . "'";
     }
     if ($a['order_by']) {
         $order_by = $a['order_by'];
     }
     $aql = "dup_phrase_group { }";
     $clause = array("dup_phrase_group" => array("where" => $where, "order by" => $order_by));
     $rs = aql::select($aql, $clause);
     $ids = array();
     foreach ($rs as $r) {
         $ids[] = $r['dup_phrase_group_id'];
     }
     return $ids;
 }

 public function getList($a = array())
 {
     //. category
     //. sub_category
     //. base
     //. volume
     //. holiday
     //. keyword
     $where = array();
     if (is_array($a['where'])) {
         foreach ($a['where'] as $w) {
             $where[] = $w;
         }
     }
     if ($a['category']) {
         $where[] = "category = '" . addslashes($a['category']) . "'";
     }
     if ($a['sub_category']) {
         $where[] = "sub_category = '" . addslashes($a['sub_category']) . "'";
     }
     if ($a['base']) {
         $where[] = "base = '" . addslashes($a['base']) . "'";
     }
     if ($a['volume']) {
         $where[] = "volume = " . $a['volume'];
     }
     if ($a['keyword']) {
         $where[] = "keyword = '" . addslashes($a['keyword']) . "'";
     }
     if ($a['holiday']) {
         $where[] = "holiday = '" . addslashes($a['holiday']) . "'";
     }
     if ($a['order_by']) {
         $order_by = $a['order_by'];
     }
     $aql = "dup_phrase_data { }";
     $clause = array("dup_phrase_data" => array("where" => $where, "order by" => $order_by));
     $rs = aql::select($aql, $clause);
     $ids = array();
     foreach ($rs as $r) {
         $ids[] = $r['dup_phrase_data_id'];
     }
     return $ids;
 }

function configure_perm($sentences = array())
{
    echo '<div class="has-floats" style="margin-bottom:15px;">';
    echo '<div style="float:left; margin-right:10px;"><input type="checkbox" class="perm-box" s_order="';
    $x = 0;
    foreach ($sentences as $sentence_id) {
        $x++;
        echo $sentence_id;
        if ($x != count($sentences)) {
            echo ",";
        }
    }
    echo '"/></div>';
    echo '<div style="float:left;">';
    foreach ($sentences as $sentence_id) {
        $rs = aql::select("dup_sentence_data { sentence where id = " . $sentence_id . " } ");
        echo $rs[0]['sentence'] . '<br>';
    }
    echo "</div></div>";
}

        $title .= '- Title';
        $type = "phrase";
        break;
    case 'h1':
        $type = "phrase";
        $title .= '- H1';
        break;
    case 'meta-title':
        $type = "phrase";
        $title .= '- Meta Title';
        break;
}
$p->template('seo', 'top');
$filters = array('category' => 'both', 'market_name' => 'both', 'market' => 'phrase', 'base' => 'phrase', 'volume' => 'phrase', 'page' => 'modifier', 'sub_category' => 'modifier');
$width = 310;
$listing = aql::select("dup_phrase_data { id as phrase_id, lower(phrase) as lower_phrase, phrase, volume order by volume DESC, phrase asc }");
$count = count($listing);
foreach ($seo_field_array as $header => $arr) {
    foreach ($arr as $field => $limit) {
        if ($field == str_replace('-', '_', $_GET['type'])) {
            $char_count_limit = $limit;
        }
    }
}
$field_array = array('Title', 'H1', 'Meta Title', 'Keywords');
?>
	
	<div style="margin: 15px;"><a href="/admin/seo/duplicate-data/split-paragraph" >Paragraph Splitter</a> | <a href="/admin/seo/duplicate-data/phrases">Phrase Listing</a></div>
	<h1><?php 
echo $p->title;
?>

	</div>
</fieldset>
<?php 
if ($media_item) {
    $aql = "blog_article{\n\t\t\t\ttitle,\n\t\t\t\tintroduction,\n\t\t\t\tmedia_item_id as article__media_item_id\n\t\t\t}\n\t\t\tblog_media\t{\n\t\t\t\t\t\t\tmedia_item_id as blog_media__media_item_id\n\t\t\t\t\t\t}\n\t\t\tblog_article_tag{\n\t\t\t\tname\n\t\t\t\twhere blog_media.blog_article_id = {$blog_article_id}\n\t\t\t\t\tand blog_media.type = 'mebox'\n\t\t\t\torder by iorder asc\n\t\t\t\tlimit 1\n\t\t\t}";
    $rs = aql::select($aql);
}
$settingss = array("transition" => "fade", "duration" => 4000, "height" => 322, "width" => 640, "height_small" => 62, "width_small" => 90);
?>
<fieldset>
	<legend>Mediabox Preview</legend>
<?php 
if ($rs) {
    $rs[0]['media_item_id'] = $rs[0]['blog_media__media_item_id'] ? $rs[0]['blog_media__media_item_id'] : $rs[0]['article__media_item_id'];
    $aql = "blog_media {\n                media_item_id\n                where blog_media.blog_article_id = {$rs[0]['blog_article_id']}\n                and type = 'tnail'\n                limit 1\n            }";
    $thumb = aql::select($aql);
    $rs[0]['thumb__media_item_id'] = $thumb[0]['media_item_id'] ? $thumb[0]['media_item_id'] : $rs[0]['media_item_id'];
    blog::marquee($rs, $settingss);
} else {
    echo "No images have been uploaded yet";
}
?>

</fieldset>
<ul class="contextMenu" id="imageContextMenu">
	<li>
		<a href="#set_article">Add to article</a>
	</li>
	<li>
		<a href="#delete">Delete</a>
	</li>

<?php

$title = 'Codebase Editor';
template::inc('skybox', 'top');
$selected_codebase = $_GET['codebase'];
$table = $_GET['table'];
$codebase_list = get_codebases();
$codebase_arr = array();
$aql = "dev_codebase\t{\n\t\t\t\t\t\t\tname\n\t\t\t\t\t\t}";
$codebase_arr = array();
$rs = aql::select($aql);
foreach ($rs as $r) {
    $codebase_arr[$r['name']] = $r['name'];
}
foreach ($codebase_list as $codebase) {
    $codebase_arr[$codebase['codebase']] = $codebase['codebase'];
}
$param = array('id' => 'codebase_name', 'name' => 'name', 'selected_value' => $selected_codebase);
snippet::dropdown($codebase_arr, $param);
?>
<br><br>
<div>
	<input type="hidden" id = "table_name" value = "<?php 
echo $table;
?>
" />
	<input type="submit" value="Save" onclick = "save_codebase()" />
</div>
<?php 
template::inc('skybox', 'bottom');

<?php

$rs = aql::select("website_page_data { value where website_page_ide = '{$_POST['website_page_ide']}' and field = '{$_POST['field']}' }");
$data = array('value' => $_POST['value'], 'mod__person_id' => PERSON_ID, 'update_time' => 'now()');
if (is_numeric($rs[0]['website_page_data_id'])) {
    $update = aql::update('website_page_data', $data, $rs[0]['website_page_data_ide']);
    if ($update == true) {
        echo 'saved';
    } else {
        echo 'error';
    }
} else {
    $data['website_page_id'] = decrypt($_POST['website_page_ide'], 'website_page');
    $data['field'] = $_POST['field'];
    $insert = aql::insert('website_page_data', $data);
    if (is_numeric($insert['website_page_data_id'])) {
        echo 'saved';
    } else {
        echo 'error';
    }
}

    ?>
            </select>
        </div>
<?php 
}
if (is_array($markets)) {
    ?>
		<div class="col">
<?php 
    $aql = "market {\n\t\t\t\t\t\tname\n\t\t\t\t\t\twhere market.name is not null and market.name <>''\n\t\t\t\t\t\tand market.primary = 1  \n\t\t\t\t\t\torder by name asc\n\t\t\t\t\t}";
    $dropdown = array('select_name' => 'market_ide', 'value_field' => 'market_ide', 'option_field' => 'name', 'selected_value' => $_GET['market_ide'], 'null_option' => 'All Markets', 'onchange' => 'this.form.submit();');
    aql::dd($aql, $dropdown);
    ?>
        </div>
<?php 
}
//if
?>
	</div>
	<br/>
	<div class="has-floats">
		<div class="col">
<?php 
$aql = "blog_category{\n\t\t\t\t\t\t\t\tname\n\t\t\t\t\t\t\t\torder by iorder\n\t\t\t\t\t\t\t}";
$dropdown = array('select_name' => 'blog_category_ide', 'value_field' => 'blog_category_ide', 'option_field' => 'name', 'selected_value' => $_GET['blog_category_ide'], 'null_option' => 'All Categories', 'onchange' => 'this.form.submit();');
aql::dd($aql, $dropdown);
?>
		</div>
		</div>
	</div>
</form>

<?php

/*
 * This is Test demo script for AQL
*/
error_reporting(E_ALL);
require "../inc/aql.php";
$a = new aql();
$setok = $a->set('basedir', './');
if (!$setok) {
    echo __LINE__ . ' ' . $a->get_error();
}
$result = $a->query("insert into t10.conf set type='friend',section='8001',call-limit=1");
$result = $a->query("delete from t10.conf where section = '8001'");
if ($result == false) {
    echo $a->get_error();
} else {
    echo 'affected_rows :' . $a->get_affected_rows() . "\n";
}

 /**
  * Gets aql::$errors and adds them to the stack
  */
 protected function addAQLErrors()
 {
     foreach (aql::$errors as $e) {
         $this->addInternalError('aql_class_error', array('message' => $e->getMessage(), 'Exception' => $e));
     }
     aql::$errors = array();
 }

    }
}
if ($ct_holiday_id) {
    $ct_holiday = aql::profile('ct_holiday', $ct_holiday_id);
    $holiday_name = $ct_holiday['name'];
    $holiday1 = $ct_holiday['holiday1'];
    $holiday2 = $ct_holiday['holiday2'];
    $holiday3 = $ct_holiday['holiday3'];
    $holiday4 = $ct_holiday['holiday4'];
    $holiday5 = $ct_holiday['holiday5'];
    $holiday6 = $ct_holiday['holiday6'];
}
if ($ct_campaign_id) {
    $ct_campaign = aql::profile('ct_campaign', $ct_campaign_id);
    $campaign_name = $ct_campaign['name'];
}
if ($ct_contract_id) {
    $ct_contract = aql::profile('ct_contract', $ct_contract_id);
    $contract_name = $ct_contract['name'];
    $contract_open_bar_start = $ct_contract['open_bar_start'];
    $contract_open_bar_end = $ct_contract['open_bar_end'];
}
$website_name = $p->seo['domain'] = $website->website['domain'];
$seo_phone = $website->website['seo_phone'];
$seo_year = date('Y');
if ($ct_campaign_id == 1 || $ct_holiday_id == 1) {
    $seo_year++;
}
if ($_GET['seo']) {
    echo $market_id . 'zz';
}

<?php

/*
 * This is Test demo script for AQL
*/
error_reporting(E_ALL);
require "../inc/aql.php";
$a = new aql();
$setok = $a->set('basedir', './');
if (!$setok) {
    echo __LINE__ . ' ' . $a->get_error();
}
// very simple test query
$query = <<<EOF
select * from t2.conf where section = 9999
EOF;
// select * from t2.conf where section != 'general' and section != NULL
// select section,host,secret FROM t2.conf where section <= 9995 and section != 'general' and section != null limit 6,1
// select section,host,secret FROM t2.conf where section like '%99%' and section != 'general' and section != null limit 1
$result = $a->query($query);
if ($result == false) {
    echo $a->get_error();
} else {
    print_r($result);
}
echo "====================================================================================\n";
# very simple test query
$query = "select * from t2.conf where section != 'general' and section != NULL limit 1";
$result = $a->query($query);
if ($result == false) {
    echo $a->get_error();

<?php

/*
 * This is Test demo script for AQL
*/
error_reporting(E_ALL);
require "../inc/aql.php";
$a = new aql();
$setok = $a->set('basedir', './');
if (!$setok) {
    echo __LINE__ . ' ' . $a->get_error();
}
$result = $a->query("insert into t15.conf set callerid=\"\\\"99\\\" <99>\",section='" . time() . "'");
if ($result == false) {
    echo $a->get_error();
} else {
    echo 'affected_rows :' . $a->get_affected_rows() . "\n";
}

			<hr>
			<div>host: <pre>skyphp.org</pre></div>
			<div>db name: <pre>dev_db</pre></div>
		</div>
		<div id = "sql" class = 'col'>
			<h3>SQL:</h3>
			<textarea cols="100" rows="20" id="sql_statement"></textarea>
		</div>
<?php 
$code_aql = "sky_codebase {\n\t\t\t\t\tname as codebase\n\t\t\t\t}";
$code_p = array('select_name' => 'codebase', 'value_field' => 'codebase', 'option_field' => 'codebase', 'null_option' => '- codebase -', 'selected_value' => '');
?>
		<div id = "options" class = 'col'>
			<div>Codebase:</div>
			<div><?php 
aql::dd($code_aql, $code_p);
?>
</div>
			<div><input name = "execute" type = "button" onclick = "execute()" value = "Execute" id = "execute" /></div>
			<div id = "output"></div>
		</div>
	</div>
	<div id = "previous-runs">
<?php 
#require_once('/pages/dev/db-version-control/ajax/previous-runs.php');
?>
	
	</div>
	<div class = "clear"></div>
</div>
<?php 

<?php

$model = 'blog_article';
$blog_article = aql::profile($model, IDE);
$primary_table = aql::get_primary_table($model);
$blog_article_id = $blog_article['blog_article_id'];
$blog_article_ide = $blog_article['blog_article_ide'];
$title = $blog_article['title'] ? $blog_article['title'] : 'Write A New Post';
$head_arr[] = "<script src = '/lib/swfupload/swfupload.js' type = 'text/javascript'></script>";
$head_arr[] = "<script src = '/modules/media/upload/handlers.js' type = 'text/javascript'></script>";
$head_arr[] = "<link type='text/css' rel='stylesheet' href='/modules/media/upload/progress.css' />";
template::inc('intranet', 'top');
?>
	<div id = "back_to_blogs"><a href = "/admin/blog/post/">&laquo; Back to Blog Posts</a></div>
<?php 
//$theme_ab1 = "undo,redo,|,bold,italic,underline,strikethrough,forecolor,backcolor,|,justifyleft,justifycenter,justifyright,justifyfull,fontselect,fontsizeselect,styleselect";
//$theme_ab2 = "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,sub,sup,charmap,|,link,unlink,anchor,image,cleanup,help,|,code,|,removeformat,|,fullscreen,|,preview";
$theme_ab1 = "undo,redo,|,bold,italic,underline,strikethrough,forecolor,backcolor,|,bullist,numlist,|,justifyleft,justifycenter,justifyright,justifyfull,|,styleselect";
$theme_ab2 = "cut,copy,paste,pastetext,pasteword,|,outdent,indent,blockquote,|,sub,sup,charmap,|,link,unlink,image,cleanup,|,code,|,removeformat,|,fullscreen,|,hr";
if (!$css_blog_editor) {
    $css_blog_editor = '/css/blog.css';
}
$options_article = array('resizing' => false, 'full_url' => $blog_img_absolute ? true : false, 'theme' => 'advanced', 'multi_buttons' => true, 'theme_ab1' => $theme_ab1, 'theme_ab2' => $theme_ab2, 'theme_ab3' => "", 'theme_ab4' => "", 'width' => '675', 'height' => '520', 'css' => $css_blog_editor);
$theme_ab1_notes = "bold,italic,underline,strikethrough,forecolor,backcolor,hr";
$options_notes = array('resizing' => true, 'theme' => 'advanced', 'multi_buttons' => true, 'theme_ab1' => $theme_ab1_notes, 'theme_ab2' => '', 'theme_ab3' => "", 'theme_ab4' => "", 'height' => '120', 'width' => '257');
$settings = array('article-content' => $options_article, 'note' => $options_notes);
helper::tinymce($settings);
aql::form($model);
template::inc('intranet', 'bottom');

	<div class="has-floats" style="margin-top: 20px;">
		<div style="float:left; width: 1000px; margin-right: 10px; font-weight:bold; font-size:18px;">Sentences</div>
    	<div style="float:left; font-weight:bold;">
        	<span style="font-size:18px">Order</span><br>
        	<input type="radio" name="auto-switch" value="man" <?php 
echo $man;
?>
> Manual<br>
        	<input type="radio" name="auto-switch" value="auto"> Auto
        </div>
	</div>
<?php 
$ids = array();
foreach ($sentences[0] as $key => $sentence) {
    $data = array('sentence' => addslashes(str_replace("''", '"', $sentence)), 'name' => $_POST['name'], 'source' => $_POST['source'], 'mod__person_id' => PERSON_ID);
    $insert = aql::insert('dup_sentence_data', $data);
    ?>
	
	<div id="sentence<?php 
    echo $key;
    ?>
-container" class="has-floats" style="margin:10px 0 20px 0;">
    	<div>Sentence <?php 
    echo $key + 1;
    ?>
</div>
		<div style="float:left; margin-right:10px;">
        	<input type="text" dup_sentence_data_id="<?php 
    echo $insert[0]['dup_sentence_data_id'];
    ?>
" id="sentence<?php