Quote:

---

//LOGIN STERINGS
string Login_Query; // holds the mysql query
string username[16]; // holds the username
string password; // holds the password
string libmysqldll = <libmysql.dll>;
var_nsave mysql_handle;

---

Quote:

---

Then
Code:

---

////////////////////
//DATABASE FUNCTIONS
dllfunction mySQL_Connectdb(w,x,y,z); 
dllfunction mySQL_Closedb();
dllfunction mySQL_ExecQuery(string);
dllfunction mySQL_GetVal(x,y);
dllfunction mySQL_GetStr(string,x,y);
dllfunction mySQL_RowNumber();
dllfunction mySQL_IsConnected();

---

After this i have all of my panels/texts that are in the login script. have you added functions to these to handle the login scripts wich mine will be below.

Code:

---

////////////////////
//TEXT'S
text txtName 
{
	pos_x = 575;
	pos_y = 115;
	layer = 30;
	font fnt_century12;
	string username;
}
text txtPassword
{
	pos_x = 575;
	pos_y = 115;
	layer = 30;
	font fnt_century12;
	string password;

---

---

Quote:

---

Now for what is in my function Main.
Code:

---

//Main Function
function main()
{
	
	mouse_on();
	level_load(MPLevel); //Load the first level
	sleep(.2);
	While (!bat_set)
	{
		wait(1);
	}
	mysql_handle = dll_open(libmysqldll);	
	mySQL_Connectdb("databse","host","user","password");
}

---

---

Quote:

---

Ok now i have a buttony ou push then a login apears. within this is the login script that i use for the 2 Textxs that were showsn earlier.
Code:

---

mySQL_Connectdb("databse","host","user","password");
if(!mySQL_IsConnected()&&!mySQL_Connectdb("databse","host","user","password"))
{	
beep;
exit;	
}	
txtName.visible = on;					
inkey(username);	
txtName.visible = off;
txtPassword.visible = on;	
inkey(password);		
txtPassword.visible = off;		

str_cat(Login_Query, "select * from Accounts WHERE Account_Name='");		
str_cat(Login_Query, username);		
str_cat(Login_Query, "' AND Password='");		
str_cat(Login_Query, password);		
str_cat(Login_Query, "';");				
mySQL_ExecQuery(Login_Query);
if(mySQL_ExecQuery(Login_Query)&&mySQL_RowNumber()==1)
{				
Join_Game();	
}
else
{		
beep;	
exit;//if no entry, exit
		
}					

---

---