August 2007

My Oracle 1Z0-007 Result

August 26, 2007

Oracle 1Z0-007 Result Originally uploaded by markmarucot I took the exam for 1Z0-007 Introduction to SQL yesterday (August 27). The some questions are very easy to answer as long as you know to concepts of Oracle SQL 9i. Some questions are tricky so I need to mark the questions to revisit after I completed answer [...]

Read the full article →

SEO URL Rewriting for GARS

August 19, 2007

I discussed the steps to setup the URL rewriting for VBulletin. For those forums using GARS, here are the steps. Edit geek/gars/mods/display/top.php Search: PLAIN TEXT CODE: $bits .= "<tr><td align=\"$stylevar[left]\"><span class=\"smallfont\"><a href=\"showthread.php?t=$value[threadid]\" title=\"$value[title]\">$value[title]</a></span></td></tr>"; Replaced with PLAIN TEXT CODE: $thread['url'] = strtolower(str_replace(" ", "-", $value[title])); $thread['url'] = strtolower(str_replace("'", "", $value[title])); $thread['url'] = ereg_replace("[/?!.$%£()~*@#]+", "", $thread['url']); $bits [...]

Read the full article →

VBulletin SEO URL Rewriting

August 19, 2007

Place the code below in the .htaccess. PLAIN TEXT CODE: RewriteRule ^t([0-9]+)-(.*).html$ showthread.php?t=$1 [L] RewriteRule ^lastpostinthread([0-9]+).html$ showthread.php?goto=lastpost&amp;t=$1 [L] RewriteRule ^newpostinthread([0-9]+).html$ showthread.php?goto=newpost&amp;t=$1 [L] RewriteRule ^f([0-9]+)-(.*).html$ forumdisplay.php?forumid=$1 [L] Edit the functions_forumlist.phpSearch for: PLAIN TEXT CODE: $forum['statusicon'] = fetch_forum_lightbulb($forumid, $lastpostinfo, $forum); and below that add PLAIN TEXT CODE: $forum['url'] = strtolower(str_replace(" ", "-",str_replace("/", "-", $forum['title']))); $forum['url'] = strtolower(str_replace("'", [...]

Read the full article →

VBulletin URL Rewriting

August 18, 2007

This discussed how to make the VBulletin URL to a human readable format. Link

Read the full article →

NoSpam! – an alternative to CAPTCHA images

August 18, 2007

This simple hack is meant as a replacement for the default CAPTCHA system in vBulletin. There are two main reasons one might want to do this: firstly, new technology is constantly being developed to crack CAPTCHA images and make spam accounts anyway, and secondly, the more secure the CAPTCHA, the more difficult it is for [...]

Read the full article →

VBulletin Specific Category Icon

August 18, 2007

Find "forumhome_forumbit_level1_nopost" template: Code: <td class="tcat"><img src="/path/to/your/image_$forum[forumid].gif" /></td> Then, when you're naming the images you'd like to display, add a suffix to each one with the Forum ID that you'd like it displayed for. Ex: image.gif for Forum ID 2 becomes - image_2.gif Edit: If you don't want to display an image for all your [...]

Read the full article →

Restrict User From Entering More Than 100 Records

August 14, 2007

You can write following code at WHEN-CREATE-RECORD trigger of that block to restrict user entering upto 100 records. IF to_number(:system.cursor_record) > 99 THEN raise form_trigger_failure; END IF;

Read the full article →

Generating Spool File Layout

August 14, 2007

Use this simple SQL script--lay.sql--to generate the layout for the spooled file. Run the script before spooling the table to get the layout Link

Read the full article →

Things to do if your query is slow

August 11, 2007

This explains on what to do to investigate why your query is slow. Link

Read the full article →

Oracle 11g Documentation

August 11, 2007

. Download Oracle Database 11g Release 1 (11.1.0.6.0) Standard Edition, Standard Edition One, and Enterprise Edition - Linux x86 (1.7 GB)2. Oracle Database 11g Release 1 Documentation Library Oracle® Database Concepts 11g Release 1 (11.1) Oracle® Database Upgrade Guide 11g Release 1 (11.1) Oracle® Database New Features Guide 11g Release 1 (11.1) “What’s New in [...]

Read the full article →