Forum Activity for @ashiksh

JamBoy
@ashiksh
11/16/14 10:40:14PM
13 posts

could we search profils with media tags?


Jamroom Developers

can i pass profile_country="USA" along with search="audio_tags = POP"


I need to pass both module variables together here
JamBoy
@ashiksh
11/13/14 01:02:26AM
13 posts

could we search profils with media tags?


Jamroom Developers


{jrCore_list module="jrProfile" }

I need to get the profiles those have particular tag name. Is it possible?

I have added the tags for audio or video , may be "POP".


I need to get the profiles those have either audio tag or video tag as POP
updated by @ashiksh: 12/27/14 08:12:32PM
JamBoy
@ashiksh
11/01/14 03:23:58AM
13 posts

jrCore_db_search_items parameter issue


Jamroom Developers

'profile_latitude not_like ?%'

This is not working for what i need. I need to get all records that has no empty field.

ie: 'profile_latitude not equal to empty'

Waiting for a quick solution!
JamBoy
@ashiksh
10/30/14 07:48:11AM
13 posts

jrCore_db_search_items parameter issue


Jamroom Developers

I have user defined fields profile_latitude and profile_longitude in profile table

I need search the records those have profile_latitude and profile_longitude.

Query:

$_params = array(

'exclude_jrUser_keys' => true,
'exclude_jrProfile_keys' => true,
'pagebreak' => 100
);
$_params['search'][]= 'profile_latitude != ""';

$_rs = jrCore_db_search_items('jrProfile',$_params);

For some reason its returning error. How can i pass value is not equal to null(!='') in this search parameter.Here my latitude or longitude values may be -ve numbers too.

Thanks in advance!

updated by @ashiksh: 12/02/14 09:05:49AM
JamBoy
@ashiksh
10/23/14 02:26:28AM
13 posts

Could we write conditions in {jrCore_list} function?


Jamroom Developers


{if $item.type eq 'country'}
search2="profile_country = $country"
{elseif $item.type eq 'state'}
search2="profile_state = $state"
{/if}

{jrCore_list module="jrProfile" search1="profile_sub_category = $subcat" order_by=$order_by template="profile_row.tpl"}

Could i do something like this with "IF" condition
updated by @ashiksh: 11/26/14 04:39:16PM
JamBoy
@ashiksh
09/10/14 12:52:35PM
13 posts

send the user back to that location once logged in?


Jamroom Developers

How can i send the user back to that location once the login.


Is there any option in admin side to set it???
updated by @ashiksh: 10/23/14 02:23:52AM
JamBoy
@ashiksh
09/10/14 08:22:53AM
13 posts

How can i pass multiple parameter in module search?


Jamroom Developers

$profile_i = jrCore_db_table_name('jrProfile','item');
$profile_k = jrCore_db_table_name('jrProfile','item_key');

SELECT $profile_i ._item_id FROM profile_k k inner join $profile_i i ON i._item_id=k._item_id WHERE (k.key='profile_name' AND k.value='something')

Next i need to pass

(k.key='profile_url' AND k.value='something')


------------------

Is there any way to write it?
updated by @ashiksh: 09/10/14 08:23:56AM
JamBoy
@ashiksh
09/10/14 07:59:26AM
13 posts

How can i pass multiple parameter in module search?


Jamroom Developers

Sorry, I am asking you to write this in php , not in template
JamBoy
@ashiksh
09/10/14 07:20:49AM
13 posts

How can i pass multiple parameter in module search?


Jamroom Developers


As i am passing jrCore_list , i need to write a query with multiple parameters (example) profile_name="something" and profile_url="something".

Is there any solution?
updated by @ashiksh: 10/11/14 02:37:41AM
1