Making Dynamic Org - Printable Version

Making Dynamic Org - 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: Making Dynamic Org (/showthread.php?tid=307791)

Making Dynamic Org - Tanush123 - 01.01.2012

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;
}

Re: Making Dynamic Org - James Coral - 01.01.2012

lol you have

pawn Код:

enum s

Re: Making Dynamic Org - Tanush123 - 01.01.2012

no i dont

Re: Making Dynamic Org - [HiC]TheKiller - 01.01.2012

pawn Код:

mysql_debug(1);

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

Re: Making Dynamic Org - Tanush123 - 01.01.2012

Код:

[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

Re: Making Dynamic Org - jamesbond007 - 01.01.2012

change No Leader to NULL ?

or u can do 'No leader'

Re: Making Dynamic Org - Tanush123 - 01.01.2012

Quote:

Originally Posted by jamesbond007

change No Leader to NULL ?

or u can do 'No leader'

thank you, iadded ' ', repped