Jump to content
SubSpace Forum Network

[MERVBot] "MySQL Substats" Plugin Coding


Recommended Posts

Posted
No, just coding. the HTML/PHP side of things is pretty much done. Smong has been waiting for a long time for the or a coder to catch up so that he could sync his PHP with the coding.
Posted
Sorry LC, I'm quitting too (you can keep the money), I don't want to be tied to a dormant project and be expected to jump back into action at some random time. If you find someone else and want the FTP/mysql passwords let me know.
Posted

Alright Smong.

 

 

If nobody cares to finish this project, then I'm abandoning it (and hey, people were wanting and expecting this for their zone).

Posted
Well since Smong abandoned the project, I would need someone (or more people) who are experienced with PHP, MySQL, C++/C#/anything that works for MERVBot. The MERVBot plugin would require a MySQL library, which is doable (aka this whole project is doable, and I know that for a fact). Smong was doing the PHP/MySQL side of things (and a little bit of HTML and CSS), me doing HTML and CSS, and allshallperish the C++ and MySQL. Now taking Smong and allshallperish out of the equation leaves us with PHP, MySQL, and a programming language. It should be very possible to continue off of the PHP coding Smong has already done, which is so far (in my opinion) quite a progression in this project.
  • 1 month later...
Posted

I have a plugin designed for SOS's version of MERVBOT that will add stats to a MySql database with these categories

 

playername | squad | killpoints | flagpoints | totalpoints | wins | losses | ratio

 

since that is about everything that I can get out of the bot easily.

 

it is keyed by playername, I think I set the maxlength to 30 chars since I dont know how big a name can get to.

 

 

I dont have any kind of website-related way of piping this information to the forums.

 

The SQL is hard-coded, so you'll have to create the tables with the same naming conventions that I used - which i think is how it is set up above - and the table name would be called 'scores'

 

I do not have anything set up for scoreresets and how to save the statistics after scoreresets.

 

I have only done minor testing - the bot isn't working in my zone yet (SSCI Devastation) as I am still redoing a few of deva's other plugins before releasing all of the redone and new plugins to the zone.

 

On the bright side, you can specify the sql connetion information in a text file - that isn't hardcoded - so once you format your db correctly then it'll work just fine in any zone.

 

Everything is in C# using visual studio 2005

Posted

This project was dumped long ago for the lack of public and developer-support. If you would like webhosting (subdomain.hlrse.net) for development/personal use, just ask me.

 

Or if you want to take over this project or something, I could send you any/all files that I and Smong have.

Posted

I was looking forward to make some kind of merv plugin that would gather various stats too...

I never worked with MySql though; any of you guys have any piece of code they could share to get me started?

...hmm I didn't read the last line of LC's post... I'd take these files blum.gif Though I can't guarantee to 'take over the project', but I'll definitly try to do something. Are your files about the web part of the thing? or just collecting stats?

Posted

Collecting statistics, compiling to MySQL data, outputtable as web data.

 

A literal/near-literal clone of the old scores site.

Posted

Until i'm done reprogramming the bot for SSCI Devastation I will not be programming anything that wouldn't be purely for the zone, I'm trying to boost it's population in my zone after all.

 

For the statistics plugin that i;ve made I haven't even created the code necessary for it to be displayed online.

 

I also have no idea for the bot how to backup the SQL table on scoreresets yet ... so my stats are at the moment purely based on the current stats of players.

 

What i've programmed is very simple and not very advanced, and its using SOS's mervbot and wouldn't work on catid's mervbot as far as I know - so I don't know how many people are actually using SOS's versino vs catid's version.

 

My bot should be done in 1-2 weeks - but I highly doubt my zone will start averaging 15-20 players a night anytime soon, so maybe summer 2008 I can look at this project since jan-april 08 i'll be too busy w/ school.

  • 2 months later...
Posted
Cre> is working on something like this on twcore for desert storm. Could talk to him.

 

Well, yes I am. I'm also working on a merv version of it but thats soon.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...