Game Development Community

dev|Pro Game Development Curriculum

User Account System

by Skylar Kelty · 11/13/2006 (4:37 pm) · 170 comments

---------------------------------------------------------------------------------------------------
Version 3
---------------------------------------------------------------------------------------------------

Version 3.3 - Updated!
download v3.3
Version 3.3 uses Web-Server Interaction and features awards, stats and member panel.
This version requires PHP, MYSQL and TorqueScript Knowledge.
If you have downloaded this before, make sure you clear your browser's cache!

Version 3.2
download v3.2
Version 3.2 uses SQLLite and features awards, stats and member panel.

Version 3.1 - Untested!
download v3.1
Version 3.1 uses xml and features awards, stats and member panel.

---------------------------------------------------------------------------------------------------
Old Versions
---------------------------------------------------------------------------------------------------

Version 2 - No longer supported!
download v2
Version 2 uses SQLite, which is more secure. Some of you may not want to use SQLite, if you dont, use v1.2

Version 1.2 - No longer supported!
download v1.2
Version 1.2 uses the fileobject

---------------------------------------------------------------------------------------------------
ChangeLog
---------------------------------------------------------------------------------------------------

UPDATES:
v1.1 - bug fixes
v1.2 - now uses c++
v2 - now uses SQLite
v3 - Fixes, Updates and 3.3 uses web-server interaction
v3.3 - Updated to.. actually work.. see comments
#81
07/14/2008 (1:54 pm)
Has it been that long? woah.. sorry, didnt seem like that long ago i posted version 1!
#82
07/14/2008 (2:09 pm)
James, I haven't had a chance to try and implement this, but I've been watching since it was released as well. I figured I'd speak up and say thank you for the great contribution!
#83
07/20/2008 (8:48 pm)
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"

Any idea as to what is wrong? The only php script I changed was the database page.
#84
07/20/2008 (11:02 pm)
I reconise that password hash... thats my password.. damnnit *changes GG password*
If I wasnt going on holiday in 5 minutes id take a look but ive just been called for boarding so ill look when i get back.
#85
07/21/2008 (12:29 pm)
Well, at least the password was encrypted, so you don't have too much to worry about, cracking the password would probably take a while.

Ohh, I also forgot to mention I am using version 3.3 I downloaded it a couple days ago.

Edited Again: Ok, it looks like in client\scripts\uac.cs on line 193. It seems that is where it is getting the password from.
#86
07/22/2008 (1:35 am)
Just a quick question. With this:

$db = mysql_connect ("localhost", "root", "") or die ('MYSQLError');
?>

Root is our MySql Databse username and the "" shows where the MySql password should go, correct?
#87
07/22/2008 (9:56 am)
Yes
mysql_connect(servername, username, password);
#88
07/22/2008 (12:04 pm)
Is version 3.3 working correctly for everyone except me? or are people just not reporting problems with it? If anyone does have version 3.3 working correctly, what all did you change to make it work?
#89
07/23/2008 (12:18 am)
function UAC::register(%this, %username, %password, %name)

Echo your username and password in there, just before the query. if those are the right values then its a php issue.

Use : print_r($_GET);
to see whats being sent to php

If thats fine then its an issue in the php scripts.

I dont see this issue, noone else has let me know yet.

EDIT: Its not a php issue, could be an issue in the way the query string is being sent. Cant test that till i get back though.
#90
07/23/2008 (9:51 am)
Line 193 of uac.cs should be changed from return "yehornot" to return UAC.Password correct?
#91
07/23/2008 (11:00 am)
I didnt like it, for security, but if you want.
Shouldnt affect the resource.
#92
07/23/2008 (12:16 pm)
Ohh, ok I honestly didn't know it was supposed to be yehornot I thought that might have been where it was getting your password from. Any idea as to why my password field always ends up with your password hash somehow?
#93
07/24/2008 (12:54 am)
Try my suggestions from the (Jul 23, 2008 at 07:18 GMT) post above and post your results.
It may be better to continue this by email, so we dont spam the resource...
email links in my profile.
#94
07/25/2008 (1:18 am)
Just as an FYI the version of this resource that acts as a separate server (aka version 4) will be released soon.
Its all been coded and is being tested right now.
I think there are a few security issues with it, but as im no security expert ill leave that to the community to fiddle with.
#95
07/29/2008 (2:41 pm)
James, so version 4 will be similar to a master server setup?
#96
07/30/2008 (11:02 am)
Version 4 runs as a separate process and is written in c#, so its similar yes.
Its almost done i just have a problem when clients dont do what theyre supposed to >>
#97
08/12/2008 (6:35 am)
Update:
Version 3.3.1 will be out soon, this is a bug fix release of 3.3
Version 4 will also be out soon, but as a separate resource
#98
10/16/2008 (8:40 am)
Has anyone tryed this with lattest TGEA?
I can not get it to compile.
1>d:\torque\afx112_combo_tgea171_sdk\engine\source\app\uac\uac.cpp(39) : error C2065: 'TypeBool' : undeclared identifier
1>d:\torque\afx112_combo_tgea171_sdk\engine\source\app\uac\uac.cpp(40) : error C2065: 'TypeString' : undeclared identifier
1>httpObject.cpp
1>d:\torque\afx112_combo_tgea171_sdk\engine\source\app\net\httpobject.cpp(139) : error C2059: syntax error : ')'
1>d:\torque\afx112_combo_tgea171_sdk\engine\source\app\net\httpobject.cpp(140) : error C2143: syntax error : missing ';' before '{'
1>d:\torque\afx112_combo_tgea171_sdk\engine\source\app\net\httpobject.cpp(143) : error C2181: illegal else without matching if
1>d:\torque\afx112_combo_tgea171_sdk\engine\source\app\net\httpobject.cpp(253) : error C2664: 'TCPObject::processLine' : cannot convert parameter 1 from 'U8 *' to 'UTF8 *'
1> Types pointed to are unrelated; conversion requires reinterpret_cast, C-style cast or function-style cast
#99
12/04/2008 (10:01 am)
Well, just in case you are reading this still, I have tried to drop this in and yet in the console there is nothing saying that the files from the client are being loaded

edit, well do I ever feel stupid now. I didnt run a dso delete before running
#100
12/16/2008 (2:29 pm)
ex. I click register nothing happens then i try to go to login in it says wait for other function to complete.
If i click login nothing happens and then i click register it says wait for other function....

what could it be ?