fillippone
Legendary
Online
Activity: 2254
Merit: 16175
Fully fledged Merit Cycler - Golden Feather 22-23
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
February 14, 2023, 11:12:40 PM |
|
<...>
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.
|
|
|
|
joker_josue
Legendary
Offline
Activity: 1750
Merit: 4780
**In BTC since 2013**
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
February 15, 2023, 12:15:19 AM Merited by fillippone (3) |
|
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.
|
█████████████████████████ ████████▀▀████▀▀█▀▀██████ █████▀████▄▄▄▄██████▀████ ███▀███▄████████▄████▀███ ██▀███████████████████▀██ █████████████████████████ █████████████████████████ █████████████████████████ ██▄███████████████▀▀▄▄███ ███▄███▀████████▀███▄████ █████▄████▀▀▀▀████▄██████ ████████▄▄████▄▄█████████ █████████████████████████ | BitList | | █▀▀▀▀ █ █ █ █ █ █ █ █ █ █ █ █▄▄▄▄ | ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ . REAL-TIME DATA TRACKING CURATED BY THE COMMUNITY . ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | ▀▀▀▀█ █ █ █ █ █ █ █ █ █ █ █ ▄▄▄▄█ | | List #kycfree Websites |
|
|
|
fillippone
Legendary
Online
Activity: 2254
Merit: 16175
Fully fledged Merit Cycler - Golden Feather 22-23
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
February 15, 2023, 12:29:06 AM |
|
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
Legendary
Offline
Activity: 1750
Merit: 4780
**In BTC since 2013**
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
February 15, 2023, 07:45:58 AM Merited by fillippone (3) |
|
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.
|
█████████████████████████ ████████▀▀████▀▀█▀▀██████ █████▀████▄▄▄▄██████▀████ ███▀███▄████████▄████▀███ ██▀███████████████████▀██ █████████████████████████ █████████████████████████ █████████████████████████ ██▄███████████████▀▀▄▄███ ███▄███▀████████▀███▄████ █████▄████▀▀▀▀████▄██████ ████████▄▄████▄▄█████████ █████████████████████████ | BitList | | █▀▀▀▀ █ █ █ █ █ █ █ █ █ █ █ █▄▄▄▄ | ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ . REAL-TIME DATA TRACKING CURATED BY THE COMMUNITY . ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | ▀▀▀▀█ █ █ █ █ █ █ █ █ █ █ █ ▄▄▄▄█ | | List #kycfree Websites |
|
|
|
LoyceV
Legendary
Offline
Activity: 3402
Merit: 17183
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
February 15, 2023, 08:15:31 AM |
|
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
Legendary
Online
Activity: 2254
Merit: 16175
Fully fledged Merit Cycler - Golden Feather 22-23
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
February 15, 2023, 08:19:29 AM Merited by LFC_Bitcoin (3) |
|
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
Legendary
Offline
Activity: 2324
Merit: 7373
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
February 15, 2023, 08:53:29 PM |
|
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 (OP)
Legendary
Offline
Activity: 2926
Merit: 7351
Top Crypto Casino
|
I'm postponing the author-reference idea until I can think more about it. ![Cheesy](https://bitcointalk.org/Smileys/default/cheesy.gif) 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: ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fimgvb.com%2Fimages%2F2023%2F02%2F14%2Fa255ef9d401b5c5201abc0d27433d77d.png&t=665&c=x-ISGb3LnK1qNw) ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fimgvb.com%2Fimages%2F2023%2F02%2F14%2Fe07b0475b5a63e479ca00a28997c52a8.png&t=665&c=0duLMfiVCA-qLQ) 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 (OP)
Legendary
Offline
Activity: 2926
Merit: 7351
Top Crypto Casino
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 06, 2023, 07:50:52 AM Merited by Symmetrick (2) |
|
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
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 09, 2023, 02:28:17 PM Last edit: March 09, 2023, 02:47:41 PM by Popkon6 Merited by yahoo62278 (2), TryNinja (1) |
|
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. ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2Fq3ZxHgQ.jpg&t=665&c=ja4FbMaGar9EkA) Ninjastic.Space is a work in progress. Please problem Solution...
|
|
|
|
LoyceV
Legendary
Offline
Activity: 3402
Merit: 17183
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 09, 2023, 02:54:23 PM |
|
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 (OP)
Legendary
Offline
Activity: 2926
Merit: 7351
Top Crypto Casino
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 09, 2023, 08:05:49 PM |
|
But today I can't find the "search option" from this nijastic.space.
Please check again. (ctrl+f5 to clear the website cache)
|
|
|
|
Popkon6
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 10, 2023, 12:20:08 AM |
|
But today I can't find the "search option" from this nijastic.space.
Please check again. (ctrl+f5 to clear the website cache) ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FNv7JSfS.jpg&t=665&c=xh-_OeOy95npMQ) 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
Legendary
Offline
Activity: 1750
Merit: 4780
**In BTC since 2013**
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 18, 2023, 11:58:34 PM |
|
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. ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.ibb.co%2FC2LMvYz%2F7d.png&t=665&c=WAQk3VyzuKIueQ) 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=29Maybe he is not doing some update, or is with a delay in updating. The note remains. ![Wink](https://bitcointalk.org/Smileys/default/wink.gif)
|
█████████████████████████ ████████▀▀████▀▀█▀▀██████ █████▀████▄▄▄▄██████▀████ ███▀███▄████████▄████▀███ ██▀███████████████████▀██ █████████████████████████ █████████████████████████ █████████████████████████ ██▄███████████████▀▀▄▄███ ███▄███▀████████▀███▄████ █████▄████▀▀▀▀████▄██████ ████████▄▄████▄▄█████████ █████████████████████████ | BitList | | █▀▀▀▀ █ █ █ █ █ █ █ █ █ █ █ █▄▄▄▄ | ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ . REAL-TIME DATA TRACKING CURATED BY THE COMMUNITY . ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | ▀▀▀▀█ █ █ █ █ █ █ █ █ █ █ █ ▄▄▄▄█ | | List #kycfree Websites |
|
|
|
dkbit98
Legendary
Offline
Activity: 2324
Merit: 7373
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 22, 2023, 04:19:48 PM |
|
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
Legendary
Offline
Activity: 1750
Merit: 4780
**In BTC since 2013**
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 22, 2023, 07:09:11 PM |
|
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=moderatorFor posts you made in threads whose title has the word "moderator": https://ninjastic.space/search?author=dkbit98&title=moderator
|
█████████████████████████ ████████▀▀████▀▀█▀▀██████ █████▀████▄▄▄▄██████▀████ ███▀███▄████████▄████▀███ ██▀███████████████████▀██ █████████████████████████ █████████████████████████ █████████████████████████ ██▄███████████████▀▀▄▄███ ███▄███▀████████▀███▄████ █████▄████▀▀▀▀████▄██████ ████████▄▄████▄▄█████████ █████████████████████████ | BitList | | █▀▀▀▀ █ █ █ █ █ █ █ █ █ █ █ █▄▄▄▄ | ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ . REAL-TIME DATA TRACKING CURATED BY THE COMMUNITY . ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ | ▀▀▀▀█ █ █ █ █ █ █ █ █ █ █ █ ▄▄▄▄█ | | List #kycfree Websites |
|
|
|
dkbit98
Legendary
Offline
Activity: 2324
Merit: 7373
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 22, 2023, 07:11:38 PM |
|
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 (OP)
Legendary
Offline
Activity: 2926
Merit: 7351
Top Crypto Casino
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 22, 2023, 08:44:59 PM |
|
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). ![Tongue](https://bitcointalk.org/Smileys/default/tongue.gif) You could keep ignoring the topics you don't care about until you only have yours left.
|
|
|
|
hosseinimr93
Legendary
Offline
Activity: 2492
Merit: 5543
|
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
Legendary
Offline
Activity: 3402
Merit: 17183
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 23, 2023, 12:26:02 PM |
|
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). ![Tongue](https://bitcointalk.org/Smileys/default/tongue.gif) 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.
|
|
|
|
|