First define the function:
Code:

---

 
//--------------------------------------------------------------------
// DLL-declarations
//--------------------------------------------------------------------
dllfunction mySQL_Connectdb(w,x,y,z); // declaration of a DLL function
dllfunction mySQL_Closedb();
dllfunction mySQL_ExecQuery(string);
dllfunction mySQL_GetVal(x,y);
dllfunction mySQL_GetStr(string,x,y);
dllfunction mySQL_RowNumber();
dllfunction mySQL_IsConnected();  

---

Then you can connect to the database with this little piece of code:
Code:

---

 mySQL_Connectdb("database","localhost","username","password") 

---

Change the database, localhost, username and password to your own.

Then you can execute a normal mysql query with mySQL_ExecQuery('query');
(there are tons of tutorials explaining this on the internet).

Now it's time to look at the information using either:
Code:

---

 
mySQL_GetVal(x, y); // gets the var value of the position x,y in the returned data
mySQL_GetStr(string, x, y); // assigns the value of x,y to the string string
 

---

Hope this helped a bit.

Yep this has helped allot.

Has anyone done any work on a user login and register part in there game? just thinking thru ho w the hell im gona go thru this in C, its not the same as doing it in php :P

Anyone got any tips?

I am working on a system for that right as I type, but I just started out so it may take a while before I have something to show.

Ok, now I've made a simple login system using inkey and a short sql query. It works quite well actually. First it takes input from the user stating both username and password, then it puts that information into a string containing a query for the a record with this username and password in the users table. If there is no such record it terminates, if it exists it continues to load information about the user from the db.

Thisis the bt that lost me, using the SQL in with C. how using th strings with the SQL? you have a small example? i learn faster that way lol.

done php about 2 years ago and it was much different using sql.

Im using Inkey anyway.

thanks

You can make the normal type of sql query:
select * from users WHERE username='USERNAME' AND password='PASSWORD';

You can create this string in c-script using the str_cat function:
Code:

---

 
		string query; // holds the mysql query
		string username; // holds the username
		string password; // holds the password

		//Take input here//

		str_cat(query, "select * from users WHERE username='");
		str_cat(query, username);
		str_cat(query, "' AND password='");
		str_cat(query, password);
		str_cat(query, "';"); 

---

The str_cat function basically adds the second string given to the function at the end of the first string. For more information on this function, look it up in the manual.

Ok. yep i understand this.

Now what happens if the user gets their password of username wrong? how do i check to see if its in the database and if its right or wrong? could i put this SQL into a IF statment?

You could check how many rows are returned after the query by using the command mySQL_RowNumber(). If it returns 1 then it should be ok, but if it returns 0 something is wrong because then it hasn't found anything.

Yes yes. but how? i really stuck here. i have inkey on the username? do i need 2 inkeys? no? And do i use if staments to work this out if theres a user in teh databse or not? is what ima sking :P

Do you know of any examples? been screwing my brain over this all night

Call this from main:
Code:

---

 

string query;
string username;
string password;

function userlogin(){
	
	if(!mySQL_IsConnected()&&!mySQL_Connectdb("dbname","localhost","dbuser","dbpass")){
	beep;exit;
	}
		
		
		inkey(username);
		inkey(password);
		
		str_cat(query, "select * from users WHERE username='");
		str_cat(query, username);
		str_cat(query, "' AND password='");
		str_cat(query, password);
		str_cat(query, "';");
		
		if(mySQL_ExecQuery(query)&&mySQL_RowNumber()==1){
			loggedinok=true;
		}else{
			exit;//if no entry, exit
		}
		

	//now you can gather info from the db
	
	mySQL_Closedb();
} 

---

This is a quick code I trew togheter, but you will see the main principles. Of course you may alter the code that exits if there is no such account, maybe show an error and let the user try again.