Cartweaver Debugger

---

Queries

0:
SELECT DISTINCT P.product_ID
FROM tbl_products P
INNER JOIN tbl_skus S
ON P.product_ID = S.SKU_ProductID
LEFT JOIN tbl_prdtcat_rel PC
ON P.product_ID = PC.prdt_cat_rel_Product_ID
WHERE
P.product_OnWeb = 1
AND P.product_Archive = 0 AND S.SKU_Stock > 0 AND PC.prdt_cat_rel_Cat_ID = 6

product_ID
32
33
38
40
37
39
42
43
44
45

1: SELECT p.product_ID,

p.product_Name,

p.product_ShortDescription

FROM tbl_products p

WHERE p.product_ID IN (32,33,38,40,37,39,42,43,44,45)

ORDER BY p.product_Sort,

p.product_Name LIMIT 0, 10

product_ID	product_Name	product_ShortDescription
37	Youth Tribe/Feather Reg T	All people belong to a Tribe, whether it is a Community, Friends or Family. Who is your Tribe? "Tribe" with swooping unity feather screen-printed across the chest of a 100% cotton Heavyweight Youth T-Shirt.
33	Youth Girls Tribe Old-English Tank	All people belong to a Tribe, whether it is a Community, Friends or Family. "Tribe" in Old-English screen-printed across the chest of a pre-shrunk 100% cotton super soft 1X1 baby rib knit spaghetti strap Tank Top.
32	Youth Girls Tribe/Feather Tank	All people belong to a Tribe, whether it is a Community, Friends or Family. Whot is your Tribe? "Tribe" with swooping unity feather screen-printed across the chest of a pre-shrunk 100% cotton super soft 1X1 baby rib knit spaghetti strap Tank Top.
38	Toddler Future/Feather Reg T	Represent your youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton Heavyweight Youth T-Shirt.
42	Toddler Future/Feather Reg Tee	Represent your youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton Heavyweight Youth T-Shirt.
43	Toddler Future/Feather Reg Tee	Represent your youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton Heavyweight Youth T-Shirt.
40	Infant Lapped Shoulder Tee	Represent your Youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton rib infant lapped shoulder Tee.
44	Infant Lapped Shoulder Tee	Represent your Youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton rib infant lapped shoulder Tee.
45	Infant Lapped Shoulder Tee	Represent your Youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton rib infant lapped shoulder Tee.
39	Future Bib	Represent your youth with "Future" and a swooping unity feather screen-printed on a 75% cotton/ 25% polyester terry with 100% cotton jersey trim bib.

2: SELECT p.product_ID,

p.product_Name,

p.product_ShortDescription

FROM tbl_products p

WHERE p.product_ID IN (32,33,38,40,37,39,42,43,44,45)

ORDER BY p.product_Sort,

p.product_Name

product_ID	product_Name	product_ShortDescription
37	Youth Tribe/Feather Reg T	All people belong to a Tribe, whether it is a Community, Friends or Family. Who is your Tribe? "Tribe" with swooping unity feather screen-printed across the chest of a 100% cotton Heavyweight Youth T-Shirt.
33	Youth Girls Tribe Old-English Tank	All people belong to a Tribe, whether it is a Community, Friends or Family. "Tribe" in Old-English screen-printed across the chest of a pre-shrunk 100% cotton super soft 1X1 baby rib knit spaghetti strap Tank Top.
32	Youth Girls Tribe/Feather Tank	All people belong to a Tribe, whether it is a Community, Friends or Family. Whot is your Tribe? "Tribe" with swooping unity feather screen-printed across the chest of a pre-shrunk 100% cotton super soft 1X1 baby rib knit spaghetti strap Tank Top.
38	Toddler Future/Feather Reg T	Represent your youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton Heavyweight Youth T-Shirt.
42	Toddler Future/Feather Reg Tee	Represent your youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton Heavyweight Youth T-Shirt.
43	Toddler Future/Feather Reg Tee	Represent your youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton Heavyweight Youth T-Shirt.
40	Infant Lapped Shoulder Tee	Represent your Youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton rib infant lapped shoulder Tee.
44	Infant Lapped Shoulder Tee	Represent your Youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton rib infant lapped shoulder Tee.
45	Infant Lapped Shoulder Tee	Represent your Youth with "Future" and a swooping unity feather screen-printed across the chest of a 100% cotton rib infant lapped shoulder Tee.
39	Future Bib	Represent your youth with "Future" and a swooping unity feather screen-printed on a 75% cotton/ 25% polyester terry with 100% cotton jersey trim bib.

3: SELECT prdctImage_FileName FROM tbl_prdtimages where prdctImage_ProductID = 37 and not (prdctImage_FileName like '%-bac%' or prdctImage_FileName like '%-cu%' or prdctImage_FileName like '%-close%' ) order by prdctImage_ImgTypeID, prdctImage_FileName asc limit 0, 1

prdctImage_FileName
y-trftr-t-nvy.jpg

4: SELECT DISTINCT SKU_Price

FROM tbl_skus

WHERE SKU_ProductID = 37 AND SKU_ShowWeb = 1

ORDER BY SKU_Price ASC

SKU_Price
12

5: SELECT prdctImage_FileName FROM tbl_prdtimages where prdctImage_ProductID = 33 and not (prdctImage_FileName like '%-bac%' or prdctImage_FileName like '%-cu%' or prdctImage_FileName like '%-close%' ) order by prdctImage_ImgTypeID, prdctImage_FileName asc limit 0, 1

prdctImage_FileName
yg-troe-tk-p.jpg

6: SELECT DISTINCT SKU_Price

FROM tbl_skus

WHERE SKU_ProductID = 33 AND SKU_ShowWeb = 1

ORDER BY SKU_Price ASC

SKU_Price
14

7: SELECT prdctImage_FileName FROM tbl_prdtimages where prdctImage_ProductID = 32 and not (prdctImage_FileName like '%-bac%' or prdctImage_FileName like '%-cu%' or prdctImage_FileName like '%-close%' ) order by prdctImage_ImgTypeID, prdctImage_FileName asc limit 0, 1

prdctImage_FileName
yg-trftr-tk-r.jpg

8: SELECT DISTINCT SKU_Price

FROM tbl_skus

WHERE SKU_ProductID = 32 AND SKU_ShowWeb = 1

ORDER BY SKU_Price ASC

SKU_Price
14

9: SELECT prdctImage_FileName FROM tbl_prdtimages where prdctImage_ProductID = 38 and not (prdctImage_FileName like '%-bac%' or prdctImage_FileName like '%-cu%' or prdctImage_FileName like '%-close%' ) order by prdctImage_ImgTypeID, prdctImage_FileName asc limit 0, 1

prdctImage_FileName
t-futftr-t-lbbl.jpg

10: SELECT DISTINCT SKU_Price

FROM tbl_skus

WHERE SKU_ProductID = 38 AND SKU_ShowWeb = 1

ORDER BY SKU_Price ASC

SKU_Price
11

11: SELECT prdctImage_FileName FROM tbl_prdtimages where prdctImage_ProductID = 42 and not (prdctImage_FileName like '%-bac%' or prdctImage_FileName like '%-cu%' or prdctImage_FileName like '%-close%' ) order by prdctImage_ImgTypeID, prdctImage_FileName asc limit 0, 1

prdctImage_FileName
t-futftr-t-wtbl.jpg

12: SELECT DISTINCT SKU_Price

FROM tbl_skus

WHERE SKU_ProductID = 42 AND SKU_ShowWeb = 1

ORDER BY SKU_Price ASC

SKU_Price
11

13: SELECT prdctImage_FileName FROM tbl_prdtimages where prdctImage_ProductID = 43 and not (prdctImage_FileName like '%-bac%' or prdctImage_FileName like '%-cu%' or prdctImage_FileName like '%-close%' ) order by prdctImage_ImgTypeID, prdctImage_FileName asc limit 0, 1

prdctImage_FileName
t-futftr-t-php.jpg

14: SELECT DISTINCT SKU_Price

FROM tbl_skus

WHERE SKU_ProductID = 43 AND SKU_ShowWeb = 1

ORDER BY SKU_Price ASC

SKU_Price
11

15: SELECT prdctImage_FileName FROM tbl_prdtimages where prdctImage_ProductID = 40 and not (prdctImage_FileName like '%-bac%' or prdctImage_FileName like '%-cu%' or prdctImage_FileName like '%-close%' ) order by prdctImage_ImgTypeID, prdctImage_FileName asc limit 0, 1

prdctImage_FileName
i-futftr-shldrt-wtbl.jpg

16: SELECT DISTINCT SKU_Price

FROM tbl_skus

WHERE SKU_ProductID = 40 AND SKU_ShowWeb = 1

ORDER BY SKU_Price ASC

SKU_Price
10

17: SELECT prdctImage_FileName FROM tbl_prdtimages where prdctImage_ProductID = 44 and not (prdctImage_FileName like '%-bac%' or prdctImage_FileName like '%-cu%' or prdctImage_FileName like '%-close%' ) order by prdctImage_ImgTypeID, prdctImage_FileName asc limit 0, 1

prdctImage_FileName
i-futftr-shldrt-wtp.jpg

18: SELECT DISTINCT SKU_Price

FROM tbl_skus

WHERE SKU_ProductID = 44 AND SKU_ShowWeb = 1

ORDER BY SKU_Price ASC

SKU_Price
10

19: SELECT prdctImage_FileName FROM tbl_prdtimages where prdctImage_ProductID = 45 and not (prdctImage_FileName like '%-bac%' or prdctImage_FileName like '%-cu%' or prdctImage_FileName like '%-close%' ) order by prdctImage_ImgTypeID, prdctImage_FileName asc limit 0, 1

prdctImage_FileName
i-futftr-shldrt-php.jpg

20: SELECT DISTINCT SKU_Price

FROM tbl_skus

WHERE SKU_ProductID = 45 AND SKU_ShowWeb = 1

ORDER BY SKU_Price ASC

SKU_Price
10

21: SELECT prdctImage_FileName FROM tbl_prdtimages where prdctImage_ProductID = 39 and not (prdctImage_FileName like '%-bac%' or prdctImage_FileName like '%-cu%' or prdctImage_FileName like '%-close%' ) order by prdctImage_ImgTypeID, prdctImage_FileName asc limit 0, 1

prdctImage_FileName
i-futftr-bib-wtbl.jpg

22: SELECT DISTINCT SKU_Price

FROM tbl_skus

WHERE SKU_ProductID = 39 AND SKU_ShowWeb = 1

ORDER BY SKU_Price ASC

SKU_Price
8

---

Page Variables

Var	Value
	Page Variables Var Value name Cartweaver   Page Variables Var Value hostname localhost database tribal_TNstore databaseUsername tribal_tn databasePassword indian databaseType mysql recordCount 1 debug 1 connection Resource id #7   Page Variables Var Value db CWDBMySQL.php targetGoToCart http://www.tribalnations.net/store/showcart.php targetCheckout http://www.tribalnations.net/store/orderform.php targetConfirmOrder http://www.tribalnations.net/store/confirmation.php targetResults http://www.tribalnations.net/store/results.php targetDetails http://www.tribalnations.net/store/details.php recordsAtATime 10 onSubmitAction Confirm cwLocale en_US hostname localhost database tribal_TNstore databaseUsername tribal_tn databasePassword indian mailServer localhost detailsDisplay Advanced paymentAuthType processor paymentAuthName CWIncPayPal.php websiteURL http://www.tribalnations.net/store/ websiteSSLURL http://www.tribalnations.net/store/ imageThumbFolder cw2/assets/ imageLargeFolder cw2/assets/ cwDebug 1 debugPassword bf enableErrorHandling (empty) allowBackOrders 0 debugger OFF sku_qty (empty) sku_id (empty) qtyAdded (empty) cwError Array   Var Value (empty)   optionList (empty) productId (empty) CartId 4751314 thisPage /store/results.php thisPageQS /store/results.php?category=6 thisPageName results.php thisLocation http://www.tribalnations.net/store/results.php thisLocationQS http://www.tribalnations.net/store/results.php?category=6
queries	Array
	Var Value queries[0] Array queries[1] Array queries[2] Array queries[3] Array queries[4] Array queries[5] Array queries[6] Array queries[7] Array queries[8] Array queries[9] Array queries[10] Array queries[11] Array queries[12] Array queries[13] Array queries[14] Array queries[15] Array queries[16] Array queries[17] Array queries[18] Array queries[19] Array queries[20] Array queries[21] Array queries[22] Array
cwDebuggerStrings	Array
	Var Value (empty)
val	(empty)
key	(empty)
temp	(empty)
column	(empty)
row	(empty)

---

URL Variables

Var	Value
category	6

---

Form Variables

Var	Value

---

Session Variables

Var	Value
CartId	4751314
debug	1
shipCalcType	localcalc
companyname	Tribal Nations
companyaddress1	3101 Redemeyer Rd
companycity	Ukiah
companystate	CA
companyzip	95482
companyphone	(707) 467-9438
companyfax	(707) 467-1866
companyemail	orders@tribalnations.net
showupsell	0
AllowBackOrders	0
chargeShipBase	1
chargeShipByWeight	0
chargeShipExtension	0
enableShipping	1
enableErrorHandling	(empty)
shipToCountryID	1
checkingOut	NO
shipTotal	(empty)
shipPref	(empty)
cartSubtotal	(empty)
cartWeightTotal	(empty)

---

Environment Variables

Var	Value
DOCUMENT_ROOT	/home/tribal/public_html
GATEWAY_INTERFACE	CGI/1.1
HTTP_ACCEPT	text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET	ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING	gzip
HTTP_ACCEPT_LANGUAGE	en-us,en;q=0.5
HTTP_CACHE_CONTROL	no-cache
HTTP_CONNECTION	close
HTTP_COOKIE	CartId=4751314; CartId=4879945; PHPSESSID=f7ded859b43b2c1e398dbc067500ecf2
HTTP_HOST	www.tribalnations.net
HTTP_PRAGMA	no-cache
HTTP_USER_AGENT	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID	ccc03-01
PATH	/bin:/usr/bin
QUERY_STRING	category=6
REDIRECT_STATUS	200
REMOTE_ADDR	38.107.191.103
REMOTE_PORT	29295
REQUEST_METHOD	GET
REQUEST_URI	/store/results.php?category=6
SCRIPT_FILENAME	/home/tribal/public_html/store/results.php
SCRIPT_NAME	/store/results.php
SERVER_ADDR	174.120.5.126
SERVER_ADMIN	webmaster@tribalnations.net
SERVER_NAME	www.tribalnations.net
SERVER_PORT	80
SERVER_PROTOCOL	HTTP/1.1
SERVER_SIGNATURE	Apache mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.tribalnations.net Port 80
SERVER_SOFTWARE	Apache mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
UNIQUE_ID	TIcLMa54BWIAAGdow2sAAAAL

---

Cookie Variables

Var	Value
CartId	4751314
PHPSESSID	f7ded859b43b2c1e398dbc067500ecf2

---

File Variables

Var	Value

---

_SERVER Variables

Var	Value
DOCUMENT_ROOT	/home/tribal/public_html
GATEWAY_INTERFACE	CGI/1.1
HTTP_ACCEPT	text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET	ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING	gzip
HTTP_ACCEPT_LANGUAGE	en-us,en;q=0.5
HTTP_CACHE_CONTROL	no-cache
HTTP_CONNECTION	close
HTTP_COOKIE	CartId=4751314; CartId=4879945; PHPSESSID=f7ded859b43b2c1e398dbc067500ecf2
HTTP_HOST	www.tribalnations.net
HTTP_PRAGMA	no-cache
HTTP_USER_AGENT	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID	ccc03-01
PATH	/bin:/usr/bin
QUERY_STRING	category=6
REDIRECT_STATUS	200
REMOTE_ADDR	38.107.191.103
REMOTE_PORT	29295
REQUEST_METHOD	GET
REQUEST_URI	/store/results.php?category=6
SCRIPT_FILENAME	/home/tribal/public_html/store/results.php
SCRIPT_NAME	/store/results.php
SERVER_ADDR	174.120.5.126
SERVER_ADMIN	webmaster@tribalnations.net
SERVER_NAME	www.tribalnations.net
SERVER_PORT	80
SERVER_PROTOCOL	HTTP/1.1
SERVER_SIGNATURE	Apache mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.tribalnations.net Port 80
SERVER_SOFTWARE	Apache mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
UNIQUE_ID	TIcLMa54BWIAAGdow2sAAAAL
PHP_SELF	/store/results.php
REQUEST_TIME	1283918641
argv	Array
	Var Value argv[0] category=6
argc	1

---

Object

Var	Value

---

Class Methods

Var	Value
0	CWCart
1	setSkuQty
2	checkStockCount
3	setSkuId
4	setCWError
5	setOptionList
6	setProductId
7	setCartId
8	getSkuQty
9	getCartQty
10	getCartItemQty
11	getSkuId
12	getQtyAdded
13	getCWError
14	getOptionList
15	getProductId
16	getCartId
17	displayError
18	update
19	updateItem
20	delete
21	multiOption
22	add
23	addItem
24	clearCart
25	cartLinks

Class Variables

Catchable fatal error: Object of class DB could not be converted to string in /home/tribal/public_html/store/cw2/CWLibrary/CWDebugger.php on line 217

Var	Value
name	Cartweaver