Mysql Problem [FIXED]
#1

Edit: I fixed it!!!!






pawn Код:
CMD:createorg(playerid,params[])
{
    if(!IsPlayerAdmin(playerid)) return 0;
    if(sscanf(params,"iis",orgid,orggenre,oname)) return SendClientMessage(playerid,grey,"USAGE: /createorg [orgid] [genre] [name]");
    if(orgid > MAX_ORGS) return SendClientMessage(playerid,red,"Too high. Max org limitation exceed.");
    CheckMySQL();
    format(str, sizeof(str), "SELECT * FROM orgs WHERE Orgid = '%d'",orgid);
    mysql_query(str);
    mysql_store_result();
    if(mysql_num_rows() == 0)
    {
        mysql_free_result();
        format(str,sizeof(str),"INSERT INTO orgs (Orgid,Name) VALUES ('%d','%s','%d')",orgid,oname,orggenre);
        mysql_query(str);
    }
    else
    {
        SendClientMessage(playerid,red,"ERROR: This Organization ID is already used.");
    }
    format(str,sizeof(str),"** You have created organization id %d, %s.",orgid,oname);
    SendClientMessage(playerid,orange,str);
    return 1;
}
Well when i use createorg it doesnt creates a file in my mysql system. My mysql works for my register and login but not for this...
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)