Gamestudio Links
Zorro Links
Newest Posts
lookback setting performance issue
by 7th_zorro. 04/16/24 03:08
folder management functions
by 7th_zorro. 04/15/24 10:10
zorro 64bit command line support
by 7th_zorro. 04/15/24 09:36
Zorro FIX plugin - Experimental
by flink. 04/14/24 07:48
Zorro FIX plugin - Experimental
by flink. 04/14/24 07:46
LPDIRECT3DCUBETEXTUR
E9

by Ayumi. 04/12/24 11:00
Sam Foster Sound | Experienced Game Composer for Hire
by titanicpiano14. 04/11/24 14:56
SGT_FW
by Aku_Aku. 04/10/24 16:09
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
2 registered members (7th_zorro, Quad), 373 guests, and 3 spiders.
Key: Admin, Global Mod, Mod
Newest Members
11honza11, ccorrea, sakolin, rajesh7827, juergen_wue
19045 Registered Users
Previous Thread
Next Thread
Print Thread
Rating: 4
Page 23 of 24 1 2 21 22 23 24
Re: CSmySQL New functions (SSL comming soon) [Re: MMike] #300785
12/05/09 06:36
12/05/09 06:36
Joined: Nov 2009
Posts: 96
philippines
joh Offline
Junior Member
joh  Offline
Junior Member

Joined: Nov 2009
Posts: 96
philippines
i used the xampp as well but maybe ill just use the wamp thank u

Re: CSmySQL New functions (SSL comming soon) [Re: joh] #305351
01/14/10 10:39
01/14/10 10:39
Joined: Nov 2009
Posts: 96
philippines
joh Offline
Junior Member
joh  Offline
Junior Member

Joined: Nov 2009
Posts: 96
philippines
can someone teach me how am i going to get record from the database and use it as a name of my character? i want to put it at the top of my player's head

Re: CSmySQL New functions (SSL comming soon) [Re: joh] #305371
01/14/10 13:44
01/14/10 13:44
Joined: Oct 2004
Posts: 4,134
Netherlands
Joozey Offline
Expert
Joozey  Offline
Expert

Joined: Oct 2004
Posts: 4,134
Netherlands
Code:
var char_id = 5; //we want the name of character number 5
str_for_num( strChar_id, char_id );
str_cpy( query, "SELECT name FROM characters WHERE char_id = " );
str_cat( query, strChar_id );

//do the mysql query with query string



Like that?

Last edited by Joozey; 01/14/10 13:45.

Click and join the 3dgs irc community!
Room: #3dgs
Re: CSmySQL New functions (SSL comming soon) [Re: Joozey] #305382
01/14/10 14:33
01/14/10 14:33
Joined: Nov 2009
Posts: 96
philippines
joh Offline
Junior Member
joh  Offline
Junior Member

Joined: Nov 2009
Posts: 96
philippines
but my character has no id? its not actually a game that you have to sign up.

so what im going to use instead of id? i just use ent_create for the player and what i want is that when my admin updates the database the name at the top of the character should update too

Re: CSmySQL New functions (SSL comming soon) [Re: joh] #305386
01/14/10 14:46
01/14/10 14:46
Joined: Oct 2007
Posts: 5,210
İstanbul, Turkey
Quad Online
Senior Expert
Quad  Online
Senior Expert

Joined: Oct 2007
Posts: 5,210
İstanbul, Turkey
@jooz
thanks to str_printf we can do

str_printf(query,"SELECT name FROM characters WHERE char_id = %d",(int)char_id);

instead of

str_for_num( strChar_id, char_id );
str_cpy( query, "SELECT name FROM characters WHERE char_id = " );
str_cat( query, strChar_id );

sorry for oftopic.


3333333333
Re: CSmySQL New functions (SSL comming soon) [Re: Quad] #305453
01/14/10 20:38
01/14/10 20:38
Joined: Jul 2004
Posts: 1,710
MMike Offline
Serious User
MMike  Offline
Serious User

Joined: Jul 2004
Posts: 1,710
guys can someone give ma Valid Link? to it, i cant download.. its broken:S

Re: CSmySQL New functions (SSL comming soon) [Re: MMike] #305455
01/14/10 20:46
01/14/10 20:46
Joined: Nov 2002
Posts: 913
Berlin, Germany
S
SchokoKeks Offline
User
SchokoKeks  Offline
User
S

Joined: Nov 2002
Posts: 913
Berlin, Germany
Originally Posted By: MMike
guys can someone give ma Valid Link? to it, i cant download.. its broken:S


The link on the first page still works for me:
download here, original version

dll also works great for me.

Re: CSmySQL New functions (SSL comming soon) [Re: SchokoKeks] #305822
01/17/10 15:10
01/17/10 15:10
Joined: Jul 2004
Posts: 1,710
MMike Offline
Serious User
MMike  Offline
Serious User

Joined: Jul 2004
Posts: 1,710
OH ok that on did... a6 dll works on a7 right? Thanks now i can test myself

Last edited by MMike; 01/17/10 15:10.
Re: CSmySQL New functions (SSL comming soon) [Re: MMike] #306015
01/19/10 01:21
01/19/10 01:21
Joined: Oct 2004
Posts: 4,134
Netherlands
Joozey Offline
Expert
Joozey  Offline
Expert

Joined: Oct 2004
Posts: 4,134
Netherlands
Oh right, thanks Quadraxas laugh. I'm too old fashioned.

@joh:
Not sure what you want, but you need to know what player you want to pull out of the database. if there is only one player, you can simply do "SELECT name FROM players" or something the like. If there are more players... I don't know how this DLL handles arrays, but you'd probably get the first result found returned.


Click and join the 3dgs irc community!
Room: #3dgs
Re: CSmySQL New functions (SSL comming soon) [Re: Joozey] #306072
01/19/10 13:52
01/19/10 13:52
Joined: Nov 2009
Posts: 96
philippines
joh Offline
Junior Member
joh  Offline
Junior Member

Joined: Nov 2009
Posts: 96
philippines
@joozey i load a player using ent_create so definitely there's no record in the database to select player. i want to assign a name on my players above their head which is found in the database

Page 23 of 24 1 2 21 22 23 24

Moderated by  adoado, checkbutton, mk_1, Perro 

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