Job Board adjustments
authorharris wong <hwong@ocad.ca>
Fri, 23 Jul 2010 21:55:49 +0000 (21:55 -0000)
committerharris wong <hwong@ocad.ca>
Fri, 23 Jul 2010 21:55:49 +0000 (21:55 -0000)
Admin
- order the admin list a categories alphabetically
- missing [jb_edit_employer] language
- if no jobs exist in the admin view, print an empty row with the
standard none found message.

User
- missing word for [employer] on the My Start level Job board screen
- word Bookmark on the MyStart JB screen should be Bookmarks
- on the employer registration page, include the login/pw requirements
eg 8 letter plus... Same as ATutor reg screen
- description on the employer registration page, should be "Company
Description"
- the data under Employer in the Empolyer how lists the posters first
name, instead of the company
- change title to Job Title in the table listing all jobs
- add a pipe between Filters and Bookmarks on the main public  JB screen
- the bookmarks link should only show up for logged in users.
- Change "Subscribe" to "Subscribe to receive new job postings"

Employer
- Text of second tab should read "Add Job Posting" instead of "Add new
post" which sound like forum post instructions
- if no jobs exist in the employer view, print an empty row with the
standard none found message.
- change label for first field in Add Job Posting to "Job Title," the
word title on its own can be misinterpreted.
- change "View Post" to "View Job Posting"
- align fields of the employer edit profile screen more symetrically,
probably labels above filds like the AT registration screen

Extra
- XSS vulnerability
- removed unused templates.

17 files changed:
mods/job_board/include/classes/Employer.class.php
mods/job_board/include/classes/Job.class.php
mods/job_board/include/html/admin/jb_categories.tmpl.php
mods/job_board/include/html/admin/jb_edit_employer.tmpl.php
mods/job_board/include/html/admin/jb_employers.tmpl.php
mods/job_board/include/html/admin/jb_index.tmpl.php
mods/job_board/include/html/employer/jb_add_new_post.tmpl.php
mods/job_board/include/html/employer/jb_edit_post.tmpl.php
mods/job_board/include/html/employer/jb_home.tmpl.php
mods/job_board/include/html/employer/jb_profile.tmpl.php
mods/job_board/include/html/employer/jb_registration.tmpl.php
mods/job_board/include/html/jb_add_to_cart.tmpl.php [deleted file]
mods/job_board/include/html/jb_advance_search_table.tmpl.php
mods/job_board/include/html/jb_index.tmpl.php
mods/job_board/include/html/jb_view_post.tmpl.php
mods/job_board/index.php
mods/job_board/module.sql

index 420a908..2302fce 100644 (file)
@@ -55,23 +55,23 @@ class Employer{
     }
 
        function getName(){
-               return $this->name;
+               return htmlentities_utf8($this->name);
        }
        
        function getEmail(){
-               return $this->email;
+               return htmlentities_utf8($this->email);
        }
 
        function getCompany(){
-               return $this->company;
+               return htmlentities_utf8($this->company);
        }
        
        function getDescription(){
-           return $this->description;
+           return htmlentities_utf8($this->description);
     }
 
        function getWebsite(){
-               return $this->website;
+               return htmlentities_utf8($this->website);
        }
        
        function getLastLogin(){
index 489b323..3f3e215 100644 (file)
@@ -411,7 +411,7 @@ class Job{
                if(!empty($this->categories)){
                        return $this->categories;
                }
-               $sql = 'SELECT * FROM '.TABLE_PREFIX.'jb_categories';
+               $sql = 'SELECT * FROM '.TABLE_PREFIX.'jb_categories order by name';
                $rs = mysql_query($sql, $db);
                
                if ($rs){
index 0ee1e8a..d1ad09e 100644 (file)
                        </div>
                        <div class="right"><a href="<?php echo AT_JB_BASENAME;?>admin/categories.php?submit=delete<?php echo SEP; ?>action=delete<?php echo SEP;?>cid=<?php echo $category['id']; ?>" ><?php echo _AT('delete'); ?></a></div>
                </div>
-       <?php endforeach; endif; ?>
+       <?php endforeach; ?>
+       <?php else: ?>
+       <div class="admin_categories">
+               <div class="left"><?php echo _AT('jb_no_category'); ?></div>
+       </div>
+       <?php endif; ?>
        </div>
 </div>
 
index 120be5a..f36eb92 100644 (file)
@@ -23,17 +23,19 @@ function encrypt_password() {
 <div class="input-form">
        <form action="" method="post" name="jb_profile_form">
                <div class="row">
-                       <label for="jb_employer_name"><?php echo _AT('name'); ?></label>
+                       <label for="jb_employer_name"><?php echo _AT('jb_employer_name'); ?></label><br/>
                        <input type="text" name="jb_employer_name" id="jb_employer_name" value="<?php echo htmlentities_utf8($this->name); ?>"/>
                </div>
 
                <div class="row">
-                       <label for="jb_employer_password"><?php echo _AT('password'); ?></label>
-                       <input type="password" name="jb_employer_password" id="jb_employer_password"/>
+                       <label for="jb_employer_password"><?php echo _AT('password'); ?></label><br/>
+                       <input type="password" name="jb_employer_password" id="jb_employer_password"/><br/>
+                       <small>&middot; <?php echo _AT('combination'); ?><br />
+                                  &middot; <?php echo _AT('15_max_chars'); ?></small>
                </div>
 
                <div class="row">
-                       <label for="jb_employer_password2"><?php echo _AT('password_again'); ?></label>
+                       <label for="jb_employer_password2"><?php echo _AT('password_again'); ?></label><br/>
                        <input type="password" name="jb_employer_password2" id="jb_employer_password2"/>
                </div>
 
@@ -48,22 +50,22 @@ function encrypt_password() {
                </div>
 
                <div class="row">
-                       <label for="jb_employer_company"><?php echo _AT('company'); ?></label>
+                       <label for="jb_employer_company"><?php echo _AT('company'); ?></label><br/>
                        <input type="text" name="jb_employer_company" id="jb_employer_company" value="<?php echo htmlentities_utf8($this->company); ?>"/>
                </div>
 
                <div class="row">
-                       <label for="jb_employer_email"><?php echo _AT('email'); ?></label>
+                       <label for="jb_employer_email"><?php echo _AT('email'); ?></label><br/>
                        <input type="text" name="jb_employer_email" id="jb_employer_email" value="<?php echo htmlentities_utf8($this->email); ?>"/>
                </div>
 
                <div class="row">
-                       <label for="jb_employer_email2"><?php echo _AT('email_again'); ?></label>
+                       <label for="jb_employer_email2"><?php echo _AT('email_again'); ?></label><br/>
                        <input type="text" name="jb_employer_email2" id="jb_employer_email2"/>
                </div>
 
                <div class="row">
-                       <label for="jb_employer_website"><?php echo _AT('jb_website'); ?></label>
+                       <label for="jb_employer_website"><?php echo _AT('jb_website'); ?></label><br/>
                        <input type="text" name="jb_employer_website" id="jb_employer_website" value="<?php echo htmlentities_utf8($this->website); ?>"/>
                </div>
 
index 235e196..432f1b6 100644 (file)
@@ -1,10 +1,10 @@
 <table  class="data static" rules="rows">
     <tr>
         <th><?php echo _AT('username'); ?></th>
-        <th><?php echo _AT('name'); ?></th>
+        <th><?php echo _AT('jb_employer_name'); ?></th>
         <th><?php echo _AT('email'); ?></th>
         <th><?php echo _AT('company'); ?></th>
-        <th><?php echo _AT('description'); ?></th>
+        <th><?php echo _AT('jb_company_description'); ?></th>
         <th><?php echo _AT('jb_website'); ?></th>
         <th><?php echo _AT('last_login'); ?></th>
         <th><?php echo _AT('jb_approval_state'); ?></th>
@@ -36,5 +36,8 @@
         <td><?php echo $approval_state; ?></td>
         <td><a href="<?php echo AT_JB_BASENAME.'admin/edit_employer.php?eid='.$employer->getId();?>"><?php echo _AT('edit'); ?></a></td>
     </tr>
-    <?php endforeach; endif; ?>
+    <?php endforeach; ?>
+       <?php else: ?>
+               <tr><td colspan="8"><?php echo _AT('none_found');?> </td></tr>
+       <?php endif; ?>
 </table>
index 25574f4..05e6e58 100644 (file)
@@ -37,6 +37,9 @@
                        <td><?php echo ($row['approval_state']==AT_JB_POSTING_STATUS_CONFIRMED)?_AT('jb_confirmed'):_AT('jb_unconfirmed'); ?></td>
                        <td><a href="<?php echo AT_JB_BASENAME . 'admin/edit_post.php?jid='.$row['id']; ?>" title="<?php echo _AT('jb_click_to_edit'); ?>"><?php echo _AT('edit');?></a> | <a href="<?php echo AT_JB_BASENAME . 'admin/view_post.php?action=delete'.SEP.'jid='.$row['id']; ?>" title="<?php echo _AT('jb_click_to_delete'); ?>"><?php echo _AT('delete'); ?></a></td>
                </tr>
-               <?php endforeach; endif; ?>
+               <?php endforeach; ?>
+               <?php else: ?>
+                       <tr><td colspan="7"><?php echo _AT('none_found'); ?></td></tr>
+               <?php endif; ?>
        </tbody>
 </table>
\ No newline at end of file
index fd309f9..1ea5862 100644 (file)
@@ -6,7 +6,7 @@ if (($_POST['setvisual'] && !$_POST['settext']) || $_GET['setvisual']) {
 <div class="input-form">
        <form action="" method="post">
                <div class="row">
-                       <label for="jb_title"><?php echo _AT('title'); ?></label>
+                       <label for="jb_title"><?php echo _AT('jb_title'); ?></label>
                        <input type="text" id="jb_title" name="jb_title" />
                </div>          
                <div class="row">
@@ -57,7 +57,7 @@ if (($_POST['setvisual'] && !$_POST['settext']) || $_GET['setvisual']) {
                        ?>
                </div>
                <div class="row">
-                       <span class="required" title="<?php echo _AT('required_field'); ?>">*</span><label for="jb_description"><?php echo _AT('description'); ?></label><br />
+                       <span class="required" title="<?php echo _AT('required_field'); ?>">*</span><label for="jb_description"><?php echo _AT('jb_post_description'); ?></label><br />
                        <textarea name="jb_description" cols="55" rows="15" id="jb_description"><?php echo $_POST['jb_description']; ?><?php echo $this->job_post['description']; ?></textarea>
                </div>
                <div class="row">
index 6b4bf0c..f616388 100644 (file)
@@ -7,7 +7,7 @@ if (($_POST['setvisual'] && !$_POST['settext']) || $_GET['setvisual']) {
 <div class="input-form">
        <form action="" method="post">
                <div class="row">
-                       <label for="jb_title"><?php echo _AT('title'); ?></label>
+                       <label for="jb_title"><?php echo _AT('jb_title'); ?></label>
                        <input type="text" id="jb_title" name="jb_title" value="<?php echo htmlentities_utf8($this->job_post['title']); ?>" />
                </div>          
                <div class="row">
@@ -63,7 +63,7 @@ if (($_POST['setvisual'] && !$_POST['settext']) || $_GET['setvisual']) {
                        ?>
                </div>
                <div class="row">
-                       <span class="required" title="<?php echo _AT('required_field'); ?>">*</span><label for="jb_description"><?php echo _AT('description'); ?></label><br />
+                       <span class="required" title="<?php echo _AT('required_field'); ?>">*</span><label for="jb_description"><?php echo _AT('jb_post_description'); ?></label><br />
                        <textarea name="jb_description" cols="55" rows="15" id="jb_description"><?php echo $_POST['jb_description']; ?><?php echo $this->job_post['description']; ?></textarea>
                </div>
 
index 100431c..1721834 100644 (file)
@@ -2,7 +2,7 @@
 <table class="data static" summary="" rules="rows">
        <thead>
                <th><?php echo _AT('id'); ?></th>
-               <th class="sort"><a href="<?php echo $_SERVER['PHP_SELF']."?col=title".SEP."order=$order"; ?>"><?php echo _AT('title'); ?></a></th>
+               <th class="sort"><a href="<?php echo $_SERVER['PHP_SELF']."?col=title".SEP."order=$order"; ?>"><?php echo _AT('jb_title'); ?></a></th>
                <th><?php echo _AT('jb_employer'); ?></th>
                <th><?php echo _AT('categories'); ?></th>       
                <th class="sort"><a href="<?php echo $_SERVER['PHP_SELF']."?col=created_date".SEP."order=$order"; ?>"><?php echo _AT('created_date'); ?></a></th>
@@ -35,6 +35,9 @@
                        <td><?php echo AT_DATE(_AT("announcement_date_format"), $row['closing_date']); ?></td>
                        <td><a href="<?php echo AT_JB_BASENAME . 'employer/edit_post.php?jid='.$row['id']; ?>" title="<?php echo _AT('jb_click_to_edit'); ?>"><?php echo _AT('edit');?></a> | <a href="<?php echo AT_JB_BASENAME . 'employer/view_post.php?action=delete'.SEP.'jid='.$row['id']; ?>" title="<?php echo _AT('jb_click_to_delete'); ?>"><?php echo _AT('delete'); ?></a></td>
                </tr>
-               <?php endforeach; endif; ?>
+               <?php endforeach; ?>
+               <?php else: ?>
+               <tr><td colspan="6"><?php echo _AT('none_found');?></td></tr>
+               <?php endif; ?>
        </tbody>
 </table>
index c60baba..6abc6fa 100644 (file)
@@ -23,37 +23,39 @@ function encrypt_password() {
 <div class="input-form">
        <form action="" method="post" name="jb_profile_form">
                <div class="row">
-                       <label for="jb_employer_name"><?php echo _AT('name'); ?></label>
+                       <label for="jb_employer_name"><?php echo _AT('jb_employer_name'); ?></label><br/>
                        <input type="text" name="jb_employer_name" id="jb_employer_name" value="<?php echo htmlentities_utf8($this->name); ?>"/>
                </div>
 
                <div class="row">
-                       <label for="jb_employer_password"><?php echo _AT('password'); ?></label>
-                       <input type="password" name="jb_employer_password" id="jb_employer_password"/>
+                       <label for="jb_employer_password"><?php echo _AT('password'); ?></label><br/>
+                       <input type="password" name="jb_employer_password" id="jb_employer_password"/><br/>
+                       <small>&middot; <?php echo _AT('combination'); ?><br />
+                                  &middot; <?php echo _AT('15_max_chars'); ?></small>
                </div>
 
                <div class="row">
-                       <label for="jb_employer_password2"><?php echo _AT('password_again'); ?></label>
+                       <label for="jb_employer_password2"><?php echo _AT('password_again'); ?></label><br/>
                        <input type="password" name="jb_employer_password2" id="jb_employer_password2"/>
                </div>
 
                <div class="row">
-                       <label for="jb_employer_company"><?php echo _AT('company'); ?></label>
+                       <label for="jb_employer_company"><?php echo _AT('company'); ?></label><br/>
                        <input type="text" name="jb_employer_company" id="jb_employer_company" value="<?php echo htmlentities_utf8($this->company); ?>"/>
                </div>
 
                <div class="row">
-                       <label for="jb_employer_email"><?php echo _AT('email'); ?></label>
+                       <label for="jb_employer_email"><?php echo _AT('email'); ?></label><br/>
                        <input type="text" name="jb_employer_email" id="jb_employer_email" value="<?php echo htmlentities_utf8($this->email); ?>"/>
                </div>
 
                <div class="row">
-                       <label for="jb_employer_email2"><?php echo _AT('email_again'); ?></label>
+                       <label for="jb_employer_email2"><?php echo _AT('email_again'); ?></label><br/>
                        <input type="text" name="jb_employer_email2" id="jb_employer_email2"/>
                </div>
 
                <div class="row">
-                       <label for="jb_employer_website"><?php echo _AT('jb_website'); ?></label>
+                       <label for="jb_employer_website"><?php echo _AT('jb_website'); ?></label><br/>
                        <input type="text" name="jb_employer_website" id="jb_employer_website" value="<?php echo htmlentities_utf8($this->website); ?>"/>
                </div>
 
index 616b451..041562c 100644 (file)
@@ -22,47 +22,51 @@ function encrypt_password()
        <form method="post" action="" name="jb_registration_form">
                <div class="row">
                        <span class="required" title="<?php echo _AT('required_field'); ?>">*</span>
-                       <label for="jb_registration_username"><?php echo _AT('username'); ?></label>
-                       <input type="text" id="jb_registration_username" name="jb_registration_username" value="<?php echo htmlentities_utf8($_POST['jb_registration_username']); ?>"/>
+                       <label for="jb_registration_username"><?php echo _AT('jb_employer_login'); ?></label><br/>
+                       <input type="text" id="jb_registration_username" name="jb_registration_username" value="<?php echo htmlentities_utf8($_POST['jb_registration_username']); ?>"/><br />
+                       <small>&middot; <?php echo _AT('contain_only'); ?><br />
+                                  &middot; <?php echo _AT('20_max_chars'); ?></small>
                </div>
 
                <div class="row">
                        <span class="required" title="<?php echo _AT('required_field'); ?>">*</span>
-                       <label for="jb_registration_password"><?php echo _AT('password'); ?></label>
-                       <input type="password" id="jb_registration_password" name="jb_registration_password" />
+                       <label for="jb_registration_password"><?php echo _AT('password'); ?></label><br/>
+                       <input type="password" id="jb_registration_password" name="jb_registration_password" /><br/>
+                       <small>&middot; <?php echo _AT('combination'); ?><br />
+                                  &middot; <?php echo _AT('15_max_chars'); ?></small>
                </div>
 
                <div class="row">
                        <span class="required" title="<?php echo _AT('required_field'); ?>">*</span>
-                       <label for="jb_registration_password2"><?php echo _AT('password_again'); ?></label>
+                       <label for="jb_registration_password2"><?php echo _AT('password_again'); ?></label><br/>
                        <input type="password" id="jb_registration_password2" name="jb_registration_password2" />
                </div>
 
                <div class="row">
                        <span class="required" title="<?php echo _AT('required_field'); ?>">*</span>
-                       <label for="jb_registration_employer_name"><?php echo _AT('name'); ?></label>
+                       <label for="jb_registration_employer_name"><?php echo _AT('jb_employer_name'); ?></label><br/>
                        <input type="text" id="jb_registration_employer_name" name="jb_registration_employer_name" value="<?php echo htmlentities_utf8($_POST['jb_registration_employer_name']); ?>"/>
                </div>
 
                <div class="row">
                        <span class="required" title="<?php echo _AT('required_field'); ?>">*</span>
-                       <label for="jb_registration_email"><?php echo _AT('email'); ?></label>
+                       <label for="jb_registration_email"><?php echo _AT('email'); ?></label><br/>
                        <input type="text" id="jb_registration_email" name="jb_registration_email" value="<?php echo htmlentities_utf8($_POST['jb_registration_email']); ?>"/>
                </div>
                
                <div class="row">
                        <span class="required" title="<?php echo _AT('required_field'); ?>">*</span>
-                       <label for="jb_registration_company"><?php echo _AT('company'); ?></label>
+                       <label for="jb_registration_company"><?php echo _AT('company'); ?></label><br/>
                        <input type="text" id="jb_registration_company" name="jb_registration_company" value="<?php echo htmlentities_utf8($_POST['jb_registration_company']); ?>"/>
                </div>
 
                <div class="row">
-                       <label for="jb_registration_website"><?php echo _AT('jb_website'); ?></label>
+                       <label for="jb_registration_website"><?php echo _AT('jb_website'); ?></label><br/>
                        <input type="text" id="jb_registration_website" name="jb_registration_website" value="<?php echo htmlentities_utf8($_POST['jb_registration_website']); ?>"/>
                </div>
                
                <div class="row">
-                       <label for="jb_registration_description"><?php echo _AT('description'); ?></label>
+                       <label for="jb_registration_description"><?php echo _AT('jb_company_description'); ?></label><br/>
                        <textarea id="jb_registration_description" name="jb_registration_description" ><?php echo htmlentities_utf8($_POST['jb_registration_description']); ?></textarea>
                </div>
 
diff --git a/mods/job_board/include/html/jb_add_to_cart.tmpl.php b/mods/job_board/include/html/jb_add_to_cart.tmpl.php
deleted file mode 100644 (file)
index d0d000c..0000000
+++ /dev/null
@@ -1,6 +0,0 @@
-<?php 
-       
-?>
-<div class="add_to_cart">
-       <a href="<?php echo AT_JB_BASENAME; ?>view_post.php?action=add_to_cart<?php echo SEP;?>jid=<?php echo intval($_GET['jid']); ?>" title="<?php echo _AT('jb_add_to_cart');?>"><?php echo _AT('jb_add_to_cart');?></a>
-</div>
\ No newline at end of file
index 5d8e201..9a3e5d5 100644 (file)
@@ -25,7 +25,7 @@
                </td>
        </tr>
        <tr>
-               <td><label for="jb_search_bookmark"><?php echo _AT('jb_bookmark'); ?></td>
+               <td><label for="jb_search_bookmark"><?php echo _AT('jb_bookmarks'); ?></td>
                <td><input type="checkbox" name="jb_search_bookmark" id="jb_search_bookmark" <?php if($_GET['jb_search_bookmark']!=''){echo 'checked="checked"';} ?> /></td>
        </tr>
        <tr>
index 319c168..d563e28 100644 (file)
@@ -13,8 +13,8 @@ if ($search_string!=''){
        <table class="data static" summary="" rules="rows">
                <thead>
                        <th><?php echo _AT('id'); ?></th>
-                       <th class="sort"><a href="<?php echo $_SERVER['PHP_SELF']."?col=title".SEP."order=$order".$search_string; ?>"><?php echo _AT('title'); ?></a></th>
-                       <th><?php echo _AT('employer'); ?></th>
+                       <th class="sort"><a href="<?php echo $_SERVER['PHP_SELF']."?col=title".SEP."order=$order".$search_string; ?>"><?php echo _AT('jb_title'); ?></a></th>
+                       <th><?php echo _AT('jb_employer'); ?></th>
                        <th><?php echo _AT('categories'); ?></th>
                        <th class="sort"><a href="<?php echo $_SERVER['PHP_SELF']."?col=created_date".SEP."order=$order".$search_string; ?>"><?php echo _AT('created_date'); ?></a></th>
                        <th class="sort"><a href="<?php echo $_SERVER['PHP_SELF']."?col=closing_date".SEP.SEP."order=$order".$search_string; ?>"><?php echo _AT('jb_closing_date'); ?></a></th>
@@ -50,7 +50,10 @@ if ($search_string!=''){
                                <td><?php echo AT_DATE(_AT("announcement_date_format"), $row['created_date']); ?></td>
                                <td><?php echo AT_DATE(_AT("announcement_date_format"), $row['closing_date']); ?></td>
                        </tr>
-                       <?php endforeach; endif; ?>
+                       <?php endforeach; ?>
+                       <?php else: ?>
+                       <tr><td colspan="6"><?php echo _AT('none_found');?></td></tr>
+                       <?php endif; ?>
                </tbody>
        </table>
 </div>
index c0701f8..5487449 100644 (file)
@@ -26,7 +26,7 @@
        </div>
 
        <div>
-               <label><?php echo _AT('description'); ?></label>
+               <label><?php echo _AT('jb_post_description'); ?></label>
                <p><?php echo $this->job_post['description']; ?></p>
        </div>
 
index 4ff4a7d..3533caa 100644 (file)
@@ -81,7 +81,9 @@ include(AT_INCLUDE_PATH.'header.inc.php');?>
                        }
                        ?>      
                        <a href="<?php echo AT_JB_BASENAME; ?>index.php<?php echo $querystring;?>#" onclick="toggleAdvanceSearch()"><?php echo _AT('jb_search_filter'); ?></a>
-                       <a href="<?php echo AT_JB_BASENAME; ?>index.php?jb_search_general=&jb_submit=Search&jb_search_bookmark=on"><?php echo _AT('jb_bookmark'); ?></a>
+                       <?php if ($_SESSION['member_id'] >= 1): //display bookmark search if it member login.?>
+                       | <a href="<?php echo AT_JB_BASENAME; ?>index.php?jb_search_general=&jb_submit=Search&jb_search_bookmark=on"><?php echo _AT('jb_bookmarks'); ?></a>
+                       <?php endif; ?>
                        <div class="jb_advance_search" style="display: none;">
                        <?php 
                                $savant->assign('job_obj', $job);
index 61433ba..0a5e1d7 100644 (file)
@@ -71,16 +71,17 @@ INSERT INTO `language_text` VALUES ('en', '_module','job_board','Job Board',NOW(
 INSERT INTO `language_text` VALUES ('en', '_module','jb_search','Search',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_search_filter','Search Filters',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_search_filter_blub','Use the following filters to refine your search',NOW(),'');
-INSERT INTO `language_text` VALUES ('en', '_module','jb_subscribe','Subscribe',NOW(),'');
+INSERT INTO `language_text` VALUES ('en', '_module','jb_subscribe','Subscribe to receive new job postings',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_subscribe_blub','Check the categories below to get email notifications when there is a new job post.',NOW(),'');
-INSERT INTO `language_text` VALUES ('en', '_module','jb_title','Title',NOW(),'');
+INSERT INTO `language_text` VALUES ('en', '_module','jb_title','Job Title',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_preferences','Preferences',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_employer','Employer',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_employers','Employers',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_categories','Categories',NOW(),'');
-INSERT INTO `language_text` VALUES ('en', '_module','jb_bookmark','Bookmark',NOW(),'');
+INSERT INTO `language_text` VALUES ('en', '_module','jb_bookmarks','Bookmarks',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_archive','Archive',NOW(),'');
-INSERT INTO `language_text` VALUES ('en', '_module','jb_description','Description',NOW(),'');
+INSERT INTO `language_text` VALUES ('en', '_module','jb_company_description','Company Description',NOW(),'');
+INSERT INTO `language_text` VALUES ('en', '_module','jb_post_description','Description',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_closing_date','Closing Date',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_login','Post a Job',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_logout','Logout',NOW(),'');
@@ -89,11 +90,13 @@ INSERT INTO `language_text` VALUES ('en', '_module','jb_any_categories','Any Cat
 INSERT INTO `language_text` VALUES ('en', '_module','jb_employer_login','Employer Login',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_login_text','Login to manage or post new jobs.',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_login_name','Employer Login Name',NOW(),'');
+INSERT INTO `language_text` VALUES ('en', '_module','jb_employer_name','Employer Name',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_archive','Archive',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_employer_home','Employer Home',NOW(),'');
-INSERT INTO `language_text` VALUES ('en', '_module','jb_add_new_post','Add new post',NOW(),'');
+INSERT INTO `language_text` VALUES ('en', '_module','jb_edit_employer','Edit Employer',NOW(),'');
+INSERT INTO `language_text` VALUES ('en', '_module','jb_add_new_post','Add Job Posting',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_edit_post','Edit Post',NOW(),'');
-INSERT INTO `language_text` VALUES ('en', '_module','jb_view_post','View Post',NOW(),'');
+INSERT INTO `language_text` VALUES ('en', '_module','jb_view_post','View Job Posting',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_edit_profile','Edit Profile',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_is_public','Allow non-ATutor users to see this post',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_no_category','No category',NOW(),'');
@@ -110,7 +113,6 @@ INSERT INTO `language_text` VALUES ('en', '_module','jb_admin_edit_categories_bl
 INSERT INTO `language_text` VALUES ('en', '_module','jb_employer_status_unconfirmed','Unconfirmed',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_employer_status_confirmed','Confirmed',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_employer_status_suspended','Suspended',NOW(),'');
-INSERT INTO `language_text` VALUES ('en', '_module','jb_add_new_post','Add new post',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_email_confirmation_subject','Job Board Email Confirmation',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_email_confirmation_message','You have registered for a job board account on %1s.  Please finish the registration process by confirming your email address by using the following link: %2s.',NOW(),'');
 INSERT INTO `language_text` VALUES ('en', '_module','jb_add_to_cart','Bookmark this post',NOW(),'');