SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help > Tutorials

Reply
 
Thread Tools Display Modes
Old 30/05/2016, 02:16 PM   #61
Roozevelt
Gangsta
 
Roozevelt's Avatar
 
Join Date: Jan 2016
Location: Tunsia
Posts: 652
Reputation: 143
Default Re: How to use SQLite

thank you i'll get it
__________________
• Left SA-MP.
• Roosevelt's stunt map pack : Click here
• SEF community
• Join now

Roozevelt is offline   Reply With Quote
Old 23/10/2017, 08:13 AM   #62
Arbico
Big Clucker
 
Arbico's Avatar
 
Join Date: Jul 2017
Posts: 91
Reputation: 5
Default Re: How to use SQLite

What do i do if i want to print a value that i return from the database
Like i have a database that has someone with score of 50
i want to send a message to that player that he have a score of 50.
__________________
Skype:Arbico
Anywhere, Anytime, i'm here to help.

Arbico is offline   Reply With Quote
Old 23/10/2017, 08:51 AM   #63
xMoBi
Big Clucker
 
xMoBi's Avatar
 
Join Date: Jul 2017
Location: Pakistan
Posts: 72
Reputation: 24
Default Re: How to use SQLite

PHP Code:
new DBResult:result db_query(sql_pipeline"SELECT * FROM `table_name` WHERE `score` = 50 LIMIT 1");
if(
db_num_rows(result)) {
    new 
name[MAX_PLAYER_NAME], string[100];
    
db_get_field_assoc_int(0"name"namesizeof name);
    
format(stringsizeof(string), "%s has 50 score"name);
    
SendClientMessage(playerid, -1string);

xMoBi is offline   Reply With Quote
Old 18/01/2018, 03:43 PM   #64
Jaxium
Little Clucker
 
Jaxium's Avatar
 
Join Date: Nov 2017
Location: Egypt
Posts: 18
Reputation: 1
Default Re: How to use SQLite

Do I need to learn main SQLite from a bigger source, before I read this tutorial?
Jaxium is offline   Reply With Quote
Old 18/01/2018, 08:00 PM   #65
dani18
Big Clucker
 
dani18's Avatar
 
Join Date: Dec 2017
Posts: 97
Reputation: 14
Default Re: How to use SQLite

Excellent work
__________________
dani18 is offline   Reply With Quote
Old 05/05/2018, 03:38 AM   #66
PlayHard
Huge Clucker
 
PlayHard's Avatar
 
Join Date: Nov 2011
Location: In an apartment
Posts: 218
Reputation: 22
Default Re: How to use SQLite

Thank you.
PlayHard 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
SQLite [Ro]DuReX Română/Romanian 30 20/06/2013 12:47 PM
SQLite help CreativityLacker Scripting Help 2 12/05/2013 10:37 AM
SQLITE help Ryan_Obeles Scripting Help 9 28/04/2013 01:55 AM
Little help on sqlite FireCat Help Archive 4 20/08/2011 01:45 PM


All times are GMT. The time now is 04:28 PM.


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