Ошибка загрузки из базы (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 i; i < rows; i++)
{
cache_get_field_content(i, "vlad", PizzaInfo[i][vlad], mysql_connection_ID, 32);
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 i; i < rows; i++)
{
PonchikiInfo[i][oobpribylbiz] = cache_get_field_content_int(i, "oobpribylbiz");
cache_get_field_content(i, "ovlad", PonchikiInfo[i][ovlad], mysql_connection_ID, 32);
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 i; i < rows; i++)
{
cache_get_field_content(i, "cvlad", ChikenInfo[i][cvlad], mysql_connection_ID, 32);
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 i; i < rows; i++)
{
cache_get_field_content(i, "bvlad", BurgerInfo[i][bvlad], mysql_connection_ID, 32);
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 i = 1; i < rows; i++)
{
cache_get_field_content(i, "avlad", AzsInfo[i][avlad], mysql_connection_ID, 32);
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 i; i < rows; i++)
{
cache_get_field_content(i, "vvlad", AvtosalonInfo[i][vvlad], mysql_connection_ID, 32);
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 i; i < rows; i++)
{
cache_get_field_content(i, "mvlad", MagazinInfo[i][mvlad], mysql_connection_ID, 32);
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 i; i < rows; i++)
{
cache_get_field_content(i, "rvlad", RelaxInfo[i][rvlad], mysql_connection_ID, 32);
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 i = 0; i < sizeof(PizzaInfo); i++)
{
format(sql1, 200, "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 l = 0; l < sizeof(PonchikiInfo); l++)
{
format(sql4, 200, "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 h = 0; h < sizeof(ChikenInfo); h++)
{
format(sql2, 200, "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 b = 0; b < sizeof(BurgerInfo); b++)
{
format(sql3, 200, "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 z = 0; z < sizeof(AzsInfo); z++)
{
format(sql5, 1024, "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 z = 0; z < sizeof(AvtosalonInfo); z++)
{
format(sql5, 1024, "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 m = 0; m < sizeof(MagazinInfo); m++)
{
format(sql6, 200, "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 r = 0; r < sizeof(RelaxInfo); r++)
{
format(sql8, 200, "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;
}
