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

[Pyro-Tech]

I have the older version of this installed....will i need to redo my edits to my distro or can i just swap out the custom files?

[radese]

This really is great, thank you so much for posting it.

A quick info regarding this, as I am not familiar with ODBC:

Originally Posted by 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 :P

In case I have the webserver on a separate host than the RunUO server, would I need ODBC to be installed on the machine with RunUO, on the machine with the web server, or both?

Thank you again

[Taran_]

Maybe it's because I'm such a noob, but I can't seem to install the webaccount-files. This is the error I get:

Warning: mysql_fetch_array() [function.mysql-fetch-array]: The result type should be either MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH. in D:\wamp\www\WebAccounting\Internal\WAConfig.php on line 225

I'm running PHP 5.2.6 with register globals enabled, MySQL 5.0.51b and I have MySQL ODBC Driver 3.51 installed.
Also, when I ran the install file the first time it created both the database and the table, but if I run it again I get this error:

Table 'web_accounts' Not found! - I Will Create It...
I have failed to create the Table 'web_accounts'...
Table 'web_accounts' already exists

[Vorspire]

Originally Posted by radese

This really is great, thank you so much for posting it.

A quick info regarding this, as I am not familiar with ODBC:


In case I have the webserver on a separate host than the RunUO server, would I need ODBC to be installed on the machine with RunUO, on the machine with the web server, or both?

Thank you again

ODBC should be installed on the receiving end of the mysql transaction, ie: on the machine which is running MySQL.

Originally Posted by Taran_

Maybe it's because I'm such a noob, but I can't seem to install the webaccount-files. This is the error I get:


I'm running PHP 5.2.6 with register globals enabled, MySQL 5.0.51b and I have MySQL ODBC Driver 3.51 installed.
Also, when I ran the install file the first time it created both the database and the table, but if I run it again I get this error:

That's fine, everythig should be set-up in your databae now. -If you want to re-do it, simply rmove the database/table or whatever from your MySQL via PhPMyAdmin or MySQL Administrator.

[Vorspire]

Originally Posted by Pyro-Tech

I have the older version of this installed....will i need to redo my edits to my distro or can i just swap out the custom files?

I recommend testing first, but it should just drop and play fair

[Taran_]

Well, that message always displays on the top. And if I try to click Request Account, Lost Password or Change E-mail adress I get the message: Please run Install.php: Install.php

Which means I can't do anything really.
Oh and I tried removing the database and try again, same thing. I click on install, the error shows up. I click any links, the error shows up plus it says "Please run Install.php"

[Vorspire]

Originally Posted by Vorspire

-If you want to re-do it, simply rmove the database/table or whatever from your MySQL via PhPMyAdmin or MySQL Administrator.

Then run install.php again

[Taran_]

I did, hehe. Forgot to say that, just edited my post when you posted.

[Vorspire]

OK, make sure your PHP install supports DEFINITIONS

as in:

define( "Key", "Value" );

[Taran_]

Well, I installed Wampserver to make it easy for me. But I searched for "define(" and found that my SQLite manager defines stuff, and that seems to work ok. Any other way I can check if my PHP install supports Definitions? I tried to find out how to activate it but with no luck.

[Taran_]

I installed it on another webserver but with the exact same results.

[Vorspire]

It's a shame you are getting this error, the php seems to work fine for me though.

Make sure your mySQL user has correct privs for editing the database though...

You may need to manuaally setup the database/tables though, i cannot really provide any more support on the issue.

For further help/info, please post your problem in a support forum, thank you

[Taran_]

The database and tables got created, but the installer didn't think so. I fixed it by setting INSTALLED to true in the scripts and bypassing the IF INSTALLED check.

[Tumeski]

Hello!

I installed this system and now im stuck with a few problems

Everything else is working fine now. I have these weird PHP errors...

Warning: mysql_fetch_array() [function.mysql-fetch-array]: The result type should be either MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH.

ALSO!

I run SVN 299 here and it seems that your account.cs is a bit old. So i updated it for anyone who needs this.

Basically if you get errors with the account.cs thats included, use this one:

[tayfuchik]

If I want to make this page on Hosting, that have nothing with Server Machine, I can only include it by using php code: include "serv.iport/page" ? Or there is other way to include it, that will be faster and secured ?

[Zaphieon]

Warning: mysql_fetch_array() [function.mysql-fetch-array]: The result type should be either MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH. in \webaccounting\Internal\WAConfig.php on line 225

	for($foo = 0; $row = mysql_fetch_array($Result,$database); $foo /// line 225

remove the red portion of the code. that will fix the above posters issue.. or you would have to define $database as a constant - MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH


though I am still having issues with it locating the web_accounts table.

  Table 'web_accounts' Not found! - I Will Create It...
  I have failed to create the Table 'web_accounts'...
  Table 'web_accounts' already exists

maybe i am missing something

[Vorspire]

i have updated the first post with the new PHP

[Zaphieon]

Originally Posted by Vorspire

i have updated the first post with the new PHP

works great.. still had to remove that small section from line 225.. also the part where you have..

//Admin E-Mail Address
//
define("ADMIN_EMAIL_ADDR", "admin@zrockonline.net");

//Admin E-Mail Address Name
//
define("ADMIN_EMAIL_NAME", "");

if you put anything in the admin email name it fubars my smtp becuase it adds it onto the email address for some reason.

[Zaphieon]

quick question before i leave my office lol.. does this port over all the accounts already on the server are do you start a new?

[Vorspire]

php mail() function uses this format:

ADMIN_EMAIL_ADDR - ADMIN_EMAIL_NAME

when sending e-mails, because mail-servers should be capable of identifying the NAME after the dash '-' for the From header... This is so that e-mails show up in your inbox as the NAME instead of just the EMAIL

[Zaphieon]

Originally Posted by Vorspire

php mail() function uses this format:

ADMIN_EMAIL_ADDR - ADMIN_EMAIL_NAME

when sending e-mails, because mail-servers should be capable of identifying the NAME after the dash '-' for the From header... This is so that e-mails show up in your inbox as the NAME instead of just the EMAIL

aye I understand that. Ill see if i cant play with it a bit to get it to work with my php version.

[LordHogFred]

First of all awesome system dude, will make my life so much easier :P.

Just one question though, is it possible to make the accounts synchronize at regular intervals that aren't world saves? I have my world saves 4 hours apart but I'd like to synchronize the accounts every 10 mins or so, is there a way to do this or does it rely on the save function?

Thanks ,


EDIT: Hmm, it doesn't seem to be importing the accounts in from UO properly. Any ideas?

[Vorspire]

It should work in a way that, if both WorldLoad and worldSave are set to false, it will use a timer to update every 10 minutes.

Also, what you will need to do is take out the "World.Save" line in the SynchronizeDatabase
() method at the bottom of WebAccounting.cs

As for not importing accounts properly, check that the "state" of the account is correct, if the account is in-game, but isn't in your mysql database, then it should automatically insert it into the database and vice-versa.

[LordHogFred]

Originally Posted by Vorspire

It should work in a way that, if both WorldLoad and worldSave are set to false, it will use a timer to update every 10 minutes.

Also, what you will need to do is take out the "World.Save" line in the SynchronizeDatabase
() method at the bottom of WebAccounting.cs

As for not importing accounts properly, check that the "state" of the account is correct, if the account is in-game, but isn't in your mysql database, then it should automatically insert it into the database and vice-versa.

Awesome thanks, I've altered it to update every 10 mins and on World Save now .

As for the accounts, it doesn't seem to be reading any accounts from the game to the database. It inserts them fine but it doesn't work the other way . Any ideas?

Cheers ,

[StrikeIII]

ahh, some mistakes you would find