PDA

View Full Version : Tourney ID Query Script?



JustCuz
10-11-2009, 09:25 PM
Does any have (or could someone easily write) an SQL query script that I can run in PGAdmin III that will return the tourney ID's of tourneys for which I have not imported a tourney history?

With PT3, this was done by querying which tourneys had a value of 1 for finish and of 0 for prize, but there doesn't seem to be a similar, consistant indicator in HEM to show which tourneys haven't had their histories imported.

Thanks in advance for any suggestions.

fozzy71
10-11-2009, 10:53 PM
I have forwarded this thread to the developer for a reply.

Rvg72
10-12-2009, 01:30 PM
select tourneynumber from tourneydata where importtype_id <> 2

ImportType_ID of 2 = summary imported, 1 = hand history files and 3 = manually edited

Roy

stantheman
11-12-2009, 08:08 PM
if I want the ID from just from one site, ex Pokerstars, how do I do that?

Rvg72
11-15-2009, 11:18 PM
you would add a "And site_Id = 2"

Party = 0
FTP = 1
Stars = 2
Prima = 3
Ipoker = 4
Absolute/Cereus = 5
Crypto = 6
Bodog = 7
UB = 8
Ongame = 9
Everest = 10
Pacific = 12
Betfair = 14
Dracula = 15
Entraction = 16
Cake = 17

Roy