[Mod] Category order / Kategorien ordnen

[ascanio]

Code: [Select]


DB Error: Bad SQL Query: 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, cat_image FROM girls_categories ORDER BY c.cat_order
Unknown table 'c' in order clause

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/ascanio/domains/girlsandgirls.net/public_html/includes/db_mysql.php:188) in /home/ascanio/domains/girlsandgirls.net/public_html/includes/sessions.php on line 84

Warning: Cannot modify header information - headers already sent by (output started at /home/ascanio/domains/girlsandgirls.net/public_html/includes/db_mysql.php:188) in /home/ascanio/domains/girlsandgirls.net/public_html/encuestas.php on line 19



[V@no]

no it doesnt work with 1.7.1 u need change in lang/<yourlang>/admin.php

Code: [Select]

$cat_order_array = array(
'c.cat_order' => 'Manuell',
'c.cat_name ASC' => 'Name Aufsteigend',
'c.cat_name DESC' => 'Name Absteigend'
); to this:

Code: [Select]

$cat_order_array = array(
'cat_order' => 'Manuell',
'cat_name ASC' => 'Name Aufsteigend',
'cat_name DESC' => 'Name Absteigend'
);

[ascanio]

no it doesnt work with 1.7.1 u need change in lang/<yourlang>/admin.php

Code: [Select]

$cat_order_array = array(
'c.cat_order' => 'Manuell',
'c.cat_name ASC' => 'Name Aufsteigend',
'c.cat_name DESC' => 'Name Absteigend'
); to this:

Code: [Select]

$cat_order_array = array(
'cat_order' => 'Manuell',
'cat_name ASC' => 'Name Aufsteigend',
'cat_name DESC' => 'Name Absteigend'
);

if doesnot work for 1.7.1 why i have to change that? if i change that will work?

[V@no]

if doesnot work for 1.7.1 why i have to change that? if i change that will work?

please, dont be so dificult.

[michi-w.]

Installer Link geht nicht.

Hat den jemand für mich?

Gruß
michi-w.

[V@no]

it sais in my sig:

My site is down, please use a mirror site to download MODs: #2 or #3 or #4 or #5

[jamstave]

Hi.. I have installed categories sort order for v 1.7.1 I got this error message why I'm getting this error message.

DB Error: Bad SQL Query: SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images FROM 4images_categories c LEFT JOIN 4images_images i ON (i.cat_id = c.cat_id AND i.image_date >= AND i.image_active = 1) GROUP BY c.cat_id ORDER BY cat_name ASC
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.image_active = 1) GROUP BY c.cat_id O

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/qapypayk/public_html/newgallery/includes/db_mysql.php:188) in /home/qapypayk/public_html/newgallery/includes/sessions.php on line 84

Jamestave.

[V@no]

u probably replaced/deleted the line that starts with $new_cutoff
put it back.

[mag]

hi,

ich würde gern die kategorien so ordnen:

A
B
C
D
E
F

usw.

Kann mir da einer weiterhelfen?

[michi-w.]

Im ACP unter Einstellungen

Kategorie Einstellungen
"Wieviele Zellen soll die Tabelle der Kategorien haben" auf 1 stellen.

Und bau diesen Bugfix ein: http://www.4homepages.de/forum/index.php?topic=6677.0

Gruß
michi-w.
 

[Guerillia]

Ich würde gernde nicht nach ABC / ZYX sortieren, sondern nach neuerster / ältester Kategorie zuerst..

[Nova]

Could someone change it so that it works for 1.7.1?

[V@no]

Could someone change it so that it works for 1.7.1?

it works just fine if u read only 1.5 pages of the replys.

[DaMIKE]

Could someone change it so that it works for 1.7.1?

it works just fine if u read only 1.5 pages of the replys.

nope

SQL for 1.7.1 has to be

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

instead of

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

[JensF]

Hi,

meine Kategoerien werden auf der Hauptseite zur Zeit so angezeigt


a - d - g
b - e - h
c - f - i


Ich möchte aber das sie so angezeigt werden

a - b - c
d - e - f
g - h - i


Was muss ich tun damit das so klappt???

Gibt es die Möglichkeit das so zu sortieren??? Irgendwie bekomm eich das nicht hin...