850 replies, Replies 471 to 480

So we have to come to a decision… Helptogo is being shut down, and they have offered us to buy the domain, and more importantly the info (as helptogo does still have all the old posts from the

Araz wrote:
I don't even remember most of the posts I made on the original help.com. It will be like reading an old diary, I think :) So much nostalgia!

I cheated a little bit and read through a couple of mine. Definite nostalgia!

- written
Questions for guys - Are you happier being with your wife/gf or your group of bros??

I’d prefer my gf. I’m anti-social and struggle to spend time with “outsiders” despite if they’re my friends or not.
But I know being social is good for you- so for the past few months I’ve been having my “group of bros” over once a week for dinner/hang out/tv.

But yeah- I’m a guy- I choose the company of my gf even though I live with her and she’s around all the time.

- written
An interesting perspective on the whole "transgender" thing.

While I totally agree with the underlying message- I think she portrays it very harshly.

Yes, it's a psychological disorder just like PTSD, bipolar, and many others. Yes, I think it should be "treated" not "accepted". Yes, I think it's silly to entertain and say it's okay to claim you're a different ***sex just because you feel like it.
I would not go so far as to say it's abuse though. Is telling children Santa brings them presents on Christmas abuse? No. It's a silly fantasy, yes. But not abuse. (Opinion)

I actually had a conversation the other day about this and an interesting point was brought up to me. GENDER is your social/cultural placement of male and female. Gender does NOT refer to your biological ***sex. (Gender is also binary, just like ***sex.)

So, the term transgender is actually valid/correct. You CAN be transgender based on your feelings.

<rant>
However, that applies only to your gender. Not your ***sex. When you're filling out patient forms- you are to enter your biological ***sex. Bathrooms are based on biological ***sex. Any time somebody asks you or the question comes up, it's important to answer based on your biological ***sex, not your current mood as to what gender you feel like being.
</rant>

- written
So we have to come to a decision… Helptogo is being shut down, and they have offered us to buy the domain, and more importantly the info (as helptogo does still have all the old posts from the

Big-Al-One wrote:
I don't think it would be a bad thing to send out notices of Help's return to the said collection of e-mails gathered.
Can likely expect some addresses to have expired or have been abandoned, etc....
How would you accomplish that at bulk rate? I assume there are 10's of thousands of them. I don't see Padre ever leaving the house if he was put to the task of replying to every one of them.👀

You'd be surprised. Not many people respond to emails- especially ones that are obviously bulk emails. I could respond to them. 🙂

However, it's not 10's of thousands. It looks like the emails are only from HTG, so probably not many people from there that aren't here already. :(

EDIT: Actually, looks like there are 2,700 in there. Not bad!

- written
Stress management.

sophieshizuko wrote:

soco wrote:
Yeah.... got HelpBot to show up!

Welcome you old hunk of tin.

on the old site i use to try to make a post that can make help bot show up multiple times has it was triggered by words .... got 8 replys from in once in a single post

😂 I hadn’t ever seen that!
Sorry. This HelpBot won’t fall for that. He shows up often, but only once per post. :P

- written
So we have to come to a decision… Helptogo is being shut down, and they have offered us to buy the domain, and more importantly the info (as helptogo does still have all the old posts from the

soco wrote:
Not sure I understand much of what was just said. Okay. Absolutely nothing. But I would clean first than import. If that is possible that is.

That's the plan. 👍

- written
So we have to come to a decision… Helptogo is being shut down, and they have offered us to buy the domain, and more importantly the info (as helptogo does still have all the old posts from the

It does not appear that the shouts/users include the original Help's user data.

But again- this is exploring via CLI, so it's not exactly the most reliable info in the world.

- written
So we have to come to a decision… Helptogo is being shut down, and they have offered us to buy the domain, and more importantly the info (as helptogo does still have all the old posts from the

What do you mean testing in Production?

So far, everything I've done has been via CLI. It's still going to be quite a bit before the data will be able to work with the front end and be visible through any actual UI.

- written
So we have to come to a decision… Helptogo is being shut down, and they have offered us to buy the domain, and more importantly the info (as helptogo does still have all the old posts from the

Yeah, a few of them are also empty. But many of them seem to be tracking HTG specific data that we don't care about. Settings, forum tools, and such.
I actually looked at every table and glanced over the data in each one to try to extract the useful ones. Looks like I grabbed about 16 of them. And even a couple of those are duplicates.

It seems there ARE shouts, but glancing over some of the data, some seem to be post-Help. Did HTG have shoutboxes?
But yes, Shouts are there. There is user data- but it's HTG user data. Good news and bad news. Emails are there.... That's about all that's useful. Not sure how it would be taken, but we could send out an email to all of those user's and say Help has returned and invite them back. Would make it explicit that they wouldn't be getting any further emails from us though so they don't think it's spam. Haha.

x_utf_posts
x_utf_topics
x_utf_message_topics
x_utf_message_posts
forums_topics
forums_posts
core_message_posts
core_polls
x_utf_polls
core_voters
shoutbox_shouts
x_utf_shoutbox_shouts
x_utf_profile_portal
x_utf_profile_friends
x_utf_members
core_members

As you can see- a few possible duplicates, and honestly I'm not sure what the difference between topics and posts is.

- written
So we have to come to a decision… Helptogo is being shut down, and they have offered us to buy the domain, and more importantly the info (as helptogo does still have all the old posts from the

It's looking like I definitely spoke too soon. :(

It's going to get crazy trying to un-format this, but let's see how it goes. 😄

@tricky - I've got the HelpToGo DB in MySQL, but our server runs on PSQL. So going to have to migrate that beast. There's ~250 tables, the majority of which look like garbage. (Who stores the meta data for the site in the database?) - Also a number of duplicate tables, for which I have no guesses why.

I tried scraping the site at one point as well- they make you wait 8 seconds between each page of posts though, and there were something like 35k pages. So I, too, was like nah screw it.

I was really hoping the database didn't store the raw HTML for topics/comments, but, alas, they do. So going to have to have a script run through all of those and remove special characters, fix up the HTML into the markdown style that we use here, and remove any of the extra stuff. (Like the - IMPORT)

And I was/am currently planning on just including the HTG posts/replies as well, since at this point- why not if it's all in the same format anyway?

- written