[Help]ascent cms v3 realmstatus

[glh290]

i made it so it will show 2 realms but it only detects one and they both say icecrown (my main server) wen one should be uludar and the other ice crown

pic

pic

any help pls

i uploaded the php files below i use notpad++ to make php edit better and easier

realms_status_panel.rar

[inzenir]

<?PHP 

//here was included settings.php
//here was included settings.php (again <_<)

/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| PHP-Fusion Ascent Realm Status Panel by Thurgood
+----------------------------------------------------+
| Tested with Ascent's v1777+ Character DB Structure
+----------------------------------------------------+
| Place this code into a folder under Infusionss
| Make sure the folder and the filename are identical
| then add your panel. 
+----------------------------------------------------+
| http://emu.game-server-cc/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/

if (!defined("IN_FUSION")) { header("Location:../../index.php"); exit; }
openside("Realm Status");
$conn = mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());
$numonline=@mysql_num_rows(mysql_query("SELECT NULL FROM `characters` WHERE `online`='1'"));
$accdb=@mysql_num_rows(mysql_query("SELECT * FROM accounts"));
$chardb=@mysql_num_rows(mysql_query("SELECT * FROM characters"));
$guilddb=@mysql_num_rows(mysql_query("SELECT * FROM guilds"));
$arenadb=@mysql_num_rows(mysql_query("SELECT * FROM arenateams"));


$abfrage = "SELECT * FROM `characters` WHERE `online`='1'";
$result = mysql_query($abfrage);
$rows0 = mysql_num_rows($result);

$abfrage1 = "SELECT * FROM `characters` WHERE `race`='1' AND `online`='1'";
$result1 = mysql_query($abfrage1);
$rows1 = mysql_num_rows($result1);

$abfrage2 = "SELECT * FROM `characters` WHERE `race`='2' AND `online`='1'";
$result2 = mysql_query($abfrage2);
$rows2 = mysql_num_rows($result2);

$abfrage3 = "SELECT * FROM `characters` WHERE `race`='3' AND `online`='1'";
$result3 = mysql_query($abfrage3);
$rows3 = mysql_num_rows($result3);

$abfrage4 = "SELECT * FROM `characters` WHERE `race`='4' AND `online`='1'";
$result4 = mysql_query($abfrage4);
$rows4 = mysql_num_rows($result4);

$abfrage5 = "SELECT * FROM `characters` WHERE `race`='5' AND `online`='1'";
$result5 = mysql_query($abfrage5);
$rows5 = mysql_num_rows($result5);

$abfrage6 = "SELECT * FROM `characters` WHERE `race`='6' AND `online`='1'";
$result6 = mysql_query($abfrage6);
$rows6 = mysql_num_rows($result6);

$abfrage7 = "SELECT * FROM `characters` WHERE `race`='7' AND `online`='1'";
$result7 = mysql_query($abfrage7);
$rows7 = mysql_num_rows($result7);

$abfrage8 = "SELECT * FROM `characters` WHERE `race`='8' AND `online`='1'";
$result8 = mysql_query($abfrage8);
$rows8 = mysql_num_rows($result8);

$abfrage9 = "SELECT * FROM `characters` WHERE `race`='10' AND `online`='1'";
$result9 = mysql_query($abfrage9);
$rows9 = mysql_num_rows($result9);

$abfrage10 = "SELECT * FROM `characters` WHERE `race`='11' AND `online`='1'";
$result10 = mysql_query($abfrage10);
$rows10 = mysql_num_rows($result10);

$horde = $rows2+$rows5+$rows6+$rows8+$rows9;
$ally = $rows1+$rows3+$rows4+$rows7+$rows10;

//Database Connection information
$ip='127.0.0.1'; //IP or DNS of your LOGONSERVER
$port1 ='8129'; //WORLD LISTENER PORT - REALM 1
$port2 ='8128'; //WORLD LISTENER PORT - REALM 2
$port3 ='8127'; //WORLD LISTENER PORT - REALM 2

include_once "settings.php"; //here is now included settings for realm 1

// Lets see if Realm 1 is alive
$fp = @fsockopen ($ip,$port1,$errno,$errstr, 0.5);
if ($fp)
{ print "<center></font><p><center><img src='".BASEDIR."http://www.mmowned.com/forums/images/realm_status/up.png'></center>"; }
else {print "<center><img src='".BASEDIR."http://www.mmowned.com/forums/images/realm_status/down.png'></center>"; }
@fclose($fp);

$conn = mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($logondb) or die(mysql_error());
$accdb=@mysql_num_rows(mysql_query("SELECT * FROM accounts"));
echo "<b>Online Players: $numonline  <br> Alliance : <font color='blue'>$ally</font> Horde : <font color='red'>$horde </font></b><p><b>Name:</b> $realmname<br><b>Realm:</b> $realmadress  <br> <b>Patch:</b> $patch<br><b>Rates:</b> $rates <br> <b><br><u>Database Statistics:</u></b><br><b>Accounts: $accdb <br>Characters: $chardb <br>Guilds: $guilddb <br>Arena Teams: $arenadb</b>
";

include_once "settings2.php"; //here is now included settings2 for realm 2
// Lets see if Realm 2 is alive
$fp = @fsockopen ($ip,$port2,$errno,$errstr, 0.5);
if ($fp)
{ print "<center></font><p><center><img src='".BASEDIR."http://www.mmowned.com/forums/images/realm_status/up.png'></center>"; }
else {print "<center><img src='".BASEDIR."http://www.mmowned.com/forums/images/realm_status/down.png'></center>"; }
@fclose($fp);

$conn = mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($logondb) or die(mysql_error());
$accdb=@mysql_num_rows(mysql_query("SELECT * FROM accounts"));
echo "<b>Online Players: $numonline  <br> Alliance : <font color='blue'>$ally</font> Horde : <font color='red'>$horde </font></b><p><b>Name:</b> $realmname<br><b>Realm:</b> $realmadress  <br> <b>Patch:</b> $patch<br><b>Rates:</b> $rates <br> <b><br><u>Database Statistics:</u></b><br><b>Accounts: $accdb <br>Characters: $chardb <br>Guilds: $guilddb <br>Arena Teams: $arenadb</b>
";
?>


<?php mysql_close; ?>
<?php
mysql_connect("$db_host",
"$db_user","$db_pass");
mysql_select_db("$db_name");
?>
<?php
// Leave this line in
mysql_close;
closeside();
?>

this should work ^^

In short, i've put the file includes on other places, because settings.php and settings2.php have same variable names

[glh290]

lol i just copied and pasted and checked the code over and over again but i cant fix this error Warning:

mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\infusions\realms_status_panel\realms_status_panel.php on line 29

i pasted the setting in includes but where else do they go?

also is ther a fix for the website/forums account creation not game account creation (game acc creat works)

Incorrect integer value: '' for column 'user_id' at row 1Table 'fusion_website.fusion_newsletter_subs' doesn't exist

[inzenir]

well... to be honest, your settings are messed up :P

Put this code on the beginning of the script, it should work then you can also delete those lines from each settings php file ^^

$host='localhost';
$user='root';
$pass='root';
$db='logon2';
$logondb='logon2';

EDIT: about registration, well, it would help if you would post more code. It's hard to figure out without any code and stuff...

[glh290]

now it says the same thing for characters but i can ask my bro to fix that simple 1 line in the script but what we dont know what to fix is the picture for the status is not there lol

will post the register in afew

[inzenir]

ok... give me something like 15 minutes, i'll upload you working version... at least i hope working version, your code is quite a mess :P

[glh290]

register.zip register stuff

ok i will se if that will work when its done and i have downloaded it bb in a few

[inzenir]

well, this should now be the Realm Status Panel

about registration... could you give me your server address, i would have to see the entire error, it has to say a line or something... and on what page does error occur...

[glh290]

works now thx except the register page

[inzenir]

no problem, you had some lines that shouldn't be there and some duplications, basically, i've removed anything you didn't need and replace with faster code, and there's also less code this time and it's easier to add a new realm...

Seriously, could you give me the link to the server so i could try and register on the forums on my own, that would be the easiest way for me to find the error.

EDIT: yay, i haz my first reputation points

[glh290]

sure its hosted on my comp lol so it might be slow im not sure tho glh290 i am also hosting a maplestory server but it wont be up till i fix the stupid npc errors its java somthing me and my bro cand do lol but comming soon is perfectworld server if we can

[inzenir]

hmm... i see could you paste a screenshot of fusion_newsletter_subs table in your database?

[glh290]

omg i see what the problem is its that that table dont exist see also i checked all the sqlfiles for this version of cms i have its not in anyof them

[inzenir]

aye, i knew it was something like that... Well, rename register.php to register123.php and register2.php to register.php it should work, but you won't be able to send mail to registered users via register.php function ^^

EDIT: and there will be no email verification

[glh290]

omg thank you man soo much now all of my users for the server will stop emailing me abot reg for site not working lol i had just reinstalled a server from 2.4.3 to the new 3.2.0 patch so i couldnt backup accounts they will be back on soon thx soo much if i could i would give you rep x10