UDK - DLLBind: Embedded database (SQLite,MySQL) v3.1.0.2

[research]

Thanks a lot, its working now

Had to remove the following line in CUDKSQLDriverSQLite::execute() to compile:

case SQLITE_NULL:
        lQRIter->second.addValue();

[BlackHornet80]

using the zip or SVN? zip maybe some files not uptodate...will check it

Edit....i'm sry for this mistake
------------------
Done, zip updated

[research]

I was using the zip file, although the code in your svn also has the same line in it
Edit: Thanks a lot, its working fine now

[rahatropa]

Wanted to update to my earlier question.. it's all working now! Thanks. My problem was looking to the database.ini's paths for the new accounts rather than the usercode folder, that P.S. you included at the end of your response was a big help =)

[AdAstra]

@BlackHornet80

Thanks!

I have working simple save system now,
and thanks to you i can have items, quests , monsters, NPC databases.
Everything seems a lot easier now.

When I release my game, you will get credited and I will name `item set/ area/ boss` after you.

Many thanks!

[BlackHornet80]

Thanks, I'm looking forward to your project and how you use the databases

[AdAstra]

A question: is it possible for the databases to be user/password protected?

I want to provide to my players the possibility to mod the game. To do that, I want the main game/DBs to be protected,
and the users can make additional content(quests, items ...) by creating additional DBs and adding them to the ini.

This way it will be harder for most of them to break the main game.

[Brexer]

You protect the db with password, your users will just reverse engineer the dll and find the password, does really take much time.

While it does protect from a certain amount of users to mess with the file, those who want to do it, will do it.

Maybe add a CRC check system to check the db's CRC (date check perhaps?) and password/username, dll protection (pack it, dont know if UDK can load the dll if you do) but then again, everything is crackable, question is, how much time you wish to spend on it, as breaking it wont take the guys who really want to break it long time.

[elmuerte]

Any form of encryption will be useless as both encryption and decryption would need to be stored in the application, so it's nothing more than security through obscurity. The same applies to using hashing mechanisms for tamper resistance. You cannot really protect data which is read and written from the same device.

[AdAstra]

I just want it to have basic protection, that will help in most cases against accidental alteration of the tables.
I know that if someone wants to do it, I cant stop them.
I will even make the user/pass public for those, that really want to mod this way.

But the way I will try to design it, is to be able to alter the data, without changing the base tables.
This way they can alter the game , but going back to a clean state will be as easy,
as removing/commenting out a line from the .ini

[UT2007]

Hello BlackHornet80, no update since last version ? is this project still alive ?

[Blade[UG]]

Hello BlackHornet80, no update since last version ? is this project still alive ?

does it need to be updated?

[paulv2k4]

How come when I download the top link of yours I get a zip with nothing in there but a non-specified filetype with no extension?

[TMichael]

Same here. I also found no sign of the read me in the project or dllbind download.

Methinks we are missing something terribly obvious...

[marcusmattingly]

I just discovered this. Wow! This is exactly what I need for the RPG I am working on.

Thanks big time for creating it. I imagine you have helped a lot of people.

[Wyldhunt]

Yes. Thank you. This is amazingly helpful.

As for the people who had trouble downloading it, I just re-downloaded it to check and it worked fine. The download should point to a 'SQLProject2010.zip', and the zip has 2 folders and a readme.txt file. if it's not downloading right, I'd suggest trying a different browser maybe. But, it does work.

[westclif]

mhm can i use this dll on the 64bit version of the udk?


//edit isn't working for me on a 64 bit system using the udk august build, i get an error message about cant bind to UDKProjectDLL.dll

[TMichael]

Yes. Thank you. This is amazingly helpful.

As for the people who had trouble downloading it, I just re-downloaded it to check and it worked fine. The download should point to a 'SQLProject2010.zip', and the zip has 2 folders and a readme.txt file. if it's not downloading right, I'd suggest trying a different browser maybe. But, it does work.

Hi Wyld,

That was the file I downloaded. Inside was a file named SQLProject2010 with no extension, and no readme.

I'll bet this has to do with extraction. I used 7-Zip. Which program did you use?

[Blade[UG]]

mhm can i use this dll on the 64bit version of the udk?


//edit isn't working for me on a 64 bit system using the udk august build, i get an error message about cant bind to UDKProjectDLL.dll

You would need to at the very least, compile a 64-bit version of the DLL. However, keep in mind, that the Editor is the only "official" 64-bit component, if you run the game in 64-bit you may be missing other things that are not implemented. (I don't know what those might be, sorry)

[Wyldhunt]

I'll bet this has to do with extraction. I used 7-Zip. Which program did you use?

I use Winrar

[TMichael]

I use Winrar

That has to be it. I'll pick up a copy and re-extract. Thanks!

[BlackHornet80]

Hello BlackHornet80, no update since last version ? is this project still alive ?

Actually I dont have any further requests for the files, so no update needed for the moment

[makke007]

HI guys how do i get a simple savesystem for an fps with that ?

Thanks for help

[CloDel Studios]

for ppl having issues with finding the files in the download, when I extracted it got a file with no extension. i simply added .rar to the end of it, and extracted that as well and there was the files.

[Blade[UG]]

"simple" and "save system" don't really go together so well. WHAT do you want to save? is the first question.

[makke007]

I want to save a simple postition like a checkpoint system in call of duty

[BlackHornet80]

just save the coordinates for example as 23.11354,213.1232,535.756847 (as TEXT) to database, and after read this text from Database use a simple string split (comma delimiter) to split up the text and get your X, Y and Z coordinate from it

[hellslayer]

I was trying to recompile the project in x64 (for the 64bit version of the editor). But there occurs to much errors which go over my understanding of c++.
Do you have any hints or will you ever releas the source of a version of this project ready to compilation with x64?

[gamma1]

Can I connect udk to SQlite, or MySQL?

[SaiyaGin]

Yeah, I need that too.

But my question is how to write data back to the SQL database on my server.

I can read for example a highscore from my SQL db, but how can i write it back, or overwrite it.

I use TCPLink.

Thx

[gamma1]

I must build a virtual world for archaeological applications in which we can manage objects. This virtual world must reflect at any time what happens in the real world: for example, if an archaeologist is on an archaeological site (corresponding to our virtual world) and he finds a jar, he must be able to add it to our virtual world (running on a server), for example with a client application written in Java maybe running on his handheld, and we believe this is possible only if this application is able to interface directly to database where objects are stored. Another example: the same archeologist want to move an object (e.g. an artifact) in the scenario without editor, we believe this is possible always only with the same tecnique, that's accessing directly to a database.
How can i manage the database of udk?
Can i use Mysql or SQlite?

[Blade[UG]]

sqlite is not built for multiple points of access. Any database that can be accessed via network should be fine, but the easiest way to do it is probably to do it with a web-server of some kind as a gateway, then you can just access it via TCPLink in Unreal. If I remember my licensing details correctly, there might be licensing issues if you tried to link MySQL directly to UDK, so it's proably best to go through a web server in between.

[hellslayer]

I recently wanted to write a code to save Data very efficient but....
I struggle with the prepared statement. I have a very basic version of the what I want to save so... can someone help me with this please?

function DoInsert()
{
mDLLAPI.SQL_selectDatabase(DBID);

mDLLAPI.SQL_prepareStatement("INSERT INTO Team ( TeamName, Permanent ) VALUES ( Tea , Perm );");
mDLLAPI.SQL_bindNamedValueString("Tea", "'BauerTeam'");
mDLLAPI.SQL_bindNamedValueInt("Perm", 0);
log("[DB]DoTable(): "$mDLLAPI.SQL_executeStatement());
} 

So can I make this work?

[BlackHornet80]

You will have to use the database syntax here ( http://www.sqlite.org/capi3ref.html#sqlite3_bind_blob )
So you will have to use for example this notation for a "variable" in a statement:

function DoInsert()
{
mDLLAPI.SQL_selectDatabase(DBID);

mDLLAPI.SQL_prepareStatement("INSERT INTO Team ( TeamName, Permanent ) VALUES ( @Tea , @Perm );");
mDLLAPI.SQL_bindNamedValueString("@Tea", "BauerTeam");
mDLLAPI.SQL_bindNamedValueInt("@Perm", 0);
log("[DB]DoTable(): "$mDLLAPI.SQL_executeStatement());
} 

I hope this solves your problem,

kind regards

[legoaragim]

Hi,

Thank's a lot for your content, i'm easy with SQL commands so i assumed that it was just what I needed.

I promised I read what you said but i just don't understand your tutorial or readme file, maybe because i'm not good at programming...

I've pasted the .uc files in the directory but I don't know how to interact with them.

So my questions are:

When in the editor, how can i create a database or send any parameters for queries?

Do I have to use a trigger or a console command?

How to use your example?



Sorry to take your time but i've been looking for days and still don't get anything...

Thank's.

[BlackHornet80]

I'm currently working on a new version 3.0.0.1

Current planned features:
- Handling multiple result sets makes it possible to query the database while iterating through a previous query result (isn't able in the current version)
- Support for an 128-bit TEA file encryption/decryption (key-based)
- some new functions for table management (I decided to add these due to a better framework i am working on):

dllimport final function int SQL_getTableCount();
dllimport final function SQL_getTableName(int aTableIdx, out string aTableName);
dllimport final function int SQL_getColumnCount(int aTableIdx);
dllimport final function SQL_getColumnInfo(int aTableIdx, int aColumnIdx, out string aColumnName, out int aColumnType);

-
And I think of creating a full set of sequences so you can use the framework functionality via Kismet in the future.

[hellslayer]

Thats very nice, handeling multiple results will remove a noticeable bottleneck of the current version.
I looking forward to this version, thanks for making this prject, it really has a lot of use cases.

[TechElv]

hi!
can i access-insert or query- sqlite tables at my game menu done with AS2 on Scaleform during the game play?

[hellslayer]

hi!
can i access-insert or query- sqlite tables at my game menu done with AS2 on Scaleform during the game play?

absolutely

[TechElv]

thanks for a flash positive answer.
so, i guess it is going to be queried to the text area i defined at AS2 right? - actually thats what i need.
but i dont know how can i show my selection query on the text area