replication with external data

[JohnnyFantastic]

Hi. I've just finished hooking up UT to a mySQL database. At the moment I've got a couple of stats for each character like speed, jump height, etc. What's the proper way to replicate this data to each client? Here's what I'm currently doing:

Extended PlayerReplicationInfo, added my var's to the replicate block
Extended Pawn
When the UT receives a query response from mySQL the data in the PRI gets updated
Overloaded the pawn's Tick function so on each tick I set the Pawn's attributes based on the PRI

This method seems inefficient, so I'm assuming there's a better (proper) way to do it

Thanks for any help

 

[Mychaeel]

Create your own ReplicationInfo subclass to replicate the data. Then set bNetNotify and use its PostNetReceive event to set the Pawn's properties.

 

[JohnnyFantastic]

Great! Thanks a lot

Create your own ReplicationInfo subclass to replicate the data. Then set bNetNotify and use its PostNetReceive event to set the Pawn's properties.

 

[PVCGilde]

Hi. I've just finished hooking up UT to a mySQL database. At the moment I've got a couple of stats for each character like speed, jump height, etc. What's the proper way to replicate this data to each client? Here's what I'm currently doing:

Wow - that sounds great. Can you give me some hints how you did this? I would like to try something similar - but using SAPDB instead of mysql.

Best would be some code snipplets - since I am new to ut2003 I have sometimes problems finding the correct classes.

Thanks
Andreas / PVC

 

[Qjahe]

Code Sample...

I would also like to know how you managed that plz.
I managed to Load a file.php's output from my website onto a TextArea like they do in the News section..

Thats what I am wondering about. did you manage to have UScript directly access MYSQL and send query to it or are you passing by an external script...

could you share how you did it plz?

Qjahe