Player Merging Query

[SunMan]

Originally Posted by Baiter

I tried this on my Stats, and I dont see how this merges =/

Also, I have ALOT of stats.... And I get this after it dispays about 150 Ips and their names:

Fatal error: Maximum execution time of 300 seconds exceeded in www.clansda.com\utstats\pages\admin\pip.php on line 26

Any Idea guys?

Hi Baiter

Add this line to the top of the .php file:

set_time_limit(600);

= 600 seconds timeout

[Adrian[ADIES]]

Originally Posted by killereye

Can it do auto merging or just shows which nicks are the same?

Good work anyway!

No kellereye and Baiter its just a list of ips with more than 1 player name. The .php is from the 3rd post by Azazel.

I just intergrating it with admin pages stops google/nosy people finding it on my server, and because its usefull.

SunMan's suggestion should fix your timeout baiter.
The Renew Flag Images is the most usefull part.

[killereye]

Beta release of player merging utility
Ok I've quickly updated my old code of this merging utility (see my previous post) and it runs now in the admin page of utstats.

Features
- It gives a list of all nicks to a certain IP
- Click "merge xxx.xxx.xxx.xxx" below it to go merge the nicks to one nick
- In the pop-up select the nick to merge to
- It'll merge all nicks in one operation to that nick!
- Also features an ignore ip's option, select the ips you want to ignore and press the ignore button at the bottom end. These ips won't show up in the list next time.

Screenshots

[i]All ip's with the nicks[/i[


Merge all nicks of a certain IP to one nick you selected

Installation
You can download it from the [C]W[L] downloads page or directly by clicking here.

a) Add plm.php to your stats/pages/admin/ folder
b) Edit stats/pages/admin/main.php
- search:
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&amp;action=mservers">Merge Servers</a></li>';
- add below it:
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&amp;action=plm">Merge IPs with more than 1 Player</a></li>';
c) Add a table to the stats database
- name: uts_ignoreips
- one field, named "ip", type "bigint(15)", not null, primary key

Be cautious, it's only a beta release. I tested it on a few occasions, but still might contain some errors. I'm not sure if I'm gonna update this code tho

Please give feedback or bug reports!

[Taragon]

Awesome job m8! Really appreciated!

[Baiter]

Originally Posted by killereye

Beta release of player merging utility
Ok I've quickly updated my old code of this merging utility (see my previous post) and it runs now in the admin page of utstats.

Features
- It gives a list of all nicks to a certain IP
- Click "merge xxx.xxx.xxx.xxx" below it to go merge the nicks to one nick
- In the pop-up select the nick to merge to
- It'll merge all nicks in one operation to that nick!
- Also features an ignore ip's option, select the ips you want to ignore and press the ignore button at the bottom end. These ips won't show up in the list next time.

Screenshots

[i]All ip's with the nicks[/i[


Merge all nicks of a certain IP to one nick you selected

Installation
You can download it from the [C]W[L] downloads page or directly by clicking here.

a) Add plm.php to your stats/pages/admin/ folder
b) Edit stats/pages/admin/main.php
- search:
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&amp;action=mservers">Merge Servers</a></li>';
- add below it:
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&amp;action=plm">Merge IPs with more than 1 Player</a></li>';
c) Add a table to the stats database
- name: uts_ignoreips
- one field, named "ip", type "bigint(15)", not null, primary key

Be cautious, it's only a beta release. I tested it on a few occasions, but still might contain some errors. I'm not sure if I'm gonna update this code tho

Please give feedback or bug reports!

Hey Killereye,

I've been looking at your enhancements to the merging system, and I was quite impressed.

I did have a couple problems, and a couple suggestions.

First of all I have a VERY full server with hundreds of unique players a day.



When I first installed this and ran it....I got an error on the bottom of the page after about 5 minutes of waiting. There were about a hundred or more ips
And their aliases, but this is what the error said on the very bottom....

Fatal error: Maximum execution time of 300 seconds exceeded in C:\...\utstats\pages\admin\plm.php on line 147

I guess the only thing I can do is to increase the timeout value. But forgive my ignorance, where do I go to do that?

Suggestions:


Suggestion #1

Beside each Alias, have in parenthesis' the number of matches they have played

Example:

24.150.223.59 - 412540731

Ben Dover (2)
dis|eased[t] (54)
dis|ease[t] (1)
Heart_Break_Kid (774)
Magentic (909)
PH|Magentic (67)


Suggestion #2

Also, to reduce the time it takes for the stats to processing on the plm request, I have another suggestion.

It would be VERY nice to have a way you can ask for only a certain range of IPs to be processing for aliases.

For Example:

24.50.0.0 to 25.50.255.255

This would conserve time and help admins out tremendously

[Azazel]

Maximum execution time is taken from your php.ini
Adding code to limit an IP range is probably the easiest/best idea imo

[killereye]

I'll do it asap Baiter Hope this means in a week (or 2) instead of months, like last time :p

[Baiter]

How's it coming along Killereye? Is it looking good?

[qwerty]

this is great waiting on a final release

[killereye]

Originally Posted by Baiter

How's it coming along Killereye? Is it looking good?

Hopefully I can work on it this week. I should have no college on thursday & friday here in BE I'll look on all feedback here by then and the requests so far don't look too hard to implement.

We're running it for a couple of weeks now on our own stats system and it works like a charm. It makes merging people manageable

[killereye]

The release of version 1.1 is here

New features:
- Manage the ignored ip's: view em and remove em from the list if necessary.
- Filter on range for both showing the ip's with more than one nick associated with and the ignored ip's.
- Small bug fixes & cleaned up the code.

Old features:
- It gives a list of all nicks to a certain IP
- Click "merge xxx.xxx.xxx.xxx" below it to go merge the nicks to one nick
- In the pop-up select the nick to merge to
- It'll merge all nicks in one operation to that nick!
- Also features an ignore ip's option, select the ips you want to ignore and press the ignore button at the bottom end. These ips won't show up in the list next time.

Installation
You can download it from the [C]W[L] downloads page or directly by clicking here.

a) Add plm.php to your stats/pages/admin/ folder
b) Edit stats/pages/admin/main.php
- search:
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&amp;action=mservers">Merge Servers</a></li>';
- add below it:
echo '<li><a href="admin.php?key='. urlencode($adminkey) .'&amp;action=plm">Merge IPs with more than 1 Player</a></li>';
c) Add a table to the stats database
- name: uts_ignoreips
- one field, named "ip", type "bigint(15)", not null, primary key
- this table saves the ip's you don't want to show anymore (the ignored ip's).

Update
Just replace the old plm.php file with the new one if you're updating.

Please give feedback or bug reports!

[Baiter]

Thanks Killereye! Will test and report back