User Account System

#101 #1. Welcome to the forums. (I say this because of the lack of info provided regarding your request for help)

#2. What version of Torque are you using?

#3. What version of UAC are you using?

#4. I am a php wiz and I have yet to get the 3.3 working. Matter of fact I stopped trying. Version 3.1 works perfectly. It's really neat. I have enhanced it in a way that it's hashed and unable to be opened by any editor.

I believe I got Version 3.2 working but never had a need for it's functions. I tested all of them using TGE 1.5.2. Thanks.

#102 I’ve got 3.3 working in TGE 1.5.2. I’m still looking through the Score, Awards and PlayerList code to figure out how it all works. A few suggestions for others who might have had some challenges getting this initially set up:

• Copied only the execs (for the new scripts and gui’s) and strSplit function into init.cs
• Copied just the Register, Login and MemberPanel buttons from the MainMenuGui.gui in the resource to my customized main menu
• Created php forms to test the php/mysql connection first. You can also check that the MySQL/PHP is working by registering / logging in directly via the URLs, e.g. http://mygamewebsite.com/register.php?name=test1&username=test1&password=test1, http:// mygamewebsite.com/login.php?username=test1&password=test1
• Added in the example and engine code - enginegamenet – already had the httpObject.cc and .h header file – I overwrote httpObject.cc (not sure if this is the latest though)
• Received “Could not connect to web server” error message upon trying to login – modified connect settings in database.php
• Scores/Awards work pretty easily. Used awards::appendaward function for adding awards, and updated the score.currentscore global variable and run score::writeoutscores to save the score.

Quote:It does not seem to be working correctly for me, whenever I register a user it doesn't work right. In the database the name field is blank the username field says something like "test1 password=test name=test" depending upon the information I enter when trying to register, and the password field always says "da39a3ee5e6b4b0d3255bfef95601890afd80709"

@Sgb Gem - I had the same problem. I fixed this by changing HTTPObject.cc to not escape the & (ampersand) so I could pass variables in the query string:

httpObject.cs Line 31 (changed):

// asciiEscapeTable['&'] = true;

And changed uac.cs to include the ‘&’ when passing variables. There’s probably a cleaner way to do this but it worked for me:
uac.cs Line 135 (in register function):

%querystring = "username="@%username@"&password="@%password@"&name="@%name;

uacs.cs Line 162 (in login function):

%querystring = "username="@%username@"&password="@%password;

@ James – thanks for putting this together and for all of your continued updates!! Question - are there any security risks with this resource and/or any recommendations on pieces to fix to make it more secure? Maybe we could add an email confirmation to the process?

#103 Jake,
Thanks for the pointers. I'm also using TGE 1.5.2 and version 3.3, but I'm totally green when it comes to the web server part of it.

I added the engine and the example parts, recompiled, and the main menu loads up with the Register, Login and Member Panel buttons. Obviously they do not do anything because I have not setup a web server yet.

How do I do this? I have a new microsoft office live website. Where exactly do I put the PHP and SQL files?
Thanks!

#104 Hey John,

I found this on some Microsoft forum in regards to using PHP/MySQL on MS Office Live - "No, we do not support PHP, MySQL or GD Library, and will not for the foreseeable future."

I'd recommend checking out a hosting provider like Bluehost or Hostgator (I use the Hostgator). For like $10/month you can host a site with CPanel and most of the typical apps you'd expect.

Once you've got a host setup, FTP in the php scripts and run the MySQL script.

Jake

#105 Hey Jake,

I signed up with hostgator, setup the database and can now register and login using my browser: http://mygamewebsite.com/register.php?name=test1&username=test1&password=test1, http:// mygamewebsite.com/login.php?username=test1&password=test1......thanks for the tip.

However, when I try to register through TGE, I get "Couldnt connect to webserver". You said, above, that you modified the database.php settings when you got the same error...could you please elaborate further.

In uac.cs line 14, I changed $uac::HTTPHost = "localhost:80"; to $uac::HTTPHost = "http://mygamewebsite.com";

Thanks!

#106

<?
$uac::HTTPHost = "yourgame.com:80";
$uac::Location = "/folder_on_eserver/";
$uac::registerPage = "register.php";
$uac::loginPage = "login.php";
$uac::scorePage = "stats.php";
$uac::awardsPage = "awards.php";
$uac::result = "";
$uac::curfunction = "";
$uac::lastmessage = "";

That should do you there, it may need the port there, I had it working on my home server and my offsite server. I know it works

#107 Thanks, J-man, that was it! And thank you James for the resource, I will be using it.

#108 I'm using tge 1.4.2 and uac3.3. when I compile using 2005 express edition I get the following errors

uac.cpp(39)typebool undeclared identifier
uac.cpp(40)typestring undeclared identifier

I'm running a wamp server with mysql. what I've done is copy all the php files into my www folder.

I also copyed all the files from the example folder over to starter.fps.

I then copyed all the engine files over to my engine folder.

I then copyed all the engine source and header files into the vs2005 project.

Oh I also put in the sql file.

When I run the program all the buttons show and almost work, but when I click the button to register it just hangs.

anyone got any ideas?

also since I am using wamp server do I have to copy some of the dlls over to the souce?

thanks.

#109 Im not sure on your stuff Dave, I have 1.52 You may want to upgrade to 2008 express and see what that does, may help, may not.

Whats in your datafolders ?

Sounds like it maybe timing out. Can you post your console log ?

#110 This is the log Looks ok except for the break outside of loop... ignoring.
I thought I saw somthing about that in this form, but I don't think there was a solution for it. I'll look again and also try vc2008.
Guess I couldn't post the whole log. Too Big. Everything before this is ok. This is where the errors start.




Loading compiled script starter.fps/client/scripts/memberpanel.cs.
Compiling starter.fps/client/scripts/uac.cs...
starter.fps/client/scripts/uac.cs (39): break outside of loop... ignoring.
starter.fps/client/scripts/uac.cs (43): break outside of loop... ignoring.
starter.fps/client/scripts/uac.cs (48): break outside of loop... ignoring.
starter.fps/client/scripts/uac.cs (52): break outside of loop... ignoring.
starter.fps/client/scripts/uac.cs (63): break outside of loop... ignoring.
starter.fps/client/scripts/uac.cs (68): break outside of loop... ignoring.
starter.fps/client/scripts/uac.cs (86): break outside of loop... ignoring.
Loading compiled script starter.fps/client/scripts/uac.cs.
Compiling starter.fps/client/scripts/score.cs...
starter.fps/client/scripts/score.cs (19): break outside of loop... ignoring.
starter.fps/client/scripts/score.cs (23): break outside of loop... ignoring.
starter.fps/client/scripts/score.cs (42): break outside of loop... ignoring.
Loading compiled script starter.fps/client/scripts/score.cs.
Compiling starter.fps/client/scripts/awards.cs...
starter.fps/client/scripts/awards.cs (21): break outside of loop... ignoring.
starter.fps/client/scripts/awards.cs (25): break outside of loop... ignoring.
starter.fps/client/scripts/awards.cs (42): break outside of loop... ignoring.
Loading compiled script starter.fps/client/scripts/awards.cs.
Compiling starter.fps/client/scripts/default.bind.cs...
Loading compiled script starter.fps/client/scripts/default.bind.cs.
Missing file: starter.fps/client/config.cs!
Binding server port to default IP
UDP initialized on port 0

--------- Initializing: Torque Creator ---------
Compiling creator/editor/editor.cs...
Loading compiled script creator/editor/editor.cs.
Compiling creator/editor/particleEditor.cs...
Loading compiled script creator/editor/particleEditor.cs.
Compiling creator/scripts/scriptDoc.cs...
Loading compiled script creator/scripts/scriptDoc.cs.
Compiling creator/ui/creatorProfiles.cs...
Loading compiled script creator/ui/creatorProfiles.cs.
Compiling creator/ui/InspectDlg.gui...
Loading compiled script creator/ui/InspectDlg.gui.
Compiling creator/ui/GuiEditorGui.gui...
Loading compiled script creator/ui/GuiEditorGui.gui.
Engine initialized...
*** Load Main Menu
keyboard0 input device created.
mouse0 input device created.
Exporting client prefs
Exporting client config
Exporting server prefs
Exporting client prefs
Exporting server prefs
Shutting down the OpenGL display device...
Making the GL rendering context not current...
Deleting the GL rendering context...
Releasing the device context...

#111 @Dave, try making the changes suggested above by Jake T (comment #102). Also try to connect directly to your database using a web browser as he suggests. That should help isolate the problem.

@J-man
My register works but login has an error:

starter.fps/client/init.cs (31): Unable to instantiate non-conobject class Array.
starter.fps/client/init.cs (42): Unable to find object: '0' attempting to call function 'add'
starter.fps/client/init.cs (54): Unable to find object: '0' attempting to call function 'add'
starter.fps/client/scripts/uac.cs (76): Unable to find object: '0' attempting to call function 'getValue'
starter.fps/client/scripts/uac.cs (77): Unable to find object: '0' attempting to call function 'getValue'

Did you encounter this? I replaced the arrayObject.cc with the latest one from Dan Nielsen's resource but I'm still getting the same error.

Thanks!

#112 @Dave
Umm I am not sure on yours, could be anything, Have you tried on the forums ?

@John
Have you tried to clean and then rebuild ? Sorry I can only offer the simple solutions that I know caused me grief. I would try to do a clean build of the engine with the stock UAC stuff. If I remember right, I think I seen in the forums that

Unable to instantiate non-conobject class Array

means it is missing

#113 @Dave
Did you make sure on your WAMP server to start all the services and put it online? I'm not sure what WAMP package you are using, I am using this.
http://www.wampserver.com/en/
However when I had forgot to start the services and put it online I was having the same troubles as you.

#114 @ Wayne Eversole

To get this to compile in TGEA you will need to put:

#include "console/consoleTypes.h"

after #include "console/console.h" in UAC.cpp

#115 Anyone know how I'd set a timeout to stop trying to connect after, say, 60 seconds?

#116 Edit: nvm.

#117 Is anyone using this and has it working?
James, I tried to email you with the email in your profile but got a return back saying it was not valid.

Thanks

#118 hello!
Email should be fine its the correct one.
I havnt played around with this for ages so I dont know if its working.
Whats the problem your having?

#119 Thanks for the reply.
I have managed to get it all working in TGEA 1.8.1 except when I type the correct username and password I get an error saying.

That user ID was incorrect, please try lgging in agian.
I am using version 3.3

Thanks

Edit...
If I type in an incorrect username and pass I get the error.
Incorrect username/password.
Only when I use the correct one do I get the error msg above.

#120 I also have this in console.log.

C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/uac.cs (39): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/uac.cs (43): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/uac.cs (48): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/uac.cs (52): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/uac.cs (63): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/uac.cs (68): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/uac.cs (86): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/score.cs (19): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/score.cs (23): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/score.cs (42): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/awards.cs (21): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/awards.cs (25): break outside of loop... ignoring.
C:/Torque/TGEA_1_8_1/GameExamples/Stronghold/game/scriptsAndAssets/client/scripts/awards.cs (42): break outside of loop... ignoring.

and
1~test
scriptsAndAssets/client/scripts/uac.cs (74): Unable to find function strSplit
scriptsAndAssets/client/scripts/uac.cs (76): Unable to find object: '' attempting to call function 'getValue'
scriptsAndAssets/client/scripts/uac.cs (77): Unable to find object: '' attempting to call function 'getValue'

Warning! You have a duplicate datablock name of UACOnline. This can cause problems. You should rename one of them.
scriptsAndAssets/client/scripts/uac.cs (67): Unknown command logout.