Yep cool thank you very much, whilst waitign for a reply i spent an hour wopkring it all out and throwing some togather it runs but it doesnt work :P ill use yours as a guide lines lol thanks man.

if(!mySQL_IsConnected()&&!mySQL_Connectdb("******","localhost","root","****"))

it doesnt do ntohign i mean it beeps and exits liek it shoujdl if theres no conectionb ut there is a ocnection ebcaue there son in teh main

Stupid Kyias. dont wory blond monmey i didnt change teh sql.

ok no nvm i just trid it with eveyrthing correct it still exits and does not wotk.

Ok.

Sorted everything out and now. its saying. Not a valid dll. hmm ive tried all the dll's that are suplied and all of the DL's on the MYSQL Server i have and still nothin. i alsp updated patch and still no luck? can anyone help?

Do you have both:
libmysql.dll AND A6mysql.dll
in the acknex plug-in folder?

No. i dont.
Ther ein my work folder. i need them there? my work folder is not in the actual GStudio folder in Program folder

If they are in your work folder you need to be sure that you have opened the dll-file from inside the script before you try to use it.

Ok.

Im abotut o try both of these files are now in the plug folder. im only using Libmysql.dll

Its also in my publised folder.

Lets see the result. ill update in a bit later.

Do i need to open Libmysql and A6Mysql. because it still does not understand some of teh comands. but no more A6 error.

Done and dusted thanks. it works all good now.



5* topic here.

Well im back for more..


God damn.

All compiled to check what its like compiled run the EXE and it just doesnt like it. when it gets to checking to see weather or not the it is connected to the database it replies with a no. lol. and my game ends. but when i runt he game from C Script it works fine. wich i find strangley odd.


Any ideas? its not my fire wall i turned it off.

Oh another thing. i have LibMySQL.dll and A6MySQL.dll in the plugins folder and my compiled game folder. for some reason when i am running it through the C edditor it compiles the A6MySql.dll instead of the one that am telling it to use in my script wich is the LibMySql.dll


Heres the cutouts of my script wich im using.
Code:

---

string libmysqldll = <libmysql.dll>;
var_nsave mysql_handle;

..

---

Then in the main
Code:

---

	mysql_handle = dll_open(libmysqldll);
	mySQL_Connectdb("Database","localhost","root","yeah");

---

Finally teh actual script wich uses this.
Code:

---

if(!mySQL_IsConnected()&&!mySQL_Connectdb("Database","localhost","root","yeah"))
{
	beep;
	exit;	//If no conection to that database then give error
}	

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_Lan();	
}
else
{		
	beep;	
	exit;//Wrong exit
		
}	

---

I cant see what it is doing wrong. when compiled it doesnt work. when runt hrough C Script edditor it all works Ace. even tho its trying to use the A6 Dll.

Thanks.