Site Numbers

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 Numbers

Postby TheProdigy » Sun Jan 27, 2008 3:05 am

Hey,

Where is the documentation on what sites are which numbers in the database? I found out FTP was '300' and stars was '100,' but didn't see this in the documentation.

Please excuse me if I looked over it
TheProdigy
 
Posts: 538
Joined: Sun Dec 09, 2007 1:20 am

Re: Site Numbers

Postby advis0r » Sun Jan 27, 2008 7:50 am

its stored in the "lookup_sites" table:
[codei48]SELECT * FROM lookup_sites

id_site site_abbrev site_name
100 "PS" "PokerStars"
200 "PTY" "Party"
300 "FTP" "Full Tilt"[/codei48]
advis0r
 
Posts: 137
Joined: Thu Jan 24, 2008 8:39 pm
Location: Southern Germany


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

Who is online

Users browsing this forum: No registered users and 8 guests

cron