[RunUO 2.0 RC1] Complete Automated Web Accounting Service 1.0

[Nott32]

Is there a way to figure out if my host is using ODBC or not?
I know a good host with PHP and stuff just PM me I don't want to get in trouble for advertising.

[tagno25]

run the following php code and it will tell you what the host has setup for php

PHP Code:

<?php 
phpinfo(); 
?>

[Nott32]

How does that tell me about ODBC?? lol

here is my PHP info page:

http://nottuo.nottnetworks.com/pi.php

[tagno25]

it would below the mysql section like the attached image

[Nott32]

LOL so I guess I aint using this, host dosnt have ODBC :-( I will try and request it

[milvaen]

i upload my files new free hosting http://milvaen.phpnet.us/RequestAccount.php

it worked but only once!

it sent me only one mail i tried other mail but it didnt sent activitation code why?

[tagno25]

you cannot have multiple accounts per email address
One account cannot have multiple email addresses

If that dosent anser your question, rephrase your question

[milvaen]

is odbc driver must be installed on my computer or host?

[HellRazor]

Originally Posted by milvaen

is odbc driver must be installed on my computer or host?

Yes, ODBC driver on the host is a requirement to use this.

[JBHOnline]

I see this question has been asked already but I haven't seen an answer for it yet.
I have all of the required files installed in the correct places.
I am noticing an error stating Unknown column 'state' in 'where clause' to.

Any help plz?

Web Accounting: Creating New Accounts...Done: (Error)
System.Data.Odbc.OdbcException: ERROR [42S22] [MySQL][ODBC 3.51 Driver][mysqld-5
.0.37-community-nt]Unknown column 'state' in 'where clause'
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode r
etcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
 String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMet
hod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
 String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Odbc.OdbcCommand.ExecuteReader()
   at Server.Accounting.WebAccounting.CreateAccounts()
Done: (Error)
System.Data.Odbc.OdbcException: ERROR [42S22] [MySQL][ODBC 3.51 Driver][mysqld-5
.0.37-community-nt]Unknown column 'state' in 'where clause'
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode r
etcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
 String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMet
hod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
 String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Odbc.OdbcCommand.ExecuteReader()
   at Server.Accounting.WebAccounting.SynchronizeDatabase()

[tagno25]

Originally Posted by JBHOnline

I see this question has been asked already but I haven't seen an answer for it yet.
I have all of the required files installed in the correct places.
I am noticing an error stating Unknown column 'state' in 'where clause' to.

Any help plz?

Did you run

CREATE TABLE IF NOT EXISTS accounts (
  `name` text NOT NULL,
  `password` text NOT NULL,
  `email` text NOT NULL,
  phase int(5) NOT NULL default '3'
) TYPE=MyISAM;

or

CREATE TABLE IF NOT EXISTS accounts (
  `name` text NOT NULL,
  `password` text NOT NULL,
  `email` text NOT NULL,
  phase int(5) NOT NULL default '0'
) TYPE=MyISAM;

Do you have ODBC 3.51?

[Lordicon]

Ok I have been trying and looking at this system for a few days now and I mangaed to get the web part installed, My problem is now that I have done this where in the web config file does it connect to another ip.

My web host and my server host are two diffrent ones and I have the server connected to the webhost but how do I get the register file to register a account on to the game servers ip? Anyone know what I mean?

Should I change this "REMOTE_ADDR" to the IP of the server?

$REMOTE_ADDR = $_SERVER["REMOTE_ADDR"];

[Lordicon]

Originally Posted by tagno25

Did you run

CREATE TABLE IF NOT EXISTS accounts (
  `name` text NOT NULL,
  `password` text NOT NULL,
  `email` text NOT NULL,
 phase int(5) NOT NULL default '3'
) TYPE=MyISAM;

or

CREATE TABLE IF NOT EXISTS accounts (
  `name` text NOT NULL,
  `password` text NOT NULL,
  `email` text NOT NULL,
 phase int(5) NOT NULL default '0'
) TYPE=MyISAM;

Do you have ODBC 3.51?

His problem is the same as everyone elses.

Change this,

CREATE TABLE IF NOT EXISTS accounts (
  `name` text NOT NULL,
  `password` text NOT NULL,
  `email` text NOT NULL,
  phase int(5) NOT NULL default '0'
) TYPE=MyISAM;

To this,

CREATE TABLE IF NOT EXISTS accounts (
  `name` text NOT NULL,
  `password` text NOT NULL,
  `email` text NOT NULL,
  state int(5) NOT NULL default '0'
) TYPE=MyISAM;

Seems that the tables in mysql are being set up wrong because of one simple word. phase should = state.

[Lordicon]

Another problem i am having i guess is from the script itself,
this is account signup.

:: UO Account SignUp ::


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/joshuani/public_html/uokhaos/RequestAccount.php on line 29

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/joshuani/public_html/uokhaos/RequestAccount.php on line 38
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!

This is verify,

Creating account, please wait...


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/joshuani/public_html/uokhaos/VerifyRequestAccount.php on line 16

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/joshuani/public_html/uokhaos/VerifyRequestAccount.php on line 24
Could Not Create Account: No database selected

I havnet even checked the other files yet and the emails are sending right but the pages have errors and Im not even sure if it can even create a account for the user or if the admin has to hand create it?

[JBHOnline]

You are awesome.

Thx for the help. IT WORKS!

[Lordicon]

I had alot of problems with this file and thought that maybe many others may have the ame problems so I changed a few things in this script so it would work for me and I hope it helps others. As you can see from above i had trouble with MySQL.

Remember to create your accounts table like THIS ONLY.

CREATE TABLE IF NOT EXISTS accounts (
  `name` text NOT NULL,
  `password` text NOT NULL,
  `email` text NOT NULL,
  state int(5) NOT NULL default '0'
) TYPE=MyISAM;

[Deiscianna]

Originally Posted by tagno25

I got the php working.
Had to modify the php like crazy.
Available to view at Faction Gaming :: 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

Using these php files I seem to still get notices, but all seems to work, just the noticed are annoying

[IMG][/IMG]


Can someone help me with gettign rid of the notices

[tagno25]

try my new update
it may work I am not able to test it currently

[Deiscianna]

thanks much for helping, but still get index errors, the errors for WAConfig are gone

found a solution for now, I added "error_reporting(0);" to the top of each of those pages, that has stopped the notices

[PhoenixDIE]

ok well... here it goes!

ok i installed all the files in the correct spots, did all the required edits that i could see and in a big newb to sql so i dont know if i set the table right but when i type www.iamuo.com/RequestAccount.php it brings up the right page and it sends the email to the right emails but when i click the verify it says page not found! and i also dont know how to check if Bravenet has ODBC i saw the php file he has there but i dont really know what to do with it. but any who.. im getting a big error that looks like the ones in another post with some diffrences:

Web Accounting: Creating New Accounts...Done: (Error)
System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] D
ata source name not found and no default driver specified
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode r
etcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection connection, Odb
cConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOption
s options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection own
ingObject)
at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbC
onnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection ow
ningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at Server.Accounting.WebAccounting.CreateAccounts()
Done: (Error)
System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] D
ata source name not found and no default driver specified
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle, RetCode r
etcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection connection, Odb
cConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOption
s options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection own
ingObject)
at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbC
onnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection ow
ningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at Server.Accounting.WebAccounting.SynchronizeDatabas e()



well..any ideas would be nice..this sounds and looks awsome so far but no clue what im doing i guess! lots to learn! lol

[tagno25]

run the following php code and it will tell you what the host has setup for php

PHP Code:

<?php  
phpinfo();  
?>

the section on ODBC should look simmilar to the atached image

[LeoXavior]

Can anyone rationalise or explain to me why these scripts require register globals to be turned on, outside of bad coding standards there should be no reason for this.. If anything get's exploited on you're server you are basically serving up you're machine saying hey please come exploit and toy with me till I break, as every variable that is passed thru anything (Including urls) get's registered in php, which is never a good thing...

Has no body else realised this and tried to fix or re-write the code to work with register globals turned off?

I don't mind re-writing for my own use, but I'm very baffled that anything that directly interfaces with names and passwords would be done in this manner. Unless there is some reason why it must be done this way that im missing. I would deffinately say in big bold letters to anyone who uses this script in this form to use it at own risk.

Could someone please correct me if their is some reason why register globals "Must" be on.
I would like to know..
Other wise it should be known to every shard that is using php with register globals turned on, that is putting every name and password and every other bit of data that is on their machine at HIGH risk.

For any who wish to learn why this is a bad thing:
Register Globals
PHP: Using Register Globals - Manual

[tagno25]

register globals does not have to be on when using my updates

[LeoXavior]

Originally Posted by tagno25

register globals does not have to be on when using my updates

Thank you for the responce, ill take a look.

[Valthar]

A quick question:

I've got 2 shards running on the same server: 1 main and 1 test center. They both are listed in the Serverlist window of UO client when player logins with his/her account. So, if both shards synch with the same web database, will players be able to login to both shards with the same account?