ok i have this at the top of the script:

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();

this at the bottom of the main function:

dll_open("A6mySQL.dll");
mySQL_Connectdb( "mytablename", "localhost", "myusername", "mypassword");

i have the two dll's in the directry my work is in and in the acknex_plugins folder.?? any ideas?

Jesus ****, about time lol.

Thanky you. i changed the

dll_open("A6mySQL.dll");
mySQL_Connectdb( "mytablename", "localhost", "myusername", "mypassword");

Form the top of my main to the bottom and it worked fine. wtf weird.

Thanks all this is a 5***** Topic.

hmm i can't connect to my database o_O
this is my script:

function fnc_connect_to_database()
{
wait(1);
dll_open("A6mysql.dll");
hr = mySQL_Connectdb("databse", "host", "user", "password");
while(1)
{
draw_text(str_for_num(blub, hr), 200,200, vector(0,0,255));
wait(1);
}
}

of course i used my real log in data in the script, but i can't connect.
my PHP files works all with thoose settings.

I can ping my website too so i don't think it's an internet problem? i even closed the firewall.

Do i have to tell 3dgs it should connect to the internet before i start it?
(i even can't do network tests with 3dgs anymore...)

well the variable hr always returns 0, so it's not connected.

Ok.

Just a couple of things i would like to know before i help.

What Version are you using?
Are you using Commercial or Pro?

Ok. Whats in your function main you need to connect to the Database within your Main function or before you do ANY querys. Have you donwloaded teh file that is on page one and put all DLL's in the right folders of your Game Studeio folder. Have you "Included" them into your script and all of teh commands.

For example. Below is every single bit of script i have in my login script for my game but it connects locally to 127.0.0.1 because i dont have pro..
Code:

---

//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;

---

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;

---

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");
}

---

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
		
}					

---

Ok thats it all of my scripts that are needed for a logging but make sure that te game is being hosted first or else it wil not work.

Make sure you downloaded the MYsql software that you need and that it is all hosted. If your doing it localy. if your doing it on a Dedicated server it should be on there. Make sure that the hjost of your Ded Server allows you to connect to the database like this it should.

If you are still havign problems the reply again you shoudl have ot tell it to connect to teh internet as your net should always be open. or you will have to connect.

Think thats everything.

that's a good explanation, thanks :>

you said: "but it connects locally to 127.0.0.1 because i dont have pro.."
Does it mean only the pro version can connect to a webserver?
Well i have the newest com version. So this might be the problem?

Yes. only Pro can connect to a web server. From what i understand this may be your problem.

You might have ot ask conitec them selfs but i think thats your problem im saving up for pro so i can do mor then 4 players

-_- so this will be the problem :<

That sucks a lot ^^'' Well i have no money for the pro so i better find another way...

Yes same here.

Just do what im doing do it locally and test it on a lan like i am you dont even need 2 computers just run server then player on teh same computer and connect to 127.0.0.1 and install all MYSql that you need on your computer. or you could just say connect to localhost , user = root, password what ver you set when you set it up.. Check page 1 to find out where you can get it from.

Good luck.

hmm yes, but i actually want people to connect over the internet to my server program and send there position and other informations to a database to save it there.
^^

Sounds like a way that may cause some Lag.

Lets see if i thinkw hat your saying is:
They to run the game
You to run game as server
Them to connect to your server over internet?
all stats saved to SQL server....

they will still have to connect to the server. you might still need pro..