The Teen Girls Pantsing and Stripping board archives

[Girlspns]

I have it in the SQL folder, so I'll try to upload it to the archives, it might take some time because it's 16 parts (I think? If it's more, then my file may be incomplete), but it'll get there eventually.

[unfair]

18 in the dump by the looks of it:

mysql> select subject from disc_245772 where subject like "%GHSW%";
+--------------------------------------------------------------+
| subject |
+--------------------------------------------------------------+
| GHSW (by Jonathan) Chapt. 1 Prologue |
| GHSW (by Jonathan) Chapt. 1 Prologue continued |
| GHSW (by Jonathan) Chapt. 2 And So It Begins |
| GHSW (by Jonathan) Chapt. 3 Escalation |
| GHSW (by Jonathan) Chapt. 4 Crossing The Line |
| GHSW (by Jonathan) Chp. 5 Humiliation On A Grand Scale |
| GHSW (by Jonathan) Chp. 5 Humiliation On A Grand Scale cont |
| GHSW (by Jonathan) Chp. 8 The Betrayal continued |
| GHSW (by Jonathan) Chp. 9 Some Down Time With Friends |
| GHSW (by Jonathan) Chp. 10 A Broken Truce continued |
| GHSW Ch11 Who Would Have Thought Math Class Was So Much Fun? |
| GHSW (by Jonathan) Chapt. 15 Spring Break Part 1 |
| GHSW (by Jonathan) Chapt. 15 Spring Break Part 1 continued |
| GHSW (by Jonathan) Chapt. 17 A Losing Battle |
| GHSW (by Jonathan) Chapt. 18 A Fashion Show For The Ages |
+--------------------------------------------------------------+

Tracked down 6 and 7 too..stupid inconsistent naming..

mysql> select subject from disc_245772 where subject like "%chp%6%";
+-------------------------------------------------------------+
| subject |
+-------------------------------------------------------------+
| Greenview High Stripping Wars Chp. 6 Practice Makes Perfect |
+-------------------------------------------------------------+
1 row in set (0.04 sec)

mysql> select subject from disc_245772 where subject like "%chp%7%";
+------------------------------------------------------+
| subject |
+------------------------------------------------------+
| Greenview High Stripping Wars Chp. 7 The Winter Play |
+------------------------------------------------------+
1 row in set (0.04 sec)

Don't know how handy people are with sql, but I may be able to help. What would you find useful? I'm surprised you say it takes too long to dump into a DB really, too literally 1 second on my PC. 1700 entries is teeny weenie really, how are you trying to do it? But I was am it locally I suppose.

Would it help you if I split it into smaller sql files, or maybe convert it to a load of text documents? Or organise it by author (almost all are anonymous though..)

Could get all kind of fun statistics, if other people find statistics fun :p e.g.

| okayterrific | 75 |
| Ashley | 77 |
| janienudiepants | 80 |
| Hooked6 | 83 |
| Humilatron | 84 |
| Wedige Spanker | 91 |
| The Controverser | 103 |
| SDS | 110 |
| sinfulstories | 111 |
| PhoenixENF | 111 |
| Jeepman89 | 116 |
| Executionus | 139 |
| SwimKid | 182 |
| dazed | 220 |
| Janie | 281 |
| Anonymous | 1038 |
+------------------------------------------------+----------+

[unfair]

Also sorry I'm sad..but 2 more things:

1. RE "I can't get all the comments because it would take too long to correlate them".

There is a granparent id field there, so you can do something fancy and get it to pull them all in for a certain story, then order them by the date:

e.g.:

mysql> select subject, author from disc_245772 where subject like "%Trisha the t%" or grandparent in (select id from disc_245772 where subject like "%Trisha the t%") order by date_entered;
+------------------------------------------------------------+---------------+
| subject | author |
+------------------------------------------------------------+---------------+
| Trisha the terrible - C1 - The worst kind of game | SDS |
| Trisha the terrible - C2 - Caught and a quick flash | SDS |
| Trisha the terrible - C3 - Stripped and tree hugging | SDS |
| Trisha the terrible - C4 - Bare bottom spanking | SDS |
| Continue | Mr Somebody |
| Re: Trisha the terrible - C3 - Stripped and tree hugging | Anonymous |
| Very good | M |
| Great start | Janie |
| Trisha the terrible - C5 - Giving the boys a closer look | SDS |
| Trisha the terrible - C6 - Naked | SDS |
| Trisha the terrible - C6 - Naked | SDS |
etc.

2. Maybe I should be PM'ing this....but is it ok that it has all the email in the sql even if they selected not to show them (show_email)? Might want to take the file down if not.

[PhilMarlowe]

I have been out of town for the past few days. I got the sql dump file loaded into MySQL on a Windows system. I need to research outputing data from MySQL other that just the list of rows from a select statement. The HeidiSQL gui that I have can save a BLOB field into a file and if its file extension is html, a browser will display it nicely.

[Girlspns]

Also sorry I'm sad..but 2 more things:

1. RE "I can't get all the comments because it would take too long to correlate them".

There is a granparent id field there, so you can do something fancy and get it to pull them all in for a certain story, then order them by the date:

I know there's a grandparent ID, but it would take WAY too much time to build out the actual website to display the fields marked as comments in the actual comments under the appropriate posts, and that's only IF I find an appropriately structured website that accepts the database's structure, and all of that just so I can preserve the ancillary comments, AND only if I find a way to automate that.

For example, the current archive has two separate tables for comments and posts, meaning I'd have to split the original table into two tables, then cut out any fields that don't fit into the new table's schema, then transfer the two tables, and before all that, I have to make sure that the story parts that have a grandparent ID because they were posted as replies to the main posts are not accidentally split into the comments table because I'm not sure whether or not the comments are searchable and...

Basically, it's like constructing a 1:1 replica of the Eiffel tower so you can see over someone's backyard fence, way too much work for practically no benefit and there's a reason this is a specialty occupation in DB admin work.

2. Maybe I should be PM'ing this....but is it ok that it has all the email in the sql even if they selected not to show them (show_email)? Might want to take the file down if not.

Good point, I'll edit the post that has the table.

[unfair]

(posting bit drunk so maybe take with pinch of salt...)

Ok fair enough, didn't mean to imply you didn't know what you're doing or anything. But I'm a junior developer and work with databases plenty. So I'm at your disposal if I can be of help.

[PhilMarlowe]

I can get all of the postings with the same parent into a text file with a <hr> between each posting. This includes comments in line with the story as posted. So far I like that. It would be more work to even remove comments, they are hard to distinguish from part2, part3, part4, etc.

There seem to be 1509 parents in the SQL file I have. This weekend I will have them all separated and will post a listing of the authors, dates and subjects here. Then you can let me know which ones to start uploading here.

[unfair]

Alright I'll leave to you Phil, let me know if you want any help or anything.

[stevesmith1990]

Sorry for making this my first post, but I've got a full copy of GHSW if anyone wants?

[Girlspns]

(posting bit drunk so maybe take with pinch of salt...)

Ok fair enough, didn't mean to imply you didn't know what you're doing or anything. But I'm a junior developer and work with databases plenty. So I'm at your disposal if I can be of help.

Oh not at all, don't worry about it, I was just trying to explain the reason I wasn't doing that because it just makes the discussion easier and more productive, I didn't take that meaning from it at all.

Sorry for making this my first post, but I've got a full copy of GHSW if anyone wants?

Yes please, it would be easier if you posted it in the forum as a new topic, I'll just add it to the archive manually from there.