Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
u2_progc [2011-01-19 19:37]
Joakim Forsgren 		u2_progc [2011-01-21 11:11]
Joakim Forsgren
Line 33: Line 33:
 </php> </php>
  
 +<code php>
 +
 +// lite kod från forumController 
 +if($_POST['a']=='InsertItem') {
 +  if (!$_POST['Item']) {
 +    $session->AddError('You can\'t post empty item...');
 +    header ('location: ' . INDEX . '?c=' . $_GET['c'] . '&a=' . $_GET['a']);
 +    exit();
 +  }
 +  $data = array (
 +    'Item' => $_POST['Item'],
 +    'UserID' => $session->Get('UserID'),
 +    'ThreadID' => $_POST['ThreadID'] ,
 +    'CreateDate' => date('Y-m-j H:i:s'),
 +    'ChangeDate' => date('Y-m-j H:i:s')
 +  );
 +  $forum->InsertItem($data);
 +  $session->AddSuccess('Item saved!');
 +  header ('location: ' . INDEX . '?c=' . $_GET['c'] . '&a=' . $_GET['a'] . '&id=' . $_POST['ThreadID']);
 +  exit();
 +}
 +
 +// lite kod från forum.php (model_forum)
 +public function InsertItem ($data) {
 +  $this->table='lab5_Items';
 +  return $this->Insert($data);
 +}
 +
 +public function DeleteThread ($threadid) {
 +  $query = "DELETE lab5_Threads, lab5_Items FROM `lab5_Threads` LEFT JOIN `lab5_Items` USING(ThreadID) 
 +            WHERE ThreadID = '" . $_POST['ThreadID'] . "' 
 +            AND (lab5_Threads.UserID = '" . service_session::getInstance()->Get('UserID') . "' 
 +            OR " . service_session::getInstance()->Get('Admin') . ")";
 +  return $this->db->Delete($query);
 +}
 +
 +</code>