Example #1
0
 /**
  * @param int $SingleID
  * @param array(int) $MultipleIDs
  * @param int $SingleSetID
  * @param array(int) $MultipleSetIDs
  * @param int $SingleModelID
  * @param array(int) $MultipleModelIDs
  * @param bool $OrAllMultipleIDs
  */
 public function __construct($SingleID = FALSE, $MultipleIDs = FALSE, $SingleSetID = FALSE, $MultipleSetIDs = FALSE, $SingleModelID = FALSE, $MultipleModelIDs = FALSE, $OrAllMultipleIDs = FALSE)
 {
     parent::__construct();
     if ($SingleID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleID;
         $this->where .= " AND video_id = ?";
     }
     if (is_array($MultipleIDs) && count($MultipleIDs) > 0 && !$OrAllMultipleIDs) {
         $this->paramtypes .= str_repeat('i', count($MultipleIDs));
         $this->values = array_merge($this->values, $MultipleIDs);
         $this->where .= sprintf(" AND video_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleIDs), '?')));
     }
     if ($SingleSetID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleSetID;
         $this->where .= " AND set_id = ?";
     }
     if (is_array($MultipleSetIDs) && count($MultipleSetIDs) > 0 && !$OrAllMultipleIDs) {
         $this->paramtypes .= str_repeat('i', count($MultipleSetIDs));
         $this->values = array_merge($this->values, $MultipleSetIDs);
         $this->where .= sprintf(" AND set_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleSetIDs), '?')));
     }
     if ($SingleModelID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleModelID;
         $this->where .= " AND model_id = ?";
     }
     if (is_array($MultipleModelIDs) && count($MultipleModelIDs) > 0 && !$OrAllMultipleIDs) {
         $this->paramtypes .= str_repeat('i', count($MultipleModelIDs));
         $this->values = array_merge($this->values, $MultipleModelIDs);
         $this->where .= sprintf(" AND model_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleModelIDs), '?')));
     }
     if ($OrAllMultipleIDs) {
         $pieces = array();
         if (is_array($MultipleIDs) && count($MultipleIDs) > 0) {
             $this->paramtypes .= str_repeat('i', count($MultipleIDs));
             $this->values = array_merge($this->values, $MultipleIDs);
             $pieces[] = sprintf("video_id IN ( %1s )", implode(', ', array_fill(0, count($MultipleIDs), '?')));
         }
         if (is_array($MultipleSetIDs) && count($MultipleSetIDs) > 0) {
             $this->paramtypes .= str_repeat('i', count($MultipleSetIDs));
             $this->values = array_merge($this->values, $MultipleSetIDs);
             $pieces[] = sprintf("set_id IN ( %1s )", implode(', ', array_fill(0, count($MultipleSetIDs), '?')));
         }
         if (is_array($MultipleModelIDs) && count($MultipleModelIDs) > 0) {
             $this->paramtypes .= str_repeat('i', count($MultipleModelIDs));
             $this->values = array_merge($this->values, $MultipleModelIDs);
             $pieces[] = sprintf("model_id IN ( %1s )", implode(', ', array_fill(0, count($MultipleModelIDs), '?')));
         }
         if ($pieces) {
             $this->where .= " AND (";
             $this->where .= implode(' OR ', $pieces);
             $this->where .= ")";
         }
     }
 }
Example #2
0
 /**
  * @param string $SingleID
  * @param array(string) $MultipleIDs
  * @param int $SingleIndexID
  * @param array(int) $MultipleIndexIDs
  * @param int $SingleModelID
  * @param array(int) $MultipleModelIDs
  * @param int $SingleSetID
  * @param array(int) $MultipleSetIDs
  * @param int $SingleImageID
  * @param array(int) $MultipleImageIDs
  * @param int $SingleVideoID
  * @param array(int) $MultipleVideoIDs
  * @param int $CacheImageWidth
  * @param int $CacheImageHeight
  * @param int $IndexSequenceNumber
  * @param int $IndexSequenceTotal
  */
 public function __construct($SingleID = FALSE, $MultipleIDs = FALSE, $SingleIndexID = FALSE, $MultipleIndexIDs = FALSE, $SingleModelID = FALSE, $MultipleModelIDs = FALSE, $SingleSetID = FALSE, $MultipleSetIDs = FALSE, $SingleImageID = FALSE, $MultipleImageIDs = FALSE, $SingleVideoID = FALSE, $MultipleVideoIDs = FALSE, $CacheImageWidth = FALSE, $CacheImageHeight = FALSE, $IndexSequenceNumber = FALSE, $IndexSequenceTotal = FALSE)
 {
     parent::__construct();
     if ($SingleID !== FALSE) {
         $this->paramtypes .= "s";
         $this->values[] = $SingleID;
         $this->where .= " AND cache_id = ?";
     }
     if (is_array($MultipleIDs) && count($MultipleIDs) > 0) {
         $this->paramtypes .= str_repeat('s', count($MultipleIDs));
         $this->values = array_merge($this->values, $MultipleIDs);
         $this->where .= sprintf(" AND cache_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleIDs), '?')));
     }
     if ($SingleIndexID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleIndexID;
         $this->where .= " AND index_id = ?";
     }
     if (is_array($MultipleIndexIDs) && count($MultipleIndexIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleIndexIDs));
         $this->values = array_merge($this->values, $MultipleIndexIDs);
         $this->where .= sprintf(" AND index_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleIndexIDs), '?')));
     }
     if ($SingleModelID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleModelID;
         $this->where .= " AND model_id = ?";
     }
     if (is_array($MultipleModelIDs) && count($MultipleModelIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleModelIDs));
         $this->values = array_merge($this->values, $MultipleModelIDs);
         $this->where .= sprintf(" AND model_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleModelIDs), '?')));
     }
     if ($SingleSetID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleSetID;
         $this->where .= " AND set_id = ?";
     }
     if (is_array($MultipleSetIDs) && count($MultipleSetIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleSetIDs));
         $this->values = array_merge($this->values, $MultipleSetIDs);
         $this->where .= sprintf(" AND set_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleSetIDs), '?')));
     }
     if ($SingleImageID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleImageID;
         $this->where .= " AND image_id = ?";
     }
     if (is_array($MultipleImageIDs) && count($MultipleImageIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleImageIDs));
         $this->values = array_merge($this->values, $MultipleImageIDs);
         $this->where .= sprintf(" AND image_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleImageIDs), '?')));
     }
     if ($SingleVideoID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleVideoID;
         $this->where .= " AND video_id = ?";
     }
     if (is_array($MultipleVideoIDs) && count($MultipleVideoIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleVideoIDs));
         $this->values = array_merge($this->values, $MultipleVideoIDs);
         $this->where .= sprintf(" AND video_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleVideoIDs), '?')));
     }
     if ($CacheImageWidth !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $CacheImageWidth;
         $this->where .= " AND cache_imagewidth = ?";
     }
     if ($CacheImageHeight !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $CacheImageHeight;
         $this->where .= " AND cache_imageheight = ?";
     }
     if ($IndexSequenceNumber !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $IndexSequenceNumber;
         $this->where .= " AND index_sequence_number = ?";
     }
     if ($IndexSequenceTotal !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $IndexSequenceTotal;
         $this->where .= " AND index_sequence_total = ?";
     }
 }
Example #3
0
 /**
  * @param int $SingleID
  * @param array(int) $MultipleIDs
  * @param string $FirstName
  * @param string $LastName
  * @param string $FullName
  */
 public function __construct($SingleID = FALSE, $MultipleIDs = FALSE, $FirstName = FALSE, $LastName = FALSE, $FullName = FALSE)
 {
     parent::__construct();
     if ($SingleID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleID;
         $this->where .= " AND model_id = ?";
     }
     if (is_array($MultipleIDs) && count($MultipleIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleIDs));
         $this->values = array_merge($this->values, $MultipleIDs);
         $this->where .= sprintf(" AND model_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleIDs), '?')));
     }
     if ($FirstName !== FALSE) {
         $this->paramtypes .= 's';
         $this->values[] = '%' . $FirstName . '%';
         $this->where .= " AND model_firstname LIKE ?";
     }
     if ($LastName !== FALSE) {
         $this->paramtypes .= 's';
         $this->values[] = '%' . $LastName . '%';
         $this->where .= " AND model_lastname LIKE ?";
     }
     if ($FullName !== FALSE) {
         $this->paramtypes .= 's';
         $this->values[] = '%' . $FullName . '%';
         $this->where .= " AND CONCAT_WS(' ', model_firstname, model_lastname) LIKE ?";
     }
 }
Example #4
0
 /**
  * @param int $SingleTagID
  * @param array(int) $MultipleTagIDs
  * @param string $TagName
  * @param int $SingleModelID
  * @param array(int) $MultipleModelIDs
  * @param int $SingleSetID
  * @param array(int) $MultipleSetIDs
  * @param int $SingleImageID
  * @param array(int) $MultipleImageIDs
  * @param int $SingleVideoID
  * @param array(int) $MultipleVideoIDs
  * @param bool $ModelIdIsNull
  * @param bool $SetIdIsNull
  * @param bool $ImageIdIsNull
  * @param bool $VideoIdIsNull
  */
 public function __construct($SingleTagID = FALSE, $MultipleTagIDs = FALSE, $TagName = FALSE, $SingleModelID = FALSE, $MultipleModelIDs = FALSE, $SingleSetID = FALSE, $MultipleSetIDs = FALSE, $SingleImageID = FALSE, $MultipleImageIDs = FALSE, $SingleVideoID = FALSE, $MultipleVideoIDs = FALSE, $ModelIdIsNull = FALSE, $SetIdIsNull = FALSE, $ImageIdIsNull = FALSE, $VideoIdIsNull = FALSE)
 {
     parent::__construct();
     if ($SingleTagID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleTagID;
         $this->where .= " AND tag_id = ?";
     }
     if (is_array($MultipleTagIDs) && count($MultipleTagIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleTagIDs));
         $this->values = array_merge($this->values, $MultipleTagIDs);
         $this->where .= sprintf(" AND tag_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleTagIDs), '?')));
     }
     if ($TagName !== FALSE) {
         $this->paramtypes .= 's';
         $this->values[] = '%' . $TagName . '%';
         $this->where .= " AND tag_name LIKE ?";
     }
     if ($SingleModelID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleModelID;
         $this->where .= " AND model_id = ?";
     }
     if (is_array($MultipleModelIDs) && count($MultipleModelIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleModelIDs));
         $this->values = array_merge($this->values, $MultipleModelIDs);
         $this->where .= sprintf(" AND model_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleModelIDs), '?')));
     }
     if ($SingleSetID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleSetID;
         $this->where .= " AND set_id = ?";
     }
     if (is_array($MultipleSetIDs) && count($MultipleSetIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleSetIDs));
         $this->values = array_merge($this->values, $MultipleSetIDs);
         $this->where .= sprintf(" AND set_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleSetIDs), '?')));
     }
     if ($SingleImageID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleImageID;
         $this->where .= " AND image_id = ?";
     }
     if (is_array($MultipleImageIDs) && count($MultipleImageIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleImageIDs));
         $this->values = array_merge($this->values, $MultipleImageIDs);
         $this->where .= sprintf(" AND image_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleImageIDs), '?')));
     }
     if ($SingleVideoID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleVideoID;
         $this->where .= " AND video_id = ?";
     }
     if (is_array($MultipleVideoIDs) && count($MultipleVideoIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleVideoIDs));
         $this->values = array_merge($this->values, $MultipleVideoIDs);
         $this->where .= sprintf(" AND video_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleVideoIDs), '?')));
     }
     if ($ModelIdIsNull) {
         $this->where .= " AND model_id IS NULL";
     }
     if ($SetIdIsNull) {
         $this->where .= " AND set_id IS NULL";
     }
     if ($ImageIdIsNull) {
         $this->where .= " AND image_id IS NULL";
     }
     if ($VideoIdIsNull) {
         $this->where .= " AND video_id IS NULL";
     }
 }
Example #5
0
 public function __construct($SingleID = FALSE, $MultipleIDs = FALSE, $UserName = FALSE, $Password = FALSE, $Email = FALSE)
 {
     parent::__construct();
     if ($SingleID !== FALSE) {
         $this->paramtypes .= "i";
         $this->values[] = $SingleID;
         $this->where .= " AND user_id = ?";
     }
     if (is_array($MultipleIDs) && count($MultipleIDs) > 0) {
         $this->paramtypes .= str_repeat('i', count($MultipleIDs));
         $this->values = array_merge($this->values, $MultipleIDs);
         $this->where .= sprintf(" AND user_id IN ( %1s ) ", implode(', ', array_fill(0, count($MultipleIDs), '?')));
     }
     if ($UserName !== FALSE) {
         $this->paramtypes .= 's';
         $this->values[] = $UserName;
         $this->where .= " AND user_username = ?";
     }
     if ($Password !== FALSE) {
         $this->paramtypes .= 's';
         $this->values[] = $Password;
         $this->where .= " AND user_password = ?";
     }
     if ($Email !== FALSE) {
         $this->paramtypes .= 's';
         $this->values[] = $Email;
         $this->where .= " AND user_email = ?";
     }
 }