HowTo: Working Tournament M Values + Get M Specific Stats

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

Re: HowTo: Working Tournament M Values + Get M Specific Stats

Postby kraada » Fri Jun 25, 2010 8:57 am

Thanks we'll get back to you in your ticket.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: HowTo: Working Tournament M Values + Get M Specific Stats

Postby AAA Donnie » Sat Jun 26, 2010 4:29 am

Uhhhhhh....after all that.... please tell me I couldn't have just dl'd it here??? Seriously? :o

What is this?
Image

I was able to find the BB stat there and import it at least, but...???
AAA Donnie
 
Posts: 85
Joined: Fri Apr 25, 2008 11:46 pm

Re: HowTo: Working Tournament M Values + Get M Specific Stats

Postby kraada » Sat Jun 26, 2010 9:06 am

That stat no longer functions properly due to changes in the PT3 caching mechanism.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: HowTo: Working Tournament M Values + Get M Specific Stats

Postby AAA Donnie » Sat Jun 26, 2010 2:56 pm

Thank god! LOL! I was hoping it was something like that. Do u have any idea if the BB stat still works?

TY
AAA Donnie
 
Posts: 85
Joined: Fri Apr 25, 2008 11:46 pm

Re: HowTo: Working Tournament M Values + Get M Specific Stats

Postby AAA Donnie » Sat Jun 26, 2010 3:30 pm

AAA Donnie wrote:Thank god! LOL! I was hoping it was something like that. Do u have any idea if the BB stat still works?

TY


NM, I dl'd it. Seems to be working fine so far.
AAA Donnie
 
Posts: 85
Joined: Fri Apr 25, 2008 11:46 pm

Re: HowTo: Working Tournament M Values + Get M Specific Stats

Postby kraada » Sat Jun 26, 2010 5:09 pm

It will work until the cache is updated, then it will cease working - but the "This session" value in the tooltip (if you hover over the stat) will remain accurate.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: HowTo: Working Tournament M Values + Get M Specific Stats

Postby chicodacat » Fri Jul 09, 2010 12:58 am

can someone please let me know how to run a script in pgadmin?

do i need my password?

thx
chicodacat
 
Posts: 17
Joined: Fri Apr 11, 2008 1:24 pm

Re: HowTo: Working Tournament M Values + Get M Specific Stats

Postby kraada » Fri Jul 09, 2010 9:58 am

In PGAdmin, connect to your database (right click, click Connect), then click the little SQL notepad icon and paste the script in there and click the Run button. You will need the password to connect to the database; the default is dbpass.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: HowTo: Working Tournament M Values + Get M Specific Stats

Postby chicodacat » Fri Jul 09, 2010 12:32 pm

kraada wrote:In PGAdmin, connect to your database (right click, click Connect), then click the little SQL notepad icon and paste the script in there and click the Run button. You will need the password to connect to the database; the default is dbpass.


will try this shorty, TYTY.
chicodacat
 
Posts: 17
Joined: Fri Apr 11, 2008 1:24 pm

Previous

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

Who is online

Users browsing this forum: No registered users and 10 guests

cron
highfalutin