Freebitcoin script not full working / fixed it

[CedzyC]

Hi, i found a error in your freebitcoin/freedogecoin script. The script should read something from the database, but the column does not exist at all. I reworked it once.

First i have added this in db_scheme:

CREATE

TABLE results ( uid int(11) NOT NULL, user_uid int(11) NOT NULL, platform varchar(100) COLLATE utf8_unicode_ci NOT NULL, value double NOT NULL, address varchar(255), timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

After that:

function update_user_result_id($user_uid,$platform,$new_id) { $user_uid_escaped=db_escape($user_uid); $platform_escaped=db_escape($platform); $new_id_escaped=db_escape($new_id);

    $exists=db_query_to_variable("SELECT 1 FROM `results` WHERE `platform`='$platform_escaped' AND `address`='$new_id_escaped'");

    if(!$exists) {
            db_query("INSERT INTO `results` (`user_uid`,`platform`,`address`,`value`) VALUES ('$user_uid_escaped','$platform_escaped','$new_id_escaped',0)

ON DUPLICATE KEY UPDATE address=VALUES(address)"); } }

And:

echo "id $id dogecoin $dogecoin\n"; $id_escaped=db_escape($id); $user_uid=db_query_to_variable("SELECT user_uid FROM results WHERE address='$id_escaped'"); if(!$user_uid) { echo "User not found\n"; continue; } $user_uid_escaped=db_escape($user_uid); $dogecoins_balance=db_query_to_variable("SELECT value FROM results WHERE address='$id_escaped'"); $balance_diff=$dogecoin-$dogecoins_balance; if($balance_diff>0) { echo "New $balance_diff DOGE, add to $user_uid\n"; update_user_results($user_uid,"Freedogecoin",$dogecoin); } else { echo "No balance change"; }