Hi Scotty,

I Think setting up some web pages to register, retrieve and update info should be relatively straight forward. Im a bit busy this week with work but would love to look at doing this.
The only bit which might be tricky is making sure the database/server is secure and protected from anything malicious (I think that might be the time consuming part!).

I'll take a look at it and send over some ideas for you to look at next weekend if that works? I'm a firm believer in keep it simple so will see what I can find out!

Best regards,

Ian

P.s. thanks again for your help with getting the server up and running! Once I have proven the installation to be stable and my broadband connection to be good enough I'll send over the details for inclusion if you like :)

P.s. I started the server automatically on booting the pi by using the following commands to add it to the rc.conf file on Raspberian

sudo nano /etc/rc.local
 

Then adding the following line: (scrabble server is the name of the server executable on my server)

sudo /home/pi/./ScrabbleServer -u DATABASE_USERNAME -p DATABASE_PASSWORD -d DATABASE_NAME 
 

It works!!! I ran the following Query in PhpMyAdmin to populate the table:

INSERT INTO `Users`(`Name`, `Passwd`, `Key`, `GamesPlayed`, `Rating`, `Registered`, `LastConnect`, `LastIP`, `LastMac`, `Messages`, `AllowKibitz`, `Email`)
VALUES ('testuser','password','1','1','1000','12/08/2012','12/08/2012','192.168.1.1','11111111','blah','1','test@test.com');

Now the server runs without errors! thanks for your advice :)

and to generate the database creation SQL Code you can do the following:

1. Open Phpmyadmin (eg mysever/phpmyadmin/)
2. Navigate to the Scrabble3d database
3. Click on the users table
4. Click on the export tab
5. Choose 'Quick' and ensure the format is selected as SQL
6. Click 'Go'

This will download the database structure in SQL format.

Hope this helps and again thanks for taking the time to look at this for me! I'll put together a quick how-to for the raspberryPI shortly

Best regards,

Ian