CristisiCristiana

Am host de la zeroping.Am baza de date.Am doar unele chestii in mysql trecute de cine a creeat gm

Am unele chestii in mysql.Am sv pe host

Problema intalnita (descriere):M-am apucat de scripting SA-MP dupa ce am vazut ca fratele meu are un sv.Am descarcat si eu un gamemode care imi place si l-am rugat pe el la mi-l instaleze.Enervant e ca turf-urile sunt dini si de multe ori raman fara unele.In mysql ma pricep eu sa fac in baza de date dar in gm nu.Speram sa ma ajutati voi.Ero(area / rile) / warning-(ul / urile):-Liniile de cod / sursa / script-ul(obligatoriu): public LoadGang() { new arrCoords[3][64]; new strFromFile2[256]; new File: file = fopen("Configs/gangzones.cfg", io_read); if (file) { new idx=0; while (idx < sizeof(GangInfo)) { fread(file, strFromFile2); split(strFromFile2, arrCoords, ','); GangInfo[idx][gID] = strval(arrCoords[0]); GangInfo[idx][gFaction] = strval(arrCoords[1]); GangInfo[idx][gHours] = strval(arrCoords[2]); printf("GangZone:%d Owner:%d Hours Left: %d",GangInfo[idx][gID],GangInfo[idx][gFaction], GangInfo[idx][gHours]); idx++; } fclose(file); } return 1; }si public OnPropUpdate() { new File: file2; new string[ 256 * 10 ]; new idx; new index = 0; new query[256]; format(query, sizeof(query), "SELECT * FROM `sbizz` ORDER BY `sbizz`.`ID` ASC"); mysql_query(query); mysql_store_result(); idx = 0; while(mysql_retrieve_row()) { index++; idx = index - 1; format( string, sizeof(string), "UPDATE `sbizz` SET `Owned` = %d, `Owner` = '%s', `Message` = '%s', `Extortion` = '%s', EntX = %f, EntY = %f, EntZ = %f, ExitX = %f, ExitY = %f, ExitZ = %f, Level = %d, Price = %d, EPrice = %d, Till = %d, Locked = %d, Interior = %d, Products = %d, MaxProducts = %d, ProductPrice = %d WHERE ID = %d", SBizzInfo[idx][sbOwned], SBizzInfo[idx][sbOwner], SBizzInfo[idx][sbMessage], SBizzInfo[idx][sbExtortion], SBizzInfo[idx][sbEntranceX], SBizzInfo[idx][sbEntranceY], SBizzInfo[idx][sbEntranceZ], SBizzInfo[idx][sbExitX], SBizzInfo[idx][sbExitY], SBizzInfo[idx][sbExitZ], SBizzInfo[idx][sbLevelNeeded], SBizzInfo[idx][sbBuyPrice], SBizzInfo[idx][sbEntranceCost], SBizzInfo[idx][sbTill], SBizzInfo[idx][sbLocked], SBizzInfo[idx][sbInterior], SBizzInfo[idx][sbProducts], SBizzInfo[idx][sbMaxProducts], SBizzInfo[idx][sbPriceProd], idx); mysql_query(query); } while(mysql_retrieve_row()) { index++; idx = index - 1; format( string, sizeof(string), "UPDATE `bizz` SET `Owned` = %d, `Owner` = '%s', `Message` = '%s', `Extortion` = '%s', EntX = %f, EntY = %f, EntZ = %f,ExitX = %f, ExitY = %f, ExitZ = %f, Level = %d, Price = %d, EPrice = %d, Till = %d, Locked = %d, Interior = %d, Products = %d, MaxProducts = %d, ProductPrice = %d WHERE ID = %d", BizzInfo[idx][bOwned], BizzInfo[idx][bOwner], BizzInfo[idx][bMessage], BizzInfo[idx][bExtortion], BizzInfo[idx][bEntranceX], BizzInfo[idx][bEntranceY], BizzInfo[idx][bEntranceZ], BizzInfo[idx][bExitX], BizzInfo[idx][bExitY], BizzInfo[idx][bExitZ], BizzInfo[idx][bLevelNeeded], BizzInfo[idx][bBuyPrice], BizzInfo[idx][bEntranceCost], BizzInfo[idx][bTill], BizzInfo[idx][bLocked], BizzInfo[idx][bInterior], BizzInfo[idx][bProducts], BizzInfo[idx][bMaxProducts], BizzInfo[idx][bPriceProd], idx); mysql_query(query); } idx = 1; while (idx < sizeof(GangInfo)) { new coordsstring[256]; format(coordsstring, sizeof(coordsstring), "%d,%d,%d\n", GangInfo[idx][gID],// GangInfo[idx][gFaction], GangInfo[idx][gHours]);// if(idx == 1) { file2 = fopen("Configs/gangzones.cfg", io_write); } else { file2 = fopen("Configs/gangzones.cfg", io_append); } fwrite(file2, coordsstring); idx++; fclose(file2); } idx = 2; while (idx < sizeof(Bank)) { new coordsstring[256]; format(coordsstring, sizeof(coordsstring), "%d,%d\n", Bank[idx][bankID],// Bank[idx][bankHours]);// if(idx == 1) { file2 = fopen("Configs/bank.cfg", io_write); } else { file2 = fopen("Configs/bank.cfg", io_append); } fwrite(file2, coordsstring); idx++; fclose(file2); } return 1; }Imagini / Video (optional):-Ati incercat sa rezolvati singur?:Da, am facut in baza de date dar in pawn/pawno nu ma prea pricep.Raman dator daca ma puteti ajuta