Duh...

That's it then.
 
Fireworks Mr Craig, if you please!
 

Ok, now I only need 8,710 more...
 

Yay! 

Ooh, palindrome...

craigb
Ok, now I only need 8,710 more...
 

The forum will probably not last that long.

craigb
Ok, now I only need 8,710 more...
 

Loop like a mad man.
 
What they goan do? Band you?

Oh well

bapu

craigb
Ok, now I only need 8,710 more...
 

The forum will probably not last that long.

 
What, it's being shut down tomorrow?

A two-fer for James!
 

...and a TOTP! This is indeed a rare day for Jyemz!

Ok, I've got to go head over to that "other" forum now.

Congrats on the TOTP and breaking 20000 posts James.
 
And you appear to have posted over 20000 posts "over there" too... Well done

synkrotron
Congrats on the TOTP and breaking 20000 posts James.
 
And you appear to have posted over 20000 posts "over there" too... Well done

 
I don't know how that happened, honest guv!

Can we just move everyone's post counts over?
 
I mean assuming* we had a delimited list of members over there with matching names here and their current count here?
 
 
 
 
*You can safely assume that certain unnamed people could quite easily retrieve the post counts of everyjuan with more than, let's say, 500 posts, match it to an identical username over there and produce a delimited list (in any format desired) with fairly minimal work if sumjuan could sumhow make use of such a list.

drewfx1
Can we just move everyone's post counts over?
 
I mean assuming* we had a delimited list of members over there with matching names here and their current count here?
 
 
 
 
*You can safely assume that certain unnamed people could quite easily retrieve the post counts of everyjuan with more than, let's say, 500 posts, match it to an identical username over there and produce a delimited list (in any format desired) with fairly minimal work if sumjuan could sumhow make use of such a list.

The mission is yours, Drew, if you choose to accept it

CraigB just published a list of post counts over at the other place.
I'd love to not have to start over from scratch, as Bapu didn't have to

drewfx1
Can we just move everyone's post counts over?
 

I think James is the first non-Moderator to have his old post count transferred over.  If Bapu approves, it can shirley be done and I can help him do it if he wants.  I thought it would be a nice gesture yesterday but haven't asked Bapu yet.

synkrotron
The mission is yours, Drew, if you choose to accept it 

Producinging a delimited list from public web sites is juan thing.
 
Updating a database is another.

I'll ask Bapu now.
 

drewfx1

synkrotron
The mission is yours, Drew, if you choose to accept it 

Producinging a delimited list from public web sites is juan thing.
 
Updating a database is another.

If you build the list I can update the db. I'm a programmer and the site owner.

craigb
I'll ask Bapu now.
 

Cool

PM sent!
 

Ha!  That Ed guy is too quick! 
 

craigb

drewfx1
Can we just move everyone's post counts over?
 

I think James is the first non-Moderator to have his old post count transferred over.  If Bapu approves, it can shirley be done and I can help him do it if he wants.  I thought it would be a nice gesture yesterday but haven't asked Bapu yet.

 
I sent him a PM last night (or perhaps very early this morning) about archiving threads from this place with a webcrawler and whether there's a web server to host such things and what knot, but he seems to be busy for sum reason and I don't want to nag him.


Retrieving things is not necessarily terribly hard (though juan must be conservative so as knot to look like a DOS attack or whatever), but it's not worth spending time on unless there is an actual use for it.

bapu

drewfx1

synkrotron
The mission is yours, Drew, if you choose to accept it 

Producinging a delimited list from public web sites is juan thing.
 
Updating a database is another.

If you build the list I can update the db. I'm a programmer and the site owner.

 
Any favored delimited format?

drewfx1

bapu

drewfx1

synkrotron
The mission is yours, Drew, if you choose to accept it 

Producinging a delimited list from public web sites is juan thing.
 
Updating a database is another.

If you build the list I can update the db. I'm a programmer and the site owner.

 
Any favored delimited format?

just put it in an .XLSX

And if you can easily pull me a text list a members there, that would save some time. No need to do it yet until I'm done over here (in case more people register in the meantime), but if I don't need to bother with that part I won't.
 
I might have to wait until the middle of the night, because I'm getting lots of timeouts when queying the member list pages here now.

drewfx1

bapu

drewfx1

synkrotron
The mission is yours, Drew, if you choose to accept it 

Producinging a delimited list from public web sites is juan thing.
 
Updating a database is another.

If you build the list I can update the db. I'm a programmer and the site owner.

 
Any favored delimited format?

I'm guessing just a .CSV file would work, however, I think you'll find why it was hard for me to gather those top three pages!  The server here continuously errors out.  Maybe Ed can ask the Bakers for a member list (most forums can produce this for admins).

For example:
 

The server has encountered an error

An exception has been thrown on the page you are trying to access. The error has been logged and the site admin will take the necessary action to prevent such error.

It is also possible that the server is currently experiencing high loads, so please try again later by clicking on the Backbutton on your browser. If the problem persists, you can contact the site admin.

---

Please try the following:

• Click the Back button to try another link.

ASPPlayground.NET Forum Software

 

I'm trying a couple of my tricks to see if I can get the info...

I notice quite a few people from here are changing their user names over there though.

Got page 1, but I may have to wait until a dead posting time to get more.  I'm guessing that all the changes is causing some of the problems (too many deadlock retries for the DBA's among you!).
 

jamesg1213
I notice quite a few people from here are changing their user names over there though.

That's fine - we can deal with the exceptions later.
 
I'm starting to get pages, up to page 5 now...
 
I'll have a lot of Excel cleanup to do, but that's what I tend to do for a living so it shouldn't be too bad!

I've got thru page 6 (1787 posts).  I wonder how far down I should go.  Those with less can be checked here on a member-by-member basis...

Cooking now!  On page 15 (677 posts and above).
 

Page 25 (369 posts and above).

You are a GOD Craig!

I've just made another post, and this one makes two!

Ha! TOTP!!
 
 

On Page 40 (186 posts and above).
 
Taking a lot longer than it should because I made the mistake of copying everything instead of pasting text only.  Each page takes a while to paste into Excel with the images which I don't care about anyway!
 
Going to stop after page 40 and do some rearranging then I might add some more without images and be done with it.

woof woof
 
 
 
oh, Jyemz said GOD
 
 
I'll get me coat

craigb
On Page 40 (186 posts and above).
 
Taking a lot longer than it should because I made the mistake of copying everything instead of pasting text only.  Each page takes a while to paste into Excel with the images which I don't care about anyway!
 
Going to stop after page 40 and do some rearranging then I might add some more without images and be done with it.

You just need to search for lines containing "/Posts":
 
 <a href="/Posts/Username">Postcount</a>
 
I don't think any of them wrap or anything, so am I missing something?
 
 
EDIT:
 
Just run find at a Windows command prompt, append redirect (>>) to a .txt file, import into Excel, text > columns, and get rid of the extra chars.
 
i.e.:
find "/Posts" "Member List _ Cakewalk Forums.html" >> postcount.txt

bapu
 
I'll get me goat

What are you doing with a goat?

I'm having difficulty sussing out the database table with the users in it. Seems so simple but I'm beginning to think they (MyBB forum developers) have it hidden somehow.

bapu
I'm having difficulty sussing out the database table with the users in it. Seems so simple but I'm beginning to think they (MyBB forum developers) have it hidden somehow.

I can just pull each page, do a find on "uid=" (in that forum's case) to get each line and parse that in Excel if you want.
 
And I'm not going to load each page manually either, so it's not particularly labor intensive if it's not a really simple DB query for you.

drewfx1

bapu
I'm having difficulty sussing out the database table with the users in it. Seems so simple but I'm beginning to think they (MyBB forum developers) have it hidden somehow.

I can just pull each page, do a find on "uid=" (in that forum's case) to get each line and parse that in Excel if you want.
 
And I'm not going to load each page manually either, so it's not particularly labor intensive if it's not a really simple DB query for you.

Sure, I've got a lot going on right now. That would be helpful.

Done.
 
Just need to sync the new user list with craigb juan way or another.

I sent the .CSV file to Bapu, do you want a copy Drew?

Got it. I'll sync up the names that are the same and send to Bapu. 

PM'd the link with a spreadsheet with matching names a few minutes ago.

Nice work guys.....really like seeing this teamwork for us to
 
 

Mesh
Nice work guys.....really like seeing this teamwork for us to
 
 

Dr. Ruth's theme song? 

Goood marning!

Good day, Andy
Yet another day, and we're still here (arse well).
What does the day bring you?

Good morning lads!!
Sooo nice to be off from twerking for the past 3 days.....planning on spending some time on the DAW today, but first have to move some stuff in the garage.

Whatcha doing today?

Mesh
Good morning lads!!
Sooo nice to be off from twerking for the past 3 days.....planning on spending some time on the DAW today, but first have to move some stuff in the garage.

Whatcha doing today?

Hey, mate.
I started (again) to take up classical guitar playing with a friend of mine. So I'm going to my 2nd rehearsal at his place this afternoon.
Before that, some mixing. I've got some voices in my head