varchar command - Printable Version

varchar command - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: varchar command (/showthread.php?tid=652802)

varchar command - Zeus666 - 19.04.2018

Hi. Married row gets reset after player login on server.

Why?

PHP код:



`Married` varchar(24) NOT NULL,


            cache_get_field_content(0, "Married", tmp), pInfo[playerid][Married] = strval(tmp);




Married with: %s pInfo[playerid][Married]


strcat(Query,"UPDATE `users` SET `Married` = '%s',

Re: varchar command - F1N4L - 19.04.2018

What's your MySQL version?

@EDIT

Why you're using string for integer?

Re: varchar command - Zeus666 - 19.04.2018

Quote:

Originally Posted by F1N4L

What's your MySQL version?

@EDIT

Why you're using string for integer?

I don't want to use integer, I want to use string.

Re: varchar command - F1N4L - 19.04.2018

Quote:

Originally Posted by Zeus666

I don't want to use integer, I want to use string.

pInfo[playerid][Married] = strval(tmp)

strval function convert STRING to INTEGER.
See more: Strval.

If Married constant is string use this:
cache_get_field_content(0, "Married", pInfo[playerid][Married])

Re: varchar command - Zeus666 - 19.04.2018

Quote:

Originally Posted by F1N4L

I modified it, but still, it won't save.

On MYSQL is saved, but In game it wont show. it shows blank

PHP код:



                format(str, sizeof(str),"%s: %s (%s) - %s",  GetAdminName(i), PlayerName(i), pInfo[i][Married], DUTY_STR);

                SendClientMessage(playerid, COLOR, str);

Re: varchar command - UFF - 19.04.2018

Код:

                format(str, sizeof(str),"%s: %s (%d) - %s",  GetAdminName(i), PlayerName(i), pInfo[i][Married], DUTY_STR); 
                SendClientMessage(playerid, COLOR, str);

Re: varchar command - F1N4L - 19.04.2018

Quote:

Originally Posted by UFF

Код:

                format(str, sizeof(str),"%s: %s (%d) - %s",  GetAdminName(i), PlayerName(i), pInfo[i][Married], DUTY_STR); 
                SendClientMessage(playerid, COLOR, str);

pInfo[i][Married] is string!

@TOPIC

Only make a debug:

Test #1:

Код:

new marr[24];
cache_get_field_content(0, "Married", marr);

format(str, sizeof(str),"%s: %s (%s) - %s",  GetAdminName(playerid), PlayerName(playerid), marr, DUTY_STR); 
SendClientMessage(playerid, COLOR, str);

Test #2:

Код:

cache_get_field_content(0, "Married", pInfo[playerid][Married], connectionHandle /* change this */, 24);

format(str, sizeof(str),"%s: %s (%s) - %s",  GetAdminName(playerid), PlayerName(playerid), pInfo[playerid][Married], DUTY_STR); 
SendClientMessage(playerid, COLOR, str);

Re: varchar command - Zeus666 - 19.04.2018

If I set someone married data as "test" it shows that variable.

At relog, in mysql still is visible, but In game not.

Re: varchar command - UFF - 20.04.2018

Код:

`Married` varchar(35) NOT NULL,

Use this and try.

Else it doesn't work,

Do you save pInfo[playerid][Married] in OnPlayerdisconnect?
And do you load it in OnPlayerConnect by Loading Player's data?

Re: varchar command - Zeus666 - 20.04.2018

Quote:

Originally Posted by UFF

Код:

`Married` varchar(35) NOT NULL,

Use this and try.

Else it doesn't work,

Do you save pInfo[playerid][Married] in OnPlayerdisconnect?
And do you load it in OnPlayerConnect by Loading Player's data?

I made an stock saving and loading player's data, and yes, they are loading.