Start of GET_VALUES hb_sess_ids - Where:sess_id|number|=|753522744 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=753522744 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:753522744 sess_id:753522744
CONNECTIONS EXIT
Start of GET_VALUES hbq_prop_details - Where:propertyid|number|=|11 RETURN:propertyname|longdescription|turnoverday|maxpeople|smoking|allowpets|propertyid|sid|pid|propertyid
Get Values Query: SELECT * FROM hbq_prop_details WHERE propertyid=11 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:St. Ives Beachfront Home|This bright and spacious 3 bedroom, two bath room home boasts two massive decks with spectacular views. The upper family room is open to the kitchen. The house includes a second family room downstairs which enters onto the lower covered deck. The downstairs family room has its own flat screen TV and DVD player and is a wonderful room for the kids. This home is located at the end of a cul-de-sac ensuring privacy. This cottage is equipped with: a BBQ, floating aluminium dock, two flat screen TV’s and DVD players, patio tables and chairs, and a washer and drier.|1|8|False|False|11|5|396|11|
End sub get_property_info: sid:5 pid:396
Start Sub get_st_price:
Passed :
Start of GET_VALUES hb_prop_prices - Where:propertyid|number|=|11|datepricefrom|date|<=|6/26/2023|datepriceto|date|>=|6/26/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=11 AND datepricefrom<='6/26/2023' AND datepriceto>='6/26/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:8990|11|6/26/2023|8/13/2023|2695|400|400|400|400|400|400|400|True|False|False|False|1000|200|30|0|30|100|0||
Weekly allowed:True daily: 3: 4:
First night:2 Monday
Start Sub build_prop_specials:
Passed propid: 11 mon: yr valid_st_date: flags:st_date=6/26/2023
Start of GET_COUNT Function
Table:hb_prop_specials
where_str: special_propertyid = 11 and special_active =1 and special_startdate <='6/26/2023' and special_enddate >='6/26/2023'
Getcount.Source: SELECT COUNT(*) as rsCount FROM hb_prop_specials Where special_propertyid = 11 and special_active =1 and special_startdate <='6/26/2023' and special_enddate >='6/26/2023'
END Get_count:0 -
End sub build_prop_specials: this_date_special_amt:0 this_date_special_percent:0
End Sub get_st_price2695 1st night:400 valid_prices:True
Start Sub pic_array_build:
Passed :
where: propertyid = 11 AND display = 1 ORDER BY displayorder ASC
Start of rs1 open Function
rs1.Source: SELECT * FROM hb_prop_pics WHERE propertyid = 11 AND display = 1 ORDER BY displayorder ASC
rsOpen Query: SELECT * FROM hb_prop_pics WHERE propertyid = 11 AND display = 1 ORDER BY displayorder ASC
End of rs1open Function :valid_records=True
pic str:11_front of house.jpg||
pic str:11_front of house.jpg||11_0-6.jpg||
pic str:11_front of house.jpg||11_0-6.jpg||11_IMG_4900.jpg||
pic str:11_front of house.jpg||11_0-6.jpg||11_IMG_4900.jpg||11_0-3jpg.jpg||
pic str:11_front of house.jpg||11_0-6.jpg||11_IMG_4900.jpg||11_0-3jpg.jpg||11_0-X9.jpg||
pic str:11_front of house.jpg||11_0-6.jpg||11_IMG_4900.jpg||11_0-3jpg.jpg||11_0-X9.jpg||11_IMG_4926.jpg||
pic str:11_front of house.jpg||11_0-6.jpg||11_IMG_4900.jpg||11_0-3jpg.jpg||11_0-X9.jpg||11_IMG_4926.jpg||11_IMG_4929.jpg||
pic str:11_front of house.jpg||11_0-6.jpg||11_IMG_4900.jpg||11_0-3jpg.jpg||11_0-X9.jpg||11_IMG_4926.jpg||11_IMG_4929.jpg||11_IMG_5601.jpg||
pic str:11_front of house.jpg||11_0-6.jpg||11_IMG_4900.jpg||11_0-3jpg.jpg||11_0-X9.jpg||11_IMG_4926.jpg||11_IMG_4929.jpg||11_IMG_5601.jpg||11_IMG_4935.jpg||
pic str:11_front of house.jpg||11_0-6.jpg||11_IMG_4900.jpg||11_0-3jpg.jpg||11_0-X9.jpg||11_IMG_4926.jpg||11_IMG_4929.jpg||11_IMG_5601.jpg||11_IMG_4935.jpg||11_0-5_2.jpg||
pic str:11_front of house.jpg||11_0-6.jpg||11_IMG_4900.jpg||11_0-3jpg.jpg||11_0-X9.jpg||11_IMG_4926.jpg||11_IMG_4929.jpg||11_IMG_5601.jpg||11_IMG_4935.jpg||11_0-5_2.jpg||11_2.jpg||
pic str:11_front of house.jpg||11_0-6.jpg||11_IMG_4900.jpg||11_0-3jpg.jpg||11_0-X9.jpg||11_IMG_4926.jpg||11_IMG_4929.jpg||11_IMG_5601.jpg||11_IMG_4935.jpg||11_0-5_2.jpg||11_2.jpg||11_1200_IMG_4056.jpg||
End sub pic_array_build: 23
|