HOME

NEWS

CURRENT
TOURNAMENT

PREVIOUS

TOURNAMENT

UNIFIED CATEGORY

  LATEST TOURNAMENT NEWS

 

 
ATPR SPONSORS

 

 

borderline

 

 

View More Photos

 

borderline

DOWNLOADS

 
Subscribe to ATPR Mailing List
 ATPR Yahoo Groups

Casino Games
Games

 
 
line

 

  WELCOME TO ATPR WEBSITE

Independence Cup

 

BC DIVISION

 

Pos Team Play Win Games Avg.
 1 DQ-BC  7   27   275   3.8571
 2 EmerTX  7   25   284   3.5714
 3 Zeemer  7   25   278   3.5714
 4 RTC-BC  7   21   271   3.0000
 5 A Team1  7   20   255   2.8571
 6 FMTC  7   19   278   2.7143
 7 Wild  6   14   201   2.3333
 8 Bangsa Moro  6   11   193   1.8333

 

 
C DIVISION
Pos Team Play Win Games Avg.
 1A Team 2 8   38   353   4.7500
 2DQ-C 8   33   339   4.1250
 3RTC - Sultan 8   30   320   3.7500
 4Kiss My Ace 8   29   318   3.6250
 5Dansalan 8   22   282   2.7500
 6Hardballs 8   19   273   2.3750
 7Chosen 8   18   291   2.2500
 8RTC - Datu 8   14   239   1.7500
 9Piratas 8   12   248   1.5000
 
 

 

 

 

 

 

                                         

top tennis

 

line

 

 

line

 

View Lancaster Cup Awarding Ceremony Pictures
View Lancaster Cup Opening Ceremony Pictures

line
   
   
   

Register
Member

Partners

Forms

Blog

Committee

Links

Scores

Copyright ©2006 ATPR Tennis

Association of Tennis Players in Riyadh
"; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo "
U"; echo "  P 
"; echo ""; } function showuser() { echo ""; echo " "; echo " "; echo " "; //echo " "; echo " "; echo " "; echo " "; echo "
User : " . $_SESSION["username"]; echo "  P 
"; echo ""; } function validateuser() { $msconnect = mysql_connect('dennisp304.globatmysql.com', 'dennis2', 'd507721'); $msdb=mysql_select_db("dennis_data",$msconnect); $sqlquery=" select * from siteusers where userid='" . $_POST['userid'] . "' and password='" . $_POST['password'] . "'"; //echo $sqlquery; $msresults= mysql_query($sqlquery); if(mysql_num_rows($msresults)>0) { $row = mysql_fetch_array($msresults); $_SESSION["userid"]=$row['userid']; $_SESSION["username"]=$row['username']; $_SESSION["userlevel"]=$row['userlevel']; session_write_close(); $mdate = date('Y-m-d '); $t = time(); $h=date("H",$t)+10; $m=date('i',$t); $mToday = $mdate . $h . ":" . $m; $msresults= mysql_query("update siteusers set lastlogin='$mToday' where userid='" . $_POST['userid'] . "'"); } //mysql_free_result($msresult); mysql_close($msconnect); } function logoutuser() { session_destroy(); } function shownewcategory($mcount) { $msconnect = mysql_connect('dennisp304.globatmysql.com', 'dennis2', 'd507721'); $msdb=mysql_select_db("dennis_data",$msconnect); //$sqlquery=" select convert(char(10),datemodified,111) as datemod,changedby,category from playerscatlog where playerid= '" . $playerid . "' order by datemodified desc"; $sqlquery=" select fullname,category,prevcategory,DATE_FORMAT(catmodified,'%d %b') as catm, remarks from players where catmodified is not NULL and active=1 order by catmodified desc limit 0,$mcount "; //$sqlquery="select top $mcount * from playerscatlog"; //echo $sqlquery; $msresults= mysql_query($sqlquery); $mcount = mysql_num_rows($msresults); //echo "
total count " . $mcount; echo ""; echo " "; while ($row = mysql_fetch_array($msresults)) { echo ""; echo "" . ""; echo ""; } echo "
Name Category Effective Prev.Cat. Remarks
 " . $row['fullname'] . "   " . $row['category'] . "   " . $row['catm'] . "   " . $row['prevcategory'] . "   " . $row['remarks'] . "
"; mysql_free_result($msresult); mysql_close($msconnect); } //=============================================== function shownewmember($mcount) { $msconnect = mysql_connect('dennisp304.globatmysql.com', 'dennis2', 'd507721'); $msdb=mysql_select_db("dennis_data",$msconnect); //$sqlquery=" select convert(char(10),datemodified,111) as datemod,changedby,category from playerscatlog where playerid= '" . $playerid . "' order by datemodified desc"; $sqlquery=" select playerid,fullname,nickname,DATE_FORMAT(regdate,'%d %b, %Y') as regdate from players where regdate <> '0000-00-00' order by playerid desc limit 0,$mcount "; //$sqlquery="select top $mcount * from playerscatlog"; //echo $sqlquery; $msresults= mysql_query($sqlquery); $mcount = mysql_num_rows($msresults); //echo "
total count " . $mcount; echo ""; echo " "; while ($row = mysql_fetch_array($msresults)) { echo ""; echo ""; echo ""; } echo "
ID Name Nickname Registered
 " . $row['playerid'] . " " . $row['fullname'] . "   " . $row['nickname'] . "   " . $row['regdate'] . "
"; mysql_free_result($msresult); mysql_close($msconnect); } function showstanding($mdiv,$count,$group) { $msconnect = mysql_connect('dennisp304.globatmysql.com', 'dennis2', 'd507721'); $msdb=mysql_select_db("dennis_data",$msconnect); if (empty($group)) {$mdiv=$mdiv; $divtitle= $mdiv; } else { $divtitle= $mdiv . '-Group ' . $group; $mdiv = $mdiv . "' and teamgroup = '$group"; } //$sqlquery=" select convert(char(10),datemodified,111) as datemod,changedby,category from playerscatlog where playerid= '" . $playerid . "' order by datemodified desc"; $sqlquery=" SELECT scores.teamcd,shortname,logopath, sum( game >0 ) AS games, sum( win ) AS wins, sum( game ) AS gamepoint, ( sum( win ) / sum( game >0 )) AS ave FROM scores left join teams on scores.teamcd = teams.teamcd WHERE teams.division = '" . $mdiv . "' GROUP BY scores.teamcd,longname ORDER BY ave DESC,gamepoint DESC LIMIT 0 , $count"; //$sqlquery="select top $mcount * from playerscatlog"; if (empty($group)) {$mdiv=$mdiv;} else { $mdiv = $mdiv . "' and teamgroup = '$group"; } //echo $sqlquery; $msresults= mysql_query($sqlquery); $mcount = mysql_num_rows($msresults); //echo "
total count " . $mcount; //echo ""; echo "
"; echo " "; $ctr=0; while ($row = mysql_fetch_array($msresults)) { $ctr++; if($ctr/2 == round($ctr/2)){ $alttr = ""; }else{ $alttr = "odd"; } echo ""; echo ""; echo ""; } echo "
Pos Top $count for Division $divtitle Play Win Games Avg.
 " . $ctr . "" . $row['shortname'] . "" . "" . "" . " " . $row['games'] . "   " . $row['wins'] . "   " . $row['gamepoint'] . "   " . $row['ave'] . "
"; //mysql_free_result($msresult); mysql_close($msconnect); } /*function scrollscore() { $msconnect = mysql_connect('dennisp304.globatmysql.com', 'dennis2', 'd507721'); $msdb=mysql_select_db("dennis_data",$msconnect); //$sqlquery=" select convert(char(10),datemodified,111) as datemod,changedby,category from playerscatlog where playerid= '" . $playerid . "' order by datemodified desc"; $sqlquery=" SELECT teams.shortname, DATE_FORMAT( gamedate, '%d%/%m %a' ) AS gamedate, win, game FROM `scores` LEFT JOIN teams ON teams.teamcd = scores.teamcd WHERE updated > curdate( )-28 ORDER BY gameno DESC LIMIT 0,23"; //$sqlquery="select top $mcount * from playerscatlog"; //echo $sqlquery; $msresults= mysql_query($sqlquery); $mcount = mysql_num_rows($msresults); //echo "
total count " . $mcount; $text = ''; $mdate =''; while ($row = mysql_fetch_array($msresults)) { if ($mdate<>$row['gamedate']) { $mdate= $row['gamedate']; $text = ' || ' . $mdate . ' ' . $text . ' | ' . $row['shortname'] . ' ' . $row['win'] . ' ' .$row['game']; } else {$text = $text . " " . $row['shortname'] . ' ' . $row['win'] . ' ' .$row['game'];} } echo "

$text

"; } */?>