\n"; $out .= "
"varchar", "artic_pub_id"=>"FK_{$country}", "artic_link"=>"varchar", "artic_img_src"=>"varchar"); $textDisplayValue= array("artict_artic_name"); if(!isset($_GET['op']) && !isset($_GET['ins']) && !isset($_GET['upd'])){ require_once("../controlPanel/includes/fNavigation.php"); if(count($_REQUEST) > 0){ if(isset($_REQUEST['rowscount'])){ $displayRowsCount = $_REQUEST['rowscount']; } if(isset($_REQUEST['pagenumber'])){ } } if(isset($_GET['n']) && isset($_GET['c'])){ $displayRowsCount = $_GET['c']; $pageNumber = $_GET['n']; } initializeNavigation($displayRowsCount, $pageNumber, "article", "article_text", "artic_id", "artict_artic_id", "artict_lan_id", $displayValue, $textDisplayValue,"../controlPanel/article.php", "", ""); }else if(isset($_GET['op']) && !isset($_GET['ins']) && !isset($_GET['upd'])){ $op = $_GET['op']; $message = "\n"; if(isset($_GET['msg'])){$message = $_GET['msg'];} if($op == 1){ echo printInsertForm($message ); }else if($op == 2){ $updatID = -1; if(isset($_GET['id'] )){ $updatID = $_GET['id']; } echo printUpdatetForm($message , $updatID); } }else if(isset($_GET['ins']) && !isset($_GET['op']) && !isset($_GET['upd'])){ $ins = $_GET['ins']; if($ins == -1){ insertCernter(); } }else if(isset($_GET['upd']) && !isset($_GET['ins']) && !isset($_GET['op']) ){ $upd = $_GET['upd']; updateCenter($upd); } $out = "\n"; $out .= "
\n"; $out .= "

المقالات

\n"; $out .= "
\n"; $out .= "
\n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; //Publication field. $out .= " \n"; $out .= " "; $out .= " \n"; $out .= " \n"; $out .= " \n"; //Publication Link. $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; //Publication image $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; //Publication date field. $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; echo $out; $out = "\n"; $langState = "SELECT lan_id, lan_name FROM languages"; $langResult = mysql_query($langState); $colorCoutner = 1; while($lng = mysql_fetch_array($langResult)){ $colorCoutnerResult = $colorCoutner / 2; $rowColor = "#89C0ED"; if(!strstr($colorCoutnerResult, '.')){ $rowColor = "#FFF"; } echo " \n"; echo " \n"; echo " \n"; echo " \n";// echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $colorCoutner++; } echo "
   
 
  ".$result." 
\n"; $out .= " "; $out .= " \n"; $out .= " \n"; $out .= " :المنشور
\n"; $out .= " :رابط المقالة
\n"; $out .= " :صورة
\n"; $out .= " \n"; $out .= " \n"; $out .= " :تاريخ المقالة
  
  
\n"; echo " \n"; echo " عنوان المقالة{$lng['lan_name']}
\n"; printEditor($lng['lan_id']); echo " \n"; echo " تفاصيل المقالة
\n"; echo "


\n"; echo "
\n"; echo "\n"; return $out; } //insertCenter Function. function insertCernter(){ $message = ""; $target = "../controlPanel/imgs/pressarticle/"; if (is_uploaded_file($HTTP_POST_FILES['image']['tmp_name'])) { copy($HTTP_POST_FILES['image']['tmp_name'], $target); } else { $message = "Possible file upload attack. Filename: " . $HTTP_POST_FILES['image']['name'];} /*$target = $target.basename($HTTP_POST_FILES['image']['name']) ; if(move_uploaded_file($HTTP_POST_FILES['image']['tmp_name'], $target)) { $message .= "The file ". basename( $HTTP_POST_FILES['image']['name']). " has been uploaded"; } else { $message .= "Sorry, there was a problem uploading your file."; }*/ $date = $_REQUEST['text_field']; $link = $_REQUEST['link']; $img = $_REQUEST['uloadimage']; $publication = $_REQUEST['publication']; $insertStatement = "INSERT INTO article (artic_date, artic_pub_id, artic_link, artic_img_src) VALUES ('$date', $publication, '$link', '$img');\n"; $insertResult = mysql_query($insertStatement); //Check if Insert artic row finished successfully. if($insertResult){ //get the id of the inserted artic row. $idState = "SELECT MAX(artic_id) AS ID FROM article";//WHERE artic_date ='$date' AND artic_pub_id=$publication AND artic_link = '$link' AND artic_img_src = '$img' $idResult= mysql_query($idState); //Check select id result if there is a value or not. if($idResult){ $id = -1; while($arc = mysql_fetch_array($idResult)){ $id = $arc['ID']; } //In case $id biger than -1 if($id > -1){ //Ini select languages table statement. $langState = "SELECT lan_id, lan_name FROM languages\n"; $langResult = mysql_query($langState); while($lng = mysql_fetch_array($langResult)){ include_once("../controlPanel/includes/constants.php"); $detials = ARTICLE_PATH.$id."_".$lng['lan_id'].".txt"; $file = fopen($detials, 'w'); if($file != false){ $fileData = $_REQUEST["rettxt_".$lng['lan_id']]; $writeFile = fwrite($file, $fileData); if($writeFile != false){ $address = $_REQUEST["address_".$lng['lan_id']]; $centerText = "INSERT INTO article_text (artict_artic_id, artict_lan_id, artict_artic_name, artict_file_name) ". "VALUES ($id, ".$lng['lan_id'].",'$address', '$detials')\n"; $textResult = mysql_query($centerText); }else { if($_REQUEST["rettxt_".$lng['lan_id']] != null && $_REQUEST["rettxt_".$lng['lan_id']] != "" ){ $message .= "can't write to file ".$detials."
\n"; } } fclose($file); }else {$message .= "can't open file ".$detials."
\n";} } if($message == null && $message == "")$message .= "تمت عملية الحفظ بنجاح"; }else {$message .= "فشلت عملية الحفظ, Can't find artic_id value";} }else {$message .= "فشلت عملية الحفظ,
Can't insert master row";} header("location: ../controlPanel/article.php?op=1&msg=".$message); } else {header("location: ../controlPanel/article.php?op=1&msg=".$message."
".mysql_error()."
");} } //printUpdatetForm Function. function printUpdatetForm($result, $id){ $centerState = "SELECT * FROM centers WHERE cen_id = ".$id; $centerResult = mysql_query($centerState); $out = "\n"; //$centerRowsNumber =mysql_num_rows($centerResult); if($centerResult){ $country = -1; $city = -1; $phone1 = "\n"; $phone2 = "\n"; $fax = "\n"; $mailBox = "\n"; $email = "\n"; $img = "\n"; while($center = mysql_fetch_array($centerResult)){ $country = $center['cen_nation_id']; $city = $center['cen_city_id']; $phone1 = $center['cen_phone_number1']; $phone2 = $center['cen_phone_number2']; $fax = $center['cen_fax']; $mailBox = $center['cen_mailbox']; $email = $center['cen_email']; $img = $center['cen_img']; } $out = "
\n"; $out .= "
\n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n";//onchange=\"preview(this)\" id=\"picField\" $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $langState = "SELECT lan_id, lan_name FROM languages\n"; $langResult = mysql_query($langState); $colorCoutner = 1; while($lng = mysql_fetch_array($langResult)){ $colorCoutnerResult = $colorCoutner / 2; $rowColor = "#89C0ED\n"; if(!strstr($colorCoutnerResult, '.')){ $rowColor = "#FFF\n"; } $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $colorCoutner++; } $out .= "
   
 "."".$result." 
\n"; //Prepare city and country array to assign then to sortCity function in javascript. ?> \n"; $cityResult = mysql_query($cityState); while($row = mysql_fetch_array($cityResult)){ if($row['city_id'] == $city){ $out .= "\n"; }else {$out .= "\n";} } $out .= " \n"; $out .= " :المدينة\n"; $out .= " \n"; $out .= " :الدولة
\n"; $out .= " :هاتف رقم 1
\n"; $out .= " :هاتف رقم 2
\n"; $out .= " :فاكس
\n"; $out .= " :صندوق بريد
\n"; $out .= " :بريد إلكتروني
\n"; $out .= " صورة
  
  
العنواناللغة
\n"; $out .= " \n"; $out .= " {$lng['lan_name']}
\n"; $out .= "


\n"; $out .= "
\n"; $out .= "
\n"; $out .= "
صورة المركز
\n"; require_once("../controlPanel/includes/constants.php"); $out .= "\n"; $out .= "
\n"; }else {$out = "No Rows Founded.
id=".$id;} return $out; } //updateCenter Function. function updateCenter($id){ $country = $_REQUEST['country']; $city = $_REQUEST['city']; $phone1 = $_REQUEST['phone1']; $phone2 = $_REQUEST['phone1']; $fax = $_REQUEST['fax']; $mailbox = $_REQUEST['mailbox']; $email = $_REQUEST['email']; $img = $_REQUEST['uploaded']; $updateStatement = "UPDATE centers SET cen_nation_id = $country , cen_city_id = $city, cen_phone_number1 = '$phone1', ". " cen_phone_number2 = '$phone2', cen_fax = '$fax', cen_mailbox = '$mailbox', cen_email = '$email', cen_img = '$img' WHERE ". " cen_id=$id\n"; $updateResult = mysql_query($updateStatement); $message = "\n"; if($updateResult){ $langState = "SELECT lan_id FROM languages\n"; $langResult = mysql_query($langState); $textCounter = 0 ; while($lng = mysql_fetch_array($langResult)){ $value = $_REQUEST["address_".$lng['lan_id']]; $centerText = "UPDATE centers_text SET centxt_value='$value' WHERE centxt_cen_id=$id AND centxt_lan_id=".$lng['lan_id']; $textResult = mysql_query($centerText); if(!$textResult)$textResult++; } if($textCounter > 0) $message .= "تمت علمية التحديث بنجاح, لكن هناك عملية أو أكثر في التفاصيل لم تنجح.\n"; else {$message .= "تمت عملية التعديل بنجاح.\n";} header("location:../controlPanel/article.php?op=2&id=".$id."&msg=".$message); }else {header("location:../controlPanel/article.php?op=2&id=$id&msg=".$message);} } //printDelete Function. function printDelete($ids){ $out = "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "


إذا أردت الإستمرار في عملية الحذف اضغط على الزر موافق, وإذا أردت التراجع إضغط على زر إلغاء الأمر

\n"; $out .= "\n"; $out .= "
\n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= "\n"; $out .= "\n"; $out .= "
\n"; $out .= "\n"; $out .= "\n"; $out .= "
\n"; return $out; } //printSuccessfulDelete Function. function printSuccessfulDelete(){ $out = "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "


.تمت عملية الحذف بنجاح

\n"; $out .= "\n"; $out .= "
\n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= "\n"; $out .= "\n"; $out .= "
\n"; return $out; } //printFailureDelete Function. function printFailureDelete($msg){ $out = "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "\n"; $out .= "


.فشلت عملية الحذف
{$msg}

\n"; $out .= "\n"; $out .= "
\n"; $out .= " \n"; $out .= " \n"; $out .= " \n"; $out .= "\n"; $out .= "\n"; $out .= "
\n"; return $out; } //deleteCenter function. function deleteCenter($ids){ $ids = rtrim($ids); $ids = ltrim($ids); $splitedIDS = split("_", $ids); foreach($splitedIDS as $myid){ if($myid != null && $myid != "" && $myid != " "){ $array .= $myid."
\n"; $result = true; $deleteTextState = "DELETE FROM centers_text WHERE centxt_cen_id =".$myid; $deleteTextResult = mysql_query($deleteTextState); if($deleteTextResult){ $deletCenterState = "DELETE FROM centers WHERE cen_id=".$myid; $deleteCenterResult = mysql_query($deletCenterState); if(!$deleteCenterResult){ $result = false; } }else { $result = false; } } } if($result){ header("location:../controlPanel/article.php?delete=1"); }else if(!$result){ header("location:../controlPanel/article.php?delete=0&msg=".mysql_errno());// } } //printEditor Function function printEditor($langID){ $out = "\n"; echo "\n"; return $out; } ?>