UserDAO.php 1.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. <?php
  2. class FreshRSS_UserDAO extends Minz_ModelPdo {
  3. public function createUser($username) {
  4. $db = Minz_Configuration::dataBase();
  5. require_once(APP_PATH . '/SQL/sql.' . $db['type'] . '.php');
  6. if (defined('SQL_CREATE_TABLES')) {
  7. $sql = sprintf(SQL_CREATE_TABLES, $db['prefix'] . $username . '_', Minz_Translate::t('default_category'));
  8. $stm = $c->prepare($sql);
  9. $ok = $stm && $stm->execute();
  10. } else {
  11. global $SQL_CREATE_TABLES;
  12. if (is_array($SQL_CREATE_TABLES)) {
  13. $ok = true;
  14. foreach ($SQL_CREATE_TABLES as $instruction) {
  15. $sql = sprintf($instruction, '', Minz_Translate::t('default_category'));
  16. $stm = $c->prepare($sql);
  17. $ok &= ($stm && $stm->execute());
  18. }
  19. }
  20. }
  21. if ($ok) {
  22. return true;
  23. } else {
  24. $info = $stm == null ? array(2 => 'syntax error') : $stm->errorInfo();
  25. Minz_Log::record ('SQL error : ' . $info[2], Minz_Log::ERROR);
  26. return false;
  27. }
  28. }
  29. public function deleteUser($username) {
  30. $db = Minz_Configuration::dataBase();
  31. require_once(APP_PATH . '/SQL/sql.' . $db['type'] . '.php');
  32. $sql = sprintf(SQL_DROP_TABLES, $db['prefix'] . $username . '_');
  33. $stm = $this->bd->prepare($sql);
  34. if ($stm && $stm->execute()) {
  35. return true;
  36. } else {
  37. $info = $stm == null ? array(2 => 'syntax error') : $stm->errorInfo();
  38. Minz_Log::record ('SQL error : ' . $info[2], Minz_Log::ERROR);
  39. return false;
  40. }
  41. }
  42. }