Ninjastic.space - BitcoinTalk Post/Address archive + API

[fillippone]

<...>

The only thing to think about is: usually user change names for a reason.
Maybe The BeardedBAby likes to be linked to his old account, and having all the history of his posts easily searchable. But those users who changed their nickname for privacy/OpseC reasons might have a saying against it.

[1714210181]

1714210181

[1714210181]

1714210181

[1714210181]

1714210181

[1714210181]

1714210181

[joker_josue]

I'm thinking about doing some changes to my database's structure to make it easier to develop some new features.

Instead of archiving each post with the author and author_uid field, insert only the author_uid which will reference the user/author from another table.

I think this will make more sense. Regardless of the username, your ID will always be the same. Therefore, if the reference base is always the user ID, it is much easier to work with all the data.

The only thing to think about is: usually user change names for a reason.
Maybe The BeardedBAby likes to be linked to his old account, and having all the history of his posts easily searchable. But those users who changed their nickname for privacy/OpseC reasons might have a saying against it.

Any user who changes his name must be aware that his ID does not change. So, even though it might not be that easy to detect this information, it exists and is available to everyone.

Therefore, everyone should be aware that this information can be crossed. Mainly, in a community that is very used to looking at all the details and analyzing data.

[fillippone]

Therefore, everyone should be aware that this information can be crossed. Mainly, in a community that is very used to looking at all the details and analyzing data.

There is nothing wrong in doing so, data are public and privacy is already lost. I am only considering this is going to further facilitate the collecting of data. A bit like the page that connects all the used addresses with their owner.

[joker_josue]

There is nothing wrong in doing so, data are public and privacy is already lost. I am only considering this is going to further facilitate the collecting of data. A bit like the page that connects all the used addresses with their owner.

It's true. This information can leave each user a little more exposed.
But on the other hand, we have to look at the benefits that we've all had from having this data accessible. This has protected the community from some malicious users. It has helped some to prove that they really are who they claim to be.

[LoyceV]

I want to know if anyone has anything against the idea (cc @LoyceV)

No objections here, go for it! In fact, I thought you would use a separate table for userIDs already instead of storing them with each post. The only reason I'm not doing it is because I don't use a database. In hindsight, I should have learned to use databases when I started, but I never expected my little data storage project to get this big.

[fillippone]

It has helped some to prove that they really are who they claim to be.

In the end, this is the important thing. The community has to protect itself from malicious users. The good users on the other ways, need to manage their privacy footprint anyways.

[dkbit98]

Since this change requires a lot of work and time (especially to update the database entries), I want to know if anyone has anything against the idea

Using ID  instead of username is much better, so I have nothing against this idea, unless it messes up with older links.
For example if I saved archived post I don't want to see this link being broken after you introduce this changes, so maybe you need to link them somehow.
If this is not the case, than you can go for it


 

[TryNinja]

I'm postponing the author-reference idea until I can think more about it.

In the meanwhile, I've made a tool to scrape all old merits before 2022 (ty @LoyceV for his merit.all.txt) and to catch up if the bot or forum is ever down for a few hours; e.g this is now in the database:

Asking because I spotted some merit (the middle transaction, from ETFbitcoin) that didn't make it into your database:

The remaining still missing is related to posts that can not be found anymore (not in the database and can't be scraped because they don't exist anymore). Also, at least one merit tx has a duplicate (date, post_id, amount, sender_uid) from the times when you could double-merit by mistake. Since I treat the combination of those fields as the id of the "transaction", only one was inserted.

[TryNinja]

I tried other topics, but the situation is exactly the same there. 100 posts, and then there is repetition.

Fixed. Make sure you clear the cache with Ctrl + F5.

Thanks!

[Popkon6]

I've been using Ninjastic.space for a long time to view profiles.
But today I can't find the "search option" from this nijastic.space.



Ninjastic.Space is a work in progress.
 
Please problem Solution...

[LoyceV]

But today I can't find the "search option" from this nijastic.space.

I just checked, and got an empty page. After a hard refresh it works again. See above:

clear the cache with Ctrl + F5.

[TryNinja]

But today I can't find the "search option" from this nijastic.space.

Please check again.

(ctrl+f5 to clear the website cache)

[Popkon6]

But today I can't find the "search option" from this nijastic.space.

Please check again.

(ctrl+f5 to clear the website cache)

Okay, Sir Problem solved.
Thanks.

But today I can't find the "search option" from this nijastic.space.

I just checked, and got an empty page. After a hard refresh it works again. See above:

clear the cache with Ctrl + F5.

Thanks Sir..

[joker_josue]

Today I noticed something, which perhaps deserves your attention.

In the "Boards Activity" section and choose the 7 days option, I noticed that the value was not increasing, despite making posts.


If I click on the post list, for the same time period, the values are different. For example, for the same period of time, it indicates that I made 54 when I go to check the posts.
https://ninjastic.space/search?after_date=2023-03-11T00%3A00%3A00&author=joker_josue&before_date=2023-03-18T23%3A59%3A59&board=29

Maybe he is not doing some update, or is with a delay in updating. The note remains.

[dkbit98]

Hey there TryNinja, I have one question for you.
How is it possible for me to search specific terms from title of topics I or any other member created?

For example, I want to search the term ''moderator'' but only for topics I created, that means all other topic from other members would be excluded from results.
Maybe some checkbox or special filtering should be added for this case, unless there is already some workaround I am not aware off.
Any help would be appreaciated.

[joker_josue]

Hey there TryNinja, I have one question for you.
How is it possible for me to search specific terms from title of topics I or any other member created?

Is this what you want to do?

For posts where you use the word "moderator": https://ninjastic.space/search?author=dkbit98&content=moderator
For posts you made in threads whose title has the word "moderator": https://ninjastic.space/search?author=dkbit98&title=moderator

[dkbit98]

Is this what you want to do?

No.
Please refrain from answering further, I explained it clearly in my previous post and I specifically asked TryNinja for help.
Thank you.

[TryNinja]

For example, I want to search the term ''moderator'' but only for topics I created, that means all other topic from other members would be excluded from results.

Not possible, unfortunately. I don't which posts are topics before February 2023 (when I started tracking new topics).

You could keep ignoring the topics you don't care about until you only have yours left.

[hosseinimr93]

For example, I want to search the term ''moderator'' but only for topics I created, that means all other topic from other members would be excluded from results.

Not possible, unfortunately. I don't which posts are topics before February 2023 (when I started tracking new topics).

As the title of replies start with Re:, you should be able to exclude them with adding -"Re:" to "Post title" field.
dkbit98 should be able to see the topics that have been made by him and include the word "moderator" in the title using this link.

This method may not be 100% accurate, because the poster can edit the title and remove the Re: from reply's title.

[LoyceV]

How is it possible for me to search specific terms from title of topics I or any other member created?

For example, I want to search the term ''moderator'' but only for topics I created, that means all other topic from other members would be excluded from results.

If you only want to search the titles, you can use CTRL-F on the forum page Search topics.

I don't which posts are topics before February 2023 (when I started tracking new topics).

But you have the data, right? Take topic 2423 for example: the first post is 32717. Can't you somehow pull this from your database? I can get you a list if you want.