[Bogdan1992]

pawn Код:

stock MySQL_House(playerid)
{
    new query[300], pname[24], savingstring[20],string1[128], x[20], y[20], z[20];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT * FROM house WHERE houseid = <0");
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(savingstring, "houseid"); HouseID[playerid] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Owner"); HouseOwner[playerid] = strval(savingstring);
        mysql_fetch_field_row(x, "xHPos");
        mysql_fetch_field_row(y, "yHPos");
        mysql_fetch_field_row(z, "zHPos");

        format(string1, sizeof string1, "House Owner: %s\nX:%d, Y:%d,Z:%d\nHouse ID:%d", HouseOwner, floatstr(x), floatstr(y), floatstr(z), HouseID);
        CreatePickup(1273, 1, floatstr(x), floatstr(y), floatstr(z));
        Create3DTextLabel(string1, 0xFFFFFFFF, floatstr(x), floatstr(y), floatstr(z), 10.0, 0, 0);

    }
    mysql_free_result();
    return 1;
}