1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

FREEBS - Free Book Store Release

Discussion in 'Products & Tools' started by noppid, Apr 13, 2005.

  1. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #21
    Thanks for sharing your results. I'm glad you found some content.

    FWIW, I can only pull about 1600 returns right now, the aws server is probably real busy. Try again later maybe. I usually get 2500 results, the current limit.
     
    noppid, Apr 13, 2005 IP
  2. mnemtsas

    mnemtsas Super Dud

    Messages:
    497
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    0
    #22
    No problems, thanks again, great script, looks like 500-600 is about the most my server is handling, so I'm just varying the keywords and getting a few thousand results that way. Here's the store btw : www.buyjoggingstrollers.com/baby-books/

    Mark
     
    mnemtsas, Apr 13, 2005 IP
  3. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #23
    Very clever, cool idea!
     
    noppid, Apr 13, 2005 IP
  4. mnemtsas

    mnemtsas Super Dud

    Messages:
    497
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    0
    #24
    :D Actually varying the keywords is giving some nice results, working in a lot of topics that are not thrown up by the primary KW I'm using.
     
    mnemtsas, Apr 13, 2005 IP
  5. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #25
    WoW nice job on the layout! I tried real hard on the templating thing, I guess it's workable.
     
    noppid, Apr 13, 2005 IP
  6. mnemtsas

    mnemtsas Super Dud

    Messages:
    497
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    0
    #26
    The templates work just fine, real easy to work out, I just wrapped everything in the simple css layout I use for the rest of the site, took about 30 minutes I suppose.
     
    mnemtsas, Apr 13, 2005 IP
  7. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #27
    I'd like to make a list of sites using freebs, may I list yours?
     
    noppid, Apr 13, 2005 IP
  8. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #28
    I'd like to make a list of sites using freebs, may I list yours?
     
    noppid, Apr 13, 2005 IP
  9. mnemtsas

    mnemtsas Super Dud

    Messages:
    497
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    0
    #29
    Sure thing.
     
    mnemtsas, Apr 13, 2005 IP
  10. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #30
    I thought of a flaw. There is code to expire books that are a week old when you pull. However using live pricing data on the purchase pages we can cache the other data for 3 months.

    So...

    I will get rid of the weekly expire code and leave it up to the store owner to follow the TOS and do the 3 month updates.

    Keep a list of the keywords you pull.

    Thanks.

    EDIT: oops, I'll just make it 90 day expire code. :D
     
    noppid, Apr 13, 2005 IP
  11. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #31
    Joeychgo informed me this morning that I forgot to make it so our titles and descriptions can be dynamic with book information in the header.html template. So I made that so. This is a huge SEO improvement I just over looked. DOH!

    Anyway, 1.03 is released and this also automates the install by just running p3.php which auto creates the tables if they don't exist and then populates the database. You could have a book store in under 15 minutes in most cases.

    BTW upgrading from 1.02 is painless too. Replace the 3 php files and do an edit to your header.html template to make the title and description dynamic.

    FREEBS - Free Book Store
     
    noppid, Apr 14, 2005 IP
  12. mnemtsas

    mnemtsas Super Dud

    Messages:
    497
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    0
    #32
    I was laying in bed thinking about this during my regular 4:00am insomnia period. How about changing the $keyword to an array and storing the $keyword corresponding to a returned book against the book record? You would need to do your amazon pull in a loop and add your own field to the returned records but the actual MySQL stuff would be the same.

    Then you could have widely varying <title> <h1> tags allowing to target a range of related KW...... Something to think about anyway.

    Mark
     
    mnemtsas, Apr 14, 2005 IP
  13. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #33
    Yep, making $keyword an array for the pull would work. But, I would make a new array and use it instead. Leaving $keyword for a default on display. Then after getting a record from the DB use that keyword instead.

    A list of like 4 keywords would be good, making for about a half hours work for p3.php. I'm sure folks would test the limits of that list length. hehe

    We add a field to the items table called keyword and store it. No problem there.

    I'll think on it. ;)
     
    noppid, Apr 14, 2005 IP
  14. mizt

    mizt Active Member

    Messages:
    772
    Likes Received:
    39
    Best Answers:
    0
    Trophy Points:
    70
    #34
    Well I got mind working pretty good. Great Script. Of course you can add my link to your list. Hell its your script.
     
    mizt, Apr 14, 2005 IP
  15. mnemtsas

    mnemtsas Super Dud

    Messages:
    497
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    0
    #35
    I've just done a little breadcrumb mod for the individual book pages, just added this code to the header.html file:

    
    if (THIS_PAGE== 'book')
    {
      if (strcmp(strtolower(substr($name,0,3)),'the')==0)
      {
        $first_char=$name[4];
      }
      else
      {
        $first_char=$name[0];
      }
      echo '<B><a href="index.php">'.$keyword.' Book Store</a> > <a href="index.php?key='.$first_char.'">'.$keyword.' books beginning with '.strtoupper($first_char).'</a></B>';  
    }
    else
    {
      echo '<B><a href="index.php">'.$keyword.' Book Store</a></B>';
    }
    ?>
    
    Code (markup):
    Mark
     
    mnemtsas, Apr 14, 2005 IP
  16. kyle422

    kyle422 Peon

    Messages:
    290
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #36
    Mark,
    What's a breadcrumb mod do?
     
    kyle422, Apr 14, 2005 IP
  17. mnemtsas

    mnemtsas Super Dud

    Messages:
    497
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    0
    #37
    oh ok, sorry. Ummmm when you're on a book page it displays links back to the main index plus the index page for the first letter of the book you're looking at

    Like this:

    Foo Book Store > Books Beginning with Letter F
     
    mnemtsas, Apr 14, 2005 IP
  18. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #38
    Very nice, I'm sure that will find it's way into my sites. Thanks
     
    noppid, Apr 14, 2005 IP
  19. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #39
    noppid, Apr 14, 2005 IP
  20. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #40

    I added the actual DB key to a variable to enhance your function. In the next version you can shorten your code to...

    
    <?php
    
    if (THIS_PAGE== 'book')
    {
      echo '<B><a href="index.php">'.$keyword.' Book Store</a> > <a href="index.php?key='.$bookkey.'">'.$keyword.' books beginning with '.strtoupper($bookkey).'</a></B>';  
    }
    else
    {
      if( THIS_PAGE == 'index' )
      	echo '<b>'.$keyword.' Book Store</b>';
      else
      	echo '<B><a href="index.php">'.$keyword.' Book Store</a></B>';
    }
    ?>
    
    PHP:
    Thanks for the tip.
     
    noppid, Apr 14, 2005 IP