[Tanush123]

EDIT: the problem is

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,"Available Org 1-15");
    CheckMySQL();
    format(str,sizeof(str),"SELECT * FROM orgs");
    mysql_query(str);
    mysql_store_result();
    if(mysql_num_rows() == 0)
    {
        mysql_free_result();
        format(str,sizeof(str),"INSERT INTO orgs (Orgid,Name,Genre,Leader,Members,Skin1,Skin2,Skin3) VALUES ('%d','%s','%d',No Leader,0,0,0,0)",orgid,oname,orggenre);
        mysql_query(str);
        format(str,sizeof(str),"You have created created org id %d with genre %d",orgid,orggenre);
        SendClientMessage(playerid,COLOR_YELLOW,str);
        format(str,sizeof(str),"Org Name: %s",oname);
        SendClientMessage(playerid,COLOR_YELLOW,str);
    }
    else
    {
        SendClientMessage(playerid,red,"ERROR: This Organization ID is already used.");
    }
    return 1;
}

[James Coral]

lol you have

pawn Код:

enum s

?

[Tanush123]

no i dont

[[HiC]TheKiller]

pawn Код:

mysql_debug(1);

at the top of your script, then post your mysql log file that is located in your server directory.

[Tanush123]

Код:

[09:05:51] CMySQLHandler::Query(INSERT INTO orgs (Orgid,Name,Genre,Leader,Members,Skin1,Skin2,Skin3) VALUES ('1','k','1',No Leader,0,0,0,0))

Код:

An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Leader,0,0,0,0)' at line 1)

When i used /createorg 1 1 k.

i think the problem is

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,"Available Org 1-15");
    CheckMySQL();
    format(str,sizeof(str),"SELECT * FROM orgs");
    mysql_query(str);
    mysql_store_result();
    if(mysql_num_rows() == 0)
    {
        mysql_free_result();
        format(str,sizeof(str),"INSERT INTO orgs (Orgid,Name,Genre,Leader,Members,Skin1,Skin2,Skin3) VALUES ('%d','%s','%d',No Leader,0,0,0,0)",orgid,oname,orggenre);
        mysql_query(str);
        format(str,sizeof(str),"You have created created org id %d with genre %d",orgid,orggenre);
        SendClientMessage(playerid,COLOR_YELLOW,str);
        format(str,sizeof(str),"Org Name: %s",oname);
        SendClientMessage(playerid,COLOR_YELLOW,str);
    }
    else
    {
        SendClientMessage(playerid,red,"ERROR: This Organization ID is already used.");
    }
    return 1;
}

i just saw it wont INSERT into my mysql database when i use /createorg

[jamesbond007]

change No Leader to NULL ?

or u can do 'No leader'

[Tanush123]

Quote:

Originally Posted by jamesbond007 change No Leader to NULL ? or u can do 'No leader'

thank you, iadded ' ', repped