site_id of FTP,PS,IPoker,Party please

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

site_id of FTP,PS,IPoker,Party please

Postby Eric Poker » Fri Oct 03, 2008 2:35 pm

What is the site_id # of FTP,PS,IPoker,Party ?

Thanks
Eric Poker
 
Posts: 104
Joined: Sat Mar 15, 2008 3:47 pm

Re: site_id of FTP,PS,IPoker,Party please

Postby WhiteRider » Fri Oct 03, 2008 3:25 pm

This will be different for everyone (I believe), depending on the order sites were first imported from.
You could build a custom stat to display the site id along with its name..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: site_id of FTP,PS,IPoker,Party please

Postby Eric Poker » Fri Oct 03, 2008 4:20 pm

ok
I won't use this for a repository then :)

What is the 3 letters abv for every site ?
Eric Poker
 
Posts: 104
Joined: Sat Mar 15, 2008 3:47 pm

Re: site_id of FTP,PS,IPoker,Party please

Postby WhiteRider » Fri Oct 03, 2008 6:01 pm

This is what it says in my DB.
100;"PS";"PokerStars"
200;"PTY";"Party"
300;"FTP";"Full Tilt"
400;"IPN";"iPoker"
500;"EVP";"Everest"
600;"PR";"OnGame"

I may have been wrong, these numbers could be the same for everyone - I don't have any hands imported from Everest or OnGame.

You can see this in PGAdmin.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: site_id of FTP,PS,IPoker,Party please

Postby Eric Poker » Fri Oct 03, 2008 6:44 pm

I'm a total moron with pgadmin :D
I think I had the same #
Eric Poker
 
Posts: 104
Joined: Sat Mar 15, 2008 3:47 pm

Re: site_id of FTP,PS,IPoker,Party please

Postby Josh » Sun Oct 05, 2008 11:00 am

The numbers are the same for everyone.
Josh
Site Admin
 
Posts: 6222
Joined: Sat Dec 08, 2007 6:03 pm


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 1 guest