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.

DarkBASIC Professional Discussion / MySQL and GUI help

Author
Message
farmkid4
16
Years of Service
User Offline
Joined: 23rd Sep 2009
Location: on my pc :)
Posted: 22nd Feb 2012 20:37
Link
hey guys it has been while since I have used DBP but im starting a new project to try and get back into it.
I am looking for info help on connecting to and modifying MySQl databases. Can it be done with built in DBP commands or do i need something else.

The other question is about GUIs I have been trying to get TOPgui to work for me but when I try to run the tester file It gives me this error
"Compilation Failed. Could not determine parameter type of 'get type pattern$(name$, 0)' at line 6658."

Any help would be great.

Back to top
Profile PM Website
Diggsey
20
Years of Service
User Offline
Joined: 24th Apr 2006
Location: On this web page.
Posted: 22nd Feb 2012 20:44
Link
"get type pattern$" is a native DBPro command, and has been for some time. Are you using a very old version of DBPro? If so then you'll need to update.

There have been a number of database plugins in the past, I suggest you search the forums and see what comes up.

[b]
Back to top
Profile PM Email Website
farmkid4
16
Years of Service
User Offline
Joined: 23rd Sep 2009
Location: on my pc :)
Posted: 22nd Feb 2012 21:06
Link
Quote: ""get type pattern$" is a native DBPro command, and has been for some time. Are you using a very old version of DBPro? If so then you'll need to update."


When I go to DBP/Help\Check For Updates... It says Im up to date what should I do to find out what version I have?

Quote: "There have been a number of database plugins in the past, I suggest you search the forums and see what comes up."


ok will do.

Back to top
Profile PM Website
Diggsey
20
Years of Service
User Offline
Joined: 24th Apr 2006
Location: On this web page.
Posted: 22nd Feb 2012 21:24
Link
If you go to Help/About it should tell you the version number.

Is the command highlighted correctly in the editor? Do you have any plugins installed that use "name$" as a command?

[b]
Back to top
Profile PM Email Website
farmkid4
16
Years of Service
User Offline
Joined: 23rd Sep 2009
Location: on my pc :)
Posted: 22nd Feb 2012 21:30
Link
Quote: "If you go to Help/About it should tell you the version number."


OK if I go to Help/About Editor"Build Oct 2 2008"

Quote: "Is the command highlighted correctly in the editor?"

No I will try the update from the tgc site and see if that fixes it.

[quote]Do you have any plugins installed that use "name$" as a command?][quote]I dont think so.

Thanks for the help I will reply in a bit after the update is finished.

Back to top
Profile PM Website
farmkid4
16
Years of Service
User Offline
Joined: 23rd Sep 2009
Location: on my pc :)
Posted: 22nd Feb 2012 21:35 Edited at: 22nd Feb 2012 21:38
Link
WOW!! You did a great job the GUI looks amazing!!!

know I just hope i can use it as well as you made it.

Thank you for the help I will prolly have more questions about the GUI but for now off I go to play

Back to top
Profile PM Website
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 28th Feb 2012 01:37 Edited at: 28th Feb 2012 01:40
Link
like this one?

can you point to others if any?

I still suck at the GUI part... which works best? and please do not say BBBGUI I struggle to even comprehend that one

EDIT

perfect not only has he disappeared from the forum his site is dead too... so I ponder which are actually still in existence?

Back to top
Profile PM
farmkid4
16
Years of Service
User Offline
Joined: 23rd Sep 2009
Location: on my pc :)
Posted: 7th Mar 2012 23:16
Link
Quote: "perfect not only has he disappeared from the forum his site is dead too..."


lol no i'm not dead I have just been busy with other things ad haven't checked this.

My site is under constructionand the button is pointing to the wrong address.

Back to top
Profile PM Website
Penfold
22
Years of Service
User Offline
Joined: 3rd Dec 2003
Location: RED postbox houses of parliment
Posted: 8th Mar 2012 00:11 Edited at: 8th Mar 2012 00:12
Link
I'm pretty sure there are non plugin ways to connect to a database. I've done it myself before when I made a monster database generator so that I could populate a world with little or no effort.

I'll see if I can find the code and post a bit later.

'Ooh 'eck chief'...'crumbs'
Back to top
Profile PM
Ortu
DBPro Master
18
Years of Service
User Offline
Joined: 21st Nov 2007
Location: Austin, TX
Posted: 8th Mar 2012 01:51
Link
You could send an http request to a .php file, assuming the MySQL is on a web server.

Back to top
Profile PM Email Website
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 8th Mar 2012 09:18
Link
Thanks Farmkid4

And Penfold

And Ortu

I have started to learn PHP and MYSQL

I hope I can figure this one out... I do have SSL access available on my hosting so will try the built in commands soon just need to learn to create peoperly structured PHP pages and make them secure I will try to remember to post my developments here shall flag it in email

Back to top
Profile PM
Penfold
22
Years of Service
User Offline
Joined: 3rd Dec 2003
Location: RED postbox houses of parliment
Posted: 8th Mar 2012 11:24
Link
Hada look when I got home last night, couldnt find it. I'll look around some more today to see if I can locate the files.

'Ooh 'eck chief'...'crumbs'
Back to top
Profile PM
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 8th Mar 2012 12:12
Link
Farmkid4

I was on about CattleRustler not being on the forums much more... I linked the thread I was referring to

Back to top
Profile PM
bitJericho
23
Years of Service
User Offline
Joined: 9th Oct 2002
Location: United States
Posted: 8th Mar 2012 14:03 Edited at: 8th Mar 2012 14:05
Link
@MrValentine, perhaps you'll remember this post for when you try and fail with the inbuilt commands

Unless they've since been fixed, I haven't tried recently:

http://forum.thegamecreators.com/?m=forum_view&t=192402&b=1

As for connecting directly to a mysql database, it's extremely dangerous! You really should route through a php or some other script first.

I recommend for games download whatever data you need from a script hosted online, and if you need database type features within your engine (complex sql statements or something), use sqlite with a datastore held in memory for speed, or saved on disk if you need data persistence.

darkBIT TGC Torrent Tracker / File Server - AGK Chat: #agk : irc.devhat.net
Back to top
Profile PM Email Website
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 8th Mar 2012 22:43
Link
@Jerico2day will have a looksie after posting this...

I have bought a recently published PHO and MYSQL book recently so i might be taking the PHP parser route eitherway

[goes over to Jerico2day's first link... ]



[looks at second link]





Thanks Jerico2day I guess its PHP all the way for inbetween database management... now to just figure out how to parse data...

Back to top
Profile PM
Ortu
DBPro Master
18
Years of Service
User Offline
Joined: 21st Nov 2007
Location: Austin, TX
Posted: 9th Mar 2012 03:06
Link
For parsing, Query results get dumped into an array which can be iterated with a simple while loop, strings can be split into an array by what ever delimiter you want spaces pipes or what have you

Back to top
Profile PM Email Website
bitJericho
23
Years of Service
User Offline
Joined: 9th Oct 2002
Location: United States
Posted: 9th Mar 2012 11:56
Link
Quote: "now to just figure out how to parse data..."


The wonderful thing with PHP is you can output however you want. You can do XML (great xml parsers are available for dbp), HTML, or just a plain old text file with data seperated by newlines.

darkBIT TGC Torrent Tracker / File Server - AGK Chat: #agk : irc.devhat.net
Back to top
Profile PM Email Website
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 9th Mar 2012 12:24 Edited at: 9th Mar 2012 12:25
Link
Do you mean an XML structure within a PHP?

EDIT

I have STYX ^^

Back to top
Profile PM
bitJericho
23
Years of Service
User Offline
Joined: 9th Oct 2002
Location: United States
Posted: 9th Mar 2012 15:35
Link
php is general scripting language, it outputs whatever you want to the webserver which then can serve it to out via http or https.

So php can output a text file, an xml file, an html file, a binary file, pretty much any kind of file you can think of.

darkBIT TGC Torrent Tracker / File Server - AGK Chat: #agk : irc.devhat.net
Back to top
Profile PM Email Website
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 9th Mar 2012 17:09
Link
as sweet shall read into it... bought another book today darn these things are expensive

I am looking at Javascript for this current project as well as PHP jQuery is involved too...

forum quiz time ^^
what do you get when you put html php javascript mysql and a server together?

Back to top
Profile PM
Ortu
DBPro Master
18
Years of Service
User Offline
Joined: 21st Nov 2007
Location: Austin, TX
Posted: 9th Mar 2012 20:29
Link
Check out http://php.net/manual/en/index.php and http://www.w3schools.com/

Very good free resources

Back to top
Profile PM Email Website
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 9th Mar 2012 20:34
Link
Thanks Ortu but trouble with web references is they are not always comprehensive full of ads and often incomplete or lacking detail...

A book though I usually never read them is much more abc as opposed to abdkglruz as is the internet

Back to top
Profile PM
Dar13
18
Years of Service
User Offline
Joined: 12th May 2008
Location: Microsoft VisualStudio 2010 Professional
Posted: 10th Mar 2012 02:49
Link
The PHP manual has no ads, and is the definitive manual for PHP. If it isn't up-to-date, nothing is. Much less a physical book.

Follow WTLD's progress on Twitter
Git repository for WasTeLanD
Back to top
Profile PM Email
MrValentine
AGK Backer
15
Years of Service
User Offline
Joined: 5th Dec 2010
Playing: FFVII
Posted: 10th Mar 2012 10:15
Link
Will have a look thanks again

Back to top
Profile PM
Back to top

Login to post a reply

Server time is: 2026-07-11 06:15:17
Your offset time is: 2026-07-11 06:15:17