tag:blogger.com,1999:blog-86533916371213645862024-02-19T16:39:40.717+04:00TRUE searchesim sajin, working in Dubai, as php web developer, developing a dubai geek networks.Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.comBlogger37125tag:blogger.com,1999:blog-8653391637121364586.post-13318480813559224522017-07-07T14:59:00.001+04:002017-07-07T14:59:17.048+04:00smtp mail using phpmailer and zoho<div dir="ltr" style="text-align: left;" trbidi="on">
<?php<br />
<br />
require_once('class.phpmailer.php');<br />
$mail = new PHPMailer();<br />
$mail->IsSMTP();<br />
$mail->SMTPDebug = 3;<br />
$mail->SMTPAuth = true;<br />
$mail->Host = "smtp.zoho.com";<br />
$mail->Port = 465;<br />
$mail->SMTPSecure = 'ssl';<br />
$mail->Username = "fullmail@domain.com";<br />
$mail->Password = "12345678";<br />
<br />
<br />
$mail->SetFrom('fullmail@domain.com', 'Web App');<br />
$mail->Subject = "A Transactional Email From Web App";<br />
$mail->MsgHTML('test');<br />
$mail->AddAddress('fullemail', 'name');<br />
if(!$mail->send()) {<br />
echo 'Message could not be sent.';<br />
echo 'Mailer Error: ' . $mail->ErrorInfo;<br />
} else {<br />
echo 'Message has been sent';<br />
}</div>
Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-27866838343709688092015-12-04T10:17:00.002+04:002015-12-04T10:17:03.170+04:00importing parent stylesheet in child theme css<div dir="ltr" style="text-align: left;" trbidi="on">
@import url("../Parallax-One/style.css");</div>
Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-35230319670737940422015-08-17T17:17:00.001+04:002015-12-17T15:00:45.543+04:00Usefull linux commands <div dir="ltr" style="text-align: left;" trbidi="on">
<div style="color: #222222; font-family: Raleway, HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: 300; letter-spacing: -0.1rem; line-height: 1.2; margin: 0px 0px 2rem; text-align: center;">
Recursively Zip a Directory and Files on Linux</div>
<br />
<pre style="background-color: #eeeeee; border: 0px; color: #222222; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;">zip -r filename.zip /path/to/folder</code></pre>
<pre style="background-color: #eeeeee; border: 0px; color: #222222; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;">to unzip to current directory,
unzip file.zip -d .</code></pre>
<pre style="background-color: #eeeeee; border: 0px; color: #222222; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; margin: 0px; padding: 0px; white-space: inherit;"><span style="color: #222222; font-family: consolas, menlo, monaco, lucida console, liberation mono, dejavu sans mono, bitstream vera sans mono, courier new, monospace, sans-serif;">To get the size of directory
du -sh dirname </span></code></pre>
</div>
Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-57038648442332767192014-12-22T16:29:00.003+04:002014-12-22T16:29:50.797+04:00A quick way to generate lorelm ipsum text<div dir="ltr" style="text-align: left;" trbidi="on">
I created a small application using appspot to generate lorelm ipsum text quickly and add free one.<br />
<br />
<a href="http://quicklorem.appspot.com/">http://quicklorem.appspot.com/</a><br />
<br />
I think i will explain you how i created and it will be helpful for others to learn appospot's initials.<br />
<br /></div>
Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-47483176834259502562014-07-24T21:06:00.000+04:002014-07-24T21:06:06.655+04:00creating custom fields in edit list for wordpress<div dir="ltr" style="text-align: left;" trbidi="on">
Here is a good tutorial for custom quick edit option on wordpress<br />
<a href="http://wpdreamer.com/2012/03/manage-wordpress-posts-using-bulk-edit-and-quick-edit/?r=1">http://wpdreamer.com/2012/03/manage-wordpress-posts-using-bulk-edit-and-quick-edit/?r=1</a></div>
Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-23027553768952280762013-01-25T10:12:00.002+04:002013-01-25T15:11:32.479+04:00slow ssh connection on ubuntu <div dir="ltr" style="text-align: left;" trbidi="on">
Simply edit <em style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">sshd_config</em><span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px;"> by typing</span><br />
<span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px;"><br /></span>
<div style="text-align: left;">
>> sudo vim /etc/ssh/sshd_config</div>
<br />
Add the line to the bottom of file<br />
<span style="background-color: white; color: #373737; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 13px;"><br /></span>
<span style="background-color: white; color: #373737; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 13px;">UseDNS no</span><br />
<span style="background-color: white; color: #373737; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 13px;"><br /></span>
<span style="background-color: white; color: #373737; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 13px;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnWaF1sUFt_tNQdYZmS783AfEokcmO7du_c1Kj3b4wKQuYBmPxiaT1bU5fVSFOoLVErbftuq-AVcI4ewQWLuiI89kFLEHTu-nQL0dMgcIqM9cZW2R-6nCuqEZbF9pVFufM2ZniqkLLHFxK/s1600/sslow-ssh-login-fix-ubuntu.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="401" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnWaF1sUFt_tNQdYZmS783AfEokcmO7du_c1Kj3b4wKQuYBmPxiaT1bU5fVSFOoLVErbftuq-AVcI4ewQWLuiI89kFLEHTu-nQL0dMgcIqM9cZW2R-6nCuqEZbF9pVFufM2ZniqkLLHFxK/s640/sslow-ssh-login-fix-ubuntu.png" width="640" /></a></div>
<span style="background-color: white; color: #373737; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 13px;"><br /></span>
<span style="background-color: white; color: #373737; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 13px;">Restart the ssh service</span><br />
<span style="background-color: white; color: #373737; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 13px;"><br /></span>
<span style="background-color: white;"></span><br />
<span style="color: #373737; font-family: Monaco, Consolas, Andale Mono, DejaVu Sans Mono, monospace; font-size: x-small;">>> sudo service ssh reload</span><br />
<span style="color: #373737; font-family: Monaco, Consolas, Andale Mono, DejaVu Sans Mono, monospace; font-size: x-small;"><br /></span>
<span style="color: #373737; font-family: Monaco, Consolas, Andale Mono, DejaVu Sans Mono, monospace; font-size: x-small;">After this it will not delay for ssh login.</span><br />
<div style="color: #373737; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 13px;">
<br /></div>
</div>
Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-20895609953941314972012-07-31T20:44:00.002+04:002012-07-31T20:44:16.525+04:00Batman dark night rises theme pack for windows<div dir="ltr" style="text-align: left;" trbidi="on">
Please download the themepack from here.<br />
<a href="https://docs.google.com/open?id=0Bz3iL12EQc5-aG45M2kyY0trYW8">https://docs.google.com/open?id=0Bz3iL12EQc5-aG45M2kyY0trYW8</a><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh08LSv9zlDc-HlGROoBQKejLpA7IhIVXXJecgfdOt2Pp4xyGwRYfj9H53YYe2OXU-NnOeJ12oGa8s0xxktoVf-TXSRHIDen5pPAbBbHyWA28h-0upy_VMptS0i79QmLuqpv3DFpYm_H40J/s1600/Batman+In+Dark+Knight+Rises+On+Bike.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh08LSv9zlDc-HlGROoBQKejLpA7IhIVXXJecgfdOt2Pp4xyGwRYfj9H53YYe2OXU-NnOeJ12oGa8s0xxktoVf-TXSRHIDen5pPAbBbHyWA28h-0upy_VMptS0i79QmLuqpv3DFpYm_H40J/s320/Batman+In+Dark+Knight+Rises+On+Bike.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-O-W6cO6FyeEH_WXTSNlcgl4yKwQd58kXt7YT25GNwjy7j9sQuv5KmTCrj3hwtJ4aaTYzjfSpFj5NIvBM13WyB7iGf59Een-il00Km-8HTgXA9RhdNA48S1r0qHkxGm0bh7tluOcvaj4O/s1600/Batman-The-Dark-Knight-Rises-HD-Wallpapers-1366x768-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-O-W6cO6FyeEH_WXTSNlcgl4yKwQd58kXt7YT25GNwjy7j9sQuv5KmTCrj3hwtJ4aaTYzjfSpFj5NIvBM13WyB7iGf59Een-il00Km-8HTgXA9RhdNA48S1r0qHkxGm0bh7tluOcvaj4O/s320/Batman-The-Dark-Knight-Rises-HD-Wallpapers-1366x768-1.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCF4NEy0l68y83UXotr-aXtZRCHknzDdX1MUHfUw5LP-TOwNFhobCPAQz6AMEOGIcUZkWN2_OO8qOGdz14wseGto7m9nnE_KeQ7iqhvsbIKQfpYEcy_bmApUyDvjs12Te4oPL5hkHJk4as/s1600/Batman_The_Dark_Knight_Rises_Wallpaper_1920x1080_28TDKR29_-_005.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCF4NEy0l68y83UXotr-aXtZRCHknzDdX1MUHfUw5LP-TOwNFhobCPAQz6AMEOGIcUZkWN2_OO8qOGdz14wseGto7m9nnE_KeQ7iqhvsbIKQfpYEcy_bmApUyDvjs12Te4oPL5hkHJk4as/s320/Batman_The_Dark_Knight_Rises_Wallpaper_1920x1080_28TDKR29_-_005.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgy2M4GXeUz0oPTas9DkBm756nQ0A4wzhl9NiGtEBXuAO_sn4QAnP53txtE629wIDPiLSBeXo1YngC7fERz1Kxl7rNfhSiBWMRzfJHP0uGrzRsb-0xslJh7__Y0TJjs15y782VU6_MPRxzE/s1600/batman-movies-bane-batmobile-the-dark-knight-rises-1400x1050.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgy2M4GXeUz0oPTas9DkBm756nQ0A4wzhl9NiGtEBXuAO_sn4QAnP53txtE629wIDPiLSBeXo1YngC7fERz1Kxl7rNfhSiBWMRzfJHP0uGrzRsb-0xslJh7__Y0TJjs15y782VU6_MPRxzE/s320/batman-movies-bane-batmobile-the-dark-knight-rises-1400x1050.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglh5h2aNFkFPEPwAhft_rwnvgkvVhgkffSEZvYlwfeKgHaNsIj3ddoy_9NdqMbqWGd2pCI6sI4QjwFXJKjHdyB-kXXHKQcBi77BiJCKSgqOFMzFCclIgA52AzaRiUkl8wp3pRfzU-xdekl/s1600/batman-the-dark-knight-rises-batman.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglh5h2aNFkFPEPwAhft_rwnvgkvVhgkffSEZvYlwfeKgHaNsIj3ddoy_9NdqMbqWGd2pCI6sI4QjwFXJKjHdyB-kXXHKQcBi77BiJCKSgqOFMzFCclIgA52AzaRiUkl8wp3pRfzU-xdekl/s320/batman-the-dark-knight-rises-batman.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBsg0nnNq0ajeMyHM0JKCjYsaQuDDnKdzwEQ6NQWxn8j1Qjggrkm2z2nVmByAQaC_2WxYewkKtFONayZ2hgONdbes9uGPU2Juv8R5wJq9CzTJ6Fjc7Fhjczl-ZsCdkZILVuJhjYzDcioOs/s1600/batman_dark_knight_rises-1680x1050.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBsg0nnNq0ajeMyHM0JKCjYsaQuDDnKdzwEQ6NQWxn8j1Qjggrkm2z2nVmByAQaC_2WxYewkKtFONayZ2hgONdbes9uGPU2Juv8R5wJq9CzTJ6Fjc7Fhjczl-ZsCdkZILVuJhjYzDcioOs/s320/batman_dark_knight_rises-1680x1050.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAoz92kjZIZ20KoQ_7tBmNdpzD0YG9I7JUhsw7xrYOn1fIUIaxiQAoSJ5dJ-5D6ZjgWPlYn-rgFLg0bapuiH1IfltZRiczHqDiyQF7mMKy0ELGKRd9pffy53XOIBcUBwtHLDJ5ekowEWx7/s1600/dark_knight.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="199" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAoz92kjZIZ20KoQ_7tBmNdpzD0YG9I7JUhsw7xrYOn1fIUIaxiQAoSJ5dJ-5D6ZjgWPlYn-rgFLg0bapuiH1IfltZRiczHqDiyQF7mMKy0ELGKRd9pffy53XOIBcUBwtHLDJ5ekowEWx7/s320/dark_knight.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMoTs1cgDMli9wdgXKBxxEgpSDAnICH9WVM3Z1RshBcWeC86zo_ecmQoreZVa4S_pU3kx8-ooXSgpqS42pvaj316kj-Gkn5ud_bBT61_kNE1Qs8fzzG6ajqQDoFGDRmnNyZN1NrGlJIAid/s1600/the_dark_knight_rises_batman-wide.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMoTs1cgDMli9wdgXKBxxEgpSDAnICH9WVM3Z1RshBcWeC86zo_ecmQoreZVa4S_pU3kx8-ooXSgpqS42pvaj316kj-Gkn5ud_bBT61_kNE1Qs8fzzG6ajqQDoFGDRmnNyZN1NrGlJIAid/s320/the_dark_knight_rises_batman-wide.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKZsAQv73k36wAYJy7gLd5sA0iIBbwnrh5Pbs-bPh7vZxrzOiJ4nrTyO383tWUo1wJ_E2OpayUPxlIbCHN4Vewl8Mnn6GGqpCUnrA-xrH-2EEEyHr47Xg8LBOE3M8vEUAQ7-nE_vXitbge/s1600/tom-hardy-christian-bale-the-dark-knight-rises1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKZsAQv73k36wAYJy7gLd5sA0iIBbwnrh5Pbs-bPh7vZxrzOiJ4nrTyO383tWUo1wJ_E2OpayUPxlIbCHN4Vewl8Mnn6GGqpCUnrA-xrH-2EEEyHr47Xg8LBOE3M8vEUAQ7-nE_vXitbge/s320/tom-hardy-christian-bale-the-dark-knight-rises1.jpg" width="320" /></a></div>
<br /></div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-5893285136742789352012-06-25T13:12:00.001+04:002012-06-25T13:12:44.192+04:00Wordpress - set the large image size in editor<div dir="ltr" style="text-align: left;" trbidi="on">
The large image size will be depend on the global variable $content_width.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiUTxFwmox6GVPXURfMWL-d26tUcrpGqQPymvJ3XZ7jSsVdPSSr71XYE0yQtETI0M9bM0fPasq9_Entd4VGi4ZfH2XFXZ7skd-yPI8TV2uJ9Aht_bBmOOEmF3wXIwntUs__dJU15AoN5X3/s1600/wordress-large-image-settings.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="235" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiUTxFwmox6GVPXURfMWL-d26tUcrpGqQPymvJ3XZ7jSsVdPSSr71XYE0yQtETI0M9bM0fPasq9_Entd4VGi4ZfH2XFXZ7skd-yPI8TV2uJ9Aht_bBmOOEmF3wXIwntUs__dJU15AoN5X3/s640/wordress-large-image-settings.png" width="640" /></a></div>
<br />
Even if we change the settings in the media settings to a bigger one, we have to put the width to <span style="background-color: white;">$content_width.</span><br />
<span style="background-color: white;"><br /></span><br />
<span style="background-color: white;"> In functions.php inside the active theme folder, </span><br />
<span style="background-color: white;"> change like this,</span><br />
<span style="background-color: white;"> </span><br />
<span style="background-color: white;"><br /></span><br />
<span style="background-color: white;">if ( ! isset( $content_width ) )</span><span style="background-color: white;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$content_width = 754;<br />
<br />
<br />
<br /><br />
<span style="background-color: white;"><br /></span><br />
<span style="background-color: white;"><br /></span></div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-91595618859259202232012-04-23T14:23:00.001+04:002012-04-23T14:23:29.709+04:00Javascript array length problem<div dir="ltr" style="text-align: left;" trbidi="on">
There is a problem in javascript array.length property.<br />
<br />var myOtherArray = [];<br /> myOtherArray[100] = ‘one’;<br />
and its length property would actually return <b><span style="color: red;">101</span> instead of 1</b>.<br />
<br />
<br />
Use this function for correct result , <br />
function count(array)<br /> {<br /> var c = 0;<br /> for(i in array) // in returns key, not object<br /> if(array[i] != undefined)<br /> c++;<br />
return c;<br />
}<br />
</div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-44340672433833264802011-10-23T12:57:00.000+04:002011-10-23T12:57:42.206+04:00Speech recognition search introduced by google<div dir="ltr" style="text-align: left;" trbidi="on">The new feature had started functioning.<br />
<br />
<blockquote>I said "USB" to google.</blockquote><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYJUl95pAlSygIfQSyBf4pwPXU8krdxULJAiSIxYMU4VbYph5UOXEyycLolBSlh7zHsIY7SWs9NjpkrpjAuBr35RV4Yp1ODpEmGz6xIDCAaczRDbzlDyFYuQZQsxE7rECqL5FCPEWysK0d/s1600/google-speach-recognition-search-1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="166" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYJUl95pAlSygIfQSyBf4pwPXU8krdxULJAiSIxYMU4VbYph5UOXEyycLolBSlh7zHsIY7SWs9NjpkrpjAuBr35RV4Yp1ODpEmGz6xIDCAaczRDbzlDyFYuQZQsxE7rECqL5FCPEWysK0d/s400/google-speach-recognition-search-1.JPG" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;">that resulted</div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfpKRTIP3ZVxxmlRCD3pjAHOEFXLI5jD-ZonJ4C0vHJ808YPeCDoOvGaWGEjDKcJlQE2Vi5yRmLlj9btxBjx2WlSJcs-F6vNXcgmazpKHGWgnFIIpuLG_ZLEaRet8l73fokUiw-y1cBMo5/s1600/google-speach-recognition-search-2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="135" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfpKRTIP3ZVxxmlRCD3pjAHOEFXLI5jD-ZonJ4C0vHJ808YPeCDoOvGaWGEjDKcJlQE2Vi5yRmLlj9btxBjx2WlSJcs-F6vNXcgmazpKHGWgnFIIpuLG_ZLEaRet8l73fokUiw-y1cBMo5/s320/google-speach-recognition-search-2.JPG" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><br />
</div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-65574613232046281232011-10-13T15:43:00.012+04:002011-10-23T17:38:41.243+04:00recurring payment code for paypal using php with NVP<div dir="ltr" style="text-align: left;" trbidi="on">This is a quick code for creating recurring profile on paypal using PHP with NVP<br />
<br />
<pre class="php" name="code"><?php
$environment = 'sandbox'; // or 'beta-sandbox' or 'live'
/**
* Send HTTP POST Request
*
* @param string The API method name
* @param string The POST Message fields in &name=value pair format
* @return array Parsed HTTP Response body
*/
function PPHttpPost($methodName_, $nvpStr_) {
global $environment;
$API_UserName = urlencode('API Username');
$API_Password = urlencode('API Password');
$API_Signature = urlencode('API Signature');
$API_Endpoint = "https://api-3t.paypal.com/nvp";
if("sandbox" === $environment || "beta-sandbox" === $environment) {
$API_Endpoint = "https://api-3t.$environment.paypal.com/nvp";
}
$version = urlencode('51.0');
// setting the curl parameters.
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $API_Endpoint);
curl_setopt($ch, CURLOPT_VERBOSE, 1);
// turning off the server and peer verification(TrustManager Concept).
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POST, 1);
// NVPRequest for submitting to server
$nvpreq = "METHOD=$methodName_&VERSION=$version&PWD=$API_Password&USER=$API_UserName&SIGNATURE=$API_Signature$nvpStr_";
// setting the nvpreq as POST FIELD to curl
curl_setopt($ch, CURLOPT_POSTFIELDS, $nvpreq);
// getting response from server
$httpResponse = curl_exec($ch);
if(!$httpResponse) {
exit("$methodName_ failed: ".curl_error($ch).'('.curl_errno($ch).')');
}
// Extract the RefundTransaction response details
$httpResponseAr = explode("&", $httpResponse);
$httpParsedResponseAr = array();
foreach ($httpResponseAr as $i => $value) {
$tmpAr = explode("=", $value);
if(sizeof($tmpAr) > 1) {
$httpParsedResponseAr[$tmpAr[0]] = $tmpAr[1];
}
}
if((0 == sizeof($httpParsedResponseAr)) || !array_key_exists('ACK', $httpParsedResponseAr)) {
exit("Invalid HTTP Response for POST request($nvpreq) to $API_Endpoint.");
}
return $httpParsedResponseAr;
}
/*--------------------*/
// Collect the payment info
// Set request-specific fields.
$firstName = urlencode('sajin');
$lastName = urlencode('tm');
$creditCardType = urlencode('Visa');
$creditCardNumber = urlencode('4824255179800020');
$expDateMonth = '10';
// Month must be padded with leading zero
$padDateMonth = urlencode(str_pad($expDateMonth, 2, '0', STR_PAD_LEFT));
$expDateYear = urlencode('2016');
$cvv2Number = urlencode('');
$address1 = urlencode('address 1');
$address2 = urlencode('address 2');
$city = urlencode('United States ');
$state = urlencode('New York');
$zip = urlencode('13355');
$country = urlencode('US'); // US or other valid country code
$amount = urlencode('12');
$currencyID = urlencode('USD'); // or other currency ('GBP', 'EUR', 'JPY', 'CAD', 'AUD')
/*--------------------*/
$token = urlencode("");
$paymentAmount = urlencode("12");
$currencyID = urlencode("USD"); // or other currency code ('GBP', 'EUR', 'JPY', 'CAD', 'AUD')
$startDate = urlencode("2011-12-12T0:0:0");
$billingPeriod = urlencode("Month"); // or "Day", "Week", "SemiMonth", "Year"
$billingFreq = urlencode("1"); // combination of this and billingPeriod must be at most a year
$desc = urlencode('desc sample');
$nvpStr="&CREDITCARDTYPE=$creditCardType&ACCT=$creditCardNumber&EXPDATE=$padDateMonth$expDateYear&FIRSTNAME=$firstName&LASTNAME=$lastName&AMT=$paymentAmount&CURRENCYCODE=$currencyID&PROFILESTARTDATE=$startDate";
$nvpStr .= "&BILLINGPERIOD=$billingPeriod&BILLINGFREQUENCY=$billingFreq&DESC=$desc";
$httpParsedResponseAr = PPHttpPost('CreateRecurringPaymentsProfile', $nvpStr);
echo "<pre>";
if("SUCCESS" == strtoupper($httpParsedResponseAr["ACK"]) || "SUCCESSWITHWARNING" == strtoupper($httpParsedResponseAr["ACK"])) {
exit('CreateRecurringPaymentsProfile Completed Successfully: '.print_r($httpParsedResponseAr, true));
} else {
exit('CreateRecurringPaymentsProfile failed: ' . print_r($httpParsedResponseAr, true));
}
echo "</pre>";
?>
</pre><br />
The output in normal case will be<br />
<br />
<pre>CreateRecurringPaymentsProfile Completed Successfully: Array
(
[PROFILEID] => I%2dK1EXE5JU3JCC
[TIMESTAMP] => 2011%2d10%2d23T13%3a30%3a55Z
[CORRELATIONID] => a2133526075
[ACK] => Success
[VERSION] => 51%2e0
[BUILD] => 2183220
)
</pre></div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com2tag:blogger.com,1999:blog-8653391637121364586.post-6555976212611485512011-06-27T17:21:00.005+04:002011-06-29T10:24:24.432+04:00regular expression for checking the text without specified extensionHi , <div> This regular expression example is useful to check whether our SQL queries accidentally contain database name , </div><div><br /></div><div>like, "SELECT purchases.* from <span class="Apple-style-span">shopdatabase.</span>purchases" .</div><div><br /></div><div><span class="Apple-style-span">For finding and removing the database names from sql , </span></div><div><span class="Apple-style-span"> use regular expression pattern " </span><span class="Apple-style-span">shopdatabase</span><span class="Apple-style-span">\<span class="Apple-style-span">.</span>[^(com|php)] "</span></div><div><span class="Apple-style-span">where the " </span>com|php " is the extensions we want to avoid.</div><div><span class="Apple-style-span"><br /></span></div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-16699863748527981132011-03-08T13:11:00.002+04:002011-03-08T13:16:01.297+04:00adding single selection of radio button in asp.net grid column on click<span style="font-family: arial;">Hi , </span><br /><span style="font-family: arial;"> This is the control code for the radio button </span><br /><br /> <span style="font-family: courier new;"> <span style="color: rgb(51, 51, 51);"><asp:radiobutton onclick="SetUniqueRadioButton('grdzoneDetails.*groupSectorId',this)" id="testid" runat="server" groupname="groupSectorId"></span></span><br /><br /> <br /><span style="font-family: arial;"> Then add the following javascript code</span><br /><br /> <span style="color: rgb(51, 51, 51); font-family: courier new;"><script type="text/javascript" language="javascript"></span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> function SetUniqueRadioButton(nameregex, current) {</span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> re = new RegExp(nameregex);</span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> for (i = 0; i <><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> elm = document.forms[0].elements[i]</span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> if (elm.type == 'radio') {</span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> if (re.test(elm.name)) {</span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> elm.checked = false;</span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> }</span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> }</span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> }</span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> current.checked = true;</span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"> }</span><br /><span style="color: rgb(51, 51, 51); font-family: courier new;"></script></span>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-74045362555341733292011-02-22T23:17:00.002+04:002011-02-22T23:18:01.107+04:00zencart email debugFor debugging emails in zencart, <div> use this , in includes\functions\functions_email.php </div><div> if (!defined('EMAIL_SYSTEM_DEBUG')) define('EMAIL_SYSTEM_DEBUG','5'); </div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-37244534124265626692010-12-18T16:30:00.000+04:002010-12-18T16:31:01.311+04:00Me at cricet match<div xmlns="http://www.w3.org/1999/xhtml"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaOcuVDU-ivSgbiWeSuY0p3LcBpOQBmMvpbRlm1TpH3GPTV6_aP0IGuMxGa6G4FkYMHzI9BndlycmZLnJViVWohsvUwNsVIiMv-3Cr04Efcize20ICzl1r7GrCGnZ04hfZoncBH14F-31a/s1600/image-upload-8-759588.jpg"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaOcuVDU-ivSgbiWeSuY0p3LcBpOQBmMvpbRlm1TpH3GPTV6_aP0IGuMxGa6G4FkYMHzI9BndlycmZLnJViVWohsvUwNsVIiMv-3Cr04Efcize20ICzl1r7GrCGnZ04hfZoncBH14F-31a/s320/image-upload-8-759588.jpg"/></a><br /><span>Pic during our first match</span><br /></div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-15136077796978127922010-12-18T15:56:00.001+04:002010-12-18T16:06:54.816+04:00Technopark roundabout<div xmlns="http://www.w3.org/1999/xhtml"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8zy8-yir0_I_bxkUwxXb3crYY_I2C-M3umR2qAvmRhkdEzaeQ7oImZ1vVs-Ttu83xvAptTL2XfPxbs30LSU0CDyFSEvmMG0H9xHfMN-2vPi0lDCD1WxrI-j9I1ShfwnkfOFqjPgZQ_uWU/s1600/image-upload-60-798948.jpg"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPzOjGDC-OCGqzmFNQ5flKFBd8Vd8r2wIi33kyiAZM2LwOha2OuZPUJsUsPQVOVI0gLDcGTwbLDCGnQmODE0c3fCGUPhi9j9O1ysLvlWTkznlkEcDExs8T6nrY_Cq4AENJzbe8hvVlt1SG/s320/image-upload-60-798948.jpg"/></a><br /><span>A view from the top of tejaswini building</span><br /></div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-62791426742888869052010-12-14T23:27:00.004+04:002010-12-16T09:22:07.901+04:00Block unethickal sites using free Microsoft softwareHi,<br />Please save our kids and ourselves by installing this free Microsoft software from unethical websites.<br />See <a href="http://explore.live.com/windows-live-family-safety-xp">http://explore.live.com/windows-live-family-safety-xp</a>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-72015703051362280292010-12-13T13:46:00.005+04:002010-12-16T09:34:03.680+04:00Delete Joomla sample data using SQLPlease take a backup of the database if you have any reusable data in tables.<br /><br />This is the screen shot after a fresh installation of <span class="blsp-spelling-error" id="SPELLING_ERROR_0">Joomla</span>.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEix1FyNkULnbQJ8rMEVUZ70UNPEsS-hwc8rzQ_jxkqzOER9pCUwmTdZb4bFayVolJUdUr-lSgRvIUilSchPutkTK5tPKSqvwBLRc8bTZVPsa3otCx2A_3gU8pPwbqNUfMsoRtf1r3cRB6eu/s1600/joomla-after-fresh-installation.JPG"><img style="display: block; margin: 0px auto 10px; text-align: center; cursor: pointer; width: 305px; height: 320px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEix1FyNkULnbQJ8rMEVUZ70UNPEsS-hwc8rzQ_jxkqzOER9pCUwmTdZb4bFayVolJUdUr-lSgRvIUilSchPutkTK5tPKSqvwBLRc8bTZVPsa3otCx2A_3gU8pPwbqNUfMsoRtf1r3cRB6eu/s320/joomla-after-fresh-installation.JPG" alt="" id="BLOGGER_PHOTO_ID_5551146583132369074" border="0" /></a><br /><br /><br />After executing the following query , the page will look like this.<br /><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjizNLOkEhgYfXRDFoifg5hAoTMhIPTEkk9SuzEnF5K3NH6MiROViOZR2v_k3QfuVKY7g74lmccCoyCe_3MIZ5SMBVw3ZFaeT3OBt1diRYrX4UvuxMuF1cqzcL8-sasbhH7UnBw2Zhyphenhyphens0Rf/s1600/after-delete-sample-data-joomla.JPG"><img style="display: block; margin: 0px auto 10px; text-align: center; cursor: pointer; width: 320px; height: 172px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjizNLOkEhgYfXRDFoifg5hAoTMhIPTEkk9SuzEnF5K3NH6MiROViOZR2v_k3QfuVKY7g74lmccCoyCe_3MIZ5SMBVw3ZFaeT3OBt1diRYrX4UvuxMuF1cqzcL8-sasbhH7UnBw2Zhyphenhyphens0Rf/s320/after-delete-sample-data-joomla.JPG" alt="" id="BLOGGER_PHOTO_ID_5551146898077617346" border="0" /></a><span class="blsp-spelling-error" id="SPELLING_ERROR_1">Remeber</span> if you had entered any additional data other than default , then it may deleted.<br /><br />Run the following SQL queries.<br /><br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_2">jos</span>_banner`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_3">jos</span>_<span class="blsp-spelling-error" id="SPELLING_ERROR_4">bannerclient</span>`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_5">jos</span>_<span class="blsp-spelling-error" id="SPELLING_ERROR_6">bannertrack</span>`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_7">jos</span>_categories`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_8">jos</span>_content`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_9">jos</span>_content_<span class="blsp-spelling-error" id="SPELLING_ERROR_10">frontpage</span>`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_11">jos</span>_<span class="blsp-spelling-error" id="SPELLING_ERROR_12">newsfeeds</span>`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_13">jos</span>_polls`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_14">jos</span>_poll_data`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_15">jos</span>_poll_date`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_16">jos</span>_sections`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_17">jos</span>_<span class="blsp-spelling-error" id="SPELLING_ERROR_18">weblinks</span>`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_19">jos</span>_contact_details`;<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_20">jos</span>_menu`;<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_21">jos</span>_menu` VALUES (1, '<span class="blsp-spelling-error" id="SPELLING_ERROR_22">mainmenu</span>', 'Home', 'home', 'index.<span class="blsp-spelling-error" id="SPELLING_ERROR_23">php</span>?option=com_content&view=<span class="blsp-spelling-error" id="SPELLING_ERROR_24">frontpage</span>', 'component', 1, 0, 20, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, '<span class="blsp-spelling-error" id="SPELLING_ERROR_25">num</span>_leading_articles=1\<span class="blsp-spelling-error" id="SPELLING_ERROR_26">nnum</span>_intro_articles=4\<span class="blsp-spelling-error" id="SPELLING_ERROR_27">nnum</span>_columns=2\<span class="blsp-spelling-error" id="SPELLING_ERROR_28">nnum</span>_links=4\<span class="blsp-spelling-error" id="SPELLING_ERROR_29">norderby</span>_<span class="blsp-spelling-error" id="SPELLING_ERROR_30">pri</span>=\<span class="blsp-spelling-error" id="SPELLING_ERROR_31">norderby</span>_sec=front\<span class="blsp-spelling-error" id="SPELLING_ERROR_32">nshow</span>_pagination=2\<span class="blsp-spelling-error" id="SPELLING_ERROR_33">nshow</span>_pagination_results=1\<span class="blsp-spelling-error" id="SPELLING_ERROR_34">nshow</span>_feed_link=1\<span class="blsp-spelling-error" id="SPELLING_ERROR_35">nshow</span>_<span class="blsp-spelling-error" id="SPELLING_ERROR_36">noauth</span>=\<span class="blsp-spelling-error" id="SPELLING_ERROR_37">nshow</span>_title=\<span class="blsp-spelling-error" id="SPELLING_ERROR_38">nlink</span>_titles=\<span class="blsp-spelling-error" id="SPELLING_ERROR_39">nshow</span>_intro=\<span class="blsp-spelling-error" id="SPELLING_ERROR_40">nshow</span>_section=\<span class="blsp-spelling-error" id="SPELLING_ERROR_41">nlink</span>_section=\<span class="blsp-spelling-error" id="SPELLING_ERROR_42">nshow</span>_category=\<span class="blsp-spelling-error" id="SPELLING_ERROR_43">nlink</span>_category=\<span class="blsp-spelling-error" id="SPELLING_ERROR_44">nshow</span>_author=\<span class="blsp-spelling-error" id="SPELLING_ERROR_45">nshow</span>_create_date=\<span class="blsp-spelling-error" id="SPELLING_ERROR_46">nshow</span>_modify_date=\<span class="blsp-spelling-error" id="SPELLING_ERROR_47">nshow</span>_item_navigation=\<span class="blsp-spelling-error" id="SPELLING_ERROR_48">nshow</span>_<span class="blsp-spelling-error" id="SPELLING_ERROR_49">readmore</span>=\<span class="blsp-spelling-error" id="SPELLING_ERROR_50">nshow</span>_vote=\<span class="blsp-spelling-error" id="SPELLING_ERROR_51">nshow</span>_icons=\<span class="blsp-spelling-error" id="SPELLING_ERROR_52">nshow</span>_<span class="blsp-spelling-error" id="SPELLING_ERROR_53">pdf</span>_icon=\<span class="blsp-spelling-error" id="SPELLING_ERROR_54">nshow</span>_print_icon=\<span class="blsp-spelling-error" id="SPELLING_ERROR_55">nshow</span>_email_icon=\<span class="blsp-spelling-error" id="SPELLING_ERROR_56">nshow</span>_hits=\<span class="blsp-spelling-error" id="SPELLING_ERROR_57">nfeed</span>_summary=\<span class="blsp-spelling-error" id="SPELLING_ERROR_58">npage</span>_title=\<span class="blsp-spelling-error" id="SPELLING_ERROR_59">nshow</span>_page_title=1\<span class="blsp-spelling-error" id="SPELLING_ERROR_60">npageclass</span>_<span class="blsp-spelling-error" id="SPELLING_ERROR_61">sfx</span>=\<span class="blsp-spelling-error" id="SPELLING_ERROR_62">nmenu</span>_image=-1\<span class="blsp-spelling-error" id="SPELLING_ERROR_63">nsecure</span>=0\n\n', 0, 0, 1);<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_64">jos</span>_modules`;<br /><br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_65">jos</span>_modules` VALUES (1, 'Main Menu', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_<span class="blsp-spelling-error" id="SPELLING_ERROR_66">mainmenu</span>', 0, 0, 1, '<span class="blsp-spelling-error" id="SPELLING_ERROR_67">menutype</span>=<span class="blsp-spelling-error" id="SPELLING_ERROR_68">mainmenu</span>\<span class="blsp-spelling-error" id="SPELLING_ERROR_69">nmoduleclass</span>_<span class="blsp-spelling-error" id="SPELLING_ERROR_70">sfx</span>=_menu\n', 1, 0, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_71">jos</span>_modules` VALUES (2, '<span class="blsp-spelling-error" id="SPELLING_ERROR_72">Login</span>', '', 1, '<span class="blsp-spelling-error" id="SPELLING_ERROR_73">login</span>', 0, '0000-00-00 00:00:00', 1, 'mod_<span class="blsp-spelling-error" id="SPELLING_ERROR_74">login</span>', 0, 0, 1, '', 1, 1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_75">jos</span>_modules` VALUES (3, 'Popular','',3,'<span class="blsp-spelling-error" id="SPELLING_ERROR_76">cpanel</span>',0,'0000-00-00 00:00:00',1,'mod_popular',0,2,1,'',0, 1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_77">jos</span>_modules` VALUES (4, 'Recent added Articles','',4,'<span class="blsp-spelling-error" id="SPELLING_ERROR_78">cpanel</span>',0,'0000-00-00 00:00:00',1,'mod_latest',0,2,1,'ordering=c_<span class="blsp-spelling-error" id="SPELLING_ERROR_79">dsc</span>\<span class="blsp-spelling-error" id="SPELLING_ERROR_80">nuser</span>_id=0\<span class="blsp-spelling-error" id="SPELLING_ERROR_81">ncache</span>=0\n\n',0, 1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_82">jos</span>_modules` VALUES (5, 'Menu Stats','',5,'<span class="blsp-spelling-error" id="SPELLING_ERROR_83">cpanel</span>',0,'0000-00-00 00:00:00',1,'mod_stats',0,2,1,'',0, 1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_84">jos</span>_modules` VALUES (6, 'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,2,1,'',1, 1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_85">jos</span>_modules` VALUES (7, 'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,2,1,'',1, 1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_86">jos</span>_modules` VALUES (8, 'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,2,1,'',1, 1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_87">jos</span>_modules` VALUES (9, 'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_<span class="blsp-spelling-error" id="SPELLING_ERROR_88">quickicon</span>',0,2,1,'',1,1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_89">jos</span>_modules` VALUES (10, 'Logged in Users','',2,'<span class="blsp-spelling-error" id="SPELLING_ERROR_90">cpanel</span>',0,'0000-00-00 00:00:00',1,'mod_logged',0,2,1,'',0,1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_91">jos</span>_modules` VALUES (11, 'Footer', '', 0, 'footer', 0, '0000-00-00 00:00:00', 1, 'mod_footer', 0, 0, 1, '', 1, 1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_92">jos</span>_modules` VALUES (12, 'Admin Menu','', 1,'menu', 0,'0000-00-00 00:00:00', 1,'mod_menu', 0, 2, 1, '', 0, 1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_93">jos</span>_modules` VALUES (13, 'Admin <span class="blsp-spelling-error" id="SPELLING_ERROR_94">SubMenu</span>','', 1,'<span class="blsp-spelling-error" id="SPELLING_ERROR_95">submenu</span>', 0,'0000-00-00 00:00:00', 1,'mod_<span class="blsp-spelling-error" id="SPELLING_ERROR_96">submenu</span>', 0, 2, 1, '', 0, 1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_97">jos</span>_modules` VALUES (14, 'User Status','', 1,'status', 0,'0000-00-00 00:00:00', 1,'mod_status', 0, 2, 1, '', 0, 1, '');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_98">jos</span>_modules` VALUES (15, 'Title','', 1,'title', 0,'0000-00-00 00:00:00', 1,'mod_title', 0, 2, 1, '', 0, 1, '');<br /><br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_99">jos</span>_modules_menu`;<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_100">jos</span>_modules_menu` VALUES (1,0);<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_101">jos</span>_menu_types`;<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_102">jos</span>_menu_types` VALUES (1, '<span class="blsp-spelling-error" id="SPELLING_ERROR_103">mainmenu</span>', 'Main Menu', 'The main menu for the site');<br />TRUNCATE TABLE `<span class="blsp-spelling-error" id="SPELLING_ERROR_104">jos</span>_templates_menu`;<br /><br /># Dumping data for table `<span class="blsp-spelling-error" id="SPELLING_ERROR_105">jos</span>_templates_menu`<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_106">jos</span>_templates_menu` VALUES ('<span class="blsp-spelling-error" id="SPELLING_ERROR_107">rhuk</span>_<span class="blsp-spelling-error" id="SPELLING_ERROR_108">milkyway</span>', '0', '0');<br />INSERT INTO `<span class="blsp-spelling-error" id="SPELLING_ERROR_109">jos</span>_templates_menu` VALUES ('<span class="blsp-spelling-error" id="SPELLING_ERROR_110">khepri</span>', '0', '1');Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com5tag:blogger.com,1999:blog-8653391637121364586.post-91681376111839299682010-10-29T10:30:00.001+04:002010-10-29T10:30:54.018+04:00drupal view system implementationhttp://drupal.org/project/module_template_systemSajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-23107356812643371432010-10-18T08:24:00.001+04:002010-10-18T08:24:55.758+04:00http://gftp.seul.org/gFTP is a free multithreaded file transfer client for *NIX based machines. It has the following features:<br /><br /> * Distributed under the terms of the GNU Public License Agreement<br /> * Written in C and has a text interface and a GTK+ 1.2/2.x interface<br /> * Supports the FTP, FTPS (control connection only), HTTP, HTTPS, SSH and FSP protocols<br /> * FTP and HTTP proxy server support<br /> * Supports FXP file transfers (transferring files between 2 remote servers via FTP)<br /> * Supports UNIX, EPLF, Novell, MacOS, VMS, MVS and NT (DOS) style directory listings<br /> * Bookmarks menu to allow you to quickly connect to remote sites<br /> * Fully Internationalized. The following translations of gFTP that are available: Albanian (sq), Amharic (am), Arabic (ar), Azerbaijan (az), Bangla (bn), Belarusian (be), Bulgarian (bg), Catalan (ca), Chinese (zh_CN,zh_HK,zh_TW), Croatian (hr), Czech (cs), Danish (da), Dutch (nl), Dzongkha (dz), English (en_CA, en_GB, en_US), Finnish (fi), French (fr), Galician (gl), German (de), Greek (el), Gujarati (gu), Hebrew (he), Hungarian (hu), Irish (ga), Italian (it), Kinyarwanda (rw), Korean (ko), Japanese (ja), Latvian (lv), Lithuanian (lt), Macedonian (mk), Malayalam (ml), Malay (ms), Nepali (ne), Norwegian (no), Norwegian bokmål (nb), Occitan (oc), Polish (pl), Portuguese (pt,pt_BR), Punjabi (pa), Romanian (ro), Russian (ru), Serbian (sr,sr@Latn), Slovak (sk), Spanish (es), Swedish (sv), Tamil (ta), Thai (th), Turkish (tr) and Ukrainian (uk) translations available.Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-85626057758656573112010-10-06T09:29:00.000+04:002010-10-06T09:29:49.262+04:00High Availability MySQL: Drizzle beta is here!<a href="http://mysqlha.blogspot.com/2010/09/drizzle-beta-is-here.html">High Availability MySQL: Drizzle beta is here!</a>: "- Sent using Google Toolbar"Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-82637712055622272272010-10-05T10:44:00.002+04:002010-10-05T10:50:34.229+04:00using compression in linux with commandUsing command line is faster than GUI.<br /><br /><br />compresses file<br /><br />gzip -c file1 > foo.gz<br /><br /><br />Gunzip and import to mysql using gzip<br /><br />gunzip < outputfile.sql.gz | mysql < mysql options>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-31782652154509691352010-09-12T21:46:00.005+04:002010-09-13T05:33:34.681+04:00Send mail with joomla jmail class using gmail smtp account<div> jimport('joomla.mail.mail');</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>$mail = new JMail();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>$mail->setsender("useremail");</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>$mail->addRecipient("destination@email.com");</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>$mail->setSubject("Here goes the subject");</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>$mail->setbody("The body of mail");</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>$mail->addAttachment('c:\\1.pdf');</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>$mail->useSMTP(true, "smtp.gmail.com", "useremail", "password",'ssl',465);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>$mail->send();</div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-69581372348622901572010-08-08T16:56:00.004+04:002010-08-08T21:05:36.469+04:00Performance comparison test between MySQL and PostgreSql<b>Step 1)</b><div><b><br /></b> <div> I have created a table in mysql with following query.</div><div><br /></div><div><div><b><span class="Apple-style-span" style="color:#999900;">CREATE TABLE `latlong` (</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> `id` int(10) NOT NULL auto_increment,</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> `lat` decimal(12,9) NOT NULL,</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> `lng` decimal(12,9) NOT NULL,</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> `place_name` varchar(253) NOT NULL,</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> PRIMARY KEY (`id`),</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> KEY `lat` (`lat`),</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> KEY `lng` (`lng`),</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> KEY `id` (`id`)</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">) ENGINE=MyISAM AUTO_INCREMENT=800001 DEFAULT CHARSET=latin1;</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"><br /></span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"><br /></span></b></div><div>I made the similar structure in PostgreSQL too.</div><div><b><span class="Apple-style-span" style="color:#999900;"><br /></span></b></div><div><div><b><span class="Apple-style-span" style="color:#999900;">CREATE TABLE latlong</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">(</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> id integer NOT NULL,</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> lat numeric(12,9) NOT NULL,</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> lng numeric(12,9) NOT NULL,</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> place_name character varying NOT NULL,</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> CONSTRAINT latlong_pkey PRIMARY KEY (id)</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">)</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">WITH (</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> OIDS=FALSE</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">);</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">ALTER TABLE latlong OWNER TO postgres;</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"><br /></span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">-- Index: lat</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"><br /></span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">-- DROP INDEX lat;</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"><br /></span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">CREATE INDEX lat</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> ON latlong</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> USING btree</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> (lat);</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"><br /></span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">-- Index: lng</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"><br /></span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">-- DROP INDEX lng;</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"><br /></span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">CREATE INDEX lng</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> ON latlong</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> USING btree</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> (lng);</span></b></div></div><div><br /></div><div><b>Step 2 )</b> I entered 70 lakhs of random data to the table using a stored procedure.</div><div>In that i kept 1 lakh of duplicate data for testing purpose.</div><div><br /></div><div>After that, i exported the mysql data to csv and imported to Postgresql.</div><div><br /></div><div><b> Now both the table has same data and structure.</b></div><div><br /></div><div>Then i ran the query on both and the time differences were amazing.</div><div><br /></div><div><div> </div></div></div><div><div><b><span class="Apple-style-span" style="color:#999900;">select count(*) from </span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">(select max(id),count(id) from latlong group by lat,lng</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;">having count(id) >1</span></b></div><div><b><span class="Apple-style-span" style="color:#999900;"> ) as tmp</span></b><b><span class="Apple-style-span" style="color:#999900;">;</span></b></div></div><div><br /></div><div>The result was 99998 in both tables.</div><div><br /></div><div>Time taken for the outputs are,</div><div><br /></div><div>Mysql > <i>29.297 seconds</i></div><div>PostgreSQL > <i>7.922 seconds</i></div><div><br /></div><div>In the above test, PostgreSQL showed better performance than MySql.</div></div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0tag:blogger.com,1999:blog-8653391637121364586.post-2906740959264024362010-08-08T12:15:00.001+04:002010-08-08T12:19:52.105+04:00mysql stored procedure exampleThis is an example script of mysqls stored procedure.<div>This will insert a large number of records into a table. I prepared this for checking the performance of db.<br /><br /><br />delimiter //<br />CREATE PROCEDURE load_part_tab()<br />begin<br />declare v int default 0;<br />declare latv,longv float;<br /><br />while v < 8000000<br />do<br /><br />set latv = FLOOR(7 + (RAND() * 5)) + rand(); <br />set longv = FLOOR(7 + (RAND() * 5)) + rand();<br /><br />INSERT INTO `sams`.`latlong` (<br />`id` ,<br />`lat` ,<br />`lng` ,<br />`place_name`<br />)<br />VALUES (<br />'', latv, longv, concat(latv,longv));<br /><br />set v = v + 1;<br />end while;<br />end<br />//</div><div>delimiter ;</div>Sajin tmhttp://www.blogger.com/profile/10386840875702509942noreply@blogger.com0