Edit Venue : Pay2Play™

Request a membership for Rotorua Hockey

All Fields are Required *

First Name *

Last Name *

Create a User Name *

Create a Password *

Phone *

Email *

Address *

Date of Birth *

Student / Staff ID

Gender *

Photo ID

*Any applicant under the age of 18 must upload ID displaying their date of birth.

Membership Type

Message

Allow Emails

I have Read and Accept P2P Terms and Conditions

Read the Pay2Play Terms and Conditions here

(default) 3 queries took 2 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT COUNT(*) AS `count` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 8	1	1	0
2	SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`address`, `Venue`.`phone`, `Venue`.`cost`, `Venue`.`google_map_link`, `Venue`.`terms`, `Venue`.`honesty_box`, `Venue`.`notes`, `Venue`.`booking_notes`, `Venue`.`image`, `Venue`.`allow_multi_slot_bookings`, `Venue`.`sport_id`, `Venue`.`region_id`, `Venue`.`type`, `Venue`.`clubscol`, `Venue`.`lock_identifier`, `Venue`.`lock_key`, `Venue`.`skip_booking_system`, `Venue`.`email`, `Venue`.`system_notification_email`, `Venue`.`logo`, `Venue`.`display_order`, `Venue`.`email_membership_reminders`, `Venue`.`accept_membership_payments`, `Venue`.`auto_renewal_reminder`, `Venue`.`uses_time_codes`, `Venue`.`booking_requires_confirmation`, `Venue`.`booking_window_days`, `Venue`.`min_bookable_slots`, `Venue`.`max_bookable_slots`, `Venue`.`refresh_bookable_slots`, `Venue`.`cancellation_buffer`, `Venue`.`lock_offline_notification`, `Venue`.`opponent_price`, `Venue`.`terms_url`, `Venue`.`email_members_bookings`, `Venue`.`contact_tracing`, `Venue`.`last_updated`, `Venue`.`timezone`, `Venue`.`google_map_email_link`, `Venue`.`push_notification_type`, `Venue`.`ftp_user`, `Venue`.`ftp_password`, `Venue`.`ftp_address`, `Venue`.`helloclub_key`, `Venue`.`pxpay_user`, `Venue`.`pxpay_key`, `Venue`.`pxpay_email`, `Venue`.`pxpost_user`, `Venue`.`pxpost_pass`, `Venue`.`player_count` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 8 LIMIT 1	1	1	1
3	SELECT `MembershipCategory`.`id`, `MembershipCategory`.`venue_id`, `MembershipCategory`.`name`, `MembershipCategory`.`renewal_period_months`, `MembershipCategory`.`advanced_warning_days`, `MembershipCategory`.`cost`, `MembershipCategory`.`group_type`, `MembershipCategory`.`created`, `MembershipCategory`.`modified`, `MembershipCategory`.`recurring_billing`, `MembershipCategory`.`hide_from_public`, `MembershipCategory`.`casual_membership`, `MembershipCategory`.`renewal_requires_confirmation` FROM `pay2playtest`.`membership_categories` AS `MembershipCategory` WHERE `hide_from_public` = 0 AND `MembershipCategory`.`venue_id` = (8)	7	7	1

(default) 3 queries took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT COUNT(*) AS `count` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 8

SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`address`, `Venue`.`phone`, `Venue`.`cost`, `Venue`.`google_map_link`, `Venue`.`terms`, `Venue`.`honesty_box`, `Venue`.`notes`, `Venue`.`booking_notes`, `Venue`.`image`, `Venue`.`allow_multi_slot_bookings`, `Venue`.`sport_id`, `Venue`.`region_id`, `Venue`.`type`, `Venue`.`clubscol`, `Venue`.`lock_identifier`, `Venue`.`lock_key`, `Venue`.`skip_booking_system`, `Venue`.`email`, `Venue`.`system_notification_email`, `Venue`.`logo`, `Venue`.`display_order`, `Venue`.`email_membership_reminders`, `Venue`.`accept_membership_payments`, `Venue`.`auto_renewal_reminder`, `Venue`.`uses_time_codes`, `Venue`.`booking_requires_confirmation`, `Venue`.`booking_window_days`, `Venue`.`min_bookable_slots`, `Venue`.`max_bookable_slots`, `Venue`.`refresh_bookable_slots`, `Venue`.`cancellation_buffer`, `Venue`.`lock_offline_notification`, `Venue`.`opponent_price`, `Venue`.`terms_url`, `Venue`.`email_members_bookings`, `Venue`.`contact_tracing`, `Venue`.`last_updated`, `Venue`.`timezone`, `Venue`.`google_map_email_link`, `Venue`.`push_notification_type`, `Venue`.`ftp_user`, `Venue`.`ftp_password`, `Venue`.`ftp_address`, `Venue`.`helloclub_key`, `Venue`.`pxpay_user`, `Venue`.`pxpay_key`, `Venue`.`pxpay_email`, `Venue`.`pxpost_user`, `Venue`.`pxpost_pass`, `Venue`.`player_count` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 8 LIMIT 1

SELECT `MembershipCategory`.`id`, `MembershipCategory`.`venue_id`, `MembershipCategory`.`name`, `MembershipCategory`.`renewal_period_months`, `MembershipCategory`.`advanced_warning_days`, `MembershipCategory`.`cost`, `MembershipCategory`.`group_type`, `MembershipCategory`.`created`, `MembershipCategory`.`modified`, `MembershipCategory`.`recurring_billing`, `MembershipCategory`.`hide_from_public`, `MembershipCategory`.`casual_membership`, `MembershipCategory`.`renewal_requires_confirmation` FROM `pay2playtest`.`membership_categories` AS `MembershipCategory` WHERE `hide_from_public` = 0 AND `MembershipCategory`.`venue_id` = (8)