Announcement

Collapse
No announcement yet.

need users move query...but how can I do that

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • need users move query...but how can I do that

    Hi

    I need to move all users have more than 300 posts from usergroupid 2 to usergroupid 12

    Thanks
    Last edited by BadGuy; Wed 17th Dec '08, 8:22am.

  • #2
    From the manual...
    http://www.vbulletin.com/docs/html/usergroup_promotions
    Lats...

    Comment


    • #3
      Hi

      That way didn't help , my forum have 230,000 users and I have more than 12,000 users have more than 300 and by that way its moving 1 user by 1 and for long time and till now I just moved 250 users .

      I need command to do it from mysql .

      I found this one :

      Code:
      UPDATE user
      SET usergroupid = 2
      WHERE usergroupid = 3
      AND joindate > UNIX_TIMESTAMP('2006-10-20 00:00:00')
      AND joindate < UNIX_TIMESTAMP('2006-10-22 00:00:00')
      But this by time not by how many posts .

      any one can help ?

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X