else {
$nocat = 1;
}
$where = join(' AND ', $criterias);
// GET TOTAL ARTICLES
$total_articles = $article->article_total($where);
$articles_totalnocat = $article->article_total(join(' AND ', array_merge($article_menu_filter,array('no'=>"article_articlecat_id='0'"))));
// MAKE ARTICLE PAGES
$articles_per_page = 10;
$page_vars = make_page($total_articles, $articles_per_page, $p);
$s = rc_toolkit::get_request('s','date');
if ($s == 'view') {
$sort = "article_views DESC";
}
elseif ($s == 'title') {
$sort = "article_title ASC";
}
else {
$sort = "article_date_start DESC";
$s = 'date';
}
$category_info = $rc_articlecats->get_record($articlecat_id);
/*
rc_toolkit::debug($categories, "CATEGORIES MENU");
$page = "admin_article";
include "admin_header.php";
$task = rc_toolkit::get_request('task', 'main');
$rc_articlecats = new rc_articlecats();
$result = "";
$rc_validator = new rc_validator();
$keys = array('setting_article_license', 'setting_permission_article', 'setting_email_articlecomment_subject', 'setting_email_articlecomment_message', 'setting_email_articlemediacomment_subject', 'setting_email_articlemediacomment_message');
// SET RESULT VARIABLE
// SAVE CHANGES
if ($task == "dosave") {
foreach ($keys as $key) {
$setting[$key] = $data[$key] = $_POST[$key];
}
if (!$rc_validator->has_errors()) {
$rc_articlecats->save_categories($_POST['articlecat_title'], $_POST['articlecat_title_sub']);
$database->database_query("UPDATE se_settings SET " . rc_toolkit::db_data_packer($data));
$setting = $database->database_fetch_assoc($database->database_query("SELECT * FROM se_settings LIMIT 1"));
$result = 11150203;
}
}
foreach ($keys as $key) {
$smarty->assign($key, $setting[$key]);
}
$categories = $rc_articlecats->get_categories(0);
$smarty->assign('is_error', $rc_validator->has_errors());
$smarty->assign('error_message', join(" ", $rc_validator->get_errors()));
$smarty->assign('result', $result);
$smarty->assign('permission_article', $setting['setting_permission_article']);
$smarty->assign('categories', $categories);
$smarty->assign('cat_max_id', $rc_articlecats->get_max_id());
include "admin_footer.php";
function log_tag($name)
{
// just some safety
if ($name=='') return false;
if ($this->case_insensitive) $name = strtolower($name);
$data = array('tag_name'=>$name);
$data_string = rc_toolkit::db_data_packer($data);
$tag = $this->get_record_by_criteria($data_string);
if ($tag) {
$data['tag_count'] = $tag['tag_count'] + 1;
$this->update($tag[$this->pk],$data);
return $tag[$this->pk];
}
else {
$data['tag_count'] = 1;
return $this->insert($data);
}
}
// GET PRIVACY SETTINGS
$level_article_privacy = unserialize($user->level_info[level_article_privacy]);
rsort($level_article_privacy);
$level_article_comments = unserialize($user->level_info[level_article_comments]);
rsort($level_article_comments);
$article_draft = 0;
$article_privacy = $level_article_privacy[0];
$article_comments = $level_article_comments[0];
$article_search = 1;
$articlecat_id = 0;
$subarticlecat_id = 0;
$article_date_start = time();
$article_tags = rc_toolkit::get_request('article_tags');
// INITIALIZE ARTICLE OBJECT
$new_article = new rc_article($user->user_info[user_id], 0);
// ATTEMPT TO ADD ARTICLE
if($task == "doadd") {
$article_title = censor($_POST['article_title']);
$article_body = censor($_POST['article_body']);
$articlecat_id = $_POST['articlecat_id'];
$subarticlecat_id = $_POST['subarticlecat_id'];
$article_draft = isset($_POST['draft']) ? 1 : 0;
$article_search = $_POST['article_search'];
$article_privacy = $_POST['article_privacy'];
$article_comments = $_POST['article_comments'];
<?
$page = "user_education";
include "header.php";
$task = rc_toolkit::get_request('task','main');
$result = "";
$rc_validator = new rc_validator();
$rc_education = new rc_education($user->user_info[user_id]);
if($user->level_info[level_education_allow] == 0) { header("Location: user_home.php"); exit(); }
if ($task == 'dosave') {
$educations = $_POST['educations'];
//rc_toolkit::debug($educations);
foreach ($educations as $eid=>$education) {
if (strlen($education['education_name'])==0) {
$rc_education->delete($eid);
}
elseif ($eid == 'new') {
$rc_education->insert($education);
}
else {
$rc_education->update($eid,$education);
}
}
$result = 11040714;
}
$searched_fields = rc_toolkit::get_request('search',array());
if ($task == 'search' || $task == 'browse') {
$searchable_fields = array(
'education_name',
'education_year',
'education_for',
'education_degree',
'education_concentration1',
'education_concentration2',
'education_concentration3'
);
$operation = strtolower(rc_toolkit::get_request('operation','and'));
if (!in_array($operation, array('and','or'))) $operation = 'and';
foreach ($searched_fields as $field => $value) {
// security filter !!
if (in_array($field, $searchable_fields)) {
$value = mysql_real_escape_string($value);
$search_data[$field] = " $field LIKE '%$value%' ";
$search_query .= "search[$field]=".urlencode($value).'&';
}
}
$criteria = " JOIN se_users ON se_users.user_id = se_educations.education_user_id";
if (count($search_data)) {
$criteria .= " WHERE " . join(" $operation ", $search_data);
}
