Army Manager

[lefamaster]

This may stray a bit between SCAR and MYSQL so bear with me.

The scenario is one of a massive army that requires checking 5 or more computers every day to see who is running and and who isn't, who is still ready to work and who is stuck in scarscape. This takes a bit of time, and I was wondering if something along the lines of the SRLstat SQL database wouldn't be useful.

I set up WAMP on a private static IP, Built a raw database, and started looking inside a few scripts to see how the process works. A little lost at this point.

What file inside of SRL holds the values for a) what IP the script will transmit the information to. b) other DB specific values, and what information it will pass to the DB?

Mainly in the design phase, but would like to hit the database with all my proggys from all my PC's then set up a PHP internal net to look at the status of all 70+ robots.

I think it is possible if I understood the trasfer of information from SCAR to SQL and vice versa.

any pointers?

[Hey321]

Check out RC ;). You set the RC nickname and then log in

Send one of your auto-ers a message saying "Status", he will then tell you who isnt working. After that you fix them, log back on your RC guy and send him a message saying "Reset" he will then make everyone on the script true ;).

[botmaster]

Check out RC ;). You set the RC nickname and then log in

Send one of your auto-ers a message saying "Status", he will then tell you who isnt working. After that you fix them, log back on your RC guy and send him a message saying "Reset" he will then make everyone on the script true ;).

/sarcasm
Try doing that with 70 + players on a massive scale. Tough luck waiting 5 minutes for every RC command to execute. Let's see, thats 70 x 5 minutes of my life wasted, plus minutes added for solving randoms. And who said autoing was supposed to recude wasting time playing RS?
/sarcasm

Naw, I think the SQL db is a good solution towards keeping track of your army if you have more than 10 players. I suck at SQL though :(, I'm not even that good at php besides the basics, :)

Anyways, I hope the system works. Maybe make scar scripts send a post variable to a site, then putting the info into a MySQL db and making SCAR repeat the command every few minutes, so you can even produce an activity log.

Another cool feature of such a system would be if you could make your players active or inactive from the online contol panel. Maybe fsockopen and then open a connection to SCAR telling it what to do?

The possibilities are virtually endless. If you're great at programming, you can even make SCAR call procedures and functions from a remote place via click of a button.

The MySQL db in this case would primarly serve as a "Buffer" for information passed between the site and SCAR.

[Jason2gs]

Five minutes per command? I'm sure that's somewhere in the SRL include. I'm sure you can screw with things enough to make something happen to your benefit :)

[WT-Fakawi]

The SQL - database is an excellent idea for maintaining and keeping track of your Players. Not only there current whereabouts, but surely more usefull stuff like amount of time online, which script it has been running, how many randoms it encountered (and when), what profit it has made. But also you could use it to control the time of day to use the Player. You could even enclose ChatBase for synchronised crosslinked private chat.

[botmaster]

RC is a little bit to slow to keep things in control with; it takes 5 mintues for every command to exectute because it needs to clear the chat window, whereas with MySQL, one could achieve a whole lot more a lot simpler. Especially because at work/school/office, RS may be blocked so using RC is somtimes impossible. SQL commands can't solve randoms, but at least you know the status and you may have the ability to kill the script if something goes bad.

Why didn't we come up with this earlier XD. This system would be so awesome.

[lefamaster]

messing with the SQLstats has opened up an entire world I never would have dream exsited, so it just seemed obvious to try and simplify my work on my army. I tried the RC thing, very time consuming, plus I run multiple computers at my house and work. I currently pause the script and manually log in each character(70+) and it takes roughly an hour.

It would be a dream come true to see all the information in columns in a nice multi-format page. Just to all at once, see who is "False" and where the hell they think they are. Huge time saver.

I am slowly becoming addicted to the "flavor" of the SRL community and less aware of the taste of RS, i hardly ever play anymore. (it tasted pretty afwul anyway). My army and the SRL community are my primary focus as of now.

I dug around the GlobalStats file, but there are other variables called in it from other places. I need a road map.


**polietly bows before the coumminty and courtseys off stage****

[Boreas]

Why didn't we come up with this earlier XD.
Couple devs have talked about it.


An idea along the same lines for 24/7 autoing: Have 4 teams, of about 4 players each. Each team autos for about 6 hours per day, in the following manner. Sleep and go to school/work for 15 hours, play on (about 1/4 of the time for each player) and off (about 3/4 of the time for each player) for 3 hours, then have dinner and watch tv for 3 hours, and then another 3 hours of playing on and off. This way you can play legit, do quests, solve randoms in the time they are at school/work/dinner on another computer.

To recap, each of these are 3 hour blocks.
|Team 1|Team 2|Team 1|Team 2|Team 3|Team 4|Team 3|Team 4|
Within each block, players of that team take about 5 minutes turns, as is the system now.

[lefamaster]

then perhaps the SQL database would be the glue that would tie them together. The sort of "team page" to keep everyone on the same page.
pardon the pun.

[omgh4x0rz]

It sounds like a good idea to me. I don't know anything about what you're talking about though :(
What is SQL even(sorry for the nub question)? And how do you send the information from SCAR to the server or whatever you are planning to recieve it with?

[lefamaster]

long defintion of what is SQL (http://en.wikipedia.org/wiki/SQL)

but basically...it is a database server. It can run and recieve information from almost any source. It can compile and organize a vast amount of data, and when used with the program language of PHP it can produce a huge amount of data population into a single webpage.

even simpler....it can collect all the data of all the bots that you/me/we can run and organize all of that data into something useful.

[Thick As Blood]

something useful, such as something like GlobalStats, but more advanced, correct?

[omgh4x0rz]

Cool. So would you have to pay to get a server, or are there free ones? Also, you said when used with PHP it can organize lots of data. I thought SQL was a language itself, so why do you need to combine it with something else?

[lefamaster]

imagine SQL as the wharehouse, and PHP would be your Wharehouse foreman. While the wharehouse stores all the data, the "foreman" PHP can call up, sort, produce sepcific requests with all the stuff in the wharehouse.

WAMP is a free PHP/APACHE/SQL server that is very easy to install, and is used to host games and databases.

[Markus]

This is a nice idea, running a mysql db to manage the status of your players.
Maybe you can rip some of SRL's globalstat parts in order to create your own scar/mysql script.
If you need help with the PHP/SQL part, I can help you with it.
edit:
I've started now on this, and I already have a script (scar) that sends the stuff to the server.
I only need to make the PHP part complete and the recieve part (so you can click on a stop button :p)
As of now, it sends the username, location, nick, and the status of the player.
I want it to also send all stats of the players, so you can see for example, how good fawki's goblin scheduler is :p