Browse Users

SELECT *
FROM phpfox_apps
WHERE is_active=1

DELETE FROM phpfox_log_session WHERE id_hash = 'c56fb43d525078d2aaf85f739d93f298'

INSERT INTO phpfox_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('66348811dc4aa8e3fbfc3ada7a6c8303', 'c56fb43d525078d2aaf85f739d93f298', '0', '1580010795', '', '0', '0', '0', '100.26.179.196', 'CCBot/2.0 (https://commoncrawl.org/faq/)')

SELECT sp.*
FROM phpfox_subscribe_purchase AS sp
     JOIN phpfox_user_field AS uf
ON(uf.subscribe_id=sp.purchase_id)

WHERE sp.user_id=0

SELECT group_id, phrase_var_name
FROM phpfox_custom_group
WHERE type_id = 'user_profile' AND is_active = 1

SELECT field_id, field_name, phrase_var_name, var_type
FROM phpfox_custom_field
WHERE group_id = 1 AND is_active = 1 AND is_search = 1

SELECT group_id, phrase_var_name
FROM phpfox_custom_group
WHERE type_id = 'user_profile' AND is_active = 1

SELECT field_id, field_name, phrase_var_name, var_type
FROM phpfox_custom_field
WHERE group_id = 1 AND is_active = 1 AND is_search = 1

SELECT *
FROM phpfox_custom_field
WHERE field_name = "about_me"

SELECT p.photo_id as cover_photo_exists, u.*, user_space.*, user_field.*, user_activity.*, ls.user_id AS is_online, ts.style_id AS designer_style_id, ts.folder AS designer_style_folder, t.folder AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id AS theme_parent_id, ug.prefix, ug.suffix, ug.icon_ext, ug.title, uf.user_id as is_featured
FROM phpfox_user AS u
     JOIN phpfox_user_group AS ug
ON(ug.user_group_id = u.user_group_id)
     JOIN phpfox_user_space AS user_space
ON(user_space.user_id = u.user_id)
     JOIN phpfox_user_field AS user_field
ON(user_field.user_id = u.user_id)
     JOIN phpfox_user_activity AS user_activity
ON(user_activity.user_id = u.user_id)
     LEFT JOIN phpfox_theme_style AS ts
ON(ts.style_id = user_field.designer_style_id AND ts.is_active = 1)
     LEFT JOIN phpfox_theme AS t
ON(t.theme_id = ts.theme_id)
     LEFT JOIN phpfox_user_featured AS uf
ON(uf.user_id = u.user_id)
     LEFT JOIN phpfox_log_session AS ls
ON(ls.user_id = u.user_id AND ls.im_hide = 0)
     LEFT JOIN phpfox_photo AS p
ON(p.photo_id = user_field.cover_photo)

WHERE u.user_id = 0

SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.birthday, u.country_iso, uf.ordering, usf.total_friend, usf.city_location
FROM phpfox_user AS u
     LEFT JOIN phpfox_user_field AS usf
ON(usf.user_id = u.user_id)
     JOIN phpfox_user_featured AS uf
ON(uf.user_id = u.user_id)

ORDER BY ordering DESC
LIMIT 100