6 # Updates the rank field in the stats database.
8 # Copyright (C) 2001 Andreas Ulbrich, Ralf Ertzinger (ndccode@ndc.sh)
10 # This program is free software; you can redistribute it and/or modify
11 # it under the terms of the GNU General Public License as published by
12 # the Free Software Foundation; either version 2 of the License, or
13 # (at your option) any later version.
15 # This program is distributed in the hope that it will be useful,
16 # but WITHOUT ANY WARRANTY; without even the implied warranty of
17 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 # GNU General Public License for more details.
20 # You should have received a copy of the GNU General Public License
21 # along with this program; if not, write to the Free Software
22 # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
31 $data_source = "DBI:mysql:$database";
34 $dbh = DBI->connect( $data_source, $username, $password) or die "Can't connect to $data_source\n"; #: $dbh->errstr\n";
37 $query = $dbh->prepare("SELECT nick FROM PlayerStats WHERE fe_skill > 0 ORDER by fe_skill DESC");
42 while ($row_hash = $query->fetchrow_hashref) {
43 $name = $row_hash->{nick};
45 $rank{$name} = $rank++;
50 foreach $name (%nick) {
52 $sql_query_string = "UPDATE PlayerStats SET fe_rank=? WHERE nick=?";
53 $sql_query=$dbh->prepare($sql_query_string);
54 $sql_query->execute($rank{$name},$nick{$name});