$list["owner"] = $_SESSION["logindetails"]["id"];
}
$admins = $GLOBALS["admin_auth"]->listAdmins();
if (sizeof($admins) > 1) {
print '<div class="label"><label for="owner">' . $GLOBALS['I18N']->get('Owner') . '</label></div><div class="field"><select name="owner">';
foreach ($admins as $adminid => $adminname) {
printf(' <option value="%d" %s>%s</option>', $adminid, $adminid == $list["owner"] ? 'selected="selected"' : '', $adminname);
}
print '</select></div>';
} else {
print '<input type="hidden" name="owner" value="' . $_SESSION["logindetails"]["id"] . '" />';
}
} else {
print '<input type="hidden" name="owner" value="' . $_SESSION["logindetails"]["id"] . '" />';
}
$aListCategories = listCategories();
if (sizeof($aListCategories)) {
print '<div class="label"><label for="category">' . $GLOBALS['I18N']->get('Category') . '</label></div>';
print '<div class="field"><select name="category">';
print '<option value="">-- ' . $GLOBALS['I18N']->get('choose category') . '</option>';
foreach ($aListCategories as $category) {
$category = trim($category);
printf('<option value="%s" %s>%s</option>', $category, $category == $list['category'] ? 'selected="selected"' : '', $category);
}
print '</select></div>';
}
### allow plugins to add rows
foreach ($GLOBALS['plugins'] as $plugin) {
print $plugin->displayEditList($list);
}
?>
<h3><?php
echo $email;
?>
</h3>
<br/>
</div>
</div>
<br/>
<br/>
<br/>
<br/>
<br/>
<br/>
<?php
listCategories($Categories, $SessionPerson->role());
?>
<div class="container col-md-8">
<?php
$posts = $BlogPosts->getAllForUser($id, ITEMS_PER_PAGE, $offset);
$count = count($posts);
if ($count > 0) {
foreach ($posts as $b) {
$categoryName = $Categories->get($b["category"])["name"];
$ans = $b["correctAnswerId"] > 0;
$opened = $b["marked"] == 0;
if ($opened || $page->isAdmin($Role)) {
blogPostWithCategory($b["id"], $b["title"], $id, $firstName, $lastName, $b["date_posted"], $b["category"], $categoryName, $ans, $opened);
}
}
break;
case 512:
check($connection, "SELECT mail FROM users WHERE mail='{$textInput}'");
break;
case 513:
check($connection, "SELECT isActivated FROM users WHERE isActivated='\${$textInput}'");
break;
case 514:
check($connection, "SELECT isRetailer FROM users WHERE isRetailer='{$textInput}'");
break;
case 521:
check($connection, "SELECT isActivated FROM notice WHERE isActivated='{$textInput}'");
break;
case 531:
check($connection, "SELECT isActivated FROM rating WHERE isActivated='{$textInput}'");
break;
case 541:
check($connection, "SELECT title FROM categories WHERE title='{$textInput}'");
break;
case 550:
changePasswordBe($connection, $username, $password, $pwOld);
break;
case 560:
listCategories($connection, $textInput);
break;
}
mysqli_close($connection);
} else {
mysqli_close($connection);
echo "DB-Connection Failed";
}
$class = "add";
$text = get_lang('AddCategory');
$form->setDefaults(array('auth_course_child' => 'TRUE'));
$form->addButtonCreate($text);
}
$form->display();
} elseif (api_get_multiple_access_url() && api_get_current_access_url_id() != 1) {
// If multiple URLs and not main URL, prevent edition and inform user
Display::display_warning_message(get_lang('CourseCategoriesAreGlobal'));
}
} else {
// If multiple URLs and not main URL, prevent deletion and inform user
if ($action == 'delete' && api_get_multiple_access_url() && api_get_current_access_url_id() != 1) {
Display::display_warning_message(get_lang('CourseCategoriesAreGlobal'));
}
echo '<div class="actions">';
$link = null;
if (!empty($parentInfo)) {
$parentCode = $parentInfo['parent_id'];
echo Display::url(Display::return_icon('back.png', get_lang("Back"), '', ICON_SIZE_MEDIUM), api_get_path(WEB_CODE_PATH) . 'admin/course_category.php?category=' . $parentCode);
}
if (empty($parentInfo) || $parentInfo['auth_cat_child'] == 'TRUE') {
echo Display::url(Display::return_icon('new_folder.png', get_lang("AddACategory"), '', ICON_SIZE_MEDIUM), api_get_path(WEB_CODE_PATH) . 'admin/course_category.php?action=add&category=' . Security::remove_XSS($category));
}
echo '</div>';
if (!empty($parentInfo)) {
echo Display::page_subheader($parentInfo['name'] . ' (' . $parentInfo['code'] . ')');
}
echo listCategories($category);
}
Display::display_footer();
$done = Sql_Affected_Rows();
if ($done) {
$result = Sql_query('delete from ' . $tables['listuser'] . " where listid = {$delete}");
$result = Sql_query('delete from ' . $tables['listmessage'] . " where listid = {$delete}");
}
$actionresult .= '..' . $GLOBALS['I18N']->get('Done') . "<br /><hr /><br />\n";
$_SESSION['action_result'] = $actionresult;
Redirect('list');
return;
# print ActionResult($actionresult);
}
if (!empty($_POST['importcontent'])) {
include dirname(__FILE__) . '/importsimple.php';
}
$html = '';
$aConfiguredListCategories = listCategories();
$aListCategories = array();
$req = Sql_Query(sprintf('select distinct category from %s where category != "" %s ', $tables['list'], $subselect_and));
while ($row = Sql_Fetch_Row($req)) {
array_push($aListCategories, $row[0]);
}
array_push($aListCategories, s('Uncategorised'));
if (sizeof($aListCategories)) {
if (isset($_GET['tab']) && in_array($_GET['tab'], $aListCategories)) {
$current = $_GET['tab'];
} elseif (isset($_SESSION['last_list_category']) && in_array($_SESSION['last_list_category'], $aListCategories)) {
$current = $_SESSION['last_list_category'];
} else {
$current = '';
}
if (stripos($current, strtolower(s('Uncategorised'))) !== false) {
//display all the supplements this user is working on
$styleClubsApplied = getUserClubsApplied($_SESSION['user_id']);
echo "<ul>";
foreach($styleClubsApplied as $styleItem) {
$style_club_id = $styleItem[0];
$style_club_name = $styleItem[1];
echo "<li class=\"sidenav1\"><a href=\"app.php?club_id=$style_club_id&action=view\">$style_club_name</a></li>";
}
echo "</ul>";
} else if(substr($side_display[$i], 0, 4) == "base" && isset($_SESSION['user_id'])) {
//display the general application categories
include_once($basePath . "/include/apply_submit.php");
if(isApplicationStarted($_SESSION['user_id'], 0)) {
$styleCategoryList = listCategories();
echo "<ul>";
foreach($styleCategoryList as $styleItem) {
$style_cat_id = $styleItem[0];
$style_cat_name = $styleItem[1];
echo "<li class=\"sidenav1\"><a href=\"app.php?club_id=0&cat_id=$style_cat_id&action=view\">$style_cat_name</a></li>";
}
echo "</ul>";
}
} else if(substr($side_display[$i], 0, 17) == "root_cat.php?cat=") {
$nav_cat = urldecode(substr($side_display[$i], 17));
}
if(isset($nav_cat)) {
echo "<ul>";
$breadcrumbs->addElement($mv['name'], makeURL($mod, array('categoryid' => $categoryid, 'movieid' => $movieid)));
$smarty->assign('movie', $mv);
$smarty->assign('path', $template_dir . "/movie.tpl");
if ($login->currentUser() !== false) {
$smarty->assign('loggedin', true);
if (isset($_POST['add'])) {
$comments->add($mod . '-movie', $login->currentUserID(), $_POST['comment'], $movieid);
}
}
$smarty->assign('comments', $comments->get($mod . '-movie', $movieid));
} else {
$notify->add($lang->get('media'), $lang->get('access_denied'));
}
$showcategories = false;
}
if ($showcategories == true) {
$list = listCategories($categoryid);
$smarty->assign('list', $list);
$smarty->assign('hide_submedia', $config->get('media', 'hide-submedia'));
$smarty->assign('downloads', listDownloads($categoryid));
$img = listPictures($categoryid);
$smarty->assign('pictures', $img);
$smarty->assign('movies', listMovies($categoryid));
@($category['folder'] = $category['uniqid']);
$smarty->assign('category', $category);
$smarty->assign('path', $template_dir . "/list.tpl");
}
} else {
$notify->add($lang->get('media'), $lang->get('access_denied'));
}
}
</div>
<!-- Move Modal -->
<div class="modal hide" id="moveModal">
<form action="index.php?action=moveContent&categoryId=<?php
echo $_GET['categoryId'];
?>
" method="post" id="moveContent" name="moveContent">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">X</button>
<h3>Move Content</h3>
</div>
<div class="modal-body" id="move_modal_body">
<p>Select the location where you wish to move the content from the dropdwon below... </p>
<select id="moveId" name="moveId">
<option value="0">Top</option>
<?php
echo listCategories(0, 1);
?>
</select>
</div>
<div class="modal-footer">
<a href="#" class="btn" data-dismiss="modal">Close</a>
<button class="btn btn-primary" type="submit" name="saveChanges">Save Changes</button>
</div>
</form>
</div>
</div><!--/span-->
</div><!--/row-->
<!-- needed for page sorting -->
<div id="info"></div>
}*/
//echo "<p>".$name."</p>";
//echo "<p>q : ".$q."</p>";
//@$q = explode('/', $q);
//echo "<h1>q[0] : ".$q[0]."</h1>";
//echo "<p>Some stuff and q is : ".$q."</p>";
@session_start();
switch ($q) {
//case 'test': test(); break;
case 'addCategory':
addCategory();
break;
//send a post to the EditCategories.php
//send a post to the EditCategories.php
case 'listCategories':
listCategories($r);
break;
case 'getCategoryList':
getCategoryList($r);
break;
case 'changeCategory':
changeCategory($q[1]);
break;
case 'removeCategory':
removeCategory($r);
break;
case 'getCategory':
getCategory(intval($r), $s);
break;
case 'getProduct':
getProduct(intval($r), $s);
function listCategories($parent_id, $level)
{
global $connection, $list_categories_defined, $classB_divider, $classC_divider, $product_list, $where_producer_pending, $where_confirmed, $where_auth_type, $where_unlisted_producer, $where_zero_inventory, $where_order_by;
$list_categories_defined = true;
$query = '
SELECT *
FROM
' . TABLE_CATEGORY . '
WHERE
parent_id = ' . $parent_id . '
ORDER BY
category_name;';
$sql = @mysql_query($query, $connection) or die(debug_print("ERROR: 579302 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__));
if (mysql_affected_rows($connection) > 0) {
//There are more categories (or subcategories) to look at
if ($level <= $_GET['depth']) {
$list_markup .= '<ul class="list-markup' . $level . '">';
}
$total = 0;
$total_new = 0;
while ($row = mysql_fetch_array($sql)) {
$category_id = $row['category_id'];
$category_name = $row['category_name'];
$category_desc = $row['category_desc'];
$parent_id = $row['parent_id'];
$return_value = listCategories($category_id, $level + 1);
$subtotal = $return_value[0];
$subtotal_new = $return_value[1];
$sublist_markup = $return_value[2];
$total = $total + $subtotal;
$total_new = $total_new + $subtotal_new;
if ($level <= $_GET['depth']) {
//Prepare output formatting
if ($total > 1) {
$plural = 's';
} else {
$plural = '';
}
$item_count_markup = $subtotal . ' item' . $plural;
if ($subtotal_new > 0) {
$item_new_count_markup = '(' . $subtotal_new . ' new)';
} else {
$item_new_count_markup = "";
}
//$list_markup .= '<li class="cat'.$level.'"><a href="'.$_SERVER['SCRIPT_NAME'].'?category_id='.$category_id.'">'.$category_name."</a>$item_count_markup $item_new_count_markup</li>\n";
//Only display if there are items in the category
if ($subtotal > 0) {
$list_markup .= '<li>
<a href="category_list2.php?category_id=' . $category_id . '&offset=' . $level . '">' . $category_name . '</a>' . $classB_divider . '<span class="levelY">
<a href="product_list.php?type=full&category_id=' . $category_id . '">' . $item_count_markup . '</a>
<a href="product_list.php?type=new&category_id=' . $category_id . '">' . $item_new_count_markup . "</a>\n </span>\n";
$list_markup .= $sublist_markup . "</li>\n";
}
}
}
if ($level <= $_GET['depth']) {
$list_markup .= "</ul>\n";
}
} else {
//There are no more "categories", so call the subcategories and see how many items are in each
$query2 = '
SELECT
' . TABLE_SUBCATEGORY . '.*,
' . NEW_TABLE_PRODUCTS . '.subcategory_id,
' . NEW_TABLE_PRODUCTS . '.listing_auth_type,
COUNT(DISTINCT(' . NEW_TABLE_PRODUCTS . '.product_id)) AS qty_of_items,
SUM(IF(DATEDIFF(NOW(), ' . NEW_TABLE_PRODUCTS . '.created) < ' . DAYS_CONSIDERED_NEW . ', 1, 0)) AS qty_of_new_items
FROM
' . TABLE_SUBCATEGORY . '
LEFT JOIN
' . NEW_TABLE_PRODUCTS . ' USING(subcategory_id)
LEFT JOIN
' . TABLE_PRODUCER . ' USING(producer_id)
LEFT JOIN ' . TABLE_INVENTORY . ' ON ' . NEW_TABLE_PRODUCTS . '.inventory_id = ' . TABLE_INVENTORY . '.inventory_id
WHERE
' . TABLE_SUBCATEGORY . '.category_id = "' . $parent_id . '"' . $where_producer_pending . $where_auth_type . $where_unlisted_producer . $where_confirmed . $where_zero_inventory . '
GROUP BY
' . NEW_TABLE_PRODUCTS . '.subcategory_id
ORDER BY
subcategory_name';
$sql2 = @mysql_query($query2, $connection) or die(debug_print("ERROR: 905656 ", array($query2, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__));
if ($level <= $_GET['depth']) {
$list_markup .= '<ul class="list-markup' . $level . '">';
}
while ($row2 = mysql_fetch_array($sql2)) {
$subcategory_id = $row2['subcategory_id'];
$subcategory_name = $row2['subcategory_name'];
$subtotal = $row2['qty_of_items'];
$subtotal_new = $row2['qty_of_new_items'];
$total = $total + $subtotal;
$total_new = $total_new + $subtotal_new;
if ($level <= $_GET['depth']) {
//Prepare output formatting
if ($total > 1) {
$plural = 's';
} else {
$plural = '';
}
$item_count_markup = $subtotal . ' item' . $plural;
if ($subtotal_new > 0) {
$item_new_count_markup = '(' . $subtotal_new . ' new)';
} else {
$item_new_count_markup = "";
}
$list_markup .= '<li>
<a href="product_list.php?type=full&subcat_id=' . $subcategory_id . '">' . $subcategory_name . '</a>' . $classC_divider . '<span class="levelZ">
<a href="product_list.php?type=full&subcat_id=' . $subcategory_id . '">' . $item_count_markup . '</a>
<a href="product_list.php?type=new&subcat_id=' . $subcategory_id . '">' . $item_new_count_markup . "</a>\n </span></li>\n";
}
}
if ($level <= $_GET['depth']) {
$list_markup .= "</ul>\n";
}
}
return array($total, $total_new, $list_markup);
}
case "saveCategory":
if ($mode == $LANG_DLM['save'] && SEC_checkToken()) {
$display = $dlcat->saveCategory();
}
if ($mode == $LANG_DLM['delete'] && SEC_checkToken()) {
$display = $dlcat->deleteCategory($cid);
}
break;
case "listCategories":
$DLM_CSRF_TOKEN = SEC_createToken();
$display .= showMessage();
$display .= listCategories();
$display = DLM_createHTMLDocument($display, array('pagetitle' => $LANG_DLM['manager']));
break;
case "move":
DLM_moveCategory();
$DLM_CSRF_TOKEN = SEC_createToken();
$display .= showMessage();
$display .= listCategories();
$display = DLM_createHTMLDocument($display, array('pagetitle' => $LANG_DLM['manager']));
break;
case "listDownloads":
default:
$DLM_CSRF_TOKEN = SEC_createToken();
$display .= DLM_updatePlugin();
$display .= showMessage();
$display .= listDownloads();
$display = DLM_createHTMLDocument($display, array('pagetitle' => $LANG_DLM['manager']));
break;
}
COM_output($display);
login();
break;
case 'logout':
logout();
break;
case 'newArticle':
newArticle();
break;
case 'editArticle':
editArticle();
break;
case 'deleteArticle':
deleteArticle();
break;
case 'listCategories':
listCategories();
break;
case 'newCategory':
newCategory();
break;
case 'editCategory':
editCategory();
break;
case 'deleteCategory':
deleteCategory();
break;
case 'newSortiment':
newSortiment();
break;
case 'editSortiment':
editSortiment();
function _editBookmark($post)
{
$retval = true;
require_once './include/spCategory.inc.php';
require_once './include/spBookmark.inc.php';
if ($post) {
$this->_ajaxResult = editBookmark($this->_db, $this->_action);
} else {
listCategories($this->_db);
if ($this->_action !== ACT_BMARK_ADD) {
getBookmark($this->_db, $GLOBALS[ARG_BMARK_ID]);
}
$this->_theme->render('dlgBmEdit.tpl');
}
}
<?php
include "../include/common.php";
include "../config.php";
include "../include/db_connect.php";
include "../include/session.php";
include "../include/apply_gen.php";
include "../include/apply_submit.php";
if (isset($_SESSION['user_id'])) {
if (isApplicationStarted($_SESSION['user_id'], 0)) {
$categoryList = listCategories();
get_page_advanced("base", "apply", array("categories" => $categoryList));
} else {
if (isset($_REQUEST['action']) && $_REQUEST['action'] == "start") {
$result = startApplication($_SESSION['user_id'], 0);
if ($result == 0) {
get_page_advanced("message", "apply", array("title" => "General application started", "message" => "You have started the general application. Please <a href=\"base.php\">click here</a> to continue.", "redirect" => "base.php"));
} else {
get_page_advanced("message", "apply", array("title" => "Error", "message" => "There was an error while starting your general application. Please <a href=\"base.php\">click here</a> to continue."));
}
} else {
get_page_advanced("base_notstarted", "apply");
}
}
} else {
get_page_advanced("message", "apply", array("title" => "Not Logged In", "message" => "You cannot access the application because you are not logged in. Please <a href=\"../login.php\">login first</a>."));
}
function listCategories($parent_id, $level = 0)
{
$query = "SELECT id, title FROM " . DB_PREFIX . "content WHERE categoryId = " . $parent_id . " AND type = 0 ORDER BY sort ASC";
$res = mysql_query($query) or die($query);
if (mysql_num_rows($res) == 0) {
return;
}
while (list($id, $title) = mysql_fetch_row($res)) {
if ($level == 0) {
$add = '';
} else {
$add = str_repeat(" ", $level);
}
echo '<option value="' . $id . '">' . $add . $title . '</option>';
listCategories($id, $level + 1);
}
/*try {
$pdo = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USERNAME, DB_PASSWORD);
$pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$st = $pdo->prepare("SELECT id, title FROM " . DB_PREFIX . "content WHERE categoryId = :categoryId AND type = 0 ORDER BY sort ASC");
$st->bindValue( ":categoryId", $parent_id, PDO::PARAM_INT );
$st->execute();
$pdo = null;
} catch(PDOException $e) {
echo "ERROR: " . $e->getMessage();
}
while (list($id, $title) = $st->fetchAll()) {
print_r($id[0]['id']);
echo '|';
print_r($title[0]['title']);
if ($level == 0) {
$add = '';
} else {
$add = str_repeat(" " . $level, $level);
$level = ($level+1);
}
echo '<option value="' . $id['id'] . '">' . $add . $title['title'] . '</option>';
listCategories($id['id'], $level);
}*/
}
