/** * Gets an array of Tags from the database, or NULL on failure. * @param TagSearchParameters $SearchParameters * @param string $OrderClause * @param string $LimitClause * @return array(Tag) | NULL */ public static function GetTags($SearchParameters = NULL, $OrderClause = 'tag_name ASC', $LimitClause = NULL) { global $dbi; $SearchParameters = $SearchParameters ? $SearchParameters : new TagSearchParameters(); $OrderClause = empty($OrderClause) ? 'tag_name ASC' : $OrderClause; $q = sprintf("\n\t\t\tSELECT\n\t\t\t\t`tag_id`, `tag_name`\n\t\t\tFROM\n\t\t\t\t`Tag`\n\t\t\tWHERE\n\t\t\t\tmut_deleted = -1\n\t\t\t\t%1\$s\n\t\t\tORDER BY\n\t\t\t\t%2\$s\n\t\t\t%3\$s", $SearchParameters->getWhere(), $OrderClause, $LimitClause ? ' LIMIT ' . $LimitClause : NULL); if (!($stmt = $dbi->prepare($q))) { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } DBi::BindParamsToSelect($SearchParameters, $stmt); if ($stmt->execute()) { $OutArray = array(); $stmt->bind_result($tag_id, $tag_name); while ($stmt->fetch()) { $o = new self($tag_id, $tag_name); $OutArray[] = $o; } $stmt->close(); return $OutArray; } else { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } }
/** * Gets an array of Videos from the database, or NULL on failure. * @param VideoSearchParameters $SearchParameters * @param string $OrderClause * @param string $LimitClause * @return Array(Video) | NULL */ public static function GetVideos($SearchParameters = NULL, $OrderClause = 'model_firstname ASC, model_lastname ASC, set_prefix ASC, set_name ASC, video_filename ASC', $LimitClause = NULL) { global $dbi; $SearchParameters = $SearchParameters ? $SearchParameters : new VideoSearchParameters(); $OrderClause = empty($OrderClause) ? 'model_firstname ASC, model_lastname ASC, set_prefix ASC, set_name ASC, video_filename ASC' : $OrderClause; $q = sprintf("\n\t\t\tSELECT\n\t\t\t\t`video_id`, `video_filename`, `video_fileextension`, `video_filesize`, `video_filechecksum`, `video_filecrc32`, \n\t\t\t\t`set_id`, `set_prefix`, `set_name`, `set_containswhat`,\n\t\t\t\t`model_id`, `model_firstname`, `model_lastname`\n\t\t\tFROM\n\t\t\t\t`vw_Video`\n\t\t\tWHERE\n\t\t\t\tmut_deleted = -1\n\t\t\t\t%1\$s\n\t\t\tORDER BY\n\t\t\t\t%2\$s\n\t\t\t%3\$s", $SearchParameters->getWhere(), $OrderClause, $LimitClause ? ' LIMIT ' . $LimitClause : NULL); if (!($stmt = $dbi->prepare($q))) { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } DBi::BindParamsToSelect($SearchParameters, $stmt); if ($stmt->execute()) { $OutArray = array(); $stmt->bind_result($video_id, $video_filename, $video_fileextension, $video_filesize, $video_filechecksum, $video_filecrc32, $set_id, $set_prefix, $set_name, $set_containswhat, $model_id, $model_firstname, $model_lastname); while ($stmt->fetch()) { $o = new self($video_id, $video_filename, $video_fileextension, $video_filesize, $video_filechecksum, $video_filecrc32, $set_id, $set_prefix, $set_name, $set_containswhat, $model_id, $model_firstname, $model_lastname); $OutArray[] = $o; } $stmt->close(); return $OutArray; } else { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } }
/** * Gets an array of CacheImages from the database, or NULL on failure. * @param $SearchParameters $SearchParameters * @param string $OrderClause * @param string $LimitClause */ public static function GetCacheImages($SearchParameters = NULL, $OrderClause = NULL, $LimitClause = NULL) { global $dbi; $SearchParameters = $SearchParameters ? $SearchParameters : new CacheImageSearchParameters(); $OrderClause = empty($OrderClause) ? 'index_id ASC, model_id ASC, set_id ASC, image_id ASC, video_id ASC' : $OrderClause; $q = sprintf("\n\t\t\tSELECT\n\t\t\t\t`cache_id`, `index_id`, `model_id`, `set_id`, `image_id`, `video_id`, `cache_imagewidth`, `cache_imageheight`, `index_sequence_number`, `index_sequence_total`\n\t\t\tFROM\n\t\t\t\t`CacheImage`\n\t\t\tWHERE\n\t\t\t\t1 = 1\n\t\t\t\t%1\$s\n\t\t\tORDER BY\n\t\t\t\t%2\$s\n\t\t\t%3\$s", $SearchParameters->getWhere(), $OrderClause, $LimitClause ? ' LIMIT ' . $LimitClause : NULL); if (!($stmt = $dbi->prepare($q))) { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } DBi::BindParamsToSelect($SearchParameters, $stmt); if ($stmt->execute()) { $OutArray = array(); $stmt->bind_result($cache_id, $index_id, $model_id, $set_id, $image_id, $video_id, $cache_imagewidth, $cache_imageheight, $index_sequence_number, $index_sequence_total); while ($stmt->fetch()) { $o = new self($cache_id, $index_id, $model_id, $set_id, $image_id, $video_id, $cache_imagewidth, $cache_imageheight, $index_sequence_number, $index_sequence_total); $OutArray[] = $o; } $stmt->close(); return $OutArray; } else { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } }
/** * Gets Tag2All records from the database or NULL on failure. * @param Tag2AllSearchParameters $SearchParameters * @param string $OrderClause * @return array(Tag2All) | NULL */ public static function GetTag2Alls($SearchParameters = NULL, $OrderClause = 'tag_name ASC') { global $dbi; $SearchParameters = $SearchParameters ? $SearchParameters : new Tag2AllSearchParameters(); $OrderClause = empty($OrderClause) ? 'tag_name ASC' : $OrderClause; $q = sprintf("\n\t\t\tSELECT\n\t\t\t\t`tag_id`, `tag_name`, `model_id`, `set_id`, `image_id`, `video_id`\n\t\t\tFROM\n\t\t\t\t`vw_Tag2All`\n\t\t\tWHERE\n\t\t\t\t1 = 1\n\t\t\t\t%1\$s\n\t\t\tORDER BY\n\t\t\t\t%2\$s", $SearchParameters->getWhere(), $OrderClause); if (!($stmt = $dbi->prepare($q))) { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } DBi::BindParamsToSelect($SearchParameters, $stmt); if ($stmt->execute()) { $OutArray = array(); $stmt->bind_result($tag_id, $tag_name, $model_id, $set_id, $image_id, $video_id); while ($stmt->fetch()) { $o = new self($tag_id, $tag_name, $model_id, $set_id, $image_id, $video_id); $OutArray[] = $o; } $stmt->close(); return $OutArray; } else { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } }
/** * Gets an array of Models from the database, or NULL on failure. * @param ModelSearchParameters $SearchParameters * @param string $OrderClause * @param string $LimitClause * @return array(Model) */ public static function GetModels($SearchParameters = NULL, $OrderClause = 'model_firstname ASC, model_lastname ASC', $LimitClause = NULL) { global $dbi; $SearchParameters = $SearchParameters ? $SearchParameters : new ModelSearchParameters(); $OrderClause = empty($OrderClause) ? 'model_firstname ASC, model_lastname ASC' : $OrderClause; $q = sprintf("\n\t\t\t\tSELECT\n\t\t\t\t\t`model_id`,`model_firstname`,`model_lastname`,`model_birthdate`,`model_remarks`,`model_setcount`, `model_firstset`, `model_lastset`\n\t\t\t\tFROM\n\t\t\t\t\t`vw_Model`\n\t\t\t\tWHERE\n\t\t\t\t\tmut_deleted = -1\t\n\t\t\t\t\t%1\$s\n\t\t\t\tORDER BY\n\t\t\t\t\t%2\$s\n\t\t\t\t%3\$s", $SearchParameters->getWhere(), $OrderClause, $LimitClause ? ' LIMIT ' . $LimitClause : NULL); if (!($stmt = $dbi->prepare($q))) { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } DBi::BindParamsToSelect($SearchParameters, $stmt); if ($stmt->execute()) { $OutArray = array(); $stmt->bind_result($model_id, $model_firstname, $model_lastname, $model_birthdate, $model_remarks, $model_setcount, $model_firstset, $model_lastset); while ($stmt->fetch()) { $o = new self($model_id, $model_firstname, $model_lastname, $model_birthdate, $model_remarks, $model_setcount, $model_firstset, $model_lastset); $OutArray[] = $o; } $stmt->close(); return $OutArray; } else { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } }
/** * Gets an array of Users from the database, or NULL on failure. * @param UserSearchParameters $SearchParameters * @param string $OrderClause * @param string $LimitClause * @return array(User) | NULL */ public static function GetUsers($SearchParameters = NULL, $OrderClause = 'user_lastname ASC, user_firstname ASC', $LimitClause = NULL) { global $dbi; $SearchParameters = $SearchParameters ? $SearchParameters : new UserSearchParameters(); $OrderClause = empty($OrderClause) ? 'user_lastname ASC, user_firstname ASC' : $OrderClause; $q = sprintf("\n\t\t\tSELECT\n\t\t\t\t`user_id`, `user_username`, `user_password`, `user_salt`,\n\t\t\t\t`user_firstname`, `user_insertion`, `user_lastname`, `user_email`,\n\t\t\t\t`user_gender`, `user_birthdate`,\n\t\t\t\t`user_datedisplayopts`, `user_imageview`, `user_language`, `user_rights`,\n\t\t\t\t`user_lastactive`, `user_lastlogin`, `user_prelastlogin`\n\t\t\tFROM\n\t\t\t\t`User`\n\t\t\tWHERE\n\t\t\t\tmut_deleted = -1\n\t\t\t\t%1\$s\n\t\t\tORDER BY\n\t\t\t\t%2\$s\n\t\t\t%3\$s", $SearchParameters->getWhere(), $OrderClause, $LimitClause ? ' LIMIT ' . $LimitClause : NULL); if (!($stmt = $dbi->prepare($q))) { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } DBi::BindParamsToSelect($SearchParameters, $stmt); if ($stmt->execute()) { $OutArray = array(); $stmt->bind_result($user_id, $user_username, $user_password, $user_salt, $user_firstname, $user_insertion, $user_lastname, $user_email, $user_gender, $user_birthdate, $user_datedisplayopts, $user_imageview, $user_language, $user_rights, $user_lastactive, $user_lastlogin, $user_prelastlogin); while ($stmt->fetch()) { // Unserialize the non-NULL value in the db, catch dev-time INT $user_rights = $user_rights && !is_numeric($user_rights) ? unserialize($user_rights) : array(); $o = new self($user_id, $user_username, $user_password, $user_salt, $user_firstname, $user_insertion, $user_lastname, $user_email, $user_gender, $user_birthdate, $user_datedisplayopts, $user_imageview, $user_language, $user_rights, $user_lastactive, $user_lastlogin, $user_prelastlogin); $OutArray[] = $o; } $stmt->close(); return $OutArray; } else { $e = new SQLerror($dbi->errno, $dbi->error); Error::AddError($e); return NULL; } }