Joomla! License Guidelines Print E-mail
User Rating: / 43
PoorBest 
Written by Andrew (Administrator)   
Thursday, 19 August 2004

This website is powered by Joomla! The software and default templates on which it runs are Copyright 2005 Open Source Matters. All other content and data, including data entered into this website and templates added after installation, are copyrighted by their respective copyright owners.

If you want to distribute, copy or modify Joomla!, you are welcome to do so under the terms of the GNU General Public License. If you are unfamiliar with this license, you might want to read 'How To Apply These Terms To Your Program' and the 'GNU General Public License FAQ'.
Last Updated ( Thursday, 19 August 2004 )
 
[ Back ]

Latest Events

2009-10-05
Summary
Purdue Ice Hockey is looking to fill a coaching position, if interested please contact Zach Fate for more details at zfate@purdue.edu. Some experience preferred.

The club has set a date for th    More

Stats Leaders

Points
Radermacher, 60
Goals
Radermacher, 30
Assists
Radermacher, 30
Penalty Minutes
Fate, 118

Standing

Silver Division North - 2010-2011 Season Standings

Purdue Wins Division!

Purdue University 10-2-0-20

University of Iowa - Black 9-2-0-16

Marquette University 8-4-0-16

Illinois State - Icebirds 5-6-1-11

Northwestern 5-6-1-11

Wheaton College 4-7-1-9

Augustana University 1-11-0-2

Standings Updated 02/15/2011
Web Site Design by MESH
38 queries executed
1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering LIMIT 1
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 6 )
 ORDER BY menuid DESC
 LIMIT 1
4
DELETE FROM jos_session
 WHERE ( time < '1327713162' )
5
SELECT * FROM jos_session WHERE session_id='058d910690591b13c73a28b7fba88411'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = MD5( '9a14d096886e50f02a181d2bdde192b1' )
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'e8013244dfffc89f8b7945d74eb29dd3','1327713939','','0','1' )
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
10
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
11
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
12
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
13
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
14
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'editors-xtd'
 ORDER BY ordering
15
SELECT access
 FROM jos_menu
 WHERE id = 6
16
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content'
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.id = 5 AND ( a.state = 1 OR a.state = -1 )
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-01-27 20:25' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-01-27 20:25' )
 AND a.access <= 0
17
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '5'
18
SELECT hits
 FROM jos_core_log_items
 WHERE time_stamp = '2012-01-27'
 AND item_table = '#__content'
 AND item_id = 5
19
UPDATE jos_core_log_items
 SET hits = ( hits + 1 )
 WHERE time_stamp = '2012-01-27'
 AND item_table = '#__content'
 AND item_id = 5
20
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
21
SELECT id
 FROM jos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
22
SELECT * FROM jos_mambots WHERE id='16'
23
SELECT a.id
 FROM jos_components AS a
 WHERE a.name = 'Syndicate'
24
SELECT * FROM jos_components WHERE id='17'
25
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= '0'
 AND m.client_id != 1
 AND ( mm.menuid = '6' OR mm.menuid = 0 )
 ORDER BY ordering
26
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
27
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
28
SELECT a.id, a.title, a.sectionid, a.catid,a.introtext,a.created
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-27 20:25:39' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-27 20:25:39' )
 AND s.published = 1
 AND cc.published = 1
 AND a.sectionid=1
 ORDER BY a.created DESC
 LIMIT 1
29
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
30
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
31
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
32
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 1
33
select SeasonID from jos_purdue_config
34
select max(g.GameDateTime) as GameTime
        from jos_purdue_game g inner join jos_purdue_player_stats ps on g.GameID=ps.GameID
        where g.GameID in (select ss.GameID
                            from jos_purdue_season_schedule ss
                            where ss.SeasonID=4)
35
select p.PlayerID, p.PlayerLastName,p.PlayerFirstName, sum(ps.Goals + ps.Assists) as Points
        from jos_purdue_player p inner join jos_purdue_player_stats ps on p.PlayerID=ps.PlayerID
        where ps.GameID in (select GameID from jos_purdue_season_schedule where SeasonID=4)
        group by p.PlayerID
        order by Points desc limit 0,1
36
select p.PlayerID, p.PlayerLastName,p.PlayerFirstName, sum(ps.Goals) as Goals
        from jos_purdue_player p inner join jos_purdue_player_stats ps on p.PlayerID=ps.PlayerID
        where ps.GameID in (select GameID from jos_purdue_season_schedule where SeasonID=4)
        group by p.PlayerID
        order by Goals desc limit 0,1
37
select p.PlayerID, p.PlayerLastName,p.PlayerFirstName, sum(ps.Assists) as Assists
        from jos_purdue_player p inner join jos_purdue_player_stats ps on p.PlayerID=ps.PlayerID
        where ps.GameID in (select GameID from jos_purdue_season_schedule where SeasonID=4)
        group by p.PlayerID
        order by Assists desc limit 0,1
38
select p.PlayerID, p.PlayerLastName,p.PlayerFirstName, sum(ps.PIM) as PIM
        from jos_purdue_player p inner join jos_purdue_player_stats ps on p.PlayerID=ps.PlayerID
        where ps.GameID in (select GameID from jos_purdue_season_schedule where SeasonID=4)
        group by p.PlayerID
        order by PIM desc limit 0,1