Mysql Crash Fixing

Mysql Crash Fixing
Hi there,

somehow I crashed a certain mysql crash by incident when doing “delete from table where id > 30” when I meant to write “delete from table where id < 30”. So to say I deleted all rows I didn´t mean to delete. Now your job would be to fix that. I still have the .myd file and the .frm file of that table and as far as I can tell all the data is still in .myd file but somehow I can´t get it into the table again the way it´s usable again.

I so far tried already to fix with myisamchk but with no success.

This needs to be done fast, so please only bid, if you are sure you can fix that.

WordPress Autoresponder Plugin

WordPress Autoresponder Plugin
Need someone to do a wordpress plugin.

It’s wordpress auto responder that is built on top of wordpress.
I want features similar to http://freeautoresponder.biz

There will be two version the free and paid versions.

Additional Features I want in the plugin
– File Attachment Extension
– Broadcast (by) Date Extension
– List Cleaning Extension
– Link Tracking – Cloaking
– Detail log charts just like Aweber showing the clicks for each broadcast and know who open it.

Here are the main features it should have below, I have the wordpress plugin with me already… so you guys dont have to work from scratch
but it must have a total different layout and file names and codes ..

Fully Integrated with WordPress.

Double Opt-In Subscription Process.

IMPORT, EXPORT, & COPY. <= Only With Pro Version

Subscription Form Widgets.

Compose & Send Messages in HTML.

Mass-Mailer Messaging System.

Stores the IP & Time of Confirmation.

CAPTCHA Submission Verification. <= Only With Pro Version

Capture More Info from Subscribers. <= Only With Pro Version

Create MULTIPLE Autoresponder Lists. <= Only With Pro Version

Schedule a Year of Daily Messages. <= Only With Pro Version

Intelligent Automated Mail-Queue. <= Only With Pro Version

Mail Logs available for export. <= Only With Pro Version

Auto Unsubscribe Link and Footer.

Multi-Port SMTP Mailer or local mail(). <= Only With Pro Version

External Results Pages for each step.

Subscription Form TinyMCE HTML Editor

Create Buttons And Images

Create Buttons And Images
I bought a WordPress theme and find that several of its images – button, header, text items – need to be changed to fit my business.

This is an easy project for someone who is familiar with graphic software (e.g., Photoshop or Elements).

You can see the theme I’m talking about at

http://themeforest.net/item/newsense-clean-business-wordpress-theme/full_screen_preview/57897

Basically, I need 30 images – one set of 15 displaying text I will supply and one set of 15 with no text – just blank (text-less) images. Note that while there are only 5 graphics listed below, they must each be prepared in 3 different colors.

I have the original images and can send them to you. What I need back is new graphics and text for

1. The logo “Newsense”
2. The subtitle “The best design company”

3. The unified graphic that contains the text “Fresh and Professional” and “Solutions for You and Your Company”

4. and 5. And the buttons that now say “View Our Services” and “Take a Tour”

I will supply the text for all of the above and would like to have replacement images (with my next text) for each of the above items in EACH of the themes three colors.

Also, I would like to have a separate set of background images so that in the future I could more easily apply the text I want on my own.

So, the deliverable is items 1-5 with next text in each of the three colors for a total of 15 images.

AND, items 1-5 with NO text – just blank buttons and images – in each of the three colors – for a total of 15 images.

The bottom line is that I should be getting 30 images – 15 with text that I will supply you and 15 that are blank (so I can supply next text later).

You should use fonts that are the same or very similar to the fonts in the original images and you should match as closely as possible the colors of the images.

If you have samples of work you’ve done that is similar to this, could you provide a URL where they appear?

Could you also provide an estimate of when this could be completed (e.g., “x” hours or “x” days after I send you the text to be applied.

I can send you the images I now have from the basic theme. You will probably need these to determine exact color, image size and font style.

Thanks.

Php-fusion Theme & Custom Mod

Php-fusion Theme & Custom Mod
Hello everyone,

I this is a two part project;

Part one:
I need a Web 2.0 gaming theme made for Php-Fusion 7.x.x.
It is for a new gaming league & tournament company, so the theme must be designed as such.

Part two:
I need a custom made mod for Php-Fusion 7.x.x.
This mod will allow the admin to make Squads for Games:
Allow admin to make games in the game category, will also allow to upload a icon for that game.
Allow admin to make a squad for a game that has been created in the game category.
Allow the admin/members of that Squad to upload Squad Banner/Player Images.
Allow the admin/members of that Squad to add/change Squad Info text.
Allow the members to vote to “kick” a Squad member with reason, the vote then will be sent to admin.
Allow the admin to setup game times for Squads to battle, Squads will be battling other Squads from that game category.
Allow the admin to input final game stats, (such as Points, Game Time, Map, Kills, Deaths, ect.)
Will need a side box made to display Game Times, What Squads are playing, Wins/Loses.
Squads will have a profile page displaying Past Games, Wins/Loses, Stats, Next Games, Squad Info, Images, Squad Banner.

I’m other things will be added.

Website Subdomain Script

Website Subdomain Script
I want to give all members of my website a unique url for easy navigation with the format: username.sitedomain.com
(Please Note:This is an example, my website is not sitedomain.com)

I already have the website(built with PHP and MYSQL), the only aspect I require work on is the subdomain name script. My website has the initial standard steps where members fill in a form for registration where they would enter their username.
As of the moment after their registration their profile page becomes
www. sitedomain. com / index.php?user=username

But I want to change this to now become
username.sitedomain.com
without having to create a physical subdomain directory on the server.

when members visit a subdomain (Example subdomain.domain.com) I DON’T want them to be redirected anywhere. At the moment the user profile page link is in the format
www. sitedomain. com / index.php?user=username

So the site would display their membership profile any time their profile page is visited. What I require is for the user profile page to show using the link format
username.sitedomain.com

Not to Re-direct them anywhere,

If you take a look at wordpress, wordpress is a membership site where every user has their own personal subdomain name which displays the users profile page

vonwoof.wordpress.com
subdomain owned by the person with the username vonwoof

superrobotwar.wordpress.com
subdomain owned by the person with the username superrobotwar and it points to the persons profile page

otakuartist.wordpress.com
subdomain owned by the person with the username otakuartist

Bid reasonably. I am looking for a low cost developer to handle the work

Please give me examples of existing websites You have built a “SUBDOMAIN script” for, (I don’t need to see your entire portfolio) and also a brief explanation of your solution (showing you understand what I require)

How to Create an Infinite Scroll Web Gallery

How to Create an Infinite Scroll Web Gallery

When working my way through a web gallery, I find it annoying when I must change pages; so in today’s tutorial, we will learn how to create an auto-generating, one-page, infinite scrolling gallery with PHP and AJAX. Let’s get started!


Step 1: Project Outline

We’ll begin with a normal gallery page that has a container for our images, and we’ll monitor the scroll position by calling a JavaScript function at a quick interval. Each time the scroll bar is near the bottom, we’ll make an AJAX request to an external PHP file, which returns a list of image names. Now, all we’ll need to do is add these images to our container, thus modifying the page height moving the scroll position higher.


Step 2: HTML Markup

We’ll work with a very basic setup: a header and the container for our images. The thumbnails will be grouped in sets of three rows, each will contain a link, referencing the full size image. After each group, we will add some text showing the total number of displayed images, and a link to the top of the page.

<body>
	<div id="header">Web Gallery | Infinite Scroll</div>
	<div id="container">
		<a href="img/Achievements.jpg"><img src="thumb/Achievements.jpg" /></a>
		<a href="img/Bw.jpg"><img src="thumb/Bw.jpg" /></a>
		<a href="img/Camera.jpg"><img src="thumb/Camera.jpg" /></a>
		<a href="img/Cat-Dog.jpg"><img src="thumb/Cat-Dog.jpg" /></a>
		<a href="img/CREATIV.jpg"><img src="thumb/CREATIV.jpg" /></a>
		<a href="img/creativ2.jpg"><img src="thumb/creativ2.jpg" /></a>
		<a href="img/Earth.jpg"><img src="thumb/Earth.jpg" /></a>
		<a href="img/Endless.jpg"><img src="thumb/Endless.jpg" /></a>
		<a href="img/EndlesSlights.jpg"><img src="thumb/EndlesSlights.jpg" /></a>    

		<p>9 Images Displayed | <a href="#header">top</a></p>
	    <hr />
	</div>
</body>

Step 3: CSS

The CSS is also quite basic. First, we define the page colors and positioning for the header and paragraphs.

body{
	background:#222;
	color:#666;
}
#header{
	font-family:Arial, Helvetica, sans-serif;
	font-size:24px;
	font-weight:bold;
	text-align:left;
	text-indent:35px;
	margin: 0 auto;
	width:800px;
	margin-bottom:10px;
}
hr{
	margin: 20px;
	border:none;
	border-top: 1px solid #111;
	border-bottom: 1px solid #333;
}
p{
	color:#444;
	text-align:left;
	font-size:10px;
	margin-left: 20px;
	margin-bottom: -10px;
}
a{
	color:#444;
}

Step 4

Then, for the container and images, I used a bit of CSS3 to add round corners and shadows. Don’t forget "-moz-box-shadow" and "-moz-border-radius" for Firefox and "-webkit-box-shadow" and "-webkit-border-radius" for Chrome and Safari.

#container{
	margin: 0 auto;
	width:800px;
	border:1px solid #333;
	-moz-border-radius: 10px;
	-webkit-border-radius: 10px;
	font-family:Verdana, Geneva, sans-serif;
	text-align:center;
}
img{
	border:10px solid #444;
	-moz-border-radius: 5px;
	-webkit-border-radius: 10px;
	margin: 15px;
}
img:hover{
	border-color:#555;
	-moz-box-shadow: 0px 0px 15px #111;
	-webkit-box-shadow: 0px 0px 15px #111;
}

Step 5: PHP Script

This is going to be very short. We need to call the PHP script with the index of the next image we need as a parameter. First of all, we have to retrieve all the available image names from a directory and save them into an array. I organized my images in two folders: "thumb" and "img" which contain the thumbnails and actual images, respectively. Note that the thumbnails must have the exact same name as their corresponding full size images.

<?php

$dir = "thumb";
if(is_dir($dir)){
	if($dd = opendir($dir)){
		while (($f = readdir($dd)) !== false)
			if($f != "." && $f != "..")
				$files[] = $f;
	closedir($dd);
	} 

We define a variable for the directory we want to get the image names from, test if it exists, and if we can open it, read all the file names from it. When reading an entire folder, we will always get two extra elements we may not want: "." – this stands for the current directory, and ".." – this stands for the parent directory. To compensate, we have to test if the element read is different from these two, then we can safely add it to our array.

$files[] = $f;

As a note, when adding an element to an array and not specifying the position to be placed in, it will always push the element to the end of the array.


Step 6

Now we have to build our response text. We are going to send back to the JavaScript a single string containing all the necessary file names separated by a semi-colon.

	$n = $_GET["n"];
	$response = "";

We get the URL parameter for the index of the next image we need, and we initialize our response text.

	for($i = $n; $i<$n+9; $i++)
		$response = $response.$files[$i%count($files)].';';
	echo $response;
}
?>

As I said before, the images will be grouped in sets of three rows, each containing three images, so we only need nine images to return the file names for a group. We start at the index we got as parameter, $n, and go until $n+9. At each increment, we add our image name followed by ";" to the response text. Here is a little tricky part. We won’t have an infinite number of images; so in order to create the effect of an "infinite" gallery which never ends, each time the index of the next image is greater that the total number of images, we must start over from the beginning. This is done by applying the "modulo" or "%" function between the index and the total number of images.

	$i%count($files)

As a result, we get the remainder of the division between these two elements. For example, if the index "$i" is "50" and the number of images "count($files)" is "45" the result will be "5". As well, if "$i" is "50" and "count($files)" is "65", the result will be "50". Finally, we have to send back our response text.


Step 7

Here is the complete PHP script. Just place your completed code within a new .php file.

<?php

	$dir = "thumb";
	if(is_dir($dir)){
		if($dd = opendir($dir)){
			while (($f = readdir($dd)) !== false)
				if($f != "." && $f != "..")
					$files[] = $f;
			closedir($dd);
		} 

	$n = $_GET["n"];
	$response = "";
		for($i = $n; $i<$n+9; $i++){
			$response = $response.$files[$i%count($files)].';';
		}
		echo $response;
	}
?>

Step 8: JavaScript

As usual, first we define some variables we will need later on.

var contentHeight = 800;
var pageHeight = document.documentElement.clientHeight;
var scrollPosition;
var n = 10;
var xmlhttp;

In order to determine weather the scroll bar is near the bottom of the page, we need three variables:

  • "contentHeight" – the height of the initial gallery
  • "pageHeight" – the height of the visible page in the browser
  • "scrollPosition" – the position of the scroll bar measured from the top

Lastly, we need a variable for the next image index (which we are going to send to the PHP script), and a variable for the Ajax request object.


Step 9

We need to define a function that will add the images to our HTML container.

function putImages(){
	if (xmlhttp.readyState==4){
    	if(xmlhttp.responseText){

A request object goes through different states as the request is made, each of which has a numerical value associated. The one we are interested in is the final state, when the request is complete and the value is "4". We first test if the request is in this state, and then check to see if we received a response.


Step 10

If both conditions are fulfilled, we have to tokenize the response text. This means we have to separate the file names into an array. Remember that in the PHP script we returned a single string with the names separated by semi-colons. Here is an example: Achievements.jpg;Bw.jpg;Camera.jpg;Cat-Dog.jpg;CREATIV.jpg;creativ2.jpg;Earth.jpg;Endless.jpg;EndlesSlights.jpg;

var resp = xmlhttp.responseText.replace("\r\n", "");
var files = resp.split(";");

There is a bit of a problem we have to deal with first; the response text may have at the beginning a new line character which we do not want. This is easily fixed with the "replace" function, that takes two parameters: "\r\n" – the new line character, and "" – empty string that will replace all occurrences of the first parameter. Now all we have to do is to split the string by our delimiter ";".


Step 11

Next, we have to add the images to our container.

            var j = 0;
            for(i=0; i<files.length; i++){
                if(files[i] != ""){
                    document.getElementById("container").innerHTML += '<a href="img/'+files[i]+'"><img src="thumb/'+files[i]+'" /></a>';
                    j++;

                    if(j == 3 || j == 6)
                        document.getElementById("container").innerHTML += '';
                    else if(j == 9){
                        document.getElementById("container").innerHTML += '<p>'+(n-1)+" Images Displayed | <a href='#header'>top</a></p><hr />";
                        j = 0;
                    }
                }
            }

For every element in our array, we check if it isn’t an empty string, and add the thumbnail with the link on it. We have to keep a counter "j" in order to separate the images in rows. After every third and sixth thumbnail added, we create a new line, and after nine thumbnails added we put the text showing the total number of displayed images and a link to the top of the page.


Step 12

Here is the complete function.

function putImages(){
	if (xmlhttp.readyState==4){
    	if(xmlhttp.responseText){
			var resp = xmlhttp.responseText.replace("\r\n", "");
			var files = resp.split(";");

            var j = 0;
            for(i=0; i<files.length; i++){
                if(files[i] != ""){
                    document.getElementById("container").innerHTML += '<a href="img/'+files[i]+'"><img src="thumb/'+files[i]+'" /></a>';

                    j++;
                    if(j == 3 || j == 6)
                        document.getElementById("container").innerHTML += '';
                    else if(j == 9){
                        document.getElementById("container").innerHTML += '<p>'+(n-1)+" Images Displayed | <a href='#header'>top</a></p><hr />";
                        j = 0;
                    }
                }
            }
		}
	}
}

Step 13

Now we are going to define the function that will check if the scroll position is getting near the bottom, and makes the request to the server.

function scroll(){

	if(navigator.appName == "Microsoft Internet Explorer")
		scrollPosition = document.documentElement.scrollTop;
	else
		scrollPosition = window.pageYOffset;

First, we have to find the position of the scroll bar. Internet Explorer does this a bit differently, so we have to determine what browser the client is using, then just store the value in the variable we defined earlier.


Step 14

	if((contentHeight - pageHeight - scrollPosition) < 500){

Now we check to see if we are about to reach the end of our gallery – if the part of the page visible in the browser is below the bottom 500px of the entire page. This isn’t an exact value, you may use a different one if you find it suitable. If this condition is true, we can continue on and add new images.


Step 15: Creating the XMLHttpRequest Object

We are ready to make the XMLHttpRequest object and send it. Again, for Internet Explorer the definition is a bit different, so we must compensate for this as well.

	if(window.XMLHttpRequest)
			//Firefox, Opera, Safari
			xmlhttp = new XMLHttpRequest();
		else
			if(window.ActiveXObject)
            	//Internet Explorer
				xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
			else
				alert ("Bummer! Your browser does not support XMLHTTP!");

Step 16

Before sending the request, we have to specify the PHP script name on the server and insert the parameters we want to give it.

	var url="getImages.php?n="+n;

This is a simple text variable representing the URL of the page.


Step 17

It’s time to send the request.

		xmlhttp.open("GET",url,true);
		xmlhttp.send();

The URL is set by calling the "open" method. The second parameter is the important one, this being the script’s URL. After doing so, all we need is to send it. This will run the PHP script and put in "xmlhttp.responseText" the return value of it.


Step 18

The final step is to place the new content on the page by calling the function we defined earlier "putImages" and to prepare our variables for the next request.

		n += 9;
		contentHeight += 800;
		xmlhttp.onreadystatechange = putImages;
	}
}

We have nine new images in the gallery, so we increment "n" with 9, and we need to change the page height; so increment "contentHeight" with 800.


Step 19

Here is the entire JavaScript we’ve used.

<script>
var contentHeight = 800;
var pageHeight = document.documentElement.clientHeight;
var scrollPosition;
var n = 10;
var xmlhttp;

function putImages(){

	if (xmlhttp.readyState==4)
	  {
		  if(xmlhttp.responseText){
			 var resp = xmlhttp.responseText.replace("\r\n", "");
			 var files = resp.split(";");
			  var j = 0;
			  for(i=0; i<files.length; i++){
				  if(files[i] != ""){
					 document.getElementById("container").innerHTML += '<a href="img/'+files[i]+'"><img src="thumb/'+files[i]+'" /></a>';
					 j++;

					 if(j == 3 || j == 6)
						  document.getElementById("container").innerHTML += '';
					  else if(j == 9){
						  document.getElementById("container").innerHTML += '<p>'+(n-1)+" Images Displayed | <a href='#header'>top</a></p><hr />";
						  j = 0;
					  }
				  }
			  }
		  }
	  }
}

function scroll(){

	if(navigator.appName == "Microsoft Internet Explorer")
		scrollPosition = document.documentElement.scrollTop;
	else
		scrollPosition = window.pageYOffset;		

	if((contentHeight - pageHeight - scrollPosition) < 500){

		if(window.XMLHttpRequest)
			xmlhttp = new XMLHttpRequest();
		else
			if(window.ActiveXObject)
				xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
			else
				alert ("Bummer! Your browser does not support XMLHTTP!");		  

		var url="getImages.php?n="+n;

		xmlhttp.open("GET",url,true);
		xmlhttp.send();

		n += 9;
		xmlhttp.onreadystatechange=putImages;
		contentHeight += 800;
	}
}



Step 20

The final thing that we must do is run the JavaScript at a specified interval.

<body onload="setInterval('scroll();', 250);">

Just set up the "onload" property of the "body" tag, and set its value to the "setInterval" function. This will run the "scroll" function every quarter of a second. Again, you may change this time value, but I found that it’s optimal for what we need.


Finished!

We are done! I hope you found this tutorial to be of help and useful. Please leave a message in the comment section below, should you need further assistance or advice.



Adult Site Seo/link Building

Adult Site Seo/link Building
Post to adult forums or blogs with a link back to one of our 20 sites.

Post 20 relevant posts in adult forums or blogs with a linkback to one of our sites. This needs to be repeted for each of our 20 sites. So in total you will be doing 400 posts.

– Each post must be unique and not posted together with another post;
– Comments must be relevant to blog or forum subject and demonstrate that you read the ongoing discussion;
– Each posting must be from a different Username and must have different content;
– Minimum 35-40 words of original and quality writing per posting
– URL Link to our website must be inserted in each posting and be active.
– Your posts have to be with SEO in mind.
– No nofollow links.
– Links must be permanent for at least 3 months after posting, final payment will be made after 3 month.

We will provide you with a list of the sites and 5 different anchors for each site to be used.

Once you post 400 posts, you will provide us with a report.

Need Great Coder For Clone

Need Great Coder For Clone
I’m looking for coder to clone one website.

Requirments:
* Full OO-PHP
* Optimized MySQL
* Fast delivery
* CodeIgniter or KohanaPHP framework used

Important notes:
* You’re required to provide reallty GOOD quality, commented code
* Poor code = no payment, great code=long term cooperation possible
* You MUST use MVC design pattern

Front end can be cloned “as it is”, without any changes. For interested programmers link will be given within PMB.

Any questions? PM me.

Webform For Flash Video

Webform For Flash Video
This should be a really easy project for a flash developer.

We’re looking to create an optin webform that appears when
the user plays a video. See example here:

http://tinyurl.com/yzzdvpt (top right video)

When the user presses play an opt-in form appears over the video.

We need the flash video to do the same as above. The opt-in
webform appears when the user plays the video.

Because we will be using our Aweber webforms, we need to embed
a query from the url into the flash webform.

Ex: http://website.com?10393
Embed into webform:
<input type=”hidden” value=”10393″ />

That should do it.

We’re looking for an easy solution to create these often without
having to use a flash person each and every time.

Thanks.