Croqueta Posted January 22, 2013 Report Share Posted January 22, 2013 nesesito estas funciones de mysql pero no pasa nada name = pc.get_name() local player_id= mysql_query("SELECT account_id from player.player WHERE name='"..name.."';") mysql_query("UPDATE account.account SET status='BLOCK' WHERE id='"..player_id.."';") Link to comment Share on other sites More sharing options...
KeKo Posted January 22, 2013 Report Share Posted January 22, 2013 Te dice algo el bsd cuando ejecutas la query en plan sintax error? Link to comment Share on other sites More sharing options...
Croqueta Posted January 22, 2013 Author Report Share Posted January 22, 2013 no me da un error es que no pasa nada Link to comment Share on other sites More sharing options...
ElRaulxX Posted January 29, 2013 Report Share Posted January 29, 2013 ¿Estás seguro que tienes definida la función en questlib? Aún así, la sintaxis sería: local player_id = mysql_query("SELECT account_id from player.player WHERE name ='"..name.."'") mysql_query("UPDATE account.account SET status ='BLOCK' WHERE id ='"player_id.account_id[1]"'") Link to comment Share on other sites More sharing options...
Croqueta Posted January 31, 2013 Author Report Share Posted January 31, 2013 gracias raul pero lo corregi solo, la ise de otra forma mysql_query("UPDATE account.account SET status ='BLOCK' WHERE id =(SELECT account_id FROM player.player WHERE name ='"..pc.get_name().."');") Link to comment Share on other sites More sharing options...
.png.baa68f22b2d02704a1a918ed3a8ae985.png.1fea0f4d835688771a54119d1cd217c1.png)
Recommended Posts