Forum Activity for @codelizard

Is there a way to download a FULL album?

Using Jamroom

Not a bad bike. I've got a Harley Road King Classic. Thats a big bike

FIND IN SET(id, column)

Jamroom Developers

yeah sounds cool. Ive used many systems with hooks (joomla, drupal, vbulletin as examples), so its nice to see them implemented here. The datastores sound cool, and I have like a bajillion questions on how its implemented and such, but I've really gotta step away from the pc and get some sleep.

Is there a way to download a FULL album?

Using Jamroom

Its 4:32am here, as well. I should be sleeping. Thanks for all of the info

Is there a way to download a FULL album?

Using Jamroom

Then I hope you dont mind a quick question. I didnt see this spelled out anywhere, so I'll just go ahead and ask here. Is the code for Jamroom and any purchased extension 100% readable? Meaning no compiled code?

FIND IN SET(id, column)

Jamroom Developers

Again, thanks for that link. I'll be honest, I didn't realize this data was coming from a datastore and not from a mysql database. That being the case, the find_in_set logic would do nothing but shortcut the 3-way like that @brian mentioned above. Would it even be worth it? Maybe just to save some typing and look cleaner, but it wouldn't save any processing...

Thanks for taking the opportunity to educate me, rather than a bad response. Ive seen too many projects where people flame first, and explain things later. Your candor is much appreciated.

Is there a way to download a FULL album?

Using Jamroom

Thanks for the input and the links. This software is definitely the best thing I found in regards to the functionality we need, but will need additions/changes to meet our precise needs. The ZIP thing is one thing that could/would help on our end as well so it could be something I might tackle.

Is there a way to download a FULL album?

Using Jamroom

I'm not even using Jamroom as of yet, evaluating it at the moment. Was just making a suggestion to the developer on how to do it without sacrificing memory or performance.

If I end up using Jamroom, this may be something I tackle, since I'll be learning the system anyways.

FIND IN SET(id, column)

Jamroom Developers

What you did will definitely work, but adding a FIND_IN_SET function would be way more efficient, database index-wise. Nate is right for wanting to use it.

It wouldnt take too much to add a new entry to your DB module called "searchset", that would let you take advantage of this. So something like this:

$_searchset = array();
$_searchset[] .= $id;
$_searchset[] .= "audio_applied_mixlics";

$_sc = array(
"searchset" => $_searchset,
"order_by" => array(
"_created" => "numerical_desc"
),
"pagebreak" => 6,
"page" => 1
);
$_rt = jrCore_db_search_items('xtSong', $_sc);

Your db function could then use an optimized find_in_set query.

Sorry, not trying to tell you how to write your software. Just trying to help out I'm thinking about purchasing your software for a project I am working on...

Is there a way to download a FULL album?

Using Jamroom

Think a little outside the box. Nothing says that the zip process needs to happen as part of the php session. Just write a record into a JOB table, with information on what needs to be done. Then, write a cron that runs every minute or so and looks for jobs to be done. It sees the zip job, runs the commands as a shell process, and updates the job table that the job is done. you can even have it email the user and tell them that thier album is ready to be downloaded. User comes, downloads their waiting album, job well done with no resource issues. you can even write a cron to clean up zipped files after being around for x amount of time...

As far as ZIP goes, its a simple install of zip on any linux system. From my experience, all shared hosts I have ever used have had either zip or gzip installed, among others...