Open-AudIT https://www.open-audit.org/phpBB3/ |
|
incomplete hot fix list with other translation https://www.open-audit.org/phpBB3/viewtopic.php?f=5&t=2465 |
Page 1 of 1 |
Author: | exmachina [ Wed Nov 07, 2007 4:55 am ] |
Post subject: | incomplete hot fix list with other translation |
hi, just a suggestion : in file : list_viewdef_all_hotfixes_patches.php and list_viewdef_hotfixes_patches_for_system.php sql query begin look like this : [code]SELECT count(software_name) AS software_count, software_name, software_version, software_publisher, software_url FROM software, system where (software_name LIKE '%hotfix%' OR software_name LIKE '%update%' OR software_name LIKE '%Service Pack%') [/code] and its works... but other country "hotfix" is called with another name. for example in french : hotfix = Correctif Service pack = Service pack 'ok its same update = Mise à Jour for a complete hotfix listing in french sql query must begin like this : [code]SELECT count(software_name) AS software_count, software_name, software_version, software_publisher, software_url FROM software, system where (software_name LIKE '%hotfix%' OR software_name LIKE '%update%' OR software_name LIKE '%Service Pack%'OR software_name LIKE '%Correctif%'OR software_name LIKE '%Mise %') [/code] that's all. one more things : sorry for my poor english. |
Author: | Mark [ Sat Nov 10, 2007 1:32 pm ] |
Post subject: | Re: incomplete hot fix list with other translation |
Could people post here with the appropriate words for their language, please. We can update the SQL to cater for everyone. |
Author: | exmachina [ Sat Nov 10, 2007 11:37 pm ] |
Post subject: | Re: incomplete hot fix list with other translation |
why not use lang\*.inc files for that ? |
Author: | mikeyrb [ Sun Nov 11, 2007 2:20 am ] |
Post subject: | Re: incomplete hot fix list with other translation |
The problem with that is it would assume that the language of the user is the same as all the computers used. That is not completely likely. |
Author: | exmachina [ Sun Nov 11, 2007 3:26 am ] |
Post subject: | Re: incomplete hot fix list with other translation |
ok, it's an excellent answer. why not use KB reference like that ? [code]SELECT count(software_name) AS software_count, software_name, software_version, software_publisher, software_url FROM software, system where (software_name LIKE '%KB%') [/code] microsoft KB reference are international ? [img]http://img134.imageshack.us/img134/6834/kbrefiv7.jpg[/img] |
Author: | mikeyrb [ Sun Nov 11, 2007 4:35 am ] |
Post subject: | Re: incomplete hot fix list with other translation |
Perhaps a regex that finds (KB******) ? I assume they will one day reach 7 digits, but who knows? |
Author: | exmachina [ Sun Nov 11, 2007 5:43 am ] |
Post subject: | Re: incomplete hot fix list with other translation |
>I assume they will one day reach 7 digits, but who knows? why this limit ? try that : [code][KQ]B[1-9]{6,}[/code] Ready for billion of hotfix !!! |
Page 1 of 1 | All times are UTC + 10 hours |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |