Thread: C# Highscores App | MySQL | 718

Page 1 of 2 12 LastLast
Results 1 to 10 of 20
  1. #1 C# Highscores App | MySQL | 718 
    Registered Member
    Join Date
    Feb 2017
    Posts
    6
    Thanks given
    0
    Thanks received
    0
    Rep Power
    0
    Hey, First time posting here, and as it is not Java, I don't know how well it will go down.

    This uses a modified version of King Foxes 718 Highscores system.
    Modifications include.

    `Added extra columns to the Database for the Level for Exp using the inbuilt getLevelForExp() method.
    `Changed the Highscores.java class to send the Levels to the database as well as the Exp for each level.

    Server Side Stuff:
    `I have my server update the database with the online players levels and exp every 5 minutes when the server sends out a world message. (I wanted to have it a little shorter but you will come to have a lot of lag with a number of players.)
    `Server send the players Username, Exp for each skill, Level for each skill, and Total Level to the database.

    Application Side:
    `On startup the application will connect to the Database that is hardcoded into the program. (Plan on making an administrator settings panel where you can add your server settings in as needed.)
    `You select a user and Get Levels
    `If you don't select a user you will get an error telling you to select a user first.
    `After you have got the levels for the first player, you are able to select a new player and get their levels, the list will auto update for the new player.

    Media:



    Hope you like it as much as i found it fun to make.
    Reply With Quote  
     

  2. #2  
    Registered Member
    bracket's Avatar
    Join Date
    Aug 2009
    Posts
    5,178
    Thanks given
    969
    Thanks received
    1,049
    Rep Power
    2644
    Updating the online players to your database every 5 minutes is horrible (what if you have hundreds of players online? it would cause performance issues), it would be better if it would be updated once the player ends the session (logout).
    Reply With Quote  
     

  3. Thankful users:


  4. #3  
    Registered Member
    Join Date
    Feb 2017
    Posts
    6
    Thanks given
    0
    Thanks received
    0
    Rep Power
    0
    I must agree that for a large server it is very stupid. But for one in which is new and doesn't have a large enough player base for it to make a large enough performance impact.
    Reply With Quote  
     

  5. #4  
    Registered Member
    bracket's Avatar
    Join Date
    Aug 2009
    Posts
    5,178
    Thanks given
    969
    Thanks received
    1,049
    Rep Power
    2644
    Quote Originally Posted by Oli Elysium View Post
    I must agree that for a large server it is very stupid. But for one in which is new and doesn't have a large enough player base for it to make a large enough performance impact.
    To some extent you are correct, but doing these kind of things this way will only teach you bad programming habits.

    edit: not trying to be an ass, just giving some tips
    Reply With Quote  
     

  6. Thankful user:


  7. #5  
    Registered Member
    Join Date
    Feb 2017
    Posts
    6
    Thanks given
    0
    Thanks received
    0
    Rep Power
    0
    Quote Originally Posted by Bracket View Post
    To some extent you are correct, but doing these kind of things this way will only teach you bad programming habits.
    And again yes you are right.

    This was mainly implemented after players were sessioning 5-10 hours. This is to allow for their scores to update. I have already changed this to 30 minutes though and then they only update 5 at a time.

    Thanks for the suggestions though
    Reply With Quote  
     

  8. #6  
    Registered Member
    Join Date
    May 2016
    Age
    20
    Posts
    234
    Thanks given
    125
    Thanks received
    39
    Rep Power
    17
    So this was written in C#? I always thought that icon was the default icon for VB 2008+
    I seriously can't see King Fox's highscores anywhere in your application besides the serversided part which is just a mysql connector which saves to db on logout.
    Need RSPS Website related services? Look no further.
    [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]
    Reply With Quote  
     

  9. #7  
    Registered Member
    Join Date
    Feb 2017
    Posts
    6
    Thanks given
    0
    Thanks received
    0
    Rep Power
    0
    Hey. Thanks for the comment. I believe they both use the same icon. But what I meant was if you used this it would be easier to take king foxes code and just add in the code for doing the levels as well as exp.
    Reply With Quote  
     

  10. #8  
    Registered Member
    Join Date
    Oct 2016
    Posts
    2
    Thanks given
    0
    Thanks received
    0
    Rep Power
    0
    Why don't you reload on the "onchange" event by the box on the left?
    UX -> extra click is 'always' bad
    Reply With Quote  
     

  11. #9  
    Visionary

    Join Date
    Jun 2008
    Posts
    3,521
    Thanks given
    448
    Thanks received
    1,229
    Rep Power
    933
    why do you have to click a button every time to see someones highscores? that's super tedious

    why not make a web app for this instead of a desktop app?
    Reply With Quote  
     

  12. Thankful users:


  13. #10  
    Registered Member
    Join Date
    Jun 2012
    Posts
    55
    Thanks given
    3
    Thanks received
    5
    Rep Power
    11
    One quick question, do you distribute this with or without your DBA credentials?
    Reply With Quote  
     

Page 1 of 2 12 LastLast

Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [317] Highscores Error [Mysql]
    By TehEnvyyy in forum Help
    Replies: 10
    Last Post: 04-29-2014, 12:26 PM
  2. Replies: 0
    Last Post: 03-04-2014, 02:16 PM
  3. MySQL. [718]
    By Tomas in forum Help
    Replies: 0
    Last Post: 04-05-2013, 06:57 AM
  4. HighScores Without MYSQL!?!?
    By jake2624 in forum Chat
    Replies: 3
    Last Post: 08-18-2012, 11:09 PM
  5. HighScores via MySQL and online viewing
    By Jellybean732 in forum Tutorials
    Replies: 54
    Last Post: 06-05-2010, 10:16 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •