xe 에서 일반유저를 관리그룹으로 포함시키려면
2010.05.13 03:27
원문 : http://www.ischo.net -- 조인상 // 시스템 엔지니어
Writer : http://www.ischo.net -- ischo // System Engineer in Replubic Of Korea
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
본문 : http://www.ischo.net -- 조인상 //시스템 엔지니어
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
mysql> select * from xe_member_group;
+----------+-----------+--------------+----------------+------------+----------+------------+-------------+
| site_srl | group_srl | title | regdate | is_default | is_admin | image_mark | description |
+----------+-----------+--------------+----------------+------------+----------+------------+-------------+
| 0 | 1 | 관리그룹 | 20100506100444 | N | Y | | |
| 0 | 2 | 준회원 | 20100506100444 | Y | N | | |
| 0 | 3 | 정회원 | 20100506100444 | N | N | | |
+----------+-----------+--------------+----------------+------------+----------+------------+-------------+
3 rows in set (0.00 sec)
mysql> insert into xe_member_group_member
-> values ('0','1','172','20100512224227');
Query OK, 1 row affected (0.00 sec)
관리그룹은 1 정회원은 3
mysql> select * from xe_member_group_member;
+----------+-----------+------------+----------------+
| site_srl | group_srl | member_srl | regdate |
+----------+-----------+------------+----------------+
| 0 | 1 | 4 | xxxxxxxxxx |
| 0 | 2 | 4 | xxxxxxxxxx |
| 0 | 3 | 888 | xxxxxxxxxx |
| 0 | 3 | 4 | xxxxxxxxxx |
| 0 | 3 | 4 | xxxxxxxxxx |
| 0 | 3 | 4 | xxxxxxxxxx |
| 0 | 3 | 4 | xxxxxxxxxx |
| 0 | 3 | 1194 | xxxxxxxxxx |
+----------+-----------+------------+----------------+
8 rows in set (0.00 sec)
해서 나온 결과에서 4번멤버가 group_srl이 1 갖고 있으므로
888 멤버를 관리그룹으로 만들고 싶으면...
mysql> insert into xe_member_group_member
-> values ('0','1','172','20100512224227');
Query OK, 1 row affected (0.00 sec)
