Narek
Компетентный
Ошибка в mysql_log
что делать? вот сам паблик незагружаетсья
подключение
что делать?
---------- Сообщение добавлено в 17:57 ---------- Предыдущее сообщение добавлено в 17:09 ----------
Закрыто сам нашол решение!
PHP:
[15:00:21] [ERROR] "mysql_tquery" - invalid connection handle (id: 0)
PHP:
publics: LoadFurniture()//ето
{
new rows, fields, id = 0;
cache_get_data(rows, fields);
if(rows)
{
for(new i; i < rows; i++)
{
FInfo[i][f_ID] = cache_get_field_content_int(i, "fID", connects);
FInfo[i][f_model] = cache_get_field_content_int(i, "fmodel", connects);
FInfo[i][f_x] = cache_get_field_content_float(i, "fx", connects);
FInfo[i][f_y] = cache_get_field_content_float(i, "fy", connects);
FInfo[i][f_z] = cache_get_field_content_float(i, "fz", connects);
FInfo[i][f_rootx] = cache_get_field_content_float(i, "frootx", connects);
FInfo[i][f_rooty] = cache_get_field_content_float(i, "frooty", connects);
FInfo[i][f_rootz] = cache_get_field_content_float(i, "frootz", connects);
FInfo[i][f_virtual] = cache_get_field_content_int(i, "fvirtualWorld", connects);
FInfo[i][f_int] = cache_get_field_content_int(i, "fint", connects);
FInfo[i][f_ID] =
CreateDynamicObject(FInfo[i][f_model],\
FInfo[i][f_x], FInfo[i][f_y], FInfo[i][f_z], FInfo[i][f_rootx], FInfo[i][f_rooty], FInfo[i][f_rootz], FInfo[i][f_virtual], FInfo[i][f_int]);
FInfo[i][f_ID] = furniture_object;
id++;
}
printf("- Успешно загружена cклад.Всего пива %d", id);
}
return 1;
}
подключение
PHP:
mysql_tquery(connects,"SELECT * FROM `furniture`", "LoadFurniture","");
PHP:
mysql_log(LOG_ERROR | LOG_WARNING, LOG_TYPE_TEXT);
connects = mysql_connect("localhost", "root", "narek", "");
//connects = mysql_connect("localhost", "root", "test1", "root");
if(mysql_errno()==0) printf("Подключение к базе успешно");
else return printf("Подключиться к базе не удалось");
mysql_tquery(connects,"SET NAMES cp1251");
mysql_tquery(connects,"set character_set_client=\'cp1251\'");
mysql_tquery(connects,"set character_set_results=\'cp1251\'");
mysql_tquery(connects,"set collation_connection=\'cp1251_general_ci\'");
mysql_tquery(connects,"SELECT * FROM `family_system`","family_loading", "") ;
mysql_tquery(connects,"SELECT * FROM `materials`", "OnLoadMaterialsCallback", "");
mysql_tquery(connects,"SELECT * FROM `mafiabalance`", "OnLoadBankMafiaCallback", "");
mysql_tquery(connects,"SELECT * FROM `meria`", "OnLoadMeriaCallback", "");
mysql_tquery(connects,"SELECT * FROM `online`", "OnLoadMaxOnline", "");
mysql_tquery(connects,"SELECT * FROM `gangzone`", "LoadGZ","");
mysql_tquery(connects,"SELECT * FROM `hospital`", "LoadHospital","");
// mysql_tquery(connects,"SELECT * FROM `gangs`",true,"GangLoad","");
mysql_tquery(connects,"SELECT * FROM `loadalkofrac`", "CallBanLoadAlkoFrac", "");
mysql_tquery(connects,"SELECT * FROM `loadbankfrac`", "CallBankLoadBankFrac", "");
mysql_tquery(connects,"SELECT * FROM `sbizz`", "LoadSBizz","");
mysql_tquery(connects,"SELECT * FROM `business`", "LoadBizes","");
mysql_tquery(connects,"SELECT * FROM `house`", "LoadProperty","");
mysql_tquery(connects,"SELECT * FROM `furniture`", "LoadFurniture","");//вот тут сама подключение
mysql_tquery(connects,"SELECT * FROM `warehouse_money`", "LoadWarehouse","");//
return true;
}
---------- Сообщение добавлено в 17:57 ---------- Предыдущее сообщение добавлено в 17:09 ----------
Закрыто сам нашол решение!
Последнее редактирование:
