UPDATE, no me actualiza la base de datos, que esta mal

[memoadian]

ya imrpimiste la consulta y la pegaste como te puse el ejemplo?

prueba así:

Código PHP:

// Script
        $votenew = ($account_extra["vote_points"] - $shop1["vote_points"]);
        $creditnew = ($account_extra["credit-store"] - $shop1["credit-store"]);
        $sql = "UPDATE $server_db.users SET users.vote_points = '".$votenew."', users.credit-store = '".$creditnew."' WHERE users.id = '".$id."' AND users.avatar = '".$avatar."' AND users.blizz = '".$blizz."' AND users.class = '".$class."' AND users.firstName = '".$firstName."' AND users.lastName = '".$lastName."' AND users.character = '".$character."'";
        echo $sql;
        $result = mysql_query($sql,$connection_setup);