[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.\");}
-- 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.27SET 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 */;
Szerző
Téma: Mysql tablázat hiba (Megtekintve 912 alkalommal)
