require “UpdateDB.php”;
$RemoteAddr = $_SERVER[‘REMOTE_ADDR’];
$HttpReferer = $_SERVER[‘HTTP_REFERER’];
$HttpUserAgent = $_SERVER[‘HTTP_USER_AGENT’];
$RemoteHost = $_SERVER[‘REMOTE_HOST’];
$Border_Color = Get_Border_Color();
$column_gap = Get_Column_Gap();
$DomainName = Get_DomainName();
$Border_Thickness = Get_Border_Thickness();
$link_color = Get_LinkColor();
$visited_color = Get_VisitedColor();
$hover_color = Get_HoverColor();
$active_color = Get_ActiveColor();
$helpdesk_email = Get_Helpdesk_Email();
$administrator_email = Get_Administrator_Email();
$program_admin = Get_ProgramAdmin_Email();
$Uploads_URL = Get_Uploads_URL();
$path_from_root_to_CSU = Get_path_from_root_to_CSU();
$path_from_root_to_uploads = Get_path_from_root_to_uploads();
$full_path_to_uploads = $DomainName . $path_from_root_to_uploads;
$this_ = Get_this_();
$Server_Root = Get_Server_Path();
$here_ = Get_here_();
$Num_Columns = Get_Link_Option();
date_default_timezone_set(‘America/Regina’);
$DateTime = date(‘Y-m-d h:i:s’, time());
$SchoolID = 0; $CommunityID = 0;$uploads_folder_name = “uploads”;
$this_ = $DomainName . “wp-content/plugins/csut/csut.php”;
$isBlankBrowser = “_blank”;
$event = “DRAWPAGE”;
$url = strval( $_SERVER[‘QUERY_STRING’] );
$parts = explode(“?”, $url);
$parts2 = explode(“&”, $parts[0]);
for ($i=0; $i<=count($parts2) – 1; $i++) { $tmp = explode(“=”, $parts2[$i]); $temp = $tmp[1]; $temp = str_replace(‘%20’, ‘ ‘, $temp); $temp = str_replace(‘%2C’, ‘,’, $temp); $temp = str_replace(‘%2F’, ‘/’, $temp); $temp = str_replace(‘%3A’, ‘:’, $temp); $temp = str_replace(‘%40’, ‘@’, $temp); $temp = str_replace(‘+’, ‘ ‘, $temp); switch (strtoupper($tmp[0])) { case “ADD_TO_DB”: $event = “Insert_TO_DB”; break; case “DFN”: $event = “Get_File”; $FileID = $temp; break; case “COMMUNITY”: $CommunityID = $temp; break; case “SCHOOLS”: $SchoolID = $temp; break; case “FILEID”: $CSU_Tobacco_ID = $temp; break; case “LIST”: $event = “DRAWPAGE”; break; } } switch ($event) { case “DRAWPAGE”: Draw_Page(); break; case “Get_File”: Display_Dialog(); break; case “Insert_TO_DB”: $MyDocInfo = Read_CSU_Tobacco_by_ID($CSU_Tobacco_ID); $myFN = $MyDocInfo[“FileFullURL”]; $Ext = explode(“.”, $myFN); $myFilenametmp = explode(“/”, $myFN); $myFilename = $myFilenametmp[count($myFilenametmp)-1]; $Mime = Get_Mime_by_Ext($Ext[count($Ext)-1]); $HeaderStr = “\”Content-Type: ” . $Mime . “\””; $FilePath = $Server_Root . $myFilename; $myFNtmp = explode(“/”, $myFN); $FileNameBaseTmp = explode(“.”, $myFilename); $ContentLength = filesize($FilePath); if (file_exists($FilePath)) { header(‘Content-Description: File Transfer’); header($HeaderStr); header(‘Content-Disposition: attachment; filename=”‘ . $myFilename . ‘”‘); // header(‘Expires: 0’); header(‘Cache-Control: must-revalidate, post-check=0, pre-check=0’); header(‘Pragma: public’); header(‘Content-Length: ‘ . $ContentLength); readfile($FilePath); Insert_CSU_Tobacco_Stats($CSU_Tobacco_ID, $RemoteAddr, $HttpReferer, $HttpUserAgent, $RemoteHost, $SchoolID, $CommunityID, $DateTime); } else { echo “no such file”; exit; } break; } exit; function Draw_Page() { global $this_, $Num_Columns, $link_color, $visited_color, $hover_color, $active_color; $Num_Columns = 0; $TFiles11 = array();$TFiles12 = array();$TFiles13 = array();$TFiles14 = array(); $TFiles21 = array();$TFiles22 = array();$TFiles23 = array();$TFiles24 = array(); $TFiles31 = array();$TFiles32 = array();$TFiles33 = array();$TFiles34 = array(); $TFiles41 = array();$TFiles42 = array();$TFiles43 = array();$TFiles44 = array(); $AllFiles = Read_CSU_Tobacco_All(); foreach ($AllFiles as $AFile) { $AFile[‘FileFullURL’] = str_replace(chr(45), ‘-‘, $AFile[‘FileFullURL’]); $AFile[‘FileName_Display’] = str_replace(chr(45), ‘-‘, $AFile[‘FileName_Display’]); $AFile[‘FileName_Display’] = str_replace(chr(39), ‘\”, $AFile[‘FileName_Display’]); $cat = Read_CSU_Category_by_ID1($AFile[‘CategoryID’]); switch ($cat[‘ColumnNum’]) { case “1”: if ($cat[‘SortOrder’] == 1) { $Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles11, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 2)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles12, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 3)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles13, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 4)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles14, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
break;
case “2”:
if ($cat[‘SortOrder’] == 1)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles21, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 2)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles22, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 3)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles23, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 4)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles24, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
break;
case “3”:
if ($cat[‘SortOrder’] == 1)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles31, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 2)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles32, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 3)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles33, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 4)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles34, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
break;
case “4”:
if ($cat[‘SortOrder’] == 1)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles41, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 2)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles42, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 3)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles43, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
if ($cat[‘SortOrder’] == 4)
{
$Added_Stuff = array(“SortOrder” => $cat[‘SortOrder’], “ColumnNum” => $cat[‘ColumnNum’], “Category” => $cat[‘Category’]);
$AFile = array_merge($AFile, $Added_Stuff);array_push($TFiles44, $AFile);
if ($cat[‘SortOrder’] > $Num_Columns) { $Num_Columns = $cat[‘SortOrder’]; }
}
break;
}
}
$Col_Percent = intval(100 / $Num_Columns)-1;
echo ” . “\r\n”;
echo ” . “\r\n”;echo ” . “\r\n”;
echo ” . “\r\n”;
echo ” . “\r\n”;
echo ” . “\r\n”;
echo ‘
‘ . “\r\n”;
echo ‘‘ . “\r\n”;
echo ” . “\r\n”;
echo ” . “\r\n”;
echo ‘
if (count($TFiles11) > 0)
{
echo ‘
if (count($TFiles11) > 0) { Draw_Links($TFiles11); }
if (count($TFiles12) > 0) { Draw_Links($TFiles12); }
if (count($TFiles13) > 0) { Draw_Links($TFiles13); }
if (count($TFiles14) > 0) { Draw_Links($TFiles14); }
echo ‘
‘ . “\r\n”;
}
if (count($TFiles21) > 0)
{
echo ‘
if (count($TFiles21) > 0) { Draw_Links($TFiles21); }
if (count($TFiles22) > 0) { Draw_Links($TFiles22); }
if (count($TFiles23) > 0) { Draw_Links($TFiles23); }
if (count($TFiles24) > 0) { Draw_Links($TFiles24); }
echo ‘
‘ . “\r\n”;
}
if (count($TFiles31) > 0)
{
echo ‘
if (count($TFiles31) > 0) { Draw_Links($TFiles31); }
if (count($TFiles32) > 0) { Draw_Links($TFiles32); }
if (count($TFiles33) > 0) { Draw_Links($TFiles33); }
if (count($TFiles34) > 0) { Draw_Links($TFiles34); }
echo ‘
‘ . “\r\n”;
}
if (count($TFiles41) > 0)
{
echo ‘
if (count($TFiles41) > 0) { Draw_Links($TFiles41); }
if (count($TFiles42) > 0) { Draw_Links($TFiles42); }
if (count($TFiles43) > 0) { Draw_Links($TFiles43); }
if (count($TFiles44) > 0) { Draw_Links($TFiles44); }
echo ‘
‘ . “\r\n”;
}
echo ‘
‘ . “\r\n”;
echo ” . “\r\n”;
echo ” . “\r\n”;
}
function Draw_Links($myTFiles)
{
global $Num_Columns, $DomainName, $full_path_to_uploads;
echo ‘
‘ . $myTFiles[0][‘Category’] . ‘
‘ . “\r\n”;
$column_number = $myTFiles[0][‘ColumnNum’];
$Sort_Order = $myTFiles[0][‘SortOrder’];
foreach ($myTFiles as $myFile)
{
if (count($myFile) > 1)
{
if (strtoupper(substr($myFile[‘FileFullURL’], 0, 4)) == “HTTP”)
{
if ($myFile[‘Add_Eval_Link’] == 1)
{
echo ‘ ‘ . $myFile[‘FileName_Display’] . ‘
‘ . “\r\n”;
} else {
echo ‘‘ . $myFile[‘FileName_Display’] . ‘
‘ . “\r\n”;
}
} else {
if ($myFile[‘Skip_Tracking’] == 1)
{
echo ‘‘ . $myFile[‘FileName_Display’] . ‘
‘ . “\r\n”;
} else {
echo ‘ ‘ . $myFile[‘FileName_Display’] . ‘
‘ . “\r\n”;
}
}
if ($myFile[‘CR_After’] == 1) { echo ”
“; }
}
}
}
function Display_Dialog()
{
global $FileID, $this_;
echo ‘
‘ . “\r\n”;
echo ‘
echo ‘
$myFileInfo = Read_CSU_Tobacco_by_ID($FileID);
$MyCat = Read_CSU_Category_by_ID($myFileInfo[‘CategoryID’]);
echo ” . “\r\n”;echo ” . “\r\n”;echo ” . “\r\n”;
echo ” . “\r\n”;
echo ” . “\r\n”;
echo ” . “\r\n”;
echo ‘ File Name: ‘ . “\r\n”;
echo ” . “\r\n”;
echo ” . “\r\n”;
echo ‘ ‘ . $myFileInfo[‘FileFullURL’] . “\r\n”;
echo ” . “\r\n”;
echo ” . “\r\n”;
echo ” . “\r\n”;echo ” . “\r\n”;
echo ‘ Description: ‘ . “\r\n”;
echo ” . “\r\n”;
echo ” . “\r\n”;
echo ‘ ‘ . $myFileInfo[‘FileName_Display’] . “\r\n”;
echo ” . “\r\n”;
echo ” . “\r\n”;
echo ‘
‘ . “\r\n”; echo ‘ Category: ‘ . “\r\n”; echo ‘ |
‘ . “\r\n”; echo ‘ ‘ . $MyCat[‘Category’] . “\r\n”; echo ‘ |
‘ . “\r\n”;
echo ‘
‘ . “\r\n”;
echo ‘For whom are you downloading this document,
a community or school? (choose one)
‘ . “\r\n”;
echo ‘
‘ . “\r\n”;
echo ‘
‘ . “\r\n”;
echo ‘
‘ . “\r\n”;
}
?>