ULX

Author Topic: MySQL Statistics of everything  (Read 3760 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}"
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.

Offline RunEndless

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
Re: MySQL Statistics of everything
« Reply #2 on: September 19, 2010, 05:22:29 AM »
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.
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.

Offline RunEndless

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
Re: MySQL Statistics of everything
« Reply #4 on: September 19, 2010, 12:30:01 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
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.
"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 »
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.
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.

Offline RunEndless

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
Re: MySQL Statistics of everything
« Reply #8 on: September 26, 2010, 05:52:40 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.
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.');