Reply
Hekseville Citizen
Registered: 08/25/2009
Offline
321 posts
 

Re: TA site resurrected ... again

Apr 11, 2010

Hey Joban, just saw your new additions. Fantatstic. You can now do all summed and as I had hoped, I have cracked the top ten ... woohoo!!

I thought I might have sneaked into 9th but bombora is still active ... doh!

 

Couple of trivial comments - maybe 'Best summed' should read 'Fastest Summed' and 'All Summed' should read 'Original Tracks Summed'.

 

Also, I like the addition of the wrecks column. It lets you see how hard someone has worked to get their times. I am glad VIP doesn't count the number of restarts people do - that would be even more telling!!! It would be good to see that column in Best Summed as well.

 

Good work Joban.

Message 30 of 466 (481 Views)
Reply
0 Likes
I Only Post Everything
Registered: 04/20/2009
Offline
893 posts
 

Re: TA site resurrected ... again

Apr 11, 2010

 

Hi Ninja,

Ha, you already found it - so I dont need to announce it anymore


NinjaAtHome wrote:

Hey Joban, just saw your new additions. Fantatstic. You can now do all summed and as I had hoped, I have cracked the top ten ... woohoo!!

I thought I might have sneaked into 9th but bombora is still active ... doh!

 

Couple of trivial comments - maybe 'Best summed' should read 'Fastest Summed' and 'All Summed' should read 'Original Tracks Summed'.

 

Also, I like the addition of the wrecks column. It lets you see how hard someone has worked to get their times. I am glad VIP doesn't count the number of restarts people do - that would be even more telling!!! It would be good to see that column in Best Summed as well.

 

Good work Joban.


I'm not a native speaker, so I'll gladly accept improvements in wording, spelling, ...

I think fastest is really better. Will be done in a minute. But original tracks summed would be wrong! Try adding tracks=17,18 to the url and you'll see DLC tracks summed (or the shortcut tracks=0 for all tracks)

 

Adding wrecks to "best summed" would be nice but is technically (a bit) difficult to formulate in sql and was a bit slow. So I'll leave it out until I'm in the optimization phase. Will be some time for sure...

 

Next will be either a player profile page or clickable track/vehicle/querytype selections - dont know yet.

 

Other ideas in the pipeline include an all summed or fastest summed with a filter on where a given racer actually has times, Best/worst lists for a player and a missing tracks list. An improvements history is also in the works, not to forget some color and design... I need a clone

 

going online now...

 

SympathyCheck this out, if you like Motorstorm Rankings

RIP MSPR Smiley Sad - Burn in hell Sony Smiley Tongue

http://joban123.weebly.com
Message 31 of 466 (481 Views)
Reply
I Only Post Everything
Registered: 04/20/2009
Offline
893 posts
 

Re: TA site resurrected ... again

Apr 22, 2010

Clickable track/vehicle/querytype selections is done. Try it out and have fun

SympathyCheck this out, if you like Motorstorm Rankings

RIP MSPR Smiley Sad - Burn in hell Sony Smiley Tongue

http://joban123.weebly.com
Message 32 of 466 (481 Views)
Reply
Gaming Beast
Registered: 01/12/2009
Offline
2075 posts
 

Re: TA site resurrected ... again

Apr 22, 2010
i love it, very easy to use
Message 33 of 466 (481 Views)
Reply
0 Likes
I Only Post Everything
Registered: 04/20/2009
Offline
893 posts
 

Re: TA site resurrected ... again

Apr 23, 2010

Thanks wildheart. And here is yet another new feature

SympathyCheck this out, if you like Motorstorm Rankings

RIP MSPR Smiley Sad - Burn in hell Sony Smiley Tongue

http://joban123.weebly.com
Message 34 of 466 (481 Views)
Reply
Gaming Beast
Registered: 01/12/2009
Offline
2075 posts
 

Re: TA site resurrected ... again

Apr 23, 2010

sounds good mate, unfortunately i am unable to connect to the leaderboard part , probs cause its really busy

 

edit- lol i actually decided to pay attention to what i was reading and found the way to view it

 

also, is there a way to find out what times i am missing so i can show up on all summed?

Message 35 of 466 (481 Views)
Reply
0 Likes
I Only Post Everything
Registered: 04/20/2009
Offline
893 posts
 

Re: TA site resurrected ... again

Apr 23, 2010

 


wildheart90 wrote:

also, is there a way to find out what times i am missing so i can show up on all summed?


 

 

Apart from asking me? No, not yet. But this will be part of the player profile page that is coming soon...

 

 

Doest that look reasonable? Havent checked, just hacked...

 

 

$ db2 "select t.name as track, v.name as vehicle from track t, vehicle v where not exists (select 1 from ta, psn_id p where ta.track = t.id and ta.vehicle = v.id and ta.psn = p.id and p.name = 'wildheart90') order by t.id, v.id"

TRACK                          VEHICLE             
------------------------------ --------------------
Kanaloa Bay                    Bike                
Kanaloa Bay                    ATV                 
Kanaloa Bay                    Buggy               
Kanaloa Bay                    Rally Car           
Sugar Rush                     Buggy               
Sugar Rush                     Big Rig             
Mudslide                       Buggy               
Cascade Falls                  Bike                
Cascade Falls                  ATV                 
Cascade Falls                  Buggy               
Cascade Falls                  Rally Car           
Cascade Falls                  Big Rig             
Beachcomber                    Rally Car           
Colossus Canyon                Buggy               
Colossus Canyon                Mudplugger          
Caldera Ridge                  Buggy               
Caldera Ridge                  Big Rig             
Caldera Ridge                  Monster Truck       
Badlands                       Bike                
Badlands                       ATV                 
Badlands                       Rally Car           
Badlands                       Racing Truck        
Badlands                       Mudplugger          
Badlands                       Monster Truck       
The Edge                       Bike                
The Edge                       ATV                 
The Edge                       Buggy               
The Edge                       Racing Truck        
The Edge                       Mudplugger          
Paradise Beach                 Bike                
Paradise Beach                 ATV                 
Paradise Beach                 Rally Car           
Paradise Beach                 Racing Truck        
The Rift                       Buggy               
The Rift                       Racing Truck        
The Rift                       Big Rig             
The Rift                       Monster Truck       
Scorched                       ATV                 
Scorched                       Buggy               
Scorched                       Racing Truck        
Razorback                      ATV                 
Razorback                      Racing Truck        
Razorback                      Monster Truck       
Rain God Spires                Buggy               
Rain God Spires                Racing Truck        
Wildfire                       Bike                
Wildfire                       ATV                 
Wildfire                       Buggy               
Wildfire                       Racing Truck        
Wildfire                       Big Rig             
Wildfire                       Monster Truck       
Riptide                        ATV                 
Riptide                        Rally Car           
Riptide                        Racing Truck        
Riptide                        Big Rig             
Reef Runner                    Bike                
Reef Runner                    ATV                 
Reef Runner                    Buggy               
Reef Runner                    Rally Car           
Reef Runner                    Racing Truck        
Reef Runner                    Mudplugger          
Reef Runner                    Monster Truck       
Quick Sands                    ATV                 
Quick Sands                    Buggy               
Quick Sands                    Rally Car           
Quick Sands                    Racing Truck        
Quick Sands                    Mudplugger          
Engorged                       Bike                
Engorged                       ATV                 
Engorged                       Buggy               
Engorged                       Rally Car           
Engorged                       Racing Truck        
Darkfire Swamp                 Bike                
Darkfire Swamp                 ATV                 
Darkfire Swamp                 Buggy               
Darkfire Swamp                 Rally Car           
Darkfire Swamp                 Racing Truck        
Darkfire Swamp                 Big Rig             
Darkfire Swamp                 Monster Truck       
The Rift Volcanic              Bike                
The Rift Volcanic              ATV                 
The Rift Volcanic              Buggy               
The Rift Volcanic              Rally Car           
The Rift Volcanic              Big Rig             
The Rift Volcanic              Monster Truck       
Scorched Volcanic              ATV                 
Scorched Volcanic              Buggy               
Scorched Volcanic              Rally Car           
Scorched Volcanic              Racing Truck        
Scorched Volcanic              Monster Truck       
Wildfire Volcanic              Bike                
Wildfire Volcanic              ATV                 
Wildfire Volcanic              Buggy               
Wildfire Volcanic              Rally Car           
Wildfire Volcanic              Mudplugger          
Wildfire Volcanic              Big Rig             
Wildfire Volcanic              Monster Truck       

  97 Satz/Sätze ausgewählt.

SympathyCheck this out, if you like Motorstorm Rankings

RIP MSPR Smiley Sad - Burn in hell Sony Smiley Tongue

http://joban123.weebly.com
Message 36 of 466 (481 Views)
Reply
0 Likes
Gaming Beast
Registered: 01/12/2009
Offline
2075 posts
 

Re: TA site resurrected ... again

Apr 24, 2010
are you kidding me!!! looks like i have my work cut out for me doing all those times again
Message 37 of 466 (481 Views)
Reply
0 Likes
Fender Bender
Registered: 11/26/2005
Offline
3301 posts
 

Re: TA site resurrected ... again

Apr 24, 2010

Im not entirely sure whether im supposed to update my times manually or if your site works off of VIP times. Anyway, it's been like a day and my time hasn't updated on your site.

 

I know I'm kinda anxious because this should bump me to 25th...

Message 38 of 466 (481 Views)
Reply
I Only Post Everything
Registered: 04/20/2009
Offline
893 posts
 

Re: TA site resurrected ... again

Apr 24, 2010
@Gravity2go: no manual update. I load the times once a day, starting at ~2am and import them into the database at noon (European time)

@Wildheart: are you saying, there should be more times? Then I'll check if they are Top1000 and if my query is ok (it looked reasonable for my missing tracks).
SympathyCheck this out, if you like Motorstorm Rankings

RIP MSPR Smiley Sad - Burn in hell Sony Smiley Tongue

http://joban123.weebly.com
Message 39 of 466 (481 Views)
Reply
0 Likes