Cum pot trece turfs pe mysql

[CristisiCristiana]

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

Edited June 16, 2015 by CristisiCristiana

[Stark.sys]

1. Plugin MySQL folosit.

2. Ai host la server sau in localhost ?

[Punct.]

 @CristisiCristiana exact cum ai la Bizz/sBizz/..-uri faci si pentru teritorii. Dar, sa nu stergi ce ai pe dini, pui in comentariu pana reusesti sa faci sistemul functional pe MySQL. Doar ca trebuie sa modifici tot ce tine de incarcarea/salvarea/modificarea informatiilor la teritorii.

 

1. Plugin MySQL folosit.

2. Ai host la server sau in localhost ?

Cu ce te ajuta informatiile astea daca el nu are teritoriile in baza de date?

[CristisiCristiana]

Am unele chestii in mysql.Am sv pe host

[MrTuNNe]

1. Plugin MySQL folosit.

2. Ai host la server sau in localhost ?

Degeaba are host la server daca nu are baza de date oferita de la firma Multe firme nu prea ofera baza de date gratis

Trebuia sa te exprimi astfel: Ai baza de date de la host sau e localhost?

(Scuze de off-topic) 

[CristisiCristiana]

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

[Rappy]

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

In cazul asta uitate la case/bizzuri/masini , orice sistem care e pe mysql, si uitate cum se incarca/salveaza/modifica. La teritorii o sa fie asemanator.