Hello people,

I spent the entire day on making a user friendly mysql connector! This version links to a database on my personal server and practically every query can be performed on it.
Exceptions can be read in the comments in the mysql_test.c.

I recommend not to make use of the database now for development, not that I care but it will be emptied every now and then. Feel free to use some queries on it, it's fully sql-injection sensitive . DROP and CREATE DATABASE won't work, and I would prefer you not to use DROP TABLE hiscores. There are other people who want to see what's in it .

Download:
litec-sql_0.1.zip


And A6?
I think it works fine for A6 as well, at least for now, if you convert it. If theres much animo for an easy to use c-script version, I'll make one. Vote in the poll.


The commands
There are three commands available:


Will connect you to the database
returns 1 when succesfull


Sends a query to the database
returns row(s), column(s) info, or an errormessage.
rows are separated by a comma (,), columns by a colon (:).


Closes the connection

There is a forth, called db_connect and allows to connect to a different database, but this will be available in the future.


The next step
This said, I have another plan for you beloved 3dgs forumusers. If this is running well, I will open a register page for people to create their own personal test database. Give your username and password in the registration form, fill them in in your testdb_connect() function, and you're set!

I do like to know if you think this (and other features) will come in handy,so please take ten seconds to fill in the poll below.

Regards,

Joozey



The Poll
[redirect link to poll, can't make polls in user contributions]


The screens




--

Here's some things I would add or change to make it more better

• Database connection would return connection variable.
• db_query should be altered to db_query(string* query, int connection)
• db_close should be altered to db_close(int connection);
• This allows multiple connections to be used (useful in some places).
• make db_connect(string* server, string* username, string* password); and db_select_database(string* database, int connection); or mix these, even though keeping these two separate does make it more agile (no need for new connection when hot switching databases)
• add useful functions such as db_num_rows, db_list_tables, etc.

Polls aside, you know I am 100% behind any A7-MySQL initiative, bro!!
Keep the DB dream alive!

Yes, noted.

I could, but you could do too within a query. I don't see how this helps improving the DLL other than doing the SQL for you .

You... don't like polls?

I'd like to see an implementaton similar to MySQL for PHP regarding function names, parameters, return values...

Apart from that: fine job

Joozy I love your contribution and you will save a lot of people a lot of work. I don't mean to give anyone a hard time but as an System Admin and serious C/C++ developer for over 25 years I have had to read a lot of licenses. We also have a patent/technical attorney to help us with the stuff we don't understand. MySQL is not interested in Game Development, and their license for using the dll in your own distributable program was over $10,000.00 USD the last time we checked. It is only free to web hosters and not to software developers. We were very sorry to learn this ourselves as we had developed an entire system online of MySQL databases and could not use them even on our local network. We were forced to move to SQLite because of the license restrictions from MySQL. Remember they are a for-profit company and have to sell something to keep developing. They sell seminars, support and licenses. For us small time developers the cost was prohibitive, plus we have to make sure that we can deliver all parts of our software legally and without restraint.

Nice work, this is a great LC based code for MySQL connectivity/compatibility towards A7

Cheers

Frazzle

How do we connect to a database??

can this connect to a database over the net?
How to configure the environment for that?

When applying for a data base, you need to set up a private server (password based to say it easy) via MySQL, connect the in and output via php (query based), send that data over a dll which Joozey already made for you (thank you again ^^) and use the corresponding dll functions in your script via SED (A7)

Cheers

Frazzle