Originally Posted by
udbrky
Does it happen with fewer players in the alias? Does it happen with your hero?
Sometimes, if there are other players that have multiple hole cards showing can be read as the hero. This causes their hands to reset on the table, as if they were you. Note that editing the database could result in a corrupt database so only attempt this if you know what your doing. Please see these steps to reset the hero:
1) Please open PGAdminIII (Start - Postgres)
2) Enter your pw (default is postgrespass)
3) Open databases - expand DB name - expand schemas - expand public - expand Tables
4) Choose settings, right click - view data, show all rows
5) Clear the value in the second row (current player)
6) Restart HM2
PGAdmin info screen looks like this:
http://i291.photobucket.com/albums/l...dbrky/null.png
It is ok with 7000 players.
With 7500 it is not ok.
Tested with smaller and larger dataBase.
It does not happen with my hero.
"Note that editing the database could result in a corrupt database so only attempt this if you know what your doing."
It's fine i test it on new database. Thanks for the info though.
I want that more players work with alliases, what i do is:
step 1 SQL query:
Code:
INSERT INTO players (playername, pokersite_id, cashhands, tourneyhands, optimizationstatus, icon)
VALUES ('Global alias', -1, 0, 0, 0, 0)
RETURNING player_id;
get for example: 20168
step 2:
Code:
INSERT INTO aliases
SELECT 20168, p1.player_id
FROM players p1
WHERE p1.player_id NOT IN
(
SELECT a1.player_id
FROM aliases a1
WHERE a1.aliasplayer_id = 20168
-- to exclude players yet inserted
)
AND p1.player_id NOT IN
(
SELECT a2.player_id
FROM players p2 JOIN aliases a2 ON p2.player_id = a2.aliasplayer_id
WHERE p2.pokersite_id = -1 and p2.playername = 'Hero'
-- to exclude hero nicknames from the insert
)
AND p1.pokersite_id <> -1
AND p1.player_id < 8000
-- to exclude other aliases
;
instead 8000 for
Code:
AND p1.player_id < 7000
it works, but for more it does not :/
then i do this 2 things:
http://i.imgur.com/DTFZ2Jf.png
http://i.imgur.com/XuEuybC.png
and then when i change do "global alliases" HM2 throws this error and i have to shutdown it.
For me-> hero it is fine and the HM2 won't shutdown.
This time additionaily i will remove main hero as you described above:
http://i.imgur.com/z9A2Usg.png
now i can open HM2:
still it changed to me as active player automaticlly - but it's fine it's still works.
now i select global alliases as player: http://i.imgur.com/vKB8igU.png
and the error is here: http://i.imgur.com/3TSaBWX.png
removed global alliases from HM2 manually, did that once more with 7k players, and then HM2 does not throw an error.
Maybe sometimes you need to hit "refresh" button.
:/
and i think i did it twice with 7000 players - then i get other players on the same database :/