</div>
<?
*/
} elseif ($func == 'iorder') {
$media_item_ides = explode(',', $_POST['order']);
foreach ($media_item_ides as $key => $media_item_ide) {
$fields = array('iorder' => $key);
aql::update('media_item', $fields, $media_item_ide);
}
exit('success');
} elseif ($func == 'save_youtube_video') {
$blog_article_video_ide = $_POST['blog_article_video_ide'];
$youtube_url = $_POST['youtube_url'];
$title = $_POST['title'];
$fields = array('blog_article_id' => $blog_article_id, 'youtube_url' => $youtube_url, 'title' => $title, 'type' => $type, 'insert_time' => 'now()', 'mod__person_id' => $person_id);
$rs = aql::insert('blog_article_video', $fields);
exit('success');
} else {
if ($func == 'delete_youtube_media') {
$blog_article_video_ide = $_POST['blog_article_video_ide'];
$fields = array('active' => 0, 'update_time' => 'now()', 'mod__person_id' => $person_id);
$rs = aql::update('blog_article_video', $fields, $blog_article_video_ide);
exit('success');
} elseif ($func == 'suggest_venue') {
$string = addslashes(trim($_POST['input']));
$aql = "venue\t{\n\t\t\t\t\t\tname,\n\t\t\t\t\t\tstate,\n\t\t\t\t\t\tcity\n\t\t\t\t\t\twhere name ilike '%{$string}%'\n\t\t\t\t\t\torder by name asc\n\t\t\t\t\t}";
$rs = aql::select($aql);
if ($rs) {
?>
<div class = "suggestions">
<?php
<?php
$blog_author_ide = $_POST['blog_author_ide'];
$blog_author_id = decrypt($blog_author_ide, 'blog_author');
$aql = "\nmarket {\n name as market_name\n where market.primary = 1\n order by name asc\n}";
$markets = aql::select($aql);
$new_market_ids = array();
foreach ($markets as $market) {
if ($_POST['market_' . $market['market_ide']]) {
$new_market_ids[] = $market['market_id'];
}
}
$where = 'market_id not in (' . implode(',', $new_market_ids) . ')';
$aql = "\nblog_author_market{\n market_id\n where blog_author_id={$blog_author_id} and active=1\n}";
//'bam' short for 'blog_author_market'
$all_bam = aql::select($aql);
if (is_array($all_bam)) {
foreach ($all_bam as $bam) {
if (!in_array($bam['market_id'], $new_market_ids)) {
aql::update('blog_author_market', array('active' => 0), $bam['blog_author_market_id']);
} else {
unset($new_market_ids[array_search($bam['market_id'], $new_market_ids)]);
}
}
}
foreach ($new_market_ids as $new_market_id) {
aql::insert('blog_author_market', array('market_id' => $new_market_id, 'blog_author_id' => $blog_author_id));
}
<?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';
}
}
<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
$blog_article_id = $article_id;
$blog_tag_id = $tag_session_array_id;
#search this combination in database
$aql_article_tag = "blog_article_tag{\n\t\t\t\t\t\t\t\t*\n\t\t\t\t\t\t\t\twhere blog_article_tag.blog_article_id = '{$blog_article_id}' and blog_article_tag.blog_tag_id = '{$blog_tag_id}'\n\t\t\t\t\t\t\t}";
$rs_article_tag = aql::select($aql_article_tag);
if (count($rs_article_tag) > 0) {
$blog_article_tag_id = $rs_article_tag[0]['blog_article_tag_id'];
$table_name = 'blog_article_tag';
$data_array = array('active' => 0);
aql::update($table_name, $data_array, $blog_article_tag_id);
}
}
foreach ($_SESSION['blog_article']['tags'] as $tag_session_array_id) {
#inserting each
$table_name = 'blog_article_tag';
$data_array = array('blog_article_id' => $article_id, 'blog_tag_id' => $tag_session_array_id);
$rs = aql::insert($table_name, $data_array);
}
}
}
}
#get the blog name
if (trim($rs_article[0]['blog_id']) != '') {
$blog_id = trim($rs_article[0]['blog_id']);
$aql_blog = "blog {\n\t\t\t\t\t\t\t\t\t\t\tname,\n\t\t\t\t\t\t\t\t\t\t\tslug\n\t\t\t\t\t\t\t\t\t\t\twhere blog.id ='{$blog_id}'\n\t\t\t\t\t\t\t\t\t\t\t}";
$rs_blog = aql::select($aql_blog);
$blog_name = $rs_blog[0]['slug'];
}
//getting the article ide
$article_ide = $rs_article[0]['blog_article_ide'];
header("location:/{$blog_name}/{$article_ide}");
<?php
global $seo_field_array;
$website_id = aql::value("website_page.website_id", $_POST['website_page_id']);
if ($_POST['val'] == 1) {
$data = array('website_id' => $website_id, 'website_page_id' => $_POST['website_page_id'], 'on_website' => 1, 'uri' => $_POST['uri']);
foreach ($seo_field_array as $type => $arr) {
foreach ($arr as $field => $max) {
$data['field'] = $field;
$rs = aql::select("website_uri_data { id as uri_id where website_id = " . $website_id . " and uri = '" . $data['uri'] . "' and field='" . $field . "' }");
if (!is_numeric($rs[0]['uri_id'])) {
$data['field'] = $field;
aql::insert('website_uri_data', $data);
}
}
}
aql::update('website_page', array('url_specific' => $_POST['val']), $_POST['website_page_id']);
//sql("update website_uri_data set on_website = 1 where uri = '".$_POST['uri']."' and website_id = ".$website_id);
$aql = "website_uri_data { where uri = '" . $_POST['uri'] . "' and website_id = " . $website_id . "}";
$rs = aql::select($aql);
if ($rs) {
foreach ($rs as $r) {
$website_uri_data = array('on_website' => '1');
$rs = aql::update('website_uri_data', $website_uri_data, $r['website_uri_data_id']);
}
}
?>
<input type="hidden" id="uri_enabled" value="<?php
echo $_POST['uri'];
?>
" />
/**
* aql::insert/update on the save array depending on what needs to be done
* recursive because of sub objects / queries
* @param array $save_array array to save
* @param array $ids ids to pass through
* @return array updated save array
*/
private final function saveArray($save_array, $ids = array())
{
$is_dev = $this->isDev();
// copy out objects
$objects = $save_array['__objects__'];
unset($save_array['__objects__']);
// helper function
$addRecordInfo = function ($table_block, $is_update = false) {
$fields = array('update' => array('mod__person_id', 'update__person_id'), 'insert' => array('insert__person_id'));
$key = $is_update ? 'update' : 'insert';
$time_field = $key . '_time';
if (!$table_block['fields'][$time_field]) {
$table_block['fields'][$time_field] = aql::now();
}
if (!defined('PERSON_ID') || !is_numeric(PERSON_ID)) {
return $table_block;
}
$id = PERSON_ID;
$fields = $fields[$key];
foreach ($fields as $field) {
$table_block['fields'][$field] = $table_block['fields'][$field] ?: $id;
}
return $table_block;
};
foreach ($save_array as $table => $info) {
// make sure this is an array
$info['fields'] = arrayify($info['fields']);
foreach ($ids as $n => $v) {
if (is_array($this->_ignore['fields']) && in_array($n, $this->_ignore['fields'])) {
// since ids are added to each table in case of foreign keys
// abort if they are being ignored in this model
continue;
}
// add the id to the table block iff there are already fields
if ($info['fields'] && !$info['fields'][$n]) {
$save_array[$table]['fields'][$n] = $v;
$info['fields'][$n] = $v;
}
}
if ($info['fields']) {
$is_update = $info['id'] && is_numeric($info['id']);
$info = $addRecordInfo($info, $is_update);
if ($is_update) {
aql::update($table, $info['fields'], $info['id'], true);
} else {
$rs = aql::insert($table, $info['fields'], true);
$save_array[$table]['id'] = $info['id'] = $rs[0][$table . '_id'];
}
}
$ids[$table . '_id'] = $info['id'];
if (is_array($info['subs'])) {
foreach ($info['subs'] as $i => $sub) {
$save_array[$table]['subs'][$i] = $this->saveArray($sub, $ids);
}
}
}
if (is_array($objects)) {
foreach ($objects as $o) {
if (!$o['data']) {
continue;
}
$tmp = Model::get($o['object']);
$tmp->_data = $o['data'];
$tmp->loadIDs($ids);
$pt = $tmp->getPrimaryTable();
$pt_id = $pt . '_id';
if (!$tmp->{$pt_id} && $this->{$pt_id}) {
$tmp->{$pt_id} = $this->{$pt_id};
}
$tmp->save(true);
if ($tmp->_errors) {
$this->addErrors($tmp->_errors);
$this->failTransaction();
}
}
}
$save_array['objects'] = $objects;
return $save_array;
}
function tinyurl($url)
{
global $cookie_domain, $tiny_domain;
if ($tiny_domain) {
$domain = $tiny_domain;
} else {
if (substr($cookie_domain, 0, 1) == '.') {
$domain = substr($cookie_domain, 1);
} else {
$domain = $cookie_domain;
}
}
$aql = "url {\n tinyid\n\t\t\t\t\twhere url = '{$url}'\n\t\t\t\t}";
$rs = aql::select($aql);
$tinyid = $rs[0]['tinyid'];
if (!$rs) {
$arr = array('url' => $url);
$rs = aql::insert('url', $arr);
$tinyid = NULL;
}
//if
$url_id = $rs[0]['url_id'];
if (!$tinyid) {
$tinyid = my_base_convert($url_id, 10, 62);
aql::update('url', array('tinyid' => $tinyid), $url_id);
}
return 'http://' . $domain . '/' . $tinyid;
}
<?php
if ($_POST['sql']) {
if ($_POST['codebase']) {
$codebase = $_POST['codebase'];
$sql = $_POST['sql'];
#$dbw->Execute($sql) or die("$sql<br>" . $dbw->ErrorMsg());
$mod__person_id = $_SESSION['login']['member_id'];
$fields = array('codebase' => $codebase, 'mod__person_id' => $mod__person_id, 'version' => 'trunk', 'sql' => $sql);
aql::insert('sky_sql_log', $fields);
exit('success');
} else {
exit('Enter codebase');
}
}
<?php
if (!$_POST['list']) {
exit('Please Select a Paragraph');
} else {
foreach ($_POST['list'] as $list) {
$data = array('sentence_order' => $list, 'mod__person_id' => PERSON_ID);
aql::insert("dup_sentence_group", $data);
$num++;
}
exit('Saved');
}
$total_volume[] = $volume + $vol2[$key];
}
// CHECK THE DB AND ENTER NON-DUPS
foreach ($final as $key => $phrase) {
$split = explode(',', $phrase);
if ($split[2]) {
$mod_where = "and dup_modifier_id = " . $split[2];
} else {
$mod_where = "";
}
$rs = aql::select("\n\t\t\tdup_phrase_group { \n\t\t\t\twhere phrase1__dup_phrase_data_id = " . $split[0] . "\n\t\t\t\tand phrase2__dup_phrase_data_id = " . $split[1] . "\n\t\t\t\t{$mod_where}\n\t\t\t}\n\t\t");
if ($rs || $split[0] == $split[1]) {
$exists[$key] = true;
} else {
$data = array('name' => $_POST['group_name'], 'seo_field' => $_POST['seo_field'], 'phrase1__dup_phrase_data_id' => $split[0], 'phrase2__dup_phrase_data_id' => $split[1], 'dup_modifier_id' => $split[2], 'mod__person_id' => PERSON_ID, 'total_volume' => $total_volume[$key], 'category' => $_POST['category'], 'market_name' => $_POST['market_name'], 'page' => $_POST['page']);
aql::insert('dup_phrase_group', $data);
}
}
// SHOW THE POSTED STUFF
if ($_POST['phrase1']) {
foreach ($_POST['phrase1'] as $p1) {
if ($_POST['phrase2']) {
foreach ($_POST['phrase2'] as $p2) {
$phrases[] = $p1 . ',' . $p2;
}
}
}
}
if ($_POST['mods']) {
foreach ($phrases as $phrase) {
foreach ($_POST['mods'] as $mod) {
<?php
$data = array('name' => $_POST['website_name'], 'type' => 'skymedia', 'domain' => $_SERVER['SERVER_NAME'], 'mod__person_id' => PERSON_ID);
$insert = aql::insert('website', $data);
if (is_array($insert)) {
?>
Website Added Successfully!
<br><br>
<button onClick="location.reload()">Close</button>
<?php
}