Webmaster Sucks Here I share stuff I used to suck at as a novice webmaster..

• Home
• About

Signing a Windows Programs

I wrote a program, but lots of virus program giving alerts and i learn i have to sign my programs with "code signing". There is lots alternative for code signing, i choice Verisign. There is some steps for signing.

Getting Signature

1. Buy a code signin certificate. Whole list > (You can also create test certificates using makecert.exe.)
2. User Certificate Manager (certmgr.exe) The Certificate Manager is also used to import and export certificates.
3. You get some files from CA (Verisign etc.) Save as abc.cer and abc.spc, after we will conver that files to .pfx
4. command prompt ;
   cert2spc xyz.cer xyz.spc
   pvk2pfx -pvk abc.pvk -pi pvkpassword -spc abc.spc -pfx pfxfilename -po pfxpassword -f
5. Finally, import your file to certificate store.
6. After we can sign our programs.

Signing program

1. You can use wizard but it doesnt work in Win8
   Command prompt: signtool signwizard
2. Another option;
   signtool sign /yourfile.exe
3. Dont forget to add timestamp for sign
   signtool timestamp -t timestamp.verisign.com/scripts/timstamp.dll yourfile.exe

Here is more details;

• www.kinook.com/blog/?p=10
• www.digicert.com/code-signing/signcode-signtool-command-line.htm
• www.sslshopper.com/what-is-code-signing.html
• blog.didierstevens.com/2008/12/31/howto-add-a-digital-signature-to-executables/

Sort VARCHAR as INT in MySQL

Sometimes we can user VARCHAR for integer values. But when we need sort them, we have got big problem. Because VARCHAR's are string and it is sorting like a string.

Example:

1a 2a 3a 10b 20b 30b 15c 25c 35c (VARCHAR)

1a 10b 15c 2a 20b 25c 3a 30b 35c (Sorted)

We need

1a 2a 3a 10b 15c 20b 25c 30b 35c (Sorted integer)

We can do it with mysql CAST

SELECT vNumber FROM table ORDER BY CAST(`vNumber` AS SIGNED)

Reverse order

SELECT vNumber FROM table ORDER BY CAST(`vNumber` AS SIGNED) DESC

Other possible conversion types you may need are:

• BINARY[(N)]
• CHAR[(N)]
• DATE
• DATETIME
• DECIMAL[(M[,D])]
• SIGNED [INTEGER]
• TIME
• UNSIGNED [INTEGER]

You can find more about CAST -> MySQL docs here.

Recursive Category Listing

Webmasters allways use category trees, i wrote a function about creating category trees with using recursive function.

<?php
header('Content-Type: text/html; charset=UTF-8');

include($_SERVER['DOCUMENT_ROOT']."/mysql.inc.php");

function categories($firstCategory,$node)
{
	$kQ = mysql_query("SELECT * FROM categories WHERE category= ".$firstCategory);
	if(mysql_num_rows($kQ) > 0)
	{
		echo(str_repeat("\t",$node+1)."<ul>\n");
		$node++;
		while($k = mysql_fetch_array($kQ))
		{
			//str_repeat is for "view source" format, we set TAB character for readable HTML
			echo(str_repeat("\t",$node)."<li>".($node+1)." ".$k["name"]."</li>\n");

			// Recursive, call function it self
			categories($k["id"], $node);
		}
		echo(str_repeat("\t",$node)."</ul>\n");
	}
}
categories(0,-1);
?>

Output :

• Food
  • Fruits
    • Apple
    • Banana
  • Vegetables
    • Tomatoes
    • Aborgin
• Drinks
  • Soft
    • Fruit Juice
      • Apple Juice
      • Strawberry Juice
    • Milk

1. Resizing image with Php by Simon Jarvis
2. Directory Listing by Spoono

<?
/*
* Class: SimpleImage, Author: Simon Jarvis, Copyright: 2006 Simon Jarvis, Date: 08/11/06
* Link: www.white-hat-web-design.co.uk/articles/php-image-resizing.php
* See the GNU General Public License for more details: www.gnu.org/licenses/gpl.html
*/

class SimpleImage {
   var $image;
   var $image_type;

   function load($filename) {
      $image_info = getimagesize($filename);
      $this->image_type = $image_info[2];
      if( $this->image_type == IMAGETYPE_JPEG ) {
         $this->image = imagecreatefromjpeg($filename);
      } elseif( $this->image_type == IMAGETYPE_GIF ) {
         $this->image = imagecreatefromgif($filename);
      } elseif( $this->image_type == IMAGETYPE_PNG ) {
         $this->image = imagecreatefrompng($filename);
      }
   }
   function save($filename, $image_type=IMAGETYPE_JPEG, $compression=75, $permissions=null) {
      if( $image_type == IMAGETYPE_JPEG ) {
         imagejpeg($this->image,$filename,$compression);
      } elseif( $image_type == IMAGETYPE_GIF ) {
         imagegif($this->image,$filename);
      } elseif( $image_type == IMAGETYPE_PNG ) {
         imagepng($this->image,$filename);
      }
      if( $permissions != null) {
         chmod($filename,$permissions);
      }
   }
   function output($image_type=IMAGETYPE_JPEG) {
      if( $image_type == IMAGETYPE_JPEG ) {
         imagejpeg($this->image);
      } elseif( $image_type == IMAGETYPE_GIF ) {
         imagegif($this->image);
      } elseif( $image_type == IMAGETYPE_PNG ) {
         imagepng($this->image);
      }
   }
   function getWidth() {
      return imagesx($this->image);
   }
   function getHeight() {
      return imagesy($this->image);
   }
   function resizeToHeight($height) {
      $ratio = $height / $this->getHeight();
      $width = $this->getWidth() * $ratio;
      $this->resize($width,$height);
   }
   function resizeToWidth($width) {
      $ratio = $width / $this->getWidth();
      $height = $this->getheight() * $ratio;
      $this->resize($width,$height);
   }
   function scale($scale) {
      $width = $this->getWidth() * $scale/100;
      $height = $this->getheight() * $scale/100;
      $this->resize($width,$height);
   }
   function resize($width,$height) {
      $new_image = imagecreatetruecolor($width, $height);
      imagecopyresampled($new_image, $this->image, 0, 0, 0, 0, $width, $height, $this->getWidth(), $this->getHeight());
      $this->image = $new_image;
   }
}
// End of SimpleImage class

/* Directory Listing
Source : www.spoono.com/php/tutorials/tutorial.php?id=10
*/

// Define the path as relative
$path = "/home/site/public_html/images/";

// Using the opendir function
$dir_handle = @opendir($path) or die("ERROR: Cannot open  <b>$path</b>");

echo("Directory Listing of $path<br/>");

//running the while loop
while ($file = readdir($dir_handle))
{
   if($file != "." && $file != "..")
   {
	$image = new SimpleImage();
	$image->load("images/".$file);
	$image->resize(80,60);
	$image->save("images2/mini_".$file);
	echo("• $file <br>");
   }
}

//closing the directory
closedir($dir_handle);
?>