Update – Wednesday, April 8th, 2009

It’s been a little less than a week since we launched Forum Generator and the response has been fantastic. So fantastic, in fact, that we had to upgrade our server today. If you notice anything wrong, please give us a holler. Support responses will be slower than usual today due to the fact that we’re focusing on finishing up the very first Forum Generator update, version 1.0.1!

Forum Generator 1.0.1, which we hope to have finished and fully tested by today, will add a few new features that people have been asking for. We’ll create a comprehensive list of those new features and functions after the update, so stay tuned! Also, all Forum Generator users should join our forums and email support with their username and PayPal address to get access to the quite active Forum Generator support forums.

Forum Generator is Live!

For months, we at blackhatzen have been working on what many believe is one of the most effective, easy-to-use, and powerful SEO and CPA promotion tools to ever hit the market. This easy-to-install, “set it and forget it,” auto-forum generator can take a fresh phpBB 3 forum from waste of space to populated, active community in under an hour! We’ve included easy to understand, step-by-step installation and usage videos to help even the most inexperienced internet marketer off to a fast start.

Forum Generator uses blackhatzen’s own information retrieval, scraping, and parsing methods to scour the web for content related to a list of keywords provided by the user. We’ve included a powerful keyword suggestion tool built-in to Forum Generator’s user friendly, Web 2.0 control panel to help users discover a vast range of effective keywords, both short and long tail, to help them dominate almost any niche they can imagine, past, future, or present! This is truly a set-it-and-forget-it application.

Meet Forum Generator

We weren’t going to say anything, but the blackhatzen family will be showing the world their new baby tonight at 10PM EST. His name is Forum Generator. We think he’s special. We hope you will too.

We’ll try to keep active on the Twitters, so give us a follow if you want more details as they emerge.

New Product Launches This Week!

We know. We know. It’s been a while since we’ve posted something new on the website. We’ve been busy working on what we think may be our best product to date! We can’t wait to show you folks what we’ve come up with because we really do think you’re going to get as much out of using it as we do!

Want a hint? Four words: Easy. Automated. Content. Generation.

Interested in finding out more? Follow us on Twitter/ for an exclusive sneak peak at what we’re bringing to the table.

Black Hat Fun with MySQL, PHP, and mod_rewrite

A BlackHatWorld user made a thread yesterday asking how to dynamically generate a large number of “pages” from a database that could potentially be indexed by a search engine.

Basically I have a DB which contains huge number of names and I would like to create a website where all those names will be made into pages and the page title should be the DB value or etc.

Basically a main website and from there You can view a list or etc and see all those names. And all pages have the same content basically but with some variables (links). What I need is that those pages are static and seam to be useful for google etc.

I hope u understand what I need? Also when I have 100K different HTML files or maybe Wordpress posts, then wont my host f**k me in the a**?

Thanks!

Of course, the solution to his question is much more simple than creating a large number of HTML files. I spent a few minutes this afternoon making some example code to show him how something along these lines would work using MySQL, PHP, and the Apache module, mod_rewrite. Big thanks go out to taky for creating his mini PHP MySQL DB class which I’ve modified and used on multiple projects recently.

Disclaimer: This code is not secure and is not meant to be run on a production server. It does the job, but it could be much more secure and efficient. It just shown here only as an example.

We’ll be working with four files:

• info.sql – A MySQL export of the database we’re querying.
• .htaccess – Dictates the RewriteRule’s so that our user is forwarded correctly.
• query.php – Parses the GET arguments and dictates our SQL queries and displays appropriate information.
• db.php – A slightly modified version of taky’s PHP MySQL DB class.

To begin, you’ll want to upload all of the files with the exception of info.sql to a directory on a web server running Apache with at MySQL, PHP, and mod_rewrite installed. You’d want to create a MySQL database, associate a user with it, and import info.sql to generate a table in that DB called info.

info.sql:

-- phpMyAdmin SQL Dump
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
-- --------------------------------------------------------
 
--
-- Table structure for table `info`
--
 
CREATE TABLE IF NOT EXISTS `info` (
  `firstname` varchar(10) NOT NULL,
  `content` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--
-- Dumping data for table `info`
--
 
INSERT INTO `info` (`firstname`, `content`) VALUES
('chuck', 'Chuck''s text.'),
('chris', 'Chris'' text.'),
('ben', 'Ben''s text.'),
('andy', 'Andy''s text.'),
('alan', 'Alan''s text.');

.htaccess:

Options +FollowSymlinks
RewriteEngine On
 
RewriteRule ^$ query.php [L,NC]
RewriteRule ^([a-zA-z]+)/$ query.php?first=$1 [L,NC]
RewriteRule ^([a-zA-z]+)/([a-zA-z]+)/$ query.php?first=$1&full=$2 [L,NC]

db.php:

< ?php
/**
 * taky php/mysql database class
 * designed to behave like codeigniter
 *
 * taky@takyhat.com
 *
 * Minor edits by osh/bhz
 * http://blackhatzen.com - zen@blackhatzen.com
 */
 
class db
{
	function __construct($host,$user,$pw,$db)
	{
		$conn = mysql_connect($host, $user, $pw) or die (mysql_error());
		mysql_select_db($db);
	}
 
	function fetch($table,$where=null,$like=null,$orderbyrand=null,$orderbyid=null,$limit=null)
	{
		$q = "SELECT * FROM ".$table;
 
		/**
		 * check for extras and modify the query
		 */
		if($where!=null)
		{
			$parts=explode('=',$where);
			$parts[1]='"'.$parts[1].'"';
 
			$where=$parts[0].'='.$parts[1];
			$q.=" WHERE ".$where;
		}
 
		if($like!=null)
		{
			$parts=explode('LIKE',$like);
			$parts[1]='"'.$parts[1].'"';
 
			$like=$parts[0].'LIKE'.$parts[1];
			$q.=" WHERE ".$like;
		}
 
		if($orderbyrand!=null)
		{
			$q.=" ORDER BY firstname";
		}
 
		if($orderbyid!=null)
		{
			$q.=" ORDER BY id desc";
		}
 
		if($limit!=null)
		{
			$q.=" LIMIT ".$limit;
		}
 
		/**
		 * return the array
		 */
		$result = mysql_query($q) or die(mysql_error());
 
		$return=array();
 
		while($row = mysql_fetch_array($result))
		{
			array_push($return,$row);
		}
 
		return($return);
	}
 
	function __destruct()
	{
		mysql_close();
	}
}
?>

query.php:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

< ?php
	include('db.php');
	$db=new db('localhost','db_user','db_pass','db_name');
	$user['first']=$_GET['first'];
	$user['full']=$_GET['full'];
 
	if(is_null($user['first']) == '1' && is_null($user['full']) == '1')
		{	
			echo '<a href="a/">a<br />';
			echo '<a href="b/">b</a><br />';
			echo '<a href="c/">c</a><br />';
		} elseif (isset($user['first']) && is_null($user['full']) == '1')
		{
			$rows=$db->fetch('info','','firstname LIKE'.$user['first'].'%');
			foreach($rows as $row)
				{
					echo '<a href="../'.$user['first'].'/' . $row['firstname'] . '/">' . $row['firstname'] . '</a><br />';
				}
		} elseif(isset($user['full'])){ 
		$rows=$db->fetch('info','firstname='.$user['full']);
		foreach($rows as $row)
			{
				echo($row['content']);
			}
		}
?>

The only changes you’ll have to make to get this working will involve changing line 3 of query.php:

$db=new db('localhost','db_user','db_pass','db_name');

You should replace localhost, db_user, db_pass, and db_name with your hostname, MySQL username, MySQL username’s password, and your MySQL DB’s name, respectively.

In the simplest terms, what the PHP code and RewriteRule’s do is grab strings passed along with the URL and use them to seed a MySQL query. So, when the user goes to http://www.domain.com/a/ they are forwarded to http://www.domain.com/query.php?first=a which in turn perform a MySQL query for ‘a%’ on the database table ‘info’ which results in the two records (Andy and Alan) to be displayed as links. When clicked, these links, formatted like http://www.domain.com/a/alan/, direct the user to http://www.domain.com/query.php?first=a&full=alan which displays the contents of the ‘content’ field for the ‘alan’ record on the ‘info’ table.

I just bought and started playing with Camtasia on a virtual machine install of XP, so here is a totally unnecessary and short video I made showing browser behavior:

Post a comment if you have any questions!

blackhatzen Wants Beta Testers!

We’re opening up a beta testing program so that we can fine tune our products for mass release with the help of members in the community. You’ll have exclusive access to our products earlier than anyone else and your comments and feedback will be integrated into a final blackhatzen product. You’ll receive a free copy of the final product at launch as well as accolades and respect from the people here at blackhatzen. Regardless of your level of experience, we are interested in hearing from you. Only a few individuals will be chosen for each new product, but we’ll be looking for both new and old marketers to help us.

Our goal is to have our first beta test up and operational by the end of this month.

Updates Galore

We’ve been really busy over the past few weeks helping all of those that bought Meta-Marketing: Volume 2 to get moving. Meta-Marketing: Volume 2 is still for sale, but we’ve increased the price dramatically and are interviewing everyone before they purchase. We’re doing this to protect the investments of our customers as well as ensure that these methods don’t get into the wrong hands.

We’ve been putting together a few new projects, one of which we’ll have some public updates on very soon. The offering in December that we decided to postpone is being reconfigured and redesigned to be an even more powerful and more cost effective money-making tool than it was when we began to develop it many months ago. We’ll be combining it with both new and old ideas to help our customers leverage their existing Internet traffic and marketing efforts.

The other project is turning into something much larger than we originally anticipated. We’re currently negotiating with one of the hottest brands in the black hat marketing/SEO business to create a one-of-a-kind training program to help both new and old users discover the full potential of a powerful tool many have left underutilized since day one. More on that soon.

We hope everyone is having a safe and profitable 2009!

Congratulations, khoahalabear!

As some of you who frequent BHW know, user khoahalabear recently won our essay contest by quite a few votes! He was awarded a free copy of Meta-Marketing: Volume 2 as well as a sneak peek at a future product.

The definition of black hat marketing, “Quite frankly, it means anything that is not honest including, but not limited to, tricking people into doing whatever the webmaster wants them to do,” taken from basictips.com. What does this mean to me exactly? Sure, I could just say that it allows me to make a huge sum of money effortlessly and let’s me “pwn” the white hat marketers who detest these methods, but that’s overly used and said by others; plus, and I’m certain you’ve heard it many times already. Instead, I’ve decided to let you take a peek at my life and how black hat has changed my outlook on life and what it really ultimately means to me on a personal level.

Now how would I go about saying this? You see, black hat has changed me into a completely new person, and I’m not just saying that. If I could word it any better, I would, because it sounds incredibly cliché. When someone looks at a way of reaching a goal, they don’t know there’s always a faster and easier way of achieving it. This may not be the most righteous way, but in order to use it you’re going to have to become a lot more tolerant and look at things outside of the box. I wouldn’t say it’s easier, or even shorter for that matter; it’s just a different way of looking at things. In taking this path I had to change how I reacted towards certain situations and figure out a way that wasn’t conventional, but would work just the same or much better. It’s a shortcut that isn’t really short, a means to an end that has no end. Whether you notice it or not, if you fully incorporate yourself in black hat you’re going to change in some way. It may or may not be readily noticeable, but whatever way you look at it, it’s an evolution.

Back when I dabbed in legitimate SEO and PPC Iooking for a way to make a few dollars here and there, I stumbled across a wonderful forum. Since then, Black Hat World has been my savior and angel. It allowed me to access depths of Internet Marketing I had never explored or even looked for in my whole career as a marketing individual. With this knowledge, I stomped the pests who sought to deter my money making process and increased my earnings ten-fold. For that, I am forever thankful and in the debt of the place we can all call home, Black Hat World.

At this point however, I’ll have to bid you adieu. I have much to learn and a large investment in a project that I’m sure will repay itself many times over. Of course, you all know that this method is neither legitimate nor ethical, still, if you have read up to this part I’m sure you could care less. In any case, before I leave I’d like to offer you one piece of advice: Stick to no more than two projects and follow them through until you either see a return or fail miserably! You’re a Black Hatter, build on what I’ve just told you and use this for your own accomplishments in life. I’d like to see this forum grow and eventually rule this world. After all, we’re all capable of being cunning, adapt and succeed…we are Black Hat!

As per the contest, khoahalabear has asked me to post a link of his choosing. So, here it is: Black Hat – Buy Sell Trade

yeti_racer, aliskorn, flow, lizmoz, giantsfan0806, rudyvise, Jagged55 also contributed fantastic essays and we’d like to thank them as well!

We hope everyone had a fun, safe holiday and wish you all success in 2009!

Happy New Year!

We’d just like to wish everyone of our readers and customers a very happy 2009! We hope that you’ve enjoyed our offerings over the last 8 months and continue to come back and support what we’re doing here. We have much more in store for 2009.

As a special thank you for all of your support in 2008, we’d like to offer a 2009 coupon for our newest Meta-Marketing offering. If you enter the coupon NYE when you are ordering, you’ll receive $150.00 the original price and be able to purchase for only $200!

Please contact us if you have any questions!

More Meta-Marketing: Volume 2 Reviews!

Good reviews continue to pour in about our newest product, Meta-Marketing: Volume 2!

From Scubaslick:

Another absolute winner Oldenstylehats. Bravo.

This is the same kind of “screw the box, I’m thinking outside the rhombus” method that you always deliver. Let the market be your guide, find the hype that others have spent sooooo much time and money building, then ride the wave of cash.

From Genjutsu:

13 pages, remove the title page and the disclaimer and your left with 11 pages of content. I printed it out and sat through and read it a few times over. Not because I didnt understand it on the first read, but because I wanted to see how much more information I could extract from the 11 pages. It seemed all too simple. There was alot of information for such a small ebook. It was written clearly and provides you with just enough to get started and earning in any niche. There is no programming or scripts included. This is just an old fashion method that requires some manual labor. You can outsource all of this if you wish (i think unlimited mentioned that). Also, it should be noted that this method comes with its own traffic. You dont have to worry about getting that yourself. I believe that is the true beauty of this method. Anyone can start earning money almost immediately.

From graphicnut:

I was lucky enough to get hold of this and even before i bought it i knew oldenstylehats would not let me down!
I will say it short and sweet, WELL worth the price tag, great support and a little discussion in the forum where you can pick up alot more ideas for the method. My mind is running wild with what you can do with it.

Thanks again Olden, another great method!!

From gts6:

this is a great method for anyone to use to make money. you really dont need any technical skills at all to pull this off.

it can also be done in a white hat manner as well for those that are not wanting to do blackhat things. And many people after reading this method will think of many other ideas to use with the basic ideas presented here.

the only way to screw this up, is to wait too long to jump on this offer

From MontyzPython:

Hey, this is very nice OSH. This is a great example of ‘thinking outside the box’. I can see this being quite lucrative for those who decide to purchase.