Index: trunk/tools/phrase_locator.php
===================================================================
diff -u -N
--- trunk/tools/phrase_locator.php	(revision 0)
+++ trunk/tools/phrase_locator.php	(revision 882)
@@ -0,0 +1,78 @@
+<?php
+	define('DB_USER','dev');
+	define('DB_PASS','dev-25-sql');
+	define('DB_HOST','localhost');
+	define('DB_BASE','alex_in_portal');
+	define('DB_PREFIX', 'Prefix_');
+	
+	$dir = '/www/alex/in-portal/';
+	$phrases = Array();
+	
+	scanDir($dir);
+	
+	function scanDir($FolderPath)
+	{
+		global $phrases;
+		$FolderHandle = opendir($FolderPath);
+		if($FolderHandle)
+		{
+			while( false !== ($file = readdir($FolderHandle)) )
+			{
+				if( $file == '.' || $file == '..' ) continue;
+				$file = $FolderPath.$file;
+				
+				if( is_dir($file) )
+				{
+					scanDir($file.'/');	
+				}
+				elseif( is_file($file) &&  in_array(substr($file,strrpos($file, '.') + 1), Array('php','js','tpl')) )
+				{
+					$filedata = file_get_contents($file);
+					preg_match_all('/\'(lu_.*|la_.*)\'/U',$filedata,$rets);
+					foreach ($rets[1] as $phrase_name) {
+						$phrases[strtolower($phrase_name)] = 1;
+					}
+					
+					preg_match_all('/"(lu_.*|la_.*)"/U',$filedata,$rets);
+					foreach ($rets[1] as $phrase_name) {
+						$phrases[strtolower($phrase_name)] = 1;
+					}
+				
+				}
+			}
+			closedir($FolderHandle);
+		}
+	}
+	//print_r($phrases);
+	
+	$mysql_link = mysql_connect(DB_HOST,DB_USER,DB_PASS);
+	mysql_select_db(DB_BASE,$mysql_link);
+	
+	$sql = 'SELECT LOWER(Phrase) AS Phrase FROM '.DB_PREFIX.'Phrase WHERE LanguageId = 1';
+	$rs = mysql_query($sql,$mysql_link);
+	while( ($row = mysql_fetch_array($rs)) )
+	{
+		unset($phrases[ $row['Phrase'] ]); // phrase is translated
+	}
+	mysql_free_result($rs);
+	
+	$ret = Array();
+	foreach($phrases as $phrase => $dummy_value)
+	{
+		$ret[] = $phrase;
+	}
+	
+	print_pre($ret);
+	
+	$fp = fopen($dir.'new_phrases.txt','w');
+	foreach ($ret as $phrase)
+	{
+		fwrite($fp,$phrase."\n");	
+	}
+	fclose($fp);
+	
+	function print_pre($s)
+	{
+		echo '<pre>',print_r($s,true),'</pre>';
+	}
+?>
\ No newline at end of file
Index: trunk/new_phrases.txt
===================================================================
diff -u -N
--- trunk/new_phrases.txt	(revision 0)
+++ trunk/new_phrases.txt	(revision 882)
@@ -0,0 +1,135 @@
+la_help_in_progress
+la_text_advanced
+la_title_sendmailcancel
+la_prevgroup
+la_nextgroup
+la_permtype_$permmodule
+la_ban_login
+la_ban_email
+la_ban_ip
+la_title_searchresults
+la_restore_file_not_found
+la_restore_access_denied
+la_restore_file_error
+la_restore_read_error
+la_restore_unknown_error
+la_tooltip_save
+la_tooltip_close
+la_text_datatype_
+la_text_custom
+la_text_multipleshow
+la_prompt_multipleshow
+la_text_prerequisit_not_passed
+la_prevcategory
+la_nextcategory
+la_text_
+la_tooltip_previousstep
+la_tooltip_nextstep
+la_tooltip_cancel
+la_description_
+la_tab_modules
+la_title_select_item
+la_title_select_target_item
+la_prompt_movedown
+la_prompt_moveup
+la_prompt_delete
+la_prompt_edit
+lu_cookies_error
+lu_ferror_reset_denied
+lu_subscribe_banned
+lu_subscribe_unknown_error
+lu_subscribe_success
+lu_subscribe_missing_address
+lu_ferror_pswd_mismatch
+lu_ferror_pswd_toolong
+lu_ferror_m_profile_userid
+lu_ferror_no_access
+lu_ferror_wrongtype
+lu_ferror_toolarge
+la_review_alreadyreviewed
+la_review_added
+la_review_pending
+la_review_error
+la_configerror_review
+lu_already_suggested 
+lu_keywords_tooshort
+lu_hello_world
+lu_searchtitle_
+lu_unknown_error
+lu_guest
+lu_profile_field
+lu_
+la_text_denied
+la_text_quicklinks
+la_by_theme
+la_front_end
+la_admin
+la_text_types
+la_prompt_all_templates
+la_prompt_parent_templates
+la_rootpass_verify_error
+la_tab_taglibrary
+la_tab_userban
+la_title_edit_ban
+la_title_category_relationselect
+la_title_category_select
+la_title_groupselect
+la_title_userselect
+la_tab_label
+la_title_label
+la_title_sendmail
+lu_read_error
+lu_no_template_error
+lu_favorite
+la_desc_emailevent_
+la_text_address_denied
+la_error_move_subcategory
+lu_close
+lu_pm_list_description
+lu_rate_access_denied
+lu_edittopic_confirm_pending
+lu_edittopic_confirm_pending_text
+lu_privatemessages_updated
+lu_my_topic_favorites
+lu_forgotpw_confirm_reset
+lu_forgotpw_confirm_text_reset
+lu_link_addreview_confirm_pending_text
+lu_review_access_denied
+lu_modifylink_pending_confirm
+lu_modifylink_pending_confirm_text
+lu_my_link_favorites
+lu_new_news
+lu_new_articles
+lu_related_articles
+lu_news_review_confirm_pending
+lu_news_addreview_confirm__pending_text
+lu_news_search_results
+lu_enlarge_picture
+lu_confirm
+lu_confirmation_title
+lu_confirm_subtitle
+lu_confirm_text
+lu_favorite_denied
+lu_register_autopasswd
+lu_modified
+lu_expires
+lu_no_expiration
+lu_rating_alreadyvoted
+la_origional_value
+la_inlink
+la_tooltip_setprimary
+la_tab_inlinkimport
+la_error_unknown_category
+la_rating_alreadyvoted
+la_vote_added
+la_text_leading
+lu_recipent_required
+lu_recipient_doesnt_exit
+la_no_topics
+la_original_values
+la_tab_phpbbimport
+lu_btn_newtopic
+lu_ferror_
+la_bytes
+la_gigabytes
+la_terabytes