[MOD] Category order / Kategorien ordnen 1.7.4 - 1.7.6

[bildergallery]

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

Code: [Select]

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

Code: [Select]

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

Code: [Select]

/*-- Setting-Group 3 --*/
ersetze

Code: [Select]

$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

Code: [Select]

  show_setting_row("num_subcats");
ersetze

Code: [Select]

  show_setting_row("num_subcats");
  show_setting_row("cat_order", "show_cat_order_select");
suche

Code: [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>";
}
ersetze

Code: [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>";
}

admin/categories.php
suche 3mal

Code: [Select]

ORDER BY cat_order, cat_name ASC";
ersetze durch

Code: [Select]

ORDER BY ".$config['cat_order']."";

SQL importieren

Code: [Select]

INSERT INTO `4images_settings` ( `setting_name` , `setting_value` )
VALUES (
'cat_order', 'cat_name ASC'
);

[nobby]

Das ist es doch mal wert es Einzubauen.

Danke Ivan 

nobby

[rinaldos]

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

Code: [Select]

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

Code: [Select]

          ORDER BY ".$config['cat_order']."";

Dann funktionierte auch der andere MOD wieder

Tolle Arbeit.

Gruß
Ingo

[musicsurfer]

Wie mache ich denn das mit dem SQL importieren ?

[sribhavan143]

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

[V@no]

Can you help me

Don't worry, the new database entry was previously added and ready to use.

[cch]

Hi

Does this work with 1.7.7?

Thanks

[Jan-Lukas]

testen, und das Ergebnis hier posten

Danke

[kai]

this mod is integrated in 1.7.7

... but without changing sql

[surferboy]

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

[V@no]

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.

[surferboy]

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

[Jockl]

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

[Rembrandt]

....
An was kann das liegen?
...

dieser mod ist in der 1.7.7 - 9 schon inkludiert.

mfg Andi

[Jockl]

Und wie kann ich ihn dann "ausbauen", damit ich mir nicht jedes Mal die Datenbank zerstöre, wenn ich die Einstellungs-Seite aufrufe?