Basic Rules
Jericho has many and varied rules, many of which are explained on a daily basis, some of which are game specific, and they make the games more interesting. Here, we outline the basic rules of Jericho. These are the basics you'll need to know before you arrive, in order that you can play/train without any immediate complications.
Basic Facility Rules
The basic facility rules, are rules that are to be followed at ALL TIMES. Some of our other rules are game specific, these rules are not, they are mandatory. It is useful to know these rules before arriving on site:-
Limitations and Regulations
FPS Limit: The FPS limit for any standard gun (other than sniper rifles) including pistols, is an average of 400fps (any gun firing over this limit, will not be able to be used at Jericho, or re-chronoed that day, unless changes have been made to the internals of the gun, ie a spring downgrade).
Sniper FPS Limit: Snipers are allowed to have a muzzle velocity of up to 550FPS, and have a mimimum engagement limit of 100ft. They MUST HAVE a sidearm, or have a 'spotter' with them. AEG's can only be desginated as a sniper rifle, if they do not have full-auto capability (the auto capability must have been completely disabled on the gun, or it must be a rifle like an SR-25 that has no automatic capability).
Face Protection:
· People over 18: People over the age of 18 can wear either a full-facemask, or fully sealed ANSI safety rated protective goggles, combined with additional face protection, such as a neoprene face cover, or shemagh.
· Minors (People under 18): Minors are required to wear a full face paintball style mask only, and are not allowed to wear goggle combinations of any kind, with ABSOLUTELY NO EXCEPTIONS.
· SHOOTING GLASSES ARE NOT ALLOWED.
Magazine Limitations:
When playing at Jericho, the following Magazine restrictions are in place:-
BEGINNERS GROUPS MAGAZINE RESTRICTIONS
Hi-Cap Magazines: If you prefer to use only Hi-Cap magazines, you are allowed to carry 2 Hi-Capacity magazines only (you may carry additional ammunition upon your person to reload them during gameplay).
Combo Play: You may combine the use of both Hi-Cap and Mid-Cap magazines. You are only able to carry one Hi-Cap, and as many Mid-Caps as you can carry (you may also carry additional speedloaders, and extra ammo during gameplay).
Mid-Cap/Standards: There are no limitations on the use of Mid-Caps or Standard magazines. You can use as many mids/standards as you can carry, and as many speedloaders and bbs as you can physically carry during gameplay.
Ultra Hi-Cap/Box/Drum/C-Mags: During regular gameplay, super Hi-Caps , Box Magazines, Drum Magazines, C-Magazines, etc, are NOT ALLOWED (unless you have a SAW-type weapon, ie M249, M60, Shrike, etc). Box magazines etc, are only allowed during games where a designated squad gunner is required, and there are not enough SAW's to fulfil SAW positions available (SAW's will always take presidence over box/drum/c-mags, etc).
ADVANCED PLAYERS MAGAZINE RESTRICTIONS
· Hi-Cap Magazines: If you prefer to use only Hi-Cap magazines, you are allowed to 1 Hi-Cap magazine only (you may carry additional ammunition upon your person to reload them during gameplay).
· Combo Play: You may combine the use of both Hi-Cap and Mid-Cap magazines. You are only able to carry one Hi-Cap, and as many Mid-Caps as you can carry (you may also carry additional speedloaders, and extra ammo during gameplay).
· Mid-Cap/Standards: There are no limitations on the use of Mid-Caps or Standard magazines. You can use as many mids/standards as you can carry, and as many speedloaders and bbs as you can physically carry during gameplay.
· Ultra Hi-Cap/Box/Drum/C-Mags: During regular gameplay, super Hi-Caps , Box Magazines, Drum Magazines, C-Magazines, etc, are NOT ALLOWED (unless you have a SAW-type weapon, ie M249, M60, Shrike, etc). Box magazines etc, are only allowed during games where a designated squad gunner is required, and there are not enough SAW's to fulfil SAW positions available (SAW's will always take presidence over box/drum/c-mags, etc).
· NO HOODIES OR SWEATSHIRTS ALLOWED: Players are not allowed to wear hoodies or sweatshirts, while playing airsoft at Jericho. It is not possible for a player to feel all hits when wearing them, and a safety risk during hot weather. Military uniform jackets (BDU, DCU, ACU, MCCUU) are required, but long sleaved t-shirts/shirts are acceptable. Airsoft is a military simulation game. Teams are split by camo, or color of shirt, therefore if 2 people show up wearing opposite colors (dark and light colors) they may be put onto different teams. PLEASE SEE UNIFORM/DRESS CODE REQUIREMENTS
· UNIFORM/DRESS CODE: Military uniforms are required to play airsoft. If you do not have a military uniform, a minimum of a jacket/top is required. You can rent a military style jacket from Jericho for $5.00 for the day. This helps greatly with team identification.
'3 Rules of Jericho'
1. SAFE AREAS:-
Face Protection: The designated safe areas are the only places within Jericho where you are clear and safe to remove face protection. Face protection must be kept on at all times when outside of these areas, and remain on until you are COMPLETELY INSIDE of one of these areas, even when there are no games being played. When a game is over, you must wear the face protection until you are completely inside one of the safe areas.
Gun Safety: Whilst the safe areas, you must have your MAGAZINE REMOVED, the CHAMBER CLEAR, the SAFETY ON, and your GUN DOWN on a table, on ri na gun rack provided for you. Treat your rifle as if it is loaded AT ALL TIMES! Do not pick up your rifle in the safe area, except when entering or leaving.When moving from a safe area into a playing area, you must carry your rifle pointing down towards the ground. DO NOT PLACE YOUR FINGER ON THE TRIGGER AT ANY TIME. Do not pick up or fire your gun at any time, for any reason within the safe areas. Do not test fire your rifle at any time, even if you think it is completely capable of firing, and especially not if it's jammed.
2. DO NOT MOVE OR DESTROY ANYTHING:-
Cover: When playing/training within Jericho, please do not move anything. Jericho is constantly being re-arranged. Sometimes doorways, windows, hallways, rooms, or even complete streets, are blocked up by barricades, barrels, pallets, etc. We painstakingly move everything around in Jericho every week to make it more interesting and different to play in. Sometimes this may be something as simple as a barrel half blocking a doorway, or a pallet placed across a doorway. Do not move these obstacles out of the way. You can use them as cover, but not pick them up and move them around to better benefit yourself. You may uncover other dangers, such as snakes, nails, etc.
3. NO BLIND FIRE:-
You must look down the sights of your gun at all times when firing. You must be able to make visual contact with your target. Do not fire around corners without looking, fire over the top of things, or put your gun into a room and fire without being able to see. Do look through one hole and fire through another (there could be people you cannot see the other side).
4. Rules during Gameplay:-
1. Hits
When playing airsoft at Jericho, a hit is defined as any contact with your person. If you are hit ANYWHERE AT ALL, you are hit.
If you are wearing loose clothing, and the bb makes contact with your clothing at all, you are still hit, and are out.
Ricochets do not count, as bullets do not bounce, but are difficult to define, so if you're at all unsure, you're out, so call it.
When you are hit, you must shout 'HIT, HIT, HIT', loudly and clearly, then follow the procedure for that particular game (for hit procedures see below). Death rags can also be used, by placing a red rag on your head, or on the muzzle of your gun, indicating you're dead or injured.
When in an 'Elimination' game, or 'Force-on-Force' (a game where one hit means you are dead, you must shout 'HIT, HIT, HIT', raise your gun/rifle in the air, and walk off the playing area onto one of the berms, or high points of the field.
DO NOT LOOK FOR CONFIRMATION OF YOUR HIT. If you are hit, it doesn't matter who shot you, friend, or enemy, all hits count. If a person shot you from cover, and you cannot see them, do not stare into the bush whee the shot came from, you're potentially giving away their position.
DEAD MEN DON'T TALK. When dead, do not talk, or give away the position of the enemy.
2. Gun Hits
Gun hits are played by line of sight in Jericho, ie, if your rifle is in between yourself and the person shooting at you, then you are out. If, for instance, your rifle is poking out around a corner (a bad habit anyway), and bbs are hitting the rifle from the side, then you would not have been hit by that bb, therefore you are not out.
3. Surrender Rules
· If you approach someone from behind or from side on, get within 10 feet, and they are unaware of your presence, YOU MUST ASK THEM TO SURRENDER, and THEY MUST ACCEPT. If this situation occurs, and either party are consfused about procedure, please do not shoot, call a 'PARLAY' (see below).
· If you come across a player within 10ft, and you are both aware of each other's presence (ie, you both backed around a corner, and you intend to come out again), do not ask them to surrender. In order to kill them, you must hit them. Aim CENTER-OF-MASS ONLY, or back up and try to go around on them. If you come around the corner to someone with their rifle trained on you, do not ask them to surrender, they have the advantage in a real life situation. ONLY EVER USE SEMI-AUTOMATIC in a close engagement, or use a pistol, if you have one. Within buildings, close environments, etc, switch to semi-auto, or use a sidearm.
· If you both come out at the same time, and are close, call a 'PARLAY' (see below).
· If a situation begins to feel dangerous IN ANY WAY, ie if a player is inside a building with one exit, and another player is outside that room, and the only thing that will happen is close combat, and it feels like it could hurt, or become dangerous, DO NOT ENGAGE, call a parlay.
· Parlay can also be used when two players are around a corner, and they BOTH KNOW it's gonna get close and dangerous, call a parlay.
4. Parlay
· 'Parlay' (or Parle), is latin for 'talk', or 'speak'. If you raise your voice and argue with someone, shout at them, or have some form of conflict, then call 'parlay', and both players leave the game. This gives them a chance to cool off, talk through the issue, etc.
· Parlay is also used when 2 people suddenly end up right up close, face-to-face, muzzle-to-muzzle. If you find yourself in this situation, just call a 'parlay', and both players can go to their start point and respawn (even if it is not a respawn game). This prevents any unnecessary problems.
session.counter ⇒ 3
session.timer.start ⇒ 1329987168
session.timer.last ⇒ 1329987200
session.timer.now ⇒ 1329987224
session.client.browser ⇒ CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
registry ⇒ {}
id ⇒ 0
name ⇒
username ⇒
email ⇒
password ⇒
password_clear ⇒
usertype ⇒
block ⇒
sendEmail ⇒ 0
registerDate ⇒
lastvisitDate ⇒
activation ⇒
params ⇒
groups ⇒ Array
guest ⇒ 1
aid ⇒ 0
session.token ⇒ 064d5ab9f38a567f1bf632902e1c8f7d
frontpage_events ⇒ Upcoming Events
-
Feb
25
-
Apr
21
link ⇒ http://www.jerichoairsoft.com/index.php/en/info/location
expiry ⇒ 1329987200
link ⇒ http://www.jerichoairsoft.com/index.php/en/info/basic-rules
expiry ⇒ 1329987225
Application 0.000 seconds (+0.000); 0.52 MB (+0.524) - afterLoadApplication 0.087 seconds (+0.087); 4.84 MB (+4.318) - afterInitialiseApplication 0.111 seconds (+0.024); 5.80 MB (+0.955) - afterRouteApplication 0.185 seconds (+0.074); 8.33 MB (+2.537) - afterDispatchApplication 0.306 seconds (+0.121); 11.26 MB (+2.925) - beforeRenderModule mod_roknavmenu ()Application 0.409 seconds (+0.103); 15.28 MB (+4.019) - afterRenderModule mod_roknavmenu ()Application 0.412 seconds (+0.003); 15.26 MB (-0.020) - beforeRenderModule mod_roknavmenu ()Application 0.429 seconds (+0.017); 15.35 MB (+0.086) - afterRenderModule mod_roknavmenu ()Application 0.443 seconds (+0.014); 15.38 MB (+0.037) - beforeRenderModule mod_roknavmenu ()Application 0.457 seconds (+0.014); 15.45 MB (+0.063) - afterRenderModule mod_roknavmenu ()Application 0.471 seconds (+0.014); 15.38 MB (-0.064) - beforeRenderModule mod_envolve_chat (Envolve Chat)Application 0.475 seconds (+0.005); 15.41 MB (+0.028) - afterRenderModule mod_envolve_chat (Envolve Chat)Application 0.476 seconds (+0.000); 15.41 MB (-0.000) - beforeRenderModule mod_login (Login Form)Application 0.483 seconds (+0.008); 15.47 MB (+0.058) - afterRenderModule mod_login (Login Form)Application 0.529 seconds (+0.046); 15.56 MB (+0.095) - afterRender15.58 MB (16,337,672 Bytes)SELECT `data`
FROM `jericho_session`
WHERE `session_id` = '9ea9bd8b6d3a42d317cc7a3b28772668'SELECT folder AS type, element AS name, params
FROM jericho_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingSELECT *
FROM jericho_languages
WHERE published=1
ORDER BY ordering ASCSELECT extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions
WHERE `type` = 'component'
AND `element` = 'com_kunena'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jericho_menu AS m
LEFT JOIN jericho_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSELECT extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions
WHERE `type` = 'component'
AND `element` = 'com_rokcandy'SELECT *
FROM jericho_rokcandy
WHERE published=1SELECT id, home, template, s.params
FROM jericho_template_styles as s
LEFT JOIN jericho_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1SELECT extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT b.rules
FROM jericho_assets AS a
LEFT JOIN jericho_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jericho_content AS a
LEFT JOIN jericho_categories AS c
on c.id = a.catid
LEFT JOIN jericho_users AS u
on u.id = a.created_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jericho_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN jericho_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jericho_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jericho_categories AS cat JOIN jericho_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 5
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 08:53:44')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 08:53:44')
AND (a.state = 1 OR a.state =2)SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jericho_categories as c
LEFT JOIN jericho_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jericho_categories AS cat JOIN jericho_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=11
AND badcats.id is null
AND (c.id=s.id OR c.language in ('en-GB','*'))
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT b.rules
FROM jericho_assets AS a
LEFT JOIN jericho_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.5' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT a.id,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM jericho_content AS a
LEFT JOIN jericho_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 11
AND a.state = 1
AND a.access = 1
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 08:53:44')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 08:53:44')
AND a.language in ('en-GB','*')
ORDER BY a.created DESCUPDATE jericho_content
SET hits = hits + 1
WHERE id = 5SELECT id, home, template, params
FROM jericho_template_styles
WHERE client_id = 0SELECT id, home, template, params
FROM jericho_template_styles
WHERE client_id = 0SELECT id, home, template, params
FROM jericho_template_styles
WHERE client_id = 0SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jericho_modules AS m
LEFT JOIN jericho_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jericho_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-02-23 08:53:44')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-02-23 08:53:44')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 183 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingSELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0SHOW FULL COLUMNS
FROM `jericho_community_config`SELECT *
FROM jericho_community_config
WHERE `name` = 'config'show tables like '%_kunena_users'SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `jericho_community_users` as a
LEFT JOIN `jericho_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jericho_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='0'SHOW FULL COLUMNS
FROM `jericho_community_profiles`SELECT *
FROM jericho_kunena_configSELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0SELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0UPDATE `jericho_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1329987168;s:18:\"session.timer.last\";i:1329987200;s:17:\"session.timer.now\";i:1329987224;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"064d5ab9f38a567f1bf632902e1c8f7d\";s:16:\"frontpage_events\";s:1470:\"<h3>Upcoming Events</h3>\n<ul class=\"cResetList clrfix\">\n \n <li class=\"jomNameTips\" title=\"Jericho Airsoft big game. Free gun prize raffle
and giveaways,sponsored by Evike.com & AEX.\" >\n <div class=\"jsEvDate\">\n <div class=\"jsMM\">Feb</div>\n <div class=\"jsDD\">25</div>\n </div>\n <div class=\"jsDetail\" style=\"margin-
left:45px\">\n <div class=\"small\">\n <b><a href=\"/index.php/en/jomsocial/events/viewevent/6-red-vs-blue\">RED VS BLUE</a></b>\n </div>\n <div class=\"small\">\n 14881 temescal canyon road, lake Elsinore, CA </div>\n <div class=\"small\">\n <a href=\"/index.php/en/jomsocial/events/viewguest?eventid=6&type=1\">\n 5 attendees </a>\n </div>\n </div>\n <div class=\"clr\"></div>\n </li>\n \n <li class=\"jomNameTips\" title=\"Airsoft team tournament hosted by Team Karma.\r\n\r\nMore details soon.\" >\n <div class=\"jsEvDate\">\n <div class=\"jsMM\">Apr</div>\n <div class=\"jsDD\">21</div>\n </div>\n <div class=\"jsDetail\" style=\"margin-
left:45px\">\n <div class=\"small\">\n <b><a href=\"/index.php/en/jomsocial/events/viewevent/7-karmageddon-airsoft-tournament\">KARMAGEDDON AIRSOFT TOURNAMENT</a></b>\n </div>\n <div class=\"small\">\n Lake Elsinore, CA </div>\n <div class=\"small\">\n <a href=\"/index.php/en/jomsocial/events/viewguest?eventid=7&type=1\">\n 2 attendees </a>\n </div>\n </div>\n <div class=\"clr\"></div>\n </li>\n </ul>\n<div class=\"app-box-footer\">\n <a href=\"/index.php/en/jomsocial/events\">View all events</a>\n</div>\n\n\";s:16:\"com_mailto.links\";a:2:{s:40:\"6863ef6c578003bc237f043ab205da830f5f2a08\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"http://www.jerichoairsoft.com/index.php/en/info/location\";s:6:\"expiry\";i:1329987200;}s:40:\"835e7fbbda2b9ce09bbfe1d207ca95181603a51e\";O:8:\"stdClass\":2:{s:4:\"link\";s:59:\"http://www.jerichoairsoft.com/index.php/en/info/basic-rules\";s:6:\"expiry\";i:1329987225;}}}'
, `time` = '1329987225'
WHERE `session_id` = '9ea9bd8b6d3a42d317cc7a3b28772668'5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions3 × SELECT template
FROM jericho_template_styles3 × SELECT id, home, template, params
FROM jericho_template_styles2 × SELECT b.rules
FROM jericho_assets AS a
LEFT JOIN jericho_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jericho_modules AS m
LEFT JOIN jericho_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jericho_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM jericho_community_config1 × SELECT *
FROM jericho_kunena_confi1 × SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.*
FROM `jericho_community_users` as a
LEFT JOIN `jericho_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jericho_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'1 × SELECT a.id,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM jericho_content AS a
LEFT JOIN jericho_categories AS cc
ON cc.id = a.catid1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jericho_content AS a
LEFT JOIN jericho_categories AS c
on c.id = a.catid
LEFT JOIN jericho_users AS u
on u.id = a.created_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jericho_contact_details AS contact1 × SELECT *
FROM jericho_languages1 × SELECT folder AS type, element AS name, params
FROM jericho_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jericho_menu AS m
LEFT JOIN jericho_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM jericho_rokcandy1 × SELECT `data`
FROM `jericho_session`1 × SELECT id, home, template, s.params
FROM jericho_template_styles as s
LEFT JOIN jericho_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jericho_categories as c
LEFT JOIN jericho_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jericho_categories AS cat JOIN jericho_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × UPDATE `jericho_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1329987168;s:18:\"session.timer.last\";i:1329987200;s:17:\"session.timer.now\";i:1329987224;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"064d5ab9f38a567f1bf632902e1c8f7d\";s:16:\"frontpage_events\";s:1470:\"<h3>Upcoming Events</h3>\n<ul class=\"cResetList clrfix\">\n \n <li class=\"jomNameTips\" title=\"Jericho Airsoft big game. Free gun prize raffle
and giveaways,sponsored by Evike.com & AEX.\" >\n <div class=\"jsEvDate\">\n <div class=\"jsMM\">Feb</div>\n <div class=\"jsDD\">25</div>\n </div>\n <div class=\"jsDetail\" style=\"margin-
left:45px\">\n <div class=\"small\">\n <b><a href=\"/index.php/en/jomsocial/events/viewevent/6-red-vs-blue\">RED VS BLUE</a></b>\n </div>\n <div class=\"small\">\n 14881 temescal canyon road, lake Elsinore, CA </div>\n <div class=\"small\">\n <a href=\"/index.php/en/jomsocial/events/viewguest?eventid=6&type=1\">\n 5 attendees </a>\n </div>\n </div>\n <div class=\"clr\"></div>\n </li>\n \n <li class=\"jomNameTips\" title=\"Airsoft team tournament hosted by Team Karma.\r\n\r\nMore details soon.\" >\n <div class=\"jsEvDate\">\n <div class=\"jsMM\">Apr</div>\n <div class=\"jsDD\">21</div>\n </div>\n <div class=\"jsDetail\" style=\"margin-
left:45px\">\n <div class=\"small\">\n <b><a href=\"/index.php/en/jomsocial/events/viewevent/7-karmageddon-airsoft-tournament\">KARMAGEDDON AIRSOFT TOURNAMENT</a></b>\n </div>\n <div class=\"small\">\n Lake Elsinore, CA </div>\n <div class=\"small\">\n <a href=\"/index.php/en/jomsocial/events/viewguest?eventid=7&type=1\">\n 2 attendees </a>\n </div>\n </div>\n <div class=\"clr\"></div>\n </li>\n </ul>\n<div class=\"app-box-footer\">\n <a href=\"/index.php/en/jomsocial/events\">View all events</a>\n</div>\n\n\";s:16:\"com_mailto.links\";a:2:{s:40:\"6863ef6c578003bc237f043ab205da830f5f2a08\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"http://www.jerichoairsoft.com/index.php/en/info/location\";s:6:\"expiry\";i:1329987200;}s:40:\"835e7fbbda2b9ce09bbfe1d207ca95181603a51e\";O:8:\"stdClass\":2:{s:4:\"link\";s:59:\"http://www.jerichoairsoft.com/index.php/en/info/basic-rules\";s:6:\"expiry\";i:1329987225;}}}' , `time` = '1329987225'1 × SHOW FULL COLUMNS
FROM `jericho_community_profiles1 × show tables like '%_kunena_users1 × SHOW FULL COLUMNS
FROM `jericho_community_config1 × UPDATE jericho_content
SET hits = hits + 1