Hoe los ik dit op?

// UPDATE USER INFO
// ----------------
$user_row = mysql_fetch_array($user_query);

// loading click configuration
foreach(array('click','referalclick','premiumclick','premiumreferalc') as $item) {
    $query = mysql_query("SELECT price FROM config WHERE item='$item' AND howmany='1'") or die(mysql_error());
    $row = mysql_fetch_row($query);
    ${$item} = $row[0];
}

// updating money and visits for the user
mysql_query("UPDATE users SET money = money + IF(account='premium',$premiumclick,$click), visits = CONVERT(visits,UNSIGNED) + 1 WHERE username='$user'") or die(mysql_error());

// updating money and visits for the referer, if any
$referer=$user_row['referer'];
if ($referer!=''){
        mysql_query("UPDATE users SET money = money + IF(account='premium',$premiumreferalc,$referalclick), referalvisits = CONVERT(referalvisits,UNSIGNED) + 1 WHERE username='$referer'") or die(mysql_error());
}

// UPDATE USER INFO
// ----------------
$user_row = mysql_fetch_array($user_query);
 
// loading click configuration
foreach(array('click','referalclick','premiumclick','premiumreferalc') as $item) {
    $query = mysql_query("SELECT price FROM config WHERE item='$item' AND howmany='1'") or die(mysql_error());
    $row = mysql_fetch_row($query);
    ${$item} = $row[0];
}
 
// updating money and visits for the user
mysql_query("UPDATE users SET money = money + IF(account='premium',$premiumclick,$click), visits = CONVERT(visits,UNSIGNED) + 1 WHERE username='$user'") or die(mysql_error());
 
// updating money and visits for the referer, if any
$referer=$user_row['referer'];
if ($referer!=''){
        mysql_query("UPDATE users SET money = money + IF(account='premium',$premiumreferalc,$referalclick), referalvisits = CONVERT(referalvisits,UNSIGNED) + 1 WHERE username='$referer'") or die(mysql_error());
}

mysql_query("UPDATE users SET money = money + IF(vipmember='Yes',$vipclick,$click), visits = CONVERT(visits,UNSIGNED) + 1 WHERE username='$user'") or die(mysql_error());

mysql_query("UPDATE users SET money = money + IF(vipmember='Yes',$vipclick,$click), visits = CONVERT(visits,UNSIGNED) + 1 WHERE username='$user'") or die(mysql_error());