Gamestudio Links
Zorro Links
Newest Posts
Data from CSV not parsed correctly
by EternallyCurious. 04/25/24 10:20
Trading Journey
by howardR. 04/24/24 20:04
M1 Oversampling
by Petra. 04/24/24 10:34
Zorro FIX plugin - Experimental
by flink. 04/21/24 07:12
Scripts not found
by juergen_wue. 04/20/24 18:51
zorro 64bit command line support
by 7th_zorro. 04/20/24 10:06
StartWeek not working as it should
by jcl. 04/20/24 08:38
folder management functions
by VoroneTZ. 04/17/24 06:52
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
3 registered members (EternallyCurious, Quad, vicknick), 700 guests, and 7 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Mega_Rod, EternallyCurious, howardR, 11honza11, ccorrea
19048 Registered Users
Previous Thread
Next Thread
Print Thread
Rating: 4
Page 13 of 24 1 2 11 12 13 14 15 23 24
Re: MySQL dll [Re: Michael_Schwarz] #41737
06/07/06 17:30
06/07/06 17:30
Joined: Mar 2006
Posts: 2,503
SC, United States
xXxGuitar511 Offline
Expert
xXxGuitar511  Offline
Expert

Joined: Mar 2006
Posts: 2,503
SC, United States
what about when u publish ur game? Then do you copy it to the .cd folder?

Does this DLL require PRO edition?


xXxGuitar511
- Programmer
Re: MySQL dll [Re: xXxGuitar511] #41738
06/08/06 10:30
06/08/06 10:30
Joined: Sep 2002
Posts: 8,177
Netherlands
PHeMoX Offline
Senior Expert
PHeMoX  Offline
Senior Expert

Joined: Sep 2002
Posts: 8,177
Netherlands
It works with A6 com and pro, I don't know about lower versions but it should work with every version that supports plug-in dlls...

Remember: You need the libmysql.dll too, just copy it into your project's .cd folder. Then you should be able to load the a6mysql.dll, which must also be copied into the project's folder.

Cheers


PHeMoX, Innervision Software (c) 1995-2008

For more info visit: Innervision Software
Re: MySQL dll [Re: PHeMoX] #41739
07/27/06 00:45
07/27/06 00:45
Joined: Oct 2002
Posts: 361
Germany Cologne
hack-panther Offline
Senior Member
hack-panther  Offline
Senior Member

Joined: Oct 2002
Posts: 361
Germany Cologne
THX
I am am so happy...
That is very cool an works 'boundlessly' with the A6 Com :-D

But one Problem:
When you not have the pro, every user can see your dbconnect-funktion,
therefore the passwort, too.
Is there a secure possibility to hide the passwort?

But THX Again...
It`s "GEIL" :-D

Sry for bad english

Re: MySQL dll [Re: hack-panther] #41740
07/27/06 04:45
07/27/06 04:45
Joined: Aug 2003
Posts: 7,439
Red Dwarf
Michael_Schwarz Offline
Senior Expert
Michael_Schwarz  Offline
Senior Expert

Joined: Aug 2003
Posts: 7,439
Red Dwarf
Quote:

THX
I am am so happy...
That is very cool an works 'boundlessly' with the A6 Com :-D

But one Problem:
When you not have the pro, every user can see your dbconnect-funktion,
therefore the passwort, too.
Is there a secure possibility to hide the passwort?

But THX Again...
It`s "GEIL" :-D

Sry for bad english




you could do a DLL that passes the password, username and DB-adress to the engine. Contact me via PM so we can do something on that.


"Sometimes JCL reminds me of Notch, but more competent" ~ Kiyaku
Re: MySQL dll [Re: Michael_Schwarz] #41741
07/27/06 16:59
07/27/06 16:59
Joined: Jan 2004
Posts: 2,013
The Netherlands
E
Excessus Offline
Expert
Excessus  Offline
Expert
E

Joined: Jan 2004
Posts: 2,013
The Netherlands
That sounds like a really bad idea.

You shouldn't try to hide the password. Instead make sure the user can only do what he is supposed to do with that password. What I mean is that you should limit the rights for that account on the server side. That way, even if they have the password and connect to your server they can only do what they are allowed to do(which is the same as the app would normaly do).

Re: MySQL dll [Re: Excessus] #41742
07/29/06 15:02
07/29/06 15:02
Joined: Oct 2002
Posts: 361
Germany Cologne
hack-panther Offline
Senior Member
hack-panther  Offline
Senior Member

Joined: Oct 2002
Posts: 361
Germany Cologne
When i do a query the game freeze mostly for a very short moment.

Is this known?

Can you improve this or is that not possible?

Re: MySQL dll [Re: Excessus] #41743
07/30/06 02:06
07/30/06 02:06
Joined: Aug 2003
Posts: 7,439
Red Dwarf
Michael_Schwarz Offline
Senior Expert
Michael_Schwarz  Offline
Senior Expert

Joined: Aug 2003
Posts: 7,439
Red Dwarf
Quote:

That sounds like a really bad idea.

You shouldn't try to hide the password. Instead make sure the user can only do what he is supposed to do with that password. What I mean is that you should limit the rights for that account on the server side. That way, even if they have the password and connect to your server they can only do what they are allowed to do(which is the same as the app would normaly do).




imagine this: an MMORPG, we need to write/change and delete(delete account) data. so anyone could just login and delete all other users, or just make his char "ubar"... hiding the password in this case is ESSENCIAL.


"Sometimes JCL reminds me of Notch, but more competent" ~ Kiyaku
Re: MySQL dll [Re: Michael_Schwarz] #41744
08/09/06 23:57
08/09/06 23:57
Joined: Aug 2006
Posts: 2
Albysan Offline
Banned
Albysan  Offline
Banned

Joined: Aug 2006
Posts: 2
This would seems like a very nice dll if i could get it to work...

What happens:

* If i put the dll in the acknex plugin folder only it says it can't load the dlls even if i put plungindir ("C:\Program Files\GStudio6\acknex_plugins") its like it doesn't exist.

* If i put it in the work folder it says that the dlls are not valid acknex dlls. well that is a start at least it recognises the dlls, even if it is not usefull at all.

* If i put one at a time, it's not any better i just get one error message instead of two (one for each dll)

this is my code (with a LOT of variations, i've tested a lot of things without success):


plugindir"C:\Program Files\GStudio6\001_Project_test_mysql";
//C:\Program Files\GStudio6\acknex_plugins
string libmysqldll = <libmysql.dll>;
string libmysqldlll = <A6mySQL.dll>;

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

var hr

Function main{
//dll_open(libmysqldll);
//dll_open(libmysqldlll);
hr = mySQL_Connectdb("test","localhost","root","********")
}

Oh yeah and another thing it doesn't recognise any of the dll functions, witch i suppose is normal since it doesn't recognise the dlls.

Can anybody help?
I would relly appreciate it.
Hope i've been clear enough thanx in advance
-----------------------------
Pro version 6.20
Mysql 4.1 and 5 tested without success

Last edited by Albysan; 08/10/06 00:00.
Re: MySQL dll [Re: Albysan] #41745
08/11/06 12:13
08/11/06 12:13
Joined: Aug 2003
Posts: 7,439
Red Dwarf
Michael_Schwarz Offline
Senior Expert
Michael_Schwarz  Offline
Senior Expert

Joined: Aug 2003
Posts: 7,439
Red Dwarf
First: "C:\Program Files\GStudio6\001_Project_test_mysql" is no valid path syntax -> "C:\\Program Files\\GStudio6\\001_Project_test_mysql"
NOTE: Always use double-backslashes!

Second, the actual better way is to place all your plugins into your Project work folder and make plugindir:
plugindir = ".";


"Sometimes JCL reminds me of Notch, but more competent" ~ Kiyaku
Re: MySQL dll [Re: Michael_Schwarz] #41746
08/11/06 13:50
08/11/06 13:50
Joined: Aug 2004
Posts: 2,215
I
ISG Offline

Expert
ISG  Offline

Expert
I

Joined: Aug 2004
Posts: 2,215
@Michael

I think what Excessus is trying to say is allow any player to sign onto any account - however - each account save files are on YOUR computer so if you log onto someone else's account they can't do anything because they don't have YOUR save information. Make the login part just for that, really nothing, but if you sign on to that account on your computer then it loads YOUR save file(s).

Maybe I'm the one that has it wrong now hehe, but that's what I thought when I first read it.


Ground Tactics - Coming Soon
Ground Tactics OFFICIAL WEBSITE
Page 13 of 24 1 2 11 12 13 14 15 23 24

Moderated by  adoado, checkbutton, mk_1, Perro 

Gamestudio download | chip programmers | Zorro platform | shop | Data Protection Policy

oP group Germany GmbH | Birkenstr. 25-27 | 63549 Ronneburg / Germany | info (at) opgroup.de

Powered by UBB.threads™ PHP Forum Software 7.7.1