server side highscore, help needed

Unity Engine
1

it here -
http://www.unifycommunity.com/wiki/i...ide_Highscores

  1. what to do in step 3 ??

private var secretKey=“mySecretKey”; // Edit this value and make sure it’s the same as the one stored on the server

from where do i get this mySecretKey ??

  1. is this the right way to change db name, user name and password ??
<?php // Send variables for the MySQL database class. $database = mysql_connect('localhost', 'sco7_scores', 'mypasss') or die('Could not connect: ' . mysql_error()); mysql_select_db('sco7_scores') or die('Could not select database'); 3. it says u must add a gui text on a game object, i have added a guitext from GameObject bar, but how to add it to my empty gameobject ?? i dragged it on the gameobject but still error is there error is on this line - gameObject.guiText.text = "Loading Scores"; 4. i hope it works with the web player Thank in advance..
2

I have some problem

3

  1. Secretkey is whatever you want it to be. Just don’t let anyone know. If anyone finds out your key they can submit whatever high score they want.

  2. looks fine. (assuming username is same name as database)

  3. Gameobject → create other → GUI Text then attach script to that

  4. yes by default if webplayer on same server.

4

Can You help me with this error? Assets/Scripts/HSController.js(13,14): BCE0005: Unknown identifier: ‘Md5’.

5

question 3 ==> i did exactly the same but error is still there… and

about 1. where in my server shall i write and keep the secretkey ???

6

This line-> var hash=Md5.Md5Sum(name + score + secretKey); and this error->Assets/Scripts/HSController.js(13,14): BCE0005: Unknown identifier: ‘Md5’. Know anyone how to fix it?

7

http://www.unifycommunity.com/wiki/index.php?title=MD5

you need to put this in your project so the hashing will work, as described in the serverside highscores tutorial on the wiki…

8

Again the some error

9

Hey it loading score, and write this There was an error getting the high score: Rejected because no crossdomain.xml policy file was found
UnityEngine.MonoBehaviour:print(Object)
$:MoveNext() (at Assets/Scripts/HSController.js:32) Can anyone help?

10

http://unity3d.com/support/documentation/Manual/Security%20Sandbox.html

Crossdomain information is in here.

11

Ok i make new file name crossdomain.xml in ftp and add this file to server. In crossdomain.xml paste code

 <?xml version="1.0"?>
<cross-domain-policy>
<allow-access-from domain="*"/>
</cross-domain-policy>

And it is all?

12

Hey now when i play scene say this: screen → http://www.uloz.to/9808671/error-jpg (sorry, but you must download the screen)

13

Help please

14

that error is saying that the databse server cannot be found, you need to make sure you change mysql_host everywhere in the script to localhost or the IP of your database server

15

Where i can find the IP of my database server?

16

Hey when i rename all mysql_host to localhost say this ->> http://www.uloz.to/9823073/error2-jpg

17

Where is your MySql database located ?

18

www.endora.cz

19

http://www.unifycommunity.com/wiki/index.php?title=Server_Side_Highscores

now you need to change all mysql_user in all scripts to whatever your database username and also need to put in mysql_password with your database password and my_database with the name of your database., you need to do this in addscore.php and display.php

$db = mysql_connect('[B]mysql_host[/B]', '[B]mysql_user[/B]', '[B]mysql_password[/B]') or die('Could not connect: ' . mysql_error());
mysql_select_db('[B]my_database[/B]') or die('Could not select database');

You will have to ask your webhost what your database IP is, it is normally the same as the IP for your hosting server.

20

So I rename the name mysql_user as the database user name?