Start of GET_VALUES hb_sess_ids - Where:sess_id|number|=|740571555 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=740571555 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:740571555 sess_id:740571555
CONNECTIONS EXIT
Start of GET_VALUES hbq_prop_details - Where:propertyid|number|=|45 RETURN:propertyname|longdescription|turnoverday|maxpeople|smoking|allowpets|propertyid|sid|pid|propertyid
Get Values Query: SELECT * FROM hbq_prop_details WHERE propertyid=45 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:Eagle Bay Lakeside Cottage|This small but cute 2 bedroom cottage looks right out at the lake and shares 900 ft of lakefront with a 3 bdrm house. A few steps will take you down to your beach and dock where you can sit and relax. It will sleep 5 in two bedrooms and the living space provides kitchen, TV with satellite. Slide included with the property.|7|5|False|True|45|5|408|45|
End sub get_property_info: sid:5 pid:408
Start Sub get_st_price:
Passed :
Start of GET_VALUES hb_prop_prices - Where:propertyid|number|=|45|datepricefrom|date|<=|8/21/2022|datepriceto|date|>=|8/21/2022 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=45 AND datepricefrom<='8/21/2022' AND datepriceto>='8/21/2022' 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:8903|45|6/26/2022|8/27/2022|1395|200|200|200|200|200|200|200|True|True|False|False|500|100|30|0|30|100|0||
Weekly allowed:True daily:True 3: 4:
First night:1 Sunday
Start Sub build_prop_specials:
Passed propid: 45 mon: yr valid_st_date: flags:st_date=8/21/2022
Start of GET_COUNT Function
Table:hb_prop_specials
where_str: special_propertyid = 45 and special_active =1 and special_startdate <='8/21/2022' and special_enddate >='8/21/2022'
Getcount.Source: SELECT COUNT(*) as rsCount FROM hb_prop_specials Where special_propertyid = 45 and special_active =1 and special_startdate <='8/21/2022' and special_enddate >='8/21/2022'
END Get_count:0 -
End sub build_prop_specials: this_date_special_amt:0 this_date_special_percent:0
End Sub get_st_price1395 1st night:200 valid_prices:True
Start Sub pic_array_build:
Passed :
where: propertyid = 45 AND display = 1 ORDER BY displayorder ASC
Start of rs1 open Function
rs1.Source: SELECT * FROM hb_prop_pics WHERE propertyid = 45 AND display = 1 ORDER BY displayorder ASC
rsOpen Query: SELECT * FROM hb_prop_pics WHERE propertyid = 45 AND display = 1 ORDER BY displayorder ASC
End of rs1open Function :valid_records=True
pic str:45_0.jpg||
pic str:45_0.jpg||45_3.jpg||
pic str:45_0.jpg||45_3.jpg||45_4.jpg||
pic str:45_0.jpg||45_3.jpg||45_4.jpg||45_5.jpg||
pic str:45_0.jpg||45_3.jpg||45_4.jpg||45_5.jpg||45_6.jpg||
pic str:45_0.jpg||45_3.jpg||45_4.jpg||45_5.jpg||45_6.jpg||45_7.jpg||
pic str:45_0.jpg||45_3.jpg||45_4.jpg||45_5.jpg||45_6.jpg||45_7.jpg||45_8.jpg||
pic str:45_0.jpg||45_3.jpg||45_4.jpg||45_5.jpg||45_6.jpg||45_7.jpg||45_8.jpg||45_9.jpg||
pic str:45_0.jpg||45_3.jpg||45_4.jpg||45_5.jpg||45_6.jpg||45_7.jpg||45_8.jpg||45_9.jpg||45_10.jpg||
End sub pic_array_build: 17
|