next »

[flinkaflenkaflrsk]

courgette,

In essence the only difference between two gameservers logging to the same DB is the server. I have actually taken the liberty of not creating a new table but just an extra column Sever in the table and adding the number of the server in the sql query so every line gets stored with the server identifier. Wouldnt this be sufficient to solved Eire's problem also?

[Courgette]

that would also solve Eire.32 problem.

[Bakes]

Will you be adding this as an option?

[Courgette]

Unfortunately this cannot be an option as it requires a different table format.
It has to be af fork of this plugin.

[FSK405|Fear]

would it be possible to have chat logger connect to a remote database?

[Courgette]

To keep that plugin easy to maintain, it uses B3 connectivity layer, thus it can only use the same database as B3 does.

[Bakes]

well, you could modify it to connect to an external database, but I can't see any reason why you'd want it to do that.

[eire.32]

There is a large amount of traffic coming from between the server and the the database. Transfering that would kill banwidth and your server in my opinion.
Eire.32

[FSK405|Fear]

Yes and No. It all depends on the setup. For some of my clients I have to use mysql on its on server along side the main web server to increase response and performance. Now with a game server i'm still testing that same concept. Correct me if im wrong but chatlogger will record the chats from the games.log? directly to the database?

On one server the current log and database files are so big that it is effecting game performance. We're debating on whether to use chatlogger or not but the main concern is the size of files it will be creating and the process it will be using. That server avg's 10 players 24/7. So far it has 19,000 registered players. We need some way to start recording the chat logs effectively.

[Bakes]

an sql database is not a large text file.

What is slowing down your pcs, is the cpu usage needed to execute the sql queries.

Try optimizing the tables, it should lower load.

The chatlogger only logs a query when someone says something, and whilst it can get quite big, there is an autopurge.

[-Chaotic-]

NOTE : if you are using the censor plugin, make sure the priority of the chatlogger plugin is less
than the priority of the censor plugin or you won't log any messages containing censored words.

Can I confirm something it probably sounds stupid but just want confirmation.

When you say less of a priority do you mean a lower number or a higher number.

IE - Censor is set at 8 and Chatlogger at 9 or Censor is set at 9 and Chatlogger at 8.

Lesser priority would mean a higher value.
Higher priortiy would mean a lesser value.

Just want to confirm what way it is. Thanks.

[Bakes]

lower is higher priority, for example, if I had cheese listed as a bad word:
(using openbanter)

priority censor 1
priority openbanter 12

!gj cheese
Warning, No profanity or offensive language blah

priority censor 12
priority openbanter 1

!gj cheese
Bakes says, Good Job, Cheeseman!

[Mikobiko]

Has anyone modified echelon to support the different servers in different tables?

[Bakes]

not yet, but you could just add the second server in echelon, with the new table?

Would that work?

[eire.32]

Heres my cop out for echelon support. Its a bit of a throw together. I'm working on a more effective version of this.

Add this section near the top of your chats.php file. under all the authorisation.

Code:

$srv = "csh";
<?php
if (isset($_GET['srv'])) {
  $srv = (get_magic_quotes_gpc()) ? $_GET['srv'] : addslashes($_GET['srv']);
}

if ($srv == "srv1") {
$chatlog_table = "chatlog";
$srv_name = "Server 1 Name Here";
}
elseif ($srv == "srv2") {
$chatlog_table = "chatlog2";
$srv_name = "Server 2 Name Here";
}
elseif ($srv == "srv3") {
$chatlog_table = "chatlog3";
$srv_name = "Server 3 Name Here";
}
?>

Then you need to navigate to the SQL Query line, its in the top of the text and you need to edit it to match this.

Code:

$query_rs_chats = sprintf("SELECT * FROM %s ORDER BY %s %s", $chatlog_table,$xlorderby_rs_chats,$xlorder_rs_chats);

Then in the HTML area add this in somewhere, wherever it looks good on the page for you. Note I wrote this in XHTML

Code:

<form method="get" action="chats.php">
              <input type="radio" name="srv" value="srv1" id="srv1" <?php if($srv == "srv1") echo "checked=\"checked\""; ?> /><label for="srv1">Server 1 Name</label>
              <input type="radio" name="srv" value="srv2" id="srv2" <?php if($srv == "srv2") echo "checked=\"checked\""; ?> /><label for="srv2">Server 2 Name</label>
              <input type="radio" name="srv" value="srv3" id="srv3" <?php if($srv == "srv3") echo "checked=\"checked\""; ?> /><label for="srv3">Server 3 Name</label>
       <input type="submit" name="Submit" value="Show Chat Logs" />
            </form>

You can see that I have repeated the bitty thing srv1, srv2, srv3, to what ever you want. For example I run a 24/7 Crossfire Server, and I gave the abbreiation of crs to that server so the code looks like.

Code:

<?php
elseif ($srv == "crs") {
$chatlog_table = "chatlog2";
$srv_name = "Crossfire";
} ?>


and


<input type="radio" name="srv" value="crs" id="crs" <?php if($srv == "crs") echo "checked=\"checked\""; ?> /><label for="crs">Crossfire</label>

Thats my dirty quick and fix. Hope that helps.
Eire.32