Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Work in Progress / New database system

Author
Message
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 26th Jun 2004 11:21
Link
I've decided to dump SQLite (as its a pain getting the .LIB files, and currently the DLL hasn't exported any functions). So, I now present DBPro support for mySQL - this time without the need for an ODBC interface.

The main advantage is that, theoretically, communication can be over the internet (as connection is done via IP address). It does, unfortunately require a seperate server program to be running.

As the moment, I've got most of the functions up and running. I just need to work out how to set permissions for selected and creating a new database (currently testing on the default one).


The place for great plug-ins and things.
There's the right way, the wrong way and the TCA way...
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 28th Jun 2004 01:11
Link
mySQL system is nearly ready - most of the useful commands are in, and there are only a few non-important ones left.

I'll be posting the plug-in and the help files I've done so far during the week.


The place for great plug-ins and things.
There's the right way, the wrong way and the TCA way...
Back to top
Profile PM Email Website
MikeS
Retired Moderator
21
Years of Service
User Offline
Joined: 2nd Dec 2002
Location: United States
Posted: 28th Jun 2004 03:05
Link
Sounds good TCA. Always good to have these kinds of plug-ins which extend upon DBP.



A book? I hate book. Book is stupid.
(Formerly known as Yellow)
Back to top
Profile PM Email
Mnemonix
21
Years of Service
User Offline
Joined: 2nd Dec 2002
Location: Skaro
Posted: 30th Jun 2004 04:15 Edited at: 30th Jun 2004 04:16
Link
Excellent Toad, This will be great for storing irc bot info and other kinds of things in client/server apps . [EDIT] Will this work with remote databases (i.e. accessing a webserver database remotely)? [/EDIT]

Visit the Db chat room, ask me for details!.
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 30th Jun 2004 18:05
Link
I presume so - I've tested it over the internet, and aside from the initial connection being slightly slow, everything else runs fine.

The good news is that the client computer doesn't need the full mySQL installation - just the MYSQLLIB.DLL needs to be present with the program.

The server side, does of course, need the full installation & setup.


The place for great plug-ins and things.
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 30th Jun 2004 19:20
Link
On the other site is an example code of how to do a hiscore table - I'll be sprucing that up for the documentation.


The place for great plug-ins and things.
Availiable : mySQL Interface plug-in.
Back to top
Profile PM Email Website
Mnemonix
21
Years of Service
User Offline
Joined: 2nd Dec 2002
Location: Skaro
Posted: 1st Jul 2004 02:42
Link
My dbp seems to be giving me weird errors when i try and run certain commands. Also some of the documentation is incomplete, so i will wait until the final release is out

Visit the Db chat room, ask me for details!.
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 1st Jul 2004 04:31 Edited at: 1st Jul 2004 04:33
Link
What commands are you trying to run ? Dont forget that you may need to set privileges (you cant just go around creating tables and expect mySQL to let you).


The place for great plug-ins and things.
Availiable : mySQL Interface plug-in.
Back to top
Profile PM Email Website
Mnemonix
21
Years of Service
User Offline
Joined: 2nd Dec 2002
Location: Skaro
Posted: 1st Jul 2004 04:42
Link
No no i set up my priveleges and all, Its causing compile errors and wont compile. My priveleges are all set up. I have mySQL installed on my home computer now, and i can successfully initialise and connect to mySQL. It seems to be various functions giving me trouble. I have yet to run a successful query on my database. mySQL_GetLastError() seems to be giving me problems and mySQL_QueryShort also seems to be giving me trouble. The sample i got from your website doesnt seem to work at all, although i will try it once more to be certain.

Visit the Db chat room, ask me for details!.
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 1st Jul 2004 04:45 Edited at: 1st Jul 2004 04:45
Link
What compile errors do you get ? I've got it running on two machines (had to, to test internet connections).

Do you have the mysqldll.dll in with the program too ?


The place for great plug-ins and things.
Availiable : mySQL Interface plug-in.
Back to top
Profile PM Email Website
Mnemonix
21
Years of Service
User Offline
Joined: 2nd Dec 2002
Location: Skaro
Posted: 1st Jul 2004 05:09
Link
mysqldll.dll?

I have mySQL.dll in the plugins-user folder and the one from the libMySQL.dll from my mySQL installation, but not mysqldll.dll.

I get weird compile errors:-

Error at line 23:
Result=mySQL_QueryShort(mySQLHandle,query$)
PARSER ERROR
------------
Subscript must be Integer or DWORD when referencing an array at line 23.


Come in the IRC if you need more information. It is however, most likely something i have stupidly done wrong.

Visit the Db chat room, ask me for details!.
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 1st Jul 2004 05:20 Edited at: 1st Jul 2004 05:37
Link
Yes, its the libx.DLL that I was talking about, so thats okay.

The QueryShort command shouldn't be there - both types of query command are mySQL_Query

The query commands are now :

DWORD=mySQL_Query(sqlHandle,"query")
DWORD=mySQL_Query(sqlHandle,"query",size)
DWORD=mySQL_Query(sqlHandle,queryAddr,size)

Download the lastest mySQL.DLL from my web site, and replace any QueryShort/QueryLong commands with just Query.


The place for great plug-ins and things.
Availiable : mySQL Interface plug-in.
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 1st Jul 2004 08:16
Link
I've got all the commands I want in now - any left out can always be added when mySQL 4.1 comes out.


The place for great plug-ins and things.
Availiable : mySQL Interface plug-in.
Back to top
Profile PM Email Website
Back to top

Login to post a reply

Server time is: 2024-11-22 07:16:59
Your offset time is: 2024-11-22 07:16:59