Digi

Hey Guys / Girls, Im Going to Start on this seeming as I cant seem to find anyone working on something like it here. I want to get a little Applet created that can check various things and Generate a BASIC report on it. This is just to help my life monitoring servers. All the Applet will do is as follows. It will check Services, What state they are in and what the startup Value is. Free disk space on the system Uptime And if somehow possible I want to include Patches loaded on Windows and SQL Server. Anyways, If someone has something already that can do some or all of these? let me know please thanks a Ton - Digi

Hi Guys / Girls Heres a random Idea I have had, I have started working with SQL and MYSQL recently and today got a statment a user made that was HUGE. So had a search for a application or something I could past the statment into and just easily see what the databases it was selecting were, etc... without having to read through it... trust me it was a LOOOOOOOOOONG statment. Had a look around here but didnt see anything like that, So im going to try make a little app that will read the pasted SQL statment. give 3 listings 1, a basic overview of what is selected. 2 from what tables, 3 what restrictions / limitations are also placed. so select options from tables where restrictions =-like 'bob' O_o lol not right I know but you get the Idea. Before I start wanted to know if anyone else thinks this is a good idea, or if you know of something that will do it, pass me the name etc... also if you like the idea, what else you want to see in it? remember basic interpritation application nothing major. not yet anyway lol

Thanks

Hey Guys / Girls, Firstly I do appologise for posting this in the wrong place if it is. But any ways here we go. I somehow think that this is seriously using AutoIT for the wrong reasons But my programming skills are Skitish at best. So I'm hoping that people can help me out and Maybe suggest other languages with some how to guides if need be What I want to Create is a LAN Party managment tool. I know there are a few online that allow for HTML access etc etc. but those are more general managment (ALP is one such tool) What I want is more of a ADMIN managment tool. What I would like to add to it is as follows: Seating Managment: This would allow you to Set firstly GRID Size (size of your Venue Width and Length) Grid Customization (Should your venue have a ARB shape (Not squared etc..) then you can place Dead markers(none working are points) to shape it better. Table layout - this means you would be able to say this is a table and have a few options on it. (seats 2, Admin, Servers, Hub, seats 1 etc etc) and each having a different color or Graphic. Occupied and open markers. Registration: Database that would be updated and used to register players - Details such as (name, surname, nick, cell, email, etc) this would also need to be a database that can be backed up to some format that can be imported again. (If this could use something like Mysql or something that would prob be best im thinking.) Comp managment: Basic managment - Create a comp specify prizes etc for each placement (No of prizes given to how many placments should be user defined) Player registration (Nicks should be used) Anyways thats the basics im looking to do. And like I say im gonna need a ton of help because I'm not 100% sure how I'm going to do some of these. So heres hoping that 1 its doable and 2 peeps are feeling like giving a hand Or at the very least someone can suggest a better app to do this with Cheers and thanks Guys / Girls -Digi

Yea the Emails would fire for the same serverlisting. To give you a practical example and why im using this. I have a Webserver,Fileserver and Backup server thats running on my network, but being as busy as I am, I cant always monitor them. Now I'd like that Myself and the rest of my team get a Email notification to our personal mail addresses and our work addresses so we can action it more effectively. I cant configure a mail forwarder that could just forward to everyone and I would like that it was just configured on a simple file (The ini file in this case.) And thanks for the Suggest on the Responce checking. Busy testing it to see if it working

Hey there Guys / Girls I was looking around for a PING responce applet and I managed to find this post by mbknows Online and Offline servers ping or not to ping! there were 2 or 3 errors I had and managed to correct. The problem I'm having though is I cant add multiple Email addresses to the applet. the other thing I want to do is only get it to mail out once it has 4 or 5 consecutive none responce pings. Thanks to anyone that can help out And even more so if anyone has a better applet hehehehe Heres the Coding Im using now. #include <file.au3> #include <INet.au3> #include <Array.au3> Dim $Pulltxtfilelist, $num, $CurrentOffline, $RunForever, $Body[1] $INIFULLPATH = @ScriptDir & "\Settings.ini" $TMPDATSTORE = @ScriptDir & "\temp.dat" FileDelete($TMPDATSTORE) IniWrite($TMPDATSTORE, "Offline", "","") IniWrite($TMPDATSTORE, "Online", "","") $SmtpServer = IniRead($INIFULLPATH, "Email Setup", "SMTPServer", "Default") $FromName = IniRead($INIFULLPATH, "Email Setup", "EmailFromName", "Default") $FromAddress = IniRead($INIFULLPATH, "Email Setup", "EmailFromAddress", "Default") $ToAddress = IniRead($INIFULLPATH, "Email Setup", "EmailToAddress", "Default") $Subject = IniRead($INIFULLPATH, "Email Setup", "EmailSubject", "Default") $Delay = IniRead($INIFULLPATH, "Setup", "EmailOutDelaySeconds", "30") If Not _FileReadToArray(@ScriptDir & "\ServerList.txt", $Pulltxtfilelist) Then MsgBox(4096, "Error", "ServersList.txt is not found please create and restart service. error:" & @error) Exit EndIf For $x = 1 To $Pulltxtfilelist[0] $num = $num + 1 $pingerror = Ping($Pulltxtfilelist[$x]) If $pingerror Then IniWrite($TMPDATSTORE, "Online", $num, $Pulltxtfilelist[$x]) EndIf If $pingerror = 0 Then IniWrite($TMPDATSTORE, "Offline", $num, $Pulltxtfilelist[$x]) Dim $Body[1] $Body[0] = $Pulltxtfilelist[$x] & " Server has not responded on last Ping. Please note that this is Just a test." $Response = _INetSmtpMail($SmtpServer, $FromName, $FromAddress, $ToAddress, $Subject, $Body, "", -1) EndIf Next Do Sleep($Delay) $OfflineCheck = IniReadSection($TMPDATSTORE, "Offline") If @error Then Else For $i = 1 To $OfflineCheck[0][0] $pingerror = Ping($OfflineCheck[$i][1]) If $pingerror = 0 Then Else IniDelete($TMPDATSTORE, "Offline", $OfflineCheck[$i][0]) IniWrite($TMPDATSTORE, "Online", $OfflineCheck[$i][0], $OfflineCheck[$i][1]) $Body[0] = $OfflineCheck[$i][1] & " Server is responding to Pings once again." $Response = _INetSmtpMail($SmtpServer, $FromName, $FromAddress, $ToAddress, $Subject, $Body, "", -1) EndIf Next EndIf $CurrentOffline = "" For $l = 1 To $OfflineCheck[0][0] $CurrentOffline = $CurrentOffline & @CRLF & $OfflineCheck[$l][1] Next $OnlineCheck = IniReadSection($TMPDATSTORE, "Online") If @error Then Else For $i = 1 To $OnlineCheck[0][0] $pingerror = Ping($OnlineCheck[$i][1]) If $pingerror = 0 Then Sleep(1000) $pingerror2 = Ping($OnlineCheck[$i][1]) ; msgbox(4096, "", $pingerror2) If $pingerror2 = 0 Then IniDelete($TMPDATSTORE, "Online", $OnlineCheck[$i][0]) IniWrite($TMPDATSTORE, "Offline", $OnlineCheck[$i][0], $OnlineCheck[$i][1]) Dim $Body[3] $Body[0] = $OnlineCheck[$i][1] & " Server has not responded on last Ping. Please note that this is Just a test." $CurrentOffline = $CurrentOffline & @CRLF & $OnlineCheck[$i][1] $Body[1] = @CRLF $Body[2] = "Server Outage List:" & @CRLF & $CurrentOffline $Response = _INetSmtpMail($SmtpServer, $FromName, $FromAddress, $ToAddress, $Subject, $Body, "", -1) EndIf EndIf Next EndIf Until $RunForever = 100

Update: 26 Downloads Of this Little Applet. Great to see people Enjoying it, Im on a standby Machine at the moment I have done a few Coding CleanUps and a few other things, Ill be Uploading soon as my new System is up and Running 100% Should hopefully be the end of the week, Im still going through the Embedding stuffs and I have done another Variant a Click run or leave and Run applet. It was a request from a Friend of mine so figured ill post it for all aswell. Z's UDP for the PNG images seems to work but busy looking at a few small things looks like its doing what i was worried about, Changing the image to BMP and Filling in the Void space (Blank Area) with the Edges of the Image. But I'm still hopefull Z's coding skills are above mine and trying to figure everything out is straining my Brain a little but im sure ill get it eventually. But otherwise, Thanks again to everyone that has assisted with the Development of my lil pet project and thanks to those that have given Positive Feedback and the Negatives that have forced me to Progress the development of stupid lil things, IE the no Icon in taskBar (BTW i will be posting the final version with that option enabled in the Compiled script, it was being used for Trouble shooting in the Beta stages and ill have a Final Release with it enabled for those that do like it.) Please Drop me a mail if there are Features And/Or other things you want to have added or refined a lil and ill look into it. And believe me there are no stupid requests just lack of the knowladge to accomplish your Goal.......(Budda eat your heart out hahahaha ) but remember half this stuff im learning as i go to start with so you may even figure it out before me Thanks again to AutoIT , Zedna , redsleeves (his lil enhance) , simphax, Lod3a You all helped Heeps. (If i dont get any requests for enhancements i will post the Final Releases in Mid June about the 14th or 15th with everything I hope, Gives me time to work out the Embedding thing and if not then ill release that one in a Beta stage afterwards.)

Hey Guys/Girls Z has updated his UDP with embedding options for PNG etc, Im busy trying to figure out if everything is working correctly. and how to incorporate everything correctly. - Digi

Hey Guys / Girls i have looked at a ton of stuff, All the things continually convert the images PNG to a BMP like format, Filling in the Blank areas of the image with the Edge colors of the image loaded. Im still going through it though to try organise how to do a embedded form of this lil applet. Im also still looking at a lil GUI option to do all the setting up and everything, I have just been seriously sick and havent spent much time on it. But nice to see peeps enjoying the applet so far L:D Keep checking for updates

hahaha sorry never saw the post yesterday i prefer having the icon there myself but yea for those that want it its useful THX simphax. OH I got hold of the developer of reshack and asked him about the PNG issue, Direct quote "NO it cant" i asked if there was any way to store the PNG, there are before anyone bites my head off, BUT when the PNG is loaded into a resource using reshack, reshack changes the image into a BMP based image, which for my use is a step backwards. He did however point me to a friend of his that was working on a similar program that apparently has alot more freedome including full length AVI adding and he said that the one big thing he was working on is PNG and maintainging a PNG format in the file its embedded. I got hold of him and he said his app is freeware so im looking at how to get it and AutoIT working together. So looks like im 1 step closer to the embedding files thing. Edit: Oh BTW The reason im not using the BMP approach i was looking at when i first started was Purely Quality, I can have a much higher quality image with alpha blending etc with a PNG where i cant have on a BMP, the BMP or JPEG for that matter always come out pixelated along the edges which im trying to avoid.

Hey guys and Girls just a Update for everyone wanting the Final Beta release (Adding Embedding) So far im just looking at the limitations of things like reshack etc, the problem is all development has stopped on reshack(encase you didnt know) and from the looks of it there isnt a capability to embed a PNG image without the applet trying to change it to a Bitmap or Jpeg, Im still looking into it though, and looking for other applets that might be able to do the same thing and work with AutoIT without to much fuss. Ill keep everyone updated with Details as i get new info..... If anyone figures it out before me PLEASE let me know its annoying as *BLEEP* trying to lol

Hey Guys / Girls I have managed to Write a Manual for using and editing the little Applet, I have also Updated the coding making it easier to use and work with, there are comments everywhere on whats happening. Digi's Splash (Beta 5) Theres the link to 5 Files, Basic Splash - Display 3 sec.ZIP Splash - Click on GUI & Position.ZIP Splash - Click on GUI (Centre).ZIP Splash - Start PortableAppMenu & Position.ZIP Splash - Start PortableAppMenu (Centre).ZIP Hope everyone finds what they want and need. and would like to know who uses and what peeps think. Thanks to everyone so far that have assisted in the coding and getting it a little more User friendly and usefull. Specifically to Lor3n - PNG Scripting assist and Idea. Simphax - For a lil help with the Click start app command And of course the AutoIT Crew For all the assist

Oh for interest Sake So far there are 9 Downloads of Splash Beta 4 6 Downloads of PortableApps Splash (Alpha) Nice to know people using it

WOHOO Hey Nice Simphax thx lol was going to have a look at it, but been busy as anything here, Ill update and replace the Files on my Share. I have also cleaned up the Scripting, There was alot of data i was using in early verions that im no longer using so removed. So ---> Splash with Click And position (No help Doc).zip Is this Version, So far Working. All scripting Cleaned Up. I will be Updating all the other Scriptings with the cleaned coding aswell. Please Note this is now Beta5 releases of the Little App, and i will be going back to the Original Coding seeing what enhancements I can add. For the Position one I will write a new Help Doc with instructions on how to position the flash wherever you want. And for those wanting how to change the Starting Application. Im still working on the TRUCrypt coding, mounting a device isn't as easy as I hoped in this case. Ill also be posting a change History in the next update, and the Downloads will also have just for interest sake. Simphax will also get a lil credit for the Help on coding. :D

um.... there a lil problem...... if you click anywhere then it will run the RunApp function....... im working on how to get it only to accept it within the Image........ Soz.... Will get the next version up soon as I can.