Jump to content

limitphp

Members
  • Posts

    706
  • Joined

  • Last visited

Posts posted by limitphp

  1. My partner and I are looking to contract someone to finish building our music website.

     

    The site is not finished, but can be seen here:

     

    www.greckle.com

     

    We need someone who is very capable in PHP, MYSQL and Ajax.

     

    Here is a comprehensive list of things that need to be finished:

     

    Here is the exhaustive list of updates we need for the site:

     

    1. limit the number of login attempts to 12

     

    2. add new feature "song rating" after "add to playlist" to all songs on the index page and every other place songs are listed. Add a slider underneath "song rating" link. Have the value of the song rating be 1-10.

    example:

    Song Rating (7.2/10) (plus a slider underneath).

     

    the first number will represent the average of all the song ratings for that particular song.

     

     

    3. The index page will still list the songs with the highest number of votes for the selected time period, but the song rating will be used for tie breakers. On the index page if two songs have the same number of votes, place the song with the higher song rating on top.

     

    4. for every place there is a list of songs (playlists, artist pages, etc...except on the index page) change the text of "Songs Ordered By" to "Sort By".

     

    5. Under "Sort By" add "Song Rating" (default will list highest song ratings first).

     

    6. Under "Sort By" change the text "Most Popular" to "Popularity (By Votes)".

     

    7. Under "Sort By" list the selections in this order:

    "Popularity (By Votes)" 1st

    "Song Rating" 2nd

    "Release Date (Newest First)" 3rd

    "Release Date (Oldest First)" 4th

     

    8. On the My Account Page, keep the menu items: Account Information, My Playlists, Display Options, and Change Password links on the side, but display the info for each menu item on the main part of the page instead of the left side.

     

    9. On the My Account Page, when they click on "Display Options" change the text from "Order Songs By" to "Sort Songs By" and add all the selections listed in number 7. Let the default value be Popularity (By Votes).

     

    10. When looking at a list of songs for playlists, artist pages, etc....except on index page...change text from "Simple View" to "Table View".

     

    11. On the register page, add these two additional questions:

    "Name of Your Favorite Song?"

    "Name of Your First Girlfriend/Boyfriend?"

     

    12. On the register page, change the alert text to match the instruction text.

     

    13. On the index page, if they have not selected any genres, by default, have all the genres selected and checked off

     

    14. On index page, add a link to the "Top Selling Songs" that creates a page that looks just like the index page, except instead of sorting songs by votes, sort songs by the number of times it has been purchased. If two songs have been purchased the same number of times, let the song rating be the tie breaker. Change the text at the top "Top Songs", to "Top Selling Songs". At the top of the page, where it says "Past: 24 hrs, 7 days, 14 days, ...365 days" add another link after 365 days that says "All time".

     

    15. Remove "Hall of Fame" text from the index page.

     

    16. On the index page, add "Top Rated Songs" in the blue menu right after "Top Selling Songs". The Top Rated Songs page should look like the index page except the songs should be sorted by song rating only.

     

    17. Everywhere there is a list of songs, add a play button to the right of each of the song titles that plays a sample of that individual song. We want to stream the first 60 seconds of the song. If possible, we want to stream from the same mp3 that would be purchased.

     

    18. On the index page and anywhere else there is a list of songs, add a "Play All Songs" button that plays all the songs listed on that page in order. Add a left arrow and a right arrow button on each side of the play all button that switches to the previous song and the next song respectively. Also, add a volume slider that allows users to control the volume (perhaps located to the right of the right arrow button). Also, add another slider to the right of the volume slider that allows the user to jump to any place in the song sample (0-60 seconds). On the index page, add these buttons and sliders underneath the "Past 24 hrs, 7 days, etc list.

     

    19. Any place there is a list of songs add a "Buy Mp3" button to the right of the Play button for each song. When the user clicks "buy mp3" use Paypal's micro payments to accept payment and allow a download of the song.

     

    20. If the user has purchased a song, instead of having a button say "Buy Mp3" change it to "Download Mp3". Also, if they have purchased a song, when the user clicks on the play button for the song, have it stream the whole song.

     

    21. On the My Account page, in the menu, underneath "Account Information", add "Purchased Songs" link. When they click on the link have it list all songs purchased by user. Sort by songs purchased most recently. Also, add all sorting options in number 7.

     

    22. Create an Admin user. user: admin1 pass: adminpass

     

    23. Allow admin users edit Band Member info and Bio (which is listed on artist page) for each artist.

     

    24. Any place users can read comments made by other users, add a "Report Abuse" button for each comment. If 5 different people click the "report abuse" button for a comment, send a notification to the admin users of greckle. When the admin users login, let the notification be at the top on the index page in the blue menu to the left of search text and search box; have a small envelope icon be the notification icon with parentheses next to it that has the number of notifications in it.

     

    25. If 10 different people click on "Report Abuse" button for a specific comment, then automatically delete the comment.

     

    26. Up at the top of most pages, after "Our Mission", add "Contact Us" link. On the Contact Us page add:

    Name: [ textbox ] - required field

    Email: [ textbox ] - required field

    Comment: [ large textbox ] - required field

     

    and a "Send" Button. The send button will send it to email addresses to be determined.

     

     

    27. Also, on the index page, in the blue menu, after the last item, add "My Greckle Library" link. Have it list all songs purchased, just like in 21.

     

     

    Please provide an estimate of what it would cost to complete the updates mentioned above, and please give us your location.

     

    Please contact : mweyant1203@yahoo.com or zepking@gmail.com

  2. No, <font> has been deprecated for a while, and is no longer valid in html5.

     

    @limitphp You should use CSS to apply the font you need to the element containing your text. The element you use should be sematic for whatever the text represents/means on the page. If you need a generic element to wrap a small bit of text, use <span> or <div> depending on if you need inline or block level elements.

     

    Div would knock the text after it down on the next line, unless I added some style properties to the div. So, perhaps span is the best tag to use to change the font of one word in a section of text?

  3. We are looking for a php web developer/designer to finish our music website and as the website grows and revenue permits we would like to have you come back to work on regular scheduled maintenence and updates for the site. The website is greckle.com Some of the major changes will be adding a play all feature and play button for songs (streaming about 45 seconds per song). Adding a buy button for songs. Integrating paypal's micro-transaction interface for buying songs. Adding an interface for admin users to add band information (names, position, other text). Adding ability to stream/download full song if it is purchased.

     

    There are also some small changes that need to be done, such as adding a "rate song" link (for each song) with a possible slider scale done in flash, updating some of the genres, changing the my account page so info will be in listed on main part of page instead of in the menu, and a few other changes that we can discuss if you are interested in taking the position.

     

    You will need to be proficient in php, javascript, some flash, mod_rewrite, and semi-advanced mysql queries. If you are interested and would like to meet with us to further discuss the details of what needs to be done to the site, and how much you would charge, please email us.

     

    Due to the complexity of the site, we will need to meet in person, thus we need someone who lives in the Houston or Austin area.

     

    Mike & Chris

    mweyant1203@yahoo.com

  4. ok, I just set folder to "Greckle"; so now that piece of code looks like this:

     

    <?php
    $path_set = "/";
    $folder = "Greckle"; // set this to be "/folder" if the script is included in a folder
    define("DOC_ROOT", $_SERVER['DOCUMENT_ROOT'] . $folder);
    define("SITEURL", "http://" . $_SERVER['HTTP_HOST'] . "/" . $folder);
    ?>

     

    I exited wamp and restarted.  And the links still don't have the folder.  They still are like this:

     

    http://localhost/register.php

     

    instead of this: http://localhost/Greckle/register.php

     

     

    ONEDIT:

     

    nevermind....I just changed to:

     

    $folder = "Greckle/";

     

    the foward slash fixed it.  thanks again.

  5. Ok, my index page loads up, but the images don't work and none of the links work. 

     

    example) link points to http://localhost/register.php

     

    but it should point to http://localhost/Greckle/register.php

     

    the folder name is not being included in my links.

     

    here is the code I have that should be taking care of that  its in a file called inc_set_root.php:

     

    <?php
    $path_set = "/";
    $folder = ""; // set this to be "/folder" if the script is included in a folder
    define("DOC_ROOT", $_SERVER['DOCUMENT_ROOT'] . $folder);
    define("SITEURL", "http://" . $_SERVER['HTTP_HOST'] . "/" . $folder);
    ?>

     

     

    in the index file I call this file using this code:

     

    <?php 
    session_start();
    include("inc_set_root.php");
    include("inc_connGreckle.php");
    include("inc_global_functions.php");
    include("inc_login_script.php");

     

    that is the beginning of my index file.   

     

    the site is in C:wamp\www\Greckle\

  6. Ok....I solved it.  I deleted the testuser and created it again.  This time I gave the user all access and localhost and set the testdata database privileges.  But, I think the problem was, I had to go back in the user privileges and set to all access to testdata.  I guess it had not done that last time, even though I set access to testdata.  Anyway, my issue is resolved. 

     

    thanks all

  7. ok...I did it just for the user testuser and I got this error message:

     

    #1141 - There is no such grant defined for user 'testuser' on host 'localhost'

     

     

    here's a screenshot of the users.  on testuser, under hosts....there is a %.  Does that mean any host including localhost?

    post-71319-13482403668235_thumb.png

  8. on phpmyadmin, on lefthand side I see list of all databases including testdata.  I click on users.  I clicked add user.  for username I put testuser.  For password, I put what matches in my code.  for "database for user" I left it at  none.

     

    for global privileges I had it check all.  then I clicked the add user button.  then i went to "edit privileges" on testuser from the phpmyadmin.

     

    under "Add privileges on the following database:" I clicked on testdata.  then under

    Database-specific privileges for the testdata i clicked check all.  then i clicked the go button.

     

    anyway, for the code to connect I have this:

     

     

    <?php
    $con = mysql_connect('localhost', 'testuser', 'xxxxxxxxx') or die ('Failed to connect to the database: '.mysql_error());
    mysql_select_db ('testdata',$con);
    
    ?>

     

     

     

     

  9. When I load the site on my local machine (using wamp server) I get this error:

     

    ( ! ) Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'testuser'@'localhost' (using password: YES) in C:\wamp\www\Greckle\inc_connGreckle.php on line 2

     

    In the apache error log I get this:

     

    PHP Warning:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'testuser'@'localhost' (using password: YES) in C:\\wamp\\www\\Greckle\\inc_connGreckle.php on line 2, referer: http://localhost/

    [Mon Jul 30 19:21:11 2012] [error] [client 127.0.0.1] PHP Stack trace:, referer: http://localhost/

    [Mon Jul 30 19:21:11 2012] [error] [client 127.0.0.1] PHP  1. {main}() C:\\wamp\\www\\Greckle\\index.php:0, referer: http://localhost/

    [Mon Jul 30 19:21:11 2012] [error] [client 127.0.0.1] PHP  2. include() C:\\wamp\\www\\Greckle\\index.php:4, referer: http://localhost/

    [Mon Jul 30 19:21:11 2012] [error] [client 127.0.0.1] PHP  3. mysql_connect() C:\\wamp\\www\\Greckle\\inc_connGreckle.php:2, referer: http://localhost/

     

     

    I setup the user testuser in phpmyadmin and added testdata database to his privileges and gave him full access.  Or at least i think I did.  I don't understand why its still saying access denied.

  10. I have this notice:

    Notice: Undefined index: currentpage in C:\wamp\www\index.php on line 172

     

    Here's the code for that line:

    // get the current page or set a default 
    $currentpage = is_numeric($_GET['currentpage']) ? (int) $_GET['currentpage'] : 1;

     

    I wrote this a while back....i forgot what the question mark and colon do.  How can I fix this notice and keep $currentpage set to the right value?

     

    thanks

  11. I have this notice:

    Notice: Undefined variable: logout in C:\wamp\www\inc_login_script.php on line 11

     

    I understand I can turn off these notices, but most of you have suggested I fix them instead.

     

    Here's my code for that line:

     

    //log user out
    if ($logout=="yes")//***********	DESTROY SESSION, DELETE COOKIE, DELETE ENTRY
    {
    //code here
    }
    

     

    I guess its giving me this notice because there will be sometimes when logout doesn't have a value.  How should I fix this notice?

     

    thanks

  12. Is your $salt the same and what exactly does $queryUser have in it and what are the exact values in the database that it should be matching?

     

    How do you know they don't match? What is your code? Does your code have any error checking login in it so that you know if the problem is a query that is failing or a query that is not matching any rows?

     

    Thats it!......

    I just remembered!  I had updated my salt!

    Thank you.......!!!

  13. Thats a good idea.  I'll create a hashPass function. 

     

    As for the clean function...I'm pretty sure, I haven't changed it....:

     

    function clean($value, $type)
    {
    if ($type=="sql")
    {
    	// Stripslashes
    	if (get_magic_quotes_gpc())
    	  {
    	  $value = stripslashes($value);
    	  }
    	  $value = mysql_real_escape_string($value);
    }elseif ($type=="html")
    {
    	$value = htmlspecialchars($value, ENT_QUOTES);
    }
    return $value;
    }
    

     

  14. I'm curious.....

    I have some test accounts setup on my website I created....I have never changed their passwords.....

    I have them stored as hashes in the database....

     

    I use this:

    $password = strtolower($password);
    $password = $password.$salt;
    $password = hash("md5",$password);
    $queryUser = "SELECT userID,username,fname,lname,verified FROM user WHERE username = '".clean($username,'sql')."' AND password = '".clean($password,'sql')."'";

     

    Is there any way the passwords won't match up after a long period of time?  Maybe a change from php 4 to php 5 or something?

    They didn't stop working until after I had my account at lunarpages reactivated and they had to manually upload a database for me....

     

    They don't seem to be working.....

    I can change the passwords in them, but I'm, just curious as to how they would stop matching....

     

  15. I remember when i first setup my site on lunarpages, I had to deal with this error, where I was using the wrong password, or I wasn't using a password, I forgot. I got it working months ago...but then my account was reset because I delayed reactivating my account and thats when all the same errors popped back.

    Here's the error:

     

    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'greckle0_greckle'@'localhost' (using password: YES) in /home/greckle0/public_html/inc_connGreckle.php on line 2
    Failed to connect to the database: Access denied for user 'greckle0_greckle'@'localhost' (using password: YES)

     

    Here's my include connection code:

    <?php
    $con = mysql_connect('localhost', 'username', 'password') or die ('Failed to connect to the database: '.mysql_error());
    mysql_select_db ('greckle0_lptest',$con);
    
    ?>

     

    Where I have username and password, I have the real one...I just didn't want to post it.

    I haven't changed the password.  Actually, the only password I have is to login to lunarpages...to the control panel.

     

    This may sound like a stupid question, but how do I know if my database is password protected?

     

    thanks

     

     

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.