Name of Database Tables for users

alt=
duke
@musamensa
8 months ago
248 posts
Hello. Please I would like to know where to find the table that holds the user information, audio URL, and audio genre.

Thanks for your help
updated by @musamensa: 08 Jul 2022 01:14:06PM
michael
@michael
8 months ago
7,550 posts
The users are all in a datastore, same with the audio module. So the best way to get access to the data in the templates is via
{jrCore_list module="jrUser" .........}
and if you're accessing via module code then by using jrCore_db_search_items
 $_sp = array(
        'search'          => array(
            "user_email = {$_post['q']}"
        ),
        'return_keys'     => array('_user_id', '_profile_id', '_updated', 'user_name', 'user_first_name', 'user_last_name', 'user_image_time', 'user_image_extension'),
        'limit'           => 1
    );

    $_rt = jrCore_db_search_items('jrUser', $_sp);

A datastore is split over 2 tables the key and the item, so you'll find all the info at:
jr_jruser_item
jr_jruser_item_key

tables.

Tags