» Find Revision
L2J Revision 4446:
L2JDP Revision 7703:
Hello ves a more personal, I'm with a mistake here and you can not resolve at all.
I have a script to vote for Gracia and will not work in Freya L2jServer tried everything nothing worked always the same error.
ERRO: Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/phoenix/public_html/vote/inc/functions.php on line 155
Location of the error:
Code: Select all
function receberItem($login,$dono,$pontos,$necessarios,$quantia,$recompensa) { if($pontos >= $necessarios) { $confere = mysql_query("SELECT * FROM items WHERE owner_id = '$dono' AND item_id = '$recompensa'"); $resultado = mysql_num_rows($confere); // $deletatodos = mysql_query("DELETE FROM items WHERE (owner_id = '$dono') AND (item_id = '$recompensa')"); $query = mysql_query("INSERT INTO items (owner_id, object_id, item_id, count, loc, loc_data, price_sell, price_buy) VALUES ('$dono', '".newObId()."', '$recompensa', '$quantia', 'WAREHOUSE', '0', '0', '0')"); #Gracia //$query = mysql_query("INSERT INTO items (owner_id, object_id, item_id, count, enchant_level, loc, loc_data, time_of_use, custom_type1, custom_type2, mana_left, time) VALUES ('$dono', '".newObId()."', '$recompensa', '$quantia', '0', 'WAREHOUSE', '0', null, '0', '0', '-1', '-1')"); $reduz = mysql_query("UPDATE accounts SET pontos_trocar=(pontos_trocar-$necessarios) WHERE login = '$login'"); $nome = mysql_query("SELECT char_name FROM characters WHERE obj_Id = '$dono'"); $rnome = mysql_result($nome,0);
If posted in the wrong place sorry my first post here in the forum