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
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
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)
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)
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
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)