Hello Dombo,
First off, thanks for the awesome website.
So far it looks amazing and it doesn't really require too much work. Or at least it shouldn't. Just a couple of things though:
To get the site properly working, more than just editing of the config file is needed. You also have to edit:
Code:
addnews.php
vote-footer.php/vote.php (assuming you would like to have the vote icons work.)
register.php
index.php (assuming you would like the title to show up with something other then MMOPS)
status.php
When doing this, please make sure that status.php uses localhost/127.0.0.1 OR you edit the allowed IP's in your config file for ArcEmu.
As well as this, the queries for both register and news were screwed up somehow. I went ahead and edited them to work with both your web database, and the logon database for ArcEmu. (The most current one I believe)
In register.php find this line (42 in a code editor such as notepad++):
Code:
$sql = "INSERT INTO accounts
and replace it with:
Code:
sql = "INSERT INTO accounts(login,password,banned,lastlogin,lastip,email,flags,forceLanguage,muted) VALUES('".$login."','".$password."',0,0,'".$ip."','".$email."',40,'".enUS."',0);";
This will create an account using the forms with basic player privileges and access to wrath.
Also open /acp/addnews.php and fine the line(22):
Code:
$query="INSERT INTO news_new
and replace it with:
Code:
$query="INSERT INTO news_new(title,date,content,poster,enabled) VALUES('".cleanuserinput($_POST['title'])."','".date('l, j F')."','".cleanuserinput($_POST['content'])."','".$posterid."',1)" or die(mysql_error());
This should guarentee everything working, provided that the user also goes through the config.php file. If I missed an entry in another .php file, please say so.
Hope this helps.
EDIT: The donate page also appears to be FUBAR. Im not sure if thats because the feature isn't ready yet, or because I happen to be on chrome, but their did seem to be some major mysql query errors.