Jump to content

what command do I use to create a mySQL login?


Recommended Posts

yes I am not sure about the SELECT part like heres my registration

function addPlayer(thePlayer, username, email, password)
 
		playerIP = getPlayerIP( thePlayer )
		playerSerial = getPlayerSerial( thePlayer )
 
if ( username ) then
			addNewUser = mysql_query(connect_mysql, "INSERT INTO `players` (login, class, serial, email, password) VALUES ('"..username.."', '2', '"..playerSerial.."','"..email.."', '"..password.."')")
if( addNewUser) then
outputChatBox( "#FF0000*USER: #FFFF00Succesfully added: #FF0000"..username.." #FFFF00to the usersystem.", player, 0, 0, 0, true )
---			restartResource(getResourceFromName("usersystem"))
triggerClientEvent ( "hideLoginWindow", getRootElement())
triggerClientEvent ( "ShowChar", getRootElement())
setPlayerName(thePlayer, username)
else
outputDebugString("mysql_query failed" )
end
			mysql_free_result( addNewUser )
else
outputChatBox ("#FF0000*USER: #FFFF00User: #FF0000"..username.." #FFFF00 could not be found.", player, 0,0,0, true)
end
end
addEvent ("addPlayer", true)
addEventHandler("addPlayer", getRootElement(), addPlayer)

now how can I use the SELECT command and apply this data for users to login

Link to comment
yes I am not sure about the SELECT part like heres my registration
function addPlayer(thePlayer, username, email, password)
 
		playerIP = getPlayerIP( thePlayer )
		playerSerial = getPlayerSerial( thePlayer )
 
if ( username ) then
			addNewUser = mysql_query(connect_mysql, "INSERT INTO `players` (login, class, serial, email, password) VALUES ('"..username.."', '2', '"..playerSerial.."','"..email.."', '"..password.."')")
if( addNewUser) then
outputChatBox( "#FF0000*USER: #FFFF00Succesfully added: #FF0000"..username.." #FFFF00to the usersystem.", player, 0, 0, 0, true )
---			restartResource(getResourceFromName("usersystem"))
triggerClientEvent ( "hideLoginWindow", getRootElement())
triggerClientEvent ( "ShowChar", getRootElement())
setPlayerName(thePlayer, username)
else
outputDebugString("mysql_query failed" )
end
			mysql_free_result( addNewUser )
else
outputChatBox ("#FF0000*USER: #FFFF00User: #FF0000"..username.." #FFFF00 could not be found.", player, 0,0,0, true)
end
end
addEvent ("addPlayer", true)
addEventHandler("addPlayer", getRootElement(), addPlayer)

now how can I use the SELECT command and apply this data for users to login

yeah I have something similar...is SELECT the command I use? like something along the lines of SELECT 'players' (login, and password) if they match it means login? I have no clue

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...