Thread: [RSPS-SCORES.COM] Create free highscores in minutes - how to

Page 2 of 8 FirstFirst 1234 ... LastLast
Results 11 to 20 of 74
  1. #11  
    Unfortunately we’re all human. Except me


    Join Date
    Aug 2011
    Posts
    926
    Thanks given
    539
    Thanks received
    439
    Rep Power
    601
    Thanks for kind words everyone
    Reply With Quote  
     

  2. #12  
    Extreme Donator

    woof woof bish's Avatar
    Join Date
    May 2011
    Age
    26
    Posts
    2,444
    Thanks given
    2,212
    Thanks received
    1,019
    Rep Power
    5000
    Great shit! :-)

    Will convert to 667/718
    Reply With Quote  
     

  3. Thankful user:


  4. #13  
    Unfortunately we’re all human. Except me


    Join Date
    Aug 2011
    Posts
    926
    Thanks given
    539
    Thanks received
    439
    Rep Power
    601
    Now offering free instalation service

    https://www.rune-server.org/black-ma...tallation.html
    Reply With Quote  
     

  5. Thankful user:


  6. #14  
    Banned

    Join Date
    Aug 2016
    Posts
    242
    Thanks given
    109
    Thanks received
    61
    Rep Power
    0
    Quote Originally Posted by LukaFurlan View Post
    Now offering free instalation service

    https://www.rune-server.org/black-ma...tallation.html
    #realmvp
    Reply With Quote  
     

  7. Thankful user:


  8. #15  
    Registered Member
    Join Date
    Jan 2015
    Posts
    277
    Thanks given
    30
    Thanks received
    23
    Rep Power
    34
    This is a really nice release! Wondering if you are going to charge anyone for benefits eventually like motivote or rspay.
    Reply With Quote  
     

  9. Thankful user:


  10. #16  
    Unfortunately we’re all human. Except me


    Join Date
    Aug 2011
    Posts
    926
    Thanks given
    539
    Thanks received
    439
    Rep Power
    601
    Quote Originally Posted by novadude View Post
    This is a really nice release! Wondering if you are going to charge anyone for benefits eventually like motivote or rspay.
    Most of stuff will be free but there will be some premium benefits ( only doing that because i need to get money for hosting somehow, its not free ).
    Reply With Quote  
     

  11. #17  
    So when I'm free, I'm free


    Jay Gatsby's Avatar
    Join Date
    Jun 2010
    Posts
    2,307
    Thanks given
    1,148
    Thanks received
    1,982
    Rep Power
    5000
    nice one fam gj
    Reply With Quote  
     

  12. Thankful user:


  13. #18  
    Registered Member

    Join Date
    Sep 2007
    Age
    32
    Posts
    2,396
    Thanks given
    5
    Thanks received
    436
    Rep Power
    902
    I would suggest opening a single mysql connection and reusing it maybe with use of a threadpool.

    Code:
    if (connection != null) {		    try {		    	stmt = (Statement) connection.createStatement();				ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS count FROM `"+user+"_scores` WHERE username='" +username+ "'");				if(rs.next()) {					if(rs.getInt("count") > 0)  {						stmt.executeUpdate("UPDATE `"+user+"_scores` SET overall_xp = '"+overallXp+"', attack_xp = '"+attackXp+"', defence_xp = '"+defenceXp+"', strength_xp = '"+strengthXp+"', constitution_xp = '"+constitutionXp+"', ranged_xp = '"+rangedXp+"', prayer_xp = '"+prayerXp+"', magic_xp = '"+magicXp+"', cooking_xp = '"+cookingXp+"', woodcutting_xp = '"+woodcuttingXp+"', fletching_xp = '"+fletchingXp+"', fishing_xp = '"+fishingXp+"', firemaking_xp = '"+firemakingXp+"', crafting_xp = '"+craftingXp+"', smithing_xp = '"+smithingXp+"', mining_xp = '"+miningXp+"', herblore_xp = '"+herbloreXp+"', agility_xp = '"+agilityXp+"', thieving_xp = '"+thievingXp+"', slayer_xp = '"+slayerXp+"', farming_xp = '"+farmingXp+"', runecrafting_xp = '"+runecraftingXp+"', hunter_xp = '"+hunterXp+"', construction_xp = '"+constructionXp+"' WHERE username = '"+username+"'");					} else {						stmt.executeUpdate("INSERT INTO `"+user+"_scores` (username, mode, overall_xp, attack_xp, defence_xp, strength_xp, constitution_xp, ranged_xp, prayer_xp, magic_xp, cooking_xp, woodcutting_xp, fletching_xp, fishing_xp, firemaking_xp, crafting_xp, smithing_xp, mining_xp, herblore_xp, agility_xp, thieving_xp, slayer_xp, farming_xp, runecrafting_xp, hunter_xp, construction_xp) VALUES ('"+username+"', '"+gameMode+"', '"+overallXp+"', '"+attackXp+"', '"+defenceXp+"', '"+strengthXp+"', '"+constitutionXp+"', '"+rangedXp+"', '"+prayerXp+"', '"+magicXp+"', '"+cookingXp+"', '"+woodcuttingXp+"', '"+fletchingXp+"', '"+fishingXp+"', '"+firemakingXp+"', '"+craftingXp+"', '"+smithingXp+"', '"+miningXp+"', '"+herbloreXp+"', '"+agilityXp+"', '"+thievingXp+"', '"+slayerXp+"', '"+farmingXp+"', '"+runecraftingXp+"', '"+hunterXp+"', '"+constructionXp+"')");					}				}				stmt.close();				connection.close();			} catch (SQLException e1) {				e1.printStackTrace();			}		} else {			System.out.println("Failed to make connection!");		}
    There is so much un-necessary operations being performed each player logout.
    Hyperion V2 Martin's Updates.

    Scar says:
    i hate it when it hits your face
    Reply With Quote  
     

  14. #19  
    Registered Member

    Join Date
    Nov 2013
    Posts
    746
    Thanks given
    187
    Thanks received
    459
    Rep Power
    5000
    Nice one, might use it in the future rep++
    Reply With Quote  
     

  15. Thankful user:


  16. #20  
    Unfortunately we’re all human. Except me


    Join Date
    Aug 2011
    Posts
    926
    Thanks given
    539
    Thanks received
    439
    Rep Power
    601
    Quote Originally Posted by Martin View Post
    I would suggest opening a single mysql connection and reusing it maybe with use of a threadpool.

    Code:
    if (connection != null) {		    try {		    	stmt = (Statement) connection.createStatement();				ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS count FROM `"+user+"_scores` WHERE username='" +username+ "'");				if(rs.next()) {					if(rs.getInt("count") > 0)  {						stmt.executeUpdate("UPDATE `"+user+"_scores` SET overall_xp = '"+overallXp+"', attack_xp = '"+attackXp+"', defence_xp = '"+defenceXp+"', strength_xp = '"+strengthXp+"', constitution_xp = '"+constitutionXp+"', ranged_xp = '"+rangedXp+"', prayer_xp = '"+prayerXp+"', magic_xp = '"+magicXp+"', cooking_xp = '"+cookingXp+"', woodcutting_xp = '"+woodcuttingXp+"', fletching_xp = '"+fletchingXp+"', fishing_xp = '"+fishingXp+"', firemaking_xp = '"+firemakingXp+"', crafting_xp = '"+craftingXp+"', smithing_xp = '"+smithingXp+"', mining_xp = '"+miningXp+"', herblore_xp = '"+herbloreXp+"', agility_xp = '"+agilityXp+"', thieving_xp = '"+thievingXp+"', slayer_xp = '"+slayerXp+"', farming_xp = '"+farmingXp+"', runecrafting_xp = '"+runecraftingXp+"', hunter_xp = '"+hunterXp+"', construction_xp = '"+constructionXp+"' WHERE username = '"+username+"'");					} else {						stmt.executeUpdate("INSERT INTO `"+user+"_scores` (username, mode, overall_xp, attack_xp, defence_xp, strength_xp, constitution_xp, ranged_xp, prayer_xp, magic_xp, cooking_xp, woodcutting_xp, fletching_xp, fishing_xp, firemaking_xp, crafting_xp, smithing_xp, mining_xp, herblore_xp, agility_xp, thieving_xp, slayer_xp, farming_xp, runecrafting_xp, hunter_xp, construction_xp) VALUES ('"+username+"', '"+gameMode+"', '"+overallXp+"', '"+attackXp+"', '"+defenceXp+"', '"+strengthXp+"', '"+constitutionXp+"', '"+rangedXp+"', '"+prayerXp+"', '"+magicXp+"', '"+cookingXp+"', '"+woodcuttingXp+"', '"+fletchingXp+"', '"+fishingXp+"', '"+firemakingXp+"', '"+craftingXp+"', '"+smithingXp+"', '"+miningXp+"', '"+herbloreXp+"', '"+agilityXp+"', '"+thievingXp+"', '"+slayerXp+"', '"+farmingXp+"', '"+runecraftingXp+"', '"+hunterXp+"', '"+constructionXp+"')");					}				}				stmt.close();				connection.close();			} catch (SQLException e1) {				e1.printStackTrace();			}		} else {			System.out.println("Failed to make connection!");		}
    There is so much un-necessary operations being performed each player logout.
    Thank you for your suggestion!

    Quote Originally Posted by Young Murda View Post
    Great shit! :-)

    Will convert to 667/718
    You think you will be able to give me example code for higher revision? so i can put it on dashboard
    Reply With Quote  
     

Page 2 of 8 FirstFirst 1234 ... LastLast

Thread Information
Users Browsing this Thread

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


User Tag List

Similar Threads

  1. Replies: 3
    Last Post: 11-16-2015, 10:17 PM
  2. Replies: 10
    Last Post: 06-30-2011, 10:32 PM
  3. Replies: 11
    Last Post: 03-15-2011, 12:07 AM
  4. Replies: 14
    Last Post: 06-22-2008, 01:24 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •