$v) ${$k} = $v; $months = array('01'=>'كانون2','02'=>'شباط','03'=>'آذار','04'=>'نيسان','05'=>'أيار','06'=>'حزيران', '07'=>'تموز','08'=>'آب','09'=>'أيلول','10'=>'تشرين1','11'=>'تشرين2','12'=>'كانون1'); include_once("admin/config.php"); mysql_connect($DBHost,$DBUser,$DBPass) or die(mysql_error()); mysql_select_db($DBName) or die(mysql_error()); $Year = $_GET['Y']; $subCatID = $_GET['subCatID']; $Or = $_GET['Or']; if ( !$Or ) $Or = 'SD'; if ($Or=="TD") { $Order = "Title DESC"; $TOr = "TA"; $SOr = "SA"; $COr = "CA"; } elseif ($Or=="SA") { $Order = "SDate"; $TOr = "TA"; $SOr = "SD"; $COr = "CA"; } elseif ($Or=="SD") { $Order = "SDate DESC"; $TOr = "TA"; $SOr = "SA"; $COr = "CA"; } elseif ($Or=="CA") { $Order = "CatID"; $TOr = "TA"; $SOr = "SD"; $COr = "CD"; } elseif ($Or=="CD") { $Order = "CatID DESC"; $TOr = "TA"; $SOr = "SA"; $COr = "CA"; } else { $Order = "Title"; $TOr = "TD"; $SOr = "SA"; $COr = "CA"; } $result = mysql_query("SELECT * FROM CoursesCats WHERE CatID='$CatID'") or die(mysql_error()); $row = mysql_fetch_row($result); $Category = stripslashes($row[0]); $CatDetails = stripslashes($row[1]); $ReqLogin = stripslashes($row[2]); $ReqAdmin = stripslashes($row[3]); $CatID = intval($row[4]); if ( $ReqLogin=='Y' || $LUID ) include("uauth.php"); include("head.php"); $NowYear = date("Y",time()); if ($Year >=$NowYear) $where = "(YEAR(SDate)=$Year OR YEAR(SDate)=0)"; else $where = "YEAR(SDate)=$Year "; $result = mysql_query("SELECT Count(*) FROM Courses WHERE CatID=$CatID AND subCatID=$subCatID AND $where AND Accepted='Y'") or die(mysql_error()); $row = mysql_fetch_row($result); $Crss = $row[0]; /* $query = "SELECT Value FROM Configs WHERE Name='ItemPerPage'"; $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_row($result); $ItemPerPage = $row[0]; $pgs = ceil($Crss/$ItemPerPage); if ( !$pg ) { $pg = 1; $_GET['pg']=1; } $nextpg = $pg+1; $prevpg = $pg-1; $end = $pg * $ItemPerPage; $start = $end - $ItemPerPage +1; if ( $end > $Crss ) $end = $Crss; */ $result = mysql_query("SELECT subCategory, subCatID FROM CoursessubCats WHERE subCatID='$subCatID'") or die(mysql_error()); $row = mysql_fetch_row($result); $subCategory = stripslashes($row[0]); $subCatID = stripslashes($row[1]); ?>
عودة  
"; if ($CatID) { ?> \n"; foreach ($_GET as $name => $value) { if ($name=="pg") $value--; echo "\n"; } echo "\n"; echo "\n"; foreach ($_GET as $name => $value) { if ($name=="pg") $value=1; echo "\n"; } echo "\n"; } if ( ($pg-5) >= 1 ) { echo "\n"; foreach ($_GET as $name => $value) { if ($name=="pg") $value-=5; echo "\n"; } echo "\n"; } if ( $pg != $pgs ) { echo "\n"; foreach ($_GET as $name => $value) { if ($name=="pg") $value++; echo "\n"; } echo "\n"; echo "\n"; foreach ($_GET as $name => $value) { if ($name=="pg") $value=$pgs; echo "\n"; } echo "\n"; } if ( ($pg+5) <= $pgs ) { echo "\n"; foreach ($_GET as $name => $value) { if ($name=="pg") $value+=5; echo "\n"; } echo "\n"; } ?>

محاضرات

"; echo"
الفئة المطلوبة : السنة المطلوبة :
إجمالي محاضرة
"?>الصفحة الاخيرة"?> "?>بعد خمس صفحات"?> "?>الصفحة التالية"?> "?>الصفحة السابقة"?> = 1 ) echo ""?>قبل خمس صفحات= 1) echo ""?> "?>الصفحة الاولى"?>
لديك سماحية إضافة دورة في هذه الصفحة من إدارة الموقع
 إضافة دورة
= $SDate ) $Started = 1; else $Started = 0; if ($NowDate >= $EDate ) $Fineshed = 1; else $Fineshed = 1; $result1 = mysql_query("SELECT CUID FROM CoursesUsers WHERE CrsID='$CrsID' AND UID='$LUID' AND Inst='N'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); $CrsStd = intval($row1[0]); $result1 = mysql_query("SELECT CUID FROM CoursesUsers WHERE CrsID='$CrsID' AND UID='$LUID' AND Inst='Y'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); $CrsInst = intval($row1[0]); $DetailsLines = explode("\n",$Details); $Details = ''; for ($kk=0;$kk<4;$kk++) $Details .= $DetailsLines[$kk]; //$Details = nl2br($Details); //$Details = mb_substr($Details,0,100); if (!$UID) $Submitter="مدير الموقع"; else { $result1 = mysql_query("SELECT Username,FirstName,LastName FROM Users WHERE UID='$UID'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); //$Submitter= " ".stripslashes($row1[0])." (".stripslashes($row1[1])." ".stripslashes($row1[2]).")"; $Submitter= " ".stripslashes($row1[0]); } $result1 = mysql_query("SELECT To_days( EDate ) - TO_DAYS( SDAte ) FROM Courses WHERE CrsID='$CrsID'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); $Duration = intval($row1[0]) + 1; $DateArr = explode(" ", $SDate); list($Y,$M,$D)= explode("-",$DateArr[0]); $SFinalDate = $D.'-'.$M.'-'.$Y; if ( !@checkdate($M,$D,$Y) ) { $SFinalDate = "(يتم تحديده لاحقاً)"; $Duration = "-"; } $DateArr = explode(" ", $EDate); list($Y,$M,$D)= explode("-",$DateArr[0]); $EFinalDate = $D.'-'.$M.'-'.$Y; if ( !@checkdate($M,$D,$Y) ) { $SFinalDate = "(يتم تحديده لاحقاً)"; $Duration = "-"; } $result1 = mysql_query("SELECT MIN(PID) FROM CoursesImgs WHERE CrsID='$CrsID'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); $PID = intval($row1[0]); $result1 = mysql_query("SELECT COUNT(*) FROM CoursesCmnts WHERE CrsID='$CrsID' AND Accepted='Y'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); $Comments = intval($row1[0]); $result1 = mysql_query("SELECT MAX(CmntID) FROM CoursesCmnts WHERE CrsID='$CrsID' AND Accepted='Y'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); $MAXCmntID = intval($row1[0]); $result1 = mysql_query("SELECT UID,Date FROM CoursesCmnts WHERE CmntID='$MAXCmntID'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); $MAXCmntUID = intval($row1[0]); $MAXCmntDate = $row1[1]; if (!$MAXCmntUID) $MAXCmntSub="مدير الموقع"; else { $result1 = mysql_query("SELECT Username,FirstName,LastName FROM Users WHERE UID='$MAXCmntUID'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); $MAXCmntSub= " ".stripslashes($row1[0]); } $MAXCmntDateArr = explode(" ", $MAXCmntDate); list($Y,$M,$D)= explode("-",$MAXCmntDateArr[0]); $MAXCmntDate = $D.'-'.$M.'-'.$Y; $result1 = mysql_query("SELECT COUNT(*) FROM CoursesUsers WHERE CrsID='$CrsID' AND Inst='Y' AND Accepted='Y'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); $Insts = intval($row1[0]); $result1 = mysql_query("SELECT COUNT(*) FROM CoursesUsers WHERE CrsID='$CrsID' AND Inst='N' AND Accepted='Y'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); $Stds = intval($row1[0]); $result1 = mysql_query("SELECT COUNT(*) FROM CoursesCmnts WHERE CrsID='$CrsID' AND Accepted='N'") or die(mysql_error()); $row1 = mysql_fetch_row($result1); $Comments4V = intval($row1[0]); if ( $SFinalDate == "(يتم تحديده لاحقاً)" OR $SDate >= $NowDate ) $tbl_rslt_nd .= ""; else $tbl_rslt .= ""; } $tbl_rslt = $tbl_rslt_nd.$tbl_rslt; echo $tbl_rslt; ?>
رقم اسم المحاضرة المدة
( يوم )		 تاريخ التنفيذ
$CrsCntr
$Title
 $Duration$SFinalDate
$CrsCntr
$Title
 $Duration$SFinalDate