Cold Fusion & PHP
Hallo @ all
ich hab ein kleines problem:
ich hab einen QT in Cold Fusion und will in in PHP umschreiben.
der QT siet so aus
<cfparam name="Attributes.TopLevMenu" default="0">
<cfparam name="Attributes.SelectedClass" default="">
<cfquery
name="SIHV_Query"
datasource=#caller.Query_DataSource#>
SELECT *
FROM Sprachen
INNER JOIN (Sites
INNER JOIN ((Matchcodes
INNER JOIN Menu_Struct ON Matchcodes.MatchID = Menu_Struct.MatchID)
INNER JOIN Menu_Data ON (Menu_Data.SiteID = Menu_Struct.SiteID) AND (Menu_Struct.MenuID = Menu_Data.MenuID))
ON (Sites.SiteID = Menu_Struct.SiteID) AND (Sites.SiteID = Matchcodes.SiteID))
ON Sprachen.SpracheID = Menu_Data.SpracheID
WHERE (Sprachen.SpracheMatch = '#Attributes.Sprache#')
AND ((Menu_Struct.Invisible IS NULL) OR (Menu_Struct.Invisible = 0))
AND (Sites.SiteMatch = '#Attributes.Site#')
<cfif Attributes.TopLevMenu EQ -1>
AND (Menu_Struct.ParentItem IS NULL)
<cfelse>
AND (Menu_Struct.ParentItem IN ( SELECT Menu_Struct.MenuID
FROM Sites INNER JOIN (Matchcodes INNER JOIN Menu_Struct
ON Matchcodes.MatchID = Menu_Struct.MatchID)
ON (Sites.SiteID = Menu_Struct.SiteID) AND (Sites.SiteID = Matchcodes.SiteID)
WHERE (Matchcodes.Matchcode = '#Attributes.Page#')
AND (Sites.SiteMatch = '#Attributes.Site#') )
)
</cfif>
ORDER BY Menu_Struct.MenuID
</cfquery>
<cfif SIHV_Query.Recordcount IS 0>
<cfquery
name="SIHV_Query"
datasource=#caller.Query_DataSource#>
SELECT *
FROM Sprachen
INNER JOIN (Sites
INNER JOIN ((Matchcodes
INNER JOIN Menu_Struct ON Matchcodes.MatchID = Menu_Struct.MatchID)
INNER JOIN Menu_Data ON (Menu_Data.SiteID = Menu_Struct.SiteID) AND (Menu_Struct.MenuID = Menu_Data.MenuID))
ON (Sites.SiteID = Menu_Struct.SiteID) AND (Sites.SiteID = Matchcodes.SiteID))
ON Sprachen.SpracheID = Menu_Data.SpracheID
WHERE (Sprachen.SpracheMatch = '#Attributes.Sprache#')
AND ((Menu_Struct.Invisible IS NULL) OR (Menu_Struct.Invisible = 0))
AND (Sites.SiteMatch = '#Attributes.Site#')
<cfif Attributes.TopLevMenu EQ -1>
AND (Menu_Struct.ParentItem IS NULL)
<cfelse>
AND (Menu_Struct.ParentItem IN ( SELECT Menu_Struct.ParentItem
FROM Sites INNER JOIN (Matchcodes INNER JOIN Menu_Struct
ON Matchcodes.MatchID = Menu_Struct.MatchID)
ON (Sites.SiteID = Menu_Struct.SiteID) AND (Sites.SiteID = Matchcodes.SiteID)
WHERE (Matchcodes.Matchcode = '#Attributes.Page#')
AND (Sites.SiteMatch = '#Attributes.Site#') )
)
</cfif>
ORDER BY Menu_Struct.MenuID
</cfquery>
</cfif>
<cfif SIHV_Query.RecordCount NEQ 0>
<cfoutput query="SIHV_Query">
#Attributes.Prefix#
<cfif #Attributes.Page# EQ #Matchcode#>
<cfif #Attributes.SelectedClass# EQ "">
#LinkText#
<cfelse>
<span class=#Attributes.SelectedClass#>#LinkText#</span>
</cfif>
<cfelse>
<cfif #External# EQ -1>
<a href="#URL#" target="_blank">#LinkText#</a>
<cfelse>
<a href="?Site=#SiteMatch#&Page=#Matchcode#&Sprache=#SpracheMatch#">#Link Text#</a>
</cfif>
</cfif>
#Attributes.Suffix#
</cfoutput>
</cfif>
Danke schon mal im Vorraus
__________________
Man muss doch nicht den Bach hinunter gehen ...
Runter schwimmen geht doch viel schneller
|