[Shinja]

PHP код:

new query[500];
case factionnamed:
    {
        if(response)
        {
            if(!strlen(inputtext)) return SendClientMessage(playerid, -1, Invalid name);
               mysql_format(mysql,query,sizeof(query), "INSERT INTO `faction` (`factionname`) VALUES ('%e')",inputtext);
             mysql_query(mysql, query);
             mysql_format(mysql,query,sizeof(query), "SELECT ID FROM `faction` WHERE factioname = '%e'",inputtext);
             mysql_query(mysql, query);
               Faction[playerid][ID] = cache_get_field_content_int(0, "ID");
             ShowPlayerDialog(playerid, factiontyped, DIALOG_STYLE_LIST, "FACTION CREATION", "Type 0(Drugs)\nType 1(Weapons)", "Choose","Cancel");
        }
case factiontyped:
    {
         if(response)
           {
             switch(listitem)
               {
                   case 0:
                 {
                      mysql_format(mysql, query,sizeof(query), "UPDATE `faction` SET `factiontype` = '0' WHERE ID = %d LIMIT 1", Faction[playerid][ID]);
                    mysql_query(mysql, query);
                   }
                case 1:
                {
                       mysql_format(mysql, query,sizeof(query), "UPDATE `faction` SET `factiontype` = '1' WHERE ID = %d LIMIT 1", Faction[playerid][ID]);
                       mysql_query(mysql, query);
                  }
             }
          }