Jump to content
  • 0

Mysql problema


Sealand123

Question

Problema intalnita (descriere): Am trecut niste functii pe mysql si nu vrea sa le citeasca pe cele de tip nume exemplu variabila owner are in database atribuita "Mihai.Samp" si nu vrea sa o citeasca
Ero(area / rile) / warning-(ul / urile): -
Liniile de cod / sursa / script-ul(obligatoriu):

asa e la ongamemodeinit

	new result[100], index = 0,strings[190];
    mysql_query("SELECT * FROM `roomhotel` ORDER BY `roomhotel`.`rID` ASC");
    mysql_store_result();
    while(mysql_retrieve_row())
    {
   			// LOADING DATA     \====================================================================/
			new i = index;
			mysql_get_field("ID", result);				CamInfo[i][rID] = strval(result);
	        mysql_get_field("Owner", result);			strmid(CamInfo[i][rOwner], result, 0, 100, 100);
	        mysql_get_field("PosX", result);			CamInfo[i][rPosX] = floatstr(result);
			mysql_get_field("PosY", result);			CamInfo[i][rPosY] = floatstr(result);
	        mysql_get_field("PosZ", result);			CamInfo[i][rPosZ] = floatstr(result);
	        mysql_get_field("Interior", result);		CamInfo[i][rInterior] = strval(result);
      		format(strings, sizeof(strings), "Ownerul este: %s",CamInfo[i][rOwner]);
   			Camera[i] = Create3DTextLabel(strings,0xFFFFFFAA,CamInfo[i][rPosX],CamInfo[i][rPosY],CamInfo[i][rPosZ],6.0,0);
			i++;

	}

Nu mi se afiseaza numele detinatorului intr-un 3dtextlabel

format(string, sizeof(string), "Chirias: %s"CamInfo[i][rOwner]);
		            Update3DTextLabelText(Camera[i], 0xFFFFFFFF, string);

 

apoi  am facut o comanda directa sa vad daca merge si nu merge nu scrie decat camera

if (strcmp(cmd, "/camera0", true) == 0)
    {
        format(string,sizeof(string), "camera %s",CamInfo[0][rOwner]);
        SendClientMessage(playerid,-1,string);
     
       }

Imagini / Video (optional): http://i.imgur.com/nW4kVvq.png asa e in phpmyadmin
Ati incercat sa rezolvati singur?:

Edited by Sealand123
Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0

Da, o poti declara asa cel mai bine

 

rOwner[MAX_PLAYER_NAME];

 

Edited by Alexander.
  • Upvote 1

Caut un om serios cu gamemode acceptabil, cu capabilitatea de a tine un host, serviciile oferite de mine sunt de scripter (experienta de 5 ani in C/C++ limbajul folosit de SA:MP). Nu am pretentii la bani, doar un server si un parteneriat frumos. Pentru mai multe detalii accept pm-uri.

 

Universitatea de Vest din Timisoara,

Facultatea de Matematica si Informatica

Informatica aplicata, Anul I

Link to comment
Share on other sites

  • 0

Arata-ne cum ai creat varibila rOwner de la enum rInfo.

  • Upvote 1

Caut un om serios cu gamemode acceptabil, cu capabilitatea de a tine un host, serviciile oferite de mine sunt de scripter (experienta de 5 ani in C/C++ limbajul folosit de SA:MP). Nu am pretentii la bani, doar un server si un parteneriat frumos. Pentru mai multe detalii accept pm-uri.

 

Universitatea de Vest din Timisoara,

Facultatea de Matematica si Informatica

Informatica aplicata, Anul I

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.