Reset manual icons/colors in hud
Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    Feb 2014
    Posts
    31

    Default Reset manual icons/colors in hud

    Hi,

    I have given a lot of players an icon/color (outline) in the hud by hand.
    I want to use a new color coding system, so I want to remove all my manual icons/colors.
    How do I do that?

    Thanks

  2. #2
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    19,759

    Default

    Open up PGAdminIII. This is in Start Menu - All Programs - Postgres.

    See the screenshot. Expand the server, put in your password, then expand at the places the red line indicates.

    In the Icon field, change all of the entries to -1

    Or, you could create a new database and use the auto rate rules in it. Keep in mind that Stars and FTP do not allow auto rate any more. It all has to be manual.

    We are looking into an SQL query to use. If it works, we will post it in here.

    autoratepg.PNG
    Regards udbrky (Chris)

  3. #3
    Holdem Manager Support Sarek's Avatar
    Join Date
    May 2010
    Location
    Eridani 40
    Posts
    21,041

    Default

    Alternative way, for "advanced" PC users, so no further comments
    If you have additional questions - do NOT try to do this!

    Start Pgadmin, expand the server till you can see list of databases
    then put cursor on YOUR database, press
    Ctrl+E
    this opens Query builder window
    paste this text
    update players set icon = -1 where icon >0
    and press F5

    Make sure you run query on database you need to change (in case you have more than one)

  4. #4
    Member
    Join Date
    Feb 2014
    Posts
    31

    Default

    Thanks,

    I just tried it. I didn't understand the "simple" approach (or couldn't make it work).
    But the "advanced" approach was easy.

    Thanks both though

  5. #5
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    19,759

    Default

    You are very welcome. Thank you for letting us know it solved your problems. It helps us when crafting future replies to other customers with similar problems.

    Good luck at the tables. If you have any further questions or problems do not hesitate to ask us.
    Regards udbrky (Chris)

Similar Threads

  1. HUD colors gone...
    By epsylon in forum General Support
    Replies: 1
    Last Post: 10-03-2015, 07:19 AM
  2. How to reset a ton of custom popups to default colors?
    By MartinBKK in forum General Support
    Replies: 1
    Last Post: 06-30-2012, 06:59 PM
  3. Replies: 1
    Last Post: 03-05-2011, 05:50 PM
  4. Reset Player Icons for Auto Rate?
    By MicroRoller in forum Manager General
    Replies: 6
    Last Post: 03-10-2010, 07:35 PM
  5. hud colors
    By wadethomas in forum Manager General
    Replies: 2
    Last Post: 11-11-2008, 07:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •