SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Filterscripts > Includes

Reply
 
Thread Tools Display Modes
Old 15/12/2011, 06:26 AM   #11
KoczkaHUN
Gangsta
 
KoczkaHUN's Avatar
 
Join Date: Jan 2010
Posts: 516
Reputation: 100
Default Re: SQLite Improved

AWSUM THX!
Good to see this released (already discussed on IRC) :P
__________________
uıɐƃɐ oɔsǝʇ uı pɹɐoqʎǝʞ ʎnq ʇou llıʍ ı
-
Quote:
Originally Posted by WackoX
If i steal a television at a store, am i still legal if i put a sign on it saying "COPYRIGHT ELECTRONIC STORE"?
Quote:
[20:46:02] <balintx> What is the output of this PAWN code? printf("%d", random(100));
[20:46:11] <JaTochNietDan> WHO THE FUCK KNOWS
-
KoczkaHUN is offline   Reply With Quote
Old 15/12/2011, 06:34 AM   #12
T0pAz
Guest
 
Posts: n/a
Default Re: SQLite Improved

well scripted, well documented so well done!
  Reply With Quote
Old 15/12/2011, 11:51 AM   #13
Slice
High-roller
 
Join Date: Mar 2008
Location: Sweden
Posts: 1,899
Reputation: 1589
Spray Re: SQLite Improved

Thanks for the feedback.

@Kar: Yeah, slipped my mind somehow!

Update
  • Added stmt_autoclose.
  • Memory usage decreased significantly.
  • All functions now accept both packed and unpacked strings.
  • Minor bug fixes and optimizations.
Slice is offline   Reply With Quote
Old 15/12/2011, 12:49 PM   #14
Y_Less
Spam Machine
 
Y_Less's Avatar
 
Join Date: Jun 2008
Location: 629 - git.io/Y
Posts: 14,729
Reputation: 3073
Default Re: SQLite Improved

Very nicely done! I've had a quick glance over the code and I am impressed (not that I shouldn't be with you).
Y_Less is online now   Reply With Quote
Old 15/12/2011, 01:03 PM   #15
Finn
High-roller
 
Join Date: Jan 2008
Posts: 1,702
Reputation: 382
Default Re: SQLite Improved

Fuck you I am not going to rewrite my db functions once again
Finn is offline   Reply With Quote
Old 15/12/2011, 01:43 PM   #16
TheArcher
High-roller
 
TheArcher's Avatar
 
Join Date: Dec 2009
Location: Home
Posts: 2,423
Reputation: 251
Default Re: SQLite Improved

Quote:
Originally Posted by Finn View Post
Fuck you I am not going to rewrite my db functions once again
Was that an insult?
__________________
TheArcher is offline   Reply With Quote
Old 15/12/2011, 07:45 PM   #17
Scenario
Godfather
 
Scenario's Avatar
 
Join Date: Feb 2010
Location: Heaven
Posts: 8,133
Reputation: 701
Default Re: SQLite Improved

Quote:
Originally Posted by TheArcher View Post
Was that an insult?
No, it was sarcasm.
Scenario is offline   Reply With Quote
Old 16/12/2011, 05:18 AM   #18
AustinJ
Big Clucker
 
Join Date: Jul 2011
Posts: 145
Reputation: 15
Default Re: SQLite Improved

Pretty damn awesome. Very useful for host that don't have MySQL.
__________________
AustinJ is offline   Reply With Quote
Old 16/12/2011, 08:21 AM   #19
Slice
High-roller
 
Join Date: Mar 2008
Location: Sweden
Posts: 1,899
Reputation: 1589
Spray Re: SQLite Improved

Update!
  • Added db_open_persistent, db_is_persistent, db_is_valid_persistent, and db_free_persistent.

    Persistent databases work exactly the same as ones you open with db_open, except for one thing: you only have to open it once. No, the database won't be constantly open.
    Example:
    Code:
    new
    	DB:g_db
    ;
    
    public OnGameModeInit() {
    	g_db = db_open_persistent("mydb.db");
    	
    	db_query(g_db, "...");
    	
    	// The db will now close
    }
    
    public OnSomethingSomething() {
    	// SQLitei will detect that the db is closed and open it
    	db_query(g_db, "...");
    	
    	// The db is still open
    	db_query(g_db, "...");
    	
    	// The db will now close
    }
  • Added db_query_autofree.

    This is just like db_query, except it will free the result for you when the current callback finishes executing. No need to use db_free_result.

    Note: Do not use db_free_result on results from this function.
  • Added db_get_field_int and db_get_field_float.
    By default, it will fetch field 0. You can add an additional argument to specify another field.

    Quickly fetch an integer or float from a result. Example:
    Code:
    new user_count;
    
    user_count = db_fetch_int(db_query_autofree(db, "SELECT COUNT(*) FROM users"));
    
    printf("There are %d users registered.", user_count);
  • Corrected a few SQLite natives.
Slice is offline   Reply With Quote
Old 22/12/2011, 11:45 AM   #20
kizla
Big Clucker
 
kizla's Avatar
 
Join Date: Dec 2009
Posts: 180
Reputation: 50
Default Re: SQLite Improved

surely gonna use it

Awesome work...
kizla is offline   Reply With Quote
Reply

Thread Tools
Display Modes

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
[FilterScript] [FS] Improved aiming luby Filterscripts 70 19/09/2014 09:00 AM
[GameMode] SECOND RELEASE TDM: IMPROVED grantism Gamemode Scripts 5 15/10/2011 03:59 PM
Have I improved? BigAl Everything and Nothing 1 10/09/2011 12:17 AM
[Map] An improved LSPD Blacknight Maps 5 01/01/2011 04:21 PM
[Map] [MAP]Improved District im2fast4u Maps 2 06/10/2009 03:44 PM


All times are GMT. The time now is 05:46 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.