SRL Stats Release!

[Wizzup?]

Hello SRL,

It's Christmas and thus the best time to hand out a present to the community!

SRL Stats: http://stats.villavu.com

Features:

Script Management. (Create Script, Allow variables per script. Randoms are allowed always) Not to be confused with the script manager.
Upcoming support for graphs.
Variables are shared across scripts in the system. (We can see how much rune essence we have mined in total)
Advanced statistics per user and script. (You can see what commits a specific user has made, what specific commits a script has)
Every single commit is registered and can (not by regular users) be removed. It's 100% flexible. Many more features will probably appear due to the flexible design.
API to create signatures. (for script, user and recent commit. I can add variables information if someone wants it)
Commit API using POST data.
Creating Variables (with variable administrators)


Does not work/missing:

Graphs.
Images per variable.
Deleting variables from a script. (So be careful when you add them to your script)
Deleting a script.
Renaming a script.
Deleting commits.
Registering with an email works, but password recovery is not yet implemented.


Using the signature API: http://villavu.com/forum/showthread.php?t=61069
Using the commit API (already written for Simba): http://villavu.com/forum/showthread.php?t=60084
Detailed explanation on the system / Source Code (Work in Progress): http://villavu.com/forum/showthread.php?t=61071

As stated above, the system theoretically should work 100% but I'm not sure how easy it is to use it in your script, at the moment. (You'll at least need the commit api linked above, as well as all the variables added you want to use added to the system.

Adaption of the new system will probably take some time and effort, but the system itself should work just fine.

Cool features: http://old.villavu.com/stats/user/59/script/4

Comments & Suggestions welcome!

[tls]

Yay!

[Smartzkid]

Wonderful news!

[YoHoJo]

When adding script name as "YoHoJo's P.M.S." it said script name contains invalid characters. I had to remove the " . " and the " ' ", is there any way to allow those characters in a script's name?

Thanks for the Christmas present!

[NCDS]

Great work Wizz! Glad to see this finally coming out. :)

[Harry]

You are going to reset the database once it's out of alpha, right? Not filled with all those fake stats?

Really nice, good job. Poke me if you want me to play around with the graphs. :)

Fake stats are only in the test site? http://stats.villavu.com/ is clean.
Oh I derp.

[Frement]

You are going to reset the database once it's out of alpha, right? Not filled with all those fake stats?

Really nice, good job. Poke me if you want me to play around with the graphs. :)

Fake stats are only in the test site? http://stats.villavu.com/ is clean.

[Wizzup?]

You are going to reset the database once it's out of alpha, right? Not filled with all those fake stats?

Really nice, good job. Poke me if you want me to play around with the graphs. :)

To be honest it's quite out of the alpha stage. More like release (candidate) It just works; but could do with more features. (I already worked on it full time during Christmas)
About the graphs, you can clone the source code and set up your own system to play with. I use matplotlib for the graphs, but I suppose something else works too if the proper data is exported.

[TomTuff]

Just in time for the influx of activity. Good job, Wizzup?! (off note... every time i write Wizzup?'s name with any other punctuation after it, it feels really awkward)

[Zyt3x]

GOOD JOB! :D
a

[Sgt Soul]

ohh I can't wait for this to be implemented into the current scripts :) then I can rise to the top!!! <3 you wizzup?!!!!!! great work :)

[Death12652]

Nice, finally.

[The Claw]

Yay. Looks good but you could change the design a bit:

http://villavu.com/forum/images/satellite/misc/header_bg.gif
http://villavu.com/forum/images/satellite/misc/pagebg.gif

[Daniel]

Why not tie the stats user db with the vBulletin one? :S

[Shuttleu]

i cant get to http://stats.villavu.com it wont load :(

[Wizzup?]

I noticed. There may be some unknown bug, shuttle. It think MySQL simply drops the connection after some time. (It works on my other server with PostGre SQL)

E: I've restarted in a more verbose mode. We'll find out soon enough.

[Wizzup?]

I fixed a couple of bugs. It seems after my variable name changes I broke the commit API. (Nice stuff)

So I partially revamped the system, and you can use now use any character supported by HTML for your username and password. (Also for variables and scripts)

The length requirement is still there. If anyone wants to change their name a bit, let me know. :p

Now we wait and see what happens with the timeouts.

[Sgt Soul]

when are you going to push people into implementing this into their current scripts? :) hehe I want to get to the top position ;)

[Smartzkid]

Is this open source?

[Wizzup?]

Yep, http://villavu.com/forum/showthread.php?t=61071

[MylesMadness]

So since they are global variables, can a page with like "SRL has mined 9001 iron" be worked out?

[Wizzup?]

So since they are global variables, can a page with like "SRL has mined 9001 iron" be worked out?

Yes, that was the idea. I can add this to the /api/ (information about a specific variable). Then you could make a signature with it.

[Nava2]

Why is there only one user (Wizzup)?

Have people not been registering for the site at all, or is it for lack of scripts implementing the system?

[Capricorn]

Why is there only one user (Wizzup)?

Have people not been registering for the site at all, or is it for lack of scripts implementing the system?

Accounts don't show up til they do atleast one commit.

It seems the start up has been shakey so far, to say the least.

[Wizzup?]

Why is there only one user (Wizzup)?

Have people not been registering for the site at all, or is it for lack of scripts implementing the system?

I have to swap a few OUTER JOIN's around. I'll fix that tonight.


Accounts don't show up til they do atleast one commit.

It seems the start up has been shakey so far, to say the least.

Na, the include just hasn't been in SRL and all. It'll take some time to be adopted, like Simba. Plus, I'm still actively working on more features.

[Wizzup?]

That bug has been fixed. You can now see all users, scripts and variables regardless of their commits. Thanks go to Nielsie for his help.

[Daniel]

Seriously, I thought this was supposed to be integrated with the forums? :S

[Frement]

Would it be hard to implement categories for scripts? Like woodcutting, mining, crafting etc.

[Wizzup?]

Seriously, I thought this was supposed to be integrated with the forums? :S

Patience is a virtue. Integrating it takes a lot of time and effort. While it is a nice idea, I simply don't have the time to write it, at the moment anyway. I'd need to learn how vBulletin plugins work, etc. Not a lot of fun. Perhaps someone else can do it but I don't really see the big advantage if people can just place an image in their signature.

[Smartzkid]

It'd be really awesome to replace the 'Longevity' meter with a meter that shows 'macroing status'

IE user's percentage of total macroing time, scaled so the person in first has a full bar

[The Claw]

How about a thing like rep, where you get an extra ball for each week of macroing time you get? Could be blue for 1 week, purple for 1 month, yellow for 1 year or something. They could go above/under the rep balls on the profiles.

[Sgt Soul]

How about a thing like rep, where you get an extra ball for each week of macroing time you get? Could be blue for 1 week, purple for 1 month, yellow for 1 year or something. They could go above/under the rep balls on the profiles.

wow that is actually a great suggestion :) I would love to see this come to work!!!!! <3 this should have been thought of previously haha

[Wizzup?]

You could probably parse the JSON output per post in PHP, with a vBulletin plugin (not too hard I suppose), although I'm unsure how much that would stress the stats system. That could also include a rank, but I'll have to implement that first. (Probably a caching mechanism too)

[The Claw]

Just use pickled dictionaries bro

[Shuttleu]

one thing i do think the stats and variables need is a search function
its hard to find say Normal Logs as it is at the moment let alone when all the vars have been added

~shut

[Frement]

Also, maybe the scripts name length could be increased?
I tried to add "Monk of Zamorak Abuser" but it is too long, but I think atleast that should be allowed size, maybe even bigger.

[Wizzup?]

Version 1.2 (now active) supports Unicode.

Frement, to what length?

[Coh3n]

Is is possible to make it so we can "move variables" (i.e. so certain ones are shown before others, even if they were added after)? Like for MSI, I added all the ores, logs and fish, then realized that Clay wasn't there, so I added it, and it's at the bottom of the list, away from all the other ores.

[Wizzup?]

Variables are sorted on the total amount that they have been committed. There's no way to ``group'' them at this time.

[Coh3n]

Variables are sorted on the total amount that they have been committed. There's no way to ``group'' them at this time.
Ah okay. Would be a need addition in the figure. :)

[Sgt Soul]

suggestion,
within each script that has been posted on the SRL stats website is it possible to have highest user for each script (like previous SRL stats) or does it have to stay with every single commit that has occurred to be posted under the heading of each script. I suggest this because I liked looking to see how I ranked up in certain scripts compared to other users :)