| Re: Transferring PMs from one user to another |
| by arie1985 on 2009/11/10 11:34:18 I found how to do it using the PHPMYADMIN, very simple SQL, even if you dont know SQL just follow these easy steps: 1) Assume the admin is user ID 1, and you create a new user to transfer the PMs to him, let's refer him as Archive and his user ID is 5000. The user Id is shown on the profile of each XOOPS user, just as if you would click on my username in this website (Xoops.org) then you will see my user ID is 50673. 2) Go to PHPMYADMIN 3) Choose the "xoops_priv_msgs" (left tab) 4) Click on SQL 5) Type the following command: UPDATE `xoops_priv_msgs` SET `to_userid` = "5000" WHERE `to_userid`= 1 That will transfer all the PMs from Admin(1) to Archive(5000). That's it! If you want to transfer ONLY read messages so unread messages will remain in the Admin's inbox then just type it this way: UPDATE `xoops_priv_msgs` SET `to_userid` = "5000" WHERE `to_userid`= 1 and `read_msg` = 1 The `read_msg` field is 1 for read messages and 0 for unread messges. Goodluck 
|
| Transferring PMs from one user to another |
| by arie1985 on 2009/11/10 8:52:22 If the admin user is flooded with lots of old PMs, can he transfer the old PMs to a new "archive" user? I heard a such thing is possible but I'm not sure how to do it. Any advice?  Thanks! |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|