Добро пожаловать на Pro Pawn - Портал о PAWN-скриптинге.
Показано с 1 по 3 из 3
  1. #1
    Аватар для Kovshevoy
    Пользователь

    Статус
    Оффлайн
    Регистрация
    11.07.2015
    Сообщений
    190
    Репутация:
    25 ±

    Ошибка загрузки из базы (MySQL r39-6)

    Здравствуйте, у меня проблема с загрузкой MySQL r39-6. Конкретно вот, что происходит. Я покупаю бизнес на сервере, и после рестарта сервера, написано что бизнес продается, а у игрока этот бизнес в таблице записан. Он может использовать команду для управления бизнеса, но в информации к бизнесу, он не записан как владелец. Обновление бизнеса проходит нормально, с запросом проблем нет.

    Вот код который сейчас - MySQL r39-6
    PHP код:
    public OnLoadBiz()
    {
        new 
    Cache:result mysql_query(mysql_connection_ID"SELECT * FROM `pizza`"),
        
    rows cache_get_row_count();

        if(
    rows)
        {
            for(new 
    irowsi++)
            {
                
    cache_get_field_content(i"vlad"PizzaInfo[i][vlad], mysql_connection_ID32);
                
    PizzaInfo[i][obpribylbiz] = cache_get_field_content_int(i"obpribylbiz");
                
    PizzaInfo[i][cena1] = cache_get_field_content_int(i"cena1");
                
    PizzaInfo[i][cena2] = cache_get_field_content_int(i"cena2");
                
    PizzaInfo[i][cena3] = cache_get_field_content_int(i"cena3");
                
    PizzaInfo[i][cena4] = cache_get_field_content_int(i"cena4");
                
    PizzaInfo[i][vsyapribyl] = cache_get_field_content_int(i"vsyapribyl");
                
    PizzaInfo[i][bizdolg] = cache_get_field_content_int(i"bizdolg");
                
    PizzaInfo[i][open] = cache_get_field_content_int(i"open");
                
    PizzaInfo[i][testo] = cache_get_field_content_int(i"testo");
                
    PizzaInfo[i][ovoshi] = cache_get_field_content_int(i"ovoshi");
                
    PizzaInfo[i][cheese] = cache_get_field_content_int(i"cheese");
                
    PizzaInfo[i][sal] = cache_get_field_content_int(i"sal");
                
    PizzaInfo[i][karto] = cache_get_field_content_int(i"karto");
                
    PizzaInfo[i][limonad] = cache_get_field_content_int(i"limonad");
                
    PizzaInfo[i][farsh] = cache_get_field_content_int(i"farsh");
                
    PizzaInfo[i][buy] = cache_get_field_content_int(i"buy");
            }
        }
        
    cache_delete(result);


        
    result mysql_query(mysql_connection_ID"SELECT * FROM `ponchiki`");
        
    rows cache_get_row_count();

        if(
    rows)
        {
            for(new 
    irowsi++)
            {
                
    PonchikiInfo[i][oobpribylbiz] = cache_get_field_content_int(i"oobpribylbiz");
                
    cache_get_field_content(i"ovlad"PonchikiInfo[i][ovlad], mysql_connection_ID32);
                
    PonchikiInfo[i][ocena1] = cache_get_field_content_int(i"ocena1");
                
    PonchikiInfo[i][ocena2] = cache_get_field_content_int(i"ocena2");
                
    PonchikiInfo[i][ocena3] = cache_get_field_content_int(i"ocena3");
                
    PonchikiInfo[i][ovsyapribyl] = cache_get_field_content_int(i"ovsyapribyl");
                
    PonchikiInfo[i][obizdolg] = cache_get_field_content_int(i"obizdolg");
                
    PonchikiInfo[i][oopen] = cache_get_field_content_int(i"oopen");
                
    PonchikiInfo[i][ocofe] = cache_get_field_content_int(i"ocofe");
                
    PonchikiInfo[i][omuka] = cache_get_field_content_int(i"omuka");
                
    PonchikiInfo[i][osugar] = cache_get_field_content_int(i"osugar");
                
    PonchikiInfo[i][oglazur] = cache_get_field_content_int(i"oglazur");
                
    PonchikiInfo[i][obuy] = cache_get_field_content_int(i"obuy");
            }
        }
        
    cache_delete(result);



        
    result mysql_query(mysql_connection_ID"SELECT * FROM `chiken`");
        
    rows cache_get_row_count();

        if(
    rows)
        {
            for(new 
    irowsi++)
            {
                
    cache_get_field_content(i"cvlad"ChikenInfo[i][cvlad], mysql_connection_ID32);
                
    ChikenInfo[i][cobpribylbiz] = cache_get_field_content_int(i"cobpribylbiz");
                
    ChikenInfo[i][ccena1] = cache_get_field_content_int(i"ccena1");
                
    ChikenInfo[i][ccena2] = cache_get_field_content_int(i"ccena2");
                
    ChikenInfo[i][ccena3] = cache_get_field_content_int(i"ccena3");
                
    ChikenInfo[i][cvsyapribyl] = cache_get_field_content_int(i"cvsyapribyl");
                
    ChikenInfo[i][cbizdolg] = cache_get_field_content_int(i"cbizdolg");
                
    ChikenInfo[i][copen] = cache_get_field_content_int(i"copen");
                
    ChikenInfo[i][cmoroz] = cache_get_field_content_int(i"cmoroz");
                
    ChikenInfo[i][climonad] = cache_get_field_content_int(i"climonad");
                
    ChikenInfo[i][csalat] = cache_get_field_content_int(i"csalat");
                
    ChikenInfo[i][csal] = cache_get_field_content_int(i"csal");
                
    ChikenInfo[i][cchiken] = cache_get_field_content_int(i"cchiken");
                
    ChikenInfo[i][ckarto] = cache_get_field_content_int(i"ckarto");
                
    ChikenInfo[i][covoshi] = cache_get_field_content_int(i"covoshi");
                
    ChikenInfo[i][cbulka] = cache_get_field_content_int(i"cbulka");
                
    ChikenInfo[i][cbuy] = cache_get_field_content_int(i"cbuy");
            }
        }
        
    cache_delete(result);


        
    result mysql_query(mysql_connection_ID"SELECT * FROM `burger`");
        
    rows cache_get_row_count();

        if(
    rows)
        {
            for(new 
    irowsi++)
            {
                
    cache_get_field_content(i"bvlad"BurgerInfo[i][bvlad], mysql_connection_ID32);
                
    BurgerInfo[i][bobpribylbiz] = cache_get_field_content_int(i"bobpribylbiz");
                
    BurgerInfo[i][bcena1] = cache_get_field_content_int(i"bcena1");
                
    BurgerInfo[i][bcena2] = cache_get_field_content_int(i"bcena2");
                
    BurgerInfo[i][bcena3] = cache_get_field_content_int(i"bcena3");
                
    BurgerInfo[i][bvsyapribyl] = cache_get_field_content_int(i"bvsyapribyl");
                
    BurgerInfo[i][bbizdolg] = cache_get_field_content_int(i"bbizdolg");
                
    BurgerInfo[i][bopen] = cache_get_field_content_int(i"bopen");
                
    BurgerInfo[i][bmoroz] = cache_get_field_content_int(i"bmoroz");
                
    BurgerInfo[i][blimonad] = cache_get_field_content_int(i"blimonad");
                
    BurgerInfo[i][bkarto] = cache_get_field_content_int(i"bkarto");
                
    BurgerInfo[i][bfarsh] = cache_get_field_content_int(i"bfarsh");
                
    BurgerInfo[i][bovoshi] = cache_get_field_content_int(i"bovoshi");
                
    BurgerInfo[i][bbulka] = cache_get_field_content_int(i"bbulka");
                
    BurgerInfo[i][bbuy] = cache_get_field_content_int(i"bbuy");
            }
        }
        
    cache_delete(result);



        
    result mysql_query(mysql_connection_ID"SELECT * FROM `azs`");
        
    rows cache_get_row_count();

        if(
    rows)
        {
            for(new 
    1rowsi++)
            {
                
    cache_get_field_content(i"avlad"AzsInfo[i][avlad], mysql_connection_ID32);
                
    AzsInfo[i][aobpribylbiz] = cache_get_field_content_int(i"aobpribylbiz");
                
    AzsInfo[i][acena1] = cache_get_field_content_int(i"acena1");
                
    AzsInfo[i][acena2] = cache_get_field_content_int(i"acena2");
                
    AzsInfo[i][avsyapribyl] = cache_get_field_content_int(i"avsyapribyl");
                
    AzsInfo[i][aopen] = cache_get_field_content_int(i"aopen");
                
    AzsInfo[i][abenz] = cache_get_field_content_int(i"abenz");
                
    AzsInfo[i][azapt] = cache_get_field_content_int(i"azapt");
                
    AzsInfo[i][abuy] = cache_get_field_content_int(i"abuy");
                
    AzsInfo[i][abizdolg] = cache_get_field_content_int(i"abizdolg");
                
    AzsInfo[i][atow] = cache_get_field_content_int(i"atow");
            }
        }
        
    cache_delete(result);


        
    result mysql_query(mysql_connection_ID"SELECT * FROM `avtosalon`");
        
    rows cache_get_row_count();

        if(
    rows)
        {
            for(new 
    irowsi++)
            {
                
    cache_get_field_content(i"vvlad"AvtosalonInfo[i][vvlad], mysql_connection_ID32);
                
    AvtosalonInfo[i][vbuy] = cache_get_field_content_int(i"vbuy");
                
    AvtosalonInfo[i][vbizdolg] = cache_get_field_content_int(i"vbizdolg");
                
    AvtosalonInfo[i][vvsyapribyl] = cache_get_field_content_int(i"vvsyapribyl");
                
    AvtosalonInfo[i][vobpribylbiz] = cache_get_field_content_int(i"vobpribylbiz");
                
    AvtosalonInfo[i][vmargin1] = cache_get_field_content_int(i"margin1");
                
    AvtosalonInfo[i][vmargin2] = cache_get_field_content_int(i"margin2");
                
    AvtosalonInfo[i][vmargin3] = cache_get_field_content_int(i"margin3");
                
    AvtosalonInfo[i][vmargin4] = cache_get_field_content_int(i"margin4");
                
    AvtosalonInfo[i][vmargin5] = cache_get_field_content_int(i"margin5");
                
    AvtosalonInfo[i][vmargin6] = cache_get_field_content_int(i"margin6");
                
    AvtosalonInfo[i][vmargin7] = cache_get_field_content_int(i"margin7");
                
    AvtosalonInfo[i][vmargin8] = cache_get_field_content_int(i"margin8");
                
    AvtosalonInfo[i][vmargin9] = cache_get_field_content_int(i"margin9");
                
    AvtosalonInfo[i][vmargin10] = cache_get_field_content_int(i"margin10");
                
    AvtosalonInfo[i][vmargin11] = cache_get_field_content_int(i"margin11");
                
    AvtosalonInfo[i][vmargin12] = cache_get_field_content_int(i"margin12");
                
    AvtosalonInfo[i][vmargin13] = cache_get_field_content_int(i"margin13");
                
    AvtosalonInfo[i][vmargin14] = cache_get_field_content_int(i"margin14");
                
    AvtosalonInfo[i][vmargin15] = cache_get_field_content_int(i"margin15");
                
    AvtosalonInfo[i][vcar1] = cache_get_field_content_int(i"car1");
                
    AvtosalonInfo[i][vcar2] = cache_get_field_content_int(i"car2");
                
    AvtosalonInfo[i][vcar3] = cache_get_field_content_int(i"car3");
                
    AvtosalonInfo[i][vcar4] = cache_get_field_content_int(i"car4");
                
    AvtosalonInfo[i][vcar5] = cache_get_field_content_int(i"car5");
                
    AvtosalonInfo[i][vcar6] = cache_get_field_content_int(i"car6");
                
    AvtosalonInfo[i][vcar7] = cache_get_field_content_int(i"car7");
                
    AvtosalonInfo[i][vcar8] = cache_get_field_content_int(i"car8");
                
    AvtosalonInfo[i][vcar9] = cache_get_field_content_int(i"car9");
                
    AvtosalonInfo[i][vcar10] = cache_get_field_content_int(i"car10");
                
    AvtosalonInfo[i][vcar11] = cache_get_field_content_int(i"car11");
                
    AvtosalonInfo[i][vcar12] = cache_get_field_content_int(i"car12");
                
    AvtosalonInfo[i][vcar13] = cache_get_field_content_int(i"car13");
                
    AvtosalonInfo[i][vcar14] = cache_get_field_content_int(i"car14");
                
    AvtosalonInfo[i][vcar15] = cache_get_field_content_int(i"car15");
            }
        }
        
    cache_delete(result);



        
    result mysql_query(mysql_connection_ID"SELECT * FROM `magazin`");
        
    rows cache_get_row_count();

        if(
    rows)
        {
            for(new 
    irowsi++)
            {
                
    cache_get_field_content(i"mvlad"MagazinInfo[i][mvlad], mysql_connection_ID32);
                
    MagazinInfo[i][mobpribylbiz] = cache_get_field_content_int(i"mobpribylbiz");
                
    MagazinInfo[i][mcena1] = cache_get_field_content_int(i"mcena1");
                
    MagazinInfo[i][mcena2] = cache_get_field_content_int(i"mcena2");
                
    MagazinInfo[i][mcena3] = cache_get_field_content_int(i"mcena3");
                
    MagazinInfo[i][mcena4] = cache_get_field_content_int(i"mcena4");
                
    MagazinInfo[i][mcena5] = cache_get_field_content_int(i"mcena5");
                
    MagazinInfo[i][mcena6] = cache_get_field_content_int(i"mcena6");
                
    MagazinInfo[i][mcena7] = cache_get_field_content_int(i"mcena7");
                
    MagazinInfo[i][mcena8] = cache_get_field_content_int(i"mcena8");
                
    MagazinInfo[i][mcena9] = cache_get_field_content_int(i"mcena9");
                
    MagazinInfo[i][mcena10] = cache_get_field_content_int(i"mcena10");
                
    MagazinInfo[i][mcena11] = cache_get_field_content_int(i"mcena11");
                
    MagazinInfo[i][mcena12] = cache_get_field_content_int(i"mcena12");
                
    MagazinInfo[i][mcena13] = cache_get_field_content_int(i"mcena13");
                
    MagazinInfo[i][mcena14] = cache_get_field_content_int(i"mcena14");
                
    MagazinInfo[i][mcena15] = cache_get_field_content_int(i"mcena15");
                
    MagazinInfo[i][mcena16] = cache_get_field_content_int(i"mcena16");
                
    MagazinInfo[i][mcena17] = cache_get_field_content_int(i"cena17");
                
    MagazinInfo[i][mcena18] = cache_get_field_content_int(i"cena18");
                
    MagazinInfo[i][mcena19] = cache_get_field_content_int(i"cena19");
                
    MagazinInfo[i][mcena20] = cache_get_field_content_int(i"cena20");
                
    MagazinInfo[i][mvsyapribyl] = cache_get_field_content_int(i"mvsyapribyl");
                
    MagazinInfo[i][mbizdolg] = cache_get_field_content_int(i"mbizdolg");
                
    MagazinInfo[i][mopen] = cache_get_field_content_int(i"mopen");
                
    MagazinInfo[i][mphone] = cache_get_field_content_int(i"mphone");
                
    MagazinInfo[i][mcamera] = cache_get_field_content_int(i"mcamera");
                
    MagazinInfo[i][mclock] = cache_get_field_content_int(i"mclock");
                
    MagazinInfo[i][mkanistra] = cache_get_field_content_int(i"mkanistra");
                
    MagazinInfo[i][mheal] = cache_get_field_content_int(i"mheal");
                
    MagazinInfo[i][mtrost] = cache_get_field_content_int(i"mtrost");
                
    MagazinInfo[i][mflower] = cache_get_field_content_int(i"mflower");
                
    MagazinInfo[i][mparash] = cache_get_field_content_int(i"mparash");
                
    MagazinInfo[i][mshlem] = cache_get_field_content_int(i"mshlem");
                
    MagazinInfo[i][mid] = cache_get_field_content_int(i"mid");
                
    MagazinInfo[i][mnumber] = cache_get_field_content_int(i"mnumber");
                
    MagazinInfo[i][mdir] = cache_get_field_content_int(i"mdir");
                
    MagazinInfo[i][mbita] = cache_get_field_content_int(i"mbita");
                
    MagazinInfo[i][mlopata] = cache_get_field_content_int(i"mlopata");
                
    MagazinInfo[i][mkl] = cache_get_field_content_int(i"mkl");
                
    MagazinInfo[i][mkatana] = cache_get_field_content_int(i"mkatana");
                
    MagazinInfo[i][mback] = cache_get_field_content_int(i"back");
                
    MagazinInfo[i][mmask] = cache_get_field_content_int(i"mask");
                
    MagazinInfo[i][mradio] = cache_get_field_content_int(i"radio");
                
    MagazinInfo[i][mot] = cache_get_field_content_int(i"ot");
                
    MagazinInfo[i][mbuy] = cache_get_field_content_int(i"mbuy");
            }
        }
        
    cache_delete(result);





        
    result mysql_query(mysql_connection_ID"SELECT * FROM `relax`");
        
    rows cache_get_row_count();

        if(
    rows)
        {
            for(new 
    irowsi++)
            {
                
    cache_get_field_content(i"rvlad"RelaxInfo[i][rvlad], mysql_connection_ID32);
                
    RelaxInfo[i][robpribylbiz] = cache_get_field_content_int(i"robpribylbiz");
                
    RelaxInfo[i][rcena1] = cache_get_field_content_int(i"rcena1");
                
    RelaxInfo[i][rcena2] = cache_get_field_content_int(i"rcena2");
                
    RelaxInfo[i][rcena3] = cache_get_field_content_int(i"rcena3");
                
    RelaxInfo[i][rcena4] = cache_get_field_content_int(i"rcena4");
                
    RelaxInfo[i][rcena5] = cache_get_field_content_int(i"rcena5");
                
    RelaxInfo[i][rcena6] = cache_get_field_content_int(i"rcena6");
                
    RelaxInfo[i][rvsyapribyl] = cache_get_field_content_int(i"rvsyapribyl");
                
    RelaxInfo[i][rbizdolg] = cache_get_field_content_int(i"rbizdolg");
                
    RelaxInfo[i][ropen] = cache_get_field_content_int(i"ropen");
                
    RelaxInfo[i][rcola] = cache_get_field_content_int(i"rcola");
                
    RelaxInfo[i][rbeer] = cache_get_field_content_int(i"rbeer");
                
    RelaxInfo[i][rvodka] = cache_get_field_content_int(i"rvodka");
                
    RelaxInfo[i][rvino] = cache_get_field_content_int(i"rvino");
                
    RelaxInfo[i][rkonyak] = cache_get_field_content_int(i"rkonyak");
                
    RelaxInfo[i][rled] = cache_get_field_content_int(i"rled");
                
    RelaxInfo[i][rbuy] = cache_get_field_content_int(i"rbuy");
            }
        }
        
    cache_delete(result);
        return 
    true;

    Вот код который был раньше - MySQL r5

    PHP код:
    public OnLoadBiz()
    {
        new 
    sql1[200];
        new 
    Field[64];
        for(new 
    0sizeof(PizzaInfo); i++)
        {
            
    format(sql1200"SELECT * FROM `pizza` WHERE `ID` = '%d'",i);
            
    mysql_query(sql1); mysql_store_result();
            
    mysql_fetch_row(sql1);
            
    mysql_fetch_field_row(PizzaInfo[i][vlad], "vlad");
            
    mysql_fetch_field_row(Field"nomerbiz"); PizzaInfo[i][nomerbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"obpribylbiz"); PizzaInfo[i][obpribylbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"cena1"); PizzaInfo[i][cena1] = strval(Field);
            
    mysql_fetch_field_row(Field"cena2"); PizzaInfo[i][cena2] = strval(Field);
            
    mysql_fetch_field_row(Field"cena3"); PizzaInfo[i][cena3] = strval(Field);
            
    mysql_fetch_field_row(Field"cena4"); PizzaInfo[i][cena4] = strval(Field);
            
    mysql_fetch_field_row(Field"vsyapribyl"); PizzaInfo[i][vsyapribyl] = strval(Field);
            
    mysql_fetch_field_row(Field"bizdolg"); PizzaInfo[i][bizdolg] = strval(Field);
            
    mysql_fetch_field_row(Field"open"); PizzaInfo[i][open] = strval(Field);
            
    mysql_fetch_field_row(Field"testo"); PizzaInfo[i][testo] = strval(Field);
            
    mysql_fetch_field_row(Field"ovoshi"); PizzaInfo[i][ovoshi] = strval(Field);
            
    mysql_fetch_field_row(Field"cheese"); PizzaInfo[i][cheese] = strval(Field);
            
    mysql_fetch_field_row(Field"sal"); PizzaInfo[i][sal] = strval(Field);
            
    mysql_fetch_field_row(Field"karto"); PizzaInfo[i][karto] = strval(Field);
            
    mysql_fetch_field_row(Field"limonad"); PizzaInfo[i][limonad] = strval(Field);
            
    mysql_fetch_field_row(Field"farsh"); PizzaInfo[i][farsh] = strval(Field);
            
    mysql_fetch_field_row(Field"buy"); PizzaInfo[i][buy] = strval(Field);
        }
        
    mysql_free_result();
        new 
    sql4[200];
        for(new 
    0sizeof(PonchikiInfo); l++)
        {
            
    format(sql4200"SELECT * FROM `ponchiki` WHERE `ID` = '%d'",l);
            
    mysql_query(sql4); mysql_store_result();
            
    mysql_fetch_row(sql4);
            
    mysql_fetch_field_row(Field"onomerbiz"); PonchikiInfo[l][onomerbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"oobpribylbiz"); PonchikiInfo[l][oobpribylbiz] = strval(Field);
            
    mysql_fetch_field_row(PonchikiInfo[l][ovlad], "ovlad");
            
    mysql_fetch_field_row(Field"ocena1"); PonchikiInfo[l][ocena1] = strval(Field);
            
    mysql_fetch_field_row(Field"ocena2"); PonchikiInfo[l][ocena2] = strval(Field);
            
    mysql_fetch_field_row(Field"ocena3"); PonchikiInfo[l][ocena3] = strval(Field);
            
    mysql_fetch_field_row(Field"ovsyapribyl"); PonchikiInfo[l][ovsyapribyl] = strval(Field);
            
    mysql_fetch_field_row(Field"obizdolg"); PonchikiInfo[l][obizdolg] = strval(Field);
            
    mysql_fetch_field_row(Field"oopen"); PonchikiInfo[l][oopen] = strval(Field);
            
    mysql_fetch_field_row(Field"ocofe"); PonchikiInfo[l][ocofe] = strval(Field);
            
    mysql_fetch_field_row(Field"omuka"); PonchikiInfo[l][omuka] = strval(Field);
            
    mysql_fetch_field_row(Field"osugar"); PonchikiInfo[l][osugar] = strval(Field);
            
    mysql_fetch_field_row(Field"oglazur"); PonchikiInfo[l][oglazur] = strval(Field);
            
    mysql_fetch_field_row(Field"obuy"); PonchikiInfo[l][obuy] = strval(Field);
            
    mysql_free_result();
        }
        new 
    sql2[200];
        for(new 
    0sizeof(ChikenInfo); h++)
        {
            
    format(sql2200"SELECT * FROM `chiken` WHERE `ID` = '%d'",h);
            
    mysql_query(sql2); mysql_store_result();
            
    mysql_fetch_row(sql2);
            
    mysql_fetch_field_row(ChikenInfo[h][cvlad], "cvlad");
            
    mysql_fetch_field_row(Field"cnomerbiz"); ChikenInfo[h][cnomerbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"cobpribylbiz"); ChikenInfo[h][cobpribylbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"ccena1"); ChikenInfo[h][ccena1] = strval(Field);
            
    mysql_fetch_field_row(Field"ccena2"); ChikenInfo[h][ccena2] = strval(Field);
            
    mysql_fetch_field_row(Field"ccena3"); ChikenInfo[h][ccena3] = strval(Field);
            
    mysql_fetch_field_row(Field"cvsyapribyl"); ChikenInfo[h][cvsyapribyl] = strval(Field);
            
    mysql_fetch_field_row(Field"cbizdolg"); ChikenInfo[h][cbizdolg] = strval(Field);
            
    mysql_fetch_field_row(Field"copen"); ChikenInfo[h][copen] = strval(Field);
            
    mysql_fetch_field_row(Field"cmoroz"); ChikenInfo[h][cmoroz] = strval(Field);
            
    mysql_fetch_field_row(Field"climonad"); ChikenInfo[h][climonad] = strval(Field);
            
    mysql_fetch_field_row(Field"csalat"); ChikenInfo[h][csalat] = strval(Field);
            
    mysql_fetch_field_row(Field"csal"); ChikenInfo[h][csal] = strval(Field);
            
    mysql_fetch_field_row(Field"cchiken"); ChikenInfo[h][cchiken] = strval(Field);
            
    mysql_fetch_field_row(Field"ckarto"); ChikenInfo[h][ckarto] = strval(Field);
            
    mysql_fetch_field_row(Field"covoshi"); ChikenInfo[h][covoshi] = strval(Field);
            
    mysql_fetch_field_row(Field"cbulka"); ChikenInfo[h][cbulka] = strval(Field);
            
    mysql_fetch_field_row(Field"cbuy"); ChikenInfo[h][cbuy] = strval(Field);
            
    mysql_free_result();
        }
        new 
    sql3[200];
        for(new 
    0sizeof(BurgerInfo); b++)
        {
            
    format(sql3200"SELECT * FROM `burger` WHERE `ID` = '%d'",b);
            
    mysql_query(sql3); mysql_store_result();
            
    mysql_fetch_row(sql3);
            
    mysql_fetch_field_row(BurgerInfo[b][bvlad], "bvlad");
            
    mysql_fetch_field_row(Field"bnomerbiz"); BurgerInfo[b][bnomerbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"bobpribylbiz"); BurgerInfo[b][bobpribylbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"bcena1"); BurgerInfo[b][bcena1] = strval(Field);
            
    mysql_fetch_field_row(Field"bcena2"); BurgerInfo[b][bcena2] = strval(Field);
            
    mysql_fetch_field_row(Field"bcena3"); BurgerInfo[b][bcena3] = strval(Field);
            
    mysql_fetch_field_row(Field"bvsyapribyl"); BurgerInfo[b][bvsyapribyl] = strval(Field);
            
    mysql_fetch_field_row(Field"bbizdolg"); BurgerInfo[b][bbizdolg] = strval(Field);
            
    mysql_fetch_field_row(Field"bopen"); BurgerInfo[b][bopen] = strval(Field);
            
    mysql_fetch_field_row(Field"bmoroz"); BurgerInfo[b][bmoroz] = strval(Field);
            
    mysql_fetch_field_row(Field"blimonad"); BurgerInfo[b][blimonad] = strval(Field);
            
    mysql_fetch_field_row(Field"bkarto"); BurgerInfo[b][bkarto] = strval(Field);
            
    mysql_fetch_field_row(Field"bfarsh"); BurgerInfo[b][bfarsh] = strval(Field);
            
    mysql_fetch_field_row(Field"bovoshi"); BurgerInfo[b][bovoshi] = strval(Field);
            
    mysql_fetch_field_row(Field"bbulka"); BurgerInfo[b][bbulka] = strval(Field);
            
    mysql_fetch_field_row(Field"bbuy"); BurgerInfo[b][bbuy] = strval(Field);
            
    mysql_free_result();
        }
        new 
    sql5[1024];
        for(new 
    0sizeof(AzsInfo); z++)
        {
            
    format(sql51024"SELECT * FROM `azs` WHERE `ID` = '%d'",z);
            
    mysql_query(sql5); mysql_store_result();
            
    mysql_fetch_row(sql5);
            
    mysql_fetch_field_row(AzsInfo[z][avlad], "avlad");
            
    mysql_fetch_field_row(Field"anomerbiz"); AzsInfo[z][anomerbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"aobpribylbiz"); AzsInfo[z][aobpribylbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"acena1"); AzsInfo[z][acena1] = strval(Field);
            
    mysql_fetch_field_row(Field"acena2"); AzsInfo[z][acena2] = strval(Field);
            
    mysql_fetch_field_row(Field"avsyapribyl"); AzsInfo[z][avsyapribyl] = strval(Field);
            
    mysql_fetch_field_row(Field"aopen"); AzsInfo[z][aopen] = strval(Field);
            
    mysql_fetch_field_row(Field"abenz"); AzsInfo[z][abenz] = strval(Field);
            
    mysql_fetch_field_row(Field"azapt"); AzsInfo[z][azapt] = strval(Field);
            
    mysql_fetch_field_row(Field"abuy"); AzsInfo[z][abuy] = strval(Field);
            
    mysql_fetch_field_row(Field"abizdolg"); AzsInfo[z][abizdolg] = strval(Field);
            
    mysql_fetch_field_row(Field"atow"); AzsInfo[z][atow] = strval(Field);
            
    mysql_free_result();
        }
        for(new 
    0sizeof(AvtosalonInfo); z++)
        {
            
    format(sql51024"SELECT * FROM `avtosalon` WHERE `ID` = '%d'",z);
            
    mysql_query(sql5); mysql_store_result();
            
    mysql_fetch_row(sql5);
            
    mysql_fetch_field_row(AvtosalonInfo[z][vvlad], "vvlad");
            
    mysql_fetch_field_row(Field"vnomerbiz"); AvtosalonInfo[z][vnomerbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"vbuy"); AvtosalonInfo[z][vbuy] = strval(Field);
            
    mysql_fetch_field_row(Field"vbizdolg"); AvtosalonInfo[z][vbizdolg] = strval(Field);
            
    mysql_fetch_field_row(Field"vvsyapribyl"); AvtosalonInfo[z][vvsyapribyl] = strval(Field);
            
    mysql_fetch_field_row(Field"vobpribylbiz"); AvtosalonInfo[z][vobpribylbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"margin1"); AvtosalonInfo[z][vmargin1] = strval(Field);
            
    mysql_fetch_field_row(Field"margin2"); AvtosalonInfo[z][vmargin2] = strval(Field);
            
    mysql_fetch_field_row(Field"margin3"); AvtosalonInfo[z][vmargin3] = strval(Field);
            
    mysql_fetch_field_row(Field"margin4"); AvtosalonInfo[z][vmargin4] = strval(Field);
            
    mysql_fetch_field_row(Field"margin5"); AvtosalonInfo[z][vmargin5] = strval(Field);
            
    mysql_fetch_field_row(Field"margin6"); AvtosalonInfo[z][vmargin6] = strval(Field);
            
    mysql_fetch_field_row(Field"margin7"); AvtosalonInfo[z][vmargin7] = strval(Field);
            
    mysql_fetch_field_row(Field"margin8"); AvtosalonInfo[z][vmargin8] = strval(Field);
            
    mysql_fetch_field_row(Field"margin9"); AvtosalonInfo[z][vmargin9] = strval(Field);
            
    mysql_fetch_field_row(Field"margin10"); AvtosalonInfo[z][vmargin10] = strval(Field);
            
    mysql_fetch_field_row(Field"margin11"); AvtosalonInfo[z][vmargin11] = strval(Field);
            
    mysql_fetch_field_row(Field"margin12"); AvtosalonInfo[z][vmargin12] = strval(Field);
            
    mysql_fetch_field_row(Field"margin13"); AvtosalonInfo[z][vmargin13] = strval(Field);
            
    mysql_fetch_field_row(Field"margin14"); AvtosalonInfo[z][vmargin14] = strval(Field);
            
    mysql_fetch_field_row(Field"margin15"); AvtosalonInfo[z][vmargin15] = strval(Field);
            
    mysql_fetch_field_row(Field"car1"); AvtosalonInfo[z][vcar1] = strval(Field);
            
    mysql_fetch_field_row(Field"car2"); AvtosalonInfo[z][vcar2] = strval(Field);
            
    mysql_fetch_field_row(Field"car3"); AvtosalonInfo[z][vcar3] = strval(Field);
            
    mysql_fetch_field_row(Field"car4"); AvtosalonInfo[z][vcar4] = strval(Field);
            
    mysql_fetch_field_row(Field"car5"); AvtosalonInfo[z][vcar5] = strval(Field);
            
    mysql_fetch_field_row(Field"car6"); AvtosalonInfo[z][vcar6] = strval(Field);
            
    mysql_fetch_field_row(Field"car7"); AvtosalonInfo[z][vcar7] = strval(Field);
            
    mysql_fetch_field_row(Field"car8"); AvtosalonInfo[z][vcar8] = strval(Field);
            
    mysql_fetch_field_row(Field"car9"); AvtosalonInfo[z][vcar9] = strval(Field);
            
    mysql_fetch_field_row(Field"car10"); AvtosalonInfo[z][vcar10] = strval(Field);
            
    mysql_fetch_field_row(Field"car11"); AvtosalonInfo[z][vcar11] = strval(Field);
            
    mysql_fetch_field_row(Field"car12"); AvtosalonInfo[z][vcar12] = strval(Field);
            
    mysql_fetch_field_row(Field"car13"); AvtosalonInfo[z][vcar13] = strval(Field);
            
    mysql_fetch_field_row(Field"car14"); AvtosalonInfo[z][vcar14] = strval(Field);
            
    mysql_fetch_field_row(Field"car15"); AvtosalonInfo[z][vcar15] = strval(Field);
            
    mysql_free_result();
        }
        new 
    sql6[300];
        for(new 
    0sizeof(MagazinInfo); m++)
        {
            
    format(sql6200"SELECT * FROM `magazin` WHERE `ID` = '%d'",m);
            
    mysql_query(sql6); mysql_store_result();
            
    mysql_fetch_row(sql6);
            
    mysql_fetch_field_row(MagazinInfo[m][mvlad], "mvlad");
            
    mysql_fetch_field_row(Field"mnomerbiz"); MagazinInfo[m][mnomerbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"mobpribylbiz"); MagazinInfo[m][mobpribylbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena1"); MagazinInfo[m][mcena1] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena2"); MagazinInfo[m][mcena2] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena3"); MagazinInfo[m][mcena3] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena4"); MagazinInfo[m][mcena4] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena5"); MagazinInfo[m][mcena5] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena6"); MagazinInfo[m][mcena6] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena7"); MagazinInfo[m][mcena7] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena8"); MagazinInfo[m][mcena8] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena9"); MagazinInfo[m][mcena9] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena10"); MagazinInfo[m][mcena10] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena11"); MagazinInfo[m][mcena11] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena12"); MagazinInfo[m][mcena12] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena13"); MagazinInfo[m][mcena13] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena14"); MagazinInfo[m][mcena14] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena15"); MagazinInfo[m][mcena15] = strval(Field);
            
    mysql_fetch_field_row(Field"mcena16"); MagazinInfo[m][mcena16] = strval(Field);
            
    mysql_fetch_field_row(Field"cena17"); MagazinInfo[m][mcena17] = strval(Field);
            
    mysql_fetch_field_row(Field"cena18"); MagazinInfo[m][mcena18] = strval(Field);
            
    mysql_fetch_field_row(Field"cena19"); MagazinInfo[m][mcena19] = strval(Field);
            
    mysql_fetch_field_row(Field"cena20"); MagazinInfo[m][mcena20] = strval(Field);
            
    mysql_fetch_field_row(Field"mvsyapribyl"); MagazinInfo[m][mvsyapribyl] = strval(Field);
            
    mysql_fetch_field_row(Field"mbizdolg"); MagazinInfo[m][mbizdolg] = strval(Field);
            
    mysql_fetch_field_row(Field"mopen"); MagazinInfo[m][mopen] = strval(Field);
            
    mysql_fetch_field_row(Field"mphone"); MagazinInfo[m][mphone] = strval(Field);
            
    mysql_fetch_field_row(Field"mcamera"); MagazinInfo[m][mcamera] = strval(Field);
            
    mysql_fetch_field_row(Field"mclock"); MagazinInfo[m][mclock] = strval(Field);
            
    mysql_fetch_field_row(Field"mkanistra"); MagazinInfo[m][mkanistra] = strval(Field);
            
    mysql_fetch_field_row(Field"mheal"); MagazinInfo[m][mheal] = strval(Field);
            
    mysql_fetch_field_row(Field"mtrost"); MagazinInfo[m][mtrost] = strval(Field);
            
    mysql_fetch_field_row(Field"mflower"); MagazinInfo[m][mflower] = strval(Field);
            
    mysql_fetch_field_row(Field"mparash"); MagazinInfo[m][mparash] = strval(Field);
            
    mysql_fetch_field_row(Field"mshlem"); MagazinInfo[m][mshlem] = strval(Field);
            
    mysql_fetch_field_row(Field"mid"); MagazinInfo[m][mid] = strval(Field);
            
    mysql_fetch_field_row(Field"mnumber"); MagazinInfo[m][mnumber] = strval(Field);
            
    mysql_fetch_field_row(Field"mdir"); MagazinInfo[m][mdir] = strval(Field);
            
    mysql_fetch_field_row(Field"mbita"); MagazinInfo[m][mbita] = strval(Field);
            
    mysql_fetch_field_row(Field"mlopata"); MagazinInfo[m][mlopata] = strval(Field);
            
    mysql_fetch_field_row(Field"mkl"); MagazinInfo[m][mkl] = strval(Field);
            
    mysql_fetch_field_row(Field"mkatana"); MagazinInfo[m][mkatana] = strval(Field);
            
    mysql_fetch_field_row(Field"back"); MagazinInfo[m][mback] = strval(Field);
            
    mysql_fetch_field_row(Field"mask"); MagazinInfo[m][mmask] = strval(Field);
            
    mysql_fetch_field_row(Field"radio"); MagazinInfo[m][mradio] = strval(Field);
            
    mysql_fetch_field_row(Field"ot"); MagazinInfo[m][mot] = strval(Field);
            
    mysql_fetch_field_row(Field"mbuy"); MagazinInfo[m][mbuy] = strval(Field);
            
    mysql_free_result();
        }
        new 
    sql8[200];
        for(new 
    0sizeof(RelaxInfo); r++)
        {
            
    format(sql8200"SELECT * FROM `relax` WHERE `ID` = '%d'",r);
            
    mysql_query(sql8); mysql_store_result();
            
    mysql_fetch_row(sql8);
            
    mysql_fetch_field_row(RelaxInfo[r][rvlad], "rvlad");
            
    mysql_fetch_field_row(Field"rnomerbiz"); RelaxInfo[r][rnomerbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"robpribylbiz"); RelaxInfo[r][robpribylbiz] = strval(Field);
            
    mysql_fetch_field_row(Field"rcena1"); RelaxInfo[r][rcena1] = strval(Field);
            
    mysql_fetch_field_row(Field"rcena2"); RelaxInfo[r][rcena2] = strval(Field);
            
    mysql_fetch_field_row(Field"rcena3"); RelaxInfo[r][rcena3] = strval(Field);
            
    mysql_fetch_field_row(Field"rcena4"); RelaxInfo[r][rcena4] = strval(Field);
            
    mysql_fetch_field_row(Field"rcena5"); RelaxInfo[r][rcena5] = strval(Field);
            
    mysql_fetch_field_row(Field"rcena6"); RelaxInfo[r][rcena6] = strval(Field);
            
    mysql_fetch_field_row(Field"rsvyapribyl"); RelaxInfo[r][rvsyapribyl] = strval(Field);
            
    mysql_fetch_field_row(Field"rbizdolg"); RelaxInfo[r][rbizdolg] = strval(Field);
            
    mysql_fetch_field_row(Field"ropen"); RelaxInfo[r][ropen] = strval(Field);
            
    mysql_fetch_field_row(Field"rcola"); RelaxInfo[r][rcola] = strval(Field);
            
    mysql_fetch_field_row(Field"rbeer"); RelaxInfo[r][rbeer] = strval(Field);
            
    mysql_fetch_field_row(Field"rvodka"); RelaxInfo[r][rvodka] = strval(Field);
            
    mysql_fetch_field_row(Field"rvino"); RelaxInfo[r][rvino] = strval(Field);
            
    mysql_fetch_field_row(Field"rkonyak"); RelaxInfo[r][rkonyak] = strval(Field);
            
    mysql_fetch_field_row(Field"rled"); RelaxInfo[r][rled] = strval(Field);
            
    mysql_fetch_field_row(Field"rbuy"); RelaxInfo[r][rbuy] = strval(Field);
            
    mysql_free_result();
        }
        return 
    true;


  2. #2
    Аватар для #Djuga
    Пользователь

    Статус
    Оффлайн
    Регистрация
    28.02.2018
    Сообщений
    11
    Репутация:
    1 ±
    Хм, может ему нужно в таблице с аккаунтами обнулить ключ к бизнесу (pBizKey и тд..)
    Последний раз редактировалось #Djuga; 05.03.2018 в 11:32.

  3. #3
    Аватар для DeimoS
    Модератор?

    Статус
    Оффлайн
    Регистрация
    27.01.2014
    Адрес
    Восточный Мордор
    Сообщений
    5,588
    Репутация:
    1984 ±
    Покажи команду покупки бизнеса
    Связаться со мной в VK можно через личные сообщения этой группы
    Заказы не принимаю

    Широко известно, что идеи стоят 0.8333 цента каждая (исходя из рыночной цены 10 центов за дюжину).
    Великих идей полно, на них нет спроса.
    Воплощение идеи в законченную игру требует долгой работы,
    таланта, терпения и креативности, не говоря уж о затратах денег, времени и ресурсов.
    Предложить идею просто, воплотить – вот в чём проблема

    Steve Pavlina

 

 

Информация о теме

Пользователи, просматривающие эту тему

Эту тему просматривают: 1 (пользователей: 0 , гостей: 1)

Ваши права

  • Вы не можете создавать новые темы
  • Вы не можете отвечать в темах
  • Вы не можете прикреплять вложения
  • Вы не можете редактировать свои сообщения
  •