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

Threaded Mode
[Plugin] [REL] MySQL Plugin (Now on github!)
Andron
Little Clucker
**
Posts: 35
Threads: 5
Joined: Sep 2008
Reputation: 0
#121

20.10.2009, 19:10
yea, I solved the problem lolz.
The real problem was that, I didnt have "Stuff".cfg xD

But yeah now its problem with "OnPlayerLogin". Everytime I log in, then samp-server.exe stops working.
I think I have done wrong in OnPlayerlogin edit.
Here my current code.

Код:
public OnPlayerLogin(playerid,password[])
{
	MySQLCheckConnection();

	new tmp2[256];
  new string2[64];
	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][pKey]);
	if(strcmp(PlayerInfo[playerid][pKey],password, true ) == 0 )
	{
		new Data[1024];
		new Field[64];
		MySQLFetchAcctRecord(PlayerInfo[playerid][pSQLID], Data);
		//new idx;
		//new Fields = mysql_field_count();
		for(new rcnt = 1; mysql_fetch_field(rcnt, Field); rcnt++)
		{
			// The rcnt values here represent the order of the columns in the characters table, so don't mess with them
			// If you add a column to the table, just add a new line with a +1 rcnt to the block below
			// Start it at 3 to skip the first few records we don't need (id, player name, password)
			if (rcnt == 3) PlayerInfo[playerid][pLevel] = strval(Field);
			if (rcnt == 4) PlayerInfo[playerid][pAdmin] = strval(Field);
			if (rcnt == 5) PlayerInfo[playerid][pDonateRank] = strval(Field);
			if (rcnt == 6) PlayerInfo[playerid][gPupgrade] = strval(Field);
			if (rcnt == 7) PlayerInfo[playerid][pConnectTime] = strval(Field);
			if (rcnt == 8) PlayerInfo[playerid][pReg] = strval(Field);
			if (rcnt == 9) PlayerInfo[playerid][pSex] = strval(Field);
			if (rcnt == 10) PlayerInfo[playerid][pAge] = strval(Field);
			if (rcnt == 11) PlayerInfo[playerid][pOrigin] = strval(Field);
			if (rcnt == 12) PlayerInfo[playerid][pCK] = strval(Field);
			if (rcnt == 13) PlayerInfo[playerid][pMuted] = strval(Field);
			if (rcnt == 14) PlayerInfo[playerid][pExp] = strval(Field);
			if (rcnt == 15) PlayerInfo[playerid][pCash] = strval(Field);
			if (rcnt == 16) PlayerInfo[playerid][pAccount] = strval(Field);
			if (rcnt == 17) PlayerInfo[playerid][pCrimes] = strval(Field);
			if (rcnt == 18) PlayerInfo[playerid][pKills] = strval(Field);
			if (rcnt == 19) PlayerInfo[playerid][pDeaths] = strval(Field);
			if (rcnt == 20) PlayerInfo[playerid][pArrested] = strval(Field);
			if (rcnt == 21) PlayerInfo[playerid][pWantedDeaths] = strval(Field);
			if (rcnt == 22) PlayerInfo[playerid][pPhoneBook] = strval(Field);
			if (rcnt == 23) PlayerInfo[playerid][pLottoNr] = strval(Field);
			if (rcnt == 24) PlayerInfo[playerid][pFishes] = strval(Field);
			if (rcnt == 25) PlayerInfo[playerid][pBiggestFish] = strval(Field);
			if (rcnt == 26) PlayerInfo[playerid][pJob] = strval(Field);
			if (rcnt == 27) PlayerInfo[playerid][pPayCheck] = strval(Field);
			if (rcnt == 28) PlayerInfo[playerid][pHeadValue] = strval(Field);
			if (rcnt == 29) PlayerInfo[playerid][pJailed] = strval(Field);
			if (rcnt == 30) PlayerInfo[playerid][pJailTime] = strval(Field);
			if (rcnt == 31) PlayerInfo[playerid][pMats] = strval(Field);
			if (rcnt == 32) PlayerInfo[playerid][pDrugs] = strval(Field);
			if (rcnt == 33) PlayerInfo[playerid][pLeader] = strval(Field);
			if (rcnt == 34) PlayerInfo[playerid][pMember] = strval(Field);
			if (rcnt == 35) PlayerInfo[playerid][pFMember] = strval(Field);
			if (rcnt == 36) PlayerInfo[playerid][pRank] = strval(Field);
			if (rcnt == 37) PlayerInfo[playerid][pChar] = strval(Field);
			if (rcnt == 38) PlayerInfo[playerid][pContractTime] = strval(Field);
			if (rcnt == 39) PlayerInfo[playerid][pDetSkill] = strval(Field);
			if (rcnt == 40) PlayerInfo[playerid][pSexSkill] = strval(Field);
			if (rcnt == 41) PlayerInfo[playerid][pBoxSkill] = strval(Field);
			if (rcnt == 42) PlayerInfo[playerid][pLawSkill] = strval(Field);
			if (rcnt == 43) PlayerInfo[playerid][pMechSkill] = strval(Field);
			if (rcnt == 44) PlayerInfo[playerid][pJackSkill] = strval(Field);
			if (rcnt == 45) PlayerInfo[playerid][pCarSkill] = strval(Field);
			if (rcnt == 46) PlayerInfo[playerid][pNewsSkill] = strval(Field);
			if (rcnt == 47) PlayerInfo[playerid][pDrugsSkill] = strval(Field);
			if (rcnt == 48) PlayerInfo[playerid][pCookSkill] = strval(Field);
			if (rcnt == 49) PlayerInfo[playerid][pFishSkill] = strval(Field);
			if (rcnt == 50) PlayerInfo[playerid][pSHealth] = floatstr(Field);
			if (rcnt == 51) PlayerInfo[playerid][pHealth] = floatstr(Field);
			if (rcnt == 52) PlayerInfo[playerid][pInt] = strval(Field);
			if (rcnt == 53) PlayerInfo[playerid][pLocal] = strval(Field);
			if (rcnt == 54) PlayerInfo[playerid][pTeam] = strval(Field);
			if (rcnt == 55) PlayerInfo[playerid][pModel] = strval(Field);
			if (rcnt == 56) PlayerInfo[playerid][pPnumber] = strval(Field);
			if (rcnt == 57) PlayerInfo[playerid][pPhousekey] = strval(Field);
			if (rcnt == 58) PlayerInfo[playerid][pPcarkey] = strval(Field);
			if (rcnt == 59) PlayerInfo[playerid][pPbiskey] = strval(Field);
			if (rcnt == 60) PlayerInfo[playerid][pPos_x] = floatstr(Field);
			if (rcnt == 61) PlayerInfo[playerid][pPos_y] = floatstr(Field);
			if (rcnt == 62) PlayerInfo[playerid][pPos_z] = floatstr(Field);
			if (rcnt == 63) PlayerInfo[playerid][pCarLic] = strval(Field);
			if (rcnt == 64) PlayerInfo[playerid][pFlyLic] = strval(Field);
			if (rcnt == 65) PlayerInfo[playerid][pBoatLic] = strval(Field);
			if (rcnt == 66) PlayerInfo[playerid][pFishLic] = strval(Field);
			if (rcnt == 67) PlayerInfo[playerid][pGunLic] = strval(Field);
			if (rcnt == 68) PlayerInfo[playerid][pGun1] = strval(Field);
			if (rcnt == 69) PlayerInfo[playerid][pGun2] = strval(Field);
			if (rcnt == 70) PlayerInfo[playerid][pGun3] = strval(Field);
			if (rcnt == 71) PlayerInfo[playerid][pGun4] = strval(Field);
			if (rcnt == 72) PlayerInfo[playerid][pAmmo1] = strval(Field);
			if (rcnt == 73) PlayerInfo[playerid][pAmmo2] = strval(Field);
			if (rcnt == 74) PlayerInfo[playerid][pAmmo3] = strval(Field);
			if (rcnt == 75) PlayerInfo[playerid][pAmmo4] = strval(Field);
			if (rcnt == 76) PlayerInfo[playerid][pCarTime] = strval(Field);
			if (rcnt == 77) PlayerInfo[playerid][pPayDay] = strval(Field);
			if (rcnt == 78) PlayerInfo[playerid][pPayDayHad] = strval(Field);
			if (rcnt == 79) PlayerInfo[playerid][pCDPlayer] = strval(Field);
			if (rcnt == 80) PlayerInfo[playerid][pWins] = strval(Field);
			if (rcnt == 81) PlayerInfo[playerid][pLoses] = strval(Field);
			if (rcnt == 82) PlayerInfo[playerid][pAlcoholPerk] = strval(Field);
			if (rcnt == 83) PlayerInfo[playerid][pDrugPerk] = strval(Field);
			if (rcnt == 84) PlayerInfo[playerid][pMiserPerk] = strval(Field);
			if (rcnt == 85) PlayerInfo[playerid][pPainPerk] = strval(Field);
			if (rcnt == 86) PlayerInfo[playerid][pTraderPerk] = strval(Field);
			if (rcnt == 87) PlayerInfo[playerid][pTut] = strval(Field);
			if (rcnt == 88) PlayerInfo[playerid][pMissionNr] = strval(Field);
			if (rcnt == 89) PlayerInfo[playerid][pWarns] = strval(Field);
			if (rcnt == 90) PlayerInfo[playerid][pAdjustable] = strval(Field);
			if (rcnt == 91) PlayerInfo[playerid][pFuel] = strval(Field);
			if (rcnt == 92) PlayerInfo[playerid][pMarried] = strval(Field);
			if (rcnt == 93) PlayerInfo[playerid][pMarriedTo] = strmid(PlayerInfo[playerid][pMarriedTo], Field, 0, strlen(Field)-1, 255);
			if (rcnt == 94) PlayerInfo[playerid][pLocked] = strval(Field);
			if (rcnt == 95) PlayerInfo[playerid][pLinked] = strval(Field);
			if (rcnt == 96) PlayerInfo[playerid][pCrashed] = strval(Field);
			if (rcnt == 97) PlayerInfo[playerid][pToitumus] = strval(Field);
			if (rcnt == 98) PlayerInfo[playerid][pPcarkey2] = strval(Field);
			if (rcnt == 99) PlayerInfo[playerid][pPcarkey3] = strval(Field);
			if (rcnt == 100) PlayerInfo[playerid][pEaglep] = strval(Field);
			if (rcnt == 101) PlayerInfo[playerid][pSDpistolp] = strval(Field);
			if (rcnt == 102) PlayerInfo[playerid][pMP5p] = strval(Field);
			if (rcnt == 103) PlayerInfo[playerid][pShotgunp] = strval(Field);
			if (rcnt == 104) PlayerInfo[playerid][pAk47p] = strval(Field);
			if (rcnt == 105) PlayerInfo[playerid][pM4p] = strval(Field);
			if (rcnt == 106) PlayerInfo[playerid][pRiflep] = strval(Field);
		}
		//mysql_free_result();
	}
	else
	{
		SendClientMessage(playerid, COLOR_WHITE, "SERVER: Vale parool !");
	  gPlayerLogTries[playerid] += 1;
	  if(gPlayerLogTries[playerid] == 4) { PlayerInfo[playerid][pLocked] = 1; }
	  return 1;
	}
	PlayerInfo[playerid][pAdjustable] = 0;
	ResetPlayerMoney(playerid);
	ConsumingMoney[playerid] = 1;
	SafeGivePlayerMoney(playerid,PlayerInfo[playerid][pCash]);
	CurrentMoney[playerid] = PlayerInfo[playerid][pCash];
	if(PlayerInfo[playerid][pReg] == 0)
	{
		PlayerInfo[playerid][pLevel] = 1;
		PlayerInfo[playerid][pSHealth] = 0.0;
		PlayerInfo[playerid][pHealth] = 50.0;
		PlayerInfo[playerid][pPos_x] = 1612.3240;
		PlayerInfo[playerid][pPos_y] = -2330.1670;
		PlayerInfo[playerid][pPos_z] = 13.5469;
		PlayerInfo[playerid][pInt] = 15;
		PlayerInfo[playerid][pLocal] = 255;
		PlayerInfo[playerid][pTeam] = 3;
		PlayerInfo[playerid][pModel] = 26;
		new randphone = 100000 + random(899999);//minimum 1000 max 9999 //giving one at the start
		PlayerInfo[playerid][pPnumber] = randphone;
		PlayerInfo[playerid][pPhousekey] = 255;
		PlayerInfo[playerid][pPbiskey] = 255;
		PlayerInfo[playerid][pPcarkey] = 999;
		PlayerInfo[playerid][pPcarkey2] = 999;
		PlayerInfo[playerid][pPcarkey3] = 999;
		PlayerInfo[playerid][pAccount] = 500;
		PlayerInfo[playerid][pReg] = 1;
	}
	/*if(PlayerInfo[playerid][pLevel] == -999) //autoban
	{
		Ban(playerid);
	}*/
	else if(PlayerInfo[playerid][pCK] > 0)
	{
		  Kick(playerid);
	}
	ClearChatbox(playerid, 8);
	SendClientMessage(playerid, COLOR_GREEN, "=============================================");
	format(string2, sizeof(string2), " Teretulemast Ьhendatud Rollimдngu serverisse, %s.",playernamesplit[0]);
	SendClientMessage(playerid, COLOR_WHITE,string2);
	SendClientMessage(playerid, COLOR_GREEN, "=============================================");
	SendClientMessage(playerid, COLOR_WHITE, "Server skriptud: AruLa ning MadeMan poolt.");
	SendClientMessage(playerid, COLOR_WHITE, "MySQL: Martin & Nicholas.");
	SendClientMessage(playerid, COLOR_WHITE, "Mumble IP: urp.live.playcode.eu:7100");
	SendClientMessage(playerid, COLOR_WHITE, "Koduleht: www.u-rp.com");
	format(string2, sizeof(string2), "Hetkel jooksva skripti versioon: %s.",SCRIPT_VERSION);
	SendClientMessage(playerid, COLOR_WHITE, string2);
	if (PlayerInfo[playerid][pDonateRank] > 0)
	{
		SendClientMessage(playerid, COLOR_WHITE,"SERVER: Sa oled preemium konto kasutaja!");
	}
	if (PlayerInfo[playerid][pLinked] == 0)
	{
		SendClientMessage(playerid, COLOR_LIGHTRED, "SERVER: Su kasuta pole aktiveeritud. Su хigused on piiratud!");
	}
	if (PlayerInfo[playerid][pAdmin] > 0)
	{
		format(string2, sizeof(string2), "SERVER: Sa oled sisse logitud kui %d admin.",PlayerInfo[playerid][pAdmin]);
		SendClientMessage(playerid, COLOR_WHITE,string2);
	}
	SendClientMessage(playerid, COLOR_GREEN, "=============================================");
	SendClientMessage(playerid, COLOR_WHITE, " ");
	printf("%s has logged in.",playername2);

	// Unset Crash
	SetTimerEx("UnsetCrash", 5000, false, "i", playerid);

	SetSpawnInfo(playerid, PlayerInfo[playerid][pTeam], PlayerInfo[playerid][pModel], PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], 1.0, -1, -1, -1, -1, -1, -1);
	if(gTeam[playerid] == 0)
	{
		gTeam[playerid] = 3;
	}
	else
	{
		gTeam[playerid] = PlayerInfo[playerid][pTeam];
	}
	gPlayerLogged[playerid] = 1;
	SpawnPlayer(playerid);
	if(PlayerInfo[playerid][pCrashed] == 0)
	{
		format(tmp2, sizeof(tmp2), "~w~Tere Tulemast ~n~~y~  %s", playername2);
	}
	else
	{
	  	SendClientMessage(playerid, COLOR_WHITE, "SERVER: Teie ьhendus katkes teadmata pхhjusel ennem vдljumist.");
	  	SendClientMessage(playerid, COLOR_YELLOW2, "Crash sьsteem: Teie positsioon taastati..");
	}
	DateProp(playerid);
	if(PlayerInfo[playerid][pFMember] < 255)
	{
	  format(tmp2, sizeof(tmp2), "Family MOTD: %s.", FamilyInfo[PlayerInfo[playerid][pFMember]][FamilyMOTD]);
	  SendClientMessage(playerid, COLOR_YELLOW, tmp2);
	}
	for(new i = 0; i < MAX_PLAYERS; i++)
	{
	  if(IsPlayerConnected(i))
	  {
	    if(PlayerInfo[i][pMaskuse] == 1)
	    {
	      ShowPlayerNameTagForPlayer(playerid, i, 0);
	    }
	  }
	}
	return 1;
}
Find
Reply
Sergei
High-roller
*****
Posts: 2,862
Threads: 11
Joined: Mar 2008
Reputation: 0
#122

20.10.2009, 19:54
Quote:
Originally Posted by MenaceX^
You should change your behavior because you are wrong. There is not a REPLACEMENT for mysql_strtok. E.g:
samp_mysql_fetch_row is here mysql_fetch_row_format.
But there is NOTHING related to strtok in this plugin than fetching a whole row.
Like anyone ever said anything about strtok and connection to this plugin.
Find
Reply
MenaceX^
High-roller
*****
Posts: 3,262
Threads: 30
Joined: Aug 2008
Reputation: 0
#123

20.10.2009, 20:53
You did, you talked about samp_mysql_strtok.. God..
Find
Reply
MattePRL
Little Clucker
**
Posts: 7
Threads: 0
Joined: Mar 2008
Reputation: 0
#124

21.10.2009, 20:50
Hey, does anyone have problem with crashing server after using commands like "fetch_row", "row_count" etc, etc... (0.3 ofc.)? It's really anoying.
Find
Reply
MenaceX^
High-roller
*****
Posts: 3,262
Threads: 30
Joined: Aug 2008
Reputation: 0
#125

21.10.2009, 21:17
You store a result?
Find
Reply
Albus_Dumbledore
Little Clucker
**
Posts: 16
Threads: 1
Joined: Jun 2008
Reputation: 0
#126

27.10.2009, 18:07
Hi all !!
I am sorry to post here but i have a problem, and i know that you have ever speak of the samp_mysql_strtok, but i don't understand how can i do .
My problem: I use moderntopia gm, when i /login on my server, it crash.
In the script, there is:

samp_mysql_strtok(Field, "|", Data);
while (samp_mysql_strtok(Field, "|", "")==1)
{

What i have to do please ? I am working on it but i don't have any solution !!
Find
Reply
Sergei
High-roller
*****
Posts: 2,862
Threads: 11
Joined: Mar 2008
Reputation: 0
#127

27.10.2009, 18:21
Your script is using other mysql plugin.
Find
Reply
Albus_Dumbledore
Little Clucker
**
Posts: 16
Threads: 1
Joined: Jun 2008
Reputation: 0
#128

27.10.2009, 18:32
Ok i didn't know
So why my server crash when i login, it's strange
Find
Reply
MenaceX^
High-roller
*****
Posts: 3,262
Threads: 30
Joined: Aug 2008
Reputation: 0
#129

27.10.2009, 18:33
Quote:
Originally Posted by Albus_Dumbledore
Hi all !!
I am sorry to post here but i have a problem, and i know that you have ever speak of the samp_mysql_strtok, but i don't understand how can i do .
My problem: I use moderntopia gm, when i /login on my server, it crash.
In the script, there is:

samp_mysql_strtok(Field, "|", Data);
while (samp_mysql_strtok(Field, "|", "")==1)
{

What i have to do please ? I am working on it but i don't have any solution !!
The crash reason is the plugin, the other plugin (Adrenaline) doesn't work well. Use this one, even though this doesn't work well either.
Find
Reply
Sergei
High-roller
*****
Posts: 2,862
Threads: 11
Joined: Mar 2008
Reputation: 0
#130

27.10.2009, 18:35
All what doesn't work in this plugin is OnQueryFinish.
Find
Reply
MenaceX^
High-roller
*****
Posts: 3,262
Threads: 30
Joined: Aug 2008
Reputation: 0
#131

09.12.2009, 10:33
Quote:
Originally Posted by $ЂЯĢ
This would be possible fix.
pawn Code:
public FindPlayerSQL(playerid)
{
  CheckSQL();
  new 
    query[128],
    pname[MAX_PLAYER_NAME];
  GetPlayerName(playerid,pname,sizeof(pname));
  mysql_real_escape_string(pname,pname);
  format(query,sizeof(query),"SELECT playerid FROM `players` WHERE name='%s' LIMIT 1",pname);
  mysql_query(query);
  mysql_store_result();
  if(mysql_num_rows()>0)
  {
    PlayerInfo[playerid][pSQLId] = mysql_fetch_int();
    if(PlayerInfo[playerid][pSQLId] <= INVALID_SQL_ID) 
    { 
        SendClientMessage(playerid,0xFFFFFF,"SERVER: Your data hasn't loaded.");
        return Kick(playerid);
    } 
  }
  mysql_free_result();
  return 1;
}
There's no reason for that because you check the rows, there can't be 3 rows but your sqlid will be 0.. It must be 1 2 or 3. (auto increment)
Find
Reply
Sergei
High-roller
*****
Posts: 2,862
Threads: 11
Joined: Mar 2008
Reputation: 0
#132

09.12.2009, 13:29
The only issue here can be that mysql_fetch_int doesn't do its job, so we make mysql_num_rows() to see if we got any data from SELECT query. If we got any data we fetch it in PlayerInfo[playerid][pSQLId]. If mysql_fetch_int() doesn't do its job we check if PlayerInfo[playerid][pSQLId] is higher than 0 (INVALID_SQL_ID). If it's not we know there is a data for that username already, but mysql_fetch_int didn't get row's ID which we wanted to get, so it's useless to continue that's why we kick player.

Understood?
Find
Reply
Deat_Itself
Gangsta
****
Posts: 595
Threads: 12
Joined: May 2009
Reputation: 0
#133

11.12.2009, 12:59
out standing work !


Saif
Find
Reply
jamesb93
Huge Clucker
***
Posts: 216
Threads: 45
Joined: May 2009
Reputation: 0
#134

11.12.2009, 16:02
Quote:
Originally Posted by $ЂЯĢ
The only issue here can be that mysql_fetch_int doesn't do its job, so we make mysql_num_rows() to see if we got any data from SELECT query. If we got any data we fetch it in PlayerInfo[playerid][pSQLId]. If mysql_fetch_int() doesn't do its job we check if PlayerInfo[playerid][pSQLId] is higher than 0 (INVALID_SQL_ID). If it's not we know there is a data for that username already, but mysql_fetch_int didn't get row's ID which we wanted to get, so it's useless to continue that's why we kick player.

Understood?
I believe this way has fixed my problem, Thanks
Find
Reply
MenaceX^
High-roller
*****
Posts: 3,262
Threads: 30
Joined: Aug 2008
Reputation: 0
#135

11.12.2009, 16:39
Aha. I do the same but I think it's stupid to kick the player in this function.. I just check later then..
Find
Reply
Lapside
Little Clucker
**
Posts: 6
Threads: 0
Joined: Apr 2008
Reputation: 0
#136

11.12.2009, 19:18
Hi, i got this error when i want to connect to the database:
Code:
MySQL Connect Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Error ID: 2002)
Here the whole error:
Code:
[20:59:14] mysql_connect("*******","*******","*******","*******");
[20:59:14] MySQL Connect Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Error ID: 2002)
[21:03:40] MySQL Ping Error: "MySQL server has gone away"
[21:03:40] mysql_close();
What to do? ...
Find
Reply
MenaceX^
High-roller
*****
Posts: 3,262
Threads: 30
Joined: Aug 2008
Reputation: 0
#137

11.12.2009, 19:19
Quote:
Originally Posted by Monoxid
Hi, i got this error when i want to connect to the database:
Code:
MySQL Connect Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Error ID: 2002)
Here the whole error:
Code:
[20:59:14] mysql_connect("*******","*******","*******","*******");
[20:59:14] MySQL Connect Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Error ID: 2002)
[21:03:40] MySQL Ping Error: "MySQL server has gone away"
[21:03:40] mysql_close();
What to do? ...
Either your data info in the script is incorrect or the database doesn't exist.
Find
Reply
Lapside
Little Clucker
**
Posts: 6
Threads: 0
Joined: Apr 2008
Reputation: 0
#138

11.12.2009, 19:27
They are the same as in my PHP script but the PHP script works..
The database exists...
Find
Reply
Coicatak
Huge Clucker
****
Posts: 318
Threads: 40
Joined: Nov 2008
Reputation: 0
#139

12.12.2009, 15:43
Hi, I got a big problem that I can't fix for HOURS.

here's the buggy function, actually totalannonce is supposed to be 10 but after the line "mysql_fetch_field_row(Field,"text");" it magically sets itself to 101 for no appearent reason...

pawn Code:
#define MAX_ANNOUNCEMENTS  10
enum rInfo
{
    rName[30],
    rText[128],
    rContact[20],
    rBusy
}new Recuiting[MAX_ANNOUNCEMENTS+1][rInfo];

stock LoadSQLRecuiting()
{
      new totalannonce;
    new Field[64];
    new Data[256];
    new sql[80];
    format(sql, sizeof(sql), "SELECT COUNT(*) FROM annonces");
    mysql_query(sql);
    mysql_store_result();
    mysql_fetch_row(Data);
    totalannonce = strval(Data);
    mysql_free_result();
    for (new idx=1; idx<=totalannonce; idx++)
    {
      format(sql, sizeof(sql), "SELECT * FROM annonces WHERE id=%d", idx);
      mysql_query(sql);
      mysql_store_result();
      if (mysql_num_rows() > 0)
      {
          mysql_fetch_row(Data);
      
          mysql_fetch_field_row(Field,"name");
          printf("%s, %d, %d", Field, totalannonce, idx);
          strmid(Recuiting[idx][rName],Field,0,strlen(Field),50);
          mysql_fetch_field_row(Field,"text");
          printf("%s, %d", Field, totalannonce);
          strmid(Recuiting[idx][rText],Field,0,strlen(Field),128);
          mysql_fetch_field_row(Field,"contact");
          printf("%s, %d", Field, totalannonce);
          strmid(Recuiting[idx][rContact],Field,0,strlen(Field),20);
          mysql_fetch_field_row(Field,"busy");
          Recuiting[idx][rBusy] = strval(Field);
        }
        mysql_free_result();
    }
    printf("%d recuiting announcements loaded from DB.", totalannonce);
    return 1;
}
Here are server logs:
Quote:

[17:35:14][17:35:14] Sweeper, 10, 1
[17:35:14] Vous conduisez une balayeuse а travers Los Santos afin de nettoyer les rues, 101
[17:35:14] ((/sweeper)), 101
[17:35:14] Aucun, 101, 2
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 3
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 4
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 5
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 6
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 7
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 8
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 9
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 10
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] 101 recuiting announcements loaded from DB.
here is a screen of the DB:


This is really annoying, so if anyone could help me... Thanks
Find
Reply
MenaceX^
High-roller
*****
Posts: 3,262
Threads: 30
Joined: Aug 2008
Reputation: 0
#140

12.12.2009, 15:51
Quote:
Originally Posted by Coicatak
Hi, I got a big problem that I can't fix for HOURS.

here's the buggy function, actually totalannonce is supposed to be 10 but after the line "mysql_fetch_field_row(Field,"text");" it magically sets itself to 101 for no appearent reason...

pawn Code:
#define MAX_ANNOUNCEMENTS 10
enum rInfo
{
    rName[30],
    rText[128],
    rContact[20],
    rBusy
}new Recuiting[MAX_ANNOUNCEMENTS+1][rInfo];

stock LoadSQLRecuiting()
{
      new totalannonce;
    new Field[64];
    new Data[256];
    new sql[80];
    format(sql, sizeof(sql), "SELECT COUNT(*) FROM annonces");
    mysql_query(sql);
    mysql_store_result();
    mysql_fetch_row(Data);
    totalannonce = strval(Data);
    mysql_free_result();
    for (new idx=1; idx<=totalannonce; idx++)
    {
      format(sql, sizeof(sql), "SELECT * FROM annonces WHERE id=%d", idx);
      mysql_query(sql);
      mysql_store_result();
      if (mysql_num_rows() > 0)
      {
         mysql_fetch_row(Data);
      
          mysql_fetch_field_row(Field,"name");
          printf("%s, %d, %d", Field, totalannonce, idx);
          strmid(Recuiting[idx][rName],Field,0,strlen(Field),50);
          mysql_fetch_field_row(Field,"text");
          printf("%s, %d", Field, totalannonce);
          strmid(Recuiting[idx][rText],Field,0,strlen(Field),128);
          mysql_fetch_field_row(Field,"contact");
          printf("%s, %d", Field, totalannonce);
          strmid(Recuiting[idx][rContact],Field,0,strlen(Field),20);
          mysql_fetch_field_row(Field,"busy");
          Recuiting[idx][rBusy] = strval(Field);
        }
        mysql_free_result();
    }
    printf("%d recuiting announcements loaded from DB.", totalannonce);
    return 1;
}
Here are server logs:
Quote:

[17:35:14][17:35:14] Sweeper, 10, 1
[17:35:14] Vous conduisez une balayeuse а travers Los Santos afin de nettoyer les rues, 101
[17:35:14] ((/sweeper)), 101
[17:35:14] Aucun, 101, 2
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 3
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 4
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 5
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 6
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 7
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 8
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 9
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101, 10
[17:35:14] Aucun, 101
[17:35:14] Aucun, 101
[17:35:14] 101 recuiting announcements loaded from DB.
here is a screen of the DB:


This is really annoying, so if anyone could help me... Thanks
This should go to scripting discussion. It's not a plugin bug, it's a script bug.
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. Plugin Development