UserDAO.php 996 B

123456789101112131415161718192021222324252627282930313233343536
  1. <?php
  2. class FreshRSS_UserDAO extends Minz_ModelPdo {
  3. public function createUser($username) {
  4. require_once(APP_PATH . '/sql.php');
  5. $db = Minz_Configuration::dataBase();
  6. $sql = sprintf(SQL_CREATE_TABLES, $db['prefix'] . $username . '_');
  7. $stm = $this->bd->prepare($sql, array(PDO::ATTR_EMULATE_PREPARES => true));
  8. $values = array(
  9. 'catName' => Minz_Translate::t('default_category'),
  10. );
  11. if ($stm && $stm->execute($values)) {
  12. return true;
  13. } else {
  14. $info = $stm->errorInfo();
  15. Minz_Log::record ('SQL error : ' . $info[2], Minz_Log::ERROR);
  16. return false;
  17. }
  18. }
  19. public function deleteUser($username) {
  20. require_once(APP_PATH . '/sql.php');
  21. $db = Minz_Configuration::dataBase();
  22. $sql = sprintf(SQL_DROP_TABLES, $db['prefix'] . $username . '_');
  23. $stm = $this->bd->prepare($sql);
  24. if ($stm && $stm->execute()) {
  25. return true;
  26. } else {
  27. $info = $stm->errorInfo();
  28. Minz_Log::record ('SQL error : ' . $info[2], Minz_Log::ERROR);
  29. return false;
  30. }
  31. }
  32. }