yH50bXuu

1//Create table if it doesn't exists
2    $create_table = "CREATE TABLE IF NOT EXISTS `$script` (
3		uid VARCHAR (50) NOT NULL PRIMARY KEY,
4		username VARCHAR(30) NOT NULL
5	  )";
6    $mysqli->query($create_table);
7
8    //Add columns if they are not present
9    $db_columns = $mysqli->query("SELECT * FROM `$script`;")->fetch_array();
10    foreach ($progress as $col => $value) {
11        $lower_col = strtolower($col);
12//		echo "\nChecking for Column: ".$lower_col;
13        if (!isset($db_columns[$lower_col])) {
14//			echo "\nNeed to add column!!: : ".$lower_col;
15            $add_col = "ALTER TABLE `$script` ADD `$lower_col` INT NOT NULL DEFAULT 0;";
16            $mysqli->query($add_col);
17        }
18    }
19
20    //Update data
21    $db_user = $mysqli->query("SELECT * FROM `$script` WHERE uid = '$uid';");
22    if ($db_user->num_rows) {
23        //User exists
24//		echo "\nUser already exists updating vals";
25        $user_row = $db_user->fetch_assoc();
26        $update_user = "UPDATE `$script` SET ";
27        foreach ($progress as $col => $value) {
28            $lower_col = strtolower($col);
29            $new_value = intval($user_row[$lower_col]) + intval($value);
30            $update_user .= "$lower_col = $new_value, ";
31        }
32        $update_user .= "username = '$username' WHERE uid = '$uid';";
33//		echo $update_user;
34        $mysqli->query($update_user);
35    } else {
36//		echo "\nUser needs to be added";
37        $user_row = $db_user->fetch_assoc();
38        $insert_user = "INSERT INTO `$script` (";
39        foreach ($progress as $col => $value) {
40            $lower_col = strtolower($col);
41            $insert_user .= "$lower_col, ";
42        }
43        $insert_user .= "username, uid) VALUES (";
44        foreach ($progress as $col => $value) {
45            $lower_col = strtolower($col);
46            $insert_user .= "$value, ";
47        }
48        $insert_user .= "'$username', '$uid');";
49//		echo $insert_user;
50        $mysqli->query($insert_user);
51    }
52    echo '{"result":"SUCCESS"}';