Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: solution for CPG with large # of albums and categories?  (Read 4878 times)

0 Members and 1 Guest are viewing this topic.

DefenceTalk.com

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 230
    • http://www.defencetalk.com
solution for CPG with large # of albums and categories?
« on: November 21, 2004, 09:50:42 pm »

One of the user's at Defencetalk.com suggested this idea. I don't know if it would be valid or has been requested before but here goes.

I will use my site as an example to keep things in perspective.

Currently, I have this layout:

>MAIN CATOGRY (country / topic based)
>>Sub-category (airforce)
>>>sub-sub-category (fighters)
>>>>cooresponding albums (F-16)

Now, DT has close to 700 albums, some 300 categories. By the time when all is set and done, we will have close to 1000 albums. Thats when trouble comes when someone tries to upload the pictures. Scrolling through that amount of albums isn't fun.

Here is the idea that user suggested when uploading pics....

When you go on the upload page, it should give you atleast different drop down boxes:

Drop down box 1: >MAIN CATOGRY (country / topic based)
Drop down box 2: >>Sub-category (airforce)
Drop Down box 3: >>>sub-sub-category (fighters)
Drop Down box 4: >>>>cooresponding albums (F-16)

When you would select drop down 1, it should populate drop down 2 with sub-categories, when you select a category in drop down 2, it should populate drop down 3 with sub-sub-category, when you select the sub-sub-cat, it should populate the last drop down(#4) with albums that are in there.

I don't know if it makes sense. If not, I do have a html page which demonstrates this idea....  :-\\

Thanks to one of the team members at CPG by suggesting a mod for sorting albums and categories very nicely (all 700 of them :D ) - which DT is currently using to cover come the above issue. Thanks nibbler!

« Last Edit: November 22, 2004, 09:39:57 am by GauGau »
Logged
(http://www.defencetalk.com/pictures/signature_cpg.php)

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: solution for CPG with large # of albums and categories?
« Reply #1 on: November 22, 2004, 09:36:55 am »

absolutely makes sense for large galleries like yours. Preferably the subsequent dropdown lists should be populated using some dhtml magic (instad of having to submit each choice to the server to generate another dropdown list for the nested category). Any code submissions / contributions would be very welcome.

Joachim
Logged

paulaerison

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 38
    • Galaxy Warzone Interactive
Re: solution for CPG with large # of albums and categories?
« Reply #2 on: November 22, 2004, 04:40:46 pm »

DHTML magik sounds wonderfull, but the sheer AMOUNT of java code and the resulting transmitted data would be stupendus...

I HAVE heard of a way (using java) to have a callback to the page that only updates the java code without requiring the page be reloaded.

Use eBay and theier category selection engine for sellers as an example of how to do this.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: solution for CPG with large # of albums and categories?
« Reply #3 on: November 22, 2004, 04:45:36 pm »

You probably know and just mis-typed, but I'm just trying to avoid/stop the popular myth, so let me add a little side note: "Java" and "JavaScript" are not the same thing. In fact, they have nothing in common except the name that often leads to misunderstandings. When refering to DHTML, you usually mean "JavaScript".

I agree though that the list might get very long - maybe a cached list of categories and albums (made up using php to populate an xml file) might be a solution.

Joachim
« Last Edit: December 01, 2004, 10:39:17 am by GauGau »
Logged

paulaerison

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 38
    • Galaxy Warzone Interactive
Re: solution for CPG with large # of albums and categories?
« Reply #4 on: November 22, 2004, 05:39:17 pm »

not mistyped, just misquoted. I was actually referring to a java serverlet, and javascript/applet.

Might not even need the serverlet, but the applet would alow the script to "query" special html/xml pages on the webserver to populate its data dynamicaly.
Logged

srirangan

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 1
  • Led Zeppelin -- Nirvana
    • Srirangan.net
Re: solution for CPG with large # of albums and categories?
« Reply #5 on: November 24, 2004, 07:32:25 am »

Yes, DHTML does indeed refer to the combined use of Javascript and CSS. And for DefenceTalk.com a DHTML Tree Menu can be a viable solution. On the user end it does indeed seem ideal, but we do need to take into account the nature of DefenceTalk.com. DT is a regularly updated high bandwidth consuming popular website. For 90% of related searches on Google, a link from DT appear in the first 10 if not first 5 search results.

For such a highly active website, the Tree Menu may indeed be in DHTML but it needs to be dynamically generated from the server side. If someone can just post the database schema of the gallery categories and album's table, I'ld come up with some PHP code snipplets for the DHTML menu.
Logged

Nibbler

  • Guest
Re: solution for CPG with large # of albums and categories?
« Reply #6 on: November 24, 2004, 12:32:10 pm »

The schema is in the package, sql/schema.sql, and of course in the CVS.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.