View file games/bottle/plugins/delete.php

File size: 2.22Kb
<?php
  
if ($game['USER_ID'] == user('ID')) {
  
  if (get('get') == 'delete_chat_ok'){
    
    get_check_valid();
    
    $data = db::get_string_all("SELECT * FROM `COMMENTS` WHERE `OBJECT_ID` = ? AND `OBJECT_TYPE` = ?", [$game['ID'], 'bottle_comments']);
    while ($list = $data->fetch()) {
      
      db::get_set("DELETE FROM `LIKES` WHERE `OBJECT_ID` = ? AND `OBJECT_TYPE` = ?", [$list['ID'], 'bottle_comments']);
      db::get_set("DELETE FROM `ATTACHMENTS` WHERE `ID_POST` = ? AND `TYPE_POST` = ?", [$list['ID'], 'bottle_comments']);
      db::get_set("DELETE FROM `COMMENTS` WHERE `ID` = ? LIMIT 1", [$list['ID']]);
    
    }
      
    success('Удаление прошло успешно');
    redirect('/games/bottle/game.php?id='.$game['ID'].'&url='.tabs($game['URL']));
      
  }
  
  if (get('get') == 'delete_chat'){
    
    get_check_valid();
    
    ?>
    <div class='list' style='margin-bottom: 10px'>
    <?=lg('Вы действительно хотите очистить чат от всех сообщений')?>?<br /><br />
    <a href='/games/bottle/game.php?id=<?=$game['ID']?>&get=delete_chat_ok&<?=TOKEN_URL?>&url=<?=tabs($game['URL'])?>' class='button'><?=icons('trash', 17, 'fa-fw')?> <?=lg('Очистить')?></a>
    <a href='/games/bottle/game.php?id=<?=$game['ID']?>&url=<?=tabs($game['URL'])?>' class='button-o'><?=lg('Отмена')?></a>
    </div>
    <?
    
  }
  
  if (get('get') == 'delete_ok'){
    
    get_check_valid();
    
    db::get_set("DELETE FROM `BOTTLE` WHERE `ID` = ? LIMIT 1", [$game['ID']]);
    
    success('Удаление прошло успешно');
    redirect('/games/bottle/?');
  
  }
  
  if (get('get') == 'delete'){
    
    get_check_valid();
    
    ?>
    <div class='list' style='margin-bottom: 10px'>
    <?=lg('Вы действительно хотите удалить стол')?> <b>#<?=$game['ID']?></b>?<br /><br />
    <a href='/games/bottle/game.php?id=<?=$game['ID']?>&get=delete_ok&<?=TOKEN_URL?>&url=<?=tabs($game['URL'])?>' class='button'><?=icons('trash', 17, 'fa-fw')?> <?=lg('Удалить')?></a>
    <a href='/games/bottle/game.php?id=<?=$game['ID']?>&url=<?=tabs($game['URL'])?>' class='button-o'><?=lg('Отмена')?></a>
    </div>
    <?
  
  }
  
}