Jump to content
Croqueta

Mysql quest ajuda.

Recommended Posts

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.."';")

Share this post


Link to post
Share on other sites

¿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]"'")

Share this post


Link to post
Share on other sites

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().."');")

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...