public function find_default_ctrAction($die = true)
{
$stat = new stat();
$category = new category();
$categories = $category->select($count);
$datetime = date("Y-m-d H:i:s", time() - 60 * 60 * 24);
foreach ($categories as $category) {
$gifts = $category->get_gifts(array('filter' => array('not_default_ctr' => true)));
$gifts_ids = array();
$min_ctr = Zend_Registry::get('config')->ctr->norma;
$default_ctr = 0;
// Определим минимальный по палате ctr
if (is_array($gifts) && count($gifts) > 0) {
foreach ($gifts as $gift) {
if (!empty($gift->id)) {
$gifts_ids[] = $gift->id;
if ($gift->ctr > 1 && $gift->ctr < $min_ctr) {
$min_ctr = $gift->ctr;
}
}
}
}
$views = $stat->get_total_views_by_category($datetime, $category->get('id'));
$default_ctr = $views > 0 ? $stat->get_total_clicks_by_category($datetime, $category->get('id')) * Zend_Registry::get('config')->ctr->norma / $views : 0;
if ($default_ctr < $min_ctr) {
$default_ctr = $min_ctr;
}
echo $category->get('category') . ', default CTR: ' . $default_ctr . ', min CTR: ' . $min_ctr . '<br>';
$category->update(array('default_ctr' => (int) $default_ctr, 'min_ctr' => (int) $min_ctr));
sleep(1);
}
if ($die) {
die;
}
}
?>
</button>
</div>
</form>
<?php
} else {
if (isset($_POST['published'])) {
$_POST['published'] = true;
} else {
$_POST['published'] = false;
}
$category = new category();
$category->setId(intval($_GET['i']));
$category->setContent($_POST['title_1'], $_POST['description_1'], $_POST['title_2'], $_POST['description_2'], $_POST['title_3'], $_POST['description_3'], $_POST['title_4'], $_POST['description_4'], $_POST['title_5'], $_POST['description_5'], $_POST['title_6'], $_POST['description_6'], $_POST['code']);
$category->setUserId($account["name"]);
$category->setDateUpdate();
$category->setPublished($_POST['published']);
$category->setCategoryType($_POST['category_type']);
if ($category->update()) {
print 'sucess';
} else {
print 'failure';
}
}
} else {
print 'error';
}
?>
</div>
*/
if (!empty($_POST)) {
include_once 'pear-database-category.php';
switch (@$_POST['action']) {
case 'add':
if (!empty($_POST['catDesc']) and !empty($_POST['catName'])) {
$result = category::add(array('name' => $_POST['catName'], 'desc' => $_POST['catDesc'], 'parent' => !empty($_POST['cat_parent']) ? (int) $_POST['cat_parent'] : null));
$_SESSION['category_manager']['error_msg'] = PEAR::isError($result) ? 'Failed to insert category: ' . $result->message : 'Category added';
} else {
$_SESSION['category_manager']['error_msg'] = 'Please enter a name and description!';
}
localRedirect('/admin/category-manager.php');
break;
case 'update':
if (!empty($_POST['catDesc']) and !empty($_POST['catName'])) {
$result = category::update((int) $_POST['cat_parent'], $_POST['catName'], $_POST['catDesc']);
$_SESSION['category_manager']['error_msg'] = PEAR::isError($result) ? 'Failed to insert category: ' . $result->message : 'Category updated';
} else {
$_SESSION['category_manager']['error_msg'] = 'Please enter a name and description!';
}
localRedirect('/admin/category-manager.php');
break;
case 'delete':
if (!empty($_POST['cat_parent'])) {
$result = category::delete($_POST['cat_parent']);
$_SESSION['category_manager']['error_msg'] = PEAR::isError($result) ? 'Failed to delete category: ' . $result->message : 'Category deleted';
} else {
$_SESSION['category_manager']['error_msg'] = 'Please select a category';
}
localRedirect('/admin/category-manager.php');
break;
$_SESSION['errors'] = $errors;
}
if ($category->category_is_exist($_GET['name'])) {
$errors[] = "the category is already exist";
$_SESSION['errors'] = $errors;
}
if (empty(trim($_GET['desc']))) {
$errors[] = "the desc is empty";
$_SESSION['errors'] = $errors;
}
if (!empty($errors)) {
$errors[] = $_GET["id"];
} else {
$category->category_name = $_GET['name'];
$category->category_desc = $_GET['desc'];
$category->update();
}
$data = $category->getallcategory();
$response1 = [];
$response1[] = $data;
$response1[] = $errors;
$jsondata = json_encode($response1);
echo $jsondata;
// $jsondata = json_encode($data);
// echo $jsondata;
}
if ($_GET['value'] == 'Edit') {
$category = new category($_GET['id']);
$jsondata = json_encode($category);
echo $jsondata;
}
dmsg('更新成功', "?mid={$mid}&file={$file}");
break;
case 'delete':
if ($catid) {
$catids = $catid;
}
$catids or msg();
$do->delete($catids);
$NUM > 200 ? $do->cache() : $do->repair();
dmsg('删除成功', $forward);
break;
case 'update':
if (!$category || !is_array($category)) {
msg();
}
$do->update($category);
foreach ($category as $catid => $v) {
$CATEGORY[$catid] = $db->get_one("SELECT * FROM {$table} WHERE catid={$catid}");
update_category($CATEGORY[$catid]);
}
$NUM > 200 ? $do->cache() : $do->repair();
dmsg('更新成功', $forward);
break;
case 'letters':
$update = false;
foreach ($CATEGORY as $k => $v) {
if (strlen($v['letter']) != 1) {
$letter = $do->get_letter($v['catname'], false);
if ($letter) {
$update = true;
$letter = substr($letter, 0, 1);
public function split_authority($id_authority)
{
$query = "select * from authorities_sources where num_authority = " . $id_authority . " and authority_type= '" . $this->notice->type . "' and num_origin_authority = " . $this->num_origin;
$result = mysql_query($query);
if (mysql_num_rows($result)) {
$infos = mysql_fetch_object($result);
}
$data = addslashes_array($this->notice->specifics_data);
switch ($this->notice->type) {
case "author":
$authority = new auteur(0);
break;
case "uniform_title":
$authority = new titre_uniforme(0);
break;
case "collection":
$authority = new collection(0);
break;
case "subcollection":
$authority = new subcollection(0);
break;
case "category":
//si on split une catégorie, on le fait dans la même branche...
$query = "select num_parent from noeuds where id_noeud = " . $id_authority;
$result = mysql_query($query);
if (mysql_num_rows($result)) {
$num_parent = mysql_result($result, 0, 0);
} else {
$num_parent = $this->get_parent_category();
}
$authority = new category(0);
break;
default:
// on fait rien...
break;
}
if ($authority && !$authority->import_denied) {
if ($this->notice->type == "category") {
$result = $authority->update($data, $this->id_thesaurus, $num_parent, $this->notice->common_data['lang']);
} else {
$result = $authority->update($data, true);
}
if ($result) {
$this->splitted = true;
$this->authority_id = $authority->id;
if ($infos->id_authority_source) {
$query = "update authorities_sources set \n\t\t\t\t\t\tnum_authority_source = " . $this->authority_id . ",\n\t\t\t\t\t\tauthority_favorite = 1,\n\t\t\t\t\t\tupdate_date = now() \n\t\t\t\t\twhere id_authority_source = " . $infos->id_authority_source;
mysql_query($query);
//on doit aussi gérer la séparation dans les notices
$query = "select * from notices_authorities_sources where num_authority_source = " . $infos->id_authority_source;
$result = mysql_query($query);
if (mysql_num_rows($result)) {
while ($row = mysql_fetch_object($result)) {
switch ($this->notice->type) {
case "author":
$query = "update responsability set responsability_author = " . $this->authority_id . " where responsability_author = " . $info->num_authority . " and responsability_notice = " . $row->num_notice;
break;
case "uniform_title":
$query = "update notices_titres_uniformes set ntu_num_tu = " . $this->authority_id . " where ntu_num_tu = " . $info->num_authority . " and ntu_num_notice = " . $row->num_notice;
break;
case "collection":
$query = "update notices set coll_id = " . $this->authority_id . ", subcoll_id = 0 where notice_id = " . $row->num_notice;
break;
case "subcollection":
$query = "update notices set subcoll_id = " . $this->authority_id . " where notice_id = " . $row->num_notice;
break;
case "category":
$query = "update notices_categories set num_noeud = " . $this->authority_id . " where notcateg_notice = " . $row->num_notice;
break;
default:
$query = "";
}
if ($query != "") {
mysql_query($query);
}
}
return true;
}
} else {
$query = "insert into authorities_sources set \n\t\t\t\t\t\tnum_authority = " . $this->authority_id . ",\n\t\t\t\t\t\tauthority_number = '" . $this->notice->common_data['authority_number'] . "',\t\n\t\t\t\t\t\tauthority_type = '" . $this->notice->type . "',\n\t\t\t\t\t\tnum_origin_authority = " . $this->num_origin . ",\n\t\t\t\t\t\tauthority_favorite = 1,\n\t\t\t\t\t\timport_date = now(),\n\t\t\t\t\t\tupdate_date = now()";
return mysql_query($query);
}
}
}
return false;
}
private function update_category($data)
{
if ($this->user['SiteRank'] >= 4) {
if (isset($data['cat'])) {
$category = category::get($data['cat']);
if ($category != null && $data['name'] != '' && $data['name'] != ' ') {
$result = category::update($data);
//Build event details to log
// $logEventID = '132';
// $logDetails = 'Forum post id:'.$post_id.' in thread id:'.$thread.' for category id:'.$category.' deleted!';
// $logEventAuthor = $this->user['Username'];
//Write to admin log.
// $this->eventLog($logEventID, $logDetails, $logEventAuthor);
json::resp(array('success' => true));
} else {
self::errorJSON('Error updating category!');
}
}
}
}
if (!defined("EXPONENT")) {
exit("");
}
$cat = null;
if (isset($_POST['id'])) {
$cat = $db->selectObject("category", "id=" . intval($_POST['id']));
}
if ($cat) {
$loc = unserialize($cat->location_data);
} else {
$loc->mod = $_POST['orig_module'];
// Only need to update the module.
$cat->rank = $db->max('category', 'rank', 'location_data', "location_data='" . serialize($loc) . "'");
if ($cat->rank === null) {
$cat->rank = 0;
} else {
$cat->rank++;
}
}
if (exponent_permissions_check('manage_categories', $loc)) {
$cat = category::update($_POST, $cat);
$cat->location_data = serialize($loc);
if (isset($cat->id)) {
$db->updateObject($cat, "category");
} else {
$db->insertObject($cat, "category");
}
exponent_flow_redirect();
} else {
echo SITE_403_HTML;
}
<?php
include 'categoryclass.php';
$categ = new category();
if (isset($_POST['save'])) {
if (!empty(trim($_POST['catname']))) {
$cat_id = $_POST['cat_id'];
$categ->name = $_POST['catname'];
$categ->update($cat_id);
header("location:addcategory.php");
} else {
header("location:addcategory.php");
}
}
