[Summary view] [Print] [Text view]

   1  <?php
   2  session_start();
   3  include_once  'include.php';
   4  
   5  $user = User :: GetInstance($_SESSION["user"]);
   6  $smarty = new My_Smarty();
   7  $smarty->assign('user', $user);
   8  //envoie le message si message a envoyer     Petronius.12.04.2006
   9  if (isset ($_POST['submit']) && $_POST['submit'] == "Envoyer")   // c'est un nouveau message
  10      {
  11          $sql = new DBconnection();
  12          $vars = array (0 => $_POST['uid'], 1 => $user->GetId(),
  13                          2 => $_POST['subject'], 3 => $_POST['message'], 4 => date("Y-m-d H:i:s"));
  14          $result = $sql->query("post_pmessage", $vars);
  15          $sql->close();
  16          $smarty->assign('newmsg_posted', translate("newmsg_posted"));
  17      }
  18  if (isset ($_POST['Effacer_x']))   // c'est une reponse
  19      {
  20          $sql = new DBconnection();
  21          $vars = array (0 => $_POST['msg_id'],);
  22          $result = $sql->query("delete_pmessage", $vars);
  23          $sql->close();
  24          $smarty->assign('newmsg_posted', translate("newmsg_deleted"));    
  25      }
  26  if (isset ($_POST['submit']) && $_POST['submit'] == "Valider")
  27      {
  28          $sql = new DBconnection();
  29          $vars = array (0 => $_POST['pmsg_sender_id'], 1 => $user->GetId(),
  30                          2 => $_POST['subject_reply'], 3 => $_POST['reply'], 4 => date("Y-m-d H:i:s"));
  31          $result = $sql->query("post_pmessage", $vars);
  32          $sql->close();
  33          $smarty->assign('newmsg_posted', translate("newmsg_reply"));
  34      }
  35  
  36  //end
  37  
  38  
  39  
  40  
  41  $sql = new DBconnection();
  42  $vars = array (0 => $user->getId(),);
  43  $result = $sql->query("get_pmessages_of_user_id", $vars);
  44  $sql->close();
  45  
  46  for ($i = 0; $row = $result->fetchRow(); $i ++) {
  47      
  48      if ($i == 0) {
  49          $sql2 = new DBconnection();
  50          $vars2 = array (0 => $row[0],);
  51          $result2 = $sql2->query("mark_as_read_pmessage", $vars2);
  52          $sql2->close();    
  53      }
  54      
  55      $pmsg[$i]['pmsg_id'] = $row[0];
  56      $pmsg[$i]['pmsg_dest_id'] = $row[1];
  57      $pmsg[$i]['pmsg_sender_id'] = $row[2];
  58      $pmsg[$i]['pmsg_title'] = $row[3];
  59      $pmsg[$i]['pmsg_body'] = $row[4];
  60      $pmsg[$i]['pmsg_datetime'] = $row[5];
  61      $pmsg[$i]['pmsg_is_read'] = $row[6];
  62      $sql = new DBconnection();
  63      $vars = array (0 => $row[2],);
  64      $result2 = $sql->query("get_user", $vars);
  65      $sql->close();
  66      $tmp_row = $result2->fetchRow();
  67      $pmsg[$i]['sender_name'] = $tmp_row[1];
  68      $pmsg[$i]['sender_avatar'] = $tmp_row[12];
  69      $smarty->append("private_msg", $pmsg[$i]);
  70  }
  71  
  72  $myday = new Day($date);
  73  $WEEK_START = $user->get_week_start();
  74  $smarty->assign('title', "Message");
  75  $smarty->assign('first_day', $WEEK_START);
  76  $smarty->assign('calendar_day', $myday);
  77  $smarty->assign('mini_cal', create_small_month($myday));
  78  $smarty = generate_menu($smarty, $myday);
  79  
  80  $smarty->assign('msg_prives', "Messages priv&eacute;s");
  81  
  82  $smarty->assign('msgreply', "1");
  83  $smarty->assign('view_pmsg', "1");
  84  $smarty->display('viewpmsg.tpl');
  85  ?>