1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Input line too long - MySQL UPDATE
Rdx
Banned
Posts: 170
Threads: 10
Joined: Sep 2011
#1

26.12.2012, 12:12
I have error : input line too long (after substitutions). I don't know how to shorten my code.


Код HTML:
forward SaveCar(uid);
public Save(uid)
{
    new query[1024];
	format(query, sizeof(query), "UPDATE `rp_cars` SET `akt` = '%d',`mod`='%d',`px`='%f',`py`='%f',`pz`='%f',`k1`='%d',`k2`='%d',`hp`='%f',`u`='%d',`u2`='%d',`u3`='%d',`prze`='%f',`cena`='%d',`p`='%d',`pmax`='%d',`ptyp`='%d',`reja`='%s',`ownerid`='%d',`alarm`='%d',`lock`='%d',`owner`='%d',`ownerid`='%d',`t`='%d',`t2`='%s',`t3`='%d',`t4`='%d',`t5`='%d',`t6`='%d',`t7`='%d',`t8`='%d',`t9`='%d',`t10`='%d',`t11`='%d',`t12`='%d',`t13`='%d',`t14`='%d',`pj`='%d',`int`='%d',`vw`='%d',`audio`='%d',`link`='%s',`zarej`='%d',`kogut`='%d',`blok`='%d',`bpowod`='%s' WHERE `uid`='%d'",
	SamochodInfo[uid][sAktywny],
	SamochodInfo[uid][sModel],
	SamochodInfo[uid][sSpawnX],
	SamochodInfo[uid][sSpawnY],
	SamochodInfo[uid][sSpawnZ],
	SamochodInfo[uid][sK1],
	SamochodInfo[uid][sK2],
	SamochodInfo[uid][sHP],
	SamochodInfo[uid][sUszkodzenia],
	SamochodInfo[uid][sUszkodzenia2],
	SamochodInfo[uid][sUszkodzenia3],
	SamochodInfo[uid][sPrzebieg],
	SamochodInfo[uid][sCena],
	SamochodInfo[uid][sPaliwo],
	SamochodInfo[uid][sPaliwoMax],
	SamochodInfo[uid][sPaliwoTyp],
	SamochodInfo[uid][sRejestracja],
	SamochodInfo[uid][sAlarm],
	SamochodInfo[uid][sZamkniety],
	SamochodInfo[uid][sOwner],
	SamochodInfo[uid][sOwnerID],
	SamochodInfo[uid][sTune],
	SamochodInfo[uid][sTune2],
	SamochodInfo[uid][sTune3],
	SamochodInfo[uid][sTune4],
	SamochodInfo[uid][sTune5],
	SamochodInfo[uid][sTune6],
	SamochodInfo[uid][sTune7],
	SamochodInfo[uid][sTune8],
	SamochodInfo[uid][sTune9],
	SamochodInfo[uid][sTune10],
	SamochodInfo[uid][sTune11],
	SamochodInfo[uid][sTune12],
	SamochodInfo[uid][sTune13],
	SamochodInfo[uid][sTune14],
	SamochodInfo[uid][sPJ],
	SamochodInfo[uid][sInt],
	SamochodInfo[uid][sVir],
	SamochodInfo[uid][sAudio],
	SamochodInfo[uid][sAudioLink],
	SamochodInfo[uid][sZarejestrowany],
	SamochodInfo[uid][sKogut],
	SamochodInfo[uid][sBlokada],
	SamochodInfo[uid][sBlokadaPowod],
	uid);
	qr++; mysql_query(query);
	mysql_free_result();
	return 1;
}
Find
Reply
Peach
Big Clucker
***
Posts: 100
Threads: 4
Joined: Oct 2012
Reputation: 0
#2

26.12.2012, 12:16
To fix that you'd have to format two query strings(instead of just one).

Then you'd query the (query) as you've formatted two of them.

If you're stuck I can do it for you..
Find
Reply
Rdx
Banned
Posts: 170
Threads: 10
Joined: Sep 2011
#3

26.12.2012, 12:45
Quote:
Originally Posted by Peach
Посмотреть сообщение
If you're stuck I can do it for you..
Can u do it for me? It's my first time with mysql ;p.
Find
Reply
Djole1337
Gangsta
*****
Posts: 873
Threads: 5
Joined: Apr 2012
Reputation: 0
#4

26.12.2012, 12:48
pawn Код:
new
    iQuery[256]
;
strcat(iQuery, "some string");
strcat(iQuery, "some string 2");
Now you can use query or w/e you doing.
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#5

26.12.2012, 12:51
Quote:
Originally Posted by Mr_DjolE
Посмотреть сообщение
pawn Код:
new
    iQuery[256]
;
strcat(iQuery, "some string");
strcat(iQuery, "some string 2");
Now you can use query or w/e you doing.
This.

But you should use a string of size over 512, because it won't update with lower size.
Find
Reply
Djole1337
Gangsta
*****
Posts: 873
Threads: 5
Joined: Apr 2012
Reputation: 0
#6

26.12.2012, 12:52
Quote:
Originally Posted by Dwane
Посмотреть сообщение
This.

But you should use a string of size over 512, because it won't update with lower size.
Yeah, I've just placed a random size.
Find
Reply
Rdx
Banned
Posts: 170
Threads: 10
Joined: Sep 2011
#7

26.12.2012, 13:08
Is it good now?
Код HTML:
new query[512];
strcat(query, "UPDATE `rp_cars` SET `akt` = '%d',`mod`='%d',`px`='%f',`py`='%f',`pz`='%f',`k1`='%d',`k2`='%d',`hp`='%f',`u`='%d',`u2`='%d',`u3`='%d',`prze`='%f',`cena`='%d',`p`='%d',`pmax`='%d',`ptyp`='%d',`reja`='%s',`ownerid`='%d',`alarm`='%d'");
strcat(query, "`lock`='%d',`owner`='%d',`ownerid`='%d',`t`='%d',`t2`='%s',`t3`='%d',`t4`='%d',`t5`='%d',`t6`='%d',`t7`='%d',`t8`='%d',`t9`='%d',`t10`='%d',`t11`='%d',`t12`='%d',`t13`='%d',`t14`='%d',`pj`='%d',`int`='%d',`vw`='%d',`audio`='%d',`link`='%s',`zarej`='%d',`kogut`='%d',`blok`='%d',`bpowod`='%s' WHERE `uid`='%d'",
	SamochodInfo[uid][sAktywny],
	SamochodInfo[uid][sModel],
	SamochodInfo[uid][sSpawnX],
	SamochodInfo[uid][sSpawnY],
	SamochodInfo[uid][sSpawnZ],
	SamochodInfo[uid][sK1],
	SamochodInfo[uid][sK2],
	SamochodInfo[uid][sHP],
	SamochodInfo[uid][sUszkodzenia],
	SamochodInfo[uid][sUszkodzenia2],
	SamochodInfo[uid][sUszkodzenia3],
	SamochodInfo[uid][sPrzebieg],
	SamochodInfo[uid][sCena],
	SamochodInfo[uid][sPaliwo],
	SamochodInfo[uid][sPaliwoMax],
	SamochodInfo[uid][sPaliwoTyp],
	SamochodInfo[uid][sRejestracja],
	SamochodInfo[uid][sAlarm],
	SamochodInfo[uid][sZamkniety],
	SamochodInfo[uid][sOwner],
	SamochodInfo[uid][sOwnerID],
	SamochodInfo[uid][sTune],
	SamochodInfo[uid][sTune2],
	SamochodInfo[uid][sTune3],
	SamochodInfo[uid][sTune4],
	SamochodInfo[uid][sTune5],
	SamochodInfo[uid][sTune6],
	SamochodInfo[uid][sTune7],
	SamochodInfo[uid][sTune8],
	SamochodInfo[uid][sTune9],
	SamochodInfo[uid][sTune10],
	SamochodInfo[uid][sTune11],
	SamochodInfo[uid][sTune12],
	SamochodInfo[uid][sTune13],
	SamochodInfo[uid][sTune14],
	SamochodInfo[uid][sPJ],
	SamochodInfo[uid][sInt],
	SamochodInfo[uid][sVir],
	SamochodInfo[uid][sAudio],
	SamochodInfo[uid][sAudioLink],
	SamochodInfo[uid][sZarejestrowany],
	SamochodInfo[uid][sKogut],
	SamochodInfo[uid][sBlokada],
	SamochodInfo[uid][sBlokadaPowod],
	uid);
	qr++; mysql_query(query);
	mysql_free_result();
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#8

26.12.2012, 13:14
No, because it won't format the message like that.
pawn Код:
new
    query[ 512 ],
    query2[ 256 ] // Optional
;
format( query2, sizeof( query2 ), "text here with formats...", variable1, variable2.. );
strcat( query, query2 );
format( query2, sizeof( query2 ), "text2 here with formats...", variable3, variable4.. );
strcat( query, query2 );
Find
Reply
Rdx
Banned
Posts: 170
Threads: 10
Joined: Sep 2011
#9

26.12.2012, 23:10
Can u make example with my variables?
Find
Reply
ReneG
High-roller
*****
Posts: 1,905
Threads: 63
Joined: Oct 2011
Reputation: 0
#10

26.12.2012, 23:31
You don't need two strings nor strcat.
pawn Код:
forward SaveCar(uid);
public SaveCar(uid)
{
    new query[700];
    format(query, sizeof(query), "UPDATE `rp_cars` SET `akt` = '%d',`mod`='%d',`px`='%f',`py`='%f',`pz`='%f',`k1`='%d',`k2`='%d',`hp`='%f',`u`='%d',`u2`='%d',`u3`='%d',`prze`='%f',`cena`='%d',`p`='%d',`pmax`='%d',`ptyp`='%d',`reja`='%s',`ownerid`='%d',`alarm`='%d',`lock`='%d',`owner`='%d',`ownerid`='%d'",
    SamochodInfo[uid][sAktywny],
    SamochodInfo[uid][sModel],
    SamochodInfo[uid][sSpawnX],
    SamochodInfo[uid][sSpawnY],
    SamochodInfo[uid][sSpawnZ],
    SamochodInfo[uid][sK1],
    SamochodInfo[uid][sK2],
    SamochodInfo[uid][sHP],
    SamochodInfo[uid][sUszkodzenia],
    SamochodInfo[uid][sUszkodzenia2],
    SamochodInfo[uid][sUszkodzenia3],
    SamochodInfo[uid][sPrzebieg],
    SamochodInfo[uid][sCena],
    SamochodInfo[uid][sPaliwo],
    SamochodInfo[uid][sPaliwoMax],
    SamochodInfo[uid][sPaliwoTyp],
    SamochodInfo[uid][sRejestracja],
    SamochodInfo[uid][sAlarm],
    SamochodInfo[uid][sZamkniety],
    SamochodInfo[uid][sOwner],
    SamochodInfo[uid][sOwnerID]);

    format(query, sizeof query, "%s,`t`='%d',`t2`='%s',`t3`='%d',`t4`='%d',`t5`='%d',`t6`='%d',`t7`='%d',`t8`='%d',`t9`='%d',`t10`='%d',`t11`='%d',`t12`='%d',`t13`='%d',`t14`='%d',`pj`='%d',`int`='%d',`vw`='%d',`audio`='%d',`link`='%s',`zarej`='%d',`kogut`='%d',`blok`='%d',`bpowod`='%s' WHERE `uid`='%d'",
    query,
    SamochodInfo[uid][sTune],
    SamochodInfo[uid][sTune2],
    SamochodInfo[uid][sTune3],
    SamochodInfo[uid][sTune4],
    SamochodInfo[uid][sTune5],
    SamochodInfo[uid][sTune6],
    SamochodInfo[uid][sTune7],
    SamochodInfo[uid][sTune8],
    SamochodInfo[uid][sTune9],
    SamochodInfo[uid][sTune10],
    SamochodInfo[uid][sTune11],
    SamochodInfo[uid][sTune12],
    SamochodInfo[uid][sTune13],
    SamochodInfo[uid][sTune14],
    SamochodInfo[uid][sPJ],
    SamochodInfo[uid][sInt],
    SamochodInfo[uid][sVir],
    SamochodInfo[uid][sAudio],
    SamochodInfo[uid][sAudioLink],
    SamochodInfo[uid][sZarejestrowany],
    SamochodInfo[uid][sKogut],
    SamochodInfo[uid][sBlokada],
    SamochodInfo[uid][sBlokadaPowod],
    uid);

    qr++; mysql_query(query);
    mysql_free_result();
    return 1;
}
not tested
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help