PHP Error::MySQL方法代码示例

 function get()
 {
     $args_list = func_get_args();
     $number_to_get = (int) $args_list[0];
     $start_number = (int) $args_list[1];
     if ($number_to_get && $start_number) {
         $query = "select ID from Users order by ID asc limit {$start_number}, {$number_to_get}";
     } else {
         if ($number_to_get) {
             $query = "select ID from Users order by ID asc limit 0, {$number_to_get}";
         } else {
             if ($start_number) {
                 $query = "select ID from Users order by ID asc limit {$start_number}, 10";
             } else {
                 $query = "select ID from Users order by ID asc limit 0, 10";
             }
         }
     }
     $q = "select count(ID) as total from Users";
     $r = mysql_query($q);
     if (!$r) {
         return Error::MySQL();
     }
     $row = mysql_fetch_assoc($r);
     $this->total = $row['total'];
     $r = mysql_query($query);
     if (!$r) {
         return Error::MySQL();
     }
     $user = array();
     while ($row = mysql_fetch_assoc($r)) {
         $user[] = User::get($row['ID']);
     }
     return $user;
 }

 function update($setting, $value)
 {
     if (!Config::isValidSetting($setting)) {
         return Error::create("Unrecognized setting: {$setting}");
     }
     $q = "delete from Config where name = '{$setting}'";
     $r = @mysql_query($q);
     if (!$r) {
         return Error::MySQL();
     }
     $q = "insert into Config (name, value) values ('{$setting}', '" . db::sanitize_to_db($value) . "')";
     $r = @mysql_query($q);
     if (!$r) {
         return Error::MySQL();
     }
     return true;
 }

 function populateShowsArray($m, $y)
 {
     $db = new db();
     $mPadded = sprintf("%02d", $m);
     $q = "select DATE_FORMAT(date, '%d') as day, ID from Shows where is_active = 1 and DATE_FORMAT(date, '%m') = '{$mPadded}' and DATE_FORMAT(date, '%Y') = '{$y}' order by date asc";
     $r = mysql_query($q);
     if ($db->isError($r)) {
         return Error::MySQL();
     }
     while ($row = mysql_fetch_assoc($r)) {
         $this->showsArray[(int) $row['day']][] = Show::get($row['ID']);
     }
 }

 function update($postArray)
 {
     $db = new db();
     $e = new Error();
     if (User::isAdmin()) {
         $genreID = $db->sanitize_to_db($postArray['genreID']);
         if (!$this->isValidGenreID($postArray['genreID'])) {
             $e->add("Invalid genre specified");
         }
         $name = $db->sanitize_to_db($postArray['name']);
         if ($name == '' || $name == null) {
             $e->add("You must specify a name for your band.");
         }
         $managerName = $db->sanitize_to_db($postArray['managerName']);
         $address1 = $db->sanitize_to_db($postArray['address1']);
         $address2 = $db->sanitize_to_db($postArray['address2']);
         $city = $db->sanitize_to_db($postArray['city']);
         $stateProvince = $db->sanitize_to_db($postArray['stateProvince']);
         if ($stateProvince == "??") {
             $stateProvince = $db->sanitize_to_db($postArray['stateProvinceOther']);
         }
         $postalCode = $db->sanitize_to_db($postArray['postalCode']);
         $bio = $db->sanitize_to_db($postArray['bio']);
         $miscellaneous = $db->sanitize_to_db($postArray['miscellaneous']);
         $country = $db->sanitize_to_db($postArray['country']);
         $defaultStateProvince = $db->sanitize_to_db($postArray['defaultStateProvince']);
         if ($defaultStateProvince == "??") {
             $defaultStateProvince = $db->sanitize_to_db($postArray['defaultStateProvince']);
         }
         $defaultCountry = $db->sanitize_to_db($postArray['defaultCountry']);
         $defaultCity = $db->sanitize_to_db($postArray['defaultCity']);
         $description = $db->sanitize_to_db($postArray['description']);
         if ($e->hasErrors()) {
             return $e;
         }
         $q = "delete from Band_Information";
         $r = mysql_query($q);
         if (!$r) {
             return Error::MySQL();
         }
         $q = "insert into Band_Information (name, managerName, address1, address2, city, stateProvince, postalCode, bio, miscellaneous, country, defaultStateProvince, defaultCountry, defaultCity, genreID, description) ";
         $q .= "values ('{$name}', '{$managerName}', '{$address1}', '{$address2}', '{$city}', '{$stateProvince}', '{$postalCode}', '{$bio}', '{$miscellaneous}', '{$country}', '{$defaultStateProvince}', '{$defaultCountry}', '{$defaultCity}', '{$genreID}', '{$description}')";
         $r = mysql_query($q);
         // ping auditionrocks.com
         // aborted attempt at creating an audition directory
         /*
         include_class('xmlrpc');
         $xc = new xmlrpc_client("/ping/", "www.auditionrocks.com");
         $message = new xmlrpcmsg("audition.pingBack", array(
         		new xmlrpcval($_SERVER["HTTP_HOST"] . SITE_WEB_DIRECTORY, "string"),
         		new xmlrpcval($name, "string"),
         		new xmlrpcval($bio, "string"),
         		new xmlrpcval($genreID, "int"),
         		new xmlrpcval($city, "string"),
         		new xmlrpcval($stateProvince, "string"),
         		new xmlrpcval($postalCode, "string"),
         		new xmlrpcval($country, "string"))
         	);
         
         $response = $xc->send($message, 5, "POST");
         */
         if ($r) {
             return true;
         } else {
             return Error::create("An unexplained error occurred when trying to update your information.");
         }
     }
 }

 function remove()
 {
     if ($this->canEdit()) {
         $r = @mysql_query("delete from Band_News where ID = " . $this->ID);
         if (!$r) {
             return Error::MySQL();
         }
     } else {
         return Error::create('You may not remove a post that is not yours.');
     }
 }

 function registerMedia($mediaType)
 {
     $type = $mediaType == 'av' ? 'av' : 'photos';
     if (User::isAdmin()) {
         if ($type == 'av' && $this->av_area_id < 1 || $type == 'photos' && $this->photo_area_id < 1) {
             $areaTitle = $type == 'av' ? "Tour Audio/Video: " : "Tour Photos: ";
             $areaIDField = $type == 'av' ? "av_area_id" : "photo_area_id";
             if ($type == 'av') {
                 $allowed_extensions = MEDIA_EXTENSIONS_ALLOWED_AV;
                 $display = "list";
             } else {
                 $allowed_extensions = MEDIA_EXTENSIONS_ALLOWED_PHOTO;
                 $display = "grid";
             }
             $ma = MediaArea::add(0, $areaTitle . $this->title, null, $allowed_extensions, $display);
             if (db::isError($ma)) {
                 return $ma;
             }
             $ma->activate();
             $q = "update Tours set {$areaIDField} = " . $ma->getID() . " where ID = {$this->ID}";
             $r = mysql_query($q);
             if (!$r) {
                 return Error::MySQL();
             } else {
                 return $r;
             }
             return $r;
         } else {
             return Error::create("A tour with an ID of {$this->ID} is already registered.");
         }
     } else {
         return Error::create('Only an admin user may authorize a tour for media.');
     }
 }

 function remove()
 {
     if (User::isAdmin()) {
         $r = @mysql_query("delete from Band_Guest_Performers where ID = " . $this->ID);
         if (!$r) {
             return Error::MySQL();
         }
     } else {
         return Error::create("Only an administrator may remove guest performers.");
     }
 }

 function moveDown($filterObj = null)
 {
     if ($filterObj) {
         $proceed = $filterObj->validateMediaOperation("MOVEDOWN");
         if (db::isError($proceed)) {
             return $proceed;
         }
     }
     $a = MediaArea::get($this->area_id);
     if (!db::isError($a)) {
         $a->updateDisplayOrder();
     }
     $q = "select display_order from DarkRoom_Media_to_Areas where ID = {$this->ID}";
     $r = mysql_query($q);
     if (!$r) {
         return Error::MySQL();
     }
     $row = mysql_fetch_assoc($r);
     if ($row['display_order']) {
         $this->display_order = $row['display_order'];
     }
     $newDO = $this->display_order + 1;
     $r1 = mysql_query("update DarkRoom_Media_to_Areas set display_order = {$this->display_order} where display_order = {$newDO} and area_id = {$this->area_id}");
     $r2 = mysql_query("\tupdate DarkRoom_Media_to_Areas set display_order = {$newDO} where ID = {$this->ID}");
     if ($r1 && $r2) {
         return true;
     } else {
         $e = new Error();
         $e->add(mysql_error());
         return $e;
     }
 }

 function add($postArray)
 {
     if (User::isAdmin()) {
         $db = new db();
         $name = $db->sanitize_to_db($postArray['name']);
         $description = $db->sanitize_to_db($postArray['description']);
         $url = $db->sanitize_to_db($postArray['url']);
         $category_id = $postArray['category_id'];
         if (!$name) {
             $name = '(untitled link)';
         }
         if (strlen($url) < 6) {
             return Error::create("Please enter a valid URL. A URL typically begins with \"http://\"");
         }
         $r = mysql_query("INSERT INTO Links (name, description, url, category_id, is_active) VALUES ('{$name}', '{$description}', '{$url}', '{$category_id}', " . DEFAULT_ACTIVE . ")");
         if ($r) {
             $nl = Link::get(mysql_insert_id());
             return $nl;
         } else {
             return Error::MySQL();
         }
     } else {
         return Error::create("Only an administrator may add links.");
     }
 }

 function add($postArray)
 {
     $db = new db();
     $uo = User::getCurrent();
     if (User::isAdmin()) {
         $uo = User::get($postArray['user_id']);
         if (db::isError($uo)) {
             $e->add($uo);
         } else {
             if (!$uo->isAdmin() && $uo->isBandMember()) {
                 $e->add("Invalid user. User must be a band member or an administrator.");
             }
         }
     } else {
         $uo = User::getCurrent();
     }
     $user_id = $uo->getID();
     $name = $db->sanitize_to_db($postArray['name']);
     $address1 = $db->sanitize_to_db($postArray['address1']);
     $address2 = $db->sanitize_to_db($postArray['address2']);
     $city = $db->sanitize_to_db($postArray['city']);
     $stateProvince = $db->sanitize_to_db($postArray['stateProvince']);
     if ($stateProvince == "??") {
         $stateProvince = $db->sanitize_to_db($postArray['stateProvinceOther']);
     }
     $postalCode = $db->sanitize_to_db($postArray['postalCode']);
     $directions = $db->sanitize_to_db($postArray['directions']);
     $country = $db->sanitize_to_db($postArray['country']);
     $country = $country == null ? VENUE_DEFAULT_COUNTRY : $country;
     if (!$name) {
         $name = '(untitled venue)';
     }
     $r = mysql_query("insert into Venues (user_id, country, name, address1, address2, city, stateProvince, postalCode, directions, is_active) values ('{$user_id}', '{$country}', '{$name}', '{$address1}', '{$address2}', '{$city}', '{$stateProvince}', '{$postalCode}', '{$directions}'," . DEFAULT_ACTIVE . ")");
     if ($r) {
         return Venue::get(mysql_insert_id());
     } else {
         return Error::MySQL();
     }
 }

 function getMemberPhoto()
 {
     // the album cover is actually the first piece of media that's active in a given member's media area
     // first we get the media area ID for the given release.
     if ($this->photo_area_id) {
         // if we have an area ID, we continue
         $q = "select ID from DarkRoom_Media_to_Areas where area_id = {$this->photo_area_id} and is_active = 1 order by display_order asc limit 1";
         $r = mysql_query($q);
         if (!$r) {
             return Error::MySQL();
         }
         $row = mysql_fetch_assoc($r);
         if ($row['ID']) {
             $mi = MediaInstance::get($row['ID']);
             return $mi;
         }
     }
 }

 function registerMedia()
 {
     if (User::isAdmin()) {
         if ($this->av_area_id < 1) {
             $areaTitle = "Track Audio/Video: ";
             $allowed_extensions = MEDIA_EXTENSIONS_ALLOWED_AV;
             $display = "list";
             $ma = MediaArea::add(0, $areaTitle . $this->title, null, $allowed_extensions, $display);
             if (db::isError($ma)) {
                 return $ma;
             }
             $ma->activate();
             $q = "update Release_Tracks set av_area_id = " . $ma->getID() . " where ID = {$this->ID}";
             $r = mysql_query($q);
             if (!$r) {
                 return Error::MySQL();
             } else {
                 return $r;
             }
             return $r;
         } else {
             return Error::create("A track with an ID of {$this->ID} is already registered.");
         }
     } else {
         return Error::create('Only an admin user may authorize a track for media.');
     }
 }