Leaderboard

No need to have a form, just get the input object and set it with _IEFormElementSetValue. I know it is misleading, but should work...

What is the DDL of this table (its CREATE TABLE persons ... statement) ? Also put in plain english what you want and the conditions you put to get the wanted result.

and to the forum @Sergi

It’s just a COM component. It’s fine. Use latest version always

There's a high chance that you are experiencing a "false positive" from your AV software. Have you checked the file attributes to see if you can obtain additional details, such as owner, creation date, last modification date, etc)?

Ok but the #include at top.. there's is 3more files to come with it.. I don't have these files but is it possible for it to create a server on my network then via his PC inject the other files ? Sorry bad English and thanks appreciate it

I won't say with certainty, but the script itself that you posted doesn't seem to be dangerous on its own... it's just a part of a script... there is a copy here: https://github.com/J2TEAM/AutoIt-UDF-Collection/blob/master/Example Scripts/Basic Web Server/ServerOriginal.au3

Ah ok sorry... Well I think someone hack my network at the moment my AV detect a trojan from a autoit script.. I will link the script if anyone can tell me what I can do with it server.au3

You'll probably get more response if you post your question here. How are we supposed to know if we can answer your question if we don't know what the question is first? Also, please keep rule #5 of the forum rules in mind. "5. Do not PM other users asking for support - that is why the forum exists, so post there instead."

Hi, There have been far too many occasions recently where the Mod team have been trying to determine whether a particular thread is legal and a member has posted offering help to the OP. If the Mods are concerned about a thread, please refrain from posting within it - and certainly do not offer anything at all useful - until the all-clear has been given. After this announcement has been posted, we will regard any future instances as unfriendly acts and the poster can expect to be sanctioned - you have been warned. M23

It seems the message has still not got through - the 2 eager beavers who posted in this thread got a week off: And a word to the wise - the next one gets a month. M23

Hi, A quick bump to get this back into view as the prohibition still stands. M23

As it seems that some members do not bother to read the "Announcements" section, I have added the above to the list of prohibited activities in the Forum rules. M23

And just in case you were wondering, we were not joking: M23

AutoIt v3.3.14.5 has been released. Just a small bug fix to the updater script. Download it here. Complete list of changes: History

AutoIt v3.3.14.4 has been released. Thanks to everyone involved, both visible and behind the scenes. Download it here. Complete list of changes: History

AutoIt v3.3.14.3 has been released. Thanks to everyone involved, both visible and behind the scenes. Download it here. Complete list of changes: History

Hi, You may well be getting a warning from your browser that the site SSL certificate has expired - and indeed it has. When Jon last moved server the automatic alert for certificate expiry was not carried over. He is on the case, but it may take a while to get the certificate renewed. In the meantime, nothing has changed here and the site is as secure as it ever was. Our apologies for the inconvenience - we hope things will be back to normal soon. M23

Jon, Now that is what I call fast service! M23

Fixed

Forum upgraded to 4.1.17.1 Please delete your browser cache if you have any problems. 4.1.17.0 Accounts flagged as spammers are now more visibly different on the member list in AdminCP Added quite a few new embed providers codepen.io coub.com deviantart.com docs.com funnyordie.com gettyimages.com iFixit.com kickstarter.com meetup.com mixcloud.com mix.office.com on.aol.com reddit.com reverbnation.com screencast.com screenr.com slideshare.net smugmug.com ustream.tv Google Maps (requires free Google API key) Default location for an AdminCP tab honors the admin's ordering Staff notification emails for tickets in Commerce now include the ticket ID Auto-saved content in the editor will now expire after 48 hours If you load an editor that has previous auto-saved content you will now be prompted to keep or remove it You can now set pre-filled reasons for Warning actions that will automatically populate the member notes editor when a moderator warns a user Escape key will now cancel quick-edit on titles Adds a setting to restrict member birthday view to admins only or to completely disable prompting for birthday to member There are now more "save and reload" options in various places to keep your place when editing content or settings New check all box when viewing activity on a member profile for easier moderation You can now hide posts that are unapproved rather than just approve or delete When a moderator changes the status of a report in the ModCP the system now puts a reply in moderator comments noting the change When you see a "could not write file" error the file it was trying to write now shows in the error logs You can now quickly edit tags when viewing an item without having to edit it if you have permission If you are using multiple devices to login to a site you will be less likely to be logged out Tags can now be quickly edited when viewing an item Administrators can now create custom RSS feeds for various content Enhancements to IP discovery tools for moderators Actions for reports in ModCP now show when status is changed as a comment Redesigned support tool More REST API methods Password strength rating and requirement option Guest terms of service alert Minimum age requirement Ban Filters are now Word Filters and can set words to automatically moderate Display name history is now available on profile view Better analytics integration Leaderboard 4.1.16.0 Large number of bugs fixed in focus areas: Commerce, Pages databases, and IPS Connect Performance improvements in: profile view, sitemap generator, posting replies, and Activity Streams We now try to more reliably detect the AWS S3 endpoint for those using S3 file storage More efficient license key checking to keep the keys from being checked too often which can slow your site down There is now a column in tasks view to show the last time it ran to help diagnostics When a member changes their email or password they now get an email confirmation If group promotion based on date is enable the system will now auto-promote even if a member does not login There is now a setting to change the number of topics per page in the forum view If you move your site to a new URL you no longer have to update a constant if using the image proxy You can now press ctrl/cmd+enter in any editor window to submit the reply In Commerce ticket view there are keyboard shortcuts to perform common actions (such as press 'r' to open reply box or 'n' for note) There is now logic to prevent double-posting when the initial post encounters an error on submit Moderators can now remove all followers from an item Contact Us is now configurable with various options Announcements can now be restricted by member group Admins now have a setting to have members automatically follow content they start or reply to. Members can optionally override this. The editor will now show a message if a link that can be embedded (image, video, etc.) failed to embed for some reason. Admins get more detailed error reasons. If your datastore (cache system) is not working properly the AdminCP will now show you a warning telling you that it needs attention. When a member is banned/suspended the system now shows a more friendly page with information on their ban. Previously it showed a permission denied page. Redesigned ticket listing in Commerce New My History view in Commerce Security Questions for account security 4.1.15.0 Commerce Customer Standing Data now loads via AJAX for faster loading Lots of Commerce related bug fixes Passwords on new hosting accounts are now more secure REST API now supports adding Staff Notes to support requests REST API now supports editing purchases Remember me cookie is now 90 days rather than 7 days A race condition is fixed where the site may call to check the license way more often than needed Performance improvements on activity streams Performance improvement to online list widgets 4.1.14.0 This is a maintenance release to fix reported issues. In addition to a strong focus on overall stability, this release contains: Official PHP 7 support Major performance improvements to Activity Streams 4.1.13.0 New per-group setting to highlight posts made by certain groups. 2 theme settings control the color and border, which are editable in the easy theme editor. New setting to make providing a billing address optional for purchases in Commerce. Personal conversation management improvements: Can now filter personal conversations to just read/unread. Can now move multiple personal conversations into a different folder at once. Can search by recipient/sender name. Notifications about Calendar events now include the event date. New setting to control which images sizes should have a watermark applied in Gallery. New setting to control which IP pool to use for SparkPost if you have purchased dedicated IP addresses. Better handling of upgrades if files have been modified. The sidebar widget for showing Downloads files can now show just free or paid files. When searching templates or CSS files in the AdminCP template editor, it will search for templates or CSS files with a name matching the term provided, in addition to searching the content of them. When viewing a log in the AdminCP, it will now show you on which page the log occurred and by which member. When the search index is being rebuilt, a message is now shown on the search results page to indicate why results may not be complete. The "details" modal for applications and plugins now has a tab which shows the hooks associated with that application or plugin. The placeholders that display on date/time inputs (e.g. "HH:MM") can now be translated. Rebuilding the search index, and rebuilding posts after a 3.x upgrade now processes newest posts first for a more user-friendly experience after upgrading. When a file is deleted, a log is created and a new setting controls how to keep these logs for.

Try this. #include <Excel.au3> Local $sSourceFileXML = "C:\Users\xxx\Desktop\1.xml" Local $sFinalFileXLS = "C:\Users\xxx\Desktop\1.xls" _Convert($sSourceFileXML, $sFinalFileXLS) Func _Convert($sXML, $sXLS) Local $oExcel = _Excel_Open(False) If @error Then Return False Local $oWorkbook = _Excel_BookOpen($oExcel, $sXML) If @error Then _Excel_Close($oExcel) Return False EndIf Local $iResult = _Excel_BookSaveAs($oWorkbook, $sXLS) _Excel_Close($oExcel) Return $iResult EndFunc ;==>_Convert Saludos

Forum updated to 4.0.12.1. Note the search tweak.

Forum upgraded to 4.0.10.2. User / Followed Content wasn't working.

Added a "Post #" indicator at the top right of a post as I know some people like saying "look at post #4" rather than linking.

Added a "Back to Top" button.

Had a bad error during an installation and the forum database got corrupted. I gave up trying to fix it after a couple of hours and have restored this morning's backup. Sorry for the inconvenience.

Some free language packs added for the forum. For French, German, Spanish, Russian and Norwegian. Sorry everyone else, people are charging money for your packs. Edit: Removed these, it made behind the scenes admin really really annoying.

Forum updated to 4.0.8. https://community.invisionpower.com/release-notes/

Removed the geshi code highlighting. It was causing some problems for a few users. No idea why. Edit: Tweaked the code and re-added for testing. Edit: And removed again.

There appears to be a problem uploading .au3 files into the Downloads system. I thought it was mime type related but after some testing I'm fairly certain that it's a weird bug caused by the file extension ending with a numeric. I've reported the bug and the workaround for the time being is upload as .zip.

Since the last upgrade, several members have reported that they cannot get an editor pane when trying to post. There is nothing that can be done at the server end - it seems that this is a cache/browser issue when the editor javascript does not load. The only thing we can suggest is to clear the browser cache and restart the browser. M23

Forum upgraded from 4.0.5.1 to 4.0.6. Release Notes

User notification options appear to have been reset by the upgrade - you will need to reset them. M23

Upgraded to 4.0.5.1 from 4.0.4 - some big backend changes so just checking everything is ok in the background. Release Notes

Forum upgraded to 4.0.4 Release Notes

Because of a forum bug, members have temporarily been prevented from deleting their own posts - so think twice before you hit "Submit Reply". M23

Forum upgraded to v4.0.3 - General bug fixes. Release Notes

Fixed up about 2800 posts and signatures that contained links to other topics that didn't work anymore. The old urls where in the format: http://www.autoitscript.com/forum/index.php?showtopic=80636&view=findpost&p=753962The new: http://www.autoitscript.com/forum/topic/80636-thesaints-toolbox/?do=findComment&comment=753962 

There has been a problem with the conversion of posts that contain backslashes outside of code blocks and they have been stripped out. So this: C:\Program Files\Something Will have become this: C:Program FilesSomething However anything that was using the [ code] or [ autoit] code boxes will be ok (i.e. the really important stuff) because they were processed differently during the upgrade. ; This will have been ok $var = "C:\Program Files\Something"There is no easy way to fix this aside from doing a full rollback to Saturday morning, and as the code boxes are intact I'm not going to do that. I'm going to write some scripts to look for commonly used paths that are used to fix them up, such as: C:\Program Files C:\Windows C:\Windows\System32 C:\Program Files\AutoIt C:\Program Files\AutoIt\Include  

Fixed up broken [ img] tags in signatures. That's all now. If there are still broken signatures they'll have to be fixed manually.

Signatures have been rebuilt but there is a bug so most bbcode still hasn't converted. In the majority of cases if you just open your signature for editing and then save it, it should be ok. Edit: I've run a script to fix up 'color' bbcode in signatures. Still have img and url to do.

We want the forum to be a pleasant place for everyone to discuss AutoIt scripting, and we also want to protect the reputation of AutoIt. So we ask you to respect these simple rules while you are here: Forum Posting 1. Do not ask for help with AutoIt scripts, post links to, or start discussion topics on the following subjects: Malware of any form - trojan, virus, keylogger, spam tool, "joke/spoof" script, etc. Bypassing of security measures - log-in and security dialogs, CAPTCHAs, anti-bot agents, software activation, etc. Automation of software/sites contrary to their EULA (see Reporting bullet below). Launching, automation or script interaction with games or game servers, regardless of the game. Running or injecting any code (in any form) intended to alter the original functionality of another process. Decompilation of AutoIt scripts or details of decompiler software. This list is non-exhaustive - the Moderating team reserve the right to close any thread that they feel is contrary to the ethos of the forum. 2. Do not post material that could be considered pornographic, violent or explicit - or express personal opinions that would not be acceptable in a civilized society. Do not post any copyrighted material unless the copyright is owned by you or by this site. 3. To protect this community, any files posted by you are subject to checks to ensure that they do not contain malware. This includes, but is not limited to, decompilation and reverse engineering. 4. Do not flame or insult other members - and just report the thread to a Moderator (see below) if you are so attacked. 5. Do not PM other users asking for support - that is why the forum exists, so post there instead. 6. Do not create multiple accounts - if you inadvertently created multiple accounts then contact a Moderator to close the unwanted ones. 7. Do not repost the same question if the previous thread has been locked - particularly if you merely reword the question to get around one of the prohibitions listed above. 8. Do not delete your posts, nor completely remove their content, if doing so will interrupt the flow of the thread. 9. Do not post in a thread while the Moderating team are actively trying to determine whether it is legal. The Moderation team will do their best to act in fair and reasonable manner. Sanctions will only be applied as a last resort and any action taken will be explained in the relevant thread. If moderation action is taken, you will need to acknowledge this through a dialog or you will be unable to post further in the forum. Please note that this dialog is not an agreement that the warning was justified - it is only there so that members are aware that moderation action has been taken and that they may have certain restrictions applied to their account. If you feel that you have been unfairly moderated then contact the Moderator concerned - using a PM or the "Report" button is preferable to opening a new thread (although new members may have to do this). But do be aware that the Moderation team has the final word - the rules are set out by the site owner and you are only welcome here if you respect his wishes. Signatures and Avatars There is no formal policy for the use of signatures but if a moderator thinks it is too big and/or distracting then you may be asked to tone it down. No-one likes wading through signatures that are a page high. Similarly for avatars, expect distracting flashing and animated gifs to be removed. Reporting If you feel a post needs Moderator attention, please use the "Report" button next to the post date at the top. You can then enter details of why you have reported the post - but there is no need to include the content of the post as that is done automatically. The Moderating team will be alerted to the post and will deal with it as soon as they can. If you suspect a EULA violation, do not expect the Moderating team to do all the work - please provide some evidence in the report such as a copy of (or link to) the EULA in question, as well as the section you believe has been violated. Finally, please do not enter into an argument with the original poster - that is why we have Moderators. Spam Please do not react to spam in any way other than reporting it. Multiple reports are combined by the forum software, so there is no need to announce that you have reported the spam - in fact doing so only increases the work for the Moderator who deals with it. Interacting with this website Anyone found abusing the website is subject to harsh punishment without warning. A non-exhaustive list of potential abuses include: Automated forum registration or login. Automated posting or sending messages on the forum. Automated manipulation of polls, user reputation or other forum features. Automated creation or comments on issue tracker tickets. Automated creation or editing of wiki pages. Other abuses which are either examples of excessive bandwidth usage or automation of the site. Use common sense. If you do not have common sense, don't do anything. Do not automate the forum, wiki or issue tracker in any way at all. Scripts which automatically update AutoIt such as AutoUpdateIt are acceptable as long as they are not abused and do not generate excessive bandwidth usage.

The irony is that I'm not entirely sure that this topic doesn't infringe on the last point of having a google trademark in the URL. I hope it means the domain name url part and not anything else ...

You are responsible for the content you post on this site. Most of the site is a public forum and the private sections have only limited controls over those who can access them - this is particularly true of "Chat". So treat posting here as if you were speaking in a crowded room surrounded by strangers. Recent high-profile defamation events on other sites illustrate that there are ways in which third parties can force personal data, including contents of personal messages, to be released by site owners. Be careful - libelous/defamatory posts can and have landed members of these other sites in legal hot water. Your anonymity is not guaranteed in such situations. M23

The Forum Rules specifically mention that "keyloggers" are a prohibited subject on this forum. Of late we have had several threads locked because they have strayed (usually unwittingly) into keylogger territory. Here is a reminder of what Jon (the site owner) has set out as the basis for acceptability: "how to check for a few keys being pressed is one thing" We are not going to define "a few" in absolute terms, but if you post any code which checks for the best part of the keyboard you can be absolutely sure that you are in breach of the rules, that your thread will be locked, and that sanctions may follow. So please do not post such scripts - we do not want to be heavy-handed, but after this announcement your excuses had better be very good ones! M23

Previously when code which was (or could very easily be converted to) a keylogger has appeared on the forum I have limited my actions to deleting the code and warning the poster. I even went to the trouble to post the above announcement so there could be no doubt as to the fact that such code was not permitted here. Yesterday I had to remove code which checked the entire keyboard and lit up the pressed key on a "virtual keyboard" GUI. Note that the post above talks of "code which checks for the best part of the keyboard" - that is exactly what this code did and with the addition of a few lines it could easily have been turned into a crude, but entirely workable, keylogger. The poster is now enjoying a short holiday - and the same fate awaits anyone else who posts similar code in future. The prohibitions in the Forum rules are there to keep this forum clean and to protect the reputation of AutoIt - which is in the interests of us all. Please use your brains and do not post code which flouts the spirit, if not the exact letter, of the rules. If you do then do not complain if you are moderated and warned. M23

I use the following code written by Spiff58 to convert numbers into columns. ; =============================================================================================================================== ; Convert column numbers to excel column letters ; Written by Spiff59 ; http://www.autoitscript.com/forum/index.php?showtopic=115665 ; =============================================================================================================================== Func _ExcelColumnLetter($iColumn = 0) Local $letters While $iColumn $x = Mod($iColumn, 26) If $x = 0 Then $x = 26 $letters = Chr($x + 64) & $letters $iColumn = ($iColumn - $x) / 26 WEnd Return $letters EndFunc

Open console then type "hack -n PERSONTOHACK -hide -override"All done

User Groups and Rights New Members - New members with that joined the forum within the last day. While in this group there are certain restrictions on the number of posts/PMs that can be made. This is to reduce the impact of spammers. After 24 hours members of this group will be promoted the Members group. Members - Members older than one day but with less than 20 posts. Standard access to the forum. Active Members - Members with more than 20 posts have additional rights No advertsSlightly more generous attachment and PM limitsAccess to the Chat forumAbility to upload files to the Downloads section MVPs - Members who are judged by the community to be helpful, who write and share useful code, who help the development of AutoIt. These users have the same rights as normal members but get a team icon, a little more attachment and PM space, and access to the MVP Chat forum section. Moderators - The forum police. This is not a democracy and each of the mods has their own distinct personality. They have the rights to edit posts, delete posts, ban users, delete users, IP ban, etc. Let the poster beware. Developers - A small group of users with access to the AutoIt source code and who have contributed significantly to the internal development of AutoIt. Some of them are also Moderators. Post Count and Rankings Ranks based on increasing post count are as follows: SeekerWayfarerAdventurerProdigyPolymathUniversalistThese titles are auto-generated and have no relation to actual skill level. Once you reach 300 posts you can change the title to whatever you like.