Example #1
0
 public static function Create($name, $description = null, $category = null, $user = null)
 {
     if ($user == null) {
         $user = User::GetCurrent();
     }
     if ($user == null) {
         return null;
     }
     $query = "INSERT INTO phpmmo_storage_files (file_name, file_description, file_category_id, file_creation_member_id, file_creation_timestamp) VALUES (" . "'" . mysql_real_escape_string($name) . "', " . ($description == null ? "NULL" : "'" . mysql_real_escape_string($description) . "'") . ", " . ($category == null ? "NULL" : $category->ID) . ", " . $user->ID . ", " . "NOW()" . ")";
     $result = mysql_query($query);
     if (mysql_errno() != 0) {
         return null;
     }
     $query = "SELECT LAST_INSERT_ID();";
     $result = mysql_query($query);
     $values = mysql_fetch_array($result);
     $id = $values[0];
     if (mysql_errno() != 0) {
         return null;
     }
     if (!is_numeric($id)) {
         return null;
     }
     $value = File::GetByID($id);
     if (mysql_errno() != 0) {
         return null;
     }
     return $value;
 }