Sziasztok minden létre van hozva és mindig ezt irja
valaki segítsen pls! előre is köszönöm! <3
Mysql_log
[12:59:14] [DEBUG] mysql_tquery - connection: 1, query: \"SELECT * FROM `bizek`\", callback: \"BizniszekBetoltese\", format: \"(null)\"
[12:59:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[12:59:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[12:59:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[12:59:14] [DEBUG] mysql_tquery - connection: 1, query: \"SELECT * FROM `jarmuvek`\", callback: \"KocsikBetoltese\", format: \"(null)\"
[12:59:14] [DEBUG] CMySQLConnection::Connect - connection was successful
[12:59:14] [DEBUG] CMySQLConnection::Connect - connection was successful
[12:59:14] [DEBUG] CMySQLConnection::Connect - connection was successful
[12:59:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[12:59:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[12:59:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[12:59:14] [DEBUG] mysql_tquery - connection: 1, query: \"SELECT * FROM `ajtok`\", callback: \"AjtokBetoltese\", format: \"(null)\"
[12:59:14] [DEBUG] CMySQLQuery::Execute[BizniszekBetoltese] - starting query execution
[12:59:14] [DEBUG] CMySQLQuery::Execute[BizniszekBetoltese] - query was successfully executed within 1.454 milliseconds
[12:59:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[12:59:14] [DEBUG] mysql_tquery - connection: 1, query: \"SELECT * FROM `hazak`\", callback: \"HazakBetoltese\", format: \"(null)\"
[12:59:14] [DEBUG] CMySQLQuery::Execute[KocsikBetoltese] - starting query execution
[12:59:14] [DEBUG] CMySQLQuery::Execute[KocsikBetoltese] - query was successfully executed within 1.322 milliseconds
[12:59:14] [DEBUG] mysql_tquery - connection: 1, query: \"SELECT * FROM `eldobottitemek`\", callback: \"EldobottItemBetoltes\", format: \"(null)\"
[12:59:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[12:59:14] [DEBUG] CMySQLQuery::Execute[AjtokBetoltese] - starting query execution
[12:59:14] [DEBUG] mysql_tquery - connection: 1, query: \"SELECT * FROM `jarmuvek`\", callback: \"KocsikBetoltese\", format: \"(null)\"
[12:59:14] [DEBUG] CMySQLQuery::Execute[AjtokBetoltese] - query was successfully executed within 3.566 milliseconds
[12:59:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[12:59:14] [DEBUG] CMySQLQuery::Execute[HazakBetoltese] - starting query execution
[12:59:14] [DEBUG] Calling callback \"BizniszekBetoltese\"..
[12:59:14] [DEBUG] cache_get_data - connection: 1
[12:59:14] [DEBUG] CMySQLQuery::Execute[HazakBetoltese] - query was successfully executed within 7.524 milliseconds
[12:59:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[12:59:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"ID\", connection: 1
[12:59:14] [DEBUG] CMySQLQuery::Execute[EldobottItemBetoltes] - starting query execution
[12:59:14] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"ID\", data: \"1\"
[12:59:14] [DEBUG] CMySQLQuery::Execute[EldobottItemBetoltes] - query was successfully executed within 7.987 milliseconds
[12:59:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[12:59:14] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"bePosX\", connection: 1
[12:59:14] [DEBUG] CMySQLQuery::Execute[KocsikBetoltese] - starting query execution
[12:59:14] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bePosX\", data: \"-53.594\"
[12:59:14] [DEBUG] CMySQLQuery::Execute[KocsikBetoltese] - query was successfully executed within 1.154 milliseconds
[12:59:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[12:59:14] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"bePosY\", connection: 1
[12:59:14] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bePosY\", data: \"1058.96\"
[12:59:14] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"bePosZ\", connection: 1
[12:59:14] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bePosZ\", data: \"19.742\"
[12:59:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"beInt\", connection: 1
[12:59:14] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"beInt\", data: \"0\"
[12:59:14] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"kiPosX\", connection: 1
[12:59:14] [WARNING] CMySQLResult::GetRowDataByName - field not found (\"kiPosX\")
[12:59:14] [ERROR] cache_get_field_content_float - invalid datatype
[12:59:15] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"kiPosY\", connection: 1
[12:59:15] [WARNING] CMySQLResult::GetRowDataByName - field not found (\"kiPosY\")
[12:59:15] [ERROR] cache_get_field_content_float - invalid datatype
[12:59:15] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"kiPosZ\", connection: 1
[12:59:15] [WARNING] CMySQLResult::GetRowDataByName - field not found (\"kiPosZ\")
[12:59:15] [ERROR] cache_get_field_content_float - invalid datatype
[12:59:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"kiInt\", connection: 1
[12:59:15] [WARNING] CMySQLResult::GetRowDataByName - field not found (\"kiInt\")
[12:59:15] [ERROR] cache_get_field_content_int - invalid datatype
[12:59:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"bTipusID\", connection: 1
[12:59:15] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bTipusID\", data: \"1\"
[12:59:15] [DEBUG] cache_get_field_content - row: 0, field_name: \"bTipus\", connection: 1, max_len: 128
[12:59:15] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bTipus\", data: \"0\"
[12:59:15] [DEBUG] cache_get_field_content - row: 0, field_name: \"bTulaj\", connection: 1, max_len: 24
[12:59:15] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bTulaj\", data: \"\"
[12:59:15] [DEBUG] cache_get_field_content - row: 0, field_name: \"bMasodTulaj\", connection: 1, max_len: 24
[12:59:15] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bMasodTulaj\", data: \"\"
[12:59:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"VanSzef\", connection: 1
[12:59:15] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"VanSzef\", data: \"0\"
[12:59:15] [DEBUG] cache_get_field_content - row: 0, field_name: \"SzefTargyNev\", connection: 1, max_len: 512
[12:59:15] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"SzefTargyNev\", data: \"0\"
[12:59:15] [DEBUG] cache_get_field_content - row: 0, field_name: \"SzefTargyDarab\", connection: 1, max_len: 512
[12:59:15] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"SzefTargyDarab\", data: \"0\"
[12:59:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"bNyitva\", connection: 1
[12:59:15] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bNyitva\", data: \"0\"
[12:59:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"bAr\", connection: 1
[12:59:15] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bAr\", data: \"1\"
[12:59:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"bElado\", connection: 1
[12:59:15] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bElado\", data: \"1\"
[12:59:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"bBelepesiAr\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bBelepesiAr\", data: \"0\"
[12:59:16] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"VanSzef\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"VanSzef\", data: \"0\"
[12:59:16] [DEBUG] cache_get_field_content - row: 0, field_name: \"bTargyDarab\", connection: 1, max_len: 512
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bTargyDarab\", data: \"0\"
[12:59:16] [DEBUG] cache_get_field_content - row: 0, field_name: \"bTargyNev\", connection: 1, max_len: 512
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bTargyNev\", data: \"0\"
[12:59:16] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"Hasznalatban\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"Hasznalatban\", data: \"1\"
[12:59:16] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[12:59:16] [DEBUG] Calling callback \"KocsikBetoltese\"..
[12:59:16] [DEBUG] cache_get_data - connection: 1
[12:59:16] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[12:59:16] [DEBUG] Calling callback \"AjtokBetoltese\"..
[12:59:16] [DEBUG] cache_get_data - connection: 1
[12:59:16] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[12:59:16] [DEBUG] Calling callback \"HazakBetoltese\"..
[12:59:16] [DEBUG] cache_get_data - connection: 1
[12:59:16] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"ID\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"ID\", data: \"1\"
[12:59:16] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"bePosX\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bePosX\", data: \"125.329\"
[12:59:16] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"bePosY\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bePosY\", data: \"-75.773\"
[12:59:16] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"bePosZ\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"bePosZ\", data: \"1.578\"
[12:59:16] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"beInt\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"beInt\", data: \"0\"
[12:59:16] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"kiPosX\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"kiPosX\", data: \"223.2\"
[12:59:16] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"kiPosY\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"kiPosY\", data: \"1287.08\"
[12:59:16] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"kiPosZ\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"kiPosZ\", data: \"1082.14\"
[12:59:16] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"kiInt\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"kiInt\", data: \"1\"
[12:59:16] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"Hasznalatban\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"Hasznalatban\", data: \"1\"
[12:59:16] [DEBUG] cache_get_field_content - row: 0, field_name: \"hTulaj\", connection: 1, max_len: 24
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"hTulaj\", data: \"\"
[12:59:16] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"hAjto\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"hAjto\", data: \"0\"
[12:59:16] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"VanTulaja\", connection: 1
[12:59:16] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"VanTulaja\", data: \"0\"
[12:59:17] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"hTipus\", connection: 1
[12:59:17] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"hTipus\", data: \"2\"
[12:59:17] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"hAr\", connection: 1
[12:59:17] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"hAr\", data: \"5\"
[12:59:17] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"gbePosX\", connection: 1
[12:59:17] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"gbePosX\", data: \"0\"
[12:59:17] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"gbePosY\", connection: 1
[12:59:17] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"gbePosY\", data: \"0\"
[12:59:17] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"gbePosZ\", connection: 1
[12:59:17] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"gbePosZ\", data: \"0\"
[12:59:17] [DEBUG] cache_get_field_content_float - row: 0, field_name: \"gbePosA\", connection: 1
[12:59:17] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"gbePosA\", data: \"0\"
[12:59:17] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"VanGarazs\", connection: 1
[12:59:17] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"VanGarazs\", data: \"0\"
[12:59:17] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"GarazsKocsi\", connection: 1
[12:59:17] [WARNING] CMySQLResult::GetRowDataByName - field not found (\"GarazsKocsi\")
[12:59:17] [ERROR] cache_get_field_content_int - invalid datatype
[12:59:17] [DEBUG] cache_get_field_content_int - row: 0, field_name: \"GarazsAjto\", connection: 1
[12:59:17] [DEBUG] CMySQLResult::GetRowDataByName - row: \'0\', field: \"GarazsAjto\", data: \"0\"
[12:59:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[12:59:17] [DEBUG] Calling callback \"EldobottItemBetoltes\"..
[12:59:17] [DEBUG] cache_get_data - connection: 1
[12:59:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[12:59:17] [DEBUG] Calling callback \"KocsikBetoltese\"..
[12:59:17] [DEBUG] cache_get_data - connection: 1
[12:59:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
fuggveny KocsikBetoltese()
{
new nums, fields, idx = 1;
cache_get_data(nums,fields);
if(nums)
{
new i = -1;
for(;++i < nums;)
{
/*KocsiInfo[idx][cID] = cache_get_field_content_int(i, \"cID\");
KocsiInfo[idx][vID] = cache_get_field_content_int(i, \"vID\");
KocsiInfo[idx][JarmuX] = cache_get_field_content_float(i, \"JarmuX\");
KocsiInfo[idx][JarmuY] = cache_get_field_content_float(i, \"JarmuY\");
KocsiInfo[idx][JarmuZ] = cache_get_field_content_float(i, \"JarmuZ\");
KocsiInfo[idx][JarmuA] = cache_get_field_content_float(i, \"JarmuA\");
KocsiInfo[idx][JarmuHP] = cache_get_field_content_float(i, \"JarmuHP\");
KocsiInfo[idx][Model] = cache_get_field_content_int(i, \"Model\");
KocsiInfo[idx][KocsiAra] = cache_get_field_content_int(i, \"KocsiAra\");
KocsiInfo[idx][Szin1] = cache_get_field_content_int(i, \"Szin1\");
KocsiInfo[idx][Szin2] = cache_get_field_content_int(i, \"Szin2\");
KocsiInfo[idx][VanTulaja] = cache_get_field_content_int(i, \"VanTulaja\");
KocsiInfo[idx][Hasznalatban] = cache_get_field_content_int(i, \"Hasznalatban\");
cache_get_field_content(0, \"Tulaj\", KocsiInfo[idx][Tulaj], g_SQL, 24);
cache_get_field_content(0, \"Rendszam\", KocsiInfo[idx][Rendszam], g_SQL, 32);
KocsiInfo[idx][Hasznalatban] = 1;
CreateVehicle(KocsiInfo[idx][Model],KocsiInfo[idx][JarmuX],KocsiInfo[idx][JarmuY],KocsiInfo[idx][JarmuZ],KocsiInfo[idx][JarmuA],KocsiInfo[idx][Szin1],KocsiInfo[idx][Szin2],-1);
SetVehicleHealth(idx, KocsiInfo[idx][JarmuHP]);*/
KocsiInfo[idx][cID] = cache_get_field_content_int(i, \"cID\");
KocsiInfo[KocsiInfo[idx][cID]][vID] = cache_get_field_content_int(i, \"vID\");
KocsiInfo[KocsiInfo[idx][cID]][JarmuX] = cache_get_field_content_float(i, \"JarmuX\");
KocsiInfo[KocsiInfo[idx][cID]][JarmuY] = cache_get_field_content_float(i, \"JarmuY\");
KocsiInfo[KocsiInfo[idx][cID]][JarmuZ] = cache_get_field_content_float(i, \"JarmuZ\");
KocsiInfo[KocsiInfo[idx][cID]][JarmuA] = cache_get_field_content_float(i, \"JarmuA\");
KocsiInfo[KocsiInfo[idx][cID]][JarmuHP] = cache_get_field_content_float(i, \"JarmuHP\");
KocsiInfo[KocsiInfo[idx][cID]][Model] = cache_get_field_content_int(i, \"Model\");
KocsiInfo[KocsiInfo[idx][cID]][KocsiAra] = cache_get_field_content_int(i, \"KocsiAra\");
KocsiInfo[KocsiInfo[idx][cID]][Szin1] = cache_get_field_content_int(i, \"Szin1\");
KocsiInfo[KocsiInfo[idx][cID]][Szin2] = cache_get_field_content_int(i, \"Szin2\");
KocsiInfo[KocsiInfo[idx][cID]][VanTulaja] = cache_get_field_content_int(i, \"VanTulaja\");
KocsiInfo[KocsiInfo[idx][cID]][Hasznalatban] = cache_get_field_content_int(i, \"Hasznalatban\");
cache_get_field_content(0, \"Tulaj\", KocsiInfo[KocsiInfo[idx][cID]][Tulaj], g_SQL, 24);
cache_get_field_content(0, \"Rendszam\", KocsiInfo[KocsiInfo[idx][cID]][Rendszam], g_SQL, 32);
KocsiInfo[KocsiInfo[idx][cID]][Hasznalatban] = 1;
CreateVehicle(KocsiInfo[KocsiInfo[idx][cID]][Model],KocsiInfo[KocsiInfo[idx][cID]][JarmuX],KocsiInfo[KocsiInfo[idx][cID]][JarmuY],KocsiInfo[KocsiInfo[idx][cID]][JarmuZ],KocsiInfo[KocsiInfo[idx][cID]][JarmuA],KocsiInfo[KocsiInfo[idx][cID]][Szin1],KocsiInfo[KocsiInfo[idx][cID]][Szin2],-1);
SetVehicleHealth(KocsiInfo[idx][cID], KocsiInfo[KocsiInfo[idx][cID]][JarmuHP]);
idx++;
}
}
if(nums) printf(\"[KOCSI_LOG] %d darab kocsi betöltve.\",nums);
else printf(\"[KOCSI_LOG] Nem lett betöltve kocsi.\");
}
fuggveny AjtokBetoltese()
{
new nums, fields, idx = 1;
cache_get_data(nums,fields);
if(nums)
{
new i = -1;
for(;++i < nums;)
{
AjtoInfo[idx][ID] = cache_get_field_content_int(i, \"ID\");
AjtoInfo[idx][aID] = cache_get_field_content_int(i, \"aID\");
AjtoInfo[idx][bePosX] = cache_get_field_content_float(i, \"bePosX\");
AjtoInfo[idx][bePosY] = cache_get_field_content_float(i, \"bePosY\");
AjtoInfo[idx][bePosZ] = cache_get_field_content_float(i, \"bePosZ\");
AjtoInfo[idx][beInt] = cache_get_field_content_int(i, \"beInt\");
AjtoInfo[idx][kiPosX] = cache_get_field_content_float(i, \"kiPosX\");
AjtoInfo[idx][kiPosY] = cache_get_field_content_float(i, \"kiPosY\");
AjtoInfo[idx][kiPosZ] = cache_get_field_content_float(i, \"kiPosZ\");
AjtoInfo[idx][kiInt] = cache_get_field_content_int(i, \"kiInt\");
AjtoInfo[idx][Hasznalatban] = cache_get_field_content_int(i, \"Hasznalatban\");
cache_get_field_content(0, \"Nev\", AjtoInfo[idx][Nev], g_SQL, 24);
cache_get_field_content(0, \"Letrehozta\", AjtoInfo[idx][Letrehozta], g_SQL, 24);
AjtoInfo[idx][Hasznalatban] = 1;
if(AjtoInfo[kiPosX] != 0.000 && AjtoInfo[kiPosY] != 0.000 && AjtoInfo[kiPosZ] != 0.000)
{
format(wszoveg,sizeof(wszoveg),\"%s\\n[Kijárat]\",AjtoInfo[Nev]);
AjtoLabel2 = Create3DTextLabel(wszoveg, COLOR_FEHER,AjtoInfo[kiPosX],AjtoInfo[kiPosY],AjtoInfo[kiPosZ], 15.0,0, 0);
}
format(wszoveg,sizeof(wszoveg),\"%s\\n[Bejárat]\",AjtoInfo[Nev]);
AjtoLabel1 = Create3DTextLabel(wszoveg, COLOR_FEHER,AjtoInfo[bePosX],AjtoInfo[bePosY],AjtoInfo[bePosZ], 15.0,0, 0);
AjtoPickup = CreatePickup (1318, 1, AjtoInfo[bePosX],AjtoInfo[bePosY],AjtoInfo[bePosZ]);
idx++;
}
}
if(nums) printf(\"[AJTO_LOG] %d darab ajtó betöltve.\",nums);
else printf(\"[AJTO_LOG] Nem lett betöltve ajtó.\");
}
fuggveny BizniszekBetoltese()
{
new nums, fields, idx = 1;
cache_get_data(nums,fields);
if(nums)
{
new i = -1;
for(;++i < nums;)
{
BizInfo[idx][ID] = cache_get_field_content_int(i, \"ID\");
BizInfo[idx][bePosX] = cache_get_field_content_float(i, \"bePosX\");
BizInfo[idx][bePosY] = cache_get_field_content_float(i, \"bePosY\");
BizInfo[idx][bePosZ] = cache_get_field_content_float(i, \"bePosZ\");
BizInfo[idx][beInt] = cache_get_field_content_int(i, \"beInt\");
BizInfo[idx][kiPosX] = cache_get_field_content_float(i, \"kiPosX\");
BizInfo[idx][kiPosY] = cache_get_field_content_float(i, \"kiPosY\");
BizInfo[idx][kiPosZ] = cache_get_field_content_float(i, \"kiPosZ\");
BizInfo[idx][kiInt] = cache_get_field_content_int(i, \"kiInt\");
BizInfo[idx][bTipusID] = cache_get_field_content_int(i, \"bTipusID\");
cache_get_field_content(0, \"bTipus\", bTipus[idx], g_SQL, 128);
cache_get_field_content(0, \"bTulaj\", bTulaj[idx], g_SQL, 24);
cache_get_field_content(0, \"bMasodTulaj\", bMasodTulaj[idx], g_SQL, 24);
// ### Széf ###
BizInfo[idx][VanSzef] = cache_get_field_content_int(i, \"VanSzef\");
cache_get_field_content(0, \"SzefTargyNev\", SzefTargyNev[idx], g_SQL, 512);
cache_get_field_content(0, \"SzefTargyDarab\", SzefTargyDarab[idx], g_SQL, 512);
// ############
BizInfo[idx][bNyitva] = cache_get_field_content_int(i, \"bNyitva\");
BizInfo[idx][bAr] = cache_get_field_content_int(i, \"bAr\");
BizInfo[idx][bElado] = cache_get_field_content_int(i, \"bElado\");
BizInfo[idx][bBelepesiAr] = cache_get_field_content_int(i, \"bBelepesiAr\");
// ### Tárgyak ###
BizInfo[idx][VanSzef] = cache_get_field_content_int(i, \"VanSzef\");
cache_get_field_content(0, \"bTargyDarab\", bTargyDarab[idx], g_SQL, 512);
cache_get_field_content(0, \"bTargyNev\", bTargyNev[idx], g_SQL, 512);
BizInfo[idx][Hasznalatban] = cache_get_field_content_int(i, \"Hasznalatban\");
if(BizInfo[idx][bElado] == 1)
{
format(wszoveg,sizeof(wszoveg),\"\"#COL_FEHER\"Név: \"#COL_MKEK\"Nincs\\n\"#COL_FEHER\"Tulajdonos: \"#COL_MKEK\"Nincs\\n\"#COL_FEHER\"Eladó: \"#COL_MKEK\"$%d\\n\"#COL_FEHER\"[Interakció: \"#COL_MKEK\"Y Gomb\"#COL_FEHER\"]\",BizInfo[idx][bAr]);
}
else
{
format(wszoveg,sizeof(wszoveg),\"\"#COL_FEHER\"Név: \"#COL_MKEK\"%s\\n\"#COL_FEHER\"Tulajdonos: \"#COL_MKEK\"%s\\n\"#COL_FEHER\"[Interakció: \"#COL_MKEK\"Y Gomb\"#COL_FEHER\"]\",
bTipus[idx],bTulaj[idx]);
}
BizInfo[idx][BizPickup] = CreatePickup (1274, 1, BizInfo[idx][bePosX],BizInfo[idx][bePosY],BizInfo[idx][bePosZ]);
BizLabel[idx] = Create3DTextLabel(wszoveg, -1,BizInfo[idx][bePosX],BizInfo[idx][bePosY],BizInfo[idx][bePosZ], 5.0,0, 0);
idx++;
}
}
if(nums) printf(\"[HAZ_LOG] %d darab biznisz betöltve.\",nums);
else printf(\"[HAZ_LOG] Nem lett betöltve biznisz.\");
}
fuggveny HazakBetoltese()
{
new nums, fields, idx = 1;
cache_get_data(nums,fields);
if(nums)
{
new i = -1;
for(;++i < nums;)
{
HazInfo[idx][ID] = cache_get_field_content_int(i, \"ID\");
HazInfo[idx][bePosX] = cache_get_field_content_float(i, \"bePosX\");
HazInfo[idx][bePosY] = cache_get_field_content_float(i, \"bePosY\");
HazInfo[idx][bePosZ] = cache_get_field_content_float(i, \"bePosZ\");
HazInfo[idx][beInt] = cache_get_field_content_int(i, \"beInt\");
HazInfo[idx][kiPosX] = cache_get_field_content_float(i, \"kiPosX\");
HazInfo[idx][kiPosY] = cache_get_field_content_float(i, \"kiPosY\");
HazInfo[idx][kiPosZ] = cache_get_field_content_float(i, \"kiPosZ\");
HazInfo[idx][kiInt] = cache_get_field_content_int(i, \"kiInt\");
HazInfo[idx][Hasznalatban] = cache_get_field_content_int(i, \"Hasznalatban\");
cache_get_field_content(0, \"hTulaj\", HazInfo[idx][hTulaj], g_SQL, 24);
strmid(HazNev[idx],HazInfo[idx][hTulaj],0,24);
HazInfo[idx][hAjto] = cache_get_field_content_int(i, \"hAjto\");
HazInfo[idx][VanTulaja] = cache_get_field_content_int(i, \"VanTulaja\");
HazInfo[idx][hTipus] = cache_get_field_content_int(i, \"hTipus\");
HazInfo[idx][hAr] = cache_get_field_content_int(i, \"hAr\");
// ### Garázs
HazInfo[idx][gbePosX] = cache_get_field_content_float(i, \"gbePosX\");
HazInfo[idx][gbePosY] = cache_get_field_content_float(i, \"gbePosY\");
HazInfo[idx][gbePosZ] = cache_get_field_content_float(i, \"gbePosZ\");
HazInfo[idx][gbePosA] = cache_get_field_content_float(i, \"gbePosA\");
HazInfo[idx][VanGarazs] = cache_get_field_content_int(i, \"VanGarazs\");
HazInfo[idx][GarazsKocsi] = cache_get_field_content_int(i, \"GarazsKocsi\");
HazInfo[idx][GarazsAjto] = cache_get_field_content_int(i, \"GarazsAjto\");
// ###
HazInfo[idx][Hasznalatban] = 1;
// ### Garázs
format(wszoveg,sizeof(wszoveg),\"\"#COL_FEHER\"Garázs Tulajdonos: \"#COL_MKEK\"%s\\n\"#COL_FEHER\"Sun utca %d.\\n\"#COL_FEHER\"[\"#COL_MKEK\"Interakció: Y Gomb\"#COL_FEHER\"]\",HazNev[idx],HazInfo[idx][ID]);
GarazsLabel[idx] = Create3DTextLabel(wszoveg, COLOR_FEHER,HazInfo[idx][gbePosX],HazInfo[idx][gbePosY],HazInfo[idx][gbePosZ], 15.0,0, 0);
GarazsPickup[idx] = CreatePickup (1318, 1, HazInfo[idx][gbePosX],HazInfo[idx][gbePosY],HazInfo[idx][gbePosZ]);
// ###
if(HazInfo[idx][hTipus] == 1 || HazInfo[idx][hTipus] == 2 || HazInfo[idx][hTipus] == 3)
{
strmid(hTipusNev[idx],\"Kis méretű\",0,24);
}
if(HazInfo[idx][hTipus] == 4 || HazInfo[idx][hTipus] == 5 || HazInfo[idx][hTipus] == 6)
{
strmid(hTipusNev[idx],\"Közepes méretű\",0,24);
}
if(HazInfo[idx][hTipus] == 7 || HazInfo[idx][hTipus] == 8 || HazInfo[idx][hTipus] == 9)
{
strmid(hTipusNev[idx],\"Kis méretű\",0,24);
}
if(HazInfo[idx][VanTulaja] == 0)
{
format(wszoveg,sizeof(wszoveg),\"\"#COL_FEHER\"Tulajdonos: \"#COL_LRED\"Nincs\\n\"#COL_FEHER\"Ház ára: \"#COL_LRED\"$%d\\n\"#COL_FEHER\"Ház mérete: \"#COL_LRED\"%s\\n\"#COL_FEHER\"[\"#COL_LRED\"Interakció: Y Gomb\"#COL_FEHER\"]\",HazInfo[idx][hAr],hTipusNev[idx]);
HazLabel[idx] = Create3DTextLabel(wszoveg, COLOR_FEHER,HazInfo[idx][bePosX],HazInfo[idx][bePosY],HazInfo[idx][bePosZ], 15.0,0, 0);
}
else
{
format(wszoveg,sizeof(wszoveg),\"\"#COL_FEHER\"Tulajdonos: \"#COL_LRED\"%s\\n\"#COL_FEHER\"Sun utca %d.\\n\"#COL_FEHER\"[\"#COL_LRED\"Interakció: Y Gomb\"#COL_FEHER\"]\",HazNev[idx],HazInfo[idx][ID]);
HazLabel[idx] = Create3DTextLabel(wszoveg, COLOR_FEHER,HazInfo[idx][bePosX],HazInfo[idx][bePosY],HazInfo[idx][bePosZ], 15.0,0, 0);
}
if(HazInfo[idx][VanTulaja] == 0) { HazPickup[idx] = CreatePickup (1273, 1, HazInfo[idx][bePosX],HazInfo[idx][bePosY],HazInfo[idx][bePosZ]); }
if(HazInfo[idx][VanTulaja] == 1) { HazPickup[idx] = CreatePickup (1272, 1, HazInfo[idx][bePosX],HazInfo[idx][bePosY],HazInfo[idx][bePosZ]); }
idx++;
}
}
if(nums) printf(\"[HAZ_LOG] %d darab ház betöltve.\",nums);
else printf(\"[HAZ_LOG] Nem lett betöltve ház.\");
}
fuggveny EldobottItemBetoltes()
{
new nums, fields, idx = 1;
cache_get_data(nums,fields);
if(nums)
{
new i = -1;
for(;++i < nums;)
{
EldobottInfo[idx][ID] = cache_get_field_content_int(i, \"ID\");
EldobottInfo[idx][eID] = cache_get_field_content_int(i, \"eID\");
EldobottInfo[idx][PosX] = cache_get_field_content_float(i, \"PosX\");
EldobottInfo[idx][PosY] = cache_get_field_content_float(i, \"PosY\");
EldobottInfo[idx][PosZ] = cache_get_field_content_float(i, \"PosZ\");
EldobottInfo[idx][Hasznalatban] = cache_get_field_content_int(i, \"Hasznalatban\");
EldobottInfo[idx][Darabszam] = cache_get_field_content_int(i, \"Darabszam\");
EldobottInfo[idx][iInt] = cache_get_field_content_int(i, \"iInt\");
EldobottInfo[idx][iVW] = cache_get_field_content_int(i, \"iVW\");
EldobottInfo[idx][SzerverBetoltes] = 1;
EldobottInfo[idx][Hasznalatban] = 1;
cache_get_field_content(0, \"Eldobta\", EldobottInfo[idx][Eldobta], g_SQL, 24);
cache_get_field_content(0, \"EldobottTargy\", EldobottTargy[idx], g_SQL, 60);
format(wszoveg,sizeof(wszoveg),\"\"#COL_FEHER\"Tárgy: \"#COL_MKEK\"%s\\n\"#COL_FEHER\"Darabszám: \"#COL_MKEK\"%d \"#COL_FEHER\"darab\\n\"#COL_FEHER\"(( Eldobta: \"#COL_MKEK\"%s\"#COL_FEHER\" ))\\n\"#COL_FEHER\"(( ID: \"#COL_MKEK\"%d\"#COL_FEHER\" ))\\n\"#COL_FEHER\"[Interakció: \"#COL_MKEK\"Y Gomb\"#COL_FEHER\"]\",EldobottTargy[idx],EldobottInfo[idx][Darabszam],EldobottInfo[idx][Eldobta],EldobottInfo[idx][eID]);
EldobottInfoLabel[idx] = Create3DTextLabel(wszoveg, -1,EldobottInfo[idx][PosX],EldobottInfo[idx][PosY],EldobottInfo[idx][PosZ]-0.9, 5.0,EldobottInfo[idx][iVW], 0);
EldobottTargyObject[idx] = CreateDynamicObject(327, EldobottInfo[idx][PosX],EldobottInfo[idx][PosY],EldobottInfo[idx][PosZ]-0.9, 0.00000, 0.0000,0);
idx++;
}
}
if(nums) printf(\"[ELDOBOTT_TARGY_LOG] %d darab eldobott tárgy betöltve.\",nums);
else printf(\"[ELDOBOTT_TARGY_LOG] Nem lett betöltve eldobott tárgy.\");
}
Létre hozott mysql táblázatok!
-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Gép: 127.0.0.1
-- Létrehozás ideje: 2018. Már 17. 13:04
-- Kiszolgáló verziója: 10.1.30-MariaDB
-- PHP verzió: 7.0.27
SET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = \"+00:00\";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Adatbázis: `test`
--
-- --------------------------------------------------------
--
-- Tábla szerkezet ehhez a táblához `ajtok`
--
CREATE TABLE `ajtok` (
`ID` int(11) NOT NULL,
`aID` int(11) NOT NULL,
`bePosX` float NOT NULL,
`bePosY` float NOT NULL,
`bePosZ` float NOT NULL,
`beInt` int(11) NOT NULL,
`kiPosX` float NOT NULL,
`kiPosY` float NOT NULL,
`kiPosZ` float NOT NULL,
`kiInt` int(11) NOT NULL,
`Hasznalatban` int(11) NOT NULL,
`Nev` text NOT NULL,
`Letrehozta` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tábla szerkezet ehhez a táblához `bizek`
--
CREATE TABLE `bizek` (
`ID` int(11) NOT NULL,
`bTulaj` text NOT NULL,
`bMasodTulaj` text NOT NULL,
`Hasznalatban` int(11) NOT NULL,
`bTipusID` int(11) NOT NULL,
`bTipus` text NOT NULL,
`bElado` int(11) NOT NULL,
`bAr` int(11) NOT NULL,
`bePosX` float NOT NULL,
`bePosY` float NOT NULL,
`bePosZ` float NOT NULL,
`beInt` int(11) NOT NULL,
`SzefTargyNev` text NOT NULL,
`SzefTargyDarab` text NOT NULL,
`bTargyDarab` text NOT NULL,
`bTargyNev` text NOT NULL,
`bNyitva` int(11) NOT NULL,
`VanSzef` int(1) NOT NULL,
`bBelepesiAr` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tábla szerkezet ehhez a táblához `eldobottitemek`
--
CREATE TABLE `eldobottitemek` (
`ID` int(11) NOT NULL,
`Eldobta` text NOT NULL,
`PosX` float NOT NULL,
`PosY` float NOT NULL,
`PosZ` float NOT NULL,
`EldobottTargy` int(11) NOT NULL,
`Darabszam` int(11) NOT NULL,
`eID` int(11) NOT NULL,
`iVW` int(11) NOT NULL,
`Hasznalatban` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tábla szerkezet ehhez a táblához `hazak`
--
CREATE TABLE `hazak` (
`ID` int(11) NOT NULL,
`hTulaj` text NOT NULL,
`bePosX` float DEFAULT NULL,
`bePosY` float DEFAULT NULL,
`bePosZ` float DEFAULT NULL,
`beInt` int(11) DEFAULT NULL,
`kiPosX` float DEFAULT NULL,
`kiPosY` float DEFAULT NULL,
`kiPosZ` float DEFAULT NULL,
`kiInt` int(11) DEFAULT NULL,
`Hasznalatban` int(11) NOT NULL,
`hAjto` int(11) NOT NULL,
`VanTulaja` int(11) NOT NULL,
`hTipus` int(11) NOT NULL,
`hAr` int(11) NOT NULL,
`gbePosX` float NOT NULL,
`gbePosY` float NOT NULL,
`gbePosZ` float NOT NULL,
`gbePosA` float NOT NULL,
`VanGarazs` int(11) NOT NULL,
`GarazsKocs` int(11) NOT NULL,
`GarazsAjto` int(11) NOT NULL,
`hVW` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tábla szerkezet ehhez a táblához `inventory`
--
CREATE TABLE `inventory` (
`pName` text NOT NULL,
`InvItemName0` text NOT NULL,
`InvItemName1` text NOT NULL,
`InvItemName2` text NOT NULL,
`InvItemName3` text NOT NULL,
`InvItemName4` text NOT NULL,
`ID` int(11) NOT NULL,
`InvItemDarab0` int(11) DEFAULT NULL,
`InvItemDarab1` int(11) DEFAULT NULL,
`InvItemDarab2` int(11) DEFAULT NULL,
`InvItemDarab3` int(11) DEFAULT NULL,
`InvItemDarab4` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tábla szerkezet ehhez a táblához `jarmuvek`
--
CREATE TABLE `jarmuvek` (
`cID` int(11) NOT NULL,
`vID` int(11) NOT NULL,
`Tulaja` text NOT NULL,
`VanTulaja` int(11) NOT NULL,
`JarmuX` float NOT NULL,
`JarmuY` float NOT NULL,
`JarmuZ` float NOT NULL,
`JarmuA` float NOT NULL,
`Szin1` int(11) NOT NULL,
`Szin2` int(11) NOT NULL,
`JarmuHP` float NOT NULL,
`KocsiAra` int(11) NOT NULL,
`Model` int(11) NOT NULL,
`Hasznalatban` int(11) NOT NULL,
`Rendszam` text NOT NULL,
`Motor` int(11) NOT NULL,
`MunkaKocsi` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tábla szerkezet ehhez a táblához `jatekosok`
--
CREATE TABLE `jatekosok` (
`id` int(11) NOT NULL,
`PosX` float NOT NULL,
`PosY` float NOT NULL,
`PosZ` float NOT NULL,
`pInt` int(11) NOT NULL,
`pVW` int(11) NOT NULL,
`pLevel` int(11) NOT NULL,
`pJatszottOrak` int(11) NOT NULL,
`pAdmin` int(11) NOT NULL,
`pNem` int(11) NOT NULL,
`pKor` int(11) NOT NULL,
`pMoney` int(11) NOT NULL DEFAULT \'120\',
`pJelszo` text NOT NULL,
`pName` text NOT NULL,
`pSkin` int(11) NOT NULL,
`pSkin2` int(11) NOT NULL,
`pArmour` float NOT NULL,
`pHealth` float NOT NULL DEFAULT \'100\',
`pHazID` int(11) NOT NULL,
`MostRegisztralt` int(11) NOT NULL,
`TaskaNala` int(11) NOT NULL,
`Flood` int(10) NOT NULL,
`BuszBerlet` int(11) NOT NULL,
`BuszJegy` int(11) NOT NULL,
`pBszBejelentkezve` int(11) NOT NULL,
`pRegStep` int(11) NOT NULL,
`Taska` int(11) NOT NULL,
`pEhseg` int(11) NOT NULL,
`pSzomjusag` int(11) NOT NULL,
`pKorhazban` int(11) NOT NULL,
`KorhazIdo` int(11) NOT NULL,
`pKorhazTimer` int(11) NOT NULL,
`pSajatHazabanVan` int(11) NOT NULL,
`RegisztracioDatum` text NOT NULL,
`RegisztracioDatumOra` text NOT NULL,
`pKocsiKulcs` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Indexek a kiírt táblákhoz
--
--
-- A tábla indexei `ajtok`
--
ALTER TABLE `ajtok`
ADD PRIMARY KEY (`ID`);
--
-- A tábla indexei `bizek`
--
ALTER TABLE `bizek`
ADD PRIMARY KEY (`ID`);
--
-- A tábla indexei `eldobottitemek`
--
ALTER TABLE `eldobottitemek`
ADD PRIMARY KEY (`ID`);
--
-- A tábla indexei `hazak`
--
ALTER TABLE `hazak`
ADD PRIMARY KEY (`ID`);
--
-- A tábla indexei `inventory`
--
ALTER TABLE `inventory`
ADD PRIMARY KEY (`ID`);
--
-- A tábla indexei `jarmuvek`
--
ALTER TABLE `jarmuvek`
ADD PRIMARY KEY (`cID`);
--
-- A tábla indexei `jatekosok`
--
ALTER TABLE `jatekosok`
ADD PRIMARY KEY (`id`);
--
-- A kiírt táblák AUTO_INCREMENT értéke
--
--
-- AUTO_INCREMENT a táblához `ajtok`
--
ALTER TABLE `ajtok`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT a táblához `bizek`
--
ALTER TABLE `bizek`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT a táblához `eldobottitemek`
--
ALTER TABLE `eldobottitemek`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT a táblához `hazak`
--
ALTER TABLE `hazak`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT a táblához `inventory`
--
ALTER TABLE `inventory`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT a táblához `jarmuvek`
--
ALTER TABLE `jarmuvek`
MODIFY `cID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT a táblához `jatekosok`
--
ALTER TABLE `jatekosok`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
