Cold Fusion & PHP

[Nonstop]

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#">#LinkText#</a>
</cfif>
</cfif>

#Attributes.Suffix#
</cfoutput>
</cfif>

Danke schon mal im Vorraus

[|Coding]

hmm also ich war nie für cold fusion :-)

da hätte der schreiberling des codes besser mal mitgesdacht und direkt php genommen.

ich mein ja nur. PHP RULEZ!! :-)

[Nonstop]

der schreiber war mein chef und er hatt aus dem grund cold fusion genommen weil wir einen Server dafür haben und ihn testen wollten und für das PHP bin ich zuständig und soll es jetzt halt mal umschreiben