Example #1
0
 function Query($query)
 {
     if ($result = mysql_query($query)) {
         return $result;
     } else {
         dp('<p>MySQL Error ' . Database::GetErrorNumber() . ': ' . Database::GetError() . ' in query <code>' . $query . '</code></p>');
         dp();
         return false;
     }
 }
Example #2
0
 function DeleteItem($master)
 {
     // First make sure we have sufficient privileges
     if (!$this->CanDelete()) {
         trigger_error("Insufficient privileges to delete from module " . $this->name, E_USER_ERROR);
         return false;
     }
     // Delete item
     if ($this->config['keepVersions']) {
         $where = 'id = ' . $master . ' OR master = ' . $master;
     } else {
         $where = 'id = ' . $master;
     }
     if (Database::DeleteFrom($this->name, $where)) {
         // Delete was successful; get rid of this item in _paths table
         if (Path::DeleteAll($this->moduleID, $master)) {
             return true;
         } else {
             trigger_error("Couldn't delete paths associated with deleted item", E_USER_ERROR);
             return false;
         }
         // Eventually, delete from _relationships where frommodule = this module
     } else {
         if (Database::GetErrorNumber() == 1451) {
             return ERROR_FOREIGN_KEY_CONSTRAINT;
         } else {
             trigger_error("Couldn't delete module item from database", E_USER_ERROR);
             return false;
         }
     }
 }