SRL Archive - SRL Site Discussion

Seeing the current SRL-Stats are now really down, we need a new system.

There are roughly three options:

• "Old System"
Keep the old system's way of storing data. (I will rewrite it from scratch, but we would roughly keep the same kind of database and stats.) The old system just has one entry for each user and script, and increases variables in there. There is no history function whatsoever. Every entry overrides all the previous ones. Although they usually just increase. ;) This system is of course compatible with the old one.
• "Extended System"
Use a whole new sort of database, that log just about every possible thing that can be logged, and will be able to turn them into very interesting graphs. (It will log everything per user, randoms, variables, what script, etc.) The system will use alot more DB space. (That shouldn't a be a problem?) My main objection again this system is when people would want a HTML interface to view stats. The load for viewing pages would probably be a bit higher than the old system, forcing caching of files. This would be quite hard to implement. Also, because the Extended system has much more features, making PHP/HTML code for all the different results it can display would take time. This system will also be backwards compatible with the old system, it will even be able to 'remove' history every month, so the database space would be about the same as the old one on the beginning of every month. (I hope I won't need to use this 'history whiper'.) Also note that it only removes 'history', not actual minutes or other numbers, only when they were committed and such. This is a small file I made, it contains some of the actions the system would have. It is probably not clear to you at all, it was to me when I wrote it though…

main:
    -> default
        -> Top X users -> users -> default
        -> Top Y scripts -> scripts -> default
        -> Total Time
        -> Total events -> events -> default
        -> Total variables -> variables -> default

special:
    -> Randoms Statistics: All randoms, Failed/Solved.

script:
    -> default stats
        -> top X users -> users -> script
        -> random events -> users -> randoms
        -> script variables. users -> script variables
    -> Detailed stats
        -> All users. -> Users -> Script -> X
            -> Sort by: 
                -> Time -> Idem
                -> Event(s) -> Idem
                -> Variables -> Idem


user:
    -> default stats
        -> Random events -> Users -> Randoms
        -> Variables -> Users -> Variables
        -> Script ownership -> Script -> Default
        -> Scripts used, User.
        -> Total stats rank. (X out of Y) -> Main -> Top X users -> 
    -> Extended stats
        -> Failed Random Events / Solved -> Users -> Randoms -> Detailed stats. 
        -> Variables per hour -> Variables -> Detailed stats 
    -> User Stats for a certain script
        -> Total Randoms & Variables
        -> Total time
        -> Rank at the script.

randoms && variables:
    -> default stats
        -> Total

    -> Detailed stats
        -> 10 users who have the variable || random the most.
        -> 10 scripts who have the variable || random the most.
        -> Randoms: Solved versus Failed
        -> Variables: Average per hour.
    -> Main
        -> Most gotten event
        -> Event with highest and lowest solving rate.

Database skeleton (I left a few inserted values in there):

-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb1
-- [url]http://www.phpmyadmin.net[/url]
--
-- Host: localhost
-- Generation Time: Apr 15, 2009 at 12:29 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.6-2ubuntu4.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `wizstats`
--

-- --------------------------------------------------------

--
-- Table structure for table `base_randoms_scripts`
--

CREATE TABLE IF NOT EXISTS `base_randoms_scripts` (
  `RandomID` mediumint(5) unsigned NOT NULL,
  `ScriptID` mediumint(5) unsigned NOT NULL,
  `Amount` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `base_randoms_scripts`
--


-- --------------------------------------------------------

--
-- Table structure for table `base_randoms_users`
--

CREATE TABLE IF NOT EXISTS `base_randoms_users` (
  `RandomID` int(5) NOT NULL,
  `UserID` int(8) NOT NULL,
  `Amount` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `base_randoms_users`
--


-- --------------------------------------------------------

--
-- Table structure for table `base_scripts`
--

CREATE TABLE IF NOT EXISTS `base_scripts` (
  `ID` mediumint(5) unsigned NOT NULL,
  `Time_Seconds` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `base_scripts`
--


-- --------------------------------------------------------

--
-- Table structure for table `base_users`
--

CREATE TABLE IF NOT EXISTS `base_users` (
  `ID` mediumint(6) unsigned NOT NULL,
  `Time_Seconds` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `base_users`
--

INSERT INTO `base_users` (`ID`, `Time_Seconds`) VALUES
(1, 1002);

-- --------------------------------------------------------

--
-- Table structure for table `commits`
--

CREATE TABLE IF NOT EXISTS `commits` (
  `CommitID` int(10) unsigned NOT NULL auto_increment,
  `UserID` mediumint(6) unsigned NOT NULL,
  `ScriptID` int(4) unsigned NOT NULL,
  `Time_Seconds` int(10) unsigned NOT NULL,
  `Date_Time_Commited` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`CommitID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `commits`
--

INSERT INTO `commits` (`CommitID`, `UserID`, `ScriptID`, `Time_Seconds`, `Date_Time_Commited`) VALUES
(1, 1, 1, 15, '2009-02-25 21:25:53'),
(2, 1, 1, 9, '2009-02-25 21:26:10'),
(3, 1, 2, 588, '2009-02-27 01:14:59'),
(4, 2, 2, 1337, '2009-02-27 01:15:25'),
(5, 2, 1, 12, '2009-02-27 01:15:37');

-- --------------------------------------------------------

--
-- Table structure for table `commit_vars`
--

CREATE TABLE IF NOT EXISTS `commit_vars` (
  `CommitID` int(11) unsigned NOT NULL,
  `RandomID` mediumint(5) unsigned NOT NULL,
  `Amount` mediumint(9) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commit_vars`
--

INSERT INTO `commit_vars` (`CommitID`, `RandomID`, `Amount`) VALUES
(1, 1, 2),
(2, 2, 1),
(2, 1, 1),
(3, 4, 12),
(4, 2, 33),
(5, 5, 52),
(2, 6, 3),
(1, 11, 63);

-- --------------------------------------------------------

--
-- Table structure for table `custom_random`
--

CREATE TABLE IF NOT EXISTS `custom_random` (
  `ID` mediumint(5) unsigned NOT NULL auto_increment,
  `Name` varchar(30) NOT NULL,
  `is_var` tinyint(1) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `custom_random`
--

INSERT INTO `custom_random` (`ID`, `Name`, `is_var`) VALUES
(1, 'Mysterious Box', 0),
(2, 'Sandwich Lady', 0),
(3, 'Trades', 0),
(4, 'Frog Events', 0),
(5, 'Drill Demon', 0),
(6, 'Maze', 0),
(7, 'Quiz', 0),
(8, 'Scaperune Balloons', 0),
(9, 'Pinball', 0),
(10, 'Scaperune Island', 0),
(11, 'Essence', 1);

-- --------------------------------------------------------

--
-- Table structure for table `scripts`
--

CREATE TABLE IF NOT EXISTS `scripts` (
  `ID` int(5) NOT NULL,
  `OwnerID` mediumint(9) NOT NULL,
  `Name` varchar(40) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `scripts`
--

INSERT INTO `scripts` (`ID`, `OwnerID`, `Name`) VALUES
(1, 1, 'Wizzup''s First Script!'),
(2, 1, 'Wizzup''s Second Script!');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `ID` mediumint(8) unsigned NOT NULL auto_increment,
  `Name` varchar(20) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`ID`, `Name`) VALUES
(1, 'Wizzup?'),
(2, 'Widget');

This is a rather simple query that finds all the random events and variables that each script has.

mysql> select custom_random.name, scripts.name, sum(commit_vars.amount) from commit_vars inner join custom_random on commit_vars.randomid = custom_random.id inner join commits on commit_vars.commitid = commits.commitid inner join scripts on commits.scriptid = scripts.id group by custom_random.name, scripts.id;
+----------------+-------------------------+-------------------------+
| name           | name                    | sum(commit_vars.amount) |
+----------------+-------------------------+-------------------------+
| Drill Demon    | Wizzup's First Script!  |                      52 | 
| Essence        | Wizzup's First Script!  |                      63 | 
| Frog Events    | Wizzup's Second Script! |                      12 | 
| Maze           | Wizzup's First Script!  |                       3 | 
| Mysterious Box | Wizzup's First Script!  |                       3 | 
| Sandwich Lady  | Wizzup's First Script!  |                       1 | 
| Sandwich Lady  | Wizzup's Second Script! |                      33 | 
+----------------+-------------------------+-------------------------+
7 rows in set (0.00 sec)

• "Mixture"
The latest option is a combination of both. I would drop the entire history feature, but script variables would be shared. As in, there will only be one 'Iron Ore' variable. This would be nice if we would want to find all the Iron Ore SRL has mined. This feature is ofcourse also supported in the "Extended system". This system would also be backwards compatible.

I personally like the Extended System the most, but I don't know how practical it is, and I can't promise I will finish it in very near future. The other two Systems shouldn't be hard to make, and will take less time to create as well.

What do you guys and girls think?

EDIT: For graphs: http://pchart.sourceforge.net/index.php

I would just use the extended system like you've written it up. Isn't really much it is lacking/wanting.

i like the idea of graphs
if you had a graph that showed the amount of autoing done by everyone, without giving names.

bit like grand exchange graphs

I quite like the sound of this new one, but will it require complicated code for us?

the global variables idea is schweet, "total iron ore srl has mined"

that would look so good

if you made like a box to tick of the 50 most popular things in rs

Enemies killed, Ess mined, Iron mined, chickens killed, feathers collected, bones buried, etc

I vote for the old system. If it aint broke don't fix it..

You always have the option of extending it at a later date but the priority for now should be to get it up and running.

also if you give too much flexibility to a new stats system it will inevitably grow out of all control and become an unwielding monster that consumes all the resources it can.

Extended FTW!!! I like how it has a lot of special features… but please do get it up and running soon :p

I like graphs
:)
extended!

From: Richard
I quite like the sound of this new one, but will it require complicated code for us?

No, the code will probably remain nearly 100% the same. It won't change in any case.

From: PriSoner
I vote for the old system. If it aint broke don't fix it..

You always have the option of extending it at a later date but the priority for now should be to get it up and running.

also if you give too much flexibility to a new stats system it will inevitably grow out of all control and become an unwielding monster that consumes all the resources it can.

I don't think it will eat that much CPU. The only thing that will use more CPU than normal is you guys loading the php pages when browsing your stats, unless I cache and update every hour… ;)

From: Wizzup?
No, the code will probably remain nearly 100% the same. It won't change in any case.



I don't think it will eat that much CPU. The only thing that will use more CPU than normal is you guys loading the php pages when browsing your stats, unless I cache and update every hour… ;)

Old system… I cant stand new things…

I like the extended system, but why not use javascript for the graphs?

If you don't declare SRLUsername and SRLPass in scripts, the SRLStats won't log anything right? i'd like to see that change…

Make a poll? New system, as long as it's still as simple to implement into scripts.

"Extended System" ftw!

Looks nice, can't wait for it ;)

Ah I do think srl needs some new stuff. So the extended sounds sexy. Can you fill us in about the black market?

Meh, lets get the whole bang for our buck. Extended.

Looks nice ;D

This + Open SVN is going to be FTW.

Extended.

Space is cheap, bandwidth is expensive part.

I like what marpis said. Even if the user isn't signed into Stats, it should still give the script credit for the work.

From: Smartzkid
I like what marpis said. Even if the user isn't signed into Stats, it should still give the script credit for the work.

From: marpis
If you don't declare SRLUsername and SRLPass in scripts, the SRLStats won't log anything right? i'd like to see that change…

Oh yes I really like that, would be awesome. And no more "srl stat account forcing" would be needed :p

Extended + Forcing the srl stats would be the best, in my opinion

The 'extended' versions sounds really nice IMO.
The disatvantages of choosing that version are clearly weighed out by the benefits.

Sounds and looks great
extended!

extended that is like a :duh: to me :D

extended seems like a nice step forward. It may well seem excessive now, but depending on where rs goes, it seems like it would be able to easily adapt to add more and more different things to record if need be. Then Instead of erasing the history, i would just compress it, for the current month you'd have whole month's stats, this week's, and one for every day, then at the end of the month, you just change it to a cumulative whole month and 1 for the cumulative year. I hope this makes sense, with my lack of knowledge of what exactly is put into stats. Overall there doesnt seem like any reason to not do the extended since the only person that it really puts a burden on is Wizzup and since he came up with the idea, he seems willing to do it.

And seeing as its been a while, i would guess that its already been started.

Im lazy, I didnt actually read what you proposed. But why dont you just make the new system backwards compatible, that way everyone wins.

Maybe you should've added a poll, Wizz..

From: EvilChicken!
Maybe you should've added a poll, Wizz..

I value posts and opinions more than simple statistics in this case.

As I thought you would reply.
I mainly want it to have a clearer overview, you could've just asked people to post reasons for their votes.

But in either way, it's passed some time since this thread was posted, and I believe people's opinions are clear.
Have you reached a decision yet?

From: EvilChicken!
As I thought you would reply.
I mainly want it to have a clearer overview, you could've just asked people to post reasons for their votes.

But in either way, it's passed some time since this thread was posted, and I believe people's opinions are clear.
Have you reached a decision yet?

Yes. That I can't create the big system any time soon. I believe Nielsie is willing to implement his system with some changes. It might be a good alternative (for now)… :)

at least we get SOMETHINg ;)

SrlStatsEx('FTW!');

Ok, so I'll try to work on this now. If it is too much work, I'll either create the base system, or see what nielsie has.

NAICE.

/spam&troll

Omg, gravediggar.(jk)


Good luck on working on it, but hey, spend some time outside too :p

I would much like a new system (Extended) however is it possible that you can preserve or transfer old script stat info from the previous system?

I still like the old system :<
I a "stick in the mud".

So, how much did you get done?

I think the stats should reset every year.

From: R0b0t1
I think the stats should reset every year.

+1. or like every 6 months, and a cup be rewarded for the #1 person and the creator of the #1 script or something.

+1 agree.
how it going wizzup?

T~M

From: R0b0t1
I think the stats should reset every year.

Quarterly?

From: Smartzkid
Quarterly?

Quarterly for each four year block, yes.

Why reset at all =\

Rubix: I think there are already to many cups like taht >.>

From: noidea
Why reset at all =\

Rubix: I think there are already to many cups like taht >.>

I count 1, the competition winner.

I dont know if its possible or too hard, but why not give your stats the option to reset or not? Or is this a dum idea? :P

From: D1zl3
I dont know if its possible or too hard, but why not give your stats the option to reset or not? Or is this a dum idea? :P

That would have to be for personal stats only.

I've started working on this again… :)

yay :D

T~M

Why reset? Just kick the inactive ones off:D

From: Main_Ftw
Why reset? Just kick the inactive ones off:D

The reset is a must.

i didn't really like the old system to much… New one sounds really cool… I got a little confused in your explanation and it seemed to talk about runescape usernames which is a big nono… I would die before autoing if the usernames got put online…

From: spicynachos2
i didn't really like the old system to much… New one sounds really cool… I got a little confused in your explanation and it seemed to talk about runescape usernames which is a big nono… I would die before autoing if the usernames got put online…

No rs usernames will or can be put online.

From: Wizzup?
No rs usernames will or can be put online.

will it be like the beta one, where we can change active/locations via the page or something? that is REALLY helpful and helps me train my army more effectively.

From: Rubix
will it be like the beta one, where we can change active/locations via the page or something? that is REALLY helpful and helps me train my army more effectively.

Does nielsie95's page allows stats per RS account?

I have not incorporated anything like stats per RS account.
E:
The stats are Statistics, not a Script/User Management System.

From: Wizzup?
The reset is a must.

People have to be able to catch munk and I, so the stats reset is a must :)

From: HyperSecret
People have to be able to catch munk and I, so the stats reset is a must :)

Well, I don't know how you meant that, but the reset is just a must, because of the way the new SRL Stats will work.

You can check the progress here.
Keep in mind that the page will change often, and contain "graphical" bugs, as I am constantly editing the code and design, as well as constantly adding more functionality.

From: Wizzup?
Does nielsie95's page allows stats per RS account?

I have not incorporated anything like stats per RS account.
E:
The stats are Statistics, not a Script/User Management System.

well like in Nielsies

if a player goes false, you can log onto him, make him true, then go to the site and change him back to true.

Not sure what your going to do with script signatures. But im running a live script image:

From: Rubix
well like in neislies,

if a player goes false, you can log onto him, make him true, then go to the site and change him back to true.

Nielsie*

SRL Stats != RS Character Management.
I may possibly even add RuneScape Character specific stats (Every user can own unlimited amounts of RS Chars)

For the actual management, no. This isn't a Character Management project, so I will not add the stuff nielsie has in his Script Management.
It requires a totally different database approach, and a different interface.

Won't do.

@ Rogeruk:

Scripts Sigs are still a good idea, but you should keep in mind the script variables aren't limited. Although I wouldn't really see anyone use more than 20 vars. :)

Thats not a problem if you use a PHP script to generate each scripts sig then it will be dynamic and auto-matically contain the vars that are in that script.

Simply just write what is passed.

From: Rubix
Nielsies

From: Wizzup?
Nielsie*

I lol'd. :)

Err.. Don't want this to be spam..

I love you Wizzup?! :)

And good work on the stats so far (lolwut. I don't even know what you've done. Haha :)).

From: rogeruk
Thats not a problem if you use a PHP script to generate each scripts sig then it will be dynamic and auto-matically contain the vars that are in that script.

Simply just write what is passed.

I wasn't referring to that. I was referring to a case where a script would have 50 variables. It won't fit on the signature image.

Oh i see. Small pixel font should do it. Forums are pretty wide could always use the width

you could just get a picture that could be continued dynamically for how ever long it needs to be. Something like Rogeruk's horizontal stripes could be used and just have it copy another line down for every 3 vars (assuming you could fit 3 per line). Theoretically it could leave you with a very tall signature, but i doubt there's much of a way to get around that with an infinite number of vars (unless you truncated them at some point)

700 x 126

49 Vars?



700 x 140

56 Vars?

I like them :)

From: nielsie95
I like them :)

Me too.

@Roger - Dude that sig is nice bro. Good job, looks nice and works nice :).

Any suggestions are welcome. For script stats could always have some sort of NPC that represents what the script is.

Eg… Script belongs in Magic.. could have an Infernal mage as the picture.. Woodcutter could have an Ent etc..

AMAZING Roger ;)
I always thought it was:
rowgerruck
lol

:)

I think that the brown looks better than the green along the top and bottom of the sigs…But that's just me being picky. Fantastic otherwise.

Richard.

As you can see in my signature.

I have hooked my private tanner script up to my own stats.

Image looking good even if i do say so myself lol.

Any news on this?

Any news?

From: rogeruk
Any news on this?

From: The Man
Any news?

Not Necessary, The Man.

That was nearly a month a go though…

From: The Man
That was nearly a month a go though…

I've been extremely busy.
ss23 is also working on his own fork of my project.
I hope to get some free time this week.

cheers for the update wizzup ;)

OK. So currently I think I can finish it in a day or so, but I'm still flooded with all the information I can add. I often find myself to keep adding info to the page, like this: http://old.villavu.com/merlijn/srlstats/website/index.php?p=ri&r=12

But that's overkill…

The actual coding isn't hard, but to display all that information…

OMG a day or so :D
Wooh :D

That system you have written so far looks very nice :)
The finished product should be excellent!

great job Wiz, take you're time.

wait, where is nielsie's stats? is it the SMS one? :o

I hope you guys will forgive me for not completing this project just yet.
Only a few things are left. A html interface to add and manage scripts (This is mainly just annoying and boring to make) and a script side to "send" stats to the system.
If anyone with php and html knowledge wants to help, I'll give him access to the repository and commit my latest code. The code is not pretty at all, and may need some revising later. At least it is pretty fast, so that will keep the server load low. :p

From: Wizzup?
I hope you guys will forgive me for not completing this project just yet.
Only a few things are left. A html interface to add and manage scripts (This is mainly just annoying and boring to make) and a script side to "send" stats to the system.
If anyone of php and html knowledge wants to help, I'll give him access to the repository and commit my latest code. The code is not pretty at all, and may need some revising later. At least it is pretty fast, so that will keep the server load low. :p

We're just glad to know you're working on it :)

Grrr. Sorry it is taking so long. Life's keeping me so busy! (Just got a new phone too… :( )

You can keep track of further development here:
http://vila.villavu.com/cgi-bin/gitweb/gitweb.cgi?p=srlstats.git;a=summary

This weekend I hope to have some time to add the Client <-> Web page functionality to one can actually send their stats data. The only thing left then is the online script / account manager. (Which is annoying to make)

After that is done… I may port it to PostgreSQL rather than MySQL…

After that…Perhaps a full rewrite, but at least we'll have something working by then.

EDIT: In case I didn't mention, any help is welcome. The code isn't very readable (I'll clean it up later), bit it isn't hard to understand either… Well, except for the SQL perhaps.

All I ask is that you have 20 or more custom vars :D

thanks for the work Wiz, keep it up.

And easy phrasing for stat sigs would be much appreciated! (Like Nielsie's at least.)

From: IceFire908
All I ask is that you have 20 or more custom vars :D

You can have unlimited, and the vars are also shared globally in the sense that there is only one 'Iron Ore' variable. Then we can see how many Iron Ore ALL scripts together mined, etc.

From: IceFire908
And easy phrasing for stat sigs would be much appreciated! (Like Nielsie's at least.)

Will do. XML?

From: Wizzup?
You can have unlimited, and the vars are also shared globally in the sense that there is only one 'Iron Ore' variable. Then we can see how many Iron Ore ALL scripts together mined, etc.

Hmm.. Sounds like this new stat system will be awesome! :)

From: Wizzup?
You can have unlimited, and the vars are also shared globally in the sense that there is only one 'Iron Ore' variable. Then we can see how many Iron Ore ALL scripts together mined, etc.



Will do. XML?

Yea I guess XML will work, as long as it's phrasible.

Hmm, intrestesting concept with the global variables, but will there be a difference between like "Essence mined" "Essenced crafted" "Iron ore mined" "Iron ore dropped" ect… and who will be setting these variables? Will I be able to submit a 'global' variable name?

From: IceFire908
Yea I guess XML will work, as long as it's phrasible.

Hmm, intrestesting concept with the global variables, but will there be a difference between like "Essence mined" "Essenced crafted" "Iron ore mined" "Iron ore dropped" ect… and who will be setting these variables? Will I be able to submit a 'global' variable name?

Maybe when adding a var to your scripts stats you can choose from a listbox? Then if chosen "Other" you can specify a new variable. And every new variable could be added to global var list? Just an idea.

From: Frement
Maybe when adding a var to your scripts stats you can choose from a listbox? Then if chosen "Other" you can specify a new variable. And every new variable could be added to global var list? Just an idea.

Something like that, yeah. That is also exactly what I meant with script/user manager. A pain in the ass to make. :p

From: IceFire908
Yea I guess XML will work, as long as it's phrasible.

Hmm, intrestesting concept with the global variables, but will there be a difference between like "Essence mined" "Essenced crafted" "Iron ore mined" "Iron ore dropped" ect… and who will be setting these variables? Will I be able to submit a 'global' variable name?

Yes, Everyone who owns a script, Yes.

From: Wizzup?
Something like that, yeah. That is also exactly what I meant with script/user manager. A pain in the ass to make. :p

Why? Should'nt take long to create, but if you're short in time then it might be a bit boring to "waste" time with that. But keeping the whole idea of the tables in database in your head is another story ;) (I'm guessing there are plenty of complex tables.)

From: Frement
Why? Should'nt take long to create, but if you're short in time then it might be a bit boring to "waste" time with that. But keeping the whole idea of the tables in database in your head is another story ;) (I'm guessing there are plenty of complex tables.)

:)

Well, i hope you enjoy coding :) Atleast i do when i see it gets used.

You're using MySQL right? I know SQL pretty well and I know that MySQL uses the same code for the most part with just a different name/params. If you need any help with the SQL just let me know and I'll see what I can do.

~Camo

is it possible to have a general account that all scripts can use, so that people who don't want to bother getting an account can still have their proggies updated…

A guest account for each script is a good idea. When user hasnt specified any name / pass it will use that instead. Good thinking.

That is what I am using for my script at SMS, I have made an account called TEMP
and if the user doesn't put details in, it uses it :)

Nielsie has already discussed this, please do not use default accounts. It will log usernames.

From: IceFire908
Nielsie has already discussed this, please do not use default accounts. It will log usernames.

Actually, this isn't Nielsie's system… I think it can be a possibility, but my main problem with it is that it hardly serves a purpose.

There is one thing I really don't like, and that is if scripts connect to some site WITHOUT the user knowing it does. If the user allows the script to connect, then he may as well just create an account on the Stats System.

From: Wizzup?
Actually, this isn't Nielsie's system… I think it can be a possibility, but my main problem with it is that it hardly serves a purpose.

There is one thing I really don't like, and that is if scripts connect to some site WITHOUT the user knowing it does. If the user allows the script to connect, then he may as well just create an account on the Stats System.

More or less I was referring to The Mans 'T.E.M.P.' Account (because the temporary system will log everyone who uses its usernames), I think this would be a good idea to have this or something like the current system where it still sends script usage info at least.

From: IceFire908
More or less I was referring to The Mans 'T.E.M.P.' Account (because the temporary system will log everyone who uses its usernames), I think this would be a good idea to have this or something like the current system where it still sends script usage info at least.

No, because it will then connect to the site without the users permission.

From: Wizzup?
No, because it will then connect to the site without the users permission.

I'm confused, won't SCAR prompt them to allow it to connect to villavu.com?

From: IceFire908
I'm confused, won't SCAR prompt them to allow it to connect to villavu.com?

Yes. However, I were to go to some site, I download a program and a so called ``script'', and it suddenly tells me it wants to connect to some site, I would immediately close the program, remove every trace of it, and run a full virus scan. (Playing devils advocate…)

From: Wizzup?
Yes. However, I were to go to some site, I download a program and a so called ``script'', and it suddenly tells me it wants to connect to some site, I would immediately close the program, remove every trace of it, and run a full virus scan. (Playing devils advocate…)

I can see where you're coming from, but the script already asks for username/password/bankpin ect.. so it's probably trust-able if not then people wouldn't have even downloaded/tried to use it.

I just think it would avoid a lot of annoying 'default' accounts like we had last time SRL Stats were around if we just made it update if you don't have an stats account setup.

I guess it's your call though, we could always change it if it doesn't work out well though ;)

From: Wizzup?
Actually, this isn't Nielsie's system… I think it can be a possibility, but my main problem with it is that it hardly serves a purpose

IceFire is talking about SMS. The Man uses a default account, which is useless and indeed could make usernames public.

From: Bad Boy JH
is it possible to have a general account that all scripts can use, so that people who don't want to bother getting an account can still have their proggies updated…

Idk about wizzups, but Nielsies stats still record all stats to the overall script progress, even if the user doesn't input a username/password into he script.

So the script overall usage is updated, even if no user/pass.

I'm sure Wizzups will also just have an 'overall overview' of EVERYTHING, regardless of weather or not the script users put in a user/pass.

From: IceFire908

I just think it would avoid a lot of annoying 'default' accounts like we had last time SRL Stats were around if we just made it update if you don't have an stats account setup.

However, if people use default accounts, those accounts and all the stats associated with those accounts can easily be removed, without touching any other scripts.

From: IceFire908

I guess it's your call though, we could always change it if it doesn't work out well though ;)

True. I guess it may be worth a shot, if someone finds a nice solution to ask the user whether or not to publish his stats.

Status update: <no need to reply>
Got more time to work on them!
I'm quickly whiping up a python framework, so development will go a lot faster. No more silly PHP I hope.

Hey Wizz, just wondering how this is going? :)

From: Coh3n
Hey Wizz, just wondering how this is going? :)

As posted in the other forum; I was away for a week and had to attend to other stuff. Also stated that if you want to write something for SRL now you can start using Niels and I'll get to this later. (It's done mainly…)

From: The Man
That is what I am using for my script at SMS, I have made an account called TEMP
and if the user doesn't put details in, it uses it :)

You sir should read all documentation :)

Nielsie's system logs stats INDEPENDANTLY of having an account.

~RM

From: Wizzup?
As posted in the other forum; I was away for a week and had to attend to other stuff. Also stated that if you want to write something for SRL now you can start using Niels and I'll get to this later. (It's done mainly…)

Ah I either completely forget reading another thread, or just didn't read it, my apologies. Thanks for the update. :)

Actually spending quite some time on it the last few days. :)