1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
New MySQL Errors for old mysql
TheLeech
Big Clucker
***
Posts: 140
Threads: 35
Joined: Aug 2015
Reputation: 0
#1

17.01.2019, 12:45
Код:
../gamemodes/Functions.pwn(284) : error 017: undefined symbol "cache_get_data"
../gamemodes/Functions.pwn(291) : error 017: undefined symbol "cache_get_field_content"
../gamemodes/Functions.pwn(292) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(283) : warning 203: symbol is never used: "fields"
../gamemodes/Functions.pwn(318) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(319) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(320) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(321) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(324) : error 017: undefined symbol "cache_get_field_content"
../gamemodes/Functions.pwn(350) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(379) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(380) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(381) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(382) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(383) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(384) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(385) : error 017: undefined symbol "cache_get_field_content_int"
../gamemodes/Functions.pwn(386) : error 017: undefined symbol "cache_get_field_content_float"
../gamemodes/Functions.pwn(387) : error 017: undefined symbol "cache_get_field_content_float"
../gamemodes/Functions.pwn(388) : error 017: undefined symbol "cache_get_field_content_float"
../gamemodes/Functions.pwn(389) : error 017: undefined symbol "cache_get_field_content_float"
../gamemodes/Functions.pwn(472) : error 017: undefined symbol "cache_get_data"
../gamemodes/Functions.pwn(478) : error 017: undefined symbol "cache_get_field_content"
../gamemodes/Functions.pwn(480) : error 017: undefined symbol "cache_get_field_content"
../gamemodes/Functions.pwn(482) : error 017: undefined symbol "cache_get_field_content"
../gamemodes/Functions.pwn(484) : error 017: undefined symbol "cache_get_field_content"
../gamemodes/Functions.pwn(486) : error 017: undefined symbol "cache_get_field_content"
Find
Reply
DarkMythHunter
Big Clucker
***
Posts: 139
Threads: 50
Joined: May 2017
Reputation: 0
#2

17.01.2019, 12:50
Show us the lines we know what we're gonna fix.


Also, try to update your mysql plugin.
Find
Reply
TheLeech
Big Clucker
***
Posts: 140
Threads: 35
Joined: Aug 2015
Reputation: 0
#3

17.01.2019, 13:18
Quote:
Originally Posted by DarkMythHunter
Посмотреть сообщение
Show us the lines we know what we're gonna fix.


Also, try to update your mysql plugin.
I have updated MySQL that's whats given me these errors, before updating it worked perfectly and this is code.

Код:
forward public OnPlayerLogin(playerid);
public OnPlayerLogin(playerid)
{
	new found = 0;
	new pName[24], str[256];
    SetPVarInt(playerid, "Admin", cache_get_field_content_int(0, "Admin"));
    SetPVarInt(playerid, "PassedRPTest", cache_get_field_content_int(0, "PassedRPTest"));
    SetPVarInt(playerid, "CharacterMade", cache_get_field_content_int(0, "CharacterMade"));
    SetPVarInt(playerid, "AppMade", cache_get_field_content_int(0, "AppMade"));
    PlayerInfo[playerid][LoggedIn] = true;
    new fetch[256];
   	cache_get_field_content(0, "AdminName", fetch);
	format(PlayerInfo[playerid][AdminName], 256, fetch);
    for(new i = 1; i < MAX_APPLICATIONS; i++)
	{
	    if(ApplicationInfo[i][SentIn] == 1)
    	{
    	    found++;
    	}
	}
	if(GetPVarInt(playerid, "Admin") >= 1 || IsPlayerAdmin(playerid))
	{
	    if(found > 0)
	    {
			format(str, sizeof(str), "Server: There are currently (%d) applications waiting approval. (/applications)", found);
			SendClientMessage(playerid, COLOR_ORANGE, str);
		}
	}
    if(GetPVarInt(playerid, "CharacterMade") == 0)
    {
        if(GetPVarInt(playerid, "PassedRPTest") == 0)
    	{
    	    if(GetPVarInt(playerid, "AppMade") == 1) {
    	        SendClientMessage(playerid, COLOR_ORANGE, "Server: It looks like you have already done an application to join our server.");
    	        SendClientMessage(playerid, COLOR_ORANGE, "We are sorry it's taking so long for you to be reviewed, Please have patients, Thanks.");
    	        SendClientMessage(playerid, COLOR_ORANGE, "Would you like to take a multi-choice test?");
    	        ShowPlayerDialog(playerid, TakeMultiChoice, DIALOG_STYLE_MSGBOX, "Take a different test?", "Would you like to take the multiple choice test?", "Yes", "No");
    	        PlayerInfo[playerid][AppID] = cache_get_field_content_int(0, "AppID");
    	        ApplicationInfo[PlayerInfo[playerid][AppID]][PlayerID] = playerid;
    	    }
    	    if(GetPVarInt(playerid, "AppMade") == 0) {
    	    	AdminsOnline(playerid);
    	    	SetPVarInt(playerid, "Questions", 1);
			}
    	    SetSpawnInfo(playerid, 0, 305, 1494.8589, 1306.48, 1093.2953, 269.15, 0, 0, 0, 0, 0, 0 );
    	    SetPlayerInterior(playerid,3);
    	    SetPlayerVirtualWorld(playerid, playerid+1);
    	    SpawnPlayer(playerid);
    	    SetPlayerSkin(playerid, 305);
    	    TogglePlayerSpectating(playerid, 0);
    	    TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
    	    return 1;
        }
        else {
            SendClientMessage(playerid, COLOR_ORANGE, "Server: Logged in, please make your character.");
			SetSpawnInfo(playerid, 0, 305, 1494.8589, 1306.48, 1093.2953, 269.15, 0, 0, 0, 0, 0, 0 );
    	    SetPlayerInterior(playerid,3);
    	    SetPlayerVirtualWorld(playerid, playerid+1);
    	    SpawnPlayer(playerid);
    	    SetPlayerSkin(playerid, 305);
    	    ShowCreateCharacterMenu(playerid);
    	    TogglePlayerSpectating(playerid, 0);
    	    TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
            return 1;
        }
    }
    SetPVarInt(playerid, "Skin", cache_get_field_content_int(0, "Skin"));
    SetPVarInt(playerid, "Sex", cache_get_field_content_int(0, "Sex"));
    SetPVarInt(playerid, "Age", cache_get_field_content_int(0, "Age"));
    SetPVarInt(playerid, "Cash", cache_get_field_content_int(0, "Cash"));
    SetPVarInt(playerid, "Bank", cache_get_field_content_int(0, "Bank"));
    SetPVarInt(playerid, "Interior", cache_get_field_content_int(0, "Interior"));
    SetPVarInt(playerid, "VirtualWorld", cache_get_field_content_int(0, "VirtualWorld"));
    SetPVarFloat(playerid, "PosX", cache_get_field_content_float(0, "PosX"));
    SetPVarFloat(playerid, "PosY", cache_get_field_content_float(0, "PosY"));
    SetPVarFloat(playerid, "PosZ", cache_get_field_content_float(0, "PosZ"));
    SetPVarFloat(playerid, "PosA", cache_get_field_content_float(0, "PosA"));
    GetPlayerName(playerid, pName, 24);
	GiveNameSpace(pName);
    format(str, sizeof(str), "Server: Welcome back %s, Thank you for being part of the community.", pName);
	SendClientMessage(playerid, COLOR_ORANGE, str);
	SetSpawnInfo(playerid, 0, GetPVarInt(playerid, "Skin"), GetPVarFloat(playerid, "PosX"), GetPVarFloat(playerid, "PosY"), GetPVarFloat(playerid, "PosZ"), GetPVarFloat(playerid, "PosA"), 0, 0, 0, 0, 0, 0 );
 	SetPlayerInterior(playerid, GetPVarInt(playerid, "Interior"));
  	SetPlayerVirtualWorld(playerid, GetPVarInt(playerid, "VirtualWorld"));
   	SpawnPlayer(playerid);
   	SetCameraBehindPlayer(playerid);
   	SetPlayerSkin(playerid, GetPVarInt(playerid, "Skin"));
   	PlayerInfo[playerid][AppID] = -1;
   	TogglePlayerSpectating(playerid, 0);
   	TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
   	SetPlayerMoneyEx(playerid, GetPVarInt(playerid, "Cash"));
    return 1;
}
Find
Reply
B3x7K
Big Clucker
***
Posts: 78
Threads: 2
Joined: Aug 2017
Reputation: 0
#4

17.01.2019, 13:27
Here i fixed it for you

PHP код:
forward public OnPlayerLogin(playerid);
public OnPlayerLogin(playerid)
{
    new found = 0;
    new pName[24], str[256];
    SetPVarInt(playerid, "Admin", cache_get_value_int(0, "Admin"));
    SetPVarInt(playerid, "PassedRPTest", cache_get_value_int(0, "PassedRPTest"));
    SetPVarInt(playerid, "CharacterMade", cache_get_value_int(0, "CharacterMade"));
    SetPVarInt(playerid, "AppMade", cache_get_value_int(0, "AppMade"));
    PlayerInfo[playerid][LoggedIn] = true;
    new fetch[256];
       cache_get_field_name(0, "AdminName", fetch);
    format(PlayerInfo[playerid][AdminName], 256, fetch);
    for(new i = 1; i < MAX_APPLICATIONS; i++)
    {
        if(ApplicationInfo[i][SentIn] == 1)
        {
            found++;
        }
    }
    if(GetPVarInt(playerid, "Admin") >= 1 || IsPlayerAdmin(playerid))
    {
        if(found > 0)
        {
            format(str, sizeof(str), "Server: There are currently (%d) applications waiting approval. (/applications)", found);
            SendClientMessage(playerid, COLOR_ORANGE, str);
        }
    }
    if(GetPVarInt(playerid, "CharacterMade") == 0)
    {
        if(GetPVarInt(playerid, "PassedRPTest") == 0)
        {
            if(GetPVarInt(playerid, "AppMade") == 1) {
                SendClientMessage(playerid, COLOR_ORANGE, "Server: It looks like you have already done an application to join our server.");
                SendClientMessage(playerid, COLOR_ORANGE, "We are sorry it's taking so long for you to be reviewed, Please have patients, Thanks.");
                SendClientMessage(playerid, COLOR_ORANGE, "Would you like to take a multi-choice test?");
                ShowPlayerDialog(playerid, TakeMultiChoice, DIALOG_STYLE_MSGBOX, "Take a different test?", "Would you like to take the multiple choice test?", "Yes", "No");
                PlayerInfo[playerid][AppID] = cache_get_value_int(0, "AppID");
                ApplicationInfo[PlayerInfo[playerid][AppID]][PlayerID] = playerid;
            }
            if(GetPVarInt(playerid, "AppMade") == 0) {
                AdminsOnline(playerid);
                SetPVarInt(playerid, "Questions", 1);
            }
            SetSpawnInfo(playerid, 0, 305, 1494.8589, 1306.48, 1093.2953, 269.15, 0, 0, 0, 0, 0, 0 );
            SetPlayerInterior(playerid,3);
            SetPlayerVirtualWorld(playerid, playerid+1);
            SpawnPlayer(playerid);
            SetPlayerSkin(playerid, 305);
            TogglePlayerSpectating(playerid, 0);
            TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
            return 1;
        }
        else {
            SendClientMessage(playerid, COLOR_ORANGE, "Server: Logged in, please make your character.");
            SetSpawnInfo(playerid, 0, 305, 1494.8589, 1306.48, 1093.2953, 269.15, 0, 0, 0, 0, 0, 0 );
            SetPlayerInterior(playerid,3);
            SetPlayerVirtualWorld(playerid, playerid+1);
            SpawnPlayer(playerid);
            SetPlayerSkin(playerid, 305);
            ShowCreateCharacterMenu(playerid);
            TogglePlayerSpectating(playerid, 0);
            TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
            return 1;
        }
    }
    SetPVarInt(playerid, "Skin", cache_get_value_int(0, "Skin"));
    SetPVarInt(playerid, "Sex", cache_get_value_int(0, "Sex"));
    SetPVarInt(playerid, "Age", cache_get_value_int(0, "Age"));
    SetPVarInt(playerid, "Cash", cache_get_value_int(0, "Cash"));
    SetPVarInt(playerid, "Bank", cache_get_value_int(0, "Bank"));
    SetPVarInt(playerid, "Interior", cache_get_value_int(0, "Interior"));
    SetPVarInt(playerid, "VirtualWorld", cache_get_value_int(0, "VirtualWorld"));
    SetPVarFloat(playerid, "PosX", cache_get_value_float(0, "PosX"));
    SetPVarFloat(playerid, "PosY", cache_get_value_float(0, "PosY"));
    SetPVarFloat(playerid, "PosZ", cache_get_value_float(0, "PosZ"));
    SetPVarFloat(playerid, "PosA", cache_get_value_float(0, "PosA"));
    GetPlayerName(playerid, pName, 24);
    GiveNameSpace(pName);
    format(str, sizeof(str), "Server: Welcome back %s, Thank you for being part of the community.", pName);
    SendClientMessage(playerid, COLOR_ORANGE, str);
    SetSpawnInfo(playerid, 0, GetPVarInt(playerid, "Skin"), GetPVarFloat(playerid, "PosX"), GetPVarFloat(playerid, "PosY"), GetPVarFloat(playerid, "PosZ"), GetPVarFloat(playerid, "PosA"), 0, 0, 0, 0, 0, 0 );
     SetPlayerInterior(playerid, GetPVarInt(playerid, "Interior"));
      SetPlayerVirtualWorld(playerid, GetPVarInt(playerid, "VirtualWorld"));
       SpawnPlayer(playerid);
       SetCameraBehindPlayer(playerid);
       SetPlayerSkin(playerid, GetPVarInt(playerid, "Skin"));
       PlayerInfo[playerid][AppID] = -1;
       TogglePlayerSpectating(playerid, 0);
       TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
       SetPlayerMoneyEx(playerid, GetPVarInt(playerid, "Cash"));
    return 1;
} 
Next time, if you want to try to migrate from old mysql to new mysql, read the wiki first.
https://sampwiki.blast.hk/wiki/MySQL/R40
Find
Reply
TheLeech
Big Clucker
***
Posts: 140
Threads: 35
Joined: Aug 2015
Reputation: 0
#5

17.01.2019, 13:37
Quote:
Originally Posted by B3x7K
Посмотреть сообщение
Here i fixed it for you

PHP код:
forward public OnPlayerLogin(playerid);
public OnPlayerLogin(playerid)
{
    new found = 0;
    new pName[24], str[256];
    SetPVarInt(playerid, "Admin", cache_get_value_int(0, "Admin"));
    SetPVarInt(playerid, "PassedRPTest", cache_get_value_int(0, "PassedRPTest"));
    SetPVarInt(playerid, "CharacterMade", cache_get_value_int(0, "CharacterMade"));
    SetPVarInt(playerid, "AppMade", cache_get_value_int(0, "AppMade"));
    PlayerInfo[playerid][LoggedIn] = true;
    new fetch[256];
       cache_get_field_name(0, "AdminName", fetch);
    format(PlayerInfo[playerid][AdminName], 256, fetch);
    for(new i = 1; i < MAX_APPLICATIONS; i++)
    {
        if(ApplicationInfo[i][SentIn] == 1)
        {
            found++;
        }
    }
    if(GetPVarInt(playerid, "Admin") >= 1 || IsPlayerAdmin(playerid))
    {
        if(found > 0)
        {
            format(str, sizeof(str), "Server: There are currently (%d) applications waiting approval. (/applications)", found);
            SendClientMessage(playerid, COLOR_ORANGE, str);
        }
    }
    if(GetPVarInt(playerid, "CharacterMade") == 0)
    {
        if(GetPVarInt(playerid, "PassedRPTest") == 0)
        {
            if(GetPVarInt(playerid, "AppMade") == 1) {
                SendClientMessage(playerid, COLOR_ORANGE, "Server: It looks like you have already done an application to join our server.");
                SendClientMessage(playerid, COLOR_ORANGE, "We are sorry it's taking so long for you to be reviewed, Please have patients, Thanks.");
                SendClientMessage(playerid, COLOR_ORANGE, "Would you like to take a multi-choice test?");
                ShowPlayerDialog(playerid, TakeMultiChoice, DIALOG_STYLE_MSGBOX, "Take a different test?", "Would you like to take the multiple choice test?", "Yes", "No");
                PlayerInfo[playerid][AppID] = cache_get_value_int(0, "AppID");
                ApplicationInfo[PlayerInfo[playerid][AppID]][PlayerID] = playerid;
            }
            if(GetPVarInt(playerid, "AppMade") == 0) {
                AdminsOnline(playerid);
                SetPVarInt(playerid, "Questions", 1);
            }
            SetSpawnInfo(playerid, 0, 305, 1494.8589, 1306.48, 1093.2953, 269.15, 0, 0, 0, 0, 0, 0 );
            SetPlayerInterior(playerid,3);
            SetPlayerVirtualWorld(playerid, playerid+1);
            SpawnPlayer(playerid);
            SetPlayerSkin(playerid, 305);
            TogglePlayerSpectating(playerid, 0);
            TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
            return 1;
        }
        else {
            SendClientMessage(playerid, COLOR_ORANGE, "Server: Logged in, please make your character.");
            SetSpawnInfo(playerid, 0, 305, 1494.8589, 1306.48, 1093.2953, 269.15, 0, 0, 0, 0, 0, 0 );
            SetPlayerInterior(playerid,3);
            SetPlayerVirtualWorld(playerid, playerid+1);
            SpawnPlayer(playerid);
            SetPlayerSkin(playerid, 305);
            ShowCreateCharacterMenu(playerid);
            TogglePlayerSpectating(playerid, 0);
            TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
            return 1;
        }
    }
    SetPVarInt(playerid, "Skin", cache_get_value_int(0, "Skin"));
    SetPVarInt(playerid, "Sex", cache_get_value_int(0, "Sex"));
    SetPVarInt(playerid, "Age", cache_get_value_int(0, "Age"));
    SetPVarInt(playerid, "Cash", cache_get_value_int(0, "Cash"));
    SetPVarInt(playerid, "Bank", cache_get_value_int(0, "Bank"));
    SetPVarInt(playerid, "Interior", cache_get_value_int(0, "Interior"));
    SetPVarInt(playerid, "VirtualWorld", cache_get_value_int(0, "VirtualWorld"));
    SetPVarFloat(playerid, "PosX", cache_get_value_float(0, "PosX"));
    SetPVarFloat(playerid, "PosY", cache_get_value_float(0, "PosY"));
    SetPVarFloat(playerid, "PosZ", cache_get_value_float(0, "PosZ"));
    SetPVarFloat(playerid, "PosA", cache_get_value_float(0, "PosA"));
    GetPlayerName(playerid, pName, 24);
    GiveNameSpace(pName);
    format(str, sizeof(str), "Server: Welcome back %s, Thank you for being part of the community.", pName);
    SendClientMessage(playerid, COLOR_ORANGE, str);
    SetSpawnInfo(playerid, 0, GetPVarInt(playerid, "Skin"), GetPVarFloat(playerid, "PosX"), GetPVarFloat(playerid, "PosY"), GetPVarFloat(playerid, "PosZ"), GetPVarFloat(playerid, "PosA"), 0, 0, 0, 0, 0, 0 );
     SetPlayerInterior(playerid, GetPVarInt(playerid, "Interior"));
      SetPlayerVirtualWorld(playerid, GetPVarInt(playerid, "VirtualWorld"));
       SpawnPlayer(playerid);
       SetCameraBehindPlayer(playerid);
       SetPlayerSkin(playerid, GetPVarInt(playerid, "Skin"));
       PlayerInfo[playerid][AppID] = -1;
       TogglePlayerSpectating(playerid, 0);
       TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
       SetPlayerMoneyEx(playerid, GetPVarInt(playerid, "Cash"));
    return 1;
} 
Next time, if you want to try to migrate from old mysql to new mysql, read the wiki first.
https://sampwiki.blast.hk/wiki/MySQL/R40
Код:
../gamemodes/Functions.pwn(284) : error 017: undefined symbol "cache_get_data"
../gamemodes/Functions.pwn(291) : warning 202: number of arguments does not match definition
../gamemodes/Functions.pwn(291) : warning 202: number of arguments does not match definition
../gamemodes/Functions.pwn(292) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(283) : warning 203: symbol is never used: "fields"
../gamemodes/Functions.pwn(318) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(319) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(320) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(321) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(324) : error 035: argument type mismatch (argument 3)
../gamemodes/Functions.pwn(350) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(379) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(380) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(381) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(382) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(383) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(384) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(385) : error 017: undefined symbol "cache_get_value_int_ovrld"
../gamemodes/Functions.pwn(386) : error 017: undefined symbol "cache_get_value_float_ovrld"
../gamemodes/Functions.pwn(387) : error 017: undefined symbol "cache_get_value_float_ovrld"
../gamemodes/Functions.pwn(388) : error 017: undefined symbol "cache_get_value_float_ovrld"
../gamemodes/Functions.pwn(389) : error 017: undefined symbol "cache_get_value_float_ovrld"
../gamemodes/Functions.pwn(472) : error 017: undefined symbol "cache_get_data"
../gamemodes/Functions.pwn(478) : error 035: argument type mismatch (argument 3)
../gamemodes/Functions.pwn(480) : error 035: argument type mismatch (argument 3)
../gamemodes/Functions.pwn(482) : error 035: argument type mismatch (argument 3)
../gamemodes/Functions.pwn(484) : error 035: argument type mismatch (argument 3)
../gamemodes/Functions.pwn(486) : error 035: argument type mismatch (argument 3)
../gamemodes/Functions.pwn(488) : error 035: argument type mismatch (argument 3)

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


26 Errors.
Find
Reply
B3x7K
Big Clucker
***
Posts: 78
Threads: 2
Joined: Aug 2017
Reputation: 0
#6

17.01.2019, 14:28
Wait wait, i realize something....
Find
Reply
TheLeech
Big Clucker
***
Posts: 140
Threads: 35
Joined: Aug 2015
Reputation: 0
#7

17.01.2019, 14:34
Quote:
Originally Posted by B3x7K
Посмотреть сообщение
Wait wait, i realize something....
What do I change this to cache_get_data for

Код:
forward OnForumAccountCheck(playerid);
public OnForumAccountCheck(playerid)
{
	new rows, fields;
	cache_get_data(rows, fields, mysql);
	if(rows)
	{
	    new String[150];
	    new pName[24];
	    GetPlayerName(playerid, pName, 24);
	    GiveNameSpace(pName);
		cache_get_value_name(0, "Password", PlayerInfo[playerid][Password], mysql, 129);
		PlayerInfo[playerid][ID] = cache_get_value_name_int(0, "ID");
		//printf("%s", PlayerInfo[playerid][Password]);

		format(String, sizeof(String), "{FFFFFF}Welcome back, %s.\n\n{0099FF}This account is already registered.\n\
		{0099FF}Please, input your password below to proceed to the game.\n\n", pName);
		ShowPlayerDialog(playerid, LoginDialog, DIALOG_STYLE_PASSWORD, "Login System", String, "Login", "Leave");
	}
	else
	{
		new String[150];
        new pName[24];
	    GetPlayerName(playerid, pName, 24);
	    GiveNameSpace(pName);

		format(String, sizeof(String), "{FFFFFF}Welcome %s.\n\n{0099FF}This account is not registered.\n\
		{0099FF}Please, input your password below to proceed.\n\n", pName);
 		ShowPlayerDialog(playerid, RegisterDialog, DIALOG_STYLE_PASSWORD, "Registration System", String, "Register", "Leave");
	}
	return 1;
}
Find
Reply
B3x7K
Big Clucker
***
Posts: 78
Threads: 2
Joined: Aug 2017
Reputation: 0
#8

17.01.2019, 15:05
Quote:
Originally Posted by TheLeech
Посмотреть сообщение
What do I change this to cache_get_data for

Код:
forward OnForumAccountCheck(playerid);
public OnForumAccountCheck(playerid)
{
	new rows, fields;
	cache_get_data(rows, fields, mysql);
	if(rows)
	{
	    new String[150];
	    new pName[24];
	    GetPlayerName(playerid, pName, 24);
	    GiveNameSpace(pName);
		cache_get_value_name(0, "Password", PlayerInfo[playerid][Password], mysql, 129);
		PlayerInfo[playerid][ID] = cache_get_value_name_int(0, "ID");
		//printf("%s", PlayerInfo[playerid][Password]);

		format(String, sizeof(String), "{FFFFFF}Welcome back, %s.\n\n{0099FF}This account is already registered.\n\
		{0099FF}Please, input your password below to proceed to the game.\n\n", pName);
		ShowPlayerDialog(playerid, LoginDialog, DIALOG_STYLE_PASSWORD, "Login System", String, "Login", "Leave");
	}
	else
	{
		new String[150];
        new pName[24];
	    GetPlayerName(playerid, pName, 24);
	    GiveNameSpace(pName);

		format(String, sizeof(String), "{FFFFFF}Welcome %s.\n\n{0099FF}This account is not registered.\n\
		{0099FF}Please, input your password below to proceed.\n\n", pName);
 		ShowPlayerDialog(playerid, RegisterDialog, DIALOG_STYLE_PASSWORD, "Registration System", String, "Register", "Leave");
	}
	return 1;
}
Maybe in mySQL 4.1, you must put cache_get into variable like:
cache_get_value_int(0, "pID", PlayerInfo[playerid][pID]);

Just an example here.....
PHP код:
forward OnPlayerLogin(playerid);
public OnPlayerLogin(playerid)
{
    new found = 0;
    new pName[24], str[256];
    static a,b,c,d;
    cache_get_value_name_int(0, "Admin", a);
    cache_get_value_name_int(0, "PassedRPTest", b);
    cache_get_value_name_int(0, "CharacterMade", c);
    cache_get_value_name_int(0, "AppMade", d);
    SetPVarInt(playerid, "Admin", a);
    SetPVarInt(playerid, "PassedRPTest", b);
    SetPVarInt(playerid, "CharacterMade", c);
    SetPVarInt(playerid, "AppMade", d);
    PlayerInfo[playerid][LoggedIn] = true;
    new fetch[256];
       cache_get_value_name(0, "AdminName", fetch);
    format(PlayerInfo[playerid][AdminName], 256, fetch);
    for(new i = 1; i < MAX_APPLICATIONS; i++)
    {
        if(ApplicationInfo[i][SentIn] == 1)
        {
            found++;
        }
    }
    if(GetPVarInt(playerid, "Admin") >= 1 || IsPlayerAdmin(playerid))
    {
        if(found > 0)
        {
            format(str, sizeof(str), "Server: There are currently (%d) applications waiting approval. (/applications)", found);
            SendClientMessage(playerid, COLOR_ORANGE, str);
        }
    }
    if(GetPVarInt(playerid, "CharacterMade") == 0)
    {
        if(GetPVarInt(playerid, "PassedRPTest") == 0)
        {
            if(GetPVarInt(playerid, "AppMade") == 1) {
                SendClientMessage(playerid, COLOR_ORANGE, "Server: It looks like you have already done an application to join our server.");
                SendClientMessage(playerid, COLOR_ORANGE, "We are sorry it's taking so long for you to be reviewed, Please have patients, Thanks.");
                SendClientMessage(playerid, COLOR_ORANGE, "Would you like to take a multi-choice test?");
                ShowPlayerDialog(playerid, TakeMultiChoice, DIALOG_STYLE_MSGBOX, "Take a different test?", "Would you like to take the multiple choice test?", "Yes", "No");
                
                static apid;
                cache_get_value_name_int(0, "AppID", apid);
                PlayerInfo[playerid][AppID] = apid;
                ApplicationInfo[PlayerInfo[playerid][AppID]][PlayerID] = playerid;
            }
            if(GetPVarInt(playerid, "AppMade") == 0) {
                AdminsOnline(playerid);
                SetPVarInt(playerid, "Questions", 1);
            }
            SetSpawnInfo(playerid, 0, 305, 1494.8589, 1306.48, 1093.2953, 269.15, 0, 0, 0, 0, 0, 0 );
            SetPlayerInterior(playerid,3);
            SetPlayerVirtualWorld(playerid, playerid+1);
            SpawnPlayer(playerid);
            SetPlayerSkin(playerid, 305);
            TogglePlayerSpectating(playerid, 0);
            TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
            return 1;
        }
        else {
            SendClientMessage(playerid, COLOR_ORANGE, "Server: Logged in, please make your character.");
            SetSpawnInfo(playerid, 0, 305, 1494.8589, 1306.48, 1093.2953, 269.15, 0, 0, 0, 0, 0, 0 );
            SetPlayerInterior(playerid,3);
            SetPlayerVirtualWorld(playerid, playerid+1);
            SpawnPlayer(playerid);
            SetPlayerSkin(playerid, 305);
            ShowCreateCharacterMenu(playerid);
            TogglePlayerSpectating(playerid, 0);
            TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
            return 1;
        }
    }
    static e,f,j,k,l,m,n,Float:o,Float:p,Float:q,Float:r;
    cache_get_value_name_int(0, "Skin", e);
    cache_get_value_name_int(0, "Sex", f);
    cache_get_value_name_int(0, "Age", j);
    cache_get_value_name_int(0, "Cash", k);
    cache_get_value_name_int(0, "Bank", l);
    cache_get_value_name_int(0, "Interior", m)
    cache_get_value_name_int(0, "VirtualWorld", n)
    cache_get_value_name_int(0, "PosX", o)
    cache_get_value_name_int(0, "PosY", p)
    cache_get_value_name_int(0, "PosZ", q)
    cache_get_value_name_int(0, "PosA", r)
    //Why you need this instead just using var?
    SetPVarInt(playerid, "Skin", e);
    SetPVarInt(playerid, "Sex", f);
    SetPVarInt(playerid, "Age", j);
    SetPVarInt(playerid, "Cash", k);
    SetPVarInt(playerid, "Bank", l);
    SetPVarInt(playerid, "Interior", m);
    SetPVarInt(playerid, "VirtualWorld", n);
    SetPVarFloat(playerid, "PosX", o);
    SetPVarFloat(playerid, "PosY", p);
    SetPVarFloat(playerid, "PosZ", q);
    SetPVarFloat(playerid, "PosA", r);
    GetPlayerName(playerid, pName, 24);
    GiveNameSpace(pName);
    format(str, sizeof(str), "Server: Welcome back %s, Thank you for being part of the community.", pName);
    SendClientMessage(playerid, COLOR_ORANGE, str);
    SetSpawnInfo(playerid, 0, GetPVarInt(playerid, "Skin"), GetPVarFloat(playerid, "PosX"), GetPVarFloat(playerid, "PosY"), GetPVarFloat(playerid, "PosZ"), GetPVarFloat(playerid, "PosA"), 0, 0, 0, 0, 0, 0 );
     SetPlayerInterior(playerid, GetPVarInt(playerid, "Interior"));
      SetPlayerVirtualWorld(playerid, GetPVarInt(playerid, "VirtualWorld"));
       SpawnPlayer(playerid);
       SetCameraBehindPlayer(playerid);
       SetPlayerSkin(playerid, GetPVarInt(playerid, "Skin"));
       PlayerInfo[playerid][AppID] = -1;
       TogglePlayerSpectating(playerid, 0);
       TextDrawShowForPlayer(playerid,MoneyDraw[playerid]);
       SetPlayerMoneyEx(playerid, GetPVarInt(playerid, "Cash"));
    return 1;
} 
You can try getting mysql cache with PlayerInfo variabel.
Find
Reply
TheLeech
Big Clucker
***
Posts: 140
Threads: 35
Joined: Aug 2015
Reputation: 0
#9

17.01.2019, 15:28
( Последний раз редактировалось TheLeech; 17.01.2019 в 15:58. )
Thanks for help, all working now
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help