Reset manual icons/colors in hud

[attackernone]

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

[udbrky]

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

[Sarek]

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)

[attackernone]

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

[udbrky]

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.