SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 09/09/2016, 03:05 PM   #21
Spmn
Gangsta
 
Join Date: Jun 2015
Location: Romania
Posts: 490
Reputation: 131
Default Re: Updating BlueG's MySQL plugin R33+ scripts to R40

Quote:
Originally Posted by eco1999 View Post
Integer is wrong;

cache_get_value_name(0, "string", dest);
new value = cache_get_value_name(0, "integer");

New;

new value;
cache_get_value_name_int(0, "integer", value);
You didn't pay attention to the entire tutorial:
Quote:
all cache_get_ functions now return their value through a reference parameter instead of returning it directly:
However, I must admit that the first post is a bit ambiguous.
Spmn is offline   Reply With Quote
Old 16/09/2016, 07:46 PM   #22
Slawiii
Huge Clucker
 
Slawiii's Avatar
 
Join Date: May 2015
Location: Morocco, Missour
Posts: 278
Reputation: 16
Default Re: Updating BlueG's MySQL plugin R33+ scripts to R40

Quote:
Originally Posted by eco1999 View Post
Integer is wrong;

cache_get_value_name(0, "string", dest);
new value = cache_get_value_name(0, "integer");

New;

new value;
cache_get_value_name_int(0, "integer", value);
yes its the correct code

or like

PHP Code:

new value;
cache_get_value_int(0"integer"value); 
__________________

[FilterScript] SVIP System (0.01%)
Slawiii is offline   Reply With Quote
Old 21/09/2016, 03:04 PM   #23
Kathleen
Huge Clucker
 
Kathleen's Avatar
 
Join Date: May 2012
Location: Netherlands
Posts: 193
Reputation: 31
Default Re: Updating BlueG's MySQL plugin R33+ scripts to R40

Is it just me, or i have to update a thousand lines now and create over thousand variables just to make R40+ work.
Kathleen is offline   Reply With Quote
Old 09/12/2016, 03:51 PM   #24
saffierr
High-roller
 
saffierr's Avatar
 
Join Date: Jul 2013
Location: GetPlayerGirlHouse(targetplayer);
Posts: 1,149
Reputation: 39
Default Re: Updating BlueG's MySQL plugin R33+ scripts to R40

It's certainly not just you, I mean; this is harder than I thought it'd be, I do not comprehend somethings whilst I'm literally doing the same as described in the tutorial. Unless someone can help and/or convince me not to downgrade again to R39, I'm going to do it.
saffierr is offline   Reply With Quote
Old 09/12/2016, 05:12 PM   #25
Konstantinos
Spam Machine
 
Konstantinos's Avatar
 
Join Date: Dec 2011
Posts: 11,844
Reputation: 1399
Default Re: Updating BlueG's MySQL plugin R33+ scripts to R40

Quote:
Originally Posted by Kathleen View Post
Is it just me, or i have to update a thousand lines now and create over thousand variables just to make R40+ work.
That's why he provided regex examples so it will be easier. I converted each line myself manually and it only took a couple of minutes (literally 5 minutes for 10k lines and many mysql functions being called).

Quote:
Originally Posted by saffierr View Post
It's certainly not just you, I mean; this is harder than I thought it'd be, I do not comprehend somethings whilst I'm literally doing the same as described in the tutorial. Unless someone can help and/or convince me not to downgrade again to R39, I'm going to do it.
I'm not sure if the log system in R39-6 which now prints the query, it still does that for warnings. You can easily find the exact line (debug info) in R40+ and it supports multiple-statements which I like a lot. I'd still prefer to be up-to-date to my plugins and be ready for new features as well.


About the "over thousands variables", it's not like you cannot create a function similar to cache_num_rows and keep it the same style:
pawn Code:
cache_get_row_int(row_idx, column_idx)
{
    new retrieved_number;
    cache_get_value_index_int(row_idx, column_idx, retrieved_number);
    return retrieved_number;
}
__________________
Life is like riding a bicycle. To keep your balance, you must keep moving.

[Tutorial] How to use SQLite
[FilterScript] Tune System
Konstantinos is offline   Reply With Quote
Old 11/12/2016, 12:34 AM   #26
AroseKhanNiazi
High-roller
 
AroseKhanNiazi's Avatar
 
Join Date: Jan 2014
Location: Pakistan
Posts: 1,352
Reputation: 78
Default Re: Updating BlueG's MySQL plugin R33+ scripts to R40

So this? http://forum.sa-mp.com/showthread.ph...30#post3811730

In previous versions there was mysql_static.so which did that work but now? xD?
AroseKhanNiazi is offline   Reply With Quote
Old 19/12/2016, 09:55 AM   #27
PapaSmerf
Little Clucker
 
Join Date: Jul 2011
Posts: 42
Reputation: 0
Default Re: Updating BlueG's MySQL plugin R33+ scripts to R40

Well, when i'm trying to include a_mysql_yinline i have this error:

Code:
fatal error 111: user error: You have to include the y_inline include before this one!
#include <YSI\y_inline>
#include <a_mysql_yinline>
PapaSmerf is offline   Reply With Quote
Old 19/12/2016, 12:12 PM   #28
Konstantinos
Spam Machine
 
Konstantinos's Avatar
 
Join Date: Dec 2011
Posts: 11,844
Reputation: 1399
Default Re: Updating BlueG's MySQL plugin R33+ scripts to R40

Quote:
Originally Posted by PapaSmerf View Post
Well, when i'm trying to include a_mysql_yinline i have this error:

Code:
fatal error 111: user error: You have to include the y_inline include before this one!
#include <YSI\y_inline>
#include <a_mysql_yinline>
https://github.com/maddinat0r/samp-m...nclude#example
__________________
Life is like riding a bicycle. To keep your balance, you must keep moving.

[Tutorial] How to use SQLite
[FilterScript] Tune System
Konstantinos is offline   Reply With Quote
Old 19/12/2016, 12:29 PM   #29
PapaSmerf
Little Clucker
 
Join Date: Jul 2011
Posts: 42
Reputation: 0
Default Re: Updating BlueG's MySQL plugin R33+ scripts to R40

Yes, i have that one. I updated YSI to 4.0 but now my compiler crashes.
PapaSmerf is offline   Reply With Quote
Old 19/12/2016, 02:00 PM   #30
Konstantinos
Spam Machine
 
Konstantinos's Avatar
 
Join Date: Dec 2011
Posts: 11,844
Reputation: 1399
Default Re: Updating BlueG's MySQL plugin R33+ scripts to R40

Can you create a new file and try to compile the example given so we can be sure whether the problems comes from your code or not? I actually downloaded YSI and it compiled so your code is most likely the problem.
__________________
Life is like riding a bicycle. To keep your balance, you must keep moving.

[Tutorial] How to use SQLite
[FilterScript] Tune System
Konstantinos 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
Updating BlueG's mysql causes deleted functions to return problems Partner Scripting Help 0 01/11/2014 10:31 PM
[MySQL] From StickenKid's plugin to BlueG's plugin jessejanssen Scripting Help 2 15/06/2014 02:20 AM
Trouble updating with BlueG's mysql R7 2KY Scripting Help 3 25/12/2013 04:46 AM
BlueG MySQL plugin - Failed (plugins/mysql.so: undefined symbol: _Z13stringvprintfPKcPc) linuxthefish Plugin Development 10 13/07/2013 11:56 AM


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


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