Ejemplo n.º 1
0
 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;
 }
Ejemplo n.º 2
0
 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;
 }
Ejemplo n.º 3
0
 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;
 }
Ejemplo n.º 4
0
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>";
}
Ejemplo n.º 5
0
" value="<?php 
        echo $page['page_type'];
        ?>
" /><span style="font-size: 10px; color: rgb(0, 102, 0); margin-left: 4px; display: inline; " id="saved_1"></span></td>
                    <td>page_path = <?php 
        echo $page['page_path'];
        ?>
</td>
                </tr>
            </table>
	<?php 
        // Insert the blank field records in the db for website_page fields that don't already exist
        $y = 2;
        foreach ($seo_field_array as $type => $field_array) {
            foreach ($field_array as $field => $max) {
                $rs2 = aql::select("website_page_data { id where field = '{$field}' and website_page_id = {$page['website_page_id']} }");
                if (!$rs2) {
                    $data = array('field' => $field, 'website_id' => $website_id, 'website_page_id' => $page['website_page_id'], 'mod__person_id' => PERSON_ID);
                    aql::insert('website_page_data', $data);
                }
            }
            if (!isset($header)) {
                ?>
					<fieldset style="width:872px; background:#f3f3f3; margin-bottom:4px; border: 1px solid #ccc; padding:5px;">
						<legend style="border: 1px solid #ccc; background:#ffffff; font-weight:bold; padding:2px 5px 2px 5px;"><?php 
                echo strtoupper(str_replace('_', ' ', $type));
                ?>
</legend>
	<?php 
                $header = $type;
            } else {
Ejemplo n.º 6
0
		
		
<?php 
$SQL = "select id from market limit 1";
$r = $db->Execute($SQL);
if (!$db->ErrorMsg()) {
    ?>
        <!-- Section for Market Start -->
		<h2 class="module-bar">Market</h2>
			<div class="module-body">
	            <div class="module-container">
                    <p>
                    <?php 
    #fetching all the market value
    $aql_market = "market {\n                        * \n                        where market.primary = 1          \n\t\t\t\t\t\torder by market.name asc\n                        }";
    $rs_market = aql::select($aql_market);
    ?>
                    <select name="market_id">
						<?php 
    $selected = $rs_article[0]['market_id'] == "" ? "selected" : "";
    ?>
						<option value="NULL" <?php 
    echo $selected;
    ?>
>National</option>
                   		<?php 
    foreach ($rs_market as $market) {
        $selected = $market['market_id'] == $rs_article[0]['market_id'] ? "selected" : "";
        ?>
                        	<option value="<?php 
        echo $market['market_id'];
Ejemplo n.º 7
0
 function getUpcomingHolidays($date = NULL)
 {
     if (!$date) {
         $date = time();
     }
     $year = date('Y');
     $rs = aql::select("ct_holiday { slug, date where date is not null order by date_order asc }");
     foreach ($rs as $r) {
         if (strtotime($r['date'] . '/' . $year) > $date) {
             $this_years_holidays[$r['slug']] = strtotime($r['date'] . '/' . $year);
         } else {
             $next_years_holidays[$r['slug']] = strtotime($r['date'] . '/' . ($year + 1));
         }
     }
     return array_merge($this_years_holidays, $next_years_holidays);
 }
Ejemplo n.º 8
0
<?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';
    }
}
Ejemplo n.º 9
0
	</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>
Ejemplo n.º 10
0
 /**
  * auth class
  * 
  * Organization: Hotwire Communications
  * Author: Harley Fischel
  */
 public static function permission($params = null, $person_id = null)
 {
     $params = trim($params);
     if (empty($params)) {
         return false;
     }
     if (empty($person_id) && isset($_SESSION['login']['person_id'])) {
         $person_id = $_SESSION['login']['person_id'];
     }
     // old method support
     if (!strpos($params, ':')) {
         $arr = explode(',', $params);
         foreach ($arr as $arg) {
             if (strpos(strtolower($_SESSION['login']['access_group']), strtolower($arg)) !== false) {
                 return true;
             }
         }
         return false;
     }
     static $access, $key;
     // new method
     $perms = explode(';', $params);
     foreach ($perms as $perm) {
         list($group, $granted) = explode(':', $perm);
         if (empty($group)) {
             return false;
         }
         if (empty($key[$group])) {
             $key[$group] = md5($group . $person_id);
         }
         if (empty($access[$key[$group]]) && !empty($person_id)) {
             $rs = aql::select(" {$group} { id, access_group } ", array('where' => array(0 => ($group != 'person' ? 'person_' : '') . 'id=' . $person_id), 'limit' => 1));
             $access[$key[$group]] = array_map(function ($str) {
                 return md5(trim(strtolower($str)));
             }, explode(',', $rs[0]['access_group']));
             // un-comment to see access array
             //			echo "<pre>md5:\n".print_r($access,true)."</pre>";
         }
         if ($granted == '*') {
             return true;
         }
         if (is_array($access[$key[$group]])) {
             if (in_array(md5($granted), $access[$key[$group]])) {
                 return true;
             }
         }
     }
     return false;
 }
Ejemplo n.º 11
0
Archivo: list.php Proyecto: hshoghi/cms
        
        <div class="col">
        	<?php 
$aql = "blog {\n\t\t\t\t\t \tid,\n\t\t\t\t\t\tname\n\t\t\t\t\t}\n\t\t\t\t\tblog_website {\n\t\t\t\t\t\twhere website_id = {$website_id}\n\t\t\t\t\t}";
$dropdown = array('select_name' => 'blog_id', 'value_field' => 'blog_id', 'option_field' => 'name', 'selected_value' => $_GET['blog_id'], 'null_option' => 'All Blogs', 'onchange' => 'this.form.submit();');
aql::dd($aql, $dropdown);
?>
        </div>
        
        <?php 
if (auth('admin', 'developer', 'blog_editor')) {
    ?>
        <div class="col">
			<?php 
    $aql = "blog_author {\n\t\t\t\t\t\tperson_id\n\t\t\t\t\t\twhere website_id = {$website_id}\n\t\t\t\t\t}\n\t\t\t\t\tperson {\n\t\t\t\t\t\tfname,\n\t\t\t\t\t\tlname\n\t\t\t\t\t\torder by lname asc\n\t\t\t\t\t}";
    $rs_author = aql::select($aql);
    ?>
            <select name="author_ide" onchange="this.form.submit();">
            <option value="">All Contributors</option>
            <?php 
    if ($rs_author) {
        foreach ($rs_author as $author) {
            ?>
            <option value="<?php 
            echo $author['person_ide'];
            ?>
" 
				<?php 
            echo $author['person_ide'] == $_GET['author_ide'] ? 'selected="selected"' : '';
            ?>
 >
Ejemplo n.º 12
0
 /**
  * Executes the actual select query based on sql_array and settings,
  * It will execute recursively based on the given array
  * depending on if there are "subs" or objects and their respective sql_arrays and aql
  *
  * @see self::sql()
  * @param   array   $arr    generated sql array
  *                  - sql
  *                  - sql_list
  *                  - sql_count
  *                  - subs
  *                  - objects
  * @param   array   $settings
  *                  - object (bool)
  *                  - aql_statement (string)
  *                  - select_type (string) default is 'sql'
  * @param   db      $db_conn
  * @return  array
  * @throws  \Sky\AQL\ConnectionException    if no db
  * @throws  \Sky\AQL\SelectException        if db select fails
  */
 private static function sql_result($arr, $settings, $db_conn = null)
 {
     if (!$db_conn) {
         $db_conn = self::getDB();
     }
     if (self::in_transaction()) {
         $db_conn = self::getMasterDB();
         $silent = true;
     }
     if (!$db_conn) {
         throw new \Sky\AQL\ConnectionException('Cannot Execute AQL without a db connection');
     }
     $object = $settings['object'];
     $aql_statement = $settings['aql_statement'];
     $sub_do_set = $settings['sub_do_set'];
     $select_type = $settings['select_type'] ?: 'sql';
     $rs = array();
     $microtime_start = microtime(true);
     $r = $db_conn->Execute($arr[$select_type]);
     if (class_exists('hwc_debug')) {
         hwc_debug::add_aql($arr[$select_type], number_format(microtime(true) - $microtime_start, 3));
     }
     if ($r === false) {
         $e = new \Sky\AQL\SelectException($aql_statement, $arr[$select_type], $db_conn->ErrorMsg());
         if (!$silent) {
             throw $e;
         } else {
             aql::$errors[] = $e;
         }
         return $rs;
     }
     while (!$r->EOF) {
         $tmp = self::generate_ides($r->GetRowAssoc(false));
         $placeholder = null;
         $get_placeholder = function ($m) use($tmp, &$placeholder) {
             return $placeholder = $tmp[$m[1]];
         };
         $replace_placeholder = function ($clause) use($get_placeholder) {
             return preg_replace_callback('/\\{\\$([\\w.]+)\\}/', $get_placeholder, $clause);
         };
         if ($arr['subs']) {
             foreach ($arr['subs'] as $k => $s) {
                 $s['sql'] = $replace_placeholder($s['sql']);
                 if ($placeholder) {
                     $params = array('object' => $object);
                     $tmp[$k] = self::sql_result($s, $params, $db_conn);
                 }
             }
         }
         $placeholder = '';
         if ($arr['objects']) {
             foreach ($arr['objects'] as $k => $s) {
                 $m = $s['model'];
                 if ($s['plural'] && $s['sub_where']) {
                     $clauses = self::get_clauses_from_model($m);
                     $min_aql = self::get_min_aql_from_model($m);
                     $clauses['where'][] = $replace_placeholder($s['sub_where']);
                     $query = aql::select($min_aql, $clauses, null, null, $sub_do_set, $db_conn);
                     if ($query) {
                         // new getRecords method
                         $ca = $s['constructor argument'];
                         $p = new $m();
                         $arr = array('ids' => array_map(function ($a) use($ca) {
                             return $a[$ca];
                         }, $query));
                         foreach ($p->getRecords($arr) as $row) {
                             $tmp[$k][]['_data'] = $row;
                         }
                         // old query loop method
                         /*                            foreach ($query as $row) {
                                                         $arg = $row[$s['constructor argument']];
                                                         $o = Model::get($m, $arg, $sub_do_set);
                                                         $tmp[$k][] = ($object) ? $o : $o->dataToArray();
                                                     }*/
                     }
                 } else {
                     if (!$s['plural']) {
                         $arg = (int) $tmp[$s['constructor argument']];
                         if ($arg) {
                             $o = Model::get($m, $arg, $sub_do_set);
                             $tmp[$k] = $object ? $o : $o->dataToArray();
                         }
                     }
                 }
             }
         }
         if ($object && $aql_statement) {
             $tmp_model = $object === true ? new Model(null, $aql_statement) : Model::get($object);
             $tmp_model->loadArray($tmp);
             $tmp_model->_token = $tmp_model->getToken();
             $tmp = $tmp_model;
         }
         $rs[] = $tmp;
         $r->moveNext();
     }
     return $rs;
 }
Ejemplo n.º 13
0
<?php

$rs = aql::select("website_uri_data { value where website_id = {$_POST['website_id']} and uri = '{$_POST['uri']}' and field = '{$_POST['field']}' }");
if ($rs) {
    aql::update("website_uri_data", array('on_website' => $_POST['url_specific']), $rs[0]['website_uri_data_id']);
}
if (!$_POST['url_specific']) {
    $rs = aql::select("website_page_data { value where field = '{$_POST['field']}' and website_page_id = {$_POST['website_page_id']} }");
}
exit($rs[0]['value']);
Ejemplo n.º 14
0
Archivo: mp3.php Proyecto: hshoghi/cms
<?php

$type = "mp3";
$blog_article_ide = IDE ? IDE : $_POST['blog_article_ide'];
$blog_article_id = $blog_article_id ? $blog_article_id : decrypt($blog_article_ide, 'blog_article');
$vfolder_path = '/blog/blog_article/' . $blog_article_id . '/mp3';
$media_upload['vfolder_path'] = $vfolder_path;
#$vfolder = media::get_vfolder($media_upload['vfolder_path']);
$aql = "blog_media{\t\n\t\t\t\t\tmedia_item_id as id,\n\t\t\t\t\ttitle\n\t\t\t\t\twhere type='mp3'\n\t\t\t\t\tand blog_article_id = {$blog_article_id}\n\t\t\t\t\torder by title asc\n\t\t\t\t}";
$vfolder['items'] = aql::select($aql);
?>


<div class = "float-left youtube_upload">
	<h2>A) Youtube</h2>
	<input type = "button" value = "Add YouTube Song" onclick = "new_youtube_media('<?php 
echo $type;
?>
')" />
</div>
<div class = "has-floats" id = "images">
<h2>B) MP3 Upload</h2>
	<input type = "hidden" name = "vfolder_path" id = "vfolder_path" value = "<?php 
echo $vfolder_path;
?>
"/>
	<input type = "hidden" name = "session_id" id = "session_id" value = "<?php 
echo session_id();
?>
"/>
<?php 
Ejemplo n.º 15
0
        ?>
</h2>
            <br>
            This Website Cannot Be Optimized Until it is Set Up in the System
            <br><br>
            Would You Like to Set it Up Now?&nbsp;&nbsp;&nbsp;&nbsp;<button id="set-up-website">Yes</button>&nbsp;&nbsp;&nbsp;&nbsp;<button id="close">No</button>
			
<?php 
        // The website exists... move forward to the check if website_page record is entered
    } else {
        $aql = "website_page { url_specific, page_type, page_path, nickname where page_path = '" . addslashes($_POST['page_path']) . "' and website_id = {$website_id} }";
        $rs = aql::select($aql);
        $page = $rs[0];
        if ($page['website_page_id']) {
            if ($page['url_specific']) {
                $rs_uri = aql::select("website_uri_data { where website_id = " . $website_id . " and uri = '" . $uri . "' and on_website = 1 }");
                if ($rs_uri) {
                    $url_specific_flag = true;
                } else {
                    $url_specific_flag = false;
                }
            }
            // We have a website_page_record so load the form
            ?>
				<div style="margin-bottom:10px;">
				<input type="checkbox" id="url_specific" website_id="<?php 
            echo $website_id;
            ?>
" website_page_id="<?php 
            echo $page['website_page_id'];
            ?>
Ejemplo n.º 16
0
		</div>
		<div class="field float-left">
			<?php 
$field = "website_id";
?>
			<label class="label" for="<?php 
echo $field;
?>
">Website</label><br>
			<select name="<?php 
echo $field;
?>
" style="width:200px;">
				<option value="">- Website -</option>
<?php 
$rs = aql::select("website { name order by name }");
foreach ($rs as $r) {
    ?>
	
					<option value="<?php 
    echo $r['website_id'];
    ?>
" <?php 
    echo $r['website_id'] == $o['website_id'] ? 'selected' : '';
    ?>
><?php 
    echo $r['name'];
    ?>
</option>
<?php 
}
Ejemplo n.º 17
0
 /**
  * Uses required fields to fetch the identifier of the object if it is not set
  * Should generally be used in postValidate() for a uniqueness constraint on the
  * required fields
  * This sets $this->{primary_table_id}
  *
  * @return Model   $this
  */
 public function getIDByRequiredFields()
 {
     # if there are errors | have ID | no required fields return
     if ($this->_errors || $this->getID() || !$this->hasRequiredFields()) {
         return $this;
     }
     # set up
     $where = array();
     $clause = array('limit' => 1, 'where' => &$where);
     $aql = sprintf('%s { }', $this->getPrimaryTable());
     $key = $this->getPrimaryTable() . '_id';
     # make where
     foreach ($this->getRequiredFields() as $f) {
         $where[] = sprintf("%s = '%s'", $f, $this->{$f});
     }
     $rs = aql::select($aql, $clause);
     $this->{$key} = $rs[0][$key] ?: $this->{$key};
     $this->_token = $this->_token ?: $this->getToken();
     return $this;
 }
Ejemplo n.º 18
0
 public function checkLogin()
 {
     global $access_groups, $access_denied, $rs_logins;
     if ($this->login_path) {
         $this->checkLoginPath();
     }
     if (!$this->post_password) {
         $this->_errors[] = 'You need to enter a password.';
     }
     if (!$this->post_username) {
         $this->_errors[] = 'You need to enter a username or email address';
     }
     if ($this->_errors) {
         return $this->r();
     }
     $username = trim(strtolower($this->post_username));
     $aql = "\n\t\t\t\t\tperson {\n\t\t\t\t\t\twhere (\n\t\t\t\t\t\t\tlower(email_address) like '{$username}' or lower(username) like '{$username}'\n\t\t\t\t\t\t\tand password_hash is not null\n\t\t\t\t\t\t)\n\t\t\t\t\t\torder by id desc\n\t\t\t\t\t}\n\t\t\t\t";
     $rs_logins = aql::select($aql);
     if ($this->post_password) {
         $granted = false;
         foreach ($rs_logins as $p) {
             $this->person = new person($p['person_id'], null, true);
             if (!$this->person->person_id) {
                 continue;
             }
             if ($this->_checkLogin($this->post_password)) {
                 if (auth_person($access_groups, $this->person->person_id) || !$access_groups) {
                     $access_denied = false;
                     return $this->r(array('person_ide' => $this->person->person_ide));
                 }
             }
         }
     }
     $this->_errors[] = 'Invalid Login';
     return $this->r();
 }
Ejemplo n.º 19
0
                $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}");
Ejemplo n.º 20
0
                      </tr>                                                
                   <?php 
    }
    ?>
              </table>
              

           </fieldset>

           <fieldset><legend>Assignments</legend>

              <a href='javascript:toggle_inactive();' id='toggle_inactive'>Show Inactive</a>

           <?php 
    $aql = "blog_author{\n                            where person_id={$blog_author['person_id']}\n                            order by status!='A'\n                         }";
    $blog_authors_rs = aql::select($aql);
    foreach ($blog_authors_rs as $form_id => $blog_author_rs) {
        $blog_author = aql::profile('blog_author', $blog_author_rs['blog_author_ide']);
        ?>
<fieldset id='blog_author_fieldset_<?php 
        echo $form_id;
        ?>
' class='blog_author_<?php 
        echo $blog_author['status'] != 'A' ? 'inactive' : 'active';
        ?>
'><?php 
        //                     include( 'aql/models/blog_author/blog_author_form.php' );
        aql::form('blog_author');
        ?>
                     <input class='blog_author_form_save_button' type="button" value="Save" onclick="save_button(true,'blog_author_form_<?php 
        echo $form_id;
Ejemplo n.º 21
0
<?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));
}
Ejemplo n.º 22
0
Archivo: ide.php Proyecto: hshoghi/cms
$p->template('intranet', 'top');
$link = function ($table, $id) {
    return sprintf('/dev/ide/%s/%s', $table, $id);
};
include 'pages/dev/dev-nav.php';
?>

    <div id="idePage">

<?php 
if ($this->ide) {
    if ($this->queryfolders[0] && $this->queryfolders[1] && $this->queryfolders[2]) {
        list($tablename, $fieldname, $value) = $this->queryfolders;
        $value = is_numeric($value) ? $value : "'{$value}'";
        $aql = "\n                        {$tablename} {\n                            id\n                            where {$fieldname} = {$value}\n                            ORDER BY id ASC\n                        }\n                    ";
        $records = aql::select($aql);
        if ($records) {
            if (count($records) == 1) {
                header("Location: {$link($tablename, $records[0]['id'])}");
            }
            foreach ($records as $r) {
                ?>
                    <p>
                        <a  href="<?php 
                echo $link($tablename, $r['id']);
                ?>
"
                            style="color:blue"
                            >
                            ID: <?php 
                echo $r['id'];
Ejemplo n.º 23
0
<?php

$websites = aql::select("website_group { website_id } website { name as website_name where website_group.name = '{$_POST['website_group_name']}' order by website.name asc }");
if (is_array($websites)) {
    foreach ($websites as $website) {
        ?>
			<div class="website"><?php 
        echo $website['website_name'];
        ?>
</div>
<?php 
        $pages = aql::select("website_page { nickname, page_path where website_id = {$website['website_id']} order by nickname asc } ");
        if (is_array($pages)) {
            foreach ($pages as $page) {
                ?>
					<a class="edit_page" title="<?php 
                echo $page['page_path'];
                ?>
" wg="<?php 
                echo $_POST['website_group_name'];
                ?>
" page_ide="<?php 
                echo $page['website_page_ide'];
                ?>
">
    	            	<div class="nickname"><?php 
                echo $page['nickname'];
                ?>
</div>
						<div class="page_path"><?php 
                echo $page['page_path'];
Ejemplo n.º 24
0
        $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;
?>
Ejemplo n.º 25
0
<?php

$rs = aql::select("website_page_data { draft, value where id = {$_POST['website_page_data_id']} }");
if ($_POST['type'] == 'draft') {
    $value = $rs[0]['draft'];
} else {
    $value = $rs[0]['value'];
}
?>
<input type="text" class="input" value="<?php 
echo $value;
?>
" field="<?php 
echo $_POST['field'];
?>
" field_type="<?php 
echo $_POST['type'];
?>
" wpd_id="<?php 
echo $_POST['website_page_data_id'];
?>
" />
Ejemplo n.º 26
0
Archivo: grid.php Proyecto: hshoghi/cms
<?php

$blog_id = trim($_REQUEST['blog_id']);
#sorting variable
$sort_by = $_REQUEST['sort_by'];
$sort_type = $_REQUEST['sort_type'];
$order_by = $sort_by . " " . $sort_type;
$condition = "";
if ($blog_id != "") {
    $condition = " where blog.id ='" . $blog_id . "'";
}
echo $aql_blog_title = "blog {\n            name\n        }\n        blog_article {\n            title             \n        }";
$rs_blog = aql::select($aql_blog_title);
//print_a($rs_blog);
// step 2. specify which columns to add to the grid
$cols = "id {}\n\t\t\t\tname {\n                label: Blog;\n            }\n\t\t\ttitle {\n\t\t\tlabel: Article;\n\t\t}\n\t\t\t\n\t\t\t";
// step 3. display the data grid on the page
$param = array('table_class' => '');
grid::render($aql_blog_title, $col, $param);
Ejemplo n.º 27
0
<div id="seo_fields">
<?php 
$opt_phrase = aql::value("website_page.opt_phrase", $page['website_page_ide']);
?>
	<div class="seo_field">
		<fieldset>
			<legend class="legend">Opt Phrase</legend>
			<h3><?php 
echo $opt_phrase ? $opt_phrase : 'Not Set';
?>
</h3>
		</fieldset>
	</div>
<?php 
foreach ($seo_field_array['html'] as $field => $max) {
    $rs = aql::select("website_page_data { draft, value where field = '{$field}' and website_page_ide = '{$page['website_page_ide']}' }");
    ?>
		<div class="seo_field">
           	<fieldset>
				<legend class="legend"><?php 
    echo ucwords(str_replace('_', ' ', $field));
    ?>
</legend>
            	<div class="draft">
					<div>Draft  <span class="field_result" id="draft_result_<?php 
    echo $field;
    ?>
_<?php 
    echo $page['website_page_ide'];
    ?>
"></span></div>
Ejemplo n.º 28
0
Archivo: mods.php Proyecto: hshoghi/cms
<?php

$where = array();
if ($_POST['page']) {
    $where[] = "( page = '{$_POST['page']}' OR page = 'general' )";
}
if ($_POST['sub_category']) {
    $where[] = "sub_category = '{$_POST['sub_category']}'";
}
$mods = aql::select("dup_modifier { id as mod_id, lower(phrase) as lower_phrase, phrase order by sub_category, phrase }", array('dup_modifier' => array('where' => $where)));
if ($mods) {
    foreach ($mods as $data) {
        ?>
		<div><input type="checkbox" id="mod_<?php 
        echo $data['mod_id'];
        ?>
" phrase="<?php 
        echo $data['phrase'];
        ?>
" mod_id="<?php 
        echo $data['mod_id'];
        ?>
" class="mod-cb" id="<?php 
        echo $data['lower_phrase'];
        ?>
" /> <label for="mod_<?php 
        echo $data['mod_id'];
        ?>
">{<?php 
        echo $data['mod_id'];
        ?>
Ejemplo n.º 29
0
                email($message, $subject, $to, $from);
                // update blog_article
                $fields = array('notification_sent' => 'now()');
                aql::update('blog_article', $fields, $blog_article_id);
                exit('Notification has been sent.');
            } else {
                exit('Error: notification template has not been created or notifacation has already been sent.');
            }
        } else {
            exit("Error: Enter valid target email address.");
        }
    } elseif ($func == 'set_blog_media_title') {
        $title = $_POST['title'];
        $type = $_POST['type'];
        $aql = "blog_media\t{\n\t\t\t\t\t\t\twhere media_item_ide = {$media_item_ide}\n\t\t\t\t\t\t\tand type = '{$type}'\n\t\t\t\t\t\t}";
        $rs = aql::select($aql);
        if ($rs) {
            $fields = array('title' => $title, 'update_time' => 'now()', 'mod__person_id' => $person_id);
            aql::update('blog_media', $fields, $rs[0]['blog_media_id']);
            exit('success');
        } else {
            exit('Error: could not find this media file in database.');
        }
    } else {
        exit('Error: Unrecognized function.');
    }
}
function email($message_text, $subject, $to, $from)
{
    // message
    $message = "\n\t<html>\n\t<head>\n\t  <title>{$subject}</title>\n\t</head>\n\t<body>\n\t  {$message_text}\n\t</body>\n\t</html>";
Ejemplo n.º 30
0
Archivo: new.php Proyecto: hshoghi/cms
                $_SESSION['blog_article']['tags'][] = $rs_tag[0]['blog_tag_id'];
            }
        } else {
            /* IT A NEW ENTRY IN DATA BASE */
            $table_name = 'blog_tag';
            $data_array = array('name' => $name);
            $rs = aql::insert($table_name, $data_array);
            $_SESSION['blog_article']['tags'][] = $rs[0]['id'];
        }
    }
}
#showing the tag
if (count($_SESSION['blog_article']['tags'])) {
    foreach ($_SESSION['blog_article']['tags'] as $tag_session_array_id) {
        $aql_tag = "blog_tag {\n\t\t\t\t\t\t\tname\n\t\t\t\t\t\t\twhere blog_tag.id ='{$tag_session_array_id}'\t\t\t\t\t\t \n\t\t\t\t\t\t}";
        $rs_tag = aql::select($aql_tag);
        foreach ($rs_tag as $tag_info) {
            ?>
					<NOBR>
						<img 
						src="/images/cross_black.jpg" 
						alt="Click here to delete the Tag"
						title ="Click here to delete the Tag"
						onmouseover="this.src='/images/cross_red.jpg'"
						onmouseout="this.src='/images/cross_black.jpg'"
						onclick="deletetag(<?php 
            echo $tag_info['blog_tag_id'];
            ?>
)" style="vertical-align:middle;"/>
						<span style="vertical-align:middle;"><?php 
            echo $tag_info['name'];