Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Replace the bloc of code in \\libs\link.php LINE 208 to 236:
- if($this->id===0) {
- if(buries_to_spam == 0) {
- $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)";
- } else {
- $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)";
- }
- if($this->debug == true){
- echo '<hr>store_basic:Insert:' . $sql . '<hr>';
- }
- $db->query($sql);
- $this->id = $db->insert_id;
- } else {
- // update
- if(buries_to_spam == 0) {
- $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";
- } else {
- $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";
- }
- if($this->debug == true){
- echo '<hr>store_basic:Update:' . $sql . '<hr>';
- }
- $db->query($sql);
- $db->query("DELETE FROM ".table_additional_categories." WHERE ac_link_id={$this->id}");
- }
- // WITH this code:
- if($this->id===0) {
- $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)";
- if($this->debug == true){
- echo '<hr>store_basic:Insert:' . $sql . '<hr>';
- }
- $db->query($sql);
- $this->id = $db->insert_id;
- } else {
- // update
- $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";
- if($this->debug == true){
- echo '<hr>store_basic:Update:' . $sql . '<hr>';
- }
- $db->query($sql);
- $db->query("DELETE FROM ".table_additional_categories." WHERE ac_link_id={$this->id}");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement