Problema bizuri

Dynamic · June 10, 2017

Salutare,

Am un gamemode mysql r39-2 si problema este ca, atunci cand dau /edit la un biz sa ii schimb levelu sau descrierea, etc.. sau daca-l cumpar toate bizurile au in baza de date acelasi id, nume, pozitie(entx, enty, entz, extx, exty, extz). M-am tot chinuit am incercat o gramada de metode.

Edited June 10, 2017 by Dynamic

Banditul · June 10, 2017

Arata-ne query-urile care sunt la acel edit biz. Probabil sa fie de ala ele

Dynamic · June 11, 2017

public LoadBizz()
{
new idx;
	new Cache: r = mysql_query( mysql_db, "SELECT * FROM `bizz`" );
	if( !cache_get_row_count( mysql_db ) ) return cache_delete( r ), print( "Nu ai niciun biz in baza de date." );
	for( new i = 0; i < cache_get_row_count( mysql_db ); i++ ){
	
			BizzInfo[i][bOwned] = cache_get_field_content_int( i, "Owned", mysql_db );
		cache_get_field_content( i, "Owner", BizzInfo[i][bOwner], mysql_db, MAX_PLAYER_NAME );
		cache_get_field_content( i, "Message", BizzInfo[i][bMessage], mysql_db, MAX_PLAYER_NAME );
		cache_get_field_content( i, "Extortion", BizzInfo[i][bExtortion], mysql_db, MAX_PLAYER_NAME );
		BizzInfo[i][bEntranceX] = cache_get_field_content_float( i, "EntX", mysql_db );
		BizzInfo[i][bEntranceY] = cache_get_field_content_float( i, "EntY", mysql_db );
		BizzInfo[i][bEntranceZ] = cache_get_field_content_float( i, "EntZ", mysql_db );
		BizzInfo[i][bExitX] = cache_get_field_content_float( i, "ExtX", mysql_db );
		BizzInfo[i][bExitY] = cache_get_field_content_float( i, "ExtY", mysql_db );
		BizzInfo[i][bExitZ] = cache_get_field_content_float( i, "ExtZ", mysql_db );
		BizzInfo[i][bLevelNeeded] = cache_get_field_content_int( i, "Level", mysql_db );
		BizzInfo[i][bBuyPrice] = cache_get_field_content_int( i, "Price", mysql_db );
		BizzInfo[i][bEntranceCost] = cache_get_field_content_int( i, "EPrice", mysql_db );
		BizzInfo[i][bTill] = cache_get_field_content_int( i, "Till", mysql_db );
		BizzInfo[i][bLocked] = cache_get_field_content_int( i, "Locked", mysql_db );
		BizzInfo[i][bInterior] = cache_get_field_content_int( i, "Interior", mysql_db );
		BizzInfo[i][bProducts] = cache_get_field_content_int( i, "Products", mysql_db );
		BizzInfo[i][bMaxProducts] = cache_get_field_content_int( i, "MaxProducts", mysql_db );
		BizzInfo[i][bPriceProd] = cache_get_field_content_int( i, "ProductPrice", mysql_db );
			printf("BizzInfo:%d Owner:%s Message:%s Entfee:%d Till:%d Products:%d/%d Interior:%d.\n",
			idx,
			BizzInfo[idx][bOwner],
			BizzInfo[idx][bMessage],
			BizzInfo[idx][bEntranceCost],
			BizzInfo[idx][bTill],
			BizzInfo[idx][bProducts],
			BizzInfo[idx][bMaxProducts],
			BizzInfo[idx][bInterior]);
			idx++;
		}
		cache_delete( r );
	return 1;
}

public OnPropUpdate()
{
	new Cache: r = mysql_query( mysql_db, "SELECT * FROM `bizz`" );
	if( cache_get_row_count( mysql_db ) ){
		idx = 0;
		for( new i = 0; i < cache_get_row_count( mysql_db ); i++ ){
			idx = cache_get_field_content_int( i, "ID", mysql_db ) - 1;
			format( string, sizeof(string), "UPDATE `bizz` SET `Owned` = %d, `Owner` = '%s', `Message` = '%s', `Extortion` = '%s', EntX = %f, EntY = %f, EntZ = %f, ExtX = %f, ExtY = %f, ExtZ = %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]);
		
  mysql_tquery( mysql_db, string );
		
		if(BizzInfo[idx][bOwned] == 0)
			{
				format(string, sizeof(string), "{2EAD15}%s\n {2EAD15} For Sale\n {2EAD15}Level: {FFFFFF}%d\n {2EAD15}Valoare: {FFFFFF}%d\n{2EAD15} /buybiz",BizzInfo[idx][bMessage],BizzInfo[idx][bLevelNeeded],BizzInfo[idx][bBuyPrice]);
			}
			else
			{
				format(string, sizeof(string), "{F5E618}%s\n {F5E618}Owner: {FFFFFF}%s\n {F5E618}Exto: {FFFFFF}%s\n {F5E618}Level: {FFFFFF}%d\n {F5E618}Fee: {FFFFFF}%d\n {F5E618}Valoare: {FFFFFF}%d\n{F5E618} Press Enter or F",BizzInfo[idx][bMessage],BizzInfo[idx][bOwner],BizzInfo[idx][bExtortion],BizzInfo[idx][bLevelNeeded],BizzInfo[idx][bEntranceCost],BizzInfo[idx][bBuyPrice]);
			}
			Update3DTextLabelText(BizLabel[idx] ,0x008080FF, string);
		}
	}
	cache_delete( r );

Banditul · June 11, 2017

public OnPropUpdate()
{
    new Cache: r = mysql_query( mysql_db, "SELECT `ID` FROM `bizz`" );
    new rows = cache_get_row_count( mysql_db ), SQLID;
    if( rows >=  1 )
    {
        idx = 0;
        for( new i = 0; i < rows; i++ )
        {
            idx = cache_get_field_content_int( i, "ID", mysql_db ) - 1;
            SQLID = cache_get_field_content_int( i, "ID", mysql_db );
            mysql_format( mysql_db, string, sizeof(string), "UPDATE `bizz` SET `Owned` = %d, `Owner` = '%e', `Message` = '%e', `Extortion` = '%e', EntX = %f, EntY = %f, EntZ = %f, ExtX = %f, ExtY = %f, ExtZ = %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])
            SQLID;
        
            mysql_tquery( mysql_db, string );
        
            if(BizzInfo[idx][bOwned] == 0)
            {
                format(string, sizeof(string), "{2EAD15}%s\n {2EAD15} For Sale\n {2EAD15}Level: {FFFFFF}%d\n {2EAD15}Valoare: {FFFFFF}%d\n{2EAD15} /buybiz",BizzInfo[idx][bMessage],BizzInfo[idx][bLevelNeeded],BizzInfo[idx][bBuyPrice]);
            }
            else
            {
                format(string, sizeof(string), "{F5E618}%s\n {F5E618}Owner: {FFFFFF}%s\n {F5E618}Exto: {FFFFFF}%s\n {F5E618}Level: {FFFFFF}%d\n {F5E618}Fee: {FFFFFF}%d\n {F5E618}Valoare: {FFFFFF}%d\n{F5E618} Press Enter or F",BizzInfo[idx][bMessage],BizzInfo[idx][bOwner],BizzInfo[idx][bExtortion],BizzInfo[idx][bLevelNeeded],BizzInfo[idx][bEntranceCost],BizzInfo[idx][bBuyPrice]);
            }
            Update3DTextLabelText(BizLabel[idx] ,0x008080FF, string);
        }
    }
    cache_delete( r );
}

Iti lipsea id-ul bizului din clauza WHERE , adica nu stia la ce id sa updateze asa ca o facea la toate.

public LoadBizz()
{
    new idx;
    new Cache: r = mysql_query( mysql_db, "SELECT * FROM `bizz`" ) , rows = cache_get_row_count( mysql_db );
    if( !cache_get_row_count( mysql_db ) ) return cache_delete( r ), print( "Nu ai niciun biz in baza de date." );
    for( new i = 0; i < rows; i++ )
    {
    
        BizzInfo[i][bOwned] = cache_get_field_content_int( i, "Owned", mysql_db );
        cache_get_field_content( i, "Owner", BizzInfo[i][bOwner], mysql_db, MAX_PLAYER_NAME );
        cache_get_field_content( i, "Message", BizzInfo[i][bMessage], mysql_db, MAX_PLAYER_NAME );
        cache_get_field_content( i, "Extortion", BizzInfo[i][bExtortion], mysql_db, MAX_PLAYER_NAME );
        BizzInfo[i][bEntranceX] = cache_get_field_content_float( i, "EntX", mysql_db );
        BizzInfo[i][bEntranceY] = cache_get_field_content_float( i, "EntY", mysql_db );
        BizzInfo[i][bEntranceZ] = cache_get_field_content_float( i, "EntZ", mysql_db );
        BizzInfo[i][bExitX] = cache_get_field_content_float( i, "ExtX", mysql_db );
        BizzInfo[i][bExitY] = cache_get_field_content_float( i, "ExtY", mysql_db );
        BizzInfo[i][bExitZ] = cache_get_field_content_float( i, "ExtZ", mysql_db );
        BizzInfo[i][bLevelNeeded] = cache_get_field_content_int( i, "Level", mysql_db );
        BizzInfo[i][bBuyPrice] = cache_get_field_content_int( i, "Price", mysql_db );
        BizzInfo[i][bEntranceCost] = cache_get_field_content_int( i, "EPrice", mysql_db );
        BizzInfo[i][bTill] = cache_get_field_content_int( i, "Till", mysql_db );
        BizzInfo[i][bLocked] = cache_get_field_content_int( i, "Locked", mysql_db );
        BizzInfo[i][bInterior] = cache_get_field_content_int( i, "Interior", mysql_db );
        BizzInfo[i][bProducts] = cache_get_field_content_int( i, "Products", mysql_db );
        BizzInfo[i][bMaxProducts] = cache_get_field_content_int( i, "MaxProducts", mysql_db );
        BizzInfo[i][bPriceProd] = cache_get_field_content_int( i, "ProductPrice", mysql_db );
        printf("BizzInfo:%d Owner:%s Message:%s Entfee:%d Till:%d Products:%d/%d Interior:%d.\n",
        idx,
        BizzInfo[idx][bOwner],
        BizzInfo[idx][bMessage],
        BizzInfo[idx][bEntranceCost],
        BizzInfo[idx][bTill],
        BizzInfo[idx][bProducts],
        BizzInfo[idx][bMaxProducts],
        BizzInfo[idx][bInterior]);
        idx++;
    }
    cache_delete( r );
    return 1;
}

Dynamic · June 11, 2017

a dat un warning 215: expression has no efect la linia

BizzInfo[idx][bPriceProd])
            SQLID;

Am modificat eu, am pus , dupa [bPriceProd] si am inchis paranteza dupa SQLID.

Sa-mi ziceti daca e bine

BizzInfo[idx][bPriceProd],

SQLID);

A compilat perfect dar cand dau /sellbiz, /buybiz, /edit, /asellbiz nu se modifica in baza de date levelul,bani,owner etc..

Pe server merge sa modifici, dar in baza de date nu se schimba, cred ca tot la OnPropUpdate e problema.

Edited June 12, 2017 by Dynamic

Sign In

Problema bizuri

Question

Dynamic

4 answers to this question

Recommended Posts

Banditul

Dynamic

Banditul

Dynamic

Create an account or sign in to comment

Create an account

Sign in

Similar Content

Actualizare textdraw (speedometer) la secunda (problema)

Problema /vehicles

Problema billboards (la expirarea billboard-ului nu seteaza variabila Billboard 0 jucatorului offline)

Problema clan members: Nu afiseaza membrii.

Problema dialog dealership (nu afiseaza ID-ul masinii)

Recently Browsing 0 members

Browse

Activity

Important Information