Help in MYSQL Command - Printable Version

Help in MYSQL Command - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Help in MYSQL Command (/showthread.php?tid=468008)

Help in MYSQL Command - willttoonn - 06.10.2013

I need a script that check the information contained in the row Bolo, I had one but it did not work.

pawn Код:

CMD:checkbolo(playerid, params[])
{
    new vehicleid;
    if(sscanf(params, "d", vehicleid)) return SendClientMessage(playerid, COLOR_GREY, "[CMD]: /checkbolo [vehicleid]");
    if(playerinfo[playerid][pMuted] == 1) return SendClientMessage(playerid, COLOR_ERROR, MUTED_ERROR);
    if(playerinfo[playerid][pLogado] == 0) return SendClientMessage(playerid, COLOR_ERROR, LOGIN_ERROR);
    format(query, sizeof(query), "SELECT Bolo FROM `vehicleinfo` WHERE ID = '",vehicleid,"'");
    mysql_function_query(MYSQLConnection, query, false, "noReturnQuery", "d", playerid);
    format(string, sizeof(string), "Bolo: %s", query);
    SendClientMessage(playerid, COLOR_GREY, query);
    return 1;
}

Re: Help in MYSQL Command - willttoonn - 06.10.2013

Someone?

Re: Help in MYSQL Command - DaTa[X] - 06.10.2013

pawn Код:

CMD:checkbolo(playerid, params[])
{
    new vehicleid;
    if(sscanf(params, "d", vehicleid)) return SendClientMessage(playerid, COLOR_GREY, "[CMD]: /checkbolo [vehicleid]");
    if(playerinfo[playerid][pMuted] == 1) return SendClientMessage(playerid, COLOR_ERROR, MUTED_ERROR);
    if(playerinfo[playerid][pLogado] == 0) return SendClientMessage(playerid, COLOR_ERROR, LOGIN_ERROR);
    format(query, sizeof(query), "SELECT Bolo FROM `vehicleinfo` WHERE ID = %d",vehicleid,"'");
    mysql_function_query(MYSQLConnection, query, false, "noReturnQuery", "d", playerid);
    format(string, sizeof(string), "Bolo: %s", query);
    SendClientMessage(playerid, COLOR_GREY, query);
    return 1;
}

Re: Help in MYSQL Command - willttoonn - 06.10.2013

Quote:

Originally Posted by DaTa[X]

pawn Код:

CMD:checkbolo(playerid, params[])
{
    new vehicleid;
    if(sscanf(params, "d", vehicleid)) return SendClientMessage(playerid, COLOR_GREY, "[CMD]: /checkbolo [vehicleid]");
    if(playerinfo[playerid][pMuted] == 1) return SendClientMessage(playerid, COLOR_ERROR, MUTED_ERROR);
    if(playerinfo[playerid][pLogado] == 0) return SendClientMessage(playerid, COLOR_ERROR, LOGIN_ERROR);
    format(query, sizeof(query), "SELECT Bolo FROM `vehicleinfo` WHERE ID = %d",vehicleid,"'");
    mysql_function_query(MYSQLConnection, query, false, "noReturnQuery", "d", playerid);
    format(string, sizeof(string), "Bolo: %s", query);
    SendClientMessage(playerid, COLOR_GREY, query);
    return 1;
}

Not work man,

the message SELECT FROM Bolo `vehicleinfo` WHERE id =% d; S

Re: Help in MYSQL Command - -Prodigy- - 06.10.2013

pawn Код:

format(query, sizeof(query), "SELECT Bolo FROM `vehicleinfo` WHERE ID = %d", vehicleid);

I also suggest you look into cached queries

Re: Help in MYSQL Command - willttoonn - 06.10.2013

Quote:

Originally Posted by -Prodigy-

pawn Код:

format(query, sizeof(query), "SELECT Bolo FROM `vehicleinfo` WHERE ID = %d", vehicleid);

I also suggest you look into cached queries

Error =S

I need an script with function of read these rows in table vehicleinfo.

You need more informations? you can ask me xD

Re: Help in MYSQL Command - willttoonn - 06.10.2013

Someone?

Re: Help in MYSQL Command - NeTSk8 - 07.10.2013

Try this, it's using cache:

Код:

CMD:checkbolo(playerid, params[])
{
    new vehicleid;
    if(sscanf(params, "d", vehicleid)) return SendClientMessage(playerid, COLOR_GREY, "[CMD]: /checkbolo [vehicleid]");
    if(playerinfo[playerid][pMuted] == 1) return SendClientMessage(playerid, COLOR_ERROR, MUTED_ERROR);
    if(playerinfo[playerid][pLogado] == 0) return SendClientMessage(playerid, COLOR_ERROR, LOGIN_ERROR);
    format(query, sizeof(query), "SELECT Bolo FROM `vehicleinfo` WHERE ID = %d",vehicleid);
    mysql_function_query(MYSQLConnection, query, true, "BoloReturnMessage", "d", playerid);
    SendClientMessage(playerid, COLOR_GREY, "Returning Bolo from database:");
    return 1;
}
forward BoloReturnMessage(playerid);
public BoloReturnMessage(playerid)
{
    new rows, fields;
    cache_get_data(rows, fields);
    if(Rows != 0)
    {
        new content[1];
		new bstring[128], bolo;
        cache_get_field_content(0, "Bolo", content);
        bolo = strval(content);
        format(bstring, sizeof(bstring), "Bolo: %s", bolo);
    	SendClientMessage(playerid, COLOR_GREY, bstring);
    }
    else
    {
        SendClientMessage(playerid, COLOR_GREY, "Failed to retrieve info from the database.");
    }
	format(string, sizeof(string), "Bolo: %s", query);
    SendClientMessage(playerid, COLOR_GREY, query);
}

It should work.