Announcement

Collapse
No announcement yet.

Query to update signatures

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

  • [Forum] Query to update signatures

    Can someone please post to me a query to purge all the users signatures from a specific usergroup? Using vB 4.20 PL2.

    Thanks!

  • #2
    Originally posted by TundraSoul View Post
    Can someone please post to me a query to purge all the users signatures from a specific usergroup? Using vB 4.20 PL2.

    Thanks!
    Run the following query at the sql box at either phpmyadmin or at your acp. For the latest, you must have enabled the run of the query at the config.php file for your admin uid.


    Code:
    UPDATE usertextfield
    LEFT JOIN user ON (user.userid = usertextfield.userid)
    SET signature = '' 
    WHERE user.usergroupid = x;

    Replaxe x with the actual id of the group whose signatures you would like to delete. Also if you are using a prefix for your tables, append it to the table names at the query above. Hope it helps.

    Comment


    • #3
      Also, please make a backup of your database before running any query. (Just in case the result is not what you want.)

      Please don't PM or VM me for support - I only help out in the threads.
      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
      Want help modifying your vbulletin forum? Head on over to vbulletin.org
      If I post CSS and you don't know where it goes, throw it into the additional.css template.

      W3Schools <- awesome site for html/css help

      Comment

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