[redirect http://shop.catalinaowners.com/yourboat.php?1/610///Q2F0YWxpbmEgMjI=] [showif [gid]=59] [redirect c22sails.htm] [/showif] [text]con=conn27[/text] [include ^dndb.tpl] [include /includes/hostlookup.tpl] [SQLExecute conn_ref=conn27&result_var=set] SELECT modspec_groups.id,modspec_groups.groupno,modspec_groups.catid,modspec_groups.boatid,modspec_skus.bundle,modspec_skus.sku AS ssku FROM modspec_groups JOIN modspec_skus ON modspec_groups.id = modspec_skus.groupid WHERE modspec_groups.id = [gid] [/SQLEXECUTE] [SQLResult result_ref=set] [founditems] [text show=f]repsku=[ssku][/text] [text show=f]groupno=[groupno][/text] [text show=f]group=[groupno][/text] [text]catid=[catid][/text] [text]boatid=[boatid][/text] [text]groupid=[id][/text] [text show=f]_sku[index]=[ssku][/text] [/founditems] [/SQLResult] [SQLExecute conn_ref=conn27&result_var=bt] SELECT * FROM modspec_boats where id = [boatid] [/SQLExecute] [SQLResult result_ref=bt] [founditems] [text]brand=[brand][/text] [text]model=[model][/text] [/founditems] [/SQLResult] [text show=f]insider=[getcookie insider][/text] [search db=/admin/site.db&eqfnodata=20&max=1] [founditems] [!] sets source cookie [/!] [showif [getcookie xcsrc]=] [text show=f]wh=[getchars start=1&end=125][referrer][/getchars][/text] [SETCOOKIE name=xcsrc&value=[wh]&expires=Wednesday, 31-Dec-2010 23:12:40 GMT&path=/&domain=.[sitename]] [/showif] [!] sets group name for whole page [/!] [search db=/emp/product/group.db&eqgroupiddata=[group]] [founditems] [text]groupname=[groupname][/text] [text]groupphoto=[groupphoto][/text] [text]kw=[keywords][/text] [text show=f]sale=[sale][/text] [text show=f]discount=[discount][/text] [text]bdays=[bdays][/text] [text]custom=[custom][/text] [text]mainsite=co[/text] [/founditems] [/search] [!] error msgs for un-selected options [/!] [showif [add]=T] [showif [textb]=skipped][text]ok=no[/text][/showif] [showif [textc]=skipped][text]ok=no[/text][/showif] [showif [textd]=skipped][text]ok=no[/text][/showif] [showif [texte]=skipped][text]ok=no[/text][/showif] [showif [ok]=no]
Error! You have not selected all required options. Please go back and select all options.

[/showif] [formvariables exact=f&name=qty] [showif [value]>0] [text]cartOK=T[/text] [/showif] [/formvariables] [hideif [cartOK]=T] [text]ok=no[/text]

Error! You have not selected a product. To select a product, go back and type a quantity next to the product you wish to purchase.
[/hideif] [/showif] [!] -- END, SHOWIF "ADD" [/!] [hideif [ok]=no] [!] sets size values for use later [/!] [IF ("[lookup db=/emp/product/product.db&lookinfield=productgroup&value=[group]&returnfield=size]"="")] [THEN] [text show=f]xsize=F[/text] [/THEN] [ELSE] [text show=f]xsize=T[/text] [/ELSE] [/IF] [!] picks one sku for product search for photo, desc, and review info [/!] [search db=/emp/product/product.db&eqskudata=[repsku]&max=1] [founditems] [!] sets options values for use later [/!] [text]vd=[vendor][/text] [text show=f]options=[options][/text] [text]meas=[meas][/text] [groupname] [include /includes/meta.inc] [include /includes/css_links.tpl] [!] [include /includes/navconfig.inc] [/!] [showif [getcookie insider]=T] [!] ADD PRODUCT TO CART [/!] [showif [add]=T] [formvariables] [name]=[value]
[/formvariables]

[text]con=conn27[/text] [include /includes/get_cart.tpl] [formvariables exact=f&name=qty] [showif [value]!] set[text show=t]sku=[getchars start=4][name][/getchars][/text] [sku] [!] error msgs for un-selected options [/!] [showif [textb]=skipped][text]ok=no[/text][/showif] [showif [textc]=skipped][text]ok=no[/text][/showif] [showif [textd]=skipped][text]ok=no[/text][/showif] [showif [texte]=skipped][text]ok=no[/text][/showif] [showif [ok]=no]

Error! You have not selected all required options. Please go back and select all options.
[/showif] [!]-[sku][/!] [search db=/emp/product/product.db&eqskudata=[sku]&max=1] [founditems] [!]+[sku][/!] [text show=t]addsku[index]=[sku][/text] [text show=f]prd1=[grep search=(["'])&replace=\\1][groupname] [product]| [hideif [textb]=[raw][textb][/raw]][textb][/hideif][hideif [textc]=[raw][textc][/raw]][textc][/hideif][hideif [textd]=[raw][textd][/raw]][textd][/hideif][/grep][/text] SQLExecute conn_ref=conn27] INSERT INTO s_cart_lineitem (sku,qty,vendor_sku,price,cost,vendor_id,product,req_meas,lcart,productgroup,est_ship_days,ldate,lfno,unitshipcost,meas_id) VALUES ('[sku]', '[value]', '[vpartno]', '[format 4.2f][IF ("[sale]"="T")][THEN][saleprice][/THEN][ELSE][price][/ELSE][/IF][/format]', '[IF ("[sale]"="T")][THEN][salecost][/THEN][ELSE][cost][/ELSE][/IF]', '[vendor]', '[prd1]', '[meas]', '[kart]', '[productgroup]', '[text show=t]bd=[bizdays][/text]', now(), '[fno]', '[unitshipcost]'[IF ("[meas]"="T")][THEN],'[productgroup]'[/THEN][ELSE],''[/ELSE][/IF]) /SQLExecute] [/founditems] [/search] [/showif] [/formvariables] redirect /confirm.php?fno=[fno]&gno=437&[listvariables name=addsku&exact=f][name]=[value]&[/listvariables]] [/showif] [/showif] [!] -- END ADD TO CART -- [/!] [include /nav_js/co/nav.html]
[!][include /includes/searchbox.inc][/!]
[text]saleends=[saleends][/text] [brand] [model] Parts Home -> [groupname]
[include /includes/cart_sql.inc]

[include /nav_js/vert_chan_use.html]

[include /includes/review.inc]

[hideif [friend]=T]
Tell a friend about this product!
[/hideif]

[showif [insider]=T] Group [groupno] (edit)

[/showif] [showif [sale]=T][/showif] [groupname] [showif [newest]>[math][math]{[date]}[/math]-46[/math]][/showif]
[!] -- SALE BLOCK -- [/!] [showif [sale]=T]

SAVE [discount]! Sale ends [format days_to_date %A %B %d, %Y][saleends][/format]

[/showif]

[showif [groupphoto]=T] 250)][THEN] >

[/THEN][ELSE] align=left>[/ELSE][/IF] [/showif] [!] -- DESCRIPTION -- [/!] [SQLExecute conn_ref=conn27&result_var=ed] SELECT * FROM modspec_desc where groupid = [groupid] [/SQLExecute] [SQLResult result_ref=ed] [founditems] [hideif [extradesc]=]
[convertchars db=/copyconv.db][interpret][extradesc][/interpret][/convertchars]

[/hideif] [/founditems] [/SQLResult] [convertchars db=/copyconv.db][interpret][lookup db=/emp/product/desc.db&lookinfield=groupid&value=[group]&returnfield=desc¬found=notfound][/interpret][/convertchars]

[include /includes/delivery.inc] [include /includes/holiday.inc]

[!] new perl form stuff [/!]

[!] options [/!] [showif [options]=T] [include /emp/copy/options/[productgroup].inc]

[/showif]

[showif [xsize]=T][/showif] [listvariables exact=f&name=_] [search db=/emp/product/product.db&eqskudata=[value]] [founditems] [IF ("[sale]"="T")] [THEN] [showif [xsize]=T][/showif] [/THEN] [ELSE] [showif [xsize]=T][/showif] [/ELSE] [/IF] [/founditems] [/search] [/listvariables]
ProductSizeItem # Qty Price
[lookup db=/emp/product/group.db&lookinfield=groupid&value=[productgroup]&returnfield=groupname]
[interpret][product][/interpret]  *Regularly $[format 4.2f][price][/format] [showif [insider]=T][showif [vendor]=fsc]([available]*[format days_to_date %m/%d][lag2][/format]) [vpartno][/showif][/showif] [IF ([available]=0) & ("[vendor]"="fsc")][THEN]
Backordered: ships 10-14 bus. days[/THEN][ELSE][/ELSE][/IF]
[interpret][size][/interpret]   [sku] $[format thousands 4.2f][saleprice][/format] US
[lookup db=/emp/product/group.db&lookinfield=groupid&value=[productgroup]&returnfield=groupname]
[interpret][product][/interpret] [showif [insider]=T][showif [vendor]=fsc]([available]*[format days_to_date %m/%d][lag2][/format]) [vpartno][/showif][/showif]  [IF ([available]=0) & ("[vendor]"="fsc")][THEN]
Backordered: ships 10-14 bus. days[/THEN][ELSE][/ELSE][/IF]
[interpret][size][/interpret]   [sku] $[format thousands 4.2f][price][/format] US

[/founditems] [/search] [include /includes/basecode.inc] [/hideif]

[include /includes/copyright.tpl] [/founditems] [/search] [SQLDisconnect conn_ref=conn27]