Register FAQ Members List Calendar Search

Go Back   RunUO - Ultima Online Emulation > RunUO > Custom Script Releases
Reload this Page [RunUO 2.0 RC1] Complete Automated Web Accounting Service 1.0

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
Page 2 of 4 < 1 2 34 >
 
Thread Tools Display Modes
Old 09-02-2006, 01:35 AM   #26 (permalink)
Forum Expert
 
Pyro-Tech's Avatar
 
Join Date: Oct 2003
Location: Carbondale, IL
Age: 23
Posts: 1,767
Send a message via MSN to Pyro-Tech
Default
umm which is the file that a user starts to request an account?? i have tested the RequestAccount.php and it goes straight to this...

Code:
:: Logged IP: xxx.xxx.xxx.xxx ::

The email has been sent with the information to activate your account!
			Please take the time to read it all carefuly!
	 			Remember to check your Junk-Mail folder too!
			
			>>>Close Window<<<


i haven't entered anything yet so i dunno what's going on
__________________
Pyro-Tech is offline   Reply With Quote
Old 09-02-2006, 02:20 PM   #27 (permalink)
Forum Expert
 
Pyro-Tech's Avatar
 
Join Date: Oct 2003
Location: Carbondale, IL
Age: 23
Posts: 1,767
Send a message via MSN to Pyro-Tech
Default
Code:
02/09-13:20 System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Drive
r Manager] Data source name not found and no default driver specified
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode r
etcode)
   at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, Odb
cConnectionString constr, OdbcEnvironmentHandle environmentHandle)
   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOption
s options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection own
ingObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
   at System.Data.Odbc.OdbcConnection.Open()
   at Server.Accounting.WebAccounting.CreateAccounts() in d:\RunUO Server 2.0\Sc
ripts\Custom\New Scripts\Systems\Web Accounting BETA\WebAccounting.cs:line 60
02/09-13:20 Done: (Error)
02/09-13:20 System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Drive
r Manager] Data source name not found and no default driver specified
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode r
etcode)
   at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, Odb
cConnectionString constr, OdbcEnvironmentHandle environmentHandle)
   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOption
s options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection own
ingObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
   at System.Data.Odbc.OdbcConnection.Open()
   at Server.Accounting.WebAccounting.SynchronizeDatabase() in d:\RunUO Server 2
.0\Scripts\Custom\New Scripts\Systems\Web Accounting BETA\WebAccounting.cs:line
118
this is the error im getting....it also mentions towards the top about not having a default driver specified....other than that, i can't really read it lol
__________________
Pyro-Tech is offline   Reply With Quote
Old 09-02-2006, 03:56 PM   #28 (permalink)
Forum Novice
 
Join Date: Jun 2006
Posts: 145
Default
Pyro, I wish i could help you but I've tried to get this script working without luck. I've asked the person who wrote it for his input and nothing so far So I decide to make my own. . I am about 50% done, I hope I can get it out and publish soon just hand tight.
__________________
Kingdom of Shadows
My Scripts :p
2.0 Soul of Ice
2.0 Armor & Weapons
Shadow_Storm is offline   Reply With Quote
Old 09-03-2006, 12:57 AM   #29 (permalink)
Forum Expert
 
Pyro-Tech's Avatar
 
Join Date: Oct 2003
Location: Carbondale, IL
Age: 23
Posts: 1,767
Send a message via MSN to Pyro-Tech
Default
Quote:
Originally Posted by Shadow_Storm
Pyro, I wish i could help you but I've tried to get this script working without luck. I've asked the person who wrote it for his input and nothing so far So I decide to make my own. . I am about 50% done, I hope I can get it out and publish soon just hand tight.
well, i got it mostly working, just the main page loads as if i had an account allready entered and sent through...if you could, message me when yours is done or something so i can check it out

this is only working like 75% for me right now
__________________
Pyro-Tech is offline   Reply With Quote
Old 09-03-2006, 01:32 PM   #30 (permalink)
Forum Novice
 
Join Date: Jun 2006
Posts: 145
Default
yea I got part of it working too the problem was that it was not inserting data into mysql and I kept getting an error with functions not been define. To the point that I got the hang of it so I deside it would be a cool experience to do my own
__________________
Kingdom of Shadows
My Scripts :p
2.0 Soul of Ice
2.0 Armor & Weapons
Shadow_Storm is offline   Reply With Quote
Old 09-06-2006, 05:32 AM   #31 (permalink)
Forum Expert
 
Pyro-Tech's Avatar
 
Join Date: Oct 2003
Location: Carbondale, IL
Age: 23
Posts: 1,767
Send a message via MSN to Pyro-Tech
Default
i got this working now actually....in his MySQL query, he had phase and it should be state....

after that, it compiled fine and i can use the webpage part too!
__________________
Pyro-Tech is offline   Reply With Quote
Old 09-06-2006, 06:18 AM   #32 (permalink)
Forum Expert
 
Pyro-Tech's Avatar
 
Join Date: Oct 2003
Location: Carbondale, IL
Age: 23
Posts: 1,767
Send a message via MSN to Pyro-Tech
Default
Ok now that i got this working, i was wondering how to make it read my CMS table to get usernames...that way a person creates their account when they register on the site....

I figure where it says things such as username password, just change to the appropriate field on the table, but one of the things that kinda has me wondering is the e-mail....do we still need it since the CMS program will take care of the user confirmation?? and if i needed to mass e-mail players, i could do it within the CMS? since i would have their e-mails on hand within that or just PM them.

but if we still need it, will it update if a user were to change their e-mail after creating an account?

i am just wondering if this idea would work and if so, do i need to only change stuff in the webaccounting.cs since i wouldn't be using the php files anymore?

thank you
__________________
Pyro-Tech is offline   Reply With Quote
Old 09-10-2006, 02:36 PM   #33 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,294
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Cool
I'm glad to see that this script has been useful to everyone

To answer a few questions:

This system can be used along side any other account creation method :P

The errors posted by Pyro-Tech simply mean that either the ODBC driver is not installed on both machines (gamehost/webserver) OR that the wrong information has been been supplied in the config files in the scripts... Also, make sure that the web host actually allows remote connections.

This system requires ODBC Driver 5.13...

This system SHOULD work with MySQL 4.1 and higher...

Good luck with any other problems, i should be getting the internet in within 30 days of this post and will look forward to my return
__________________

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard
Vorspire is offline   Reply With Quote
Old 09-10-2006, 03:00 PM   #34 (permalink)
Forum Expert
 
Pyro-Tech's Avatar
 
Join Date: Oct 2003
Location: Carbondale, IL
Age: 23
Posts: 1,767
Send a message via MSN to Pyro-Tech
Default
yeah my error was mainly in part that i didn't have the ODBC driver on my computer...i downloaded it, but forgot to install

also, the script and the table info was conflicting...but that wasn't hard to fix or anything

EDIT: glad to see you back vorpshire
__________________
Pyro-Tech is offline   Reply With Quote
Old 09-25-2006, 10:00 AM   #35 (permalink)
Newbie
 
scrapy's Avatar
 
Join Date: May 2006
Age: 26
Posts: 27
Default
where can I download ODBC Driver 5.13 ?
scrapy is offline   Reply With Quote
Old 09-25-2006, 03:04 PM   #36 (permalink)
Forum Expert
 
Vorspire's Avatar
 
Join Date: Jan 2005
Location: Newcastle, United Kingdom
Age: 21
Posts: 2,294
Send a message via ICQ to Vorspire Send a message via MSN to Vorspire Send a message via Skype™ to Vorspire
Default
www.google.com
__________________

RPK.VORSPIRE.COM - The WoW-UO Cross-Over Shard
Vorspire is offline   Reply With Quote
Old 09-25-2006, 05:24 PM   #37 (permalink)
Newbie
 
scrapy's Avatar
 
Join Date: May 2006
Age: 26
Posts: 27
Default
i cant find ((( mb you help me ?
scrapy is offline   Reply With Quote
Old 11-06-2006, 01:20 PM   #38 (permalink)
Forum Newbie
 
Join Date: Nov 2006
Posts: 11
Default
Hi!

I have a little problem...

When I request an ancount (on the requestaccount.php page) and I click request account an 404 error found...

My $WebURL is good but I can't request an account... :S

All my files are in the same folder and $WebURL is url of the folder of my files.

PS: Thanx and sorry for my bad english(I'm a French-Canadian )

Quote:
Not Found

The requested URL /RequestAccount.php&p=2 was not found on this server.
Arthan is offline   Reply With Quote
Old 11-07-2006, 06:48 PM   #39 (permalink)
Forum Newbie
 
Join Date: Dec 2005
Posts: 12
Default
Outstanding Job!!. Thank you for your hard work.
Blaaatz is offline   Reply With Quote
Old 11-09-2006, 08:37 AM   #40 (permalink)
Forum Novice
 
Join Date: Oct 2003
Age: 34
Posts: 192
Send a message via ICQ to Khaybel Send a message via MSN to Khaybel
Default
Quote:
Originally Posted by Pyro-Tech
umm which is the file that a user starts to request an account?? i have tested the RequestAccount.php and it goes straight to this...

Code:
:: Logged IP: xxx.xxx.xxx.xxx ::

The email has been sent with the information to activate your account!
			Please take the time to read it all carefuly!
	 			Remember to check your Junk-Mail folder too!
			
			>>>Close Window<<<


i haven't entered anything yet so i dunno what's going on
I was getting the same issue as above, any idea what I missed? I have register globals and odbc setup, mysql 4.1.21 .. *cratches head*
__________________
OrBSydia DevNetwork
Khaybel is offline   Reply With Quote
Old 11-30-2006, 02:52 AM   #41 (permalink)
Newbie
 
Join Date: Jul 2006
Age: 20
Posts: 80
Send a message via ICQ to tagno25
Default
I got the php working.
Had to modify the php like crazy.
Available to view at http://www.factiongaming.biz/ under the "Account Management" and "New Players" links

it sends emails and you can verify all the links

register globals is off

attached are the working php files
Attached Files
File Type: zip php.zip (5.8 KB, 133 views)
Last edited by tagno25; 11-30-2006 at 03:05 AM.
tagno25 is offline   Reply With Quote
Old 11-30-2006, 03:19 AM   #42 (permalink)
Forum Expert
 
Pyro-Tech's Avatar
 
Join Date: Oct 2003
Location: Carbondale, IL
Age: 23
Posts: 1,767
Send a message via MSN to Pyro-Tech
Default
it worked fine for me once you get the ODBC stuff worked out...what did you have to change in the php files??
__________________
Pyro-Tech is offline   Reply With Quote
Old 11-30-2006, 12:09 PM   #43 (permalink)
Newbie
 
Join Date: Jul 2006
Age: 20
Posts: 80
Send a message via ICQ to tagno25
Default
first i had to cgange the & to ? like in RequestAccount.php&p=2
second I had to have all the php files retreie the variables first via $_GET and $_POST
then in all the files i had to move include("WAConfig.php"); below the variables
then I had to pass all the varables used in the emails to the function

I had to add the following to WAConfig.php
Quote:
$REMOTE_ADDR = $_SERVER["REMOTE_ADDR"];
$crypt_email=md5($email);
and change all instiances of $crypt_query to $crypt_email

it works w/o register globals being on

look at the file I atached above for all the php files
Last edited by tagno25; 11-30-2006 at 12:11 PM.
tagno25 is offline   Reply With Quote
Old 12-10-2006, 04:16 AM   #44 (permalink)
Forum Novice
 
Join Date: Oct 2003
Age: 34
Posts: 192
Send a message via ICQ to Khaybel Send a message via MSN to Khaybel
Default
thanks for the update
__________________
OrBSydia DevNetwork
Khaybel is offline   Reply With Quote
Old 01-06-2007, 06:32 PM   #45 (permalink)
Forum Expert
 
Nott32's Avatar
 
Join Date: Feb 2006
Location: In front of my computer...
Age: 16
Posts: 562
Send a message via MSN to Nott32 Send a message via Yahoo to Nott32
Default
EDIT: NVM.
But I cant get this to work with my host get the error below:

Quote:
Web Accounting: Creating New Accounts...Done: (Error)
System.Data.Odbc.OdbcException: ERROR [42S21] [MySQL][ODBC 3.51 Driver][mysqld-4
.1.20-standard-log]Unknown column 'state' in 'where clause'
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode r
etcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior,
String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMet
hod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior,
String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteReader()
at Server.Accounting.WebAccounting.CreateAccounts()
Done: (Error)
System.Data.Odbc.OdbcException: ERROR [42S21] [MySQL][ODBC 3.51 Driver][mysqld-4
.1.20-standard-log]Unknown column 'state' in 'where clause'
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode r
etcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior,
String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMet
hod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior,
String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteReader()
at Server.Accounting.WebAccounting.SynchronizeDatabas e()
///////////////////////////////////////////AND ON SAVE//////////////////////////////////////

Web Accounting: Creating New Accounts...Done: (Error)
System.Data.Odbc.OdbcException: ERROR [42S21] [MySQL][ODBC 3.51 Driver][mysqld-4
.1.20-standard-log]Unknown column 'state' in 'where clause'
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode r
etcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior,
String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMet
hod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior,
String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteReader()
at Server.Accounting.WebAccounting.CreateAccounts()
Done: (Error)
System.Data.Odbc.OdbcException: ERROR [42S21] [MySQL][ODBC 3.51 Driver][mysqld-4
.1.20-standard-log]Unknown column 'state' in 'where clause'
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode r
etcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior,
String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMet
hod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior,
String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteReader()
at Server.Accounting.WebAccounting.SynchronizeDatabas e()
Exporting All Valid Email Addresses...Done!
Doesn't crash the server at all infarct Ive played with max three players on for hours but I need to get this to work lol...
__________________
Everytime a puppy gets hit by a car from me smoking I take another drag, point, and laugh.
Last edited by Nott32; 01-07-2007 at 07:52 PM.
Nott32 is offline   Reply With Quote
Old 01-08-2007, 09:31 AM   #46 (permalink)
Newbie
 
Join Date: Jul 2006
Age: 20
Posts: 80
Send a message via ICQ to tagno25
Post
Everything has to be in the proper place try my dump

here is an sql dump that should work
it creates the database `web_accounting`
Attached Files
File Type: txt Web Accounting.txt (723 Bytes, 93 views)
Last edited by tagno25; 01-08-2007 at 09:34 AM.
tagno25 is offline   Reply With Quote
Old 01-08-2007, 12:34 PM   #47 (permalink)
Newbie
 
milvaen's Avatar
 
Join Date: Oct 2006
Location: Turkey
Posts: 94
Default
i tried this but i have a problem and don't understand

my internet explorer shows this

Code:
Notice: Undefined variable: e in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 12

Notice: Undefined variable: a in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 12

Notice: Undefined variable: IP in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 12

Notice: Undefined variable: a in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 19

Notice: Undefined variable: crypt_email in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 19

Notice: Undefined variable: a in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 19

Notice: Undefined variable: e in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 19

Notice: Undefined variable: crypt_query in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 26

Notice: Undefined variable: query in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 26

Notice: Undefined variable: a in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 33

Notice: Undefined variable: crypt_email in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 33

Notice: Undefined variable: a in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 33

Notice: Undefined variable: e in /www/freehostinn.com/m/i/l/milvaen/htdocs/WAConfig.php on line 33

Notice: Undefined variable: REMOTE_ADDR in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 4
:: Logged IP: ::


Notice: Undefined variable: p in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 8

Notice: Undefined variable: qemail in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 14

Notice: Undefined variable: qemail2 in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 14

Notice: Undefined variable: accname in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 21

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 23

Notice: Undefined variable: email in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 30

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 32

Notice: Undefined variable: email in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 39

Notice: Undefined variable: accname in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 39

Notice: Undefined variable: REMOTE_ADDR in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 39

Notice: Undefined variable: EmailSubject1 in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 45

Notice: Undefined variable: EmailMessage1 in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 45

Notice: Undefined variable: AdminEmailAddress in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 45

Notice: Undefined variable: AdminEmailAddress in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 47

Notice: Undefined variable: EmailSubjectAdmin in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 47

Notice: Undefined variable: EmailMessageAdmin in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 47

Notice: Undefined variable: AdminEmailAddress in /www/freehostinn.com/m/i/l/milvaen/htdocs/RequestAccount.php on line 47
The email has been sent with the information to activate your account!
Please take the time to read it all carefuly!
Remember to check your Junk-Mail folder too!
milvaen is offline   Reply With Quote
Old 01-08-2007, 05:27 PM   #48 (permalink)
Newbie
 
Join Date: Jul 2006
Age: 20
Posts: 80
Send a message via ICQ to tagno25
Default
this file replaces the php's with properly working ones
php.zip

It is also eariler on this page
Last edited by tagno25; 01-08-2007 at 05:42 PM.
tagno25 is offline   Reply With Quote
Old 01-09-2007, 05:44 AM