4images Forum & Community
4images Modifications / Modifikationen => Mods & Plugins (Releases & Support) => Topic started by: bildergallery on February 22, 2008, 05:46:36 PM
-
Beschreibung:
Hallo zusammen, mit diesem [MOD] werden die Kategorien sortiert.
- Kategorien im Admin Control Panel
- Kategorien in den Templates
Features:
- Kategorien sortieren Manuell
- Kategorien sortieren absteigend
- Kategorien sortieren aufsteigend
global.php
suche
if (defined("GET_CACHES")) {
$sql = "SELECT cat_id, cat_name, cat_description, cat_parent_id, cat_hits, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment
FROM ".CATEGORIES_TABLE."
ORDER BY cat_order, cat_name ASC";
ersetze
if (defined("GET_CACHES")) {
$sql = "SELECT cat_id, cat_name, cat_description, cat_parent_id, cat_hits, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment
FROM ".CATEGORIES_TABLE."
ORDER BY ".$config['cat_order']."";
lang/deutsch/admin.php
suche
/*-- Setting-Group 3 --*/
ersetze
$setting['cat_order'] = "Kategorien sortieren<br /><span class=\"smalltext\">Manuell, Kategoriename aufsteigend oder absteigend</span>";
$cat_order_optionlist = array(
'cat_order, cat_name ASC' => 'Manuell',
'cat_name ASC' => 'Aufsteigend',
'cat_name DESC' => 'Absteigend'
);
/*-- Setting-Group 3 --*/
admin/settings.php
suche
show_setting_row("num_subcats");
ersetze
show_setting_row("num_subcats");
show_setting_row("cat_order", "show_cat_order_select");
suche
function show_image_order_select($setting_name, $setting_value) {
global $image_order_optionlist;
echo "<select name=\"setting_item[".$setting_name."]\">";
foreach ($image_order_optionlist as $key => $val) {
echo "<option value=\"$key\"";
if ($setting_value == $key) {
echo " selected=\"selected\"";
}
echo ">".$val."</option>";
}
echo "</select>";
}
ersetze
function show_cat_order_select($setting_name, $setting_value) {
global $cat_order_optionlist;
echo "<select name=\"setting_item[".$setting_name."]\">";
foreach ($cat_order_optionlist as $key => $val) {
echo "<option value=\"$key\"";
if ($setting_value == $key) {
echo " selected=\"selected\"";
}
echo ">".$val."</option>";
}
echo "</select>";
}
function show_image_order_select($setting_name, $setting_value) {
global $image_order_optionlist;
echo "<select name=\"setting_item[".$setting_name."]\">";
foreach ($image_order_optionlist as $key => $val) {
echo "<option value=\"$key\"";
if ($setting_value == $key) {
echo " selected=\"selected\"";
}
echo ">".$val."</option>";
}
echo "</select>";
}
admin/categories.php
suche 3mal
ORDER BY cat_order, cat_name ASC";
ersetze durch
ORDER BY ".$config['cat_order']."";
SQL importieren
INSERT INTO `4images_settings` ( `setting_name` , `setting_value` )
VALUES (
'cat_order', 'cat_name ASC'
);
-
Das ist es doch mal wert es Einzubauen.
Danke Ivan :thumbup:
nobby
-
Klappt wunderbar, aber nachdem ich mir den MOD eingebaut hatte, war der MOD CATEGORIE Image nicht mehr vorhanden :-( Also habe ich der Änderung der GLOGBAL.PHP nur anstelle von
if (defined("GET_CACHES")) {
$sql = "SELECT cat_id, cat_name, cat_description, cat_parent_id, cat_hits, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment
FROM ".CATEGORIES_TABLE."
ORDER BY ".$config['cat_order']."";
das geändert
ORDER BY ".$config['cat_order']."";
Dann funktionierte auch der andere MOD wieder :-)
Tolle Arbeit.
Gruß
Ingo
-
Wie mache ich denn das mit dem SQL importieren ?
-
Hello!!!
I have's Erreur :(
requête SQL:
INSERT INTO `4images_settings` ( `setting_name` , `setting_value` )
VALUES (
'cat_order', 'cat_name ASC'
)
MySQL a répondu:Documentation
#1062 - Duplicate entry 'cat_order' for key 1
Can you help me
bhavan
-
Can you help me
Don't worry, the new database entry was previously added and ready to use.
-
Hi
Does this work with 1.7.7?
Thanks
-
testen, und das Ergebnis hier posten
Danke
-
this mod is integrated in 1.7.7 ;)
... but without changing sql ;)
-
Hi -
Using v.1.7.7
Just started going through all 17 pages of the MODs and came across this one. Read the last two posts that says this function [MOD] is integrated into v1.7.7
Yes, that's true, I do have the categories sorted in the order I want from the ACP 'Edit Categories' link ... but ... on the home.html template, the categories still list in alphabetical order.
Any ideas how to solve that? I really want my categories to display in the order I have selected in the ACP.
Thanks,
Brian
-
Then it must be some other modifications you've added.. 4images uses the same block of code to sort the categories on home page and in a category.
-
Hi -
Thanks for the ideas. That made me consult my modification installation log. I changed the desc to the asc here:
3/16/2010 - installed the Tag Cloud MOD - topic=16812.0; pretty simple installation. had to add a bar for the 'New Images' on the search page; copied from the home.html;
also added a bar for the keywords and for the {lang_keyword} and {show_tag_clouds}; changed the settings in the includes/functions.php to the following:
in the mysql function, changed the last two lines:
ORDER BY i.word_text ASC <<<<<<<<<<<<<<<<<<<<<<----------------------------------------------------------
LIMIT 60"; <-- this is for # of keywords to display
changed the font min/max to following %'s: 325 & 100
changed the rgb colors to the following: 0, 175 for all three groupings.
Do you think the ASC code change is causing the problem? I mean, do you think it could cause the problem from the includes/functions.php file?
Thanks,
Brian
-
Hallo!
Ich habe diesen MOD in meiner 4images-Installation eingebaut und habe soeben auf Version 1.7.9 upgedatet. Sobald ich nun aber einmal die Einstellungsseite im Admin Panel aufruf, wird in der Tabelle 4images_settings ein Fehler erzeugt, der dazu führt, dass die gesamte Seite nicht mehr aufrufbar ist, da in der SQL Abfrage 2x ASC vorkommt.
An was kann das liegen?
Vielen Dank im Voraus!
Mfg,
Jockl
-
....
An was kann das liegen?
...
dieser mod ist in der 1.7.7 - 9 schon inkludiert.
mfg Andi
-
Und wie kann ich ihn dann "ausbauen", damit ich mir nicht jedes Mal die Datenbank zerstöre, wenn ich die Einstellungs-Seite aufrufe?
-
Baue das aus, was Du eingebaut hast, das solltest Du ja wissen.
Denn da es schon drin ist in der neuen Version, hast Du es jetzt doppelt drin.
-
Baue das aus, was Du eingebaut hast, das solltest Du ja wissen.
....
:mrgreen: ich war zu perplex auf die frage hin, um das zu schreiben..
-
Baue das aus, was Du eingebaut hast, das solltest Du ja wissen.
....
:mrgreen: ich war zu perplex auf die frage hin, um das zu schreiben..
Haha, wie lustig :roll:
Betrifft das dann auch den zusätzlichen Eintrag in der 4images_settings Tabelle?
-
das kannst du aus der DB löschen, der eintrag wird von der galerie automatisch vorgenommen.
entferne ganz einfach allles was mit diesen mod zu tun hat.
-
Hallo,
gerade eben den Mod eingebaut und sobald ich in die Einstellungen möchte, kommt folgender Fehler:
Fatal error: Cannot redeclare show_cat_order_select() (previously declared in /homepages/13/d555038670/htdocs/4images/admin/settings.php:53) in /homepages/13/d444038670/htdocs/4images/admin/settings.php on line 124
Was habe ich falsch gemacht?
Hier mal der PHP Code aus der settings.php
<?php
/**************************************************************************
* *
* 4images - A Web Based Image Gallery Management System *
* ---------------------------------------------------------------- *
* *
* File: settings.php *
* Copyright: (C) 2002-2012 Jan Sorgalla *
* Email: jan@4homepages.de *
* Web: http://www.4homepages.de *
* Scriptversion: 1.7.11 *
* *
* Never released without support from: Nicky (http://www.nicky.net) *
* *
**************************************************************************
* *
* Dieses Script ist KEINE Freeware. Bitte lesen Sie die Lizenz- *
* bedingungen (Lizenz.txt) für weitere Informationen. *
* --------------------------------------------------------------- *
* This script is NOT freeware! Please read the Copyright Notice *
* (Licence.txt) for further information. *
* *
*************************************************************************/
define('IN_CP', 1);
define('ROOT_PATH', './../');
require('admin_global.php');
if ( $action == "") {
$action = "modifysettings";
}
function show_template_dir_select($setting_name, $setting_value) {
echo "<select name=\"setting_item[".$setting_name."]\">";
$handle = opendir(ROOT_PATH.TEMPLATE_DIR);
while ($folder = @readdir($handle)) {
if (@is_dir(ROOT_PATH.TEMPLATE_DIR."/".$folder) && $folder != "." && $folder != "..") {
$folderlist[] = $folder;
}
}
sort($folderlist);
for($i = 0; $i < sizeof($folderlist); $i++) {
echo "<option value=\"".$folderlist[$i]."\"";
if ($setting_value == $folderlist[$i]) {
echo " selected=\"selected\"";
}
echo ">".$folderlist[$i]."</option>\n";
}
closedir($handle);
echo "</select>";
}
function show_cat_order_select($setting_name, $setting_value) {
global $cat_order_optionlist;
echo "<select name=\"setting_item[".$setting_name."]\">";
foreach ( $cat_order_optionlist as $k => $v ) {
echo "<option value=\"".$k."\"";
if ($setting_value == $k) {
echo " selected=\"selected\"";
}
echo ">".$v."</option>\n";
}
echo "</select>\n";
}
function show_cat_sort_select($setting_name, $setting_value) {
global $cat_sort_optionlist;
echo "<select name=\"setting_item[".$setting_name."]\">";
foreach ( $cat_sort_optionlist as $k => $v ) {
echo "<option value=\"".$k."\"";
if ($setting_value == $k) {
echo " selected=\"selected\"";
}
echo ">".$v."</option>\n";
}
echo "</select>\n";
}
function show_language_dir_select($setting_name, $setting_value) {
echo "<select name=\"setting_item[".$setting_name."]\">";
$handle = opendir(ROOT_PATH."lang");
while ($folder = @readdir($handle)) {
if (@is_dir(ROOT_PATH."lang/$folder") && $folder != "." && $folder != "..") {
$folderlist[] = $folder;
}
}
sort($folderlist);
for($i = 0; $i < sizeof($folderlist); $i++) {
echo "<option value=\"".$folderlist[$i]."\"";
if ($setting_value == $folderlist[$i]) {
echo " selected=\"selected\"";
}
echo ">".$folderlist[$i]."</option>\n";
}
closedir($handle);
echo "</select>\n";
}
function show_convert_tool_select($setting_name, $setting_value) {
global $convert_tool_optionlist;
echo "<select name=\"setting_item[".$setting_name."]\">";
foreach ($convert_tool_optionlist as $key => $val) {
echo "<option value=\"$key\"";
if ($setting_value == $key) {
echo " selected=\"selected\"";
}
echo ">".$val."</option>";
}
echo "</select>";
}
function show_cat_order_select($setting_name, $setting_value) {
global $cat_order_optionlist;
echo "<select name=\"setting_item[".$setting_name."]\">";
foreach ($cat_order_optionlist as $key => $val) {
echo "<option value=\"$key\"";
if ($setting_value == $key) {
echo " selected=\"selected\"";
}
echo ">".$val."</option>";
}
echo "</select>";
}
function show_image_order_select($setting_name, $setting_value) {
global $image_order_optionlist;
echo "<select name=\"setting_item[".$setting_name."]\">";
foreach ($image_order_optionlist as $key => $val) {
echo "<option value=\"$key\"";
if ($setting_value == $key) {
echo " selected=\"selected\"";
}
echo ">".$val."</option>";
}
echo "</select>";
}
function show_image_sort_select($setting_name, $setting_value) {
global $image_sort_optionlist;
echo "<select name=\"setting_item[".$setting_name."]\">";
foreach ($image_sort_optionlist as $key => $val) {
echo "<option value=\"$key\"";
if ($setting_value == $key) {
echo " selected=\"selected\"";
}
echo ">".$val."</option>";
}
echo "</select>";
}
function show_upload_mode_options($setting_name, $setting_value) {
global $upload_mode_optionlist;
foreach ($upload_mode_optionlist as $key => $val) {
echo "<input type=\"radio\" name=\"setting_item[".$setting_name."]\" value=\"$key\"";
if ($setting_value == $key) {
echo " checked=\"checked\"";
}
echo "> ".$val."<br />";
}
}
function show_auto_thumbnail_resize_type_options($setting_name, $setting_value) {
global $auto_thumbnail_resize_type_optionlist;
foreach ($auto_thumbnail_resize_type_optionlist as $key => $val) {
echo "<input type=\"radio\" name=\"setting_item[".$setting_name."]\" value=\"$key\"";
if ($setting_value == $key) {
echo " checked=\"checked\"";
}
echo "> ".$val."<br />";
}
}
function show_account_activation_options($setting_name, $setting_value) {
global $account_activation_optionlist;
foreach ($account_activation_optionlist as $key => $val) {
echo "<input type=\"radio\" name=\"setting_item[".$setting_name."]\" value=\"$key\"";
if ($setting_value == $key) {
echo " checked=\"checked\"";
}
echo "> ".$val."<br />";
}
}
function show_setting_row($setting_name, $value_option = "", $htmlspecialchars = 0) {
global $config, $setting;
$config_value = $config[$setting_name];
$config_value = ($htmlspecialchars) ? htmlspecialchars($config[$setting_name]) : $config[$setting_name];
$setting[$setting_name] = replace_url($setting[$setting_name]);
if ($value_option == "") {
show_input_row($setting[$setting_name], "setting_item[".$setting_name."]", $config_value);
}
elseif ($value_option == "textarea") {
show_textarea_row($setting[$setting_name], "setting_item[".$setting_name."]", $config_value, "", 6);
}
elseif ($value_option == "radio") {
show_radio_row($setting[$setting_name], "setting_item[".$setting_name."]", $config_value);
}
else {
echo "<tr class=\"".get_row_bg()."\">\n<td valign=\"top\"><p class=\"rowtitle\">".$setting[$setting_name]."</p></td>\n";
echo "<td><p>";
$value_option($setting_name, $config_value);
echo "</p></td>\n</tr>\n";
}
}
// end of functions
show_admin_header();
if ($action == "updatesettings") {
$setting_item = $HTTP_POST_VARS['setting_item'];
foreach ($setting_item as $key => $val) {
$val = trim($val);
$sql = "SELECT * FROM ".SETTINGS_TABLE." WHERE setting_name = '$key'";
$res = $site_db->get_numrows($site_db->query($sql));
if ( !$res > 0 ) {
$sql = "INSERT INTO ".SETTINGS_TABLE." (setting_value, setting_name)
VALUES ('$val', '$key');";
} else {
$sql = "UPDATE ".SETTINGS_TABLE."
SET setting_value = '$val'
WHERE setting_name = '$key'";
}
$res = $site_db->query($sql);
}
if ($HTTP_POST_VARS['setting_item']['language_dir'] != $config['language_dir']) {
include(ROOT_PATH.'lang/'.$HTTP_POST_VARS['setting_item']['language_dir'].'/admin.php');
?>
<script language="javascript">
<!--
top.head.location = '<?php echo $site_sess->url(ROOT_PATH."admin/index.php?action=head"); ?>';
top.nav.location = '<?php echo $site_sess->url(ROOT_PATH."admin/index.php?action=nav"); ?>';
top.main.location = '<?php echo $site_sess->url(ROOT_PATH."admin/settings.php?action=modifysettings&settings_msg=".urlencode($lang['save_settings_success'])); ?>';
// -->
</script>
<?php
printf("<b>%s</b><p>", $lang['save_settings_success']);
show_admin_footer();
}
else {
$msg = sprintf("<b>%s</b><p>", $lang['save_settings_success']);
$action = "modifysettings";
}
}
if ($action == "modifysettings") {
if (isset($HTTP_GET_VARS['settings_msg'])) {
printf("<b>%s</b><p>", trim($HTTP_GET_VARS['settings_msg']));
}
elseif (!empty($msg)) {
echo $msg;
}
$sql = "SELECT setting_name, setting_value
FROM ".SETTINGS_TABLE;
$result = $site_db->query($sql);
$config = array();
while ($row = $site_db->fetch_array($result)) {
$config[$row['setting_name']] = $row['setting_value'];
}
show_form_header("settings.php", "updatesettings");
show_table_header($lang['nav_general_settings'], 2);
echo "<tr class=\"tablerow\"><td colspan=\"2\">";
echo "<table border=\"0\" cellpadding=\"3\" cellspacing=\"1\"><tr valign=\"top\">\n";
$numgroups = sizeof($setting_group);
$percolumn = ceil($numgroups / 2);
$settingcounter = 0;
foreach ($setting_group as $key => $val) {
$settingcounter++;
echo "<td>";
show_text_link($val,"#setting_group_".$key);
echo "<br /></td>\n";
if ($settingcounter == 4) {
echo "</tr><tr>";
$settingcounter = 0;
}
}
echo "</tr></table>\n";
echo "</td></tr>";
show_table_separator($setting_group[1], 2, "setting_group_1");
show_setting_row("site_name", "", 1);
show_setting_row("site_email");
show_setting_row("use_smtp", "radio");
show_setting_row("smtp_host");
show_setting_row("smtp_username");
show_setting_row("smtp_password");
show_setting_row("template_dir", "show_template_dir_select");
show_setting_row("language_dir", "show_language_dir_select");
show_setting_row("date_format");
show_setting_row("time_format");
show_setting_row("convert_tool", "show_convert_tool_select");
show_setting_row("convert_tool_path");
show_setting_row("gz_compress", "radio");
show_setting_row("gz_compress_level");
show_table_separator($setting_group[2], 2, "setting_group_2");
show_setting_row("cat_order", "show_cat_order_select");
show_setting_row("cat_sort", "show_cat_sort_select");
show_setting_row("cat_cells");
show_setting_row("cat_table_width");
show_setting_row("cat_table_cellspacing");
show_setting_row("cat_table_cellpadding");
show_setting_row("num_subcats");
show_setting_row("cat_order", "show_cat_order_select");
show_table_separator($setting_group[3], 2, "setting_group_3");
show_setting_row("image_order", "show_image_order_select");
show_setting_row("image_sort", "show_image_sort_select");
show_setting_row("new_cutoff");
show_setting_row("image_border");
show_setting_row("image_cells");
show_setting_row("default_image_rows");
show_setting_row("custom_row_steps");
show_setting_row("image_table_width");
show_setting_row("image_table_cellspacing");
show_setting_row("image_table_cellpadding");
show_table_separator($setting_group[4], 2, "setting_group_4");
show_setting_row("upload_mode", "show_upload_mode_options");
show_setting_row("allowed_mediatypes");
show_setting_row("max_thumb_width");
show_setting_row("max_thumb_height");
show_setting_row("max_thumb_size");
show_setting_row("max_image_width");
show_setting_row("max_image_height");
show_setting_row("max_media_size");
show_setting_row("upload_notify", "radio");
show_setting_row("upload_emails");
show_setting_row("auto_thumbnail", "radio");
show_setting_row("auto_thumbnail_dimension");
show_setting_row("auto_thumbnail_resize_type", "show_auto_thumbnail_resize_type_options");
show_setting_row("auto_thumbnail_quality");
show_table_separator($setting_group[5], 2, "setting_group_5");
show_setting_row("badword_list", "textarea");
show_setting_row("badword_replace_char");
show_setting_row("wordwrap_comments");
show_setting_row("html_comments", "radio");
show_setting_row("bb_comments", "radio");
show_setting_row("bb_img_comments", "radio");
show_table_separator($setting_group[6], 2, "setting_group_6");
show_setting_row("category_separator", "", 1);
show_setting_row("paging_range");
show_table_separator($setting_group[7], 2, "setting_group_7");
show_setting_row("user_edit_image", "radio");
show_setting_row("user_delete_image", "radio");
show_setting_row("user_edit_comments", "radio");
show_setting_row("user_delete_comments", "radio");
show_setting_row("account_activation", "show_account_activation_options");
show_setting_row("activation_time");
show_setting_row("session_timeout");
show_setting_row("display_whosonline", "radio");
show_setting_row("highlight_admin", "radio");
show_form_footer($lang['save_changes'], "", 2);
}
show_admin_footer();
?>
-
Du hast die function show_cat_order_select() zweimal im Code in den besagten Zeilen.
Lösche die ältere function (also die, welche du nicht nachträglich eingefügt hast) komplett raus.
-
Oh oke. Danke
-
@marcusfuerth , falls es dir noch immer nicht aufgefallen ist, dieser Mod ist seit der Version 1.7.7 schon drinnen.
mfg Andi
-
Ist mir danach aufgefallen :roll:
-
sollte man mal im ersten Posting reinschreiben ;)
-
Naja steht ja mehr oder weniger im Thread Titel:
"[MOD] Category order / Kategorien ordnen 1.7.4 - 1.7.6 "