[fakuivan]

Hi there!

I know that you can asign a dynamic array size like this int[] numbers = new int[somevar], so I tried to do the same with a string (1 byte array???) like this:

				stringsize = ((SQL_FetchSize(hQuery, 0)) + 1);
				ReplyToCommand(client, "[TFTDB] length: %i", stringsize);
				char[] phrase = new char[stringsize];
				SQL_FetchString(hQuery, 0, phrase, strlen(phrase));
				ReplyToCommand(client, "[TFTDB] phrase: %s", phrase);
				ReplyToCommand(client, "[TFTDB] strlen(phrase): %i", strlen(phrase));

and got this

[TFTDB] length: 29
[TFTDB] phrase:
[TFTDB] strlen(phrase): 0

I didn't used sizeof() because the compiler replaces it with a number when compiled. Why is this not working?

[fakuivan]

SOLVED

The problem was the strlen() function that for some reason was returning 0. I changed the strlen(phrase) func by the stringsize int returned by the db.

				stringsize = ((SQL_FetchSize(hQuery, 0)) + 1);
				char[] phrase = new char[stringsize];
				SQL_FetchString(hQuery, 0, phrase, stringsize);
				ReplyToCommand(client, "[TFTDB] length: %i", stringsize);
				ReplyToCommand(client, "[TFTDB] phrase: %s", phrase);
				ReplyToCommand(client, "[TFTDB] strlen(phrase): %i", strlen(phrase));

Output:

[TFTDB] length: 29
[TFTDB] phrase: Si lo construyes, el morirá
[TFTDB] strlen(phrase): 28	//worked now for some reason

[Impact123]

The reason strlen returned 0 is because the string was empty. SQL_FetchString couldn't fill it because you told it to put 0 chars (return value of strlen as 3rd param) at max into it, hence it stayed that way. What's the reason you don't just declare a big enough buffer to hold the string?

[Miu]

I think you misunderstand strlen

[fakuivan]

Originally Posted by Impact123 The reason strlen returned 0 is because the string was empty. SQL_FetchString couldn't fill it because you told it to put 0 chars (return value of strlen as 3rd param) at max into it, hence it stayed that way. What's the reason you don't just declare a big enough buffer to hold the string?

Got it, strlen iterates over the string untill it finds a null terminator.

The thing is that the smallest phrase in the db is only 2 characters long and the biggest one is 1142 characters long (untill valve decides to put a phrase longer than the current one), don't know if that is a problem yet so I just used the dynamic string size :v.

btw what if I declare a string using decl and do strlen(theNonTerminatedString)?

[Potato Uno]

It might crash the server because strlen pretty much counts all the bytes up to the null terminator (0), and decl has no null terminator.

You should not be using decl anyway. The SM devs don't recommend it, it never should have existed.