Hi Community!

It there a way to make online members' status (Age of Conan guild) visible on a website?

Thanx in advance!

dill

ok, I know this is probably a mysql issue, but was wondering if you could work me through it to see what I might be missing (google is threatening to boycot me because of all the queries)
first off, running 0.6.5 bebot for ao, mysql 5.2.1 on windows box....webserver is a shared hosting on linux box.

I run bebot locally, and have my web page hosted remotely. trying out your script, I found out that I had only allowed localhost connections to the bebot db. I added a new user to the db, for the sake of argument bebot2@'%'.

this allowed me to be able to connect to the db via mysql maestro from another computer on the intranet, so I think the command took.

So I uploaded the script to my webserver, changing the parts that needed to be changed and I get this when I run the script from a browser:
Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'xx.xx.xx.xx' (113) in /<<path to script>>/onlinestatus.php on line 6
Error connecting to mysql2
so thought it might be a firewall setting, so checked both the router and the system, and firewall is disabled on both. made sure port 3306 was forwarded to that machine.  (basically have so many ports pointing to that machine, it might as well be on the DMZ)
everything should be fine, yet for some reason it does not allow me to connect.

I would rather not move the sql db to the remote hosting, as it is both slow and cumbersome for the bots. likewise, I would not want to move the hosting to the local machine as the office does not have enough bandwidth to support such an action.

Any help, nudges, pointers, subscriptions to rogaine to replace pulled hair, would be greatly appreciated..

make incomming connection then:)

update web db from your bot machine

yeah tried that, they said they wouldn't do it for a shared, but was a perfect time to upgrade to v-ded hosting. Gotta love a sales pitch.

did you try this clash? or this is not what you were looking for?

and still toying with the idea of getting a vded and hosting the bot on that...with a combined db...

Try this code?

<?php
/*
    this will make list of your members that are online
    i used sql from http://bebot.link/ao-0-6-support/online-query/msg12818/#msg12818
*/
print '<table>'
$sql = "SELECT o.nickname, w.profession, w.level, w.defender_rank_id FROM online AS o LEFT JOIN whois AS w ON o.nickname = w.nickname WHERE o.status_gc = '1' AND o.botname NOT LIKE '%IRC' ORDER BY o.nickname ASC";

$query = mysql_query($sql) or die('error!<br>'.mysql_error());
if (mysql_affected_rows() > 0) {
  while ($r = mysql_fetch_object($query)) {
    print '<tr>
            <td>'.$r->nickname.'</td>
            <td>'.$r->profession.'</td>
            <td>'.$r->level.'</td>
            <td>'.$r->defender_rank_id.'</td>
           </tr>';
    unset($r);
  }
  mysql_free_result($query);
}
unset($sql);
print '</table>';
?>

Change
$result = mysql_query($query);To
$result = mysql_query($query) or die('error!<br>'.mysql_error());
Or even add this to afer <?php
error_reporting(E_ALL);
ini_set("display_errors", 1);