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

Threaded Mode
[Plugin] [REL] MySQL Plugin (Now on github!)
joco96
Big Clucker
***
Posts: 54
Threads: 8
Joined: Nov 2007
Reputation: 0
#41

24.03.2009, 16:10
Hi all!
I'm using this plugin, but I've got a question:
How can I make query, which gets back more than 1 row:
Here is my trying:
pawn Код:
new line[128], f=0, idx, field[MAX_PLAYER_NAME];
    CheckSQLConnection();
    mysql_query("SELECT * FROM forbnames");
    mysql_store_result();
    while(mysql_fetch_row(line)) {
      mysql_fetch_row_format(line, " ");
        field = strtok(line, idx);
        format(ForbidNames[f], MAX_PLAYER_NAME, field);
        f++;
    }
    mysql_free_result();
Thanx!
Find
Reply
Chaprnks
Gangsta
****
Posts: 603
Threads: 12
Joined: Sep 2007
Reputation: 0
#42

27.03.2009, 16:08
pawn Код:
new
    data[128],
    row[512],
    i;
mysql_query("SELECT * FROM `forbnames`");
mysql_store_result();
while(mysql_fetch_row(row))
{
    mysql_fetch_field_row(data, "Name on mysql column");
    strmid(ForbidNames[f], data, 0, strlen(data), MAX_PLAYER_NAME);
    i++;
}
Haven't tested but it should work.
Find
Reply
joco96
Big Clucker
***
Posts: 54
Threads: 8
Joined: Nov 2007
Reputation: 0
#43

27.03.2009, 18:30
Quote:
Originally Posted by ǝɹoɯ‾ʎ
pawn Код:
new
    data[128],
    row[512],
    i;
mysql_query("SELECT * FROM `forbnames`");
mysql_store_result();
while(mysql_fetch_row(row))
{
    mysql_fetch_field_row(data, "Name on mysql column");
    strmid(ForbidNames[f], data, 0, strlen(data), MAX_PLAYER_NAME);
    i++;
}
Haven't tested but it should work.
I wrote in this thread, I solved it.
I do it like u write it =), but 1 day ago.

But thank you!
Find
Reply
elvago
Gangsta
****
Posts: 510
Threads: 14
Joined: Jan 2009
Reputation: 0
#44

29.03.2009, 18:42
Sorry i Dont speak much english but i need Help, i like update my code for this mi old code are

Код:
	while(samp_mysql_strtok(arm, "|", armas)==1 && consulta[playerid] <= 6) //From 2nd call to the end you MUST call strtok without resultline
		{
		while(samp_mysql_strtok(arm, "|", "")==1 && consulta[playerid] <= 6) //From 2nd call to the end you MUST call strtok without resultline
		{
		consulta[playerid]++;
			if(consulta[playerid] == 1)
			{
	  	arma2[playerid] = strval(arm);
	  	if(arma2[playerid] == strval(""))
	  	arma2[playerid] = 0;
	  	printf("arma1: %s",arm); // palos
	  	}
	  	if(consulta[playerid] == 2)
			{
			arma3[playerid] = strval(arm);
			if(arma3[playerid] == strval(""))
	  	arma3[playerid] = 0;
			printf("arma2: %s",arm); // pistolitas
	  	}
	  	if(consulta[playerid] == 3)
			{
			arma4[playerid] = strval(arm);
			if(arma4[playerid] == strval(""))
	  	arma4[playerid] = 0;
			printf("arma3: %s",arm); //m4
	  	}
	  	if(consulta[playerid] == 4)
			{
			arma5[playerid] = strval(arm);
			if(arma5[playerid] == strval(""))
	  	arma5[playerid] = 0;
			printf("arma4: %s",arm); // escopetas
	  	}
	  	if(consulta[playerid] == 5)
			{
			arma6[playerid] = strval(arm);
			if(arma6[playerid] == strval(""))
	  	arma6[playerid] = 0;
			printf("arma5: %s",arm); // mp5
	  	}
		}
		}
Where i need change to update?

PD: Sorry my bad english thanks for you helpme
Find
Reply
elvago
Gangsta
****
Posts: 510
Threads: 14
Joined: Jan 2009
Reputation: 0
#45

30.03.2009, 05:44
nothing can helpme?
Find
Reply
Chaprnks
Gangsta
****
Posts: 603
Threads: 12
Joined: Sep 2007
Reputation: 0
#46

31.03.2009, 00:31
Quote:
Originally Posted by elvago
nothing can helpme?
pawn Код:
new
    data[128],
    row[512],
    i;
mysql_query("SELECT * FROM `DATABASE_NAME`");
mysql_store_result();
while(mysql_fetch_row(row))
{
    mysql_fetch_field_row(data, "Name on mysql column");
    arma2[playerid] = strval(arm);
    if(arma2[playerid] == strval(""))
    arma2[playerid] = 0;
    printf("arma1: %s",arm); // palos
    mysql_fetch_field_row(data, "Name on mysql column");
    arma3[playerid] = strval(arm);
    if(arma3[playerid] == strval(""))
    arma3[playerid] = 0;
    printf("arma2: %s",arm); // pistolitas
    mysql_fetch_field_row(data, "Name on mysql column");
    arma4[playerid] = strval(arm);
    if(arma4[playerid] == strval(""))
    arma4[playerid] = 0;
    printf("arma3: %s",arm); //m4
    mysql_fetch_field_row(data, "Name on mysql column");
    arma5[playerid] = strval(arm);
    if(arma5[playerid] == strval(""))
    arma5[playerid] = 0;
    printf("arma4: %s",arm); // escopetas
    mysql_fetch_field_row(data, "Name on mysql column");
    arma6[playerid] = strval(arm);
    if(arma6[playerid] == strval(""))
    arma6[playerid] = 0;
    printf("arma5: %s",arm); // mp5
    i++;
}
If that current code works on the old mySQL, this should.
Find
Reply
elvago
Gangsta
****
Posts: 510
Threads: 14
Joined: Jan 2009
Reputation: 0
#47

31.03.2009, 01:50
Thx, but the server are crashed you can fix this?

PD: sorry my bad english
Find
Reply
elvago
Gangsta
****
Posts: 510
Threads: 14
Joined: Jan 2009
Reputation: 0
#48

31.03.2009, 02:18
now the error are
mysql_fetch_field_row(arm, "palos");

''palos'' are a colum

PD: Sorry my bad english, Thanks for help me
Find
Reply
Michael_K
Little Clucker
**
Posts: 12
Threads: 0
Joined: Dec 2008
Reputation: 0
#49

05.04.2009, 17:58
every time i send "SELECT * FROM ..." and I call mysql_num_rows() i got all fine
but when ic call mysql_fetch_row(); the server crashes why?
if I call "SELECT `coloumnname` FROM ..." it worked fine.
Find
Reply
stijnthegamer
Little Clucker
**
Posts: 4
Threads: 0
Joined: Nov 2008
Reputation: 0
#50

07.04.2009, 06:45
I use this:

Код:
	mysql_connect("127.0.0.1","root","samp","root");
	printf("Connecting done");
	
	mysql_query("SELECT money FROM gebruikers WHERE naam = 'Stijn'");
	mysql_store_result();
	new row[1];
	new i;
	while(mysql_fetch_row(row))
	{
		printf("%d", row[i]);
		i++;
	}
In my database, money would be 125, but in my serverprompt it shows 78, and after that the server crashes.
I think the problem is by the fetching, inserthing things to the database is going like it should, but I coundn't read them.

Somebody can help me? And yeah, I've used the search enegine of this forum but still found nothing usefull.

Stijnthegamer.
Find
Reply
Hris
Little Clucker
**
Posts: 7
Threads: 1
Joined: May 2007
Reputation: 0
#51

08.04.2009, 07:27
if I use somethink like this:
pawn Код:
format(sql, sizeof(sql), "SELECT * FROM jobright WHERE userID = '%d' AND jobID = '%d'", GlobalAccountData[playerid][AccountID], JOB_MEDIC);
mysql_query(sql);
mysql_store_result();
if(mysql_num_rows() == 1)
    {
    //do somethink
    }
mysql_free_result();
The server crashes and creates a crashinfo.txt
But when I remove the mysql_free_result(); it just works fine..

Here is the content from the crashinfo.txt:
Код:
--------------------------

Exception At Address: 0x00B56ED0



Registers:

EAX: 0xDDDDDDDD	EBX: 0x00000001	ECX: 0xDDDDDDDD	EDX: 0x00DEFC15

ESI: 0x01215968	EDI: 0x0013F55C	EBP: 0x0013F55C	ESP: 0x0013F520

EFLAGS: 0x00010212



Stack:
Hris
Find
Reply
Michael_K
Little Clucker
**
Posts: 12
Threads: 0
Joined: Dec 2008
Reputation: 0
#52

09.04.2009, 00:03
my problem is done
don't use mysql_debug()
Find
Reply
michael2572
Big Clucker
***
Posts: 50
Threads: 9
Joined: Jan 2007
Reputation: 0
#53

11.04.2009, 16:42
Could someone who knows please explain what this error means?

Run time error 19: "File or function is not found"

I'm 100% positive I set up the plugin correctly. When I don't include the natives, the plugin loads successfully:
/************************************************/
/* SAMP-MySQL v0.13 Plugin loaded successfully ! */
/************************************************/

Yet when I DO include the natives, I get the runtime error. Which is a piece of crap, by the way, cause the damn thing is very vague and doesn't even give a line number.

Thanks in advance.
Find
Reply
simstosh
Big Clucker
***
Posts: 52
Threads: 11
Joined: Jul 2006
Reputation: 0
#54

13.04.2009, 17:45
I'm trying to compile the source but MAKE shows these errors... :/

Код:
[root@box source_files]# make
gcc -c -O3 -w -DLINUX -I../SDK/amx/ ../SDK/amx/*.c
g++ -c -O3 -w -DLINUX -I../SDK/amx/ ../SDK/*.cpp
g++ -c -O3 -w -DLINUX -I../SDK/amx/ *.cpp
In file included from main.cpp:3:
main.h:18:26: error: mysql/mysql.h: No such file or directory
source/mysqlhandler.h:16: error: 'my_ulonglong' does not name a type
main.h:38: error: 'MYSQL' does not name a type
main.h:39: error: 'MYSQL_ROW' does not name a type
main.h:40: error: ISO C++ forbids declaration of 'MYSQL_RES' with no type
main.h:40: error: expected ';' before '*' token
main.h:41: error: ISO C++ forbids declaration of 'MYSQL_FIELD' with no type
main.h:41: error: expected ';' before '*' token
make: *** [all] Error 1
Anyone knows wth is this?
Find
Reply
ADreNaLiNe-DJ
Huge Clucker
***
Posts: 208
Threads: 1
Joined: Aug 2006
Reputation: 0
#55

14.04.2009, 17:11
Please post in the correct topic...

You're not in the samp-myql topic but in the alternative mysql plugin topic...

Quote:
Originally Posted by michael2572
Could someone who knows please explain what this error means?

Run time error 19: "File or function is not found"

I'm 100% positive I set up the plugin correctly. When I don't include the natives, the plugin loads successfully:
/************************************************/
/* SAMP-MySQL v0.13 Plugin loaded successfully ! */
/************************************************/

Yet when I DO include the natives, I get the runtime error. Which is a piece of crap, by the way, cause the damn thing is very vague and doesn't even give a line number.

Thanks in advance.
Find
Reply
pspleo
Gangsta
****
Posts: 747
Threads: 12
Joined: Nov 2007
Reputation: 0
#56

14.04.2009, 17:57
Good plugin!
I'm doing small functions (i'm beginner) so yeah, would this kinda work:

http://pastebin.com/f2d46eb31

http://pastebin.com/f6b724ec5

Leopard
Find
Reply
Slice
High-roller
*****
Posts: 1,831
Threads: 69
Joined: Mar 2008
Reputation: 0
#57

18.04.2009, 14:09
Quote:
Originally Posted by simstosh
I'm trying to compile the source but MAKE shows these errors... :/

Код:
[root@box source_files]# make
gcc -c -O3 -w -DLINUX -I../SDK/amx/ ../SDK/amx/*.c
g++ -c -O3 -w -DLINUX -I../SDK/amx/ ../SDK/*.cpp
g++ -c -O3 -w -DLINUX -I../SDK/amx/ *.cpp
In file included from main.cpp:3:
main.h:18:26: error: mysql/mysql.h: No such file or directory
source/mysqlhandler.h:16: error: 'my_ulonglong' does not name a type
main.h:38: error: 'MYSQL' does not name a type
main.h:39: error: 'MYSQL_ROW' does not name a type
main.h:40: error: ISO C++ forbids declaration of 'MYSQL_RES' with no type
main.h:40: error: expected ';' before '*' token
main.h:41: error: ISO C++ forbids declaration of 'MYSQL_FIELD' with no type
main.h:41: error: expected ';' before '*' token
make: *** [all] Error 1
Anyone knows wth is this?
I get that too, I'm a complete noob when it comes to C++!
Find
Reply
kingdutch
Little Clucker
**
Posts: 47
Threads: 2
Joined: Mar 2009
Reputation: 0
#58

19.04.2009, 12:38
Yep same for me, looks like you made a little mistake there G-Styelzzzz :O

Reason I'm recompiling is because the .so file you gave us will crash on mysql_num_rows();

EDIT: To compile make sure you have the file mysql.h
which comes in:
[21:00] <@mabako> rc libmysqlclient15-dev 5.0.32-7etch8 mysql database development files

(apt-get install libmysqlclient15-dev)
Find
Reply
[IB]Scorcher
High-roller
*****
Posts: 1,007
Threads: 15
Joined: Nov 2007
Reputation: 0
#59

20.04.2009, 15:25
You are awesome, G Stylzz for this one.
Find
Reply
mysan
Big Clucker
***
Posts: 88
Threads: 5
Joined: May 2008
Reputation: 0
#60

25.04.2009, 11:25
I have a problem . Plugin doesn't work on VPS server WINDOWS SERVER 2003. Plugin by adrenaline work but no have needed functions
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


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