Oldunreal Forums - [227h] Unreal mySQL interface class

	Welcome, Guest. Please Login or Register

Home

Help

Oldunreal Forums › Unreal › Unreal General Forum › [227h] Unreal mySQL interface class

(Moderators: Smirftsch, TCP_Wolf, pÍtßûll, DieHard SCWS)

‹ Previous Topic | Next Topic ›

Pages: 1

Send Topic

[227h] Unreal mySQL interface class (Read 1102 times)

[]KAOS[]Casey

Oldunreal MasterPoster

Offline

nedm

Posts: 2891
Gender: male

[227h] Unreal mySQL interface class
08/22/11 at 09:27:13

I've made a way to interact with MySQL databases natively in unreal through unrealscript in a not-lame manner!

http://www.klankaos.com/USQL.7z

Usage : you must install MySQL 5.5(Only version tested) in

32-bit

.

You have to click "Advanced" and change install type to 32bit to have this work at all. Otherwise enjoy trying to figure out how to uninstall 64bit mysql.

Examples/docs to come later. The usage I used to build/test USQLDB interaction is commented out in postbeginplay. The class can be found under Info -> USQLDB. You will need to spawn an instance of USQLDB and call on it to use any functions. The default 5.5 mysql installer should come with the same table/db I used to run the postbeginplay code.

Also, enjoy the src code; windows only etc.

« Last Edit: 08/22/11 at 09:28:03 by []KAOS[]Casey »

IP Logged

[]KAOS[]Casey

Oldunreal MasterPoster

Offline

nedm

Posts: 2891
Gender: male

Re: [227h] Unreal mySQL interface class
Reply #1 - 09/09/11 at 08:32:04

http://www.klankaos.com/GSQLInventoryManager.zip

Arguably simple SQL ID create/delete and inventory managing system.

This will save your inventory upon killing something, or upon level end. GSQLInventoryManager only works with JGrass. {Go to projects under http://udhq.org/ to find JGrass.}
However, I can port it to other gametypes if someone wishes, assuming it's interface is compatible, though I could make a much simpler {and poop} version for simple gametypes.

Your inventory will be restored upon respawning.

Please note I have not done any benchmarks on speed yet, and I still need to write the docs for USQLDB.

Obviously, you need mysql 5.5 and USQLDB installed for this to even work.

Since i'm far too lazy at 12 am to edit the mod again to use an ini system to use the password, enjoy manually editing the password until sometime tomorrow!

« Last Edit: 09/09/11 at 08:41:33 by []KAOS[]Casey »

IP Logged

Qtit Full Member Offline Oldunreal member Posts: 132 Hell Gender:	Re: [227h] Unreal mySQL interface class Reply #2 - 09/09/11 at 15:13:13 Wait... What? You have successfully created a MMO database for Unreal, right? If so, I love you.
Back to top	IP Logged

Pcube

Ex Member

Re: [227h] Unreal mySQL interface class
Reply #3 - 09/09/11 at 16:30:50

Qtit wrote on 09/09/11 at 15:13:13:

Wait... What? You have successfully created a MMO database for Unreal, right?
If so, I love you.

Essentially he has created a mod that will swiftly enable MMO capabilities. He could even tweak it so that multiple servers can point to the same database, thus allowing for creation of a network of servers & shared user accounts. If anyone got the ball rolling I'd be sure to join in such a setup.

IP Logged

[]KAOS[]Casey

Oldunreal MasterPoster

Offline

nedm

Posts: 2891
Gender: male

Re: [227h] Unreal mySQL interface class
Reply #4 - 09/09/11 at 18:28:56

Qtit wrote on 09/09/11 at 15:13:13:

Wait... What? You have successfully created a MMO database for Unreal, right?
If so, I love you.

You can store any amount of arbitrary data, using whatever SQL commands known to you. Although there is no SQL injection protection yet, since that's a hefty topic on itself..

But yes, you can store stats, experience, inventory, quest flags, any other sort of flags, and retrieve them.

And as pcube said, if an off-site server allows for connections not from localhost(127.0.0.1) you could indeed have multiple servers from multiple people querying the database.

Oh poop, speaking of that, I forgot to update the USQL.dll package.. oh crap oh poop, crappity smack UTF-8 since it doesnt work with player names

USQL package is now updated. 1.1 includes a fix for storing ASCII character names in a UTF-8 database. Side effects if any are unknown.

« Last Edit: 09/09/11 at 18:38:39 by []KAOS[]Casey »

IP Logged

Qtit

Full Member

Offline

Oldunreal member

Posts: 132
Hell
Gender: male

Re: [227h] Unreal mySQL interface class
Reply #5 - 09/09/11 at 21:30:21

Okay, I know nothing about SQL, so basically I'd need to learn something.

Still, I am deeply interested in that kind of project, mod, whatever. Is it capable to control NPC/AI spawning and behavior in multiple maps? I mean, there is a UT mod (I think) which lets loading of multiple maps on Unreal Server. Having this mod linked with the SQL database you've created and updated to manage more information, we basically could create an Unreal based MMO... Right?

Because, if so, that is freaking awesome, if I may say so. I have no idea how it would work with playercount limit and this multiple map loading on server(s) (I imagine that one server would not be enough to load 10 maps which could work as a part of the mmo-type game world) but still, even basic leveling coop unreal server with cross-level travelling could rule the world.

Damn, if what I've written isn't clear enough I'm sorry... It's been a looooong day of a longer week.

IP Logged

[]KAOS[]Casey

Oldunreal MasterPoster

Offline

nedm

Posts: 2891
Gender: male

Re: [227h] Unreal mySQL interface class
Reply #6 - 09/09/11 at 22:15:53

Well, It could hold spawn positions for an ungodly amount of monsters. The spawn conditions would have to be done through uscript, but there could be a respawn time in the database itself. Multiple map mod {there's also one for 227, thanks to dots} would easily work with such a thing.

I don't know how bandwidth works on a multi-map server at all, so I can't really comment there at all. Though if it's actually seperate handling for each XLevel instance it probably could work.

IP Logged

Pages: 1

Send Topic

Oldunreal Forums › Unreal › Unreal General Forum

‹ Previous Topic | Next Topic ›

(Moderators: Smirftsch, TCP_Wolf, pÍtßûll, DieHard SCWS)

« Home

‹ Board

Top of this page