Search found 32 matches

by Qriist
27 Mar 2020, 14:44
Forum: Scripts and Functions
Topic: MemoryFileIO
Replies: 17
Views: 2923

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: 2
Views: 462

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: 2
Views: 462

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. SingleRecordSQL(table,array,upsertkey := "",upsertdiscardkeys := ""){ /* [table] a string containing the na...
by Qriist
26 Feb 2020, 23:08
Forum: Ask For Help
Topic: [Binary files] Convert ReadInts to memory reads.
Replies: 0
Views: 340

[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: 315

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: 206
Views: 57787

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: 206
Views: 57787

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: 206
Views: 57787

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: 206
Views: 57787

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: 206
Views: 57787

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: 206
Views: 57787

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: 206
Views: 57787

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: 3799

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: 3799

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: 3799

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: 3799

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
by Qriist
18 May 2019, 15:17
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 3799

Re: Photobucket bulk downloader

That's strange. I haven't encountered this issue and don't know how to help with that at this time. I just checked and my links download fine - appropriate quality with no watermarks...

Would you paste a couple of the links? Maybe you are grabbing the wrong set. Make sure you have the "Direct" set.
by Qriist
13 May 2019, 03:21
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 3799

Photobucket bulk downloader

This is a script to download manually gathered "direct" links from your photobucket account. Downloading via photobucket itself is... cumbersome. thanks to phaleth for the download(). Usage: 1) Tick any file on photobucket. 2) A "Select All" button in the top right becomes available. Press it. 3) Re...
by Qriist
20 Feb 2019, 19:18
Forum: Ask For Help
Topic: Alternative to iniread
Replies: 5
Views: 873

Re: Alternative to iniread

dang, just came in to say that.

For readability you can do

Code: Select all

states := {1: "AK"
	, 2: "AZ"
	, 3: "AR"
	, 4 : "XY" }
by Qriist
28 Oct 2018, 23:59
Forum: Scripts and Functions
Topic: RecordKill() - easy culling of related records from an array.
Replies: 0
Views: 638

RecordKill() - easy culling of related records from an array.

I had an issue where I had decoded hundreds of thousands of records from a collection of binary files into an array of parsed values, which then would be saved to a JSON - only it would take hours upon hours for my Json class to write the data out. Doing a little investigating I discovered that my a...

Go to advanced search