Hi, i'm trying to create a quest where the player name is registered and checked if the name is already on the DB, but i'm getting a problem when the quest makes the check it return itself and don't registe the player name and doesn't show the massage: "You were successfully registered!"
Can someone help me pls.
thanks
Can someone help me pls.
PHP Code:
local playername = pc.get_name()
local namecheck = mysql_query("SELECT player_name FROM player.event_test WHERE player_name='"..playername.."'")
if namecheck.player_name[1] == playername then
say_title(""..mob_name(npc.get_race).."")
say("")
say("You are already registered!")
say("")
return
end
mysql_query("INSERT player.event_test SET player_name='"..playername.."'")
say_title(""..mob_name(npc.get_race).."")
say("")
say("You were successfully registered!")
say("")
return
end
end
end