mysql_query check

[DarkWolfX10]

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.

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 


thanks

[Jinbei]

Hey,

please use this service:

Somebody can help you certainly.
#closerequest

kind regards

[Nectix]

#closed