/** * Add a new Term and Condition * @param int language id * @param string the content * @param int term and condition type (0 or 1) * @param string explain changes * @return boolean sucess */ public static function add($language, $content, $type, $changes) { $legal_table = Database::get_main_table(TABLE_MAIN_LEGAL); $last = self::get_last_condition($language); $language = Database::escape_string($language); $content = Database::escape_string($content); $type = intval($type); $changes = Database::escape_string($changes); $time = time(); if ($last['content'] != $content) { $version = intval(LegalManager::get_last_condition_version($language)); $version++; $sql = "INSERT INTO {$legal_table}\n\t\t\t\t\t\tSET language_id = '" . Database::escape_string($language) . "',\n\t\t\t\t\t\t\tcontent = '" . $content . "',\n\t\t\t\t\t\t\tchanges= '" . $changes . "',\n\t\t\t\t\t\t\ttype = '" . $type . "',\n\t\t\t\t\t\t\tversion = '" . Database::escape_string($version) . "',\n\t\t\t\t\t\t\tdate = '" . $time . "'"; $result = Database::query($sql); return true; } elseif ($last['type'] != $type && $language == $last['language_id']) { //update $id = $last['legal_id']; $sql = "UPDATE {$legal_table}\n\t\t\t\t\tSET changes= '" . $changes . "',\n\t\t\t\t\ttype = '" . $type . "',\n\t\t\t\t\tdate = '" . $time . "'\n\t\t\t\t\tWHERE legal_id= {$id} "; $result = Database::query($sql); return true; } else { return false; } }
/** * Add a new Term and Condition * @param int $language language id * @param string $content content * @param int $type term and condition type (0 or 1) * @param string $changes explain changes * @return boolean success */ public static function add($language, $content, $type, $changes) { $legal_table = Database::get_main_table(TABLE_MAIN_LEGAL); $last = self::get_last_condition($language); $type = intval($type); $time = time(); if ($last['content'] != $content) { $version = intval(LegalManager::get_last_condition_version($language)); $version++; $params = ['language_id' => $language, 'content' => $content, 'changes' => $changes, 'type' => $type, 'version' => intval($version), 'date' => $time]; Database::insert($legal_table, $params); return true; } elseif ($last['type'] != $type && $language == $last['language_id']) { //update $id = $last['legal_id']; $params = ['changes' => $changes, 'type' => $type, 'date' => $time]; Database::update($legal_table, $params, ['legal_id => ?' => $id]); return true; } else { return false; } }