View Issue Details

IDProjectCategoryView StatusLast Update
0005884Multi Theft Auto : San AndreasServerpublic2011-10-27 18:59
ReporterMX_MasterAssigned Toccw 
PrioritynormalSeverityfeatureReproducibilityN/A
Status resolvedResolutionfixed 
Product Version 
Target Version1.1.1 R2Fixed in Version1.1.1 R2 
Summary0005884: REQUEST: Ability to create/open/delete custom SQLite DBs insteed of using general "registry.db"
Description

Many scripted storage systems uses built-in SQL functions. But if we want to create custom, private or portable storage system we needs custom SQLite databases, which can be placed in resources folders.

For example, we can store large maps data in SQLite DBs. It's faster than XML maps and will have more structure features.

Also we can store some private data in the resource folder in custom DBs.

Also custom filled DBs can be shared with their parent resource over Internet or MTA Community.

TagsNo tags attached.

Activities

MX_Master

2011-02-03 11:27

viewer   ~~0012849

is it not so hard to add this feature?

XX3

2011-02-11 15:57

viewer   ~~0012903

Hmm, I need this kind of fix so I can share the houses I made with Dakilla's SQL House system to the internet.

Good idea MX_Master!

MX_Master

2011-08-11 05:22

viewer   ~~0014230

i think it can be targeted to 2.0

arranTuna

2011-10-27 17:01

manager   ~~0015137

May already be possible. Look at the new function http://wiki.multitheftauto.com/wiki/DbConnect "host: The target to connect to. The format of this depends on the database type. For sqlite it is a filepath to a sqlite database file. If the filepath starts with ":/" then the server's global databases directory is used. "

That suggests that you can connect to custom sqlite database. Get newest nightly and give it a try!

MX_Master

2011-10-27 18:58

viewer   ~~0015140

Nice done, ccw. He made it (: http://code.google.com/p/mtasa-blue/source/detail?r=3327

p.s.: arranTuna, thanks for the PM

Issue History

Date Modified Username Field Change