Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Thu Mar 28, 2024 8:27 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 
Author Message
PostPosted: Wed Nov 07, 2007 4:55 am 
Offline
Newbie

Joined: Thu Nov 01, 2007 8:21 am
Posts: 27
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.


Top
 Profile  
Reply with quote  
PostPosted: Sat Nov 10, 2007 1:32 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1964
Location: Brisbane, Australia
Could people post here with the appropriate words for their language, please.
We can update the SQL to cater for everyone.

_________________
Support and Development hours available from [url=https://opmantek.com]Opmantek[/url].
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Sat Nov 10, 2007 11:37 pm 
Offline
Newbie

Joined: Thu Nov 01, 2007 8:21 am
Posts: 27
why not use lang\*.inc files for that ? :roll:


Top
 Profile  
Reply with quote  
PostPosted: Sun Nov 11, 2007 2:20 am 
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.


Top
  
Reply with quote  
PostPosted: Sun Nov 11, 2007 3:26 am 
Offline
Newbie

Joined: Thu Nov 01, 2007 8:21 am
Posts: 27
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]


Top
 Profile  
Reply with quote  
PostPosted: Sun Nov 11, 2007 4:35 am 
Perhaps a regex that finds (KB******) ? I assume they will one day reach 7 digits, but who knows?


Top
  
Reply with quote  
PostPosted: Sun Nov 11, 2007 5:43 am 
Offline
Newbie

Joined: Thu Nov 01, 2007 8:21 am
Posts: 27
>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:


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group