Notice: Undefined offset: 8192 in /storage/content/09/172109/jholmster.com/public_html/includes/kiss_error_handler.php on line 179 jQuery/Ajax Advanced Caching System 2.3.3

$79.99

SWAT 3: Close Quarters Battle
[PC-SWAT3]

SWAT 3: Close Quarters Battle
Windows 95/98

211 in progress with shots fired. Officer down. Armed suspects with hostages. Respond Code 3! Los Angles, 2005, In the next seven days, representatives from every nation around the world will converge on Las Angles to witness the signing of the United Nations Nuclear Abolishment Treaty. The protection of these dignitaries falls on the shoulders of one organization, LAPD SWAT. As part of this elite tactical organization, you and your team have the weapons and all the training necessary to protect, to serve, and "When needed" to use deadly force to keep the peace. It takes more than weapons to make it through each mission. Your arsenal includes C2 charges, flashbangs, tactical grenades. opti-Wand mini-video cameras, and other devices critical to meeting your objectives and keeping your men free of injury. Uncompromised Duty, Honor and Valor!
Reviews

Customers who bought this product also purchased
Die Hard With A Vengeance
Die Hard With A Vengeance
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
0 items
Share Product
Share via E-Mail
Share on Facebook Share on Twitter
Currencies

Parse Time: 0.246s

FWR MEDIA
KissER Query Output:
Total Queries: 20
Slowest Query Number 15
Time: 0.0057 Seconds.
Total query Time 0.0419 Seconds.
Number: 1
Time: 0.0038 Seconds.
Query: select configuration_key as cfgKey, configuration_value as cfgValue from configuration
Number: 2
Time: 0.0015 Seconds.
Query: select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
Number: 3
Time: 0.0016 Seconds.
Query: select languages_id, name, code, image, directory from languages order by sort_order
Number: 4
Time: 0.0022 Seconds.
Query: select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name
Number: 5
Time: 0.0015 Seconds.
Query: select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10
Number: 6
Time: 0.0015 Seconds.
Query: select products_name from products_description where products_id = '25' and language_id = '1'
Number: 7
Time: 0.0018 Seconds.
Query: select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '18') and tr.tax_class_id = '1' group by tr.tax_priority
Number: 8
Time: 0.0013 Seconds.
Query: select products_name from products_description where products_id = '21' and language_id = '1'
Number: 9
Time: 0.0014 Seconds.
Query: select products_name from products_description where products_id = '21' and language_id = '1'
Number: 10
Time: 0.0013 Seconds.
Query: select products_image from products where products_id = '21'
Number: 11
Time: 0.0017 Seconds.
Query: select image from products_images where products_id = '21' order by sort_order
Number: 12
Time: 0.0019 Seconds.
Query: select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' and r.reviews_status = 1 and p.products_id = '21' order by r.reviews_id desc limit 10
Number: 13
Time: 0.002 Seconds.
Query: select count(*) as total from products p, products_description pd where p.products_status = '1' and p.products_id = '21' and pd.products_id = p.products_id and pd.language_id = '1'
Number: 14
Time: 0.003 Seconds.
Query: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '21' and pd.products_id = p.products_id and pd.language_id = '1'
Number: 15
Time: 0.0057 Seconds.
Query: update products_description set products_viewed = products_viewed+1 where products_id = '21' and language_id = '1'
Number: 16
Time: 0.0029 Seconds.
Query: select image, htmlcontent from products_images where products_id = '21' order by sort_order
Number: 17
Time: 0.0015 Seconds.
Query: select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='21' and patrib.options_id = popt.products_options_id and popt.language_id = '1'
Number: 18
Time: 0.0015 Seconds.
Query: select count(*) as count from reviews r, reviews_description rd where r.products_id = '21' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and reviews_status = 1
Number: 19
Time: 0.0025 Seconds.
Query: select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '21' and opa.orders_id = opb.orders_id and opb.products_id != '21' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6
Number: 20
Time: 0.0013 Seconds.
Query: select products_name from products_description where products_id = '12' and language_id = '1'
FWR MEDIA
KissER Error Handling:
Unique error code: 8192 Error Count: 1
Error: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
File: includes/functions/database.php
Line: 19
E_WARNING Error Count: 33
Error: fopen(/tmp/jholmster/configuration_cache.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/configuration_cache_arrays.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/currencies.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/currencies.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/languages.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/languages.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: constant(): Couldn't find constant PRODPATH_21
File: includes/functions/general.php
Line: 965
Error: array_key_exists() expects parameter 2 to be array, null given
File: includes/application_top.php
Line: 515
Error: fopen(/tmp/jholmster/categories_box-english.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: constant(): Couldn't find constant SUBCATCOUNT_1
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_1
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_2
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_2
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_3
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_3
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_21
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_21
File: includes/functions/general.php
Line: 422
Error: fopen(/tmp/jholmster/categories_box-english.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/bm_whats_new-english-USD.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: array_key_exists() expects parameter 2 to be array, null given
File: includes/functions/general.php
Line: 105
Error: fopen(/tmp/jholmster/bm_whats_new-english-USD.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/bm_best_sellers_box-0-1.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/bm_best_sellers_box-0-1.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/reviews_box-english.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/reviews_box-english.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/product_info.php-products_id-21-language-english-currency-USD.page.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/also_purchased-english.cache21): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/also_purchased-english.cache21): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/product_info.php-products_id-21-language-english-currency-USD.page.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: error_log(/tmp/jholmster/page_parse_time.log): failed to open stream: No such file or directory
File: includes/application_bottom.php
Line: 20