Mysql r5 pe r39-3

Jimmi · July 23, 2015

Problema intalnita (descriere): M-am gandit sa trec si eu dupa 6 luni de server pe r39-3.Nu ma prea descurc dar incerc si eu...
Ero(area / rile) / warning-(ul / urile): Sunt mai multe si al sbiz-uri dar acolo le rezolv eu daca am un model
Liniile de cod / sursa / script-ul(obligatoriu):

public LoadBizz()
{
    new biss;
    new result[100],index = 0;
    new query[256];
    format(query, sizeof(query), "SELECT * FROM `bizz` ORDER BY `bizz`.`ID` ASC");
    mysql_query(query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        biss++;
        index++;
        new i = index;
        mysql_get_field("Owned", result);            BizzInfo[i][bOwned] = strval(result);//Scuze ca ma uit, dar nu am mai lucrat de ceva timp cu r6//no problem oricum n-aveam ce face
        mysql_get_field("Owner", result);            strmid(BizzInfo[i][bOwner], result, 0, 32, 32);
        mysql_get_field("Message", result);            strmid(BizzInfo[i][bMessage], result, 0, 60, 60);
        mysql_get_field("Extortion", result);       strmid(BizzInfo[i][bExtortion], result, 0, 32, 32);
        mysql_get_field("EntX", result);            BizzInfo[i][bEntranceX] = floatstr(result);
        mysql_get_field("EntY", result);            BizzInfo[i][bEntranceY] = floatstr(result);
        mysql_get_field("EntZ", result);            BizzInfo[i][bEntranceZ] = floatstr(result);
        mysql_get_field("ExitX", result);            BizzInfo[i][bExitX] = floatstr(result);
        mysql_get_field("ExitY", result);            BizzInfo[i][bExitY] = floatstr(result);
        mysql_get_field("ExitZ", result);            BizzInfo[i][bExitZ] = floatstr(result);
        mysql_get_field("Level", result);            BizzInfo[i][bLevelNeeded] = strval(result);
        mysql_get_field("Price", result);            BizzInfo[i][bBuyPrice] = strval(result);
        mysql_get_field("EPrice", result);            BizzInfo[i][bEntranceCost] = strval(result);
        mysql_get_field("Till", result);            BizzInfo[i][bTill] = strval(result);
        mysql_get_field("Locked", result);            BizzInfo[i][bLocked] = strval(result);
        mysql_get_field("Interior", result);        BizzInfo[i][bInterior] = strval(result);
        mysql_get_field("Products", result);        BizzInfo[i][bProducts] = strval(result);
        mysql_get_field("MaxProducts", result);        BizzInfo[i][bMaxProducts] = strval(result);
        mysql_get_field("ProductPrice", result);    BizzInfo[i][bPriceProd] = strval(result);
    }
    mysql_free_result();
    printf("[BIZZ]Au fost incarcate %d bizz-uri.Felicitari pentru reusita.[PG-ZONE.RO]", index);
    return 1;
}

Imagini / Video (optional):
Ati incercat sa rezolvati singur?: Da

Edited July 25, 2015 by jimmi

Jimmi · July 23, 2015

careva?

Jimmi · July 24, 2015

up

Tibixux · July 24, 2015

PM ME DATE CONTACT, IL POT TRECE PENTRU DOAR 3 EURO.

Jimmi · July 24, 2015

UP

Jimmi · July 25, 2015

up

Jimmi · July 26, 2015

Se mai uita cineva?am incercat sa fac dupa un sistem mai vechi dintr-un gm dar tot sunt erori...

public LoadBizz()
{
    new biss;
    new index = 0;
    new query[256];
    format(query,sizeof(query),"SELECT * FROM `bizz` ORDER BY `bizz`.`ID` ASC");
    mysql_tquery(handle, query, "", "");
    if(cache_get_row_count(handle))
    while(mysql_retrieve_row())
    {
        biss++;
        index++;
        new i = index;
        cache_get_field_content_int("Owned",            BizzInfo[i][bOwned] = strval(handle);
        cache_get_field_content_int("Owner",    strmid(BizzInfo[i][bOwner], handle, 0, 32, 32);
        cache_get_field_content_int("Message",            strmid(BizzInfo[i][bMessage], handle, 0, 60, 60);
        cache_get_field_content_int("Extortion",       strmid(BizzInfo[i][bExtortion], handle, 0, 32, 32);
        cache_get_field_content_int("EntX",             BizzInfo[i][bEntranceX] = floatstr(handle);
        cache_get_field_content_int("EntY",            BizzInfo[i][bEntranceY] = floatstr(handle);
        cache_get_field_content_int("EntZ",            BizzInfo[i][bEntranceZ] = floatstr(handle);
        cache_get_field_content_int("ExitX",            BizzInfo[i][bExitX] = floatstr(handle);
        cache_get_field_content_int("ExitY",        BizzInfo[i][bExitY] = floatstr(handle);
        cache_get_field_content_int("ExitZ",            BizzInfo[i][bExitZ] = floatstr(handle);
        cache_get_field_content_int("Level",            BizzInfo[i][bLevelNeeded] = strval(handle);
        cache_get_field_content_int("Price",            BizzInfo[i][bBuyPrice] = strval(handle);
        cache_get_field_content_int("EPrice",        BizzInfo[i][bEntranceCost] = strval(handle);
        cache_get_field_content_int("Till",             BizzInfo[i][bTill] = strval(handle);
        cache_get_field_content_int("Locked",             BizzInfo[i][bLocked] = strval(handle);
        cache_get_field_content_int("Interior",     BizzInfo[i][bInterior] = strval(handle);
        cache_get_field_content_int("Products",        BizzInfo[i][bProducts] = strval(handle);
        cache_get_field_content_int("MaxProducts",    BizzInfo[i][bMaxProducts] = strval(handle);
        cache_get_field_content_int("ProductPrice",    BizzInfo[i][bPriceProd] = strval(handle);
    }
    mysql_free_result();
    printf("[BIZZ]Au fost incarcate %d bizz-uri.Felicitari pentru reusita.[PG-ZONE.RO]", index);
    return 1;
}

Edited July 26, 2015 by jimmi

WiDuAlK · July 27, 2015

incearca ceva de genu:

public LoadBizz()
{
	new query[256], rows, fields, temp[200];
	cache_get_data(rows, fields, handle);
   
    mysql_format(handle,query,sizeof(query),"SELECT * FROM `bizz` ");
	mysql_query(handle, query);

	for (new i = 0; i < rows; i++)
    {
        BizzInfo[i + 1][bOwned] = cache_get_field_content(i,"Owned", temp);
		BizzInfo[i + 1][bOwner] = cache_get_field_content(i,"Owner", temp);
		//liniile tale
        BizzInfo[i + 1][bEntranceX] = cache_get_field_content_int(i, "EntX"); 
		// etc
    }
    printf("[BIZZ]Au fost incarcate %d bizz-uri.Felicitari pentru reusita.[PG-ZONE.RO]", rows);
    return 1;
}

WopsS · July 27, 2015

incearca ceva de genu:

public LoadBizz()
{
	new query[256], rows, fields, temp[200];
	cache_get_data(rows, fields, handle);
   
    mysql_format(handle,query,sizeof(query),"SELECT * FROM `bizz` ");
	mysql_query(handle, query);

	for (new i = 0; i < rows; i++)
    {
        BizzInfo[i + 1][bOwned] = cache_get_field_content(i,"Owned", temp);
		BizzInfo[i + 1][bOwner] = cache_get_field_content(i,"Owner", temp);
		//liniile tale
        BizzInfo[i + 1][bEntranceX] = cache_get_field_content_int(i, "EntX"); 
		// etc
    }
    printf("[BIZZ]Au fost incarcate %d bizz-uri.Felicitari pentru reusita.[PG-ZONE.RO]", rows);
    return 1;
}

Functia mea, hahahahaha.

Am pus-o eu mai jos explicata.

MySQL_LoadBusinesses()
{
	new Query[32 + 1], Rows, Cache:cache; // Initializam variabilele.

	mysql_format(MySQLHandle, Query, sizeof(Query), "SELECT * FROM `businesses`"); // Formatam un text pentru interogare.
	cache = mysql_query(MySQLHandle, Query, true); // Executam interogarea si rezultatul ei il pastram in cache.

	cache_set_active(cache); // Setam cache-ul activ pe variabila 'cache'.
	Rows = cache_num_rows(); // Preluam numarul de randuri stocate in cache.

	for (new i = 0; i < Rows; i++) // Mergem prin toate randurile.
	{
		BusinessInfo[i + 1][bMySQLID] = cache_get_field_content_int(i, "ID");// Preluam ID-ul afacerii din baza de date si il putem pe pozitia 'i + 1' pentru ca vrem sa plecam cu el de la 1.
		cache_get_field_content(i, "OwnerName", BusinessInfo[i + 1][bOwnerName]); // Preluam numele detinatorului.
		// etc..

	}

	cache_set_active(Cache:0); // Ne setam pe cache-ul 0 care nu este nimic.
	cache_delete(cache); // Stergem cache-ul din variabila 'cache' sa eliberam memoria.
}

Tu trebuie s-o adaptezi.

Eu acolo am

cache_set_active(cache);

pentru ca mai chem functii si din alte thread-uri. Nu stiu daca e necesar s-o pui.

WiDuAlK · July 28, 2015

Functia mea, hahahahaha.

Am pus-o eu mai jos explicata.

MySQL_LoadBusinesses()
{
	new Query[32 + 1], Rows, Cache:cache; // Initializam variabilele.

	mysql_format(MySQLHandle, Query, sizeof(Query), "SELECT * FROM `businesses`"); // Formatam un text pentru interogare.
	cache = mysql_query(MySQLHandle, Query, true); // Executam interogarea si rezultatul ei il pastram in cache.

	cache_set_active(cache); // Setam cache-ul activ pe variabila 'cache'.
	Rows = cache_num_rows(); // Preluam numarul de randuri stocate in cache.

	for (new i = 0; i < Rows; i++) // Mergem prin toate randurile.
	{
		BusinessInfo[i + 1][bMySQLID] = cache_get_field_content_int(i, "ID");// Preluam ID-ul afacerii din baza de date si il putem pe pozitia 'i + 1' pentru ca vrem sa plecam cu el de la 1.
		cache_get_field_content(i, "OwnerName", BusinessInfo[i + 1][bOwnerName]); // Preluam numele detinatorului.
		// etc..

	}

	cache_set_active(Cache:0); // Ne setam pe cache-ul 0 care nu este nimic.
	cache_delete(cache); // Stergem cache-ul din variabila 'cache' sa eliberam memoria.
}

Tu trebuie s-o adaptezi.

Eu acolo am

cache_set_active(cache);

pentru ca mai chem functii si din alte thread-uri. Nu stiu daca e necesar s-o pui.

pai de aceea nu am pus-o , pentru ca nu e necesar

NoNamed · August 1, 2015

Topic Closed . Inactivitate .

Sign In

Mysql r5 pe r39-3

Question

Jimmi

10 answers to this question

Recommended Posts

Jimmi

Jimmi

Tibixux

Jimmi

Jimmi

Jimmi

WiDuAlK

WopsS

WiDuAlK

NoNamed

Similar Content

Gamemode Hardgaming Versiunea a 4-a (no-mysql) 1 2

HardGaming V2-fara mysql

Recently Browsing 0 members

Browse

Activity

Important Information