Go Back   RunUO - Ultima Online Emulation > RunUO > Custom Script Releases

Custom Script Releases This forum is where you can release your custom scripts for other users to use.

Please note: By releasing your scripts here you are submitting them to the public and as such agree to make them public domain. The RunUO Team has made its software GPL for you to use and enjoy you should do the same for anything based off of RunUO.

Reply
 
Thread Tools Display Modes
Old 05-14-2008, 06:58 PM   #1 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,295
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Cool [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: admin@vorspire.com 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]
Attached Files
File Type: rar Web Accounting.rar (27.4 KB, 109 views)
__________________

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard

Last edited by Vorspire; 07-01-2008 at 04:31 PM.
Vorspire is offline   Reply With Quote
Old 05-14-2008, 11:05 PM   #2 (permalink)
Master of the Internet
 
Joeku's Avatar
 
Join Date: Feb 2005
Location: ShatteredSosaria.com
Posts: 9,252
Default

Damn, son.
Joeku is offline   Reply With Quote
Old 05-15-2008, 07:03 AM   #3 (permalink)
Forum Expert
 
nadious's Avatar
 
Join Date: Jan 2003
Location: (Near) Atlanta, GA
Posts: 369
Default

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.
__________________
Play HeroScape? Check out our map site here: http://heroscape.catalystradio.com
nadious is offline   Reply With Quote
Old 05-15-2008, 10:55 AM   #4 (permalink)
Newbie
 
Join Date: Sep 2007
Posts: 12
Default

Errors:
+ Accounting/Account.cs:
CS0029: Line 45: Não é possível converter implicitamente o tipo 'System.Collections.Generic.List<Server.Multis.Bas eHouse>' 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'
Nodio is offline   Reply With Quote
Old 05-15-2008, 11:26 AM   #5 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,295
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Default

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
__________________

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard
Vorspire is offline   Reply With Quote
Old 05-15-2008, 12:27 PM   #6 (permalink)
Forum Expert
 
typhoonbot's Avatar
 
Join Date: Dec 2006
Posts: 478
Default

wow, super script man karma + on that one

regards

T
__________________
legendsofkaine.page.tl
typhoonbot is offline   Reply With Quote
Old 05-15-2008, 12:51 PM   #7 (permalink)
Newbie
 
Join Date: Sep 2007
Posts: 12
Default

Quote:
Originally Posted by Admin Vorspire View Post
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 is offline   Reply With Quote
Old 05-15-2008, 12:56 PM   #8 (permalink)
Newbie
 
Join Date: Sep 2007
Posts: 12
Default

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 is offline   Reply With Quote
Old 05-15-2008, 01:00 PM   #9 (permalink)
Newbie
 
Join Date: Sep 2007
Posts: 12
Default

Can i add you on msn?
Nodio is offline   Reply With Quote
Old 05-15-2008, 06:48 PM   #10 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,295
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Default

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.
__________________

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard
Vorspire is offline   Reply With Quote
Old 05-16-2008, 08:15 AM   #11 (permalink)
Newbie
 
Join Date: Sep 2007
Posts: 12
Default

///// 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?
Nodio is offline   Reply With Quote
Old 05-16-2008, 09:45 AM   #12 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,295
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Default

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

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard
Vorspire is offline   Reply With Quote
Old 05-16-2008, 01:55 PM   #13 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,295
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Cool

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
__________________

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard
Vorspire is offline   Reply With Quote
Old 05-16-2008, 10:57 PM   #14 (permalink)
Newbie
 
Join Date: Sep 2007
Posts: 12
Default

Quote:
Originally Posted by Admin Vorspire View Post
Do you see a file called "ACCOUNTHANDLER.CS" in that list?
Quote:
Originally Posted by Admin Vorspire View Post
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 is offline   Reply With Quote
Old 05-16-2008, 10:58 PM   #15 (permalink)
Newbie
 
Join Date: Sep 2007
Posts: 12
Default

but i dont know what im doiing wrong
Nodio is offline   Reply With Quote
Old 05-16-2008, 11:30 PM   #16 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,295
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Default

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
__________________

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard
Vorspire is offline   Reply With Quote
Old 05-18-2008, 05:08 PM   #17 (permalink)
Lurker
 
Join Date: Jun 2006
Posts: 7
Default

Just a quick question for you vorspire. Would this require my web server to be on the same server as my RunUO server?
JamesCurtis is offline   Reply With Quote
Old 05-19-2008, 12:18 AM   #18 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,295
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Default

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 :P
__________________

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard
Vorspire is offline   Reply With Quote
Old 05-19-2008, 12:56 AM   #19 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,295
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Default

Quote:
Originally Posted by nadious View Post
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.
__________________

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard
Vorspire is offline   Reply With Quote
Old 05-19-2008, 11:46 PM   #20 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,295
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Cool

Quote:
Originally Posted by Vorspire View Post
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!
__________________

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard
Vorspire is offline   Reply With Quote
Old 05-20-2008, 12:47 AM   #21 (permalink)
Forum Expert
 
Join Date: Dec 2007
Location: Texas..
Posts: 379
Send a message via AIM to Avalanche- Send a message via MSN to Avalanche-
Default

damm man.. Nice tho =]
Avalanche- is offline   Reply With Quote
Old 05-20-2008, 12:21 PM   #22 (permalink)
Forum Expert
 
Join Date: Oct 2002
Age: 45
Posts: 4,363
Default

I'd love to see something like that that was integrated with VBulletin.
__________________
HellRazor is offline   Reply With Quote
Old 06-08-2008, 07:48 PM   #23 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,295
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Default

You can integrate this with anything you like, just use a custom registration form or something and use the php code supplied
__________________

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard
Vorspire is offline   Reply With Quote
Old 06-10-2008, 06:07 PM   #24 (permalink)
Lurker
 
Join Date: Sep 2007
Posts: 3
Default

thank you for your sharing

can you post the necessary modifies to get your script work? ^^
ste1985alh is offline