Thrills & Chills

SELECT `status`
FROM `mozo_benchmark` ?>

SELECT `event_id`, `event_title`, `event_label`, `min_start_date`, `max_start_date`, `start_date`, `end_date`, `start_time`, `end_time`, `is_multidate`, `event_description`, `venue_id`, `venue_name`, `venue_city`, `venue_state`, `venue_zip`, `venue_country`, `thumbnail`, `button_label`, `is_private`, `have_ticket`, `event_banner`, `featured_type`, `is_feature`, `is_closed`, `close_reason`, `location_type`, `event_status`, `org_id`, `seat_status`, `datetime_id`, `name`, `label`, `phone`, `email`, `logo`, `banner_video_type`, `side_video_type`, `video_link`, `banner_video_url`, `title`, `description`, `keyword`, `facebook`, `payment_account_use`, `loc_longitude`, `loc_latitude`
FROM `v_event_details_home`
WHERE `event_id` = '322431697527026'
GROUP BY `event_id` ?>

SELECT `faq_title`, `faq_description`
FROM `event_faq_table`
WHERE `event_id` = '322431697527026'
AND `status` = 1
ORDER BY `sequence` ?>

SELECT `paid_by_org_percentage`, `paid_by_org_flate`, `eventmozo_fee_percentage`, `eventmozo_fee_flate`, `who_wiil_pay`, `offline_payment`, `account_setup`, `old_events`, `vendor_percentage`, `vendor_flate`, `event_eventmozo_fee`, `event_eventmozo_fee_flate`
FROM `v_mozo_events_org_fees`
WHERE `event_id` = '322431697527026' ?>

SELECT `id`, `event_id`, `ip_address`, `timestamp`, `visited`
FROM `mozo_event_views`
WHERE `ip_address` = '104.23.197.35'
AND `event_id` = '322431697527026' ?>

SELECT mt.ticket_id AS ticket_id, mt.ticket_name AS ticket_name, mt.ticket_type AS ticket_type, mt.ticket_price AS ticket_price, mt.ticket_quantity AS ticket_quantity, mt.event_id AS event_id, mt.ticket_min_order AS ticket_min_order, mt.ticket_max_order AS ticket_max_order, mt.action AS action, mt.ticket_sale_start AS ticket_sale_start, mt.ticket_sale_end AS ticket_sale_end, mt.ticket_description AS ticket_description, mt.datetime_id AS datetime_id, mt.ticket_valid_start AS ticket_valid_start, mt.ticket_valid_end AS ticket_valid_end, mt.start_time AS start_time, mt.end_time AS end_time, mt.ticket_sequence AS ticket_sequence, mt.ticket_mandatory AS ticket_mandatory, mt.created_by AS created_by, mt.ticket_sale_type AS ticket_sale_type, mt.setting AS setting, mt.seat_color AS seat_color, sq.sold_quantity AS sold_quantity
FROM `mozo_tickets` AS `mt`
LEFT JOIN (SELECT `mto`.`ticket_id`, SUM(mto.ticket_quantity) AS sold_quantity
FROM `mozo_post_transaction` AS `pt`
INNER JOIN (SELECT * FROM mozo_ticket_order WHERE event_id = '322431697527026') AS mto ON `pt`.`orderid` = `mto`.`order_id`
WHERE `pt`.`event_id` = `mto`.`event_id`
AND `pt`.`tr_status` = 'succeeded'
GROUP BY `mto`.`ticket_id`) AS sq ON `sq`.`ticket_id` = `mt`.`ticket_id`
WHERE `mt`.`event_id` = '322431697527026'
AND (`mt`.`ticket_sale_type` = "0" or `mt`.`ticket_sale_type` = "1" or `mt`.`ticket_sale_type` = "2") ?>

SELECT `note_for_attendees`, `terms_condition`, `fullview_ads_sh`
FROM `mozo_event_extra`
WHERE `event_id` = '322431697527026' ?>

SELECT `link`
FROM `mozo_tickets_links`
WHERE `event_id` = '322431697527026' ?>

SELECT `ads_id`, `start_date`, `city`, `state`, `country`, `end_date`, `link`, `tag`, `visibility`, `status`, `banner_path`, `type`, `created_on`, `updated_on`, `fullview_type`, `event_id`, `pdf`, `fullview`, `region`
FROM `v_ads_visibility_on_page`
WHERE (status='3' OR status='1' OR status='2')
AND `fullview_type` = 0
AND `type` = 3
AND `start_date` <= '2026-04-07'
AND `end_date` >= '2026-04-07'
AND `region` = 'Bay Area'
GROUP BY `ads_id`
ORDER BY `status` ASC ?>

SELECT `id`, `org_id`, `event_id`, `name`, `email`, `phone`, `visible_status`, `created_on`, `updated_on`
FROM `mozo_contactpersoninfo`
WHERE `event_id` = '322431697527026' ?>

SELECT `ads_id`, `start_date`, `city`, `state`, `country`, `end_date`, `link`, `tag`, `visibility`, `status`, `banner_path`, `type`, `created_on`, `updated_on`, `fullview_type`, `event_id`, `pdf`, `fullview`, `region`, `event_ads_flag`
FROM `v_ads_visibility_on_page`
WHERE (event_id='322431697527026' OR event_id IS NULL)
AND (datetime_id='' OR datetime_id IS NULL)
AND (status='3' OR status='1' OR status='2')
AND `fullview_type` = 0
AND `type` = 2
AND `start_date` <= '2026-04-07'
AND `end_date` >= '2026-04-07'
AND `region` = 'Bay Area'
GROUP BY `ads_id`
ORDER BY `status` ASC ?>

Array
(
)

Array
(
    [database_group_name] => 
    [tables] => Array
        (
            [users] => users
            [groups] => groups
            [users_groups] => users_groups
            [login_attempts] => login_attempts
        )

    [join] => Array
        (
            [users] => user_id
            [groups] => group_id
        )

    [hash_method] => bcrypt
    [default_rounds] => 8
    [random_rounds] => 
    [min_rounds] => 5
    [max_rounds] => 9
    [salt_prefix] => $2y$
    [artist_banner_img] => ob4480b1577509578-44.jpg
    [artist_profile_img] => ap4480b1577509578-502.jpg
    [venue_banner_img] => vb6f13d1577509195-330.jpg
    [aov_default_img] => ob260d11577508231-206.jpg
    [aov_profile_default_img] => ol260d11577508231-368.jpg
    [site_title] => EventMozo
    [admin_email] => [email protected]
    [default_group] => members
    [admin_group] => admin
    [identity] => email
    [min_password_length] => 8
    [max_password_length] => 20
    [email_activation] => 1
    [manual_activation] => 
    [remember_users] => 1
    [user_expire] => 86500
    [user_extend_on_login] => 
    [track_login_attempts] => 1
    [track_login_ip_address] => 1
    [maximum_login_attempts] => 5
    [lockout_time] => 600
    [forgot_password_expiration] => 0
    [recheck_timer] => 0
    [remember_cookie_name] => remember_code
    [identity_cookie_name] => identity
    [use_ci_email] => 1
    [email_config] => Array
        (
            [mailtype] => html
        )

    [website_name] => EventMozo.com
    [webmaster_email] => [email protected]
    [from_email] => [email protected]
    [email_templates] => auth/email/
    [email_activate] => activate.tpl.php
    [email_forgot_password] => forgot_password.tpl.php
    [email_forgot_password_complete] => new_password.tpl.php
    [email_event_activate_complete] => event_activation.tpl.php
    [email_event_invitation_complete] => request_invitation_for_event.tpl.php
    [email_collaborator_invitation_complete] => collaborator_invitation.tpl.php
    [email_resend_order] => email_resend_order.tpl.php
    [email_ticket_booked_for_attendee] => attendee_email.tpl.php
    [email_for_organizer_event_verification] => verification_organizer_event.tpl.php
    [assign_org_user] => assign_org_user.tpl.php
    [assign_org_useralready] => assign_org_useralready.tpl.php
    [admin_event_notification] => admin_event_notification.tpl.php
    [contact_to_organizer] => contact_to_organizer.tpl.php
    [order_Email] => email_paid_ticket_mail.tpl.php
    [box_office_order_Email] => email_paid_ticket_mail_box.tpl.php
    [adminorg_Email] => organizeradmin_activation.tpl.php
    [salt_length] => 22
    [store_salt] => 
    [delimiters_source] => config
    [message_start_delimiter] => <p>
    [message_end_delimiter] => </p>
    [error_start_delimiter] => <p>
    [error_end_delimiter] => </p>
)

Array
(
    [use_ssl] => 1
    [verify_peer] => 1
    [access_key] => AKIA5SLQDSR6RIUONVXB
    [secret_key] => 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
    [bucket_name] => produsevents
    [folder_name] => sach/
    [s3_url] => https://produsevents.s3.amazonaws.com/
    [get_from_enviroment] => 
    [access_key_envname] => 
    [secret_key_envname] => 
)