[RUO 2.0 F+] Complete Automated Web-Accounting Service V2.0.1

[Vorspire]

[RUO 2.0 F+] Complete Automated Web-Accounting Service V2.0.2

Supported Versions: 2.0 ALL

PLEASE POST ALL ERRORS OR HELP REQUESTS IN THE CORRECT FORUM, DO NOT USE THIS THREAD FOR SUPPORT REQUESTS! THANK YOU!

Updates

//Version 2.0.2

• Added Admin-Only Account Activation Functionality

- If you have an older version, you will have to replace ALL FILES and RE-CONFIGURE your WAConfig.php

//////////////////////////////////////////////////////////////////////////
/////
///// Complete Automated Web Accounting Service 2.0.3
/////
///// Creator: Vorspire Shard: Rhovanion-PK
///// Email: [email protected] WebUrl: Rhovanion-PK - Ultima Online Free-Shard - RunUO
/////
///// Created: 14th May, 2008 :: 12:40
/////
///// For: RunUO Community :: RunUO.com - The RunUO Gaming Network
/////
///// Supported Versions: 2.0 Final +
/////
//////////////////////////////////////////////////////////////////////////
/////
///// Description:
/////
///// This script was designed with intent for use with larger
///// shards, although any shard can run it. This script was
///// also designed to be fully automated, taking the labour
///// out of manually adding accounts, while also helping to
///// prevent multi-accounting and miscellanious account creation.
/////
///// All account data is stored in a MySQL database for easy and
///// secure access. The passwords are encrypted within the
///// database to prevent account hacking, password stealing or
///// misuse of data. (This is based on your Password Protection choice!)
/////
///// I have also packaged a small addon to this script, which
///// enables an admin to export ALL account email addresses to
///// "Email Addresses.txt" in your RunUO directory, formatted
///// for easy copy + paste into the 'BCC' area of an email form;
///// for mass-mailing your players. Done via a command.
///// More information in ExportEmails.cs
/////
//////////////////////////////////////////////////////////////////////////
/////
///// This service comes complete with the following main features:
/////
///// #1: Shard Account Requesting
/////
///// User requests a shard account via the form on the website.
///// The form will notify the admin when an account has been
///// requested.
///// No data is entered into the MySQL database until the user
///// verifies the request using a url generated by the form.
///// The form willgenerate a random password for the user and
///// display it when the verification is complete.
///// (Done by emails).
/////
/////
///// #2: Lost Password Recovery
/////
///// User requests his/her account password by filling in
///// the email address registered to their account.
///// When the form is submitted, it will send a verification
///// email to the user with a verification url in it.
///// When the user visits the url, they are given another
///// random password, and their account info is updated in the
///// MySQL database.
/////
/////
///// #3: Email change support
/////
///// Same system as with the lost password request.
/////
///// #4: Account Email Exportation
/////
///// A command to enable an admin to export ALL account email addresses to
///// "Email Addresses.txt" in your RunUO directory, formatted
///// for easy copy + paste into the 'BCC' area of an email form;
///// for mass-mailing your players. More information in ExportEmails.cs
/////
///// #5: Admin Account Verification
/////
///// An option to enable or disable user-account verification, leaving
///// the task up to the admin, via email notifications.
/////
///// #6: Automatic Install
/////
///// In-Built PHP Installer that automatically sets up the transactions
///// database and table for the Web Accounting Service.
/////
///// #7: Easy Encryption
/////
///// A script providing the namespace "Encryption" to your server,
///// containing simple string to hash conversion methods.
/////
///// Usage: Server.Encryption.MD5Hash("Hello World"); //Md5 Hashing
///// Usage: Server.Encryption.SHA1Hash("Hello World"); //Sha1 Hashing
/////
//////////////////////////////////////////////////////////////////////////
/////
///// Supplied Files:
/////
///// ./README.txt
///// ./Main/WAConfig.cs
///// ./Main/WebAccounting.cs
///// ./Replace These/Account.cs
///// ./Replace These/Accounts.cs
///// ./Add-Ons/ExportEmails.cs
///// ./Add-Ons/Encryption.cs
/////
///// Website Files:
/////
///// ./Website Files/WebAccounting-->
/////
///// +Internal/WAConfig.php
///// +Internal/Install.php
///// +Internal/Messages.php
///// +ChangeEmail.php
///// +CreateAccount.php
///// +index.php
///// +RequestAccount.php
///// +UpdateEmail.php
///// +UpdatePW.php
///// +VerifyAccountRequest.php
///// +VerifyChangeEmailRequest.php
///// +VerifyLostPWRequest.php
/////
//////////////////////////////////////////////////////////////////////////
/////
///// Requirements:
/////
///// RunUO 2.0 Final +
///// No Previous Account.cs or Accounts.cs Edits
/////
///// Web Server Requirements:
/////
///// MySQL Server 4.1 or higher
///// MySQL ODBC Driver 3.51
///// PHP 4.x or higher (with 'register_globals' enabled)
/////
//////////////////////////////////////////////////////////////////////////
/////
///// Installation:
/////
///// Place WAConfig.cs and Web Accounting.cs into your custom
///// scripts folder.
/////
///// Edit WAConfig.cs to suit your shard.
///// Edit AccountHandler.cs and set AutoAccountCreation to FALSE!
/////
///// *REPLACE* Account.cs and Accounts.cs @ RunUO/Scripts/Accounting/
/////
///// Copy the "WebAccounting" FOLDER to your Web-Space
/////
///// *CAREFULY* edit WAConfig.php to suit your website
///// and shard. (Also in accordance with WAConfig.cs)
/////
///// I only reccommend ADVANCED users edit the actual WebSite Account
///// Management Files to integrate them into their Web-Sites, although
///// sections of code have been annotated to mark where no edits should
///// be made!
/////
//////////////////////////////////////////////////////////////////////////
/////
///// The script has been supplied as-is, with a simple
///// configuration. All configuration options have been annotated
///// to help the user understand better as to what each part of
///// the script does.
/////
///// Known Bugs:
/////
///// None.
/////
/////
///// Note From The Creator:
/////
///// I hope you enjoy using, editing and reading this script
///// as much as I did writing and testing it
/////
///// Please leave this credit note intact!
/////
///// Best regards,
///// Vorspire
/////
//////////////////////////////////////////////////////////////////////////

[VERSION#]2.0.2[#VERSION]

 

[Joeku]

Damn, son.

 

[nadious]

I'd LOVE to use this system, but I would love a feature to where as a GM, I can look at the account and decide to approve the account, rather than having the user validate it via an e-mail. That's the only thing missing to me.

 

[Nodio]

Errors:
+ Accounting/Account.cs:
CS0029: Line 45: Não é possível converter implicitamente o tipo 'System.Collections.Generic.List<Server.Multis.BaseHouse>' em 'System.Collections.Arra
List'
CS0117: Line 933: 'Server.Misc.AccountHandler' não contém uma definição para 'IPTables'
CS0117: Line 934: 'Server.Misc.AccountHandler' não contém uma definição para 'IPTables'
CS0117: Line 936: 'Server.Misc.AccountHandler' não contém uma definição para 'IPTables'
CS0117: Line 936: 'Server.Misc.AccountHandler' não contém uma definição para 'IPTables'

 

[Vorspire]

that is not an error generated by my scripts. you may have made some custom edits that need to be fixed before using my script.

Please read the Requirements section in the README.txt

Regards

 

[typhoonbot]

wow, super script man karma + on that one

regards

T

 

[Nodio]

that is not an error generated by my scripts. you may have made some custom edits that need to be fixed before using my script.

Please read the Requirements section in the README.txt

Regards

Im runing it on a clean RunUO RC2

 

[Nodio]

look this, again with a pre-compiled package found here on forum

Core: Optimizing for 2 processors
Scripts: Compiling C# scripts...ScriptCompiler: CS1668: Caminho de pesquisa invá
lido 'C:\Arquivos de programas\Microsoft Visual Studio\VC98\mfc\lib' especificad
o em 'variável de ambiente LIB' -- 'O sistema não pode encontrar o caminho espec
ificado. '
ScriptCompiler: CS1668: Caminho de pesquisa inválido 'C:\Arquivos de programas\M
icrosoft Visual Studio\VC98\lib' especificado em 'variável de ambiente LIB' -- '
O sistema não pode encontrar o caminho especificado. '
failed (1 errors, 0 warnings)
Errors:
+ Accounting/Account.cs:
CS0029: Line 45: Não é possível converter implicitamente o tipo 'System.Coll
ections.Generic.List<Server.Multis.BaseHouse>' em 'System.Collections.ArrayList'

CS0117: Line 933: 'Server.Misc.AccountHandler' não contém uma definição para
'IPTables'
CS0117: Line 934: 'Server.Misc.AccountHandler' não contém uma definição para
'IPTables'
CS0117: Line 936: 'Server.Misc.AccountHandler' não contém uma definição para
'IPTables'
CS0117: Line 936: 'Server.Misc.AccountHandler' não contém uma definição para
'IPTables'
Scripts: One or more scripts failed to compile or no script files were found.
- Press return to exit, or R to try again.

 

[Nodio]

Can i add you on msn?

 

[Vorspire]

Sorry, i cannot provide support on this because the errors are to do with AccountHandler.cs - which is not pre-packaged with my files.

You will have to either take the 2.0 FINAL copy of AccountHandler.cs or make some edits to Account.cs

I do not personally work with RunUO 2.0, so couldn't help you with your problem.

Please make a new thread in SCRIPT SUPPORT for further help, thanks.

 

[Nodio]

///// Supplied Files:
/////
///// ./README.txt
///// ./Main/WAConfig.cs
///// ./Main/WebAccounting.cs
///// ./Replace These/Account.cs
///// ./Replace These/Accounts.cs
///// ./Add-Ons/ExportEmails.cs
///// ./Add-Ons/Encryption.cs



dude, i've replaced all there files, so why u said what it arent in your package?

 

[Vorspire]

Do you see a file called "ACCOUNTHANDLER.CS" in that list?

 

[Vorspire]

I would like to know if everything works in order, correctly as it should from those of you who have installed the system, can you please post a link to the website-location of your accounting system installations?

Don't forget to rate the thread!

Regards

 

[Nodio]

Do you see a file called "ACCOUNTHANDLER.CS" in that list?

I would like to know if everything works in order, correctly as it should from those of you who have installed the system, can you please post a link to the website-location of your accounting system installations?

Don't forget to rate the thread!

Regards

Core: Optimizing for 2 processors
Scripts: Compiling C# scripts...ScriptCompiler: CS1668: Caminho de pesquisa invá
lido 'C:\Arquivos de programas\Microsoft Visual Studio\VC98\mfc\lib' especificad
o em 'variável de ambiente LIB' -- 'O sistema não pode encontrar o caminho espec
ificado. '
ScriptCompiler: CS1668: Caminho de pesquisa inválido 'C:\Arquivos de programas\M
icrosoft Visual Studio\VC98\lib' especificado em 'variável de ambiente LIB' -- '
O sistema não pode encontrar o caminho especificado. '
failed (1 errors, 0 warnings)
Errors:
+ Accounting/Account.cs:
CS0029: Line 45: Não é possível converter implicitamente o tipo 'System.Coll
ections.Generic.List<Server.Multis.BaseHouse>' em 'System.Collections.ArrayList'

CS0117: Line 933: 'Server.Misc.AccountHandler' não contém uma definição para
'IPTables'
CS0117: Line 934: 'Server.Misc.AccountHandler' não contém uma definição para
'IPTables'
CS0117: Line 936: 'Server.Misc.AccountHandler' não contém uma definição para
'IPTables'
CS0117: Line 936: 'Server.Misc.AccountHandler' não contém uma definição para
'IPTables'
Scripts: One or more scripts failed to compile or no script files were found.
- Press return to exit, or R to try again.




IF U CHECK CLEARY ERROR NOT ON ACONTHANDLE

 

[Nodio]

but i dont know what im doiing wrong

 

[Vorspire]

stop posting your errors in this topic, READ THE FIRST POST. THANKYOU.

And the errors are IN Account.cs but they are NOT CAUSED by Account.cs - they are caused by AccountHandler.cs because you decided to remove something that is required by Accounts.cs.

Do not post anything more on the subject, thanks. -That is what the Script Support section is for!

Regards

 

[JCurtis_2004]

Just a quick question for you vorspire. Would this require my web server to be on the same server as my RunUO server?

 

[Vorspire]

Hell naw, with ODBC, you can do external connections, but localhost would definately be much faster and secure, with less likelyness for data loss or corruption. - that's if you mean, does the MySQL database have to be local...

Then Hell Naw, the php pages will interact with the database at the configuration you specify in the WAConfig.php

 

[Vorspire]

I'd LOVE to use this system, but I would love a feature to where as a GM, I can look at the account and decide to approve the account, rather than having the user validate it via an e-mail. That's the only thing missing to me.

I understand, but then i'd have to re-release this system as "The Complete Un-Automated Web Accounting System" - lol.

 

[Vorspire]

I understand, but then i'd have to re-release this system as "The Complete Un-Automated Web Accounting System" - lol.

OK, I have updated the PHP SCRIPTS to be compatible with Admin-Only Activation of Accounts...

Please compare the new WAConfig.php to your current one!