17.08.2012, 20:44
i need a bit of help converting my script from file to MYSQL
this is my load script
this is my save script
this is my load script
Код:
LoadProperty() { new arrCoords[38][64]; new strFromFile2[256]; new File: file = fopen("/config/property.cfg", io_read); if (file) { new idx; while (idx < sizeof(HouseInfo)) { fread(file, strFromFile2); split(strFromFile2, arrCoords, ','); HouseInfo[idx][hEntrancex] = floatstr(arrCoords[0]); HouseInfo[idx][hEntrancey] = floatstr(arrCoords[1]); HouseInfo[idx][hEntrancez] = floatstr(arrCoords[2]); HouseInfo[idx][hExitx] = floatstr(arrCoords[3]); HouseInfo[idx][hExity] = floatstr(arrCoords[4]); HouseInfo[idx][hExitz] = floatstr(arrCoords[5]); HouseInfo[idx][hHealthx] = strval(arrCoords[6]); HouseInfo[idx][hHealthy] = strval(arrCoords[7]); HouseInfo[idx][hHealthz] = strval(arrCoords[8]); HouseInfo[idx][hArmourx] = strval(arrCoords[9]); HouseInfo[idx][hArmoury] = strval(arrCoords[10]); HouseInfo[idx][hArmourz] = strval(arrCoords[11]); //printf("HouseInfo hEntrancez %f",HouseInfo[idx][hEntrancez]); strmid(HouseInfo[idx][hOwner], arrCoords[12], 0, strlen(arrCoords[12]), 255); strmid(HouseInfo[idx][hDiscription], arrCoords[13], 0, strlen(arrCoords[13]), 255); HouseInfo[idx][hValue] = strval(arrCoords[14]); HouseInfo[idx][hHel] = strval(arrCoords[15]); HouseInfo[idx][hArm] = strval(arrCoords[16]); HouseInfo[idx][hInt] = strval(arrCoords[17]); HouseInfo[idx][hLock] = strval(arrCoords[18]); HouseInfo[idx][hOwned] = strval(arrCoords[19]); HouseInfo[idx][hRooms] = strval(arrCoords[20]); HouseInfo[idx][hRent] = strval(arrCoords[21]); HouseInfo[idx][hRentabil] = strval(arrCoords[22]); HouseInfo[idx][hTakings] = strval(arrCoords[23]); HouseInfo[idx][hVec] = strval(arrCoords[24]); if(HouseInfo[idx][hVec] == 411) { HouseInfo[idx][hVec] = 411; } HouseInfo[idx][hVcol1] = strval(arrCoords[25]); HouseInfo[idx][hVcol2] = strval(arrCoords[26]); HouseInfo[idx][hDate] = strval(arrCoords[27]); HouseInfo[idx][hStartLevel] = strval(arrCoords[28]); //This should read the old "hLevel" hLevel is now temp. HouseInfo[idx][hLevel] = strval(arrCoords[29]); HouseInfo[idx][hRC] = strval(arrCoords[30]); HouseInfo[idx][hGarbage] = strval(arrCoords[31]); HouseInfo[idx][hVecx] = floatstr(arrCoords[32]); HouseInfo[idx][hVecy] = floatstr(arrCoords[33]); HouseInfo[idx][hVecz] = floatstr(arrCoords[34]); HouseInfo[idx][hVecr] = floatstr(arrCoords[35]); strmid(HouseInfo[idx][hPlate], arrCoords[36], 0, strlen(arrCoords[36]), 8); HouseInfo[idx][hBPlate] = floatstr(arrCoords[37]); //HouseInfo[idx][hPlate] = floatstr(arrCoords[37]); //HouseInfo[idx] printf("HouseInfo:%d Owner:%s hTakings %d hVec %d",idx,HouseInfo[idx][hOwner],HouseInfo[idx][hTakings],HouseInfo[idx][hVec]); idx++; } } fclose(file); // return 1; }
Код:
OnPropUpdate() { if (gdebug >= 1){printf("DEBUG OnPropUpdate()");} new idx; new File: file2; while (idx < sizeof(HouseInfo)) { new coordsstring[512]; format(coordsstring, sizeof(coordsstring), "%f,%f,%f,%f,%f,%f,%d,%d,%d,%d,%d,%d,%s,%s,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%f,%f,%f,%f,%s,%d\n", HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez], HouseInfo[idx][hExitx], HouseInfo[idx][hExity], HouseInfo[idx][hExitz], HouseInfo[idx][hHealthx], HouseInfo[idx][hHealthy], HouseInfo[idx][hHealthz], HouseInfo[idx][hArmourx], HouseInfo[idx][hArmoury], HouseInfo[idx][hArmourz], HouseInfo[idx][hOwner], HouseInfo[idx][hDiscription], HouseInfo[idx][hValue], HouseInfo[idx][hHel], HouseInfo[idx][hArm], HouseInfo[idx][hInt], HouseInfo[idx][hLock], HouseInfo[idx][hOwned], HouseInfo[idx][hRooms], HouseInfo[idx][hRent], HouseInfo[idx][hRentabil], HouseInfo[idx][hTakings], HouseInfo[idx][hVec], HouseInfo[idx][hVcol1], HouseInfo[idx][hVcol2], HouseInfo[idx][hDate], HouseInfo[idx][hStartLevel], HouseInfo[idx][hLevel], HouseInfo[idx][hRC], HouseInfo[idx][hGarbage], HouseInfo[idx][hVecx], HouseInfo[idx][hVecy], HouseInfo[idx][hVecz], HouseInfo[idx][hVecr], HouseInfo[idx][hPlate], HouseInfo[idx][hBPlate] ); if(idx == 0) { file2 = fopen("/config/property.cfg", io_write); } else { file2 = fopen("/config/property.cfg", io_append); } fwrite(file2, coordsstring); idx++; fclose(file2); }