Raised This Month: $ Target: $400
 0% 

SQLite local database


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
GuskiS
Veteran Member
Join Date: Aug 2007
Location: Latvia
Old 10-15-2014 , 03:17   Re: SQLite local database
Reply With Quote #1

Quote:
Originally Posted by YamiKaitou View Post
SQL_SetAffinity("sqlite");
SQL_MakeDbTuple("localhost", "root", "", "database");
Quote:
Originally Posted by Sylwester View Post
You need to make sure that sqlite module is running (you can start it from plugin with #pragma loadlib sqlite).
If mysql module is running too then you have to use SQL_SetAffinity("sqlite") before making tuple.
Make tuple using: g_sql_tuple = SQL_MakeDbTuple("", "", "", "filename")
Your database will be saved in addons\amxmodx\data\sqlite3\filename.sq3
You can then view and edit your database using other tools like http://sourceforge.net/projects/sqlitebrowser/
Thanks for reply, nicely done
But which tuple type is the right one - with or without (you hihi) login data?

EDIT: Does anything else changes from MySQL? Or everything remains the same?
__________________
Finished mods:
Trouble in Terrorist Town
MurderMod
The Hidden
Cowboys vs Indians
JailBreak Supreme
Survival Madness

Last edited by GuskiS; 10-15-2014 at 03:19.
GuskiS is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 17:37.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode