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
by 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
by 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]
Users browsing this forum: No registered users and 8 guests