/var/www/hkosl.com/onegolf/webadmin/scores_index.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<?php
    
require_once('check_login.php');
    
$event_player_info = array();
    if(!empty(
$_GET["event_id"])){
        
$event_id = (int)$_GET["event_id"];
        
$event_player_info get_event_player($event_idNULL);
    }

    
$event_info get_event();
?>
<!DOCTYPE html>
<html>
<head>
    <?php require_once('html_head.php'); ?>

    <script type="text/javascript">
        function DeleteRow(id) {
            if (confirm("Are you sure to delete this record?")) {
                window.location.href = 'player_delete.php?id=' + id;
            }
        }
    </script>
</head>

<body>

<table width="1000" height="600" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td width="200" align="left" valign="top">
            <table width="200" border="0" cellpadding="0" cellspacing="0">
                <tr>
                    <td height="70" align="left" valign="middle">&nbsp;</td>
                </tr>
                <tr>
                    <td width="200" align="left" valign="top"><!-- Main Menu -->
                        <?php require("menu.php"); ?><!-- End Main Menu --></td>
                </tr>
            </table>
        </td>
        <td width="800" align="left" valign="top">
            <table width="800" border="0" cellpadding="0" cellspacing="0">
                <tr>
                    <td>
                        <table width="800" border="0" cellspacing="0" cellpadding="0">
                            <tr>
                                <td height="70" class="pagetitletxt">&nbsp;&nbsp;</td>
                                <td width="50" align="center" class="icontxt">
                                    <!--<a href="player_addform.php"><img src="images/iconNew.png" alt="Add" width="32" height="32" border="0"/><br/>&nbsp;Add&nbsp;&nbsp;
                                    </a>--></td>
                            </tr>
                        </table>
                    </td>
                </tr>
                <tr>
                    <td class="pagetitletxt">
                        &nbsp;&nbsp;<b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle"/> Scores </b></td>
                </tr>
                <tr>
                    <td height="25" align="left" valign="middle" class="msg"><?php if (!empty($_GET["msg"])) echo $msg?></td>
                </tr>

                <tr>
                    <td align="left" valign="middle">

                        <div style="padding-bottom: 10px;font-size: 12px; font-weight: bold;">
                            Event: <select name="event_id" onchange="location.href='scores_index.php?event_id='+this.value;">
                                <option value="0">--- Please select a event ---</option>
                                <?php
                                    
foreach($event_info as $event){
                                        echo 
"<option value='".$event["id"]."' ".($event["id"] == (int)$_GET["event_id"] ? "selected":"").">".$event["name"]."</option>";
                                    }
                                
?>
                            </select>
                        </div>
                        <table width="800" border="0" cellpadding="0" cellspacing="0">
                            <tr>
                                <td width="10" class="listtitletxt"></td>
                                <td width="20" class="listtitletxt">No.</td>
                                <td width="300" class="listtitletxt">Name</td>
                                <td width="100" class="listtitletxt">Gender</td>
                                <td width="80" class="listtitletxt">Last Update</td>
                                <td width="20" class="listtitletxt"></td>
                                <td width="20" class="listtitletxt"></td>
                            </tr>
                            <?php
                                $num 
1;

                                foreach (
$event_player_info as $row) {

                                    print 
"<tr>";
                                    print 
"<td class='listtxt' style='padding-left:5'>&nbsp;</td>";

                                    print 
"<td class='listtxt' style='padding-left:5'>".$num."</td>";
                                    
$num++;

                                    print 
"<td class='listtxt' style='padding-left:5'>" $row{'player_name'} . " [".str_pad($row["player_id"], 4"0"STR_PAD_LEFT)."]</td>";

                                    
$gender_info get_master_type_code("GENDER"$row["gender"]);
                                    print 
"<td class='listtxt' style='padding-left:5'>" $gender_info{'name_en'} . "</td>";

                                    
$score get_scores($row{'event_id'}, $row{'player_id'});
                                    print 
"<td class='listtxt' style='padding-left:5'>".$score{"lastupdate"}."</td>";

                                    
// Modify
                                    
print "<td class='listtxt' align='center'><a href='#' onClick=\"window.location='scores_modifyform2.php?event_id=" $row{'event_id'} . "&player_id=".$row{"player_id"}."'\"><img src='images/btnModify.png' title='Modify' alt='Modify' hspace='2' border='0'></a></td>";

                                    
// Delete
                                    
print "<td class='listtxt' align='center'><a href='#' onClick=\"DeleteRow(" $row{'id'} . ")\"><img src='images/btnDelete.png' title='Delete' alt='Delete' hspace='2' border='0'></a></td>";

                                    print 
"</tr>";
                                }
                                
$dbh null;
                            
?>
                        </table>

                    </td>
                </tr>
            </table>
        </td>
    </tr>
</table>

</body>
</html>