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 ? :roll:
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 !!! :mrgreen:
Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/