Advertisement
Guest User

fix to discarded stories

a guest
Sep 2nd, 2014
254
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.28 KB | None | 0 0
  1. // Replace the bloc of code in \\libs\link.php LINE 208 to 236:
  2.  
  3. if($this->id===0) {
  4.  
  5.     if(buries_to_spam == 0) {
  6.    
  7.         $sql = "INSERT IGNORE INTO " . table_links . " (link_author, link_randkey, link_category, link_date, link_published_date, link_votes, link_karma, link_title, link_content ,link_group_id) VALUES ($link_author, $link_randkey, $link_category, FROM_UNIXTIME($link_date), FROM_UNIXTIME($link_published_date), $link_votes, $link_karma, '', '',$link_group_id)";
  8.     } else {
  9.         $sql = "INSERT IGNORE INTO " . table_links . " (link_author, link_status, link_randkey, link_category, link_date, link_published_date, link_votes, link_karma, link_title, link_content ,link_group_id) VALUES ($link_author, '$link_status', $link_randkey, $link_category, FROM_UNIXTIME($link_date), FROM_UNIXTIME($link_published_date), $link_votes, $link_karma, '', '',$link_group_id)";
  10.     }
  11.        
  12.     if($this->debug == true){
  13.         echo '<hr>store_basic:Insert:' . $sql . '<hr>';
  14.     }
  15.     $db->query($sql);
  16.     $this->id = $db->insert_id;
  17. } else {
  18. // update
  19.     if(buries_to_spam == 0) {
  20.             $sql = "UPDATE " . table_links . " set `link_reports`=$link_reports, `link_comments`=$link_comments, link_author=$link_author, link_status='$link_status', link_randkey=$link_randkey, link_category='$link_category', link_modified=NULL, link_date=FROM_UNIXTIME($link_date), link_published_date=FROM_UNIXTIME($link_published_date), link_votes=$link_votes, link_karma=$link_karma, link_group_id=$link_group_id WHERE link_id=$this->id";
  21.                 } else {
  22.              $sql = "UPDATE " . table_links . " set `link_reports`=$link_reports, `link_comments`=$link_comments, link_author=$link_author, link_randkey=$link_randkey, link_category='$link_category', link_modified=NULL, link_date=FROM_UNIXTIME($link_date), link_published_date=FROM_UNIXTIME($link_published_date), link_votes=$link_votes, link_karma=$link_karma, link_group_id=$link_group_id WHERE link_id=$this->id";
  23.                 }
  24.  
  25.     if($this->debug == true){
  26.         echo '<hr>store_basic:Update:' . $sql . '<hr>';
  27.     }
  28.     $db->query($sql);
  29.  
  30.     $db->query("DELETE FROM ".table_additional_categories." WHERE ac_link_id={$this->id}");
  31. }
  32.  
  33. // WITH this code:
  34.  
  35. if($this->id===0) {
  36.  
  37.     $sql = "INSERT IGNORE INTO " . table_links . " (link_author, link_status, link_randkey, link_category, link_date, link_published_date, link_votes, link_karma, link_title, link_content ,link_group_id) VALUES ($link_author, '$link_status', $link_randkey, $link_category, FROM_UNIXTIME($link_date), FROM_UNIXTIME($link_published_date), $link_votes, $link_karma, '', '',$link_group_id)";
  38.        
  39.     if($this->debug == true){
  40.         echo '<hr>store_basic:Insert:' . $sql . '<hr>';
  41.     }
  42.     $db->query($sql);
  43.     $this->id = $db->insert_id;
  44. } else {
  45. // update
  46.     $sql = "UPDATE " . table_links . " set `link_reports`=$link_reports, `link_comments`=$link_comments, link_author=$link_author, link_status='$link_status', link_randkey=$link_randkey, link_category='$link_category', link_modified=NULL, link_date=FROM_UNIXTIME($link_date), link_published_date=FROM_UNIXTIME($link_published_date), link_votes=$link_votes, link_karma=$link_karma, link_group_id=$link_group_id WHERE link_id=$this->id";
  47.  
  48.     if($this->debug == true){
  49.         echo '<hr>store_basic:Update:' . $sql . '<hr>';
  50.     }
  51.     $db->query($sql);
  52.  
  53.     $db->query("DELETE FROM ".table_additional_categories." WHERE ac_link_id={$this->id}");
  54. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement