Mysql retrive problem save and HTTP!
#1

I've try to use HTTP to retrive resolve host information about player but for some reason its show error: HTTP_ERROR_BAD_HOST 1
pawn Код:
CMD:check4(playerid,params[])
{
    new result[128];
    //new ip[25] = "2.35.99.186";
    new ip[25] = "84.54.177.51";
    //new ip =GetPlayerIP(playerid);
    format(result,sizeof(result), "linuxthefish.net?ip=%i.",ip);
    HTTP(playerid, HTTP_GET, result, "", "MyHttpResponse");
    return 1;
}
pawn Код:
forward MyHttpResponse(index, response_code, data[]);
public MyHttpResponse(index, response_code, data[])
{
        new buffer[128];
        if(response_code == 200)
        {
            format(buffer, sizeof(buffer), "%s", data);
            SendClientMessage(index, -1, buffer);
        }
        else
        {
            format(buffer, sizeof(buffer), "The request failed! The response code was: %d", response_code); // HTTP_ERROR_BAD_HOST          1
            SendClientMessage(index, -1, buffer);
        }
        return 1;
}
Thanks for everyone who help me solve this issue
Reply
#2

1)

pawn Код:
mysql_fetch_field_row(dt,"reason");     PlayerInfo[playerid][pReason] = strval(dt);
should be

pawn Код:
mysql_fetch_field_row(PlayerInfo[playerid][pReason], "reason");

2)

pawn Код:
stock SetReportlog(playerid,target,report)
{
    new reportlog[256];
    format(reportlog,sizeof(reportlog),"INSERT INTO `reportlog` (`username`,`reported`,`reason`,`IP`) VALUES ('%s','%s','%s','%s')",PlayerName(playerid),PlayerName(target),report,GetPlayerIP(target));
    mysql_query(reportlog);
    mysql_store_result();
    mysql_free_result();
    return 1;
}
should be

pawn Код:
stock SetReportlog(playerid,target,report[])
{
    new reportlog[256];
    format(reportlog,sizeof(reportlog),"INSERT INTO `reportlog` (`username`,`reported`,`reason`,`IP`) VALUES ('%s','%s','%s','%s')",PlayerName(playerid),PlayerName(target),report,GetPlayerIP(target));
    mysql_query(reportlog);
    return 1;
}

3)

Try putting www. before the URL.




/700th post
Reply
#3

mysql_affected_rows is only to be used after a delete, insert or update statement. Use mysql_num_rows when working with select, show or describe.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)