baza

[KoBBy]

Imi poate da si mie fisierul .sql pentru sistemul de garaje creat de Edison?

 

Sau sa imi spuna ce coloane sa fac.

Edited January 15, 2018 by KoBBy

[MiritaXD]

	function LoadGarages() {
    new Cache: db = mysql_query(SQL, "SELECT * FROM `garages`");
    new x, result[126];
     for(new i, j = cache_get_row_count (); i != j; ++i) {
        garages ++;
           cache_get_field_content(i, "ID", result); x = strval(result), garageInfo[garages][gID] = x;
           cache_get_field_content(i, "Owner", result); format(garageInfo[x][gOwner], 32, result);
         cache_get_field_content(i, "UserID", result); garageInfo[x][gUserID] = strval(result);
        cache_get_field_content(i, "Price", result); garageInfo[x][gPrice] = strval(result);
	        garageInfo[x][gPos][0] = cache_get_field_content_float(i, "X"); 
           garageInfo[x][gPos][1] = cache_get_field_content_float(i, "Y");
           garageInfo[x][gPos][2] = cache_get_field_content_float(i, "Z"); 
        garageInfo[x][gAngle] = cache_get_field_content_float(i, "Angle"); 
	           garageInfo[x][gVirtualID] = x;    
	           garageInfo[x][gPickup] = CreateDynamicPickup(1277, 23, garageInfo[x][gPos][0], garageInfo[x][gPos][1], garageInfo[x][gPos][2]);
           garage_label(x);     
    }
    printf("Garages loaded: %d", garages);
    cache_delete(db);
    return 1;
}

[KoBBy]

La 1/16/2018 la 11:30, MiritaXD a spus:

 

	function LoadGarages() {
    new Cache: db = mysql_query(SQL, "SELECT * FROM `garages`");
    new x, result[126];
     for(new i, j = cache_get_row_count (); i != j; ++i) {
        garages ++;
           cache_get_field_content(i, "ID", result); x = strval(result), garageInfo[garages][gID] = x;
           cache_get_field_content(i, "Owner", result); format(garageInfo[x][gOwner], 32, result);
         cache_get_field_content(i, "UserID", result); garageInfo[x][gUserID] = strval(result);
        cache_get_field_content(i, "Price", result); garageInfo[x][gPrice] = strval(result);
	        garageInfo[x][gPos][0] = cache_get_field_content_float(i, "X"); 
           garageInfo[x][gPos][1] = cache_get_field_content_float(i, "Y");
           garageInfo[x][gPos][2] = cache_get_field_content_float(i, "Z"); 
        garageInfo[x][gAngle] = cache_get_field_content_float(i, "Angle"); 
	           garageInfo[x][gVirtualID] = x;    
	           garageInfo[x][gPickup] = CreateDynamicPickup(1277, 23, garageInfo[x][gPos][0], garageInfo[x][gPos][1], garageInfo[x][gPos][2]);
           garage_label(x);     
    }
    printf("Garages loaded: %d", garages);
    cache_delete(db);
    return 1;
}

 

Ma refer la codul care sa il bag in PHPMYADMIn

[MiritaXD]

La 1/18/2018 la 21:08, KoBBy a spus:

Ma refer la codul care sa il bag in PHPMYADMIn

pai nu vezi modelu? Tabel

garages

dupa in acel tabel adaugi

ID, Owner, UserID, Price,X,Y,Z,Angel