Donate to the B3 fund!

"even a small donation helps!"
Donate with PayPal!
Most of the plugins here are made by B3 users and the authors may not visit frequently. If you need support for plugins or if questions remain unanswered, you will have to contact the author directly. Read the full Support Disclaimer here

NOTE: Do not attach plugins to your forumtopics! Attachements are periodically removed by maintenance tasks. Upload your plugins to our Downloads section instead!

Author Topic: chatlogger plugin  (Read 79078 times)

Offline flinkaflenkaflrsk

  • Sr. Member
  • ****
  • Posts: 238
Re: chatlogger plugin v0.2.0
« Reply #45 on: January 23, 2009, 01:26:56 PM »
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?

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4882
    • Github repository
Re: chatlogger plugin v0.2.0
« Reply #46 on: January 24, 2009, 10:03:19 PM »
that would also solve Eire.32 problem.

Offline Bakes

  • B3 Contrib/Support
  • Hero Member
  • *
  • Posts: 1226
Re: chatlogger plugin v0.2.0
« Reply #47 on: February 13, 2009, 08:03:13 PM »
Will you be adding this as an option?

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4882
    • Github repository
Re: chatlogger plugin v0.2.0
« Reply #48 on: February 14, 2009, 01:58:21 PM »
Unfortunately this cannot be an option as it requires a different table format.
It has to be af fork of this plugin.

Offline FSK405|Fear

  • Newbie
  • *
  • Posts: 4
Re: chatlogger plugin v0.2.0
« Reply #49 on: February 27, 2009, 07:07:24 AM »
would it be possible to have chat logger connect to a remote database?

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4882
    • Github repository
Re: chatlogger plugin v0.2.0
« Reply #50 on: February 27, 2009, 10:26:06 AM »
To keep that plugin easy to maintain, it uses B3 connectivity layer, thus it can only use the same database as B3 does.
« Last Edit: February 27, 2009, 10:07:15 PM by Courgette »

Offline Bakes

  • B3 Contrib/Support
  • Hero Member
  • *
  • Posts: 1226
Re: chatlogger plugin v0.2.0
« Reply #51 on: February 27, 2009, 05:56:11 PM »
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.

Offline eire.32

  • Echelon v2. Dev.
  • Former Dev. (senate)
  • Full Member
  • *****
  • Posts: 114
    • e32designs.com
Re: chatlogger plugin v0.2.0
« Reply #52 on: February 27, 2009, 08:44:12 PM »
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
Eire.32

Offline FSK405|Fear

  • Newbie
  • *
  • Posts: 4
Re: chatlogger plugin v0.2.0
« Reply #53 on: February 28, 2009, 12:49:31 AM »
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.

Offline Bakes

  • B3 Contrib/Support
  • Hero Member
  • *
  • Posts: 1226
Re: chatlogger plugin v0.2.0
« Reply #54 on: February 28, 2009, 08:59:15 AM »
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.

Offline -Chaotic-

  • Full Member
  • ***
  • Posts: 65
    • The Walking Dead
Re: chatlogger plugin v0.2.0
« Reply #55 on: March 04, 2009, 05:57:48 PM »
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.

Offline Bakes

  • B3 Contrib/Support
  • Hero Member
  • *
  • Posts: 1226
Re: chatlogger plugin v0.2.0
« Reply #56 on: March 04, 2009, 06:01:18 PM »
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!

Offline Mikobiko

  • Sr. Member
  • ****
  • Posts: 250
Re: chatlogger plugin v0.2.0
« Reply #57 on: April 12, 2009, 07:23:17 PM »
Has anyone modified echelon to support the different servers in different tables?

Offline Bakes

  • B3 Contrib/Support
  • Hero Member
  • *
  • Posts: 1226
Re: chatlogger plugin v0.2.0
« Reply #58 on: April 14, 2009, 05:42:01 PM »
not yet, but you could just add the second server in echelon, with the new table?

Would that work?

Offline eire.32

  • Echelon v2. Dev.
  • Former Dev. (senate)
  • Full Member
  • *****
  • Posts: 114
    • e32designs.com
Re: chatlogger plugin v0.2.0
« Reply #59 on: May 23, 2009, 09:36:59 PM »
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: [Select]
$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: [Select]
$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: [Select]
<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: [Select]
<?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
Eire.32

 


Rate this page +1 at Google Search