|
Post by mundas on May 23, 2011 21:09:54 GMT 1
anyone know who this person is? www.runegame.com/vbf/showthread.php?t=33961i mean the guy who made that thread. what he created there is great, and i would love to reply, so i made an account on runegame.com forum. buts the way it looks its never going to be unlocked.
|
|
|
Post by Karigard on May 23, 2011 21:37:57 GMT 1
No idea who that is.
His creation sounds great though. Could really come in handy for that serverstat mutator shex wanted.
|
|
|
Post by mundas on May 24, 2011 13:34:07 GMT 1
exactly, but i was thinking further. imagine all "big" servers uploading player stats to a central database - a "global" version of serverstat. and if the mutator allows querying as well, the current top 5 could be displayed right under the scoreboard or something..
|
|
|
Post by Trouble* on May 25, 2011 12:40:10 GMT 1
i guess it's an easier way of stat logging. looks good. i guess it is possible to connect some servers with this, perhaps you can use vnb forum as a central, cause everyone is around here most. I was thinking of making a seperated section below the clanwar section, and add the list there. Or would it be impossible to connect this to a forum?
|
|
|
Post by Karigard on May 25, 2011 16:19:59 GMT 1
Global serverstats sound even better I like the idea of having the top 5 displayed ingame. I'm not sure why you'd want to use the forum for this. A spereate site sounds much better. Then there could be a link under the stats under the scoreboard so people know where to look at the stats. The URL should be something simple and easy to remember.
|
|
|
Post by =[VnB]=Wrath on May 25, 2011 22:53:35 GMT 1
Sounds like a great thing. I like stats. But how would you track it? By nickname? Ip? Both? Is there a way to avoid people faking your nick and trashing your stats; i.e. registered users only? Maybe it would be possible to have some kind of temporary stats for the general public, but you would have to register to ensure they were permanently stored. So stats were saved for each nickname, but they would be scrapped by the end of the day, or week, unless the player was logged in using their password? I dunno, it makes it a much bigger hassle, I know. But how would you counter the fakers? The URL should be something simple and easy to remember. I did a quick check and www.runestats.com (& .net, .org, .info) is available. I've never owned a domain before so I'm not sure about the pricing but it looks like you can get one relatively cheap ($5-$15 per year).
|
|
|
Post by mundas on May 26, 2011 19:26:15 GMT 1
i dont like the idea of registration. you could just refuse to authenticate or create a dummy account to prevent statlogging (and thus only record games where you perform well).
by the way, its not just the url. you also need a php-enabled webserver that can host a sqlite database.
|
|
|
Post by shexpeare on May 28, 2011 22:08:10 GMT 1
I have no idea who this Canyouh is but what he did here is great. Earlier me and Mundas made a statlogger that logged everything in a text file. And a php-script loaded the stats from that log to a database. Both solutions give the same result in the end, storing the logged data in a database. But using this sqlite database will probably make things easier for admins. It should be possible to get the stats uploaded to a website without having to do anything manually. Global server stats would be nice indeed. Getting the domain and a host isn't any problem. If it's needed I can register and pay for it. I don't think there is a good solution to track players. Both IP and Name can be changed if a player wants to. By always logging a players IP and name you can at least check if same IP used different nicks and vice versa. Maybe some kind of registration could work. But then again the Rune players are a lazy people so I'm not sure many would actually register. EDIT:An easy way to check the saved data on a local sqlite database is to use Firefox withl this add-on: SQLite Manager
|
|
|
Post by mundas on May 29, 2011 9:56:38 GMT 1
ive taken a look at it.
-it creates a .db file in the system folder that contains the data. you can not specify a remote database to write stuff to.
-it works by sending SQL commands from ingame. this gives maximum flexibility, but may require some security measures against sql injection.
if communication with a remote DB would be possible, it would be perfect. maybe someone can request that in the runegame.com thread for me? i just cant reply with my account, its driving me insane.
update: i have another request: sql errors should be returned as strings. for example:
log(rdb.saveData(CREATE TABLE XYZ));
should write "table XYZ already exists" to the log if the table is already in the database.
second update: whenever i use loaddata(), the game crashes. whats up with that? my rows don't contain the [ ] from the example, are those required?
|
|
|
Post by shexpeare on May 29, 2011 12:02:27 GMT 1
I tested the chatsaver mutator and noticed the data was stored in a table named Runedata.
If the mutator uses SQL commands to save to a db it should be possible to use other commands as well? Lets say you want to backup the database every hour (as an example). Wouldn't it be possible to make the mutator run given SQL commands every hour?
I'm not that familiar to SQLite, I always used MySQL. SQLite is a bit more restricted compared to the commands you can use with MySQL. I have to do some reading about that. But preventing SQL injections shouldn't be a problem.
Ill make a post in the runegame.com thread for you.
|
|
|
Post by Karigard on May 29, 2011 12:22:52 GMT 1
Ouch, why didn't I think of this before? SQLite is a serverless database meaning there is no remote access to a server. This is problematic since the Rune server is obviously not the same as the webserver.
I'll ask him if he can write a RuneDB for MySQL instead and if not maybe I'll just do it myself. All that needs to be done for that is to wrap the most important MySQL API calls to UnrealScript accessible funtions. Shouldn't be too hard, I think.
|
|
|
Post by mundas on May 29, 2011 13:02:36 GMT 1
made a small mutator that logs kills and deaths. it logs all kill/death events: and keeps global account of individual player stats: SQLite is not server based, but it should still be possible to write to a remote database, via a shared folder or FTP. it would require the sqlite mutator to allow writing to a folder other than Rune/System.
|
|
|
Post by Karigard on May 29, 2011 20:39:53 GMT 1
Weird solution, but if it works it's fine.
It seems your account on runegame.com has now been activated, mundas.
Nice work on the mutator, btw.
|
|
|
Post by mundas on May 30, 2011 9:47:04 GMT 1
talked to shex about it, we pretty much agree that a mysql db that can be remotely accessed from rune would be the best solution. Its the weapon of choice, if someone can make a .dll for it (i dont have much time and my c++ skills are not very good).
the sqlite solution can be used if mysql is not an option.
|
|
|
Post by shexpeare on May 30, 2011 15:26:10 GMT 1
It would be great if MySQL can be used instead of SQLite. About those sql injections.. Im used to having php-scripts that handles the incoming data. Like preventing sql injections. So the information from a webform or file is pointed to myscript.php that saves it to DB. It's important that this can be done by the mutator if it has access to a remote server.
|
|