Gamestudio Links
Zorro Links
Newest Posts
Free Live Data for Zorro with Paper Trading?
by dr_panther. 05/18/24 11:01
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
2 registered members (7th_zorro, dr_panther), 724 guests, and 3 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
Lite-C with MySql (Ent_Create) #216756
07/18/08 16:41
07/18/08 16:41
Joined: May 2007
Posts: 185
Netherlands
SurudoiRyu Offline OP
Member
SurudoiRyu  Offline OP
Member

Joined: May 2007
Posts: 185
Netherlands
Hi all,

Im having problem's with this:

Code:

str_cpy(MyQuery, "SELECT * FROM RF_NPC");

if(!mySQL_IsConnected())
{
// display: disconnected
printf("Database Down!");
}
else
if(mySQL_ExecQuery(MyQuery) && mySQL_RowNumber() > 0)
{
var Temp_NPC;
var Temp_NPC_PosX;
var Temp_NPC_PosY;
var Temp_NPC_PosZ;

var i;
wait(1);
			mySQL_GetStr(Temp_NPC,1,0);			ent_create(Temp_NPC,vector(0,0,0),NULL); 
wait(1);
				

}



It gives an error with weird characters.
What im doing wrong ?
And yes DB is connected this is not all of my script but here its going wrong.
I allready can Login And create Account so it works only this part to create dynamicly entity's
there is atm only 1 entry in the DB (skelet.mdl)
that i read out and parse to 3dgs.
VarChar 50 with:
0 = ID
1 = Name
2 = Xpos
3 = Ypos
4 = Zpos
5 = Function


-The Dragon's Eye is alway's watching you!-
Re: Lite-C with MySql (Ent_Create) [Re: SurudoiRyu] #216821
07/18/08 22:21
07/18/08 22:21
Joined: Nov 2007
Posts: 1,032
Croatia
croman Offline
Serious User
croman  Offline
Serious User

Joined: Nov 2007
Posts: 1,032
Croatia
can you post what says in that error message? or perhaps you can post that screen of that error?



Ubi bene, ibi Patria.
Re: Lite-C with MySql (Ent_Create) [Re: croman] #216879
07/19/08 13:32
07/19/08 13:32
Joined: May 2007
Posts: 185
Netherlands
SurudoiRyu Offline OP
Member
SurudoiRyu  Offline OP
Member

Joined: May 2007
Posts: 185
Netherlands
Here is the error,





Hope u can help me out.



Greetzzz,


-The Dragon's Eye is alway's watching you!-
Re: Lite-C with MySql (Ent_Create) [Re: SurudoiRyu] #217142
07/21/08 16:42
07/21/08 16:42
Joined: May 2007
Posts: 185
Netherlands
SurudoiRyu Offline OP
Member
SurudoiRyu  Offline OP
Member

Joined: May 2007
Posts: 185
Netherlands
Hmm got it working right now,
I used Var Temp_NPC; instead of STRING* Temp_NPC = "#50";

so it is solved!


-The Dragon's Eye is alway's watching you!-

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