Gamestudio Links
Zorro Links
Newest Posts
Change chart colours
by 7th_zorro. 05/11/24 09:25
Data from CSV not parsed correctly
by dr_panther. 05/06/24 18:50
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
5 registered members (AndrewAMD, alibaba, Konsti, 2 invisible), 1,418 guests, and 2 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Hanky27, firatv, wandaluciaia, Mega_Rod, EternallyCurious
19051 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Page 2 of 3 1 2 3
Re: AckMySQL [Re: XuserTM] #333623
07/17/10 18:52
07/17/10 18:52
Joined: Jun 2009
Posts: 3
K
Kral Offline
Guest
Kral  Offline
Guest
K

Joined: Jun 2009
Posts: 3
thank you (:

Re: AckMySQL [Re: XuserTM] #333626
07/17/10 19:07
07/17/10 19:07
Joined: Nov 2009
Posts: 37
X
XuserTM Offline
Newbie
XuserTM  Offline
Newbie
X

Joined: Nov 2009
Posts: 37
unsigned long ackmysql_num_rows(int savekey);
Shows how many rows the result, given in savekey, has

Returns:
*
The number of rows.
__________
This is not Return the number of rows???

Re: AckMySQL [Re: XuserTM] #333627
07/17/10 19:09
07/17/10 19:09
Joined: May 2009
Posts: 445
Peine, Germany
Razoron Offline OP
Senior Member
Razoron  Offline OP
Senior Member

Joined: May 2009
Posts: 445
Peine, Germany
It returns the number of rows... I tested it at my serverlist.

Re: AckMySQL [Re: Razoron] #333632
07/17/10 19:40
07/17/10 19:40
Joined: Nov 2009
Posts: 37
X
XuserTM Offline
Newbie
XuserTM  Offline
Newbie
X

Joined: Nov 2009
Posts: 37
My mysql table
||||||id ||User |||| pass
1 aaa bbb
2 dddd bzzbb



I could not do ,
ackmysql_query_result_threaded("SELECT * FROM users WHERE User ='dddd'",1);
wait(5);
num_rows = ackmysql_num_rows(1);
ackmysql_fetch_row(1, 1, result);


result = 2 . it is id.
Bud I want result pass.
I try
ackmysql_fetch_row(1, 2, result);
bud did not.

Re: AckMySQL [Re: XuserTM] #333637
07/17/10 20:03
07/17/10 20:03
Joined: May 2009
Posts: 445
Peine, Germany
Razoron Offline OP
Senior Member
Razoron  Offline OP
Senior Member

Joined: May 2009
Posts: 445
Peine, Germany
You don't need to use mysql_num_rows.

Code:
ackmysql_query_result_threaded("SELECT pass FROM users WHERE User='dddd'", 1);

while(ackmysql_query_state() == ACKMYSQL_RUNNING) {wait(1);}

ackmysql_fetch_row(1, 0, result);



Re: AckMySQL [Re: Razoron] #333638
07/17/10 20:08
07/17/10 20:08
Joined: Nov 2009
Posts: 37
X
XuserTM Offline
Newbie
XuserTM  Offline
Newbie
X

Joined: Nov 2009
Posts: 37
Thanks a lot,I succeed.

Re: AckMySQL [Re: XuserTM] #335936
07/31/10 19:39
07/31/10 19:39
Joined: Jun 2010
Posts: 12
I
invictus Offline
Newbie
invictus  Offline
Newbie
I

Joined: Jun 2010
Posts: 12
hi... im having a problem connecting 3dgs to ackmysql... it always says empty prototype in main when i run the test... i alread placed the necessary files (dlls and headers) to their respective folder but im still having problems.. im using only a free version of 3dgs..

Re: AckMySQL [Re: invictus] #336080
08/01/10 14:35
08/01/10 14:35
Joined: Nov 2009
Posts: 37
X
XuserTM Offline
Newbie
XuserTM  Offline
Newbie
X

Joined: Nov 2009
Posts: 37
function main()
{
ackmysql_init();
wait(1);
... your code...
}

=)

Re: AckMySQL [Re: XuserTM] #336207
08/02/10 11:37
08/02/10 11:37
Joined: May 2009
Posts: 445
Peine, Germany
Razoron Offline OP
Senior Member
Razoron  Offline OP
Senior Member

Joined: May 2009
Posts: 445
Peine, Germany
No, ackmysql would crash if you don't initialize it. You won't get an empty prototype error.
Did you copy also libmysql.dll to your projects plugin dir?
Show me your acklog.
Did you install VC++ 2010 redistributable (32 bit)?

Last edited by Razoron; 08/02/10 11:37.
Re: AckMySQL [Re: Razoron] #336369
08/03/10 13:38
08/03/10 13:38
Joined: Jan 2010
Posts: 23
D
Darkmax Offline
Newbie
Darkmax  Offline
Newbie
D

Joined: Jan 2010
Posts: 23
im having the same problem that invictus.

i copy the ackmysql.dll and libmysql.dll to c:\Program Files\GStudio7 (i think is there where i have to paste those files)

then i paste the ackmysql.h to my project folder and tried the test.c that you include in the zip file.

I change the information of the database with mine, but when i run the program, says an error "Empty prototype called in main" and also "Couldn't connect to mysql server".

If some one knows why im having this errors?, i would be very pleased because im trying to use gamestudio for a project and using a database is a must.

Last edited by Darkmax; 08/03/10 13:39.
Page 2 of 3 1 2 3

Moderated by  HeelX, Lukas, rayp, Rei_Ayanami, Superku, Tobias, TWO, VeT 

Gamestudio download | chip programmers | Zorro platform | shop | Data Protection Policy

oP group Germany GmbH | Birkenstr. 25-27 | 63549 Ronneburg / Germany | info (at) opgroup.de

Powered by UBB.threads™ PHP Forum Software 7.7.1