[Dokins]

House Storing. - DOESNT WORK.

pawn Код:

if(!(strcmp(item, "cocaine", true)))
            {
                HouseCoke[houseid] = MySQL_GetValue(houseid, "HouseCoke", "houses");
                Cocaine[playerid] = MySQL_GetValue(PlayerSQLID[playerid], "cocaine", "accounts");
                if(sscanf(params, "s[24]s[32]d",usage,item,slot))
                {
                    SendClientMessage(playerid, COLOUR_GREY, "Usage: /house store cocaine [amount]");
                    return 1;

                }
                if(slot > Cocaine[playerid]) return SendClientMessage(playerid, COLOUR_GREY, "You do not have this much cocaine.");
                HouseCoke[houseid] = HouseCoke[houseid] += slot;
                Cocaine[playerid] = Cocaine[playerid] -= slot;
                MySQL_SetInteger(houseid, "HouseCoke", HouseCoke[houseid], "houses");
                MySQL_SetInteger(PlayerSQLID[playerid], "Cocaine", Cocaine[playerid], "accounts");
                format(string, sizeof(string), "You have stored a %d gram(s) of cocaine in your house.", slot);
                SendClientMessage(playerid, COLOUR_BLUE, string);
                format(string, sizeof(string), "* %s has stored some drugs in their house.", GetNameEx(playerid));
                ProxDetector(30.0, playerid, string, COLOUR_PURPLE, COLOUR_PURPLE, COLOUR_PURPLE, COLOUR_PURPLE, COLOUR_PURPLE);
            }

House GETTING - WORKS.

pawn Код:

if(!strcmp(item, "weed", true))
            {
                HouseWeed[houseid] = MySQL_GetValue(houseid, "HouseWeed", "houses");
                Weed[playerid] = MySQL_GetValue(PlayerSQLID[playerid], "weed", "accounts");
                if(sscanf(params, "s[24]s[32]d",usage,item,slot))
                {
                    SendClientMessage(playerid, COLOUR_GREY, "Usage: /house get weed [amount]");
                    return 1;

                }
                if(slot > HouseWeed[houseid]) return SendClientMessage(playerid, COLOUR_GREY, "You do not have this much weed stored.");
                HouseWeed[houseid] = HouseWeed[houseid] -= slot;
                Weed[playerid] = Weed[playerid] + slot;
                MySQL_SetInteger(houseid, "HouseWeed", HouseWeed[houseid], "houses");
                MySQL_SetInteger(PlayerSQLID[playerid], "Weed", Weed[playerid], "accounts");
                format(string, sizeof(string), "You have taken a %d gram(s) of weed from your house.", slot);
                SendClientMessage(playerid, COLOUR_BLUE, string);
                format(string, sizeof(string), "* %s has taken some drugs from their house.", GetNameEx(playerid));
                ProxDetector(30.0, playerid, string, COLOUR_PURPLE, COLOUR_PURPLE, COLOUR_PURPLE, COLOUR_PURPLE, COLOUR_PURPLE);
            }

[RenSoprano]

pawn Код:

if(!strcmp(item, "cocaine", true))
            {
                HouseCoke[houseid] = MySQL_GetValue(houseid, "HouseCoke", "houses");
                Cocaine[playerid] = MySQL_GetValue(PlayerSQLID[playerid], "cocaine", "accounts");
                if(sscanf(params, "s[24]s[32]d",usage,item,slot))
                {
                    SendClientMessage(playerid, COLOUR_GREY, "Usage: /house store cocaine [amount]");
                    return 1;

                }
                if(slot > Cocaine[playerid]) return SendClientMessage(playerid, COLOUR_GREY, "You do not have this much cocaine.");
                HouseCoke[houseid] = HouseCoke[houseid] += slot;
                Cocaine[playerid] = Cocaine[playerid] -= slot;
                MySQL_SetInteger(houseid, "HouseCoke", HouseCoke[houseid], "houses");
                MySQL_SetInteger(PlayerSQLID[playerid], "Cocaine", Cocaine[playerid], "accounts");
                format(string, sizeof(string), "You have stored a %d gram(s) of cocaine in your house.", slot);
                SendClientMessage(playerid, COLOUR_BLUE, string);
                format(string, sizeof(string), "* %s has stored some drugs in their house.", GetNameEx(playerid));
                ProxDetector(30.0, playerid, string, COLOUR_PURPLE, COLOUR_PURPLE, COLOUR_PURPLE, COLOUR_PURPLE, COLOUR_PURPLE);
            }

Try this

[Dokins]

It's no difference, it's to do with the SSCANF and I can't figure it out.