Thread: MySQL : Player Loading / Saving - Creating a Query

Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13
  1. #11  
    Banned

    Join Date
    Oct 2009
    Posts
    438
    Thanks given
    29
    Thanks received
    108
    Rep Power
    0
    Quote Originally Posted by funkE View Post
    no the amount of digits is 11 not the maximum value (incl - i believe) int is 4 bytes no matter what or else it's not an int

    I don't think you really understood what I wrote. I never said that int has a maximum value of 11. But I also see where you're coming from because I've realized I had a mistype.
    Reply With Quote  
     

  2. #12  
    Registered Member
    Join Date
    Jun 2016
    Posts
    52
    Thanks given
    5
    Thanks received
    0
    Rep Power
    11
    Quote Originally Posted by Brandito View Post
    Well, add my skype (brandon_dtd) and I'll show you how I integrated player data into the website.
    Basically only save the things you need to save to MySQL, on my websites I let players view stuff like their total donations, points (pk, vote, donator) and also let players change data like their unlock pin, email address, password (and display name for servers that have that) and loyalty titles if you want to go all out fancy and have them shown before/after the username. Obviously though, before putting passwords anywhere near MySQL, hash them server-sided, not encrypt, hash.
    i will shoot you an add , Ive done something similar for a different game so i figure i could work something to use the same idea towards RSPS.
    and ofcourse haha , the server sided part hasn't even really started yet was more or less trying to get the SQL part out of the way since I really dont have a strong knowledge of it

    Quote Originally Posted by x_stormrider View Post
    http://www.peachpit.com/articles/art...30885&seqNum=7
    Give that a good read and it should start a good foundation for understanding the difference in data types.


    int(11) means that the column can store maximum int value of 11, whereas, NOT NULL means that it must always contain a value.
    Thank you i will give it a good read!

    Quote Originally Posted by funkE View Post
    no the amount of digits is 11 not the maximum value (incl - i believe) int is 4 bytes no matter what or else it's not an int
    I had thought the same thing he did by my prior knowledge , i figured int(11) would mean a number with a max value of 11. So thank you very much for clearing that up.
    Reply With Quote  
     

  3. #13  
    ???

    funkE's Avatar
    Join Date
    Feb 2008
    Posts
    2,612
    Thanks given
    255
    Thanks received
    989
    Rep Power
    1366
    Quote Originally Posted by x_stormrider View Post
    I don't think you really understood what I wrote.
    i disagree. i interpreted it as unclear and potentially misleading. how does that make my understanding wrong?

    Quote Originally Posted by x_stormrider View Post
    I never said that int has a maximum value of 11.
    yes you did, you said this:

    int(11) means that the column can store maximum int value of 11
    either way, it wasn't clear what that even means so i attempted to make it clear.
    .
    Reply With Quote  
     

Page 2 of 2 FirstFirst 12

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. [PI]Better Player Loading/Saving
    By Slawth Baws in forum Snippets
    Replies: 27
    Last Post: 02-20-2013, 03:23 AM
  2. [PI]Better Player Loading/Saving
    By Slawth Baws in forum Snippets
    Replies: 3
    Last Post: 02-15-2013, 12:26 AM
  3. [Hyperion] MySQL Character Loading/Saving
    By Joshua F in forum Snippets
    Replies: 6
    Last Post: 12-03-2012, 01:52 AM
  4. [562][rs2hd] MySQL Player Saving & Loading [REQ]
    By coolv1994 in forum Requests
    Replies: 11
    Last Post: 09-11-2011, 01:36 AM
  5. [DELTA] mySQL Player loading
    By nl pk3er in forum Help
    Replies: 2
    Last Post: 04-25-2010, 01:43 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
  •