MySQL support for Torque Engine

#41 Nick,

If you are looking for the Zip file that I posted, the hosting company that I was doing business with screwed me (for your reading enjoyment). If your email can handle it, I would be more than happy to email you the Zip file and/or the original code distributed by Felix. Below are the Zip file sizes:

MySQL-Windows.zip around 953k

mysql.zip around 5k

Rich

#42 Maybe submit it as a resource here?

I'd like a copy if that's ok with you :)

edgardner@maxgaming.net

#43 Edward,

You should be receiving 2 emails from me. The first one contains the original code distributed by Felix. The second one is the MySQL Windows includes and libraries.

As far as creating a resource, Felix really should do it since he is the author of the code.

Rich

#44 hmmm let me see ( looks at the HD in the e-mail server he uses as a foot rest and sees 31G free ) ... yep .. my e-mail can handle it :-)

and ya , i have seen more than a few hosting companies send out e-mails like that to meny people. Thats why i spend an extra $40/month for static ip's and garenteed speed with no restrictions ;-)

thanks nick@lucindrea.com

#45 Nick,

Thanks for putting a smile on my face (i.e. your comments about your e-mail server); it's been a bad day.

You should receive two emails from me shortly. I just want to remind you that this is the original code as release by Felix. You will need to make some modifications to get it to work. See the posts dated Aug 20, 2002 17:55 GMT and Aug 21, 2002 11:03 GMT in this thread.

I don't want to hijack this thread, but a link to the hosting company you use would be appreciated.

Thank you.

Rich

#46 long e-mail reply.

hmm now i have to do the time zone math .......

#47 ok .. my turn to post my compile errors

Compiling...
mysql.cc
z:\torque\lib\mysql\include\mysql_com.h(115) : error C2146: syntax error : missing ';' before identifier 'fd'
z:\torque\lib\mysql\include\mysql_com.h(115) : error C2501: 'SOCKET' : missing storage-class or type specifiers
z:\torque\lib\mysql\include\mysql_com.h(115) : error C2501: 'fd' : missing storage-class or type specifiers
z:\torque\engine\game\mysql\mysql.cc(17) : error C2065: 'MySQL' : undeclared identifier
z:\torque\engine\game\mysql\mysql.cc(17) : error C2501: 'IMPLEMENT_CONOBJECT' : missing storage-class or type specifiers

their are 49 of these errors so i'm not going to post them all but you get the idea

#48 ok got it

both the mysql.cc and the mysql_cs.cc need the "#include mysql.h" changed to "#include fimysql.h" ( or whatever the renamed file in the game/mysql is )

hehe long day .. i hate stareing right at somthing and not seeing the ovious

#49 Could I get someone to shoot me an email with the mysql support code or point me to a website to download it from? www.futureint.de gives errors for virtualy eveyr page for me.

#50 tork.zenkel.com
:)

#51 Anyone know if this works on 1.2

#52 I am sorry, this is not an answer to your question but we have been receiving mails about this topic for a long time now, including support requests.

The reason why we have dropped this sub-project was the enormous danger that lies in a possible security exploit of directly using a database remotely. Please, keep in mind, that it would be much more secure to create a wrapper server which will reduce the risc of data being sniffed or even manipulated by an security exploit of the database server. The data being saved in a database-server is, in most cases, too important to be directly accessable by the internet.

Do not leave security relevant instances, like internet-sided servers, to others, not even to the MySQL team.

just my two cents
Felix Kollmann
Future Interactive
[http://www.futureint.de]
[fkollmann@futureint.de ]

#53 I know about security, and i have many power-full friends at Counter-Hack, so i'm not worried about it, i'm just worried that it works, if it does, great, its what i need, but, security is not an issue to me, i don't mean to be rude, and if it is possible, could you possibly e-mail me some screenshots @ killer_aka@hotmail.com if you have any on hand, if you don't want too, or don't have any, no prob

#54 Ehm... sorry, I did not get you... what screenshots do you want to have? The MySQL implementation is Torque-internal only and does not produce graphical output but error- and warning-messages.

But as I said before we dropped the sub-project, no way.

kind regards
Felix Kollmann

#55 Sorry, i don't have any, i was wondering if you did

#56 All,

I just posted a resource containing a few updates to fi Developer's original resource for MySQL connectivity through TGE.

I'll post a link once the resource is posted

-Ron

#57 Sweet :)

#58 It's up.

#59 You know what would be cool, embedding SQLite into Torque.

#60 @Bryan,

I looked into that for a few things a while back. It should be quite easy to do. I havent got around to implementing code yet since we probably wont need it in the end for our project. If enough people nag me I might do it as a resource, though. Theres definately a fair few things it would be useful for.

Tom.