PHP DBLayer::select方法代码示例

 /**
  * loads the object's attributes.
  * loads the object's attributes by giving a SID as parameter
  * @param $id the id of the querycaches row
  */
 public function load_With_SID($id)
 {
     $dbl = new DBLayer("lib");
     $statement = $dbl->select("ams_querycache", array('id' => $id), "SID=:id");
     $row = $statement->fetch();
     $this->set($row);
 }

 /**
  * loads the object's attributes.
  * loads the object's attributes by giving a ticket_content's id,
  * @param $id the id of the ticket_content entry that should be loaded
  */
 public function load_With_TContentId($id)
 {
     $dbl = new DBLayer("lib");
     $statement = $dbl->select("ticket_content", array('id' => $id), "TContentId=:id");
     $row = $statement->fetch();
     $this->tContentId = $row['TContentId'];
     $this->content = $row['Content'];
 }

/**
 * Local Hook to get database content
 * which is called by the global hook 
 * by passing a parameter
 * 
 * Hook to get the player stats of the character
 * 
 * @param  $data array with respective information
 * @return $row extracted db content wrt $data
 */
function hook_get_player_stat($data)
{
    // returns the character id with respect to the character name  in the ring_tool->characters
    $db = new DBLayer('webig');
    $sth = $db->select('players', array('name' => $data), 'name=:name');
    $row = $sth->fetch();
    return $row;
}

 /**
  * loads the object's attributes.
  * loads the object's attributes by giving a categories id.
  * @param $id the id of the ticket_category that should be loaded
  */
 public function load_With_TCategoryId($id)
 {
     $dbl = new DBLayer("lib");
     $statement = $dbl->select("ticket_category", array('id' => $id), "TCategoryId=:id");
     $row = $statement->fetch();
     $this->tCategoryId = $row['TCategoryId'];
     $this->name = $row['Name'];
 }

 /**
  * Check if user is in in_support_group.
  * @param $user_id the id of the user.
  * @param $group_id the id of the support group.
  * @return true is returned in case the user is in the support group, else false is returned.
  */
 public static function userExistsInSGroup($user_id, $group_id)
 {
     $dbl = new DBLayer("lib");
     //check if name is already used
     if ($dbl->select("in_support_group", array('user_id' => $user_id, 'group_id' => $group_id), "`User` = :user_id and `Group` = :group_id")->rowCount()) {
         return true;
     } else {
         return false;
     }
 }

 private function getLatestMigration()
 {
     $sql = "SELECT migration from migrations order by migration desc limit 1";
     $res = DBLayer::select($sql);
     $r = mysql_fetch_assoc($res);
     if ($r['migration'] == "") {
         return 0;
     } else {
         return $r['migration'];
     }
 }

 /**
  * loads the object's attributes.
  * loads the object's attributes by giving a ticket_id, it will put the matching user_id and the ticket_id into the attributes.
  * @param $ticket_id the id of the ticket that should be loaded
  */
 public function load($ticket_id)
 {
     $dbl = new DBLayer("lib");
     $statement = $dbl->select("`assigned`", array('ticket_id' => $ticket_id), "`Ticket` = :ticket_id");
     $row = $statement->fetch();
     $this->set($row);
 }

 /**
  * loads the object's attributes.
  * loads the object's attributes by giving a TId (ticket id).
  * @param $id the id of the ticket that should be loaded
  */
 public function load_With_TId($id)
 {
     $dbl = new DBLayer("lib");
     $statement = $dbl->select("ticket", array('id' => $id), "TId=:id");
     $row = $statement->fetch();
     $this->tId = $row['TId'];
     $this->timestamp = $row['Timestamp'];
     $this->title = $row['Title'];
     $this->status = $row['Status'];
     $this->queue = $row['Queue'];
     $this->ticket_category = $row['Ticket_Category'];
     $this->author = $row['Author'];
     $this->priority = $row['Priority'];
 }

/**
 * function to check for updates or
 * if the same plugin already exists
 * also, if the update founds ,check for the UpdateInfo in the .info file.
 * Update is saved in the temp directory with pluginName_version.zip
 *
 * @param  $fileName file which is uploaded in .zip extension
 * @param  $findPath where we have to look for the installed plugins
 * @param  $tempFile path for the temporary file
 * @param  $tempPath path where we have to store the update
 * @return 2 if plugin already exists and update not found
 * @return 3 if update info tag not found in .info file
 */
function checkForUpdate($fileName, $findPath, $tempFile, $tempPath)
{
    // check for plugin if exists
    $file = scandir($findPath);
    foreach ($file as $key => $value) {
        if (strcmp($value, $fileName) == 0) {
            if (!file_exists($tempPath . "/test")) {
                mkdir($tempPath . "/test");
            }
            // extracting the update
            if (zipExtraction($tempFile, $tempPath . "/test/")) {
                $result = readPluginFile(".info", $tempPath . "/test/" . $fileName);
                // check for the version for the plugin
                $db = new DBLayer("lib");
                $sth = $db->select("plugins", array('Name' => $result['PluginName']), "Name = :Name");
                $info = $sth->fetch();
                $info['Info'] = json_decode($info['Info']);
                // the two versions from main plugin and the updated part
                $new_version = explode('.', $result['Version']);
                $pre_version = explode('.', $info['Info']->Version);
                // For all plugins we have used semantic versioning
                // Format: X.Y.Z ,X->Major, Y->Minor, Z->Patch
                // change in the X Y & Z values refer the type of change in the plugin.
                // for initial development only Minor an Patch MUST be 0.
                // if there is bug fix then there MUST be an increment in the Z value.
                // if there is change in the functionality or addition of new functionality
                // then there MUST be an increment in the Y value.
                // When there is increment in the X value , Y and Z MUST be 0.
                // comparing if there is some change
                if (!array_diff($new_version, $pre_version)) {
                    // removing the uploaded file
                    Plugincache::rrmdir($tempPath . "/test/" . $fileName);
                    return '2';
                    //plugin already exists
                } else {
                    // check for update info if exists
                    if (!array_key_exists('UpdateInfo', $result)) {
                        return '3';
                        //update info tag not found
                    } else {
                        // check if update already exists
                        if (pluginUpdateExists($info['Id'], $tempPath . "/" . trim($fileName, ".zip") . "_" . $result['Version'] . ".zip")) {
                            echo "Update already exists";
                            throw new SystemExit();
                        } else {
                            // removing the preivous update
                            $dbr = new DBLayer("lib");
                            $dbr->delete("updates", array('id' => $info['Id']), "PluginId=:id");
                            // storing update in the temp directory
                            // format of update save
                            if (move_uploaded_file($tempFile, $tempPath . "/" . trim($fileName, ".zip") . "_" . $result['Version'] . ".zip")) {
                                // setting update information in the database
                                $update['PluginId'] = $info['Id'];
                                $update['UpdatePath'] = $tempPath . "/" . trim($fileName, ".zip") . "_" . $result['Version'] . ".zip";
                                $update['UpdateInfo'] = json_encode($result);
                                $dbr->insert("updates", $update);
                                header("Cache-Control: max-age=1");
                                header("Location: index.php?page=plugins&result=7");
                                throw new SystemExit();
                            }
                        }
                    }
                }
            }
        }
    }
}

/**
 * Global Hook to load the data from db and set it
 * into the global array to return it to the template
 */
function api_key_management_hook_load_db()
{
    global $var_set;
    global $API_key_management_return_set;
    $dbl = new DBLayer("lib");
    if (isset($_SESSION['user'])) {
        // returns the registered keys
        $sth = $dbl->select('ams_api_keys', array('user' => $_SESSION['user']), 'User = :user');
        $row = $sth->fetchAll();
        $API_key_management_return_set['api_keys'] = $row;
        // fetch the character from the array to compare
        $com = array_column($API_key_management_return_set['api_keys'], 'UserCharacter');
        // returns the characters with respect to the user id in the ring_tool->characters
        try {
            $dbl = new DBLayer('ring');
            $sth = $dbl->selectWithParameter('char_name', 'characters', array(), '1');
            $row = $sth->fetch();
            // loop through the character list and remove the character if already have an api key
            $API_key_management_return_set['characters'] = array_diff($row, $com);
        } catch (PDOException $e) {
            error_log($e->getMessage());
        }
    }
}

 /**
  * loads the object's attributes.
  * loads the object's attributes by giving a group id, it will put the matching groups attributes in the object.
  * @param $id the id of the support group that should be loaded
  */
 public function load_With_SGroupId($id)
 {
     $dbl = new DBLayer("lib");
     $statement = $dbl->select("`support_group`", array('id' => $id), "`SGroupId` = :id");
     $row = $statement->fetch();
     $this->set($row);
 }

 /**
  * loads the object's attributes by using a ticket's id.
  * loads the object's attributes by giving a ticket's entry id.
  * @param $id the id of the ticket, the ticket_info entry of that ticket should be loaded.
  */
 public function load_With_Ticket($id)
 {
     $dbl = new DBLayer("lib");
     $statement = $dbl->select("ticket_info", array('id' => $id), "Ticket=:id");
     $row = $statement->fetch();
     $this->set($row);
 }

 /**
  * loads the object's attributes.
  * loads the object's attributes by giving a ticket_reply's id.
  * @param $id the id of the ticket_reply that should be loaded
  */
 public function load_With_TReplyId($id)
 {
     $dbl = new DBLayer("lib");
     $statement = $dbl->select("ticket_reply", array('id' => $id), "TReplyId=:id");
     $row = $statement->fetch();
     $this->tReplyId = $row['TReplyId'];
     $this->ticket = $row['Ticket'];
     $this->content = $row['Content'];
     $this->author = $row['Author'];
     $this->timestamp = $row['Timestamp'];
     $this->hidden = $row['Hidden'];
 }

 /**
  * loads the object's attributes.
  * loads the object's attributes by giving a TUserId.
  * @param $id the id of the ticket_user that should be loaded
  */
 public function load_With_TUserId($id)
 {
     $dbl = new DBLayer("lib");
     $statement = $dbl->select("ticket_user", array('id' => $id), "TUserId=:id");
     $row = $statement->fetch();
     $this->tUserId = $row['TUserId'];
     $this->permission = $row['Permission'];
     $this->externId = $row['ExternId'];
 }

 /**
  * get language attribute of the object.
  */
 public function getLanguage()
 {
     $dbw = new DBLayer("web");
     if (!isset($this->language) || $this->language == "") {
         $statement = $dbw->select("ams_user", array('id' => $this->uId), "UId=:id");
         $row = $statement->fetch();
         $this->set($row);
     }
     return $this->language;
 }