SA-MP Forums Archive
Mysql Problem [FIXED] - 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: Mysql Problem [FIXED] (/showthread.php?tid=303718)



Mysql Problem [FIXED] - Tanush123 - 15.12.2011

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...