9Stores.com

INVALID SQL: 1176 : Key 'protocol' doesn't exist in table 'xcart_payment_methods'
SQL QUERY FAILURE: SELECT paymentid FROM xcart_payment_methods USE INDEX (protocol) WHERE protocol = 'https'

Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb25b/b657/ipw.i9stores/public_html/shop/include/func.php:13 in /hermes/bosweb25b/b657/ipw.i9stores/public_html/shop/referer.php on line 61

Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb25b/b657/ipw.i9stores/public_html/shop/include/func.php:13 in /hermes/bosweb25b/b657/ipw.i9stores/public_html/shop/include/get_language.php on line 126

Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb25b/b657/ipw.i9stores/public_html/shop/include/func.php:13 in /hermes/bosweb25b/b657/ipw.i9stores/public_html/shop/include/get_language.php on line 127

Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb25b/b657/ipw.i9stores/public_html/shop/include/func.php:13 in /hermes/bosweb25b/b657/ipw.i9stores/public_html/shop/include/get_language.php on line 132

Warning: Cannot modify header information - headers already sent by (output started at /hermes/bosweb25b/b657/ipw.i9stores/public_html/shop/include/func.php:13 in /hermes/bosweb25b/b657/ipw.i9stores/public_html/shop/include/get_language.php on line 133
INVALID SQL: 1176 : Key 'code' doesn't exist in table 'xcart_languages'
SQL QUERY FAILURE: SELECT xcart_languages.code, xcart_countries.*, lng_c.value as country, lng_l.value as language FROM xcart_languages USE INDEX (code), xcart_countries, xcart_languages as lng_c, xcart_languages as lng_l WHERE lng_c.name = CONCAT('country_', xcart_countries.code) AND lng_c.code = 'US' AND lng_l.code = 'US' AND lng_l.name = CONCAT('language_', xcart_countries.code) AND xcart_languages.code=xcart_countries.code GROUP BY xcart_languages.code ORDER BY xcart_languages.code
INVALID SQL: 1176 : Key 'code' doesn't exist in table 'xcart_languages'
SQL QUERY FAILURE: SELECT xcart_languages.code, xcart_countries.*, lng_c.value as country, lng_l.value as language FROM xcart_languages USE INDEX (code), xcart_countries, xcart_languages as lng_c, xcart_languages as lng_l WHERE lng_c.name = CONCAT('country_', xcart_countries.code) AND lng_c.code = 'US' AND lng_l.code = 'US' AND lng_l.name = CONCAT('language_', xcart_countries.code) AND xcart_languages.code=xcart_countries.code GROUP BY xcart_languages.code ORDER BY xcart_languages.code
INVALID SQL: 1176 : Key 'code' doesn't exist in table 'xcart_languages'
SQL QUERY FAILURE: SELECT xcart_languages.code, xcart_countries.*, lng_c.value as country, lng_l.value as language FROM xcart_languages USE INDEX (code), xcart_countries, xcart_languages as lng_c, xcart_languages as lng_l WHERE lng_c.name = CONCAT('country_', xcart_countries.code) AND lng_c.code = 'DE' AND lng_l.code = 'DE' AND lng_l.name = CONCAT('language_', xcart_countries.code) AND xcart_languages.code=xcart_countries.code GROUP BY xcart_languages.code ORDER BY xcart_languages.code
INVALID SQL: 1146 : Table 'i9stores_xcart.xcart_categories_subcount' doesn't exist
SQL QUERY FAILURE: SELECT xcart_categories.categoryid,xcart_categories.parentid,xcart_categories.categoryid_path,xcart_categories.category,xcart_categories.product_count,xcart_categories.avail,xcart_categories.order_by,IF(xcart_categories_lng.category != '', xcart_categories_lng.category, xcart_categories.category) as category,xcart_categories_subcount.subcategory_count, xcart_categories_subcount.product_count,IF(xcart_icons.image != '','Y','') as is_icon, xcart_icons.image_path FROM xcart_categories USE INDEX (am) LEFT JOIN xcart_categories_lng USE INDEX (PRIMARY) ON xcart_categories_lng.code='US' AND xcart_categories_lng.categoryid=xcart_categories.categoryid LEFT JOIN xcart_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = xcart_categories.categoryid AND xcart_categories_subcount.membership = xcart_categories.membership LEFT JOIN xcart_icons ON xcart_categories.categoryid = xcart_icons.categoryid WHERE xcart_categories.avail='Y' AND xcart_categories.membership IN('', '') GROUP BY xcart_categories.categoryid ORDER BY xcart_categories.order_by, xcart_categories.category
INVALID SQL: 1146 : Table 'i9stores_xcart.xcart_products_categories' doesn't exist
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_products.forsale='Y' GROUP BY xcart_products.productid

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hermes/bosweb25b/b657/ipw.i9stores/public_html/shop/include/func.php on line 102
9Stores.com

Rebel T-Shirt Store

Replica Gun Store

Airsoft Gun Store

Blank Guns Store

Rebel Stuff Store

Civil War Store

Flags Store

Pirate Costume Store

Pool Cue Store

Product Search:

Advanced search

HOME | MY ACCOUNT | HELP | CONTACT US | LINKS

9 Great Stores

Authentication

Secure login

Recover password

If you have disabled Javascript in your browser click here

Your cart

	Cart is empty

View cart
Checkout

Help

146 Brighton Circle
Brunswick, Ga. 31525
Toll Free Phone:
(866) 314-0791
Email Us

9Stores.com

Welcome to 9Stores.com!
The Net's Fastest Growing Supply Depot For:

Rebel T-shirts - Replica Guns - Civil War Guns - Blank Guns - Airsoft Guns - Rebel T-shirts - Confederate T-shirts - Pool Cues - - Pirate Costumes - Rebel Confederate Merchandise - Civil War Memorabilia - Rebel/Confederate Flags and more!!

9Stores.com is your southern connection for Replica Guns, Rebel T-shirts, Civil War Guns, Blank Guns, Airsoft Guns, Rebel Stuff, Confederate and Civil War Collectibles, Pool Cues and Pool/Billiard supplies! Offering the very best selections on the net of our name brand products, ALL at prices that can't be beat, we are your one stop virtual shopping mall for quality products tailored to fit the needs of exciting, outgoing lifestyles

We invite you to browse our many stores where we are sure you will find just what you were looking for. If you have any questions, please contact us where our knowledgable staff will be glad to help.

Offering fast, friendly and courteous service, we guarantee that your on line shopping experience with 9Stores.comwill be a pleasurable one.

We offer secure online ordering for all our products! We also welcome phone or mail in orders at:
9Stores.com
146 Brighton Circle
Brunswick, Ga. 31525
Toll Free Ph.: (866) 314-0791

For more information, please E-mail us at: info@9Stores.com

FEATURED STORES
CLICK HERE TO VISIT REPLICA GUN STORE One of the net's most unique selections of replica guns including: Replica Blank Guns - Blank Firing Guns - Replica Muskets - Replica Flintlock Pistols - Replica Assault Rifles - Replica Civil War Guns and much more!	CLICK HERE TO VISIT BLANK GUN STORE A super selection of quality blank guns at prices that can't be beat! Our blank firing guns are perfect for stage and movie productions, starter guns and personal use.	CLICK HERE TO VISIT AIRSOFT GUNS STORE A great selection of popular Airsoft pellet guns, Softair guns, BB guns, pellet guns, Air Soft pistols, Softair assault rifles and Airsoft ammunition offered at best prices on the net!!
CLICK HERE TO VISIT REBEL STUFF STORE Your Confederate super store offering a unique selection of Rebel and confederate Merchandise including: Rebel and Confederate Clothing - Rebel Hats - Confederate Flag Bikinis - Afghans - Ties and more!	CLICK HERE TO VISIT PIRATE STORE A great selection of Pirate Costume accessories including Pirate Swords, Pirate's Hat, Pirate Muskets, Flintlock Pistols, Pirate's Blunderbuss and more!	CLICK HERE TO VISIT CIVIL WAR STORE A super selection of interesting and unique Civil War items such as Civil War Weapons, Civil War Swords, Civil War Collectibles, Civil War Flags,CSA items, Civil War Music, Civil War Map, Civil War Hats, Rebel Flags, Confederate Flags, Union Flag, Confederate, Rebel Clothing, Rebel Shirts, Confederate - Rebel - Union Guns, Swords, Confederate/Rebel Bumper Stickers, License Plates and more!!!
CLICK HERE TO VISIT REBEL FLAG STORE A great selection of Rebel Flags,Confederate flags including 18 different choices for Rebel and Confederate Battle Flags, the 1st National Confederate Flag, the 2nd Confederate Flag and the 3rd National Confederate Flags, Individual State Rebel Flags for Georgia, Rebel Flag for Mississippi, Rebel Flag for North Carolina and Rebel Flag for South Carolina to name a few....	CLICK HERE TO VISIT POOL CUE STORE STORE A great selection of Pool and Billiard Cues and other Pool Accessories including: Meucci Pool Cues, Cuetec Pool Cues, Joss Pool Cues, Schon Pool Cues, Action Pool Cues, Scorpion Pool Cues, Viking Pool Cues, Falcon Pool Cues and much more!	CLICK HERE TO VISIT REBEL T-SHIRT STORE Hundreds of popular Rebel T-shirts, Confederate T-shirts, Redneck T-shirts and more at prices that can't be beat!

For more information, we invite you to contact us at:
Email: info@9stores.com