PHP rex_sql::delete 예제들

delete() 공개 메소드

Setzt eine Delete-Anweisung auf die angegebene Tabelle mit den angegebenen WHERE Parametern ab.

public delete ( )

예제 #1

파일: extension_common.inc.php 프로젝트: BackupTheBerlios/redaxo-svn

 function a724_deletePathnamesFromTable()
 {
     $debug = false;
     // Alle Urls der Tabelle loeschen
     $sqld = new rex_sql();
     $sqld->setDebug($debug);
     $sqld->setTable('rex_a724_frau_schultze');
     $sqld->setWhere('name != "" AND url_table != "" AND url_table_parameters = ""');
     $sqld->delete();
 }

예제 #2

파일: rex_asd_news_language.php 프로젝트: Sysix/asd_news

function asd_news_deleteClang($params)
{
    $id = $params['id'];
    $name = $params['name'];
    $sql = new rex_sql();
    $sql->setTable(rex_asd_news_config::getTable());
    $sql->setWhere('`clang`= ' . $id);
    if ($sql->delete()) {
        echo rex_info('ASD News: Neuigkeiten wurden gelöscht');
    } else {
        echo rex_warning('<b>ASD News Fehler:</b> Neuigkeiten aus der Sprache "' . $name . '" konnte nicht gelöscht werden');
    }
}

예제 #3

파일: class.rex_externalMultiValueManager.inc.php 프로젝트: BackupTheBerlios/redaxo-addons

 function getInsertValue($value)
 {
     $value = (array) $value;
     $section =& $this->getSection();
     // Alle vorhanden Werte löschen
     $sql = new rex_sql();
     $sql->setTable($this->foreignTable);
     $sql->setWhere($section->_getWhereString());
     $sql->delete();
     // und anschließend alle neu eintragen
     foreach ($value as $val) {
         // Parameter aus der Ursprungstabelle mit abspeichern damit später darüber verknüpft werden kann
         foreach ($section->getWhere() as $whereColName => $whereColValue) {
             $sql->setValue($whereColName, $whereColValue);
         }
         // Den zu speichernden Wert
         $sql->setValue($this->foreignField, $val);
         $sql->setTable($this->foreignTable);
         $sql->insert();
     }
     // null zurückgeben, damit zu diesem Feld nichts im rexForm gespeichert wird
     return null;
 }

예제 #4

파일: class.rexsearch.inc.php 프로젝트: olien/rexsearch

 /** 
  * Truncates the cache or deletes all data that are concerned with the given index-ids.
  * 
  * @param mixed $_indexIds
  * 
  * 
  */
 function deleteCache($_indexIds = false)
 {
     if ($_indexIds === false) {
         // delete entire search-chache
         $delete = new rex_sql();
         $delete->setTable($this->tablePrefix . '587_searchcacheindex_ids');
         $delete->delete();
         $delete2 = new rex_sql();
         $delete2->setTable($this->tablePrefix . '587_searchcache');
         $delete2->delete();
     } elseif (is_array($_indexIds) and !empty($_indexIds)) {
         $sql = new rex_sql();
         $query = sprintf('
     SELECT cache_id
     FROM %s
     WHERE index_id IN (%s)', $this->tablePrefix . '587_searchcacheindex_ids', implode(',', $_indexIds));
         $deleteIds = array(0);
         foreach ($sql->getArray($query) as $cacheId) {
             $deleteIds[] = $cacheId['cache_id'];
         }
         // delete from search-cache where indexed IDs exist
         $delete = new rex_sql();
         $delete->setTable($this->tablePrefix . '587_searchcache');
         $delete->setWhere('id IN (' . implode(',', $deleteIds) . ')');
         $delete->delete();
         // delete the cache-ID and index-ID
         $delete2 = new rex_sql();
         $delete2->setTable($this->tablePrefix . '587_searchcacheindex_ids');
         $delete2->setWhere('cache_id IN (' . implode(',', $deleteIds) . ')');
         $delete2->delete();
         // delete all cached searches which had no result (because now they maybe will have)
         $delete3 = new rex_sql();
         $delete3->setTable($this->tablePrefix . '587_searchcache');
         $delete3->setWhere(sprintf('id NOT IN (SELECT cache_id FROM `%s`)', $this->tablePrefix . '587_searchcacheindex_ids'));
         $delete3->delete();
     }
 }

예제 #5

파일: news.php 프로젝트: Sysix/asd_news

    $status = $sql->getValue('status') ? 0 : 1;
    $sql->setTable(rex_asd_news_config::getTable());
    $sql->setWhere('id=' . $id . ' AND clang = ' . $clang);
    $sql->setValue('status', $status);
    if ($sql->update()) {
        echo rex_info($I18N->msg('asd_news_status_saved'));
    } else {
        echo rex_warning($sql->getError());
    }
    $func = '';
}
if ($func == 'delete') {
    $sql = new rex_sql();
    $sql->setTable(rex_asd_news_config::getTable());
    $sql->setWhere('id=' . $id . ' AND clang = ' . $clang);
    if ($sql->delete()) {
        echo rex_info($I18N->msg('asd_news_deleted'));
    } else {
        echo rex_warning($sql->getError());
    }
    $func = '';
}
if ($func == 'unpublish') {
    $sql = new rex_sql();
    $sql->setTable(rex_asd_news_config::getTable());
    $sql->setWhere('id=' . $id . ' AND clang = ' . $clang);
    $sql->setValue('publishedAt', '0000-00-00 00:00:00');
    $sql->setValue('publishedBy', 0);
    $successMessage = $I18N->msg('asd_news_unpublished_s');
    if (rex_asd_news_config::getConfig('published-lang') == 'all') {
        $sql->setWhere('`id` = ' . $id);

예제 #6

파일: module.modules.inc.php 프로젝트: BackupTheBerlios/redaxo-svn

if (!empty($add_action)) {
    $action = new rex_sql();
    $action->setTable($REX['TABLE_PREFIX'] . 'module_action');
    $action->setValue('module_id', $modul_id);
    $action->setValue('action_id', $action_id);
    if ($action->insert()) {
        $message = $I18N->msg('action_taken');
        $goon = 'ja';
    } else {
        $message = $action->getErrro();
    }
} elseif (isset($function_action) and $function_action == 'delete') {
    $action = new rex_sql();
    $action->setTable($REX['TABLE_PREFIX'] . 'module_action');
    $action->setWhere('id=' . $iaction_id . ' LIMIT 1');
    $message = $action->delete($I18N->msg('action_deleted_from_modul'));
}
// ---------------------------- FUNKTIONEN FÜR MODULE
$module_in_use_message = '';
if ($function == 'delete') {
    $del = new rex_sql();
    $del->setQuery("SELECT " . $REX['TABLE_PREFIX'] . "article_slice.article_id, " . $REX['TABLE_PREFIX'] . "article_slice.clang, " . $REX['TABLE_PREFIX'] . "article_slice.ctype, " . $REX['TABLE_PREFIX'] . "module.name FROM " . $REX['TABLE_PREFIX'] . "article_slice\r\n      LEFT JOIN " . $REX['TABLE_PREFIX'] . "module ON " . $REX['TABLE_PREFIX'] . "article_slice.modultyp_id=" . $REX['TABLE_PREFIX'] . "module.id\r\n      WHERE " . $REX['TABLE_PREFIX'] . "article_slice.modultyp_id='{$modul_id}' GROUP BY " . $REX['TABLE_PREFIX'] . "article_slice.article_id");
    if ($del->getRows() > 0) {
        $modulname = htmlspecialchars($del->getValue($REX['TABLE_PREFIX'] . "module.name"));
        for ($i = 0; $i < $del->getRows(); $i++) {
            $aid = $del->getValue($REX['TABLE_PREFIX'] . "article_slice.article_id");
            $clang_id = $del->getValue($REX['TABLE_PREFIX'] . "article_slice.clang");
            $ctype = $del->getValue($REX['TABLE_PREFIX'] . "article_slice.ctype");
            $OOArt = OOArticle::getArticleById($aid, $clang_id);
            $label = $OOArt->getName() . ' [' . $aid . ']';
            if (count($REX['CLANG']) > 1) {

예제 #7

파일: index.inc.php 프로젝트: brt-tito/rex-news

// Allgemeine Funktionen aufrufen bei Listenansicht (Offline stellen etc.)
switch ($func) {
    case 'setstatus':
        $oid = rex_request('oid', 'int');
        $statusfield = rex_request('statusfield', 'string');
        $oldstatus = rex_request('oldstatus', 'int');
        $minstatus = rex_request('minstatus', 'int', 0);
        $maxstatus = rex_request('maxstatus', 'int');
        if (setStatus(TBL_NEWS, $oid, $statusfield, $oldstatus, $minstatus, $maxstatus)) {
            echo rex_info('Statusupdate erfolgreich');
        } else {
            echo rex_warning('Statusupdate nicht erfolgreich');
        }
        $func = '';
        break;
    case 'delete':
        $postparams = implode(",", $_POST['ids']);
        $sql = new rex_sql();
        $sql->setTable(TBL_NEWS);
        $sql->setWhere('id IN (' . $postparams . ')');
        $success = $sql->delete();
        if ($sql->getRows() > 0) {
            echo rex_info('Die Datensätze wurden gelöscht');
        } else {
            echo rex_warning('Die Datensätze konnten nicht gelöscht werden');
        }
        $func = '';
        break;
}
require $file;
require $REX['INCLUDE_PATH'] . "/layout/bottom.php";

예제 #8

파일: class.rex_global_settings_language.php 프로젝트: olien/global_settings

 /**
  * @param $clang
  * @return bool
  */
 public static function removeLanguageData($clang)
 {
     global $REX;
     $sql = new rex_sql();
     $sql->setTable($REX['TABLE_PREFIX'] . 'global_settings');
     $sql->setWhere('clang = ' . (int) $clang);
     return $sql->delete();
 }

예제 #9

파일: module.modules.inc.php 프로젝트: BackupTheBerlios/redaxo-svn

if ($add_action != "") {
    $action = new rex_sql();
    $action->setTable($REX['TABLE_PREFIX'] . 'module_action');
    $action->setValue('module_id', $modul_id);
    $action->setValue('action_id', $action_id);
    if ($action->insert()) {
        $info = $I18N->msg('action_taken');
        $goon = '1';
    } else {
        $warning = $action->getErrro();
    }
} elseif ($function_action == 'delete') {
    $action = new rex_sql();
    $action->setTable($REX['TABLE_PREFIX'] . 'module_action');
    $action->setWhere('id=' . $iaction_id . ' LIMIT 1');
    $info = $action->delete($I18N->msg('action_deleted_from_modul'));
}
// ---------------------------- FUNKTIONEN FÜR MODULE
if ($function == 'delete') {
    $del = new rex_sql();
    $del->setQuery("SELECT " . $REX['TABLE_PREFIX'] . "article_slice.article_id, " . $REX['TABLE_PREFIX'] . "article_slice.clang, " . $REX['TABLE_PREFIX'] . "article_slice.ctype, " . $REX['TABLE_PREFIX'] . "module.name FROM " . $REX['TABLE_PREFIX'] . "article_slice\r\n      LEFT JOIN " . $REX['TABLE_PREFIX'] . "module ON " . $REX['TABLE_PREFIX'] . "article_slice.modultyp_id=" . $REX['TABLE_PREFIX'] . "module.id\r\n      WHERE " . $REX['TABLE_PREFIX'] . "article_slice.modultyp_id='{$modul_id}' GROUP BY " . $REX['TABLE_PREFIX'] . "article_slice.article_id");
    if ($del->getRows() > 0) {
        $module_in_use_message = '';
        $modulname = htmlspecialchars($del->getValue($REX['TABLE_PREFIX'] . "module.name"));
        for ($i = 0; $i < $del->getRows(); $i++) {
            $aid = $del->getValue($REX['TABLE_PREFIX'] . "article_slice.article_id");
            $clang_id = $del->getValue($REX['TABLE_PREFIX'] . "article_slice.clang");
            $ctype = $del->getValue($REX['TABLE_PREFIX'] . "article_slice.ctype");
            $OOArt = OOArticle::getArticleById($aid, $clang_id);
            $label = $OOArt->getName() . ' [' . $aid . ']';
            if (count($REX['CLANG']) > 1) {