Форум сервера Counter-Strike компании IPTelecom

 1: // chande mysql stored data encoding from default to specified
 2: $config = array(
 3:             'host' => 'localhost',
 4:             'username' => 'ыть',
 5:             'password' => 'ыть',
 6:             'database' => 'ыть',
 7:             'charset' => 'utf8'
 8:             ); 
 9: 
10: // variables
11: $tables = array();
12: $items =  array();
13: @$do = $_GET['do'];
14: 
15: // mysql_set_charset legacy definition 
16: if (!function_exists('mysql_set_charset')) {
17:     function mysql_set_charset($charset,$dbh) {
18:         return mysql_query("set names $charset",$dbh);
19:     }
20: }
21: 
22: echo '<h3>Connecting...</h3>';
23: mysql_connect($config['host'],$config['username'],$config['password']);
24: echo mysql_error();
25: mysql_select_db($config['database']);
26: echo mysql_error();
27: 
28: echo '<h3>Getting tables...</h3>';
29: $result = mysql_list_tables($config['database']);
30: echo mysql_error();
31: while ($row = mysql_fetch_row($result)) $tables[] = $row[0];
32: echo implode(', ', $tables);
33: 
34: echo '<h3>Select...</h3>';
35: foreach($tables as $tablename) {
36:     $items[$tablename] = array();
37:     $result = mysql_query("SELECT * FROM $tablename");
38:     echo mysql_error();
39:     while ($row = mysql_fetch_assoc($result)) $items[$tablename][] = $row;
40: }
41: 
42: echo '<h3>Set charset...</h3>';
43: mysql_set_charset($config['charset']);
44: echo mysql_error();
45: 
46: echo '<h3>Update...</h3>';
47: // loop tables
48: mysql_query("START TRANSACTION");
49: foreach($items as $tablename=>$table) {
50:     echo "<h4>$tablename (" . count($table) . ")</h4>";
51:     // loop rows
52:     foreach ($table as $row) {
53:         $id = $row['id'];
54:         echo "$id ";
55: 
56:         $values = array();
57:         // loop fields
58:         foreach ($row as $field=>$value) {
59:             if($value && !is_numeric($value)) {
60:                 $value = mysql_real_escape_string($value);
61:                 $values[] = "$field='$value'";
62:             }
63:         }
64: 
65:         // build query
66:         $set = implode(',',$values);
67:         $query = "UPDATE $tablename SET $set WHERE id=$id";
68: 
69:         // test or go
70:         if($do=='go') {
71:             mysql_query($query);
72:             if($error = mysql_error()) echo "$error <hr/>";
73:         } else {
74:             echo "<textarea rows=3 cols=85>$query</textarea><br/>";
75:         }
76:     }
77: }
78: mysql_query("COMMIT");