Chat, GUID, Stats and Mapstats Logger[3.0.2.2] 01.02.

[ImportBot]

Originally Posted by XpKiller*:

 

@Zaeed Im on that thing atm im rewritting some parts of the code, this will properly fix this issue.

[ImportBot]

Originally Posted by Trizik*:

 

is there some other way to do this without ODBC?

 

my host uses litespeed with cpanel and refuses to support ODBC due to compatibility issues...

[ImportBot]

Originally Posted by XpKiller*:

 

is there some other way to do this without ODBC?

 

my host uses litespeed with cpanel and refuses to support ODBC due to compatibility issues...

So far i know is there no other way, because procon dont support other methods to connect to DBs.

 

U know that the odbc driver is needed on the procon machine only.

[ImportBot]

Originally Posted by Trizik*:

 

yes, i know, but the server hosting the database still has to support ODBC, doesn't it?

 

my host specifically told me ODBC support is not supported by cpanel with litespeed and they suggested i use different database management software that doesn't require ODBC.

[ImportBot]

Originally Posted by XpKiller*:

 

No the DB has nothing to do with odbc you need a normal MySQL Server nothing more. The ODBC driver is needed on the host with the procon tool only.

[ImportBot]

Originally Posted by Trizik*:

 

my web host confirmed port 3306 is open. i made sure their ip is in procon's trusted list and the database settings are correct. i also made sure the ip of procon host is in my web host's allowed remote mysql list. why do you think i'm getting this error?

[09:00:57 95] Error in OpenConnection:

[09:00:57 95] Index #1

[09:00:57 95] Message: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '205.204.68.136' (10060)

[09:00:57 95] Native: 2003

[09:00:57 95] Source:

[09:00:57 95] SQL: HY000

[09:00:57 95] Error in getBFBCStats: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)

at PRoConEvents.CChatGUIDStatsLogger.getBFBCStats(Lis t`1 lstPlayers)

[ImportBot]

Originally Posted by XpKiller*:

 

You host is not probably not allowed to connect to the DB Server.

The port is open but telnet give me this:

`?Host 'dslb-092-076-106-147.pools.arcor-ip.net' is not allowed to connect to the

is MySQL server

[ImportBot]

Originally Posted by Trizik*:

 

the problem was due to my web host's firewall auto block, it thought my procon host was a ddos attack

 

they unblocked my procon host's ip and now it connects successfully

 

thanks for the help

[ImportBot]

Originally Posted by Buko*:

 

Can I get the whole database as *.sql File!_!_!_! Please

[ImportBot]

Originally Posted by GitSum*:

 

I just wanted to confirm the proper way to delete a player from the database without screwing anything up. We had a couple of hackers that I would like to remove and I am database noob...

 

It looks like I can remove a player using phpMyAdmin. Here is what I was going to do:

• Search the database/all tables for the player's name
• Immediately delete all matches found in "tbl_chatlog"
• Browse "tbl_playerdata", note the PlayerID and then delete that record
• Go into "tbl_playerstats_bfv" find the PlayerID and delete
• Go into "tbl_weaponstats_bfv" find the PlayerID and delete

Is this the proper way of doing it without hosing the database?

[ImportBot]

Originally Posted by XpKiller*:

 

If you would do this so your database probably gets inconsistent. If you just remove there stats from the ranking then just delete their rows in tbl_playerstats and tbl_weaponstats but if you want remove them completely I could give you a SQL script for this job.

[ImportBot]

Originally Posted by GitSum*:

 

.. I could give you a SQL script for this job.

That would be great, I would just as soon remove them completley

 

Thanks - looking forward to trying it out

[ImportBot]

Originally Posted by XpKiller*:

 

You need to alter the script for you needs if you are not sure how to use this feel free to ask. It is always a good idea to have backup.

 

Code:

START TRANSACTION;

#Set you target DB
use your_DB_here;

#Your BadBoy here
SET @HackerID = (SELECT PlayerID FROM tbl_playerdata WHERE SoldierName = "Hacker");

#Alternate is to set HackerID directly The HackerID is the PlayerID.
#SET @HackerID = 666;

#DELETE FROM Dogtagstable
DELETE FROM tbl_dogtags 
WHERE VictimID = @HackerID OR KillerID = @HackerID;

#DELETE FROM bfbcs
DELETE FROM tbl_bfbcs
WHERE bfbcsID = @HackerID;

#DELETE FROM playerstats
DELETE FROM tbl_playerstats
WHERE StatsID = @HackerID;

#DELETE FROM weaponstats
DELETE FROM tbl_weaponstats
WHERE WeaponStatsID = @HackerID;

#DELETE FROM playerdata
DELETE FROM tbl_playerdata
WHERE PlayerID = @HackerID;

#If you have also _bfv Tables uncomment the next lines too.

#DELETE FROM tbl_playerstats_bfv
#WHERE StatsID = @HackerID;

#DELETE FROM tbl_dogtags 
#WHERE VictimID = @HackerID OR KillerID = @HackerID;

#DELETE FROM tbl_weaponstats_bfv
#WHERE WeaponStatsID = @HackerID;

COMMIT;

[ImportBot]

Originally Posted by GitSum*:

 

I exported our main database and imported it back in to "_test1" because we had players on the server at the time.

 

I was having some problems with the database name - it kept giving me an error (set your target database). It looked like I was already using the right database, so I deleted the two lines that started with "set your target DB". Also I used the PlayerID (380) and it looks like it worked!

 

Here are the first couple of lines of the query that I used:

 

START TRANSACTION;

 

#Your BadBoy here

#SET @HackerID = (SELECT PlayerID FROM tbl_playerdata WHERE SoldierName = "Hacker");

 

#Alternate is to set HackerID directly The HackerID is the PlayerID.

SET @HackerID = 380;

 

This database is for Vietnam, so I un-commented the lines you pointed out. . Here are the results of the actual query:

 

START TRANSACTION;# MySQL returned an empty result set (i.e. zero rows).

 

 

#Your BadBoy here

#SET @HackerID = (SELECT PlayerID FROM tbl_playerdata WHERE SoldierName = "Hacker");

 

#Alternate is to set HackerID directly The HackerID is the PlayerID.

SET @HackerID = 380;# MySQL returned an empty result set (i.e. zero rows).

 

 

#DELETE FROM Dogtagstable

DELETE FROM tbl_dogtags

WHERE VictimID = @HackerID OR KillerID = @HackerID;# MySQL returned an empty result set (i.e. zero rows).

 

 

#DELETE FROM bfbcs

DELETE FROM tbl_bfbcs

WHERE bfbcsID = @HackerID;# 1 row(s) affected.

 

 

#DELETE FROM playerstats

DELETE FROM tbl_playerstats

WHERE StatsID = @HackerID;# MySQL returned an empty result set (i.e. zero rows).

 

 

#DELETE FROM weaponstats

DELETE FROM tbl_weaponstats

WHERE WeaponStatsID = @HackerID;# MySQL returned an empty result set (i.e. zero rows).

 

 

#DELETE FROM playerdata

DELETE FROM tbl_playerdata

WHERE PlayerID = @HackerID;# 1 row(s) affected.

 

 

#If you have also ?[...]

 

I went back and did a search on his playername, the only thing that showed up was under the tbl_chatlog > would it be easy to add a line to delete them too?

 

Attached Files:

• database.jpg

[ImportBot]

Originally Posted by XpKiller*:

 

Chatlog is no related with the rest of the stats db you can just delete this lines.

Otherwise everything looks good not every table must contain the ID.

 

Code:

DELETE FROM tbl_chatlog
WHERE logSoldierName = "Hacker";

This should delete all rows of the target player in chatlog.

[ImportBot]

Originally Posted by GitSum*:

 

It didn't delete the chatlog entries, I even tried changing the "Hacker" to "HackerID". I see some of the entries in the chat log are from the server - welcome, killstreaks, etc. Can I just click the delete button?

 

Attached Files:

• chatlog.jpg

[ImportBot]

Originally Posted by XpKiller*:

 

chat is not relate to the stats db you can just delete them

[ImportBot]

Originally Posted by GitSum*:

 

Cool - thanks for your help!

 

I forgot to mention -> if your using Top ** KillStreaks or whatever, it is based on data from the chat logs - so you have to delete the chat log references to get someone off the killstreak display

[ImportBot]

Originally Posted by Buko*:

 

Hi, in my sql database I find no tbl_stars.

and where are the bonus points stored?

 

Can you help me?

[ImportBot]

Originally Posted by Cain*:

 

This is working very well, thank you !!

[ImportBot]

Originally Posted by Legate*:

 

Hi XpKiller,

 

The current version will be support BF3?

 

Legate.

[ImportBot]

Originally Posted by XpKiller*:

 

no i wont work due i dont know weapons of bf3

 

I will build a new release for bf3

Atm im cleaning up the code and new routines to it.

Also i need to redesign the weapondb due massive number of weapons in bf3.

The weapontable will be split in tables for each weapon category. Like Assaultrifle will get their own table.

 

I expect to get it working in a week or two after release.

[ImportBot]

Originally Posted by Legate*:

 

It's logic, I supposed it but I needed to ask ..

 

Thanks for your time and effort

[ImportBot]

Originally Posted by RedOne1*:

 

Is the whole plugin not working or part of it? I wanted to use it for bf3 chatlogs/guidelog etc etc

 

GrTz Red

[ImportBot]

Originally Posted by XpKiller*:

 

@RedOne1 you could try the simple Tracker

 

www.phogue.net/forumvb/showth...0.0-05.12.2010*

 

the "big" Version is not ready yet.

[ImportBot]

Originally Posted by RedOne1*:

 

Thank you

 

GrTz Red

[ImportBot]

Originally Posted by RadicalMode*:

 

Can you release the plugin without the weapon stats first?

 

It would be nice to have the @rank and @top10 available as soon as possible.

[ImportBot]

Originally Posted by RedOne1*:

 

@RedOne1 you could try the simple Tracker

 

www.phogue.net/forumvb/showth...0.0-05.12.2010*

 

the "big" Version is not ready yet.

I tried it, isnt yet ready i guess

 

We got 3 servers. If a activate it on all servers it will crash on one of those. Two servers is OK three is not ok.

But still thanks for the answer, this is only a feedback

 

GrTz Red

[ImportBot]

Originally Posted by meatball88*:

 

Go go Xpkiller =) really want this plugin, go as hard as you can.

 

Thanks alot for all the work and time you are putting into this!

[ImportBot]

Originally Posted by GitSum*:

 

Yes, this is probably my favorite plug-in. Patiently awaiting the BF3 version, thanks for all your hard work