realm status issue (spanish realms)

by **Frant1K** » Thu Jan 18, 2007 8:47 pm

Hey, I installed a roster for my guild. This guild is on a spanish realm on european servers...

In the realmstatus configuration tab of the roster, where you choose on which server your realm is, spanish servers don't appear! so I can't make it work.

I thought that installing the spanish localization it would be fixed, but is not... localization files are only traslations of the roster, as far as I discovered.

am I right?

Does anyone know how to solve my problem? Is there any way to add the spanish servers to the realmstatus so I can use roster properly?

I think there is, because I saw lots of spanish server rosters... but I don´t know how, and I can't find the answer by searching this forums. Hope you can help me.

by **zanix** » Thu Jan 18, 2007 11:33 pm

Do you know the URL for the realm status page for Spanish?

by **Frant1K** » Fri Jan 19, 2007 4:25 am

I think you are asking for this page

http://www.wow-europe.net/es/serverstatus/

by **zanix** » Fri Jan 19, 2007 5:38 am

Run this SQL on your roster db in something like phpmyadmin

Code: Select all: UPDATE `roster_config` SET `form_type` = 'select{US Servers^http://www.worldofwarcraft.com/realmstatus/status.xml|European English^http://www.wow-europe.com/en/serverstatus/index.html|European German^http://www.wow-europe.com/de/serverstatus/index.html|European French^http://www.wow-europe.com/fr/serverstatus/index.html|European Spanish^http://www.wow-europe.com/es/serverstatus/index.html' WHERE `id` = '8000';

This will give you the option for ES when selecting the URL in Roster Config

EDIT: Fixed SQL query

by **Frant1K** » Fri Jan 19, 2007 6:45 am

thanx a lot

by **Ikaro** » Thu Jan 25, 2007 11:32 am

Hi,

I did has you said to solve the problem and now I get this message:

Warning: preg_match() [function.preg-match]: Unknown modifier '/' in /home/master91/public_html/wowroster2/realmstatus.php on line 124

Thanks for the feed back

by **Ikaro** » Thu Jan 25, 2007 12:32 pm

Hi again

I fix the problem and now I don't get the error message, but I don't get the server status for Zul'Jin server in spanish realms.

I did has you said and I did not even get the select option for Spanish realms on the config.

Thanks for your help

by **Ikaro** » Thu Jan 25, 2007 3:30 pm

Well,

Dracula at the IRC channel help me to solve part of the problem, and it related to the fact that the Code posted by Zanix looks like to be wrong.... no ofense please, the one that works for me is the fallowing with form_type:

Code: Select all: UPDATE `roster_config` SET `form_type` = 'select{US Servers^http://www.worldofwarcraft.com/realmstatus/status.xml|European English^http://www.wow-europe.com/en/serverstatus/index.html|European German^http://www.wow-europe.com/de/serverstatus/index.html|European French^http://www.wow-europe.com/fr/serverstatus/index.html|European Spanish^http://www.wow-europe.com/es/serverstatus/index.html' WHERE `id` = '8000';

but it still did not work, i point to the xml pages instead of the html and it returned a bad response, saing that the server was offline.

Any ideas?

Thanks a lot

by **Ikaro** » Thu Jan 25, 2007 4:10 pm

I guess I found the problem

In the php code for the realmstatus, is like :

Code: Select all: case 1 : $realmData['serverstatus'] = 'Down'; break;

and that is ok for the usa xml, but for the european xml it should be something like:

Code: Select all: case $xml_server === "Down": $realmData['serverstatus'] = 'Down'; break;

Im not php programer but I've having a look to the xml files and the realmstatus.php so can you have a look at this and tell me if i'm right?
could if be some kind of fix for the european server status?

by **Ikaro** » Thu Jan 25, 2007 4:43 pm

or could it be?

Code: Select all: case 'Down': $realmData['serverstatus'] = 'Down'; break;

Don't know :S

by **Ikaro** » Thu Jan 25, 2007 7:30 pm

Well,

Dracula help me solving this problem with this:

Code: Select all: switch ( strtoupper( $xml_server['S'] ) ) { case "0": case "DOWN":

Hope it helps

Bye

by **dracula** » Thu Jan 25, 2007 8:55 pm

I like to see my nick in threads

Let's summarize our findings:
There is no need to use separate urls for the various European languages. The realm status for all European servers can be found at:
http://www.wow-europe.com/en/serverstatus/index.xml

Now that both US and EU use .xml you could as well remove the html checks and parsers from realmstatus.php. However, since US uses numbers and EU uses strings, the switch-statements need to be expanded like Ikaro posted.

You can use the attached 'realmstatus.php' and upload it to your roster. Keep in mind that this depends on the use of .xml links (so use that in the UPDATE statement) and it is not yet localized (it will be in english).

by **Ikaro** » Fri Jan 26, 2007 2:42 am

Hi

Thanks once again to Dracula & Zanix for the help in this issue, the database should be changed as well like:

Code: Select all: PDATE `roster_config` SET `form_type` = 'select{US Servers^http://www.worldofwarcraft.com/realmstatus/status.xml|European All^http://www.wow-europe.com/en/serverstatus/index.xml' WHERE `id` = '8000';

I guess this should be fine, and with the Dracula php it will display the data fine

Anyway I saw that Zanix posted some changes for Roster SVN Log so for the moment the solution posted in this threat should do the trick.

See you all.

by **zanix** » Fri Jan 26, 2007 2:56 am

Yep, I basically copied what dracula posted here, and added some variables so the image text will be localized

Make sure you go to "The BETA Files" forum and provide some translations!

by **Ikaro** » Fri Jan 26, 2007 3:00 am

I did