Gamestudio Links
Zorro Links
Newest Posts
Trading Journey
by howardR. 04/28/24 09:55
basik85278
by basik85278. 04/28/24 08:56
Zorro Trader GPT
by TipmyPip. 04/27/24 13:50
Help with plotting multiple ZigZag
by M_D. 04/26/24 20:03
Data from CSV not parsed correctly
by jcl. 04/26/24 11:18
M1 Oversampling
by jcl. 04/26/24 11:12
Why Zorro supports up to 72 cores?
by jcl. 04/26/24 11:09
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
2 registered members (AndrewAMD, NeoDumont), 761 guests, and 1 spider.
Key: Admin, Global Mod, Mod
Newest Members
wandaluciaia, Mega_Rod, EternallyCurious, howardR, 11honza11
19049 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Page 1 of 3 1 2 3
A8 - LiteC MYSQL Connector #403342
06/18/12 17:05
06/18/12 17:05
Joined: Nov 2007
Posts: 318
Brasil, Paraná
NeoNeper Offline OP
Senior Member
NeoNeper  Offline OP
Senior Member

Joined: Nov 2007
Posts: 318
Brasil, Paraná
EDIT: New Update for 1.1 And LINKS for Download WORK
Hello Friends.
First, I want to thank everyone who helped me with my doubts.
thank you!

This is my first contribution to the community.
I hope it is helpful to everyone.

What this is?
The name of the topic says it all!.

A8 - LiteC MYSQL Connector:
Used to manipulate the data in mysql table V. 5 + +

Download: A8 - LiteC MYSQL Connector
Download - V1.1

Documentation
Manual V1.1

Examples and documentation included in the zip package

Any questions or bug, please let me know.!!


Last edited by NeoNeper; 04/13/13 20:22.

Please! Use easy words to be translated. because my English is not very good! Grateful.
_______________________________________________________
Re: A8 - LiteC MYSQL Connector [Re: NeoNeper] #403346
06/18/12 17:56
06/18/12 17:56
Joined: Nov 2002
Posts: 913
Berlin, Germany
S
SchokoKeks Offline
User
SchokoKeks  Offline
User
S

Joined: Nov 2002
Posts: 913
Berlin, Germany
This is a great contribution! There have been quite many discussions about mysql plugins but most were outdated. Thanks to you there is now well documented alternative.

I especially like the colorful manual. There is only one information missing: In what format are the lines returned? Are they always given as char* oder STRING*? Please add this information to the manual.
I couldn't try the plugin because I'm using the engine sdk, but I hope others will use it often.

Re: A8 - LiteC MYSQL Connector [Re: SchokoKeks] #403349
06/18/12 18:10
06/18/12 18:10
Joined: Mar 2006
Posts: 1,993
Karlsruhe
PadMalcom Offline
Serious User
PadMalcom  Offline
Serious User

Joined: Mar 2006
Posts: 1,993
Karlsruhe
Reaaaally well done! Especially the manual looks good!

Re: A8 - LiteC MYSQL Connector [Re: SchokoKeks] #403351
06/18/12 18:19
06/18/12 18:19
Joined: Nov 2007
Posts: 318
Brasil, Paraná
NeoNeper Offline OP
Senior Member
NeoNeper  Offline OP
Senior Member

Joined: Nov 2007
Posts: 318
Brasil, Paraná
Thanks for the comment SchokoKeks!
And Thanks for comment PadMalcom!
(^.^)

> On Documentation already have the the return type of each function has, However, I noticed that in some cases, it is poorly explained.

I'll improve the documentation and post the news






Last edited by NeoNeper; 06/18/12 18:21.

Please! Use easy words to be translated. because my English is not very good! Grateful.
_______________________________________________________
Re: A8 - LiteC MYSQL Connector [Re: NeoNeper] #403562
06/22/12 00:55
06/22/12 00:55

T
tolu619
Unregistered
tolu619
Unregistered
T



Cool! Hoping this will work with Transact-SQL as well!

Re: A8 - LiteC MYSQL Connector [Re: ] #421222
04/13/13 20:23
04/13/13 20:23
Joined: Nov 2007
Posts: 318
Brasil, Paraná
NeoNeper Offline OP
Senior Member
NeoNeper  Offline OP
Senior Member

Joined: Nov 2007
Posts: 318
Brasil, Paraná
LINKS WORKS and New Update. (^.^)


Please! Use easy words to be translated. because my English is not very good! Grateful.
_______________________________________________________
Re: A8 - LiteC MYSQL Connector [Re: NeoNeper] #421341
04/15/13 19:14
04/15/13 19:14
Joined: Apr 2007
Posts: 3,751
Canada
WretchedSid Offline
Expert
WretchedSid  Offline
Expert

Joined: Apr 2007
Posts: 3,751
Canada
Whatever you are trying to do here, THIS is the wrong way.

Please, everyone, don't use this, and don't write your own wrappers over libmysql! MySQL is released under the GPL license, NOT LGPL, even just linking against the librarie requires you to publish your source code under the GPL as well, otherwise you are violating an ACTUAL license. The GPL is no Kindergarten, no "oh, some neckbeards jerk over it" thingy and a lot of people and companies have been sued over GPL violations.
I can't stress this enough, if you want to stay out of legal trouble, DON'T use this. Ever.

The second thing is, you are opening your game and server up to a tremendous security risk, and this is no Kindergarten either! Embedding your username and password for your MySQL database into your game is a HORRIBLE idea, everyone, and this includes my mom, can get them out of your game and run arbitrary queries against YOUR database. If you prefer your server to not become an anonymous FTP full of childporn and warez, DON'T fucking use this.

Now, to make it easy, here is what you should do in the style of a "choose your own adventure"

1) I'm a programmer and I would like to save my highscores locally (read answer A)
2) I'm an idiot and I believe that a database should drive my MMORPG (read answer B)
3) I'm a sane person and would like to use a database to store some information about my users (read answer C)

Answer A: Use sqlite3. It's the de facto industry standard for these kinds of things, extremely optimized, fast and well tested.

Answer B: MySQL scales exceptionally bad, you might be better of with an alternative. That doesn't mean that MySQL is bad, or doesn't has its advantages for large scale applications, but you will likely end up putting a lot of effort into your caching strategy to get the load off of your database servers (not saying that you won't put a lot of work into your caches anyways). Please read about alternatives and then pick something that gets the job done best for your MMORPG, and keep in mind to always allocate enough resources for the worst case (and be prepared to scale over night).

Answer C: Use MySQL on your server and provide a RESTful API, or similar, for your game. Use normal HTTPS requests to communicate with the API and let the server handle the MySQL stuff. For the love of god, sanitize your user input and use data bindings.

I get it, most of you aren't serious and just want to play around, but if you have in mind to do something serious, or even remotely serious, please, please, please, don't make the wrong mistakes.

Last edited by JustSid; 04/15/13 20:13. Reason: Off of, I suck at english. Debate me.

Shitlord by trade and passion. Graphics programmer at Laminar Research.
I write blog posts at feresignum.com
Re: A8 - LiteC MYSQL Connector [Re: WretchedSid] #421345
04/15/13 20:06
04/15/13 20:06
Joined: Oct 2007
Posts: 5,210
Ä°stanbul, Turkey
Quad Offline
Senior Expert
Quad  Offline
Senior Expert

Joined: Oct 2007
Posts: 5,210
Ä°stanbul, Turkey
^this.


3333333333
Re: A8 - LiteC MYSQL Connector [Re: NeoNeper] #429196
09/10/13 09:26
09/10/13 09:26
Joined: May 2012
Posts: 11
Germany
T
TheDynamit Offline
Newbie
TheDynamit  Offline
Newbie
T

Joined: May 2012
Posts: 11
Germany
The links are dead, someone has the version 1.1, which I myself have version 1.0

Re: A8 - LiteC MYSQL Connector [Re: TheDynamit] #429199
09/10/13 09:51
09/10/13 09:51
Joined: Aug 2002
Posts: 3,258
Mainz
oliver2s Offline
Expert
oliver2s  Offline
Expert

Joined: Aug 2002
Posts: 3,258
Mainz

Page 1 of 3 1 2 3

Moderated by  HeelX, Lukas, rayp, Rei_Ayanami, Superku, Tobias, TWO, VeT 

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