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

Threaded Mode
Sscanf "Warning"
BossArturKA
Little Clucker
**
Posts: 26
Threads: 11
Joined: Aug 2013
Reputation: 0
#1

02.05.2014, 23:01
Hi, everybody!
At me is fashions, loading of businesses is fashionable.
It looks as follows:
PHP код:
    new Result:busns = sql_query(zConn, "SELECT * FROM `business` ORDER BY `id`", QUERY_CACHED);
    gBusinessCount = sql_num_rows(busns);
    for(new i;i<gBusinessCount;i++)
    {
        sql_fetch_row(busns,"|",zRes);
        sql_next_row(busns);
        sscanf(zRes,"p<|>e<is[64]iiiiiiiiffffiiiii>iiii",gBusiness[i]);
        gBusinessArea[i] = CreateDynamicSphere(gBusiness[i][busiX],gBusiness[i][busiY],gBusiness[i][busiZ],1.0);
        CreateDynamicPickup(19132,1,gBusiness[i][busiX],gBusiness[i][busiY],gBusiness[i][busiZ]);
        gBusinessText[i] = CreateDynamic3DTextLabel("_",CWHITE,gBusiness[i][busiX],gBusiness[i][busiY],gBusiness[i][busiZ]+1.0,20.0);
        switch(gBusiness[i][busiMafia])
        {
               case F_COL: Terra[2]++;
               case F_MEX: Terra[1]++;
               case F_YAK: Terra[0]++;
        }
    }
    sql_free_result(busns); 
At start fashion flood ravine here so:
PHP код:
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count.
[01:41:33] sscanf warning: Format specifier does not match parameter count. 
Problem in line:
PHP код:
sscanf(zRes,"p<|>e<is[64]iiiiiiiiffffiiiii>iiii",gBusiness[i]); 
I need to load the following hitherto:
PHP код:
busiID,
busiName[64],
busiType,
busiBint,
busiOwnerID,
busiSellPrice,
busiBank,
busiPrice,
busiProduct,
busiStatus,
Float:busiX,
Float:busiY,
Float:busiZ,
Float:busiR,
busiOrder,
busiDeliving,
busiDelivingArea,
busiDay,
busiMafia,
busiEnterPrice 
Here so the MySQL database looks:
PHP код:
CREATE TABLE IF NOT EXISTS `business` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE cp1251_bin NOT NULL,
  `type` int(2) NOT NULL,
  `bint` int(2) NOT NULL,
  `ownerid` int(9) NOT NULL,
  `sellprice` int(9) NOT NULL,
  `bank` int(11) NOT NULL,
  `price` int(4) NOT NULL,
  `product` int(7) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `x` float NOT NULL,
  `y` float NOT NULL,
  `z` float NOT NULL,
  `r` float NOT NULL,
  `order` int(8) NOT NULL DEFAULT '0',
  `deliving` int(8) NOT NULL DEFAULT '0',
  `day` int(30) NOT NULL,
  `mafia` int(11) NOT NULL,
  `enter` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin AUTO_INCREMENT=1 ; 
Help me to make correctly please inquiry for "sscanf".
Find
Reply
BossArturKA
Little Clucker
**
Posts: 26
Threads: 11
Joined: Aug 2013
Reputation: 0
#2

03.05.2014, 16:20
( Последний раз редактировалось BossArturKA; 03.05.2014 в 16:52. )
Not absolutely I understood, not the Englishman, the translator not absolutely correctly forms offers.
The mere verbiage turns out simply.
So it will turn out?
PHP код:
sscanf(zRes,"p<|>e<is[64]iiiffffiiiii>iiii",gBusiness[i]); 
On ideas:
PHP код:
`id` int(4) NOT NULL AUTO_INCREMENT,                //i
`name` varchar(64) COLLATE cp1251_bin NOT NULL,     //str
`type` int(2) NOT NULL,                             //i
`bint` int(2) NOT NULL,                             //i
`ownerid` int(9) NOT NULL,                          //i
`sellprice` int(9) NOT NULL,                        //i
`bank` int(11) NOT NULL,                            //i
`price` int(4) NOT NULL,                            //i
`product` int(7) NOT NULL,                          //i
`status` tinyint(1) NOT NULL,                       //i
`x` float NOT NULL,                                    //f
`y` float NOT NULL,                                    //f
`z` float NOT NULL,                                    //f
`r` float NOT NULL,                                    //f
`order` int(8) NOT NULL DEFAULT '0',                //i
`deliving` int(8) NOT NULL DEFAULT '0',             //i
`day` int(30) NOT NULL,                             //i
`mafia` int(11) NOT NULL,                           //i
`enter` int(32) NOT NULL,                           //i 
That is inquiry:
PHP код:
sscanf(zRes,"p<|>e<is[64]iiiiiiiiffffiiiii",gBusiness[i]); 
But it doesn't load...
Find
Reply
BossArturKA
Little Clucker
**
Posts: 26
Threads: 11
Joined: Aug 2013
Reputation: 0
#3

03.05.2014, 17:52
Close please.
It is solved.
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