Tennis Tipping Statistics Website - New URL tt-statistics.info - Page 61 - MensTennisForums.com
 7Likes
 
LinkBack Thread Tools
post #901 of 1948 (permalink) Old 07-19-2012, 10:48 AM
-LIFETIME MEMBER-
 
AdeyC's Avatar
 
Join Date: Jan 2009
Posts: 14,169
                     
Re: Tennis Tipping Statistics Website - Working Again

Quote:
Originally Posted by -Evita- View Post
I have some good news First of all, the site is working again and hopefully it will keep working. If it goes down again, please PM me.

Second, I noticed there's a very complicated SQL request to the database that seems to get stuck sometimes and possibly causes the site to become slower. sfar helped me identify this request, it's from the Tournament Winners page so I've removed the link to this page until I can fix this issue. So I hope the site will be faster and more reliable now.

Let's try to keep it up to date
You can count on me to help out - as I use it a lot for Managing I feel it only right for me to put something back in.

You can contact me on my TF Account or adriancollins@hotmail.com. I rarely log on here anymore
AdeyC is offline  
Sponsored Links
Advertisement
 
post #902 of 1948 (permalink) Old 07-19-2012, 01:59 PM
Registered User
 
tennismaster882001's Avatar
 
Join Date: Apr 2004
Posts: 1,600
                     
Re: Tennis Tipping Statistics Website - Working Again

Is it really working, won't open for me now.
tennismaster882001 is offline  
post #903 of 1948 (permalink) Old 07-19-2012, 02:10 PM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,821
                     
Re: Tennis Tipping Statistics Website - Working Again

No, damn it I'll go home in a couple of hours and check it, maybe someone has the tournament winners link saved and is still trying to open the page. I hope

Edit: No, it turns out the underlying issue (whatever it is) still hasn't been fixed I contacted the server support people again and they're telling me to restart the server again

한국어 너무 좋아요

Last edited by -Evita-; 07-19-2012 at 04:58 PM.
-Evita- is offline  
post #904 of 1948 (permalink) Old 07-19-2012, 05:25 PM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,821
                     
Re: Tennis Tipping Statistics Website - Working (Sometimes)

The site is working again at the moment. Maybe the complicated SQL statement did cause it after all, I discovered several database connections that were stuck on it after I restarted the DB process. I removed the file that contained this statement from the server though so hopefully nobody will be able to access it now. I'll monitor it closely in the next 24 hours.

한국어 너무 좋아요
-Evita- is offline  
post #905 of 1948 (permalink) Old 07-19-2012, 08:54 PM
Registered User
 
sfar's Avatar
 
Join Date: Mar 2011
Posts: 3,043
                     
Re: Tennis Tipping Statistics Website - Working (Sometimes)

Quote:
Originally Posted by -Evita- View Post
The site is working again at the moment. Maybe the complicated SQL statement did cause it after all, I discovered several database connections that were stuck on it after I restarted the DB process. I removed the file that contained this statement from the server though so hopefully nobody will be able to access it now. I'll monitor it closely in the next 24 hours.
I've been playing around with the web site and it runs smoothly.

When you can spend some time with this, please tell me if what I suggested to you by PM worked and check if those lines I told you from the statement are causing some trouble.

BTW, great job!!

Entry List / Draw Maker - TT Interactive Rankings
tennistipping.zz.mu


Tennis Tipping
Best rankings:
Singles: 132 (18/06/2012)
Doubles: 88 (06/08/2012)
sfar is offline  
post #906 of 1948 (permalink) Old 07-20-2012, 07:00 PM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,821
                     
Re: Tennis Tipping Statistics Website - The Green Color?

It's been more than 24 hours and no problems

On a slightly different subject - is anyone else tired of the green color of the website? I'm obviously no web designer but maybe I could change it to something better. Any ideas? If you do have an idea about how the site should look, the best would be if you drew it and then posted the design here as a picture. Then everyone could discuss it. You are also free to suggest how navigation should work.

한국어 너무 좋아요
-Evita- is offline  
post #907 of 1948 (permalink) Old 07-20-2012, 10:02 PM
-LIFETIME MEMBER-
 
AdeyC's Avatar
 
Join Date: Jan 2009
Posts: 14,169
                     
Re: Tennis Tipping Statistics Website - The Green Color?

Quote:
Originally Posted by -Evita- View Post
It's been more than 24 hours and no problems

On a slightly different subject - is anyone else tired of the green color of the website? I'm obviously no web designer but maybe I could change it to something better. Any ideas? If you do have an idea about how the site should look, the best would be if you drew it and then posted the design here as a picture. Then everyone could discuss it. You are also free to suggest how navigation should work.
Would it be possible to have the site give you the option of the background colour and/or colour of text?

You can contact me on my TF Account or adriancollins@hotmail.com. I rarely log on here anymore
AdeyC is offline  
post #908 of 1948 (permalink) Old 07-20-2012, 11:38 PM
Registered User
 
Thunderfish8's Avatar
 
Join Date: Apr 2011
Posts: 2,217
                     
Re: Tennis Tipping Statistics Website - The Green Color?

Quote:
Originally Posted by -Evita- View Post
It's been more than 24 hours and no problems

On a slightly different subject - is anyone else tired of the green color of the website? I'm obviously no web designer but maybe I could change it to something better. Any ideas? If you do have an idea about how the site should look, the best would be if you drew it and then posted the design here as a picture. Then everyone could discuss it. You are also free to suggest how navigation should work.
in terms of navigation, the only thing that would be helpful is a search bar for both players and/or tournaments because there are so many that finding it on the drop down menu is a pain

background... maybe a pale orange with purple font
or light blue/turquoise with purple font
the background shouldn't be too dark and the font shouldn't be too light otherwise it'll be painful to look at

Gulbis Ferrer Nishikori
Isner Nadal Dimitrov Istomin Wawrinka B. Baker

Berdych Monaco Granollers Leo-Mayer Troicki Roger-Vasselin Lu Paire

PAW Titles: Brisbane 2012 & 2014
FITD Titles: Marseille 2014
Tennis Tipping Titles
Singles: Orleans CH '11, Tampere CH '12, Medellin CH '12, Vancouver CH '15, Opava FUT '15
Doubles: Noumea CH '13 w/ Chirag, Cherbourg CH '14, Yokohama CH '15 w/ BMT360
Thunderfish8 is offline  
post #909 of 1948 (permalink) Old 07-21-2012, 12:47 AM
Registered User
 
kingroger's Avatar
 
Join Date: Aug 2009
Posts: 3,346
                     
Re: Tennis Tipping Statistics Website - Working Again

Will be back soon and upload new tournaments...

Yes it would be great to have a color change haha

Automatic ranking system?

TTS:#248 (High: #121) W (2)2012: Alphen CH, Szezecin CH
TTD: #252 (High: #26)
W (5) 2012: Caloundra CH w/TankingTheSet, Memphis w/Hellcat, Arad CH w/Marto - 2011: Cherbourg CH w/Kirilenko-Fan, Miami w/Kirilenko-Fan
DTT Singles: High: #1 - W Australian Open 2011, Madrid 2011, Tokyo 2011
DTT Doubles: High: #3 - W Wimbledon 2011, US Open 2011
kingroger is offline  
post #910 of 1948 (permalink) Old 07-21-2012, 06:14 AM
Registered User
 
sfar's Avatar
 
Join Date: Mar 2011
Posts: 3,043
                     
Re: Tennis Tipping Statistics Website - The Green Color?

I would put frames and borders in it and re-think the distribution of the main page.

Entry List / Draw Maker - TT Interactive Rankings
tennistipping.zz.mu


Tennis Tipping
Best rankings:
Singles: 132 (18/06/2012)
Doubles: 88 (06/08/2012)
sfar is offline  
post #911 of 1948 (permalink) Old 07-21-2012, 01:55 PM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,821
                     
Re: Tennis Tipping Statistics Website - The Green Color?

Quote:
Originally Posted by AdeyC View Post
Would it be possible to have the site give you the option of the background colour and/or colour of text?
Yes. Good idea.

Quote:
Originally Posted by Thunderfish8 View Post
in terms of navigation, the only thing that would be helpful is a search bar for both players and/or tournaments because there are so many that finding it on the drop down menu is a pain
That's a great idea too. It could work for tournaments but I'm not so sure about players because player names have all kinds of symbols in their names that are not on the standard keyboard. Hmm.

Quote:
background... maybe a pale orange with purple font
or light blue/turquoise with purple font
the background shouldn't be too dark and the font shouldn't be too light otherwise it'll be painful to look at
Can you go here, choose the color combinations you like and then post them here? Post the color number that is above the color picker, for example #6655A1.

Quote:
Originally Posted by kingroger View Post
Will be back soon and upload new tournaments...
Great

Quote:
Automatic ranking system?
Maybe someday

Quote:
Originally Posted by sfar View Post
I would put frames and borders in it and re-think the distribution of the main page.
Yup. A banner at the top, links on the left, everything else in the middle. Now I just need someone to make a banner

한국어 너무 좋아요
-Evita- is offline  
post #912 of 1948 (permalink) Old 07-22-2012, 02:55 PM
-LIFETIME MEMBER-
 
AdeyC's Avatar
 
Join Date: Jan 2009
Posts: 14,169
                     
Re: Tennis Tipping Statistics Website - The Green Color?

Name change to be done - tennisbabe999 to Anin

You can contact me on my TF Account or adriancollins@hotmail.com. I rarely log on here anymore
AdeyC is offline  
post #913 of 1948 (permalink) Old 07-28-2012, 10:40 AM Thread Starter
Come on, Ernest!
 
-Evita-'s Avatar
 
Join Date: Oct 2007
Posts: 16,821
                     
Re: Tennis Tipping Statistics Website - The Green Color?

Quote:
Originally Posted by AdeyC View Post
Name change to be done - tennisbabe999 to Anin
Done.

I also deleted Furth CH 2012 so it needs to be reentered.

한국어 너무 좋아요
-Evita- is offline  
post #914 of 1948 (permalink) Old 07-28-2012, 10:55 AM
Registered User
 
kingroger's Avatar
 
Join Date: Aug 2009
Posts: 3,346
                     
Re: Tennis Tipping Statistics Website - The Green Color?

New tournaments will be up tomorrow

TTS:#248 (High: #121) W (2)2012: Alphen CH, Szezecin CH
TTD: #252 (High: #26)
W (5) 2012: Caloundra CH w/TankingTheSet, Memphis w/Hellcat, Arad CH w/Marto - 2011: Cherbourg CH w/Kirilenko-Fan, Miami w/Kirilenko-Fan
DTT Singles: High: #1 - W Australian Open 2011, Madrid 2011, Tokyo 2011
DTT Doubles: High: #3 - W Wimbledon 2011, US Open 2011
kingroger is offline  
post #915 of 1948 (permalink) Old 07-28-2012, 04:41 PM
Registered User
 
tennismaster882001's Avatar
 
Join Date: Apr 2004
Posts: 1,600
                     
Re: Tennis Tipping Statistics Website - The Green Color?

hugocnamaral is wrongly inputed in mtftt as hugocrnamaral.
jahrastaman should really be jahrastaman_BR
Both need to be corrected.
tennismaster882001 is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the MensTennisForums.com forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in









Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.



Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome