Search found 36 matches

by Qriist
24 Oct 2020, 19:28
Forum: Ask For Help
Topic: optimization of a (x) ? != : ==
Replies: 15
Views: 2490

Re: optimization of a (x) ? != : ==

well after testing; using Return in the middle of the loop isn't working with my version of AHK. There must be some fault in your testing or your logic. There is no difference between returning from inside a loop and returning immediately after breaking out of the loop. She's using a decade old ver...
by Qriist
15 Oct 2020, 12:59
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-12-12
Replies: 228
Views: 69020

Re: [Class] SQLiteDB - Update on 2019-12-12

hasantr the array IS an object. You can use the following code to visualize the data: DB := new SQLiteDB DB.openDB(path_to_your_database) DB.GetTable(your_sql_query, output_table) ;view entire result data including the "administrative" info msgbox % st_printarr(output_table) ;view one row at a time...
by Qriist
15 Sep 2020, 05:22
Forum: Ask For Help
Topic: IE COM help
Replies: 1
Views: 62

IE COM help

Hey there, I have a strange issue trying to grab a specific selector. The issue only appears with AHK, I can manually select it in the browser console. full code used right now: #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. ; #Warn ; Enable warnings to assis...
by Qriist
27 Mar 2020, 14:44
Forum: Scripts and Functions
Topic: MemoryFileIO
Replies: 17
Views: 3519

Re: MemoryFileIO

Hey this is great! In terms of usage I only need to change one line, right? Example: (Full example function: https://github.com/Qriist/Digest/blob/master/lib/Digest_Bin_110f_levels.ahk ) Digest_Bin_110f_levels(BinToDecompile) ;BinToDecompile = complete filepath { global Bin := FileOpen(BinToDecompil...
by Qriist
23 Mar 2020, 23:31
Forum: Scripts and Functions
Topic: SingleRecordSQL() - Generate all SQL for inserting or upserting a flat array
Replies: 3
Views: 764

Re: SingleRecordSQL() - Generate all SQL for inserting or upserting a flat array

burque505 wrote:
22 Mar 2020, 10:01
s
Huh, how'd that get there? lol
Fixed.


Glad you like it! :D
by Qriist
21 Mar 2020, 15:48
Forum: Scripts and Functions
Topic: SingleRecordSQL() - Generate all SQL for inserting or upserting a flat array
Replies: 3
Views: 764

SingleRecordSQL() - Generate all SQL for inserting or upserting a flat array

Hello! This simple-to-use SQLite function is meant to ease iterating over a large array of data, especially data from APIs that may not return a consistent set of keys between different calls. UPDATE 2020-10-12 -Added noWrap and upsertValidation as parameters -couple misc bugfixes SingleRecordSQL(ta...
by Qriist
26 Feb 2020, 23:08
Forum: Ask For Help
Topic: [Binary files] Convert ReadInts to memory reads.
Replies: 0
Views: 456

[Binary files] Convert ReadInts to memory reads.

So first and foremost this is working code. It already does what I want. I'm looking for optimization. I have never dealt with direct memory access, which I know is needed for binary files. Essentially, what do I need to change to move from a huge series of Read/ReadU[Char|Int|Short|Long] operations...
by Qriist
30 Jan 2020, 17:44
Forum: Gaming
Topic: Diablo 2 - need hep with simple script
Replies: 2
Views: 411

Re: Diablo 2 - need hep with simple script

Also try the other send modes.
by Qriist
08 Oct 2019, 10:48
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-12-12
Replies: 228
Views: 69020

Re: [Class] SQLiteDB - Update on 2019-07-12

kczx3 wrote:
08 Oct 2019, 10:27
So you're still having the problem though?
Nope! All is well. Not a library issue at all.
by Qriist
08 Oct 2019, 09:35
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-12-12
Replies: 228
Views: 69020

Re: [Class] SQLiteDB - Update on 2019-07-12

Two notes: AFAICS user_id_str is defined only for the table tweets . Yep, that was the issue. Revamped the code and all is well. Reform.query(query) <<<<< ????? I was trying a lot of things trying to figure out what was going on. revamped code: for k,v in tableset { QUERY .= "INSERT OR IGNORE INTO ...
by Qriist
07 Oct 2019, 21:19
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-12-12
Replies: 228
Views: 69020

Re: [Class] SQLiteDB - Update on 2019-07-12

As a workaround I guess I can export the dB to a third temporary dB and delete all records that aren't the present Id, then import THAT. would be slow but effective, I guess.
by Qriist
07 Oct 2019, 21:10
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-12-12
Replies: 228
Views: 69020

Re: [Class] SQLiteDB - Update on 2019-07-12

schema of dB with my pragma edits afterwards. The attached is a compilation of recent tweets with the word SQLite. It Is a nonsensitive representative of my dataset. What want is to separate into different external databases based on user_id_str. I'm annoyed because it feels like I'm doing it right....
by Qriist
07 Oct 2019, 20:52
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-12-12
Replies: 228
Views: 69020

Re: [Class] SQLiteDB - Update on 2019-07-12

No error, just a silent abort, I guess. @kczx3

I'll post a sample here shortly, along with the CreateDB schema it uses
by Qriist
07 Oct 2019, 19:39
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-12-12
Replies: 228
Views: 69020

Re: [Class] SQLiteDB - Update on 2019-07-12

no, it's from the main attached DB @kczx3

It's literally the WHERE clause causing the fail.
by Qriist
07 Oct 2019, 19:22
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-12-12
Replies: 228
Views: 69020

Re: [Class] SQLiteDB - Update on 2019-07-12

EDIT: NOT A LIBRARY ISSUE. just me I'm having a spot of trouble trying to do database exports. First of all, I'm using this as guide. I confirm the code works in SQLite Studio. So here's the issue: I'm trying to "cut up" some databases for other processing. I'm trying to sort them out based on a sp...
by Qriist
31 Jul 2019, 19:35
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 4475

Re: Photobucket bulk downloader

A big big thank to you, Qriist ! Just observed something very interesting, and be useful to you - when using the script / pb.txt as is, all exif info are removed from the resulting files. However, adding an "o" in the URLs - as in my case from "i12.photobucket.com" to "oi12.photobucket.com" does th...
by Qriist
31 Jul 2019, 19:31
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 4475

Re: Photobucket bulk downloader

You are running an AHK version that is 9 years old yet it is my script that is wrong? That's chuckle-worthy.

Try using the compiled version in the attachment.
by Qriist
19 May 2019, 12:42
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 4475

Re: Photobucket bulk downloader

@DavidJHowe Try this new version. Should solve the issue! :)
by Qriist
19 May 2019, 09:52
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 4475

Re: Photobucket bulk downloader

I tried those links, they do indeed download with watermarks. Let me do some research. Can't for a few hours though. While you wait, go ahead and try the methods found at https gist.github.com /philipjewell/a9e1eae2d999a2529a08c15b06deb13d Broken Link for safety

Go to advanced search