SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 24/05/2014, 09:27 AM   #1
MisterMania67
Little Clucker
 
MisterMania67's Avatar
 
Join Date: Oct 2012
Posts: 31
Reputation: 16
Default Bug with compilation

Hi

I have a problem when I compile my script.
The compiler loads but never after that compiles and unresponsive.
And if I remove "adrenaline =% d", the compilation's going very well.
I do not understand or can come of this, the mysql plugin can be a size limit requests?

pawn Code:
forward UpdateAccount(playerid);
public UpdateAccount(playerid)
{
    F(query, sizeof(query), "UPDATE `accounts` SET pseudo='%s', ip='%s', mail='%s', sexe=%d, age=%d, origine='%s', argent=%d, banque=%d, cb=%d, skin=%d, score=%d, respect=%d, respectmax=%d, world=%d, interieur=%d, vie='%f', armure='%f', tuto=%d, prochExp=%d, job=%d, tempsJob=%d, tempsIg=%d, admin=%d, jail=%d, jailAdmin='%s', jailRaison='%s', avertissements=%d, telephone=%d, telephoneStatus=%d, telephoneCredits=%d,"\
    "clefP=%d, clefP2=%d, clefP3=%d, plaque='%s', weed=%d, coke=%d, adrenaline=%d WHERE pseudo='%s'",
    PlayerName(playerid),
    playerInfo[playerid][ip],
    playerInfo[playerid][mail],
    playerInfo[playerid][sexe],
    playerInfo[playerid][age],
    playerInfo[playerid][origine],
    playerInfo[playerid][argent],
    playerInfo[playerid][banque],
    playerInfo[playerid][cb],
    playerInfo[playerid][skin],
    playerInfo[playerid][score],
    playerInfo[playerid][respect],
    playerInfo[playerid][respectmax],
    playerInfo[playerid][world],
    playerInfo[playerid][interieur],
    playerInfo[playerid][vie],
    playerInfo[playerid][armure],
    playerInfo[playerid][tuto],
    playerInfo[playerid][prochExp],
    playerInfo[playerid][job],
    playerInfo[playerid][tempsJob],
    playerInfo[playerid][tempsIg],
    playerInfo[playerid][admin],
    playerInfo[playerid][jail],
    playerInfo[playerid][jailAdmin],
    playerInfo[playerid][jailRaison],
    playerInfo[playerid][avertissements],
    playerInfo[playerid][telephone],
    playerInfo[playerid][telephoneStatus],
    playerInfo[playerid][telephoneCredits],
    clefP[playerid][0],
    clefP[playerid][1],
    clefP[playerid][2],
    playerInfo[playerid][plaque],
    playerInfo[playerid][weed],
    playerInfo[playerid][coke],
    playerInfo[playerid][adrenaline],
    playerInfo[playerid][pseudo]);
    mysql_query(query);
    return printf("Compte %d - %s mis jour", playerInfo[playerid][id], PlayerName(playerid));
}
MisterMania67 is offline   Reply With Quote
Old 24/05/2014, 09:44 AM   #2
Ciandlah
Huge Clucker
 
Ciandlah's Avatar
 
Join Date: Mar 2013
Location: Pawno
Posts: 247
Reputation: 34
Default Re: Bug with compilation

I had the same problem a while back, I just done this. INstead of having one huge Query,

Split everything into two querys, for example

FIrst query you will have from IP - Job and the rest you would have in a second query from Job to the bottom.

If I understood your question properly this is what worked for me when my pawno crashed while attempting to understad a large query
__________________


Founder @ xApplications 2006 - present
C++, CSS, JAVA, HTML, Python, Mysql, Assembly
Founder @ CypressGaming Network Discord Server
Ciandlah is online now   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
Help me please with the compilation. StAsMaNn Scripting Help 1 07/05/2013 01:43 PM
Compilation Twixer Server Support 2 13/02/2012 03:25 PM


All times are GMT. The time now is 11:50 AM.


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