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
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
About the author
Recent Blogs
• AFXSpellCooldowns• TGEA material.cs Generator
• Check for update
• Save/Load game system
• DOM, SG and future resources
#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
Any idea as to what is wrong? The only php script I changed was the database page.
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
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.
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
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.
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
$db = mysql_connect ("localhost", "root", "") or die ('MYSQLError');
?>
Root is our MySql Databse username and the "" shows where the MySql password should go, correct?
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?
#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
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.
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
Shouldnt affect the resource.
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
It may be better to continue this by email, so we dont spam the resource...
email links in my profile.
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
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.
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
Its almost done i just have a problem when clients dont do what theyre supposed to >>
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
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
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
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
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
edit, well do I ever feel stupid now. I didnt run a dso delete before running
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 loadededit, well do I ever feel stupid now. I didnt run a dso delete before running
#100
If i click login nothing happens and then i click register it says wait for other function....
what could it be ?
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 ?

Torque Owner Skylar Kelty
SkylarK