/createhouse mysql problem
#1

pawn Код:
if(strcmp(cmd, "/createhouse", true) == 0)
    {
        if(IsPlayerConnected(playerid))
        {
            new Float:X, Float:Y, Float:Z;
            GetPlayerPos(playerid, X,Y,Z);
            new Int = 1;
            new Owner[256], Discription[256];
            format(Owner, sizeof(Owner), "The State");
            format(Discription, sizeof(Discription), "House Apartment");
            new Value = 45000;
            new Lock = 1;
            new Owned = 0;
            new World = 1;
            new Query[256];
            new x1 = 244.411987;
            new y1 = 305.032990;
            new z1 = 999.231995;
            new id;
            id = mysql_num_rows()+1;
            format(Query, sizeof(Query), "INSERT INTO `house` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Discription`, `Value`, `Int`, `Lock`, `Owned`, `World`) VALUES ('%d', '%f', '%f', '%f', '%f', '%f', '%f', '%s', '%s', '%d', '%d', '%d', '%d', '%d')", id, X,Y,Z,x1,y1,z1,Owner,Discription,Value,Int,Lock,Owned,World);
            mysql_query(Query);
            mysql_free_result();
            return 1;
        }
        return 1;
    }
It disn`t working..when i write this command is not insering in data base tabel.
Reply


Messages In This Thread
/createhouse mysql problem - by GeonMake - 11.02.2012, 11:53
Re: /createhouse mysql problem - by Sufyan - 11.02.2012, 11:58
Re: /createhouse mysql problem - by GeonMake - 11.02.2012, 12:06
Re: /createhouse mysql problem - by fordawinzz - 11.02.2012, 12:35
Re: /createhouse mysql problem - by Sufyan - 11.02.2012, 12:41
Re: /createhouse mysql problem - by GeonMake - 11.02.2012, 12:47
Re: /createhouse mysql problem - by fordawinzz - 11.02.2012, 15:04
Re: /createhouse mysql problem - by [MG]Dimi - 11.02.2012, 16:19
Re: /createhouse mysql problem - by Rob_Maate - 11.02.2012, 17:35
Re: /createhouse mysql problem - by GeonMake - 11.02.2012, 20:24

Forum Jump:


Users browsing this thread: 3 Guest(s)