PDA

View Full Version : How to delete several players' hands from the database



masterlog
07-08-2013, 07:08 PM
Hi everyone,

The question is: how can you delete old hands of target several players from the database/hud. Wanted to delete old hands of some regular players that had 100k+ hands in my base. Purging hands doesn't suit me as I need to save most players' hands.

So after using google search I found posts about deleting players from postgresql with null hands. I went to pgadmin public tables -- players and search for cashhands > 100000 and delete those players. But before that I exported the amount of recent hands needed for those players from holdem manager.

The problem is that now after having successfully imported the hands in HM. Those players are not visible nor in the HM nor in the pgadmin.

So i would really appreciate if you could help me to resolve the situation without recreating new database.

Patvs
07-09-2013, 03:31 AM
It isn't possible to delete hands from specific opponents from the database.

chaosmate
08-07-2013, 09:06 AM
Hello!

It would be very useful for me too....

Waiting to be solved

Patvs
08-07-2013, 08:50 PM
This isn't possible. You can use a last number of hands filter (which will affect ALL players): hud options--> hud options. (of use a last number of months filter)