! - . . , , . , , , (, ) . !



" LEAGUE"
VK: vk.com/sergey68

76890 - 1000,46860 - 500, 300
** V.I.P --> **

: MYSQL

1 5 5

  1. #1

      Lonton

    :
    :04.12.2011
    :58
    :1 [+/-] 

    MYSQL

    , ! MYSQL -, , - :
    PHP :
    MYSQL R39-

    PHP :
    stock LoadBizz()
    {
        
    mysql_function_query(cH"SELECT * FROM `"TABLE_BIZ"`"true"OnLoadBizzCallback""");
        return 
    1;
    }

    forward OnLoadBizzCallback();
    public 
    OnLoadBizzCallback()
    {
        new 
    rowsfieldsifub[64];
        
    cache_get_data(rowsfields);
        for(
    0rowsi++)
        {
            
    cache_get_field_content(i"bID"fub), BizzInfo[i][bID] = strval(fub);
              
    cache_get_field_content(i"bEntranceX"fub), BizzInfo[i][bEntranceX] = floatstr(fub);
              
    cache_get_field_content(i"bEntranceY"fub), BizzInfo[i][bEntranceY] = floatstr(fub);
              
    cache_get_field_content(i"bEntranceZ"fub), BizzInfo[i][bEntranceZ] = floatstr(fub);
              
    cache_get_field_content(i"bExitX"fub), BizzInfo[i][bExitX] = floatstr(fub);
              
    cache_get_field_content(i"bExitY"fub), BizzInfo[i][bExitY] = floatstr(fub);
              
    cache_get_field_content(i"bExitZ"fub), BizzInfo[i][bExitZ] = floatstr(fub);
              
    cache_get_field_content(i"bOwner"fub), strmid(BizzInfo[i][bOwner], fub0strlen(fub), MAX_PLAYER_NAME);
              
    cache_get_field_content(i"bExtortion"fub), strmid(BizzInfo[i][bExtortion], fub0strlen(fub), MAX_PLAYER_NAME);
              
    cache_get_field_content(i"bMessage"fub), strmid(BizzInfo[i][bMessage], fub0strlen(fub), MAX_PLAYER_NAME);
              
    cache_get_field_content(i"bOwned"fub), BizzInfo[i][bOwned] = strlen(fub);
            
    cache_get_field_content(i"bBuyPrice"fub), BizzInfo[i][bBuyPrice] = strval(fub);
            
    cache_get_field_content(i"bEntranceCost"fub), BizzInfo[i][bEntranceCost] = strval(fub);
            
    cache_get_field_content(i"bTill"fub), BizzInfo[i][bTill] = strval(fub);
            
    cache_get_field_content(i"bProducts"fub), BizzInfo[i][bProducts] = strval(fub);
            
    cache_get_field_content(i"bMaxProducts"fub), BizzInfo[i][bMaxProducts] = strval(fub);
            
    cache_get_field_content(i"bPriceProd"fub), BizzInfo[i][bPriceProd] = strval(fub);
            
    cache_get_field_content(i"bLocked"fub), BizzInfo[i][bLocked] = strval(fub);
            
    cache_get_field_content(i"bInterior"fub), BizzInfo[i][bInterior] = strval(fub);
            
    cache_get_field_content(i"bLevelNeeded"fub), BizzInfo[i][bLevelNeeded] = strval(fub);

             new 
    text[600];
            if(
    BizzInfo[i][bOwned] == 0)
            {
                
    format(textsizeof(text),"{FF6347}%s"color_white"\nID: {7CFC00}%d"color_white"\n: {7CFC00}$%d"color_white"\n: {7CFC00}%d\n"color_white": "color_lred"/buybiz"BizzInfo[i][bMessage], iBizzInfo[i][bBuyPrice], BizzInfo[i][bLevelNeeded]);
                
    AddStaticPickup(123923BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ]);
            }
            if(
    BizzInfo[i][bOwned] == 1)
            {
                if(
    BizzInfo[i][bLocked] == 1format(textsizeof(text),"{FF6347}%s"color_lred"\n"color_white"\nID: {7CFC00}%d"color_white"\n: {7CFC00}%s"color_white"\n: {FF6347}%d/%d "color_lblue"\n  1 : {7CFC00}$%d"BizzInfo[i][bMessage], iBizzInfo[i][bOwner], BizzInfo[i][bProducts], BizzInfo[i][bMaxProducts], BizzInfo[i][bPriceProd]);
                else if(
    BizzInfo[i][bLocked] == 0format(textsizeof(text),"{FF6347}%s"color_lblue "\n"color_white"\nID: {7CFC00}%d"color_white"\n: {7CFC00}%s"color_white"\n: {FF6347}%d/%d "color_lblue"\n  1 : {7CFC00}$%d"color_white"\n  : {7CFC00}$%d"color_white"\n: "color_lred"/enter"BizzInfo[i][bMessage], iBizzInfo[i][bOwner], BizzInfo[i][bProducts], BizzInfo[i][bMaxProducts], BizzInfo[i][bPriceProd], BizzInfo[i][bEntranceCost]);
                
    AddStaticPickup(123923BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ]);
            }
            
    BizzInfo[i][bText] = Create3DTextLabel(text, -1BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ]+120.001);
            
    BizzInfo[i][bIcon] = CreateDynamicMapIcon(BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ], 56, -10, -1, -1400.0);
        }
        
    printf("~   - %i."i);
        return 
    1;
    }
    stock UpdateBizz(i)
    {
        new 
    text[600];
        
    DestroyPickup(BizzInfo[i][bPickup]);
        if(
    BizzInfo[i][bOwned] == 0)
        {
         
    format(textsizeof(text),"{FF6347}%s"color_white"\nID: {7CFC00}%d"color_white"\n: {7CFC00}$%d"color_white"\n: {7CFC00}%d\n"color_white": "color_lred"/buybiz"BizzInfo[i][bMessage], iBizzInfo[i][bBuyPrice], BizzInfo[i][bLevelNeeded]);
        
    BizzInfo[i][bPickup] = CreatePickup(123923BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ]);
        }
        if(
    BizzInfo[i][bOwned] == 1)
        {
        if(
    BizzInfo[i][bLocked] == 1format(textsizeof(text),"{FF6347}%s"color_lred"\n"color_white"\nID: {7CFC00}%d"color_white"\n: {7CFC00}%s"color_white"\n: {FF6347}%d/%d "color_lblue"\n  1 : {7CFC00}$%d"BizzInfo[i][bMessage], iBizzInfo[i][bOwner], BizzInfo[i][bProducts], BizzInfo[i][bMaxProducts], BizzInfo[i][bPriceProd]);
        else if(
    BizzInfo[i][bLocked] == 0format(textsizeof(text),"{FF6347}%s"color_lblue "\n"color_white"\nID: {7CFC00}%d"color_white"\n: {7CFC00}%s"color_white"\n: {FF6347}%d/%d "color_lblue"\n  1 : {7CFC00}$%d"color_white"\n  : {7CFC00}$%d"color_white"\n: "color_lred"/enter"BizzInfo[i][bMessage], iBizzInfo[i][bOwner], BizzInfo[i][bProducts], BizzInfo[i][bMaxProducts], BizzInfo[i][bPriceProd], BizzInfo[i][bEntranceCost]);
        
    BizzInfo[i][bPickup] = CreatePickup(123923BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ]);
        }
        
    Update3DTextLabelText(BizzInfo[i][bText], -1text);
    }

    stock SaveBizz(idbiz)
    {
        if(
    idbiz == -1) for(idbiz 0idbiz sizeof(BizzInfo); idbiz++) SaveBizz(idbiz);
        else
        {
            new 
    fub[500];
            
    format(fubsizeof(fub),"UPDATE `"TABLE_BIZ"` SET `bEntranceX` = '%f', `bEntranceY` = '%f', `bEntranceZ` = '%f', `bExitX` = '%f', `bExitY` = '%f', `bExitZ` = '%f',\
            `bOwner` = '%s', `bExtortion` = '%s', `bMessage` = '%s', `bOwned` = '%d',\
            `bBuyPrice` = '%d', `bEntranceCost` = '%d', `bTill` = '%d', `bProducts` = '%d', `bMaxProducts` = '%d', `bPriceProd` = '%d', `bLocked` = '%d', `bInterior` = '%d', `bLevelNeeded` = '%d' WHERE `ID` = '%d'"
    ,
            
    BizzInfo[idbiz][bEntranceX], BizzInfo[idbiz][bEntranceY], BizzInfo[idbiz][bEntranceZ], BizzInfo[idbiz][bExitX],
            
    BizzInfo[idbiz][bExitY], BizzInfo[idbiz][bExitZ], BizzInfo[idbiz][bOwner], BizzInfo[idbiz][bExtortion], BizzInfo[idbiz][bMessage], BizzInfo[idbiz][bOwned],
            
    BizzInfo[idbiz][bBuyPrice], BizzInfo[idbiz][bEntranceCost], BizzInfo[idbiz][bTill], BizzInfo[idbiz][bProducts], BizzInfo[idbiz][bMaxProducts], BizzInfo[idbiz][bPriceProd], BizzInfo[idbiz][bLocked], BizzInfo[idbiz][bInterior], BizzInfo[idbiz][bLevelNeeded], idbiz);
            
    mysql_tquery(cHfub"""");
        }
        return 
    1;

    []


    , . , 3 , .... , , , , , (.
    - , , :

    :
    [23:07:17] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'ID' in 'where clause'
    [23:07:26] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'ID' in 'where clause'
    [23:07:28] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'ID' in 'where clause'
    [23:07:28] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'ID' in 'where clause'
    [23:07:47] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'ID' in 'where clause'
    [23:07:52] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'ID' in 'where clause'
    [23:07:59] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'ID' in 'where clause'
    [23:10:10] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'ID' in 'where clause'
    [23:10:23] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'ID' in 'where clause'
    [23:10:27] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'ID' in 'where clause'
    []


    , , - , 3
    PHP :
    if(BizzInfo[i][bOwned] == 1
    , ...

    , - /asellbiz:

    PHP :
        else if(strcmp(cmd"/asellbiz"true) == 0)
        {
            new 
    i;
            if(
    PlayerInfo[playerid][pAdmin] < 8) return send(playeridcol_grad1"*      .");
            if(
    sscanf(params"d"params[0])) return send(playeridcol_grad1": /asellbiz [bizid]");
            if(
    params[0] > sizeof(BizzInfo)) return send(playeridcol_grey"*  ID !");
            
    BizzInfo[params[0]][bLocked] = 1;
            
    BizzInfo[params[0]][bOwned] = 0;
            
    strmid(BizzInfo[params[0]][bOwner], "The State"0strlen("The State"), 255);
            
    strmid(BizzInfo[params[0]][bExtortion], ""0strlen(""), 255);
            
    PlayerPlaySound(playerid10520.00.00.0);
            
    format(stringsizeof(string), "~w~You have sold the Business");
            
    GameTextForPlayer(playeridstring100003);
            
    SaveBizz(i);
            return 
    1;
        } 
    // ,   ZCMD    .... 


    , .
  2. #2

      H-U-N-T-E-R

    :
    :22.08.2016
    :582
    :60 [+/-] 
    .
    .
    stock*SaveBizz(idbiz) ( ) `ID` `bID`
  3. #3

      Lonton

    :
    :04.12.2011
    :58
    :1 [+/-] 
    ! 3D Text ?
  4. #4

      H-U-N-T-E-R

    :
    :22.08.2016
    :582
    :60 [+/-] 
    ?
  5. #5

      Lonton

    :
    :04.12.2011
    :58
    :1 [+/-] 
    bOwned = 0, , 0, -, bOwned=1, -. , 1

    ==== .

    ---------- 17:39 ---------- 16:02 ----------

    PHP :
    ... // CLOSED 
    Lonton; 08.02.2017 14:38.

, : 0

.

-----, /color, , , , closed, color, , , , , , mysql, , ., , , , , , , , php, silver, size, zcmd, ,

(, , , , , ), , .
!
samp-rp advanvce pawn s0beit cs 1.6 0.3x World of Tanks samp-rp, samp-rp, - PAWNO SA-MP IV-MP MTA cleo s0beit sobeit sa-mp sa-mp pawno pawno pawno iv-mp iv-mp iv-mp godfather SAMP gta 4 4 GTA 4 GTA 4 GTA 4 SAMP SAMP Pen1 LS Pen1 Fugitive The Godfather rp roleplay samp-rp sa-mp sa-mp pawno gta-iv gta-v gta-sa gta-3 gta-III gta-4 gta-5 gta-vc mta mta-dm mta-race mta-sa pawno info ru pawno pawno gta-iv gta-iv gta-v gta-v gta-iv keygen gta sa gta 4 multiplayer gta san adnreas multiplayer sa-mp forum sa-mp pawno sa-mp pawno sa-mp gta-sa pawno pawno errors sa-mp 0.3c SA-MP 0.3d 4 GTA 4 GTA 4 GTA 4 SAMP SAMP Pen1 LS Pen1 Fugitive The Godfather SAMP hack rat android instagram twitter ddos root linux ubuntu mac android advance arizona 4g