Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation [HELP] How do I make a 1-100 list for a Game. [PLASE READ]

    How do I make a thing like this http://imobcodes.com/ so that people enter there user name and friend code and it puts them in a 1-100 line.. and when they do it the get put at #1 and go down as others post theres..

    and i wanna make it so they can only post each hour..

    also I wanna be able to change peoples name colors.. like if there a donor and such..

    PLEASE HELP!! I think this is PHP with MySql If i dont have to use my MySql them please tell me how I can I have 0 knowledge of both of them..

    So please check out these sites.. I wanna be able to do what there doing here is a couple more..

    http://girlwarcodes.com

    PLEASE HELP ME

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    26,603
    Thanks
    80
    Thanked 4,500 Times in 4,464 Posts
    If you really have zero knowledge of both PHP and MySQL then you have two choices:

    (1) Get ready to spend at least a couple of weeks (depends on how fast you are at leaning computer languages, etc. 2 weeks? 4 weeks? 12 weeks??) learning the basics of both PHP and MySQL. [But first check if the ISP you are using even supports PHP! If you are using a Windows-based host, for example, you may need to use ASP or ASP.NET instead.]

    (2) Pay somebody to write this for you.

    There's a separate forum on this site for hiring people to do little jobs like this.

  • #3
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Old Pedant View Post
    If you really have zero knowledge of both PHP and MySQL then you have two choices:

    (1) Get ready to spend at least a couple of weeks (depends on how fast you are at leaning computer languages, etc. 2 weeks? 4 weeks? 12 weeks??) learning the basics of both PHP and MySQL. [But first check if the ISP you are using even supports PHP! If you are using a Windows-based host, for example, you may need to use ASP or ASP.NET instead.]

    (2) Pay somebody to write this for you.

    There's a separate forum on this site for hiring people to do little jobs like this.
    Shouldint this be farly easy i mean all it is doing is putting things in a 1-100 line and droping them down as more people put there info (USername) in..?

    I mean could you give me a simple one? Im usign 1and1 windows host...

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    26,603
    Thanks
    80
    Thanked 4,500 Times in 4,464 Posts
    Sure, the SQL code is simple.

    But now you have to learn how to use PHP to display what's in the DB table.

    And you asked for lots of other extras, like coloring and donors and and and...

    I am *NOT* a PHP programmer. But I consider myself expert in JSP and ASP and moderately advanced in MySQL, so I think I could do this in a day or two. Would probably take an experienced PHP person somewhat less than a day.

    The SQL involved is pretty trivial:
    Code:
    To add a new person:
         INSERT INTO friends ( whenadded, friendcode, userid, donationamount )
         VALUES( Now(), $friendcode, $userid, $donationamount )
    
    To get the last 100:
         SELECT * FROM friends ORDER BY whenadded DESC LIMIT 100
    But after that...depends on how fancy you want it to be.

  • #5
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Old Pedant View Post
    Sure, the SQL code is simple.

    But now you have to learn how to use PHP to display what's in the DB table.

    And you asked for lots of other extras, like coloring and donors and and and...

    I am *NOT* a PHP programmer. But I consider myself expert in JSP and ASP and moderately advanced in MySQL, so I think I could do this in a day or two. Would probably take an experienced PHP person somewhat less than a day.

    The SQL involved is pretty trivial:
    Code:
    To add a new person:
         INSERT INTO friends ( whenadded, friendcode, userid, donationamount )
         VALUES( Now(), $friendcode, $userid, $donationamount )
    
    To get the last 100:
         SELECT * FROM friends ORDER BY whenadded DESC LIMIT 100
    But after that...depends on how fancy you want it to be.
    Ok well I beleive you are smart enough to help me if you could?
    I dont care how fancy it is I can code HTML... This is my site.. http://thatrandompodcast.com

    So I can code the looks I just want to be able to put in a code and it adds it to the top of the list.. so it could like like this..

    Girl Wars Code List ( Latest 500 )
    (Add codes in red - They help keep the site up and usually are the best girl wars codes!)
    # 166-123-560
    # 156-792-587
    # 141-447-342
    # 173-592-127
    # 115-449-854
    # ect....

    It can just be plain Ill center it and put design around it later..

    Also I just want it to be like there friend code and thats all.. I want them to be able to put there code into a bar press done or enter then it puts there code in the list.
    Last edited by JakeJumpsHigh; 04-13-2009 at 11:34 PM.

  • #6
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    26,603
    Thanks
    80
    Thanked 4,500 Times in 4,464 Posts
    Sorry, but not going to tackle PHP. I don't even have a PHP server to test with.

    Maybe somebody else will read this.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •