member_model_model.class.php 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. <?php
  2. defined('IN_PHPCMS') or exit('No permission resources.');
  3. pc_base::load_sys_class('model', '', 0);
  4. class member_model_model extends model {
  5. public function __construct() {
  6. $this->db_config = pc_base::load_config('database');
  7. $this->db_setting = 'default';
  8. $this->table_name = 'model';
  9. parent::__construct();
  10. }
  11. public function drop_table($tablename) {
  12. $tablename = $this->db_tablepre.$tablename;
  13. $tablearr = $this->db->list_tables();
  14. if(in_array($tablename, $tablearr)) {
  15. return $this->db->query("DROP TABLE $tablename");
  16. } else {
  17. return false;
  18. }
  19. }
  20. public function create_table($tablename) {
  21. $tablename = $this->db_tablepre.$tablename;
  22. $tablearr = $this->db->list_tables();
  23. if(!in_array($tablename, $tablearr)) {
  24. return $this->db->query("CREATE TABLE $tablename (`userid` int(10) unsigned NOT NULL, UNIQUE KEY `userid` (`userid`)) DEFAULT CHARSET=".CHARSET);
  25. } else {
  26. return false;
  27. }
  28. }
  29. /**
  30. * 修改member表会员模型
  31. * @param unknown_type $tablename
  32. */
  33. public function change_member_modelid($from_modelid, $to_modelid) {
  34. $tablename = $this->db_tablepre.'member';
  35. $this->db->update(array('modelid'=>$to_modelid), $tablename, "modelid='$from_modelid'");
  36. }
  37. }
  38. ?>