[IndependentGaming]

Hello I'm trying to fix this problem but it keeps giving me errors I removed 2 things from those lines and it still says it doesn't match..

I'm currently trying to update the mysql plugin from R7 to the newest one but every line that has this :

Код:

cache_get_value_name_int(row,  szField, szResult);

it shows one of those errors below

Код:

C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4282) : error 035: argument type mismatch (argument 3)
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4288) : error 035: argument type mismatch (argument 3)
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4292) : error 035: argument type mismatch (argument 3)
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4296) : error 035: argument type mismatch (argument 3)
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4300) : error 035: argument type mismatch (argument 3)
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4304) : error 035: argument type mismatch (argument 3)
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4308) : error 035: argument type mismatch (argument 3)
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4312) : error 035: argument type mismatch (argument 3)
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4316) : error 035: argument type mismatch (argument 3)
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4320) : error 035: argument type mismatch (argument 3)
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4324) : error 035: argument type mismatch (argument 3)
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4328) : error 035: argument type mismatch (argument 3)

PHP код:

for(new i = 0; i < MAX_PLAYERTOYS; i++)
                    {
                        format(szField, sizeof(szField), "pt%dModelID", i);
                        cache_get_value_name_int(row,  szField, szResult);
                        PlayerToyInfo[extraid][i][ptModelID] = strval(szResult);
                        if(PlayerToyInfo[extraid][i][ptModelID] != 0)
                        {
                            format(szField, sizeof(szField), "pt%dBone", i);
                            cache_get_value_name_int(row,  szField, szResult);
                            PlayerToyInfo[extraid][i][ptBone] = strval(szResult);
                            format(szField, sizeof(szField), "pt%dPosX", i);
                            cache_get_value_name_float(row,  szField, szResult);
                            PlayerToyInfo[extraid][i][ptPosX] = floatstr(szResult);
                            format(szField, sizeof(szField), "pt%dPosY", i);
                            cache_get_value_name_float(row,  szField, szResult);
                            PlayerToyInfo[extraid][i][ptPosY] = floatstr(szResult);
                            format(szField, sizeof(szField), "pt%dPosY", i);
                            cache_get_value_name_float(row,  szField, szResult);
                            PlayerToyInfo[extraid][i][ptPosY] = floatstr(szResult);
                            format(szField, sizeof(szField), "pt%dPosZ", i);
                            cache_get_value_name_float(row,  szField, szResult);
                            PlayerToyInfo[extraid][i][ptPosZ] = floatstr(szResult);
                            format(szField, sizeof(szField), "pt%dRotX", i);
                            cache_get_value_name_float(row,  szField, szResult);
                            PlayerToyInfo[extraid][i][ptRotX] = floatstr(szResult);
                            format(szField, sizeof(szField), "pt%dRotY", i);
                            cache_get_value_name_float(row,  szField, szResult);
                            PlayerToyInfo[extraid][i][ptRotY] = floatstr(szResult);
                            format(szField, sizeof(szField), "pt%dRotZ", i);
                            cache_get_value_name_float(row,  szField, szResult);
                            PlayerToyInfo[extraid][i][ptRotZ] = floatstr(szResult);
                            format(szField, sizeof(szField), "pt%dScaX", i);
                            cache_get_value_name_float(row,  szField, szResult);
                            PlayerToyInfo[extraid][i][ptScaleX] = floatstr(szResult);
                            format(szField, sizeof(szField), "pt%dScaY", i);
                            cache_get_value_name_float(row,  szField, szResult);
                            PlayerToyInfo[extraid][i][ptScaleY] = floatstr(szResult);
                            format(szField, sizeof(szField), "pt%dScaZ", i);
                            cache_get_value_name_float(row,  szField, szResult);
                            PlayerToyInfo[extraid][i][ptScaleZ] = floatstr(szResult);
                        }
                        else
                        {
                            PlayerToyInfo[extraid][i][ptBone] = 0;
                            PlayerToyInfo[extraid][i][ptPosX] = 0.0;
                            PlayerToyInfo[extraid][i][ptPosY] = 0.0;
                            PlayerToyInfo[extraid][i][ptPosZ] = 0.0;
                            PlayerToyInfo[extraid][i][ptRotX] = 0.0;
                            PlayerToyInfo[extraid][i][ptRotY] = 0.0;
                            PlayerToyInfo[extraid][i][ptRotZ] = 0.0;
                            PlayerToyInfo[extraid][i][ptScaleX] = 0.0;
                            PlayerToyInfo[extraid][i][ptScaleY] = 0.0;
                            PlayerToyInfo[extraid][i][ptScaleZ] = 0.0;
                        }
                    } 


[iKarim]

You are fetching an integer but passing an array (string) to the function, thus a type mismatch. What you need to do is using the variable directly:

PHP код:

                            format(szField, sizeof(szField), "pt%dBone", i); 
                            cache_get_value_name_int(row,  szField, PlayerToyInfo[extraid][i][ptBone]); 


Also this is pretty helpful: https://sampwiki.blast.hk/wiki/MySQL

[IndependentGaming]

Код:

C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4336) : error 017: undefined symbol "cache_get_value_name__float"
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4339) : error 017: undefined symbol "cache_get_value_name__float"
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4342) : error 017: undefined symbol "cache_get_value_name__float"
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4345) : error 017: undefined symbol "cache_get_value_name__float"
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4348) : error 017: undefined symbol "cache_get_value_name__float"
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4351) : error 017: undefined symbol "cache_get_value_name__float"
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4354) : error 017: undefined symbol "cache_get_value_name__float"
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4357) : error 017: undefined symbol "cache_get_value_name__float"
C:\Users\marlb\Desktop\MCRP\gamemodes\MCRP.pwn(4360) : error 017: undefined symbol "cache_get_value_name__float"

I changed everything see:

PHP код:

for(new i = 0; i < MAX_PLAYERTOYS; i++)
                     {
                          format(szField, sizeof(szField), "pt%dModelID", i);
                        cache_get_value_name_int(row,  szField, PlayerToyInfo[extraid][i][ptBone]);

                          if(PlayerToyInfo[extraid][i][ptModelID] != 0)
                        {
                               format(szField, sizeof(szField), "pt%dBone", i);
                            cache_get_value_name_int(row,  szField, PlayerToyInfo[extraid][i][ptBone]);

                            format(szField, sizeof(szField), "pt%dPosX", i);
                            cache_get_value_name__float(row,  szField, PlayerToyInfo[extraid][i][ptPosX]);

                               format(szField, sizeof(szField), "pt%dPosY", i);
                            cache_get_value_name__float(row,  szField, PlayerToyInfo[extraid][i][ptPosY]);

                            format(szField, sizeof(szField), "pt%dPosZ", i);
                            cache_get_value_name__float(row,  szField, PlayerToyInfo[extraid][i][ptPosZ]);

                            format(szField, sizeof(szField), "pt%dRotX", i);
                            cache_get_value_name__float(row,  szField, PlayerToyInfo[extraid][i][ptRotX]);

                            format(szField, sizeof(szField), "pt%dRotY", i);
                            cache_get_value_name__float(row,  szField, PlayerToyInfo[extraid][i][ptRotY]);

                            format(szField, sizeof(szField), "pt%dRotZ", i);
                            cache_get_value_name__float(row,  szField, PlayerToyInfo[extraid][i][ptRotZ]);

                            format(szField, sizeof(szField), "pt%dScaX", i);
                            cache_get_value_name__float(row,  szField, PlayerToyInfo[extraid][i][ptScaX]);

                            format(szField, sizeof(szField), "pt%dScaY", i);
                            cache_get_value_name__float(row,  szField, PlayerToyInfo[extraid][i][ptScaY]);

                            format(szField, sizeof(szField), "pt%dScaZ", i);
                            cache_get_value_name__float(row,  szField, PlayerToyInfo[extraid][i][ptScaZ]);
                        }
                        else
                        {
                            PlayerToyInfo[extraid][i][ptBone] = 0;
                            PlayerToyInfo[extraid][i][ptPosX] = 0.0;
                            PlayerToyInfo[extraid][i][ptPosY] = 0.0;
                            PlayerToyInfo[extraid][i][ptPosZ] = 0.0;
                            PlayerToyInfo[extraid][i][ptRotX] = 0.0;
                            PlayerToyInfo[extraid][i][ptRotY] = 0.0;
                            PlayerToyInfo[extraid][i][ptRotZ] = 0.0;
                            PlayerToyInfo[extraid][i][ptScaleX] = 0.0;
                            PlayerToyInfo[extraid][i][ptScaleY] = 0.0;
                            PlayerToyInfo[extraid][i][ptScaleZ] = 0.0;
                        }
                    } 


[iKarim]

You have double underscores "__" instead of a single one in the float functions, they should be:

PHP код:

cache_get_value_name_float