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

Threaded Mode
Need Help About Save "TagSystem" SQL
edwardluciano
Big Clucker
***
Posts: 100
Threads: 30
Joined: Oct 2012
Reputation: 0
#1

25.03.2014, 12:51
( Последний раз редактировалось edwardluciano; 26.03.2014 в 02:07. )
Sorry if my thread wrong section & English skill not good
Thank you for all answers future

i has problem about save when login again and use tag it bug somtime lost first word sometime same follow picture

how can i fix

before log out (Create TAG for player and use tag)



after login again (use TAG again)



this my code

Код:
enum pInfo
{
    pTagger[128],
}

public OnAccountUpdate(playerid)
{
	if(IsPlayerConnected(playerid))
	{
		if(gPlayerLogged[playerid])
		{
		    	MySQLCheckConnection();
				new query[MAX_STRING];
				format(query, MAX_STRING, "UPDATE players SET ");
                                MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "Tag", PlayerInfo[playerid][pTagger]);
MySQLUpdateFinish(query, PlayerInfo[playerid][pSQLID]);
		}
	}
	return 1;
}

public OnPlayerLogin(playerid,password[])
{
	if(IsPlayerNPC(playerid)) return 1;
	MySQLCheckConnection();
	new tmp2[256];
	new string2[256];
	new playername2[MAX_PLAYER_NAME];
	new playernamesplit[3][MAX_PLAYER_NAME];
	GetPlayerName(playerid, playername2, sizeof(playername2));
	split(playername2, playernamesplit, '_');
	MySQLFetchAcctSingle(PlayerInfo[playerid][pSQLID], "Password", PlayerInfo[playerid][pPassword]);
	if(strcmp(PlayerInfo[playerid][pPassword],password, true ) == 0 )
	{
		new Data[1024];
		new Field[64];
		new rcnt = 1;
		MySQLFetchAcctRecord(PlayerInfo[playerid][pSQLID], Data);
		samp_mysql_strtok(Field, "|", Data);
		while (samp_mysql_strtok(Field, "|", "")==1)
		{
                      if (rcnt == 1) PlayerInfo[playerid][pTagger] = strmid(PlayerInfo[playerid][pTagger], Field, 0, strlen(Field), 16);
                 }



        if(!strcmp(cmdtext, "/mytag", true))
        {
			GetPlayerName(playerid, sendername, sizeof(sendername));
			new string1[256],string2[256],string3[256],string4[256],string5[256],string6[256],mstring[1024];
			format(string1,sizeof(string1),"1. %s",PlayerInfo[playerid][pTagger]);
			format(string6,sizeof(string6),"ถอด Tag ออก");

			format(mstring,sizeof(mstring),"%s", string1);

			ShowPlayerDialog(playerid, DIALOG_TAG, DIALOG_STYLE_LIST, "{FF9900}*~ TAG ~*",mstring, "เลือก", "ยกเลิก");

        }

if(dialogid == DIALOG_TAG)
  	{
  	    new tagmr[128];
  		if(!response) { return 1; }
    	switch (listitem)
     	{
			case 0: //////////////////TAG1
			{
			    if(TagShow[playerid] == 1)
			    {
					Delete3DTextLabel(TagDD[playerid]);
					TagShow[playerid] = 0;
			    }
			    
       			if(PlayerInfo[playerid][pTagcolor]== 1)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0xFF0000FF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 2)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0x00CA00FF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 3)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0x2F97FFFF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 4)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0xFF5EAEFF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 5)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0xFF8000FF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 6)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0x0000FDFF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 7)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0x8F20FFFF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 8)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0xFFFFFFFF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 9)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0x8F8F8FFF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 10)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0xFF9F9FFF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 11)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0xB3FFB3FF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 12)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0x9DCEFFFF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 13)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0xFFBBFFFF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 14)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0xFFC184FF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
				if(PlayerInfo[playerid][pTagcolor]== 15)
				{
   				   strmid(tagmr, PlayerInfo[playerid][pTagger], 0, strlen(PlayerInfo[playerid][pTagger]), 255);
				   TagDD[playerid] = Create3DTextLabel(tagmr, 0xD7AEFFFF, 0.0, 0.0, 0.0, 10.0, 0, 0);
				   Attach3DTextLabelToPlayer(TagDD[playerid], playerid, 0.0, 0.0, 0.5);
				   TagShow[playerid] = 1;
				   SendClientMessage(playerid, COLOR_WHITE, "*คุณได้ติดตั้ง Tag 1 เรียบร้อย");
				   return 1;
				}
    			SendClientMessage(playerid, COLOR_WHITE, "*** โปรดทราบหากข้อความนี้แสดงเมื่อท่านมี Tag อยู่ตำแหน่งนี้นั่นหมายถึง Tag นี้บัค");
				return 1;
			}
}
Find
Reply
edwardluciano
Big Clucker
***
Posts: 100
Threads: 30
Joined: Oct 2012
Reputation: 0
#2

25.03.2014, 16:12
(T_ T) no body can fix
Find
Reply
Beckett
High-roller
*****
Posts: 1,794
Threads: 104
Joined: Feb 2012
Reputation: 0
#3

25.03.2014, 16:33
I don't understand it, you mean when someone disconnects there will be a tag on his last position or what?
Find
Reply
edwardluciano
Big Clucker
***
Posts: 100
Threads: 30
Joined: Oct 2012
Reputation: 0
#4

26.03.2014, 02:07
Quote:
Originally Posted by DaniceMcHarley
Посмотреть сообщение
I don't understand it, you mean when someone disconnects there will be a tag on his last position or what?
Admin create TAG give someone , someone use that TAG follow pic



When someone logout & login again , use that TAG again follow pic "it bug not same first"



how can i fix

sorry
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