<cfcomponent hint="my hint" displayname="mechlist">
	<cffunction name="AslList" access="public" returntype="query">
       <cfargument name="XEra" default="2" required="no">
       <cfargument name="XFaction" default="1" required="yes">
       <cfargument name="XVType" default="1" required="no">
       <cfargument name="flag" default="1" required="yes">

       <cfquery name="AslList" datasource="touman">

SELECT TRO.Faction, TRO.Name, TRO.Class, TRO.VType AS XVType, TRO.Weight, TRO.APrev as Prev, TRO.ANext as Next, TRO.UnitID, Mass.TMass as uMass, TRO.TMass, TRO.Faction AS XFaction, TRO.Era AS XEra, TRO.Votes AS AVotes FROM Era INNER JOIN (Faction INNER JOIN (Weight INNER JOIN (VType INNER JOIN (Mass INNER JOIN (Class INNER JOIN TRO ON Class.ClassID = TRO.Class) ON Mass.MassID = TRO.TMass) ON VType.VTID = TRO.VType) ON Weight.ID = TRO.Weight) ON Faction.FactionID = TRO.Faction) ON Era.EraID = TRO.Era
WHERE 	0 = 0 AND
	<cfif (flag is 1)>
	(((TRO.Faction)=#Arguments.XFaction#) AND
        ((TRO.VType)=#Arguments.XVType#) AND
	((TRO.Weight)=4))</cfif>
ORDER BY TRO.TMass, TRO.Name;
</cfquery>
		<cfreturn AslList>
	</cffunction>


       <cffunction name="HvyList" access="public" returntype="query">
       <cfargument name="XEra" default="2" required="no">
       <cfargument name="XFaction" default="1" required="yes">
       <cfargument name="XVType" default="1" required="no">
       <cfargument name="flag" default="1" required="no">

       <cfquery name="HvyList" datasource="touman">

SELECT TRO.Faction, TRO.Name, TRO.Class, TRO.VType AS XVType, TRO.Weight, TRO.APrev as Prev, TRO.ANext as Next, TRO.UnitID, Mass.TMass as uMass, TRO.TMass, TRO.Faction AS XFaction, TRO.Era AS XEra, TRO.Votes AS AVotes FROM Era INNER JOIN (Faction INNER JOIN (Weight INNER JOIN (VType INNER JOIN (Mass INNER JOIN (Class INNER JOIN TRO ON Class.ClassID = TRO.Class) ON Mass.MassID = TRO.TMass) ON VType.VTID = TRO.VType) ON Weight.ID = TRO.Weight) ON Faction.FactionID = TRO.Faction) ON Era.EraID = TRO.Era
WHERE 	0 = 0 AND
	<cfif (flag is 1)>
	(((TRO.Faction)=#Arguments.XFaction#) AND
        ((TRO.VType)=#Arguments.XVType#) AND
	((TRO.Weight)=3))</cfif>
ORDER BY TRO.TMass, TRO.Name;
</cfquery>
		<cfreturn HvyList>
	</cffunction>


       <cffunction name="MedList" access="public" returntype="query">
       <cfargument name="XEra" default="2" required="no">
       <cfargument name="XFaction" default="1" required="yes">
       <cfargument name="XVType" default="1" required="no">
       <cfargument name="flag" default="1" required="no">

       <cfquery name="MedList" datasource="touman">
SELECT TRO.Faction, TRO.Name, TRO.Class, TRO.VType AS XVType, TRO.Weight, TRO.APrev as Prev, TRO.ANext as Next, TRO.UnitID, Mass.TMass as uMass, TRO.TMass, TRO.Faction AS XFaction, TRO.Era AS XEra, TRO.Votes AS AVotes FROM Era INNER JOIN (Faction INNER JOIN (Weight INNER JOIN (VType INNER JOIN (Mass INNER JOIN (Class INNER JOIN TRO ON Class.ClassID = TRO.Class) ON Mass.MassID = TRO.TMass) ON VType.VTID = TRO.VType) ON Weight.ID = TRO.Weight) ON Faction.FactionID = TRO.Faction) ON Era.EraID = TRO.Era
WHERE 	0 = 0 AND
	<cfif (flag is 1)>
	(((TRO.Faction)=#Arguments.XFaction#) AND
        ((TRO.VType)=#Arguments.XVType#) AND
	((TRO.Weight)=2))</cfif>
ORDER BY TRO.TMass, TRO.Name;
</cfquery>
		<cfreturn MedList>
	</cffunction>


       <cffunction name="LtList" access="public" returntype="query">
       <cfargument name="XEra" default="2" required="no">
       <cfargument name="XFaction" default="1" required="yes">
       <cfargument name="XVType" default="1" required="no">
       <cfargument name="flag" default="1" required="no">

       <cfquery name="LtList" datasource="touman">

SELECT TRO.Faction, TRO.Name, TRO.Class, TRO.VType AS XVType, TRO.Weight, TRO.APrev as Prev, TRO.ANext as Next, TRO.UnitID, Mass.TMass as uMass, TRO.TMass, TRO.Faction AS XFaction, TRO.Era AS XEra, TRO.Votes AS AVotes FROM Era INNER JOIN (Faction INNER JOIN (Weight INNER JOIN (VType INNER JOIN (Mass INNER JOIN (Class INNER JOIN TRO ON Class.ClassID = TRO.Class) ON Mass.MassID = TRO.TMass) ON VType.VTID = TRO.VType) ON Weight.ID = TRO.Weight) ON Faction.FactionID = TRO.Faction) ON Era.EraID = TRO.Era
WHERE 	0 = 0 AND
	<cfif (flag is 1)>
	(((TRO.Faction)=#Arguments.XFaction#) AND
        ((TRO.VType)=#Arguments.XVType#) AND
	((TRO.Weight)=1))</cfif>
ORDER BY TRO.TMass, TRO.Name;
</cfquery>
		<cfreturn LtList>
	</cffunction>

</cfcomponent>

