ULX
« previous next »
Pages: [1]   Go Down

Author Topic: MySQL Statistics of everything  (Read 3768 times)

0 Members and 1 Guest are viewing this topic.

Offline RunEndless

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
MySQL Statistics of everything
« on: September 18, 2010, 04:24:58 AM »
I would like to suggest MySQL Statistics system for optional part of Ulyssesmod that you can keep statistics of everything in MySQL database.

"Tree of Database"
{Steam_ID}
 |_ {Player Name}
 |_ {Kills}
 |_ {Deaths}
 |_ {Props Spawned (Amount)}
 |_ {Last Visit (Date, Time)}
 |_ {Time Played (Overall)}

That would be very nice.
I'm not sure does Ulyssesmod support these things, but those things and columns of information at least is nice.

I would like to code part of PHP for those information to catch information from the database to the MOTD.

Ex. "Most Killer: {Player Name}"
Logged
Scripting a PHP.

class ULX {
       function ULX_N_PHP($string) {
              echo $string;
       }
} $ULX = new ULX;
$ULX->ULX_N_PHP('PHP + OOP with MySQL is fun.');

Offline MrPresident

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 2728
  • Karma: 430
    • |G4P| Gman4President
Re: MySQL Statistics of everything
« Reply #1 on: September 18, 2010, 01:06:42 PM »
This isn't something that the guys here will include, most likely. I don't even think this would really even need to be a module, but it doesn't seem like a bad idea, maybe one of the community members here who like to dabble in SQL will pick this up as a 3rd party addon.
Logged

Offline RunEndless

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
Re: MySQL Statistics of everything
« Reply #2 on: September 19, 2010, 05:22:29 AM »
Quote from: MrPresident on September 18, 2010, 01:06:42 PM
This isn't something that the guys here will include, most likely. I don't even think this would really even need to be a module, but it doesn't seem like a bad idea, maybe one of the community members here who like to dabble in SQL will pick this up as a 3rd party addon.

I would appreciate that if someone can code that. (If someone others are interested about that too.)
I'm just interested to code part of PHP or example MOTD which is able to modify how ever wants to.
If it success well i would code mini CMS to same.
Logged
Scripting a PHP.

class ULX {
       function ULX_N_PHP($string) {
              echo $string;
       }
} $ULX = new ULX;
$ULX->ULX_N_PHP('PHP + OOP with MySQL is fun.');

Offline MrPresident

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 2728
  • Karma: 430
    • |G4P| Gman4President
Re: MySQL Statistics of everything
« Reply #3 on: September 19, 2010, 12:13:17 PM »
If you are comfortable with PHP then LUA shouldn't be a hard switch for you at all.. and the lua coding for MySQL is similar to PHP for PySQL.

If you play GMod and you know how coding/programming works I highly recommend that you look into learning how to code in LUA.
Logged

Offline RunEndless

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
Re: MySQL Statistics of everything
« Reply #4 on: September 19, 2010, 12:30:01 PM »
Quote from: MrPresident on September 19, 2010, 12:13:17 PM
If you are comfortable with PHP then LUA shouldn't be a hard switch for you at all.. and the lua coding for MySQL is similar to PHP for PySQL.

If you play GMod and you know how coding/programming works I highly recommend that you look into learning how to code in LUA.

Have tried lua, but i don't understand anything like where i have to put the file that the game executes it and blabla O.o
Logged
Scripting a PHP.

class ULX {
       function ULX_N_PHP($string) {
              echo $string;
       }
} $ULX = new ULX;
$ULX->ULX_N_PHP('PHP + OOP with MySQL is fun.');

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
Re: MySQL Statistics of everything
« Reply #5 on: September 19, 2010, 02:17:45 PM »
Basics of how/where to put things re:Lua and Gmod.
http://wiki.garrysmod.com/?title=Lua

I knew bits and peices of various scripting languages before I learned Lua.
The Gmod wiki is a great place then and now.
Logged
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming

Offline RunEndless

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
Re: MySQL Statistics of everything
« Reply #6 on: September 23, 2010, 03:41:47 AM »
Quote from: JamminR on September 19, 2010, 02:17:45 PM
Basics of how/where to put things re:Lua and Gmod.
http://wiki.garrysmod.com/?title=Lua

I knew bits and peices of various scripting languages before I learned Lua.
The Gmod wiki is a great place then and now.
Enough hard code language for me.
I stay in PHP. ^_^

By the way thank you for the wiki. I checked something out from there.
Logged
Scripting a PHP.

class ULX {
       function ULX_N_PHP($string) {
              echo $string;
       }
} $ULX = new ULX;
$ULX->ULX_N_PHP('PHP + OOP with MySQL is fun.');

Offline Aaron113

  • Hero Member
  • *****
  • Posts: 803
  • Karma: 102
Re: MySQL Statistics of everything
« Reply #7 on: September 23, 2010, 06:03:07 AM »
If your still looking for someone to code it, I'd gladly take a shot at it here in the near future.
Logged

Offline RunEndless

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
Re: MySQL Statistics of everything
« Reply #8 on: September 26, 2010, 05:52:40 AM »
Quote from: Aaron113 on September 23, 2010, 06:03:07 AM
If your still looking for someone to code it, I'd gladly take a shot at it here in the near future.

I would be glad for contribute that "addon" with my PHP Scripts.
I'm not super coder or anything else, but i'm interested to code PHP and i would like to find any kind of small "working" so i would be a piece of this kind of addon.
Logged
Scripting a PHP.

class ULX {
       function ULX_N_PHP($string) {
              echo $string;
       }
} $ULX = new ULX;
$ULX->ULX_N_PHP('PHP + OOP with MySQL is fun.');
Pages: [1]   Go Up
« previous next »