FREEBS - Free Book Store Release

The notices are coming in by the hundreds, literally!

The bot is taking a nice long walk through the books. This is cool!

 

Over 300 more books walked.

Now it's hitting my Home Repair site which is only one week old or so.

 

Very nice.

 

Hi,

I finally got around to doing a quick hack for putting 5 direct book links on the main book index. Basically this grabs 5 books from a random starting position in the first 100 books records ordered by Amazon's 'ranking' field. Hopefully it will get a few book titles indexed a bit faster.

File: index.php

SEARCH FOR:

		if( $SEO_MODE )
		{
			$books_html = file_get_contents("./templates/seobookindex.html");
		}
		else
		{
			$books_html = file_get_contents("./templates/bookindex.html");
		}
		ob_start();

Code (markup):

INSERT BEFORE:

		//
		//Load up five random books
		//
		if ($books_avail>100)
		{
		  $lower_limit=rand(1,95);
		}
		else
		{
		  if ($books_avail>5)
		  {
		    $lower_limit=rand(1,$books_avail-5);		
		  }
		  else
		  {
		    $lower_limit=1;
		  }
		}
                if ($books_avail<5)
                {
		  $query="SELECT * FROM ".TABLE_PREFIX."items ORDER BY RATING LIMIT ".$lower_limit.",".$books_avail;
                }
                else
                {
		  $query="SELECT * FROM ".TABLE_PREFIX."items ORDER BY RATING LIMIT ".$lower_limit.",5";
                }
		$result=mysql_query($query);
		
		while ($data=mysql_fetch_Array($result))
		{
		  $popular_books.= '<a href="book.php?isbn='.$data[asin].'.html">'.$data[name]." : ".$data[author]." : ".$data[rdate].'</a><br />';
		}

Code (markup):

File: template/bookindex.html

Insert At EOF:

<table border="0" width="100%" cellpadding="5">
  <tr>
    <td><br /><b>Popular <?php echo $keyword; ?> Books!</b></td>
  </tr>
  <tr>
     <td><?php echo $popular_books; ?></td>
  </tr>
</table>

Code (markup):

I didn't do the coding for the SEO_MODE because it doesn't work on my server but I'm sure noppid will do it.

 

If a 1.11 becomes necessary, this is in there in a similar fashion.

What? You thought I didn't read those suggestions?

 

For the .htaccess file? Yes I did. Unfortunately it simply doesnt work on my server for rewriting URL's (301's work just fine). I've got a support ticket up at my host but they're not really helping. Oh well.

 

OK, I'm lost.

What's broke where?

What I did was based on your idea, random books called "Our Picks" on the pages. The SEO mode links are included.

I'll try and zip up 1.11, but if my head starts to hurt and I jump off the roof, it's your fault.

Anyway, What the hell are we talking about?

 

lmao I thought you were talking about the SEO_MODE stuff not working on my server. No need for you to do anything for me noppid, it's all working fine, other than the .htaccess thing, but there's nothing you can do about that!

 

Oh I see. I didn't understand. But I did add the randoms to the program.

 

Well Google is steadfastly refusing to index any pages on my baby books site, but it has been going crazy on my second book store, Time Management Books today. 100+ Google is crawling your site emails this morning.

 

Yes, agreed, different reactions on my end too. Attacking one site and gingerly walking the other. The other two are new and could have months of suffering ahead of them while they age.

 

My San Diego Book Store is already page 6 Google for " San Diego Books "

 

Just did a search around my sites..... I have the program on seven sites.....many thanks Noppid
Google has found the bookshop on two sites, on one it's just the main page but on the other site that page and two letter pages have been found......so we are on our way .

I noticed that on two of my new sites (less than a month old) that Google just gave PR to, one PR2 the other PR3 Google only sees 1 page
I wonder why Google was so generous to these two sites

 

This one is doing good.

http://www.google.com/search?hl=en&...familyseekers.org/genealogy-books&btnG=Search

My other 4 have 1 and 1 and 47 indexed. That 640 is encouraging.

 

This one is doing even better..... 823

http://www.google.com/search?hl=en&...w.lincolnsofdistinction.com/books&btnG=Search

 

Dang I'm still at 36. Hmm

 

The first visitor to two of my sites on May 1st was from Japan, it arrived right after midnight, I assume it was a bot as it checked out dozens of the bookstore pages on both sites, it has since been to four other sites that has the bookstore. In fact on all those sites it has visited the most pages by far.
Another visitor that I have never seen before is the Linkwalker bot, this has also been over sites I have the bookstore on and looked through a lot of pages.

The only site that hasen't had a visit from either of these bots is a site where I didn't apply the store correctly.

So it's looking good, I just hope they continue to visit my sites and I'm hoping at least one of them has something to do with Google .

 

I stopped posting about it, but the bots seem to love taking walks in all of my book stores.

 

Bumb, still only 37 pages indexed. How about that random book page. I'd love to set up a few links to that just to get these search engines indexing some books. Whats everyone index count so far?

I have pr 4 homepage on one of my sites that gets indexed daily that I would be willing to link to a few other book stores. Of course in retunr I'd like some pr4+ links going to my book store.

 

Hehe 672 pages now.