Forum Activity for @blindmime

jrCore_list search

Design and Skin Customization

You might go into how the jr5 search function in jrCore_list can accept mysql search parameters and go into detail with some examples of this. Make special note of any exceptions. Also explain how jrCore_list searches must be escaped to work within the double-quote because it's a little different than a php mysql statement, I think. Link to that page Brian referenced. That will give us a framework from which to explore what's possible.

jrCore_media_player on a Page

Using Jamroom

I think this appears to be working:


updated by @blindmime: 07/23/14 09:32:43PM

jrCore_list search

Design and Skin Customization

Michael, I do try things a number of ways, but in this case I wasn't sure on a few things, like how jamroom is intepreting some of the symbols or how jrCore_list might require symbols and patterns being escaped. I twould be nice to have this kind of thing clarified.

That link was helpful, Brian. It helped me solve the issue in a previous thread, I think. This


appears to generate a match for only "project-1" (1 being the item id) and not project-12 or project-112, etc.
updated by @blindmime: 07/23/14 09:34:17PM

jrCore_list search

Design and Skin Customization

Do all the symbols work and do I need to escape anything in any particular way?

Like does search="audio_credits REGEXP ^project-`$item._item_id`$" work?

(^ stands for beginning of line and $ stands for ending of line)

There's a list of symbols here: https://qualysguard.qualys.com/qwebhelp/fo_help/module_pc/policies/regular_expression_symbols.htm

jrCore_list search

Design and Skin Customization

Can I get a general guide on what is allowed in the search parameter for jrCore_list?

Is everything one can do in sql OK or are there limits?

Are all wildcards OK? Do I need to escape them a certain way?

Can I do something like: search="audio_credits REGEXP ^project-`$item._item_id`$"?
updated by @blindmime: 09/03/14 10:40:33AM

Arvixe

Jamroom Hosting

No worries, Michael. I know you were just trying to help. As always -- and it's much appreciated, believe me.

jrCore_media_player on a Page

Using Jamroom

It's the jrAudio module.

It seems like a common need would be search for something like "The Beatles" and not return both The Beatles and The Beatles Revue.

I'm probably wrong, but shouldn't search="audio_credits REGEXP ^project-`$item._item_id`$" work? I've tried escaping the $ in various ways. Maybe the jr syntax is doing something too?

Also, in my case, I can't really use an added field for this because a song could contain sources from multiple projects. The credit field is sometimes like, "Written by John Smith with sources from project-1 by Jane Doe, project-4 by Sam Smith, and project-24 by Don Juan." So I would have the same issue in that case. I'm using jrPage for artists to create Project Pages. the item_details template has a song player which automatically lists songs created with sources from the project based on the item_id which is the Project-id. A song might appear on multiple project pages if it uses sources from multiple projects.

I'm curious how jr4 worked in this regard. I've been doing this exact thing with jr4 for many years. Our site sort of revolves around listing songs that belong to certain numbered collaborative projects.

I've noticed the search in this forum and the documentation is sort of difficult to find things longer than a word, it seems. At least to me.
updated by @blindmime: 07/18/14 06:14:27AM

Arvixe

Jamroom Hosting

No worries, mate.

Arvixe

Jamroom Hosting

Don't get me wrong. I really appreciate all the help you guys go out of your way to give me. You're all great.

I don't mind Arvixe sharing it privately with the jamroom team in order to address their server issues. I just don't feel good about private email being made public.
updated by @blindmime: 07/16/14 07:19:25AM

Arvixe

Jamroom Hosting

I'm aware of the ones that are not server issues. I've been coding templates. Arvixe requested the log so I sent them the whole log, which does include many other entries, some of which, I'm guessing, are server related.

I sent these to ARVIXE PRIVATELY via email so they could troubleshoot the upload errors I've been getting. I did not post my server logs publicly in this forum.

Do you think it's a great idea to be posting my server logs unedited to a public forum without my permission?

I don't.

Please delete them immediately.
updated by @blindmime: 07/16/14 07:07:15AM