Start of GET_VALUES hb_sess_ids - Where:sess_id|number|=|741505760 RETURN:sess_siteid|sess_userid|sess_useraccesslevel|sess_superuser|sess_userfname|sess_userlname|sess_useremail|sess_siteadminid|sess_siteadminemail|sess_siteadminfname|sess_siteadminlname|sess_tempval|sess_logintype
Get Values Query: SELECT * FROM hb_sess_ids WHERE sess_id=741505760 order by sess_siteid
Get Values : sess_siteid|sess_userid|sess_useraccesslevel|sess_superuser|sess_userfname|sess_userlname|sess_useremail|sess_siteadminid|sess_siteadminemail|sess_siteadminfname|sess_siteadminlname|sess_tempval|sess_logintype
Conn str : Driver={SQL Server};Server=199.103.61.50\SQLEXPRESS,1433;Database=infinite_db;Uid=yourviews;Pwd=zxrt8D#IzgSd5n0j;
Returned Values:Empty
End sub get_sess_values: siteid
Start Sub get_page_info:
Passed :
Start Sub check_for_page_layout:
Passed :
Passed : /prop/prop_request.asp
Start of GET_VALUES HB_pageLayouts - Where:pagename|string|=|/prop/prop_request.asp RETURN:pg_left_col_width|pg_left_col_bgcolor|pg_ctr_col_width|pg_ctr_col_bgcolor|pg_right_col_width|pg_right_col_bgcolor|pg_form_defaults|pg_parameters
Get Values Query: SELECT * FROM HB_pageLayouts WHERE pagename='/prop/prop_request.asp' order by pg_left_col_width
Get Values : pg_left_col_width|pg_left_col_bgcolor|pg_ctr_col_width|pg_ctr_col_bgcolor|pg_right_col_width|pg_right_col_bgcolor|pg_form_defaults|pg_parameters
Conn str : Driver={SQL Server};Server=199.103.61.50\SQLEXPRESS,1433;Database=infinite_db;Uid=yourviews;Pwd=zxrt8D#IzgSd5n0j;
Returned Values:Empty
From DB - pg_left_col_width : /
pg_ctr_col_width : /
pg_right_col_width : /
form_defaults :
parameters:
End Sub check_for_page_layout
Final numbers - pg_left_col_width : 10/
pg_ctr_col_width : 600/
pg_right_col_width : 10/
form_defaults :
parameters:
End Sub check_for_page_layout
End sub get_page_info:
PROGRAM ENTRY
httpcookie:
REALcookie:
Siteid:1
superuser: mgmt:
logintype:
user fname: lname:
accesslevel:
site_css_url:
Siteid:1 Master siteid: session.sessionid:741505760 sess_id:741505760
CONNECTIONS EXIT
Start of GET_VALUES hbq_prop_details - Where:propertyid|number|=|461 RETURN:propertyname|longdescription|turnoverday|maxpeople|smoking|allowpets|propertyid|sid|pid|propertyid
Get Values Query: SELECT * FROM hbq_prop_details WHERE propertyid=461 order by propertyname
Get Values : propertyname|longdescription|turnoverday|maxpeople|smoking|allowpets|propertyid|sid|pid|propertyid
Conn str : Driver={SQL Server};Server=199.103.61.50\SQLEXPRESS,1433;Database=infinite_db;Uid=yourviews;Pwd=zxrt8D#IzgSd5n0j;
Returned Values:Blind Bay Hideaway|Enjoy the unique experience of living in the past with this secluded waterfront property. The house sleeps 8 with a king bed bedroom on the main floor looking out at the lake with a full bath. Cozy living room upstairs and full kitchen with all appliances including dishwasher. Downstairs is divided into 2 separate rooms with 2 double beds in one room and 2 bunk sets in the other room. Washer and dryer in the basement and TV with internet connection. The deck on the back side of the house still has great lake views and will comfortably fit everyone. In the front is a great firepit area where everyone can sit around and enjoy the summer evenings with a great view of the lake This property shares a great dock with neighboring cabin and has 2 boat moorings. It's off the main road so you will enjoy peace and quiet and great views of Copper Island.|7|8|False|True|461|1|674|461|
End sub get_property_info: sid:1 pid:674
Start Sub get_st_price:
Passed :
Start of GET_VALUES hb_prop_prices - Where:propertyid|number|=|461|datepricefrom|date|<=|6/15/2023|datepriceto|date|>=|6/15/2023 RETURN:priceid|propertyid|datepricefrom|datepriceto|weeklyprice|mondayprice|tuesdayprice|wednesdayprice|thursdayprice|fridayprice|saturdayprice|sundayprice|weeklyallowed|dailyallowed|threedayallowed|fourdayallowed|weeklyDDamt|dailyDDamt|weeklymgmtpercent|weeklymgmtamount|dailymgmtpercent|dailymgmtamount|othercharges|otherchargesdesc
Get Values Query: SELECT * FROM hb_prop_prices WHERE propertyid=461 AND datepricefrom<='6/15/2023' AND datepriceto>='6/15/2023' order by priceid
Get Values : priceid|propertyid|datepricefrom|datepriceto|weeklyprice|mondayprice|tuesdayprice|wednesdayprice|thursdayprice|fridayprice|saturdayprice|sundayprice|weeklyallowed|dailyallowed|threedayallowed|fourdayallowed|weeklyDDamt|dailyDDamt|weeklymgmtpercent|weeklymgmtamount|dailymgmtpercent|dailymgmtamount|othercharges|otherchargesdesc
Conn str : Driver={SQL Server};Server=199.103.61.50\SQLEXPRESS,1433;Database=infinite_db;Uid=yourviews;Pwd=zxrt8D#IzgSd5n0j;
Returned Values:8952|461|6/11/2023|7/1/2023|1750|275|275|275|275|275|275|275|True|False|True|True|1000|200|35|0|32|100|100|Cleaning charge for 3 & 4 day bookings|
Weekly allowed:True daily: 3:True 4:True
First night:5 Thursday
Start Sub build_prop_specials:
Passed propid: 461 mon: yr valid_st_date: flags:st_date=6/15/2023
Start of GET_COUNT Function
Table:hb_prop_specials
where_str: special_propertyid = 461 and special_active =1 and special_startdate <='6/15/2023' and special_enddate >='6/15/2023'
Getcount.Source: SELECT COUNT(*) as rsCount FROM hb_prop_specials Where special_propertyid = 461 and special_active =1 and special_startdate <='6/15/2023' and special_enddate >='6/15/2023'
END Get_count:0 -
End sub build_prop_specials: this_date_special_amt:0 this_date_special_percent:0
End Sub get_st_price1750 1st night:275 valid_prices:True
Start Sub pic_array_build:
Passed :
where: propertyid = 461 AND display = 1 ORDER BY displayorder ASC
Start of rs1 open Function
rs1.Source: SELECT * FROM hb_prop_pics WHERE propertyid = 461 AND display = 1 ORDER BY displayorder ASC
rsOpen Query: SELECT * FROM hb_prop_pics WHERE propertyid = 461 AND display = 1 ORDER BY displayorder ASC
End of rs1open Function :valid_records=True
pic str:461_0.jpg||
pic str:461_0.jpg||461_1.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||461_9.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||461_9.jpg||461_10.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||461_9.jpg||461_10.jpg||461_11.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||461_9.jpg||461_10.jpg||461_11.jpg||461_12.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||461_9.jpg||461_10.jpg||461_11.jpg||461_12.jpg||461_13.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||461_9.jpg||461_10.jpg||461_11.jpg||461_12.jpg||461_13.jpg||461_14.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||461_9.jpg||461_10.jpg||461_11.jpg||461_12.jpg||461_13.jpg||461_14.jpg||461_15.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||461_9.jpg||461_10.jpg||461_11.jpg||461_12.jpg||461_13.jpg||461_14.jpg||461_15.jpg||461_21.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||461_9.jpg||461_10.jpg||461_11.jpg||461_12.jpg||461_13.jpg||461_14.jpg||461_15.jpg||461_21.jpg||461_31.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||461_9.jpg||461_10.jpg||461_11.jpg||461_12.jpg||461_13.jpg||461_14.jpg||461_15.jpg||461_21.jpg||461_31.jpg||461_36.jpg||
pic str:461_0.jpg||461_1.jpg||461_2.jpg||461_3.jpg||461_4.jpg||461_5.jpg||461_6.jpg||461_17.jpg||461_7.jpg||461_8.jpg||461_9.jpg||461_10.jpg||461_11.jpg||461_12.jpg||461_13.jpg||461_14.jpg||461_15.jpg||461_21.jpg||461_31.jpg||461_36.jpg||461_37.jpg||
End sub pic_array_build: 41
|