Forum: MS SQL  Jul 10th, 2008 |
| Replies: 2 Views: 2,729 Re: Delete records from a table
DELETE FROM table1
USING table1, table1 AS vtable
WHERE (table1.ID > vtable.ID)
AND (table1.field_name=vtable.field_name)
You may need to have lots of ANDs at the end, if you want lots of fields to... |
| Forum: Growing an Online Community Jul 5th, 2006 |
| Replies: 30 Views: 6,353 Re: Time Frame for Growing Forum
I guess it depends on how you define truly. If you mean, the owner/admin dies, and yet somehow 3 years later the forum is still humming along, then, yeah, no forum is that self-sustaining.
However,... |
| Forum: Growing an Online Community Jul 5th, 2006 |
| Replies: 3 Views: 2,777 Re: Email blast question.
It wouldn't be spam if you could partner with a site that is already established in your market. I've done that with email newsletters -- I find a site for writers, find out how much it costs to... |
| Forum: Growing an Online Community Jun 8th, 2006 |
| Replies: 15 Views: 3,639 |
| Forum: Geeks' Lounge Jun 8th, 2006 |
| Replies: 38 Views: 3,813 Re: Other forum your a member of
I see you on The Admin Zone every now & then. :)
I'm a member of TAZ, Daniweb, Sitepoint, v7, Digital Point, webmaster-talk, Ozzu, talk-freelance, phpbb.com, and maybe 30 more. Oh, and my own... |
| Forum: Geeks' Lounge Jun 8th, 2006 |
| Replies: 60 Views: 10,930 Re: Favorite All Time Games
Mmm. Cain goes way back. Nice. I loved playing Yar's Revenge.
My list of favorite games:
Kaboom! on Atari 2600 - they encouraged gamers to take a photo of their TV if they got a high enough... |
| Forum: Growing an Online Community Jun 7th, 2006 |
| Replies: 35 Views: 10,965 Re: Revenue Sharing Forums??
Not only that, it promotes quality discussion, because the people participating don't want to drive away members. Suddenly, the top posters start to view your site the way you view it. They want to... |
| Forum: Growing an Online Community Jun 7th, 2006 |
| Replies: 35 Views: 10,965 Re: Revenue Sharing Forums??
I'm about to implement this on one of my forums. I'm looking at Google's terms and I cannot find anything that would prohibit this. Can you explain how it violates the TOS? I don't want to get in... |
| Forum: Growing an Online Community Jun 7th, 2006 |
| Replies: 38 Views: 9,660 Re: forum software
SMF (Simple Machines Forum) is another free one.
My thinking is like this:
If you're poor, or if you are a free software zealot (I am -- I want the ability to freely modify & use without... |
| Forum: Growing an Online Community Jun 7th, 2006 |
| Replies: 15 Views: 3,639 |
| Forum: Promotion and Marketing Plans Jun 7th, 2006 |
| Replies: 22 Views: 6,193 |
| Forum: Promotion and Marketing Plans Jun 7th, 2006 |
| Replies: 11 Views: 5,220 |
| Forum: Website Reviews Jun 7th, 2006 |
| Replies: 2 Views: 1,176 Re: please review http://Qualitybase.org
Wow. I thought your comment was very harsh, so I went to the site to try to provide an alternative viewpoint. However, upon reviewing the site, I have to say that you're not far off the mark.
The... |
| Forum: Site Layout and Usability Jun 7th, 2006 |
| Replies: 4 Views: 17,008 Re: How to build a Forum?
Go to www.phpbb.com and download the phpBB forum software. Unzip the downloaded file, and upload the contents to your Web server. Then pull up the installer page in your Web browser, and follow the... |
| Forum: Promotion and Marketing Plans Jun 7th, 2006 |
| Replies: 4 Views: 1,777 Re: Am I missing something?
Many sites have tens of thousands of articles/tutorials/etc. So no, I don't think you can overdo that. Every page is a potential landing page for a visitor who was searching on Google.
There are... |
| Forum: Growing an Online Community Apr 18th, 2006 |
| Replies: 21 Views: 5,407 Re: How could I promote a women forum?
Wow, if you're actually going to do it, let me give you some tips.
First, you can blow your whole budget in an hour, if you pick keywords that are too broad. If that happens, it's not a total loss,... |
| Forum: Promotion and Marketing Plans Mar 27th, 2006 |
| Replies: 20 Views: 5,172 Re: How many visitors on average?
That's pages per visit, not hits? Wow. That's really, really incredible. You have a very sticky site. I'm going to stop by and try to learn from you.
-T |
| Forum: Growing an Online Community Mar 24th, 2006 |
| Replies: 16 Views: 3,266 Re: One post wonders
Really? That's primarily what I like it for. It's perfect for the obscure old threads that I'll never remember to check, unless there is a reminder.
But I do have a strategy for managing the big... |
| Forum: Growing an Online Community Mar 24th, 2006 |
| Replies: 16 Views: 3,266 Re: One post wonders
Yes, I love that too. In fact, I wrote the mod for phpBB that switches the default to "enabled." However, oddly, it's about the least-downloaded mod I've got. I think forum admins might not... |
| Forum: Growing an Online Community Mar 20th, 2006 |
| Replies: 6 Views: 2,253 Re: poaching/recruiting
DanceInstructor, dojo, Dustin, thank you all for the input. I eventually slogged through it. I ended up banning SIX people, including the moderator, no chance (or desire) of making it up with her... |
| Forum: Growing an Online Community Mar 17th, 2006 |
| Replies: 16 Views: 3,266 Re: One post wonders
Well, if the ideas mentioned won't work, that may just be a difference in size -- your almost 70K membership causes issues that those of us with 5K memberships don't experience. That's OK. But... |
| Forum: Growing an Online Community Mar 17th, 2006 |
| Replies: 5 Views: 5,721 Re: Contest ideas for a big board
By the way, your idea about polls does work. I'm sure you've seen Slashdot's poll on the right side of their site. Every week (or two), they have a new poll. All they have to do is set it up, and... |
| Forum: Growing an Online Community Mar 17th, 2006 |
| Replies: 5 Views: 5,721 Re: Contest ideas for a big board
I did a contest that required examining every response, but it didn't take much time on my part at all. Here's what I did: I wanted a new logo, and I offered $250 to the winner. Each entry needed... |
| Forum: Growing an Online Community Mar 17th, 2006 |
| Replies: 7 Views: 2,402 Re: Email newsletter
Here's what I'm working toward for email. I'm creating a short email (just a few paragraphs) that contains links to the best topics, and mentions a couple of the newest site features. I'll send it... |
| Forum: Growing an Online Community Mar 17th, 2006 |
| Replies: 16 Views: 3,266 Re: One post wonders
I was always impressed by welcome PMs. However, I have to admit that it never made me post more. It just gave me a warm fuzzy feeling.
One of the best ways (I think) to get rid of 1-post wonders... |
| Forum: Growing an Online Community Mar 17th, 2006 |
| Replies: 56 Views: 12,846 Re: Paying for posts
I did that, and regretted it. I'd much rather use a paid service, even considering how weak their services are.
The people I did post exchanges with posted terribly. One guy just copied posts and... |
| Forum: Growing an Online Community Feb 10th, 2006 |
| Replies: 6 Views: 2,253 poaching/recruiting
I have a plea for advice from admins of large, successful forums. I'm in a bind. I run a few forums, and finally created a successful one. But last week, one of the moderators posted some material... |
| Forum: Growing an Online Community Jan 22nd, 2006 |
| Replies: 21 Views: 5,407 |
| Forum: Growing an Online Community Jan 21st, 2006 |
| Replies: 21 Views: 5,407 Re: How could I promote a women forum?
You can't even afford $10 for Google Adwords? Without some kind of boost at the beginning, you're going to grow VERY slowly.
I guess if I had absolutely zero dollars, my best way to promote would... |
| Forum: Growing an Online Community Jan 21st, 2006 |
| Replies: 56 Views: 12,846 Re: Paying for posts
On December 19th I purchased 100 posts from both Forum Elves & Forum Launch. Days went by with no further activity. Finally, on December 31st, I saw a batch of registrations and lots of posting from... |
| Forum: Promotion and Marketing Plans Jan 21st, 2006 |
| Replies: 13 Views: 3,550 |
| Forum: Promotion and Marketing Plans Jan 21st, 2006 |
| Replies: 20 Views: 5,172 |
| Forum: Geeks' Lounge Jan 21st, 2006 |
| Replies: 2 Views: 1,643 Re: Nice Song!
Yeah, she's cute, but her face has no mystery to it.
However, I could watch her hips for a few hours. ;)
-Tony |
| Forum: Community Introductions Jan 21st, 2006 |
| Replies: 2 Views: 1,149 |
| Forum: Community Introductions Jan 21st, 2006 |
| Replies: 2 Views: 1,135 |
| Forum: Promotion and Marketing Plans Dec 17th, 2005 |
| Replies: 27 Views: 6,767 Re: What drove your traffic?
I wrote a few posts a while ago that outlined things I was doing to keep members & get better conversions. Here's a recap:
Remove barriers to entry. When I put my site up for review on a few... |
| Forum: Growing an Online Community Dec 11th, 2005 |
| Replies: 14 Views: 5,046 Re: Community Building Activities?
You know, contests really worked for me. I should have mentioned that in the other topic you have on traffic-building.
Anyway, I did a bounty -- $1 per magazine entered into my database. I ended... |
| Forum: Growing an Online Community Dec 11th, 2005 |
| Replies: 9 Views: 2,581 Re: "Expired Members"
Yeah, I agree with Dani. On my site, I run a query on the database every month or two, to get a list of all the members who have not even activated their accounts. I send them a reminder email with... |
| Forum: Promotion and Marketing Plans Dec 11th, 2005 |
| Replies: 27 Views: 6,767 Re: What drove your traffic?
My site is smaller than yours. I run a forum site with only about 2000 members. I also have a couple technology sites. Here are the things that caused a rise in traffic:
PR Web press release --... |
| Forum: Promotion and Marketing Plans Aug 21st, 2005 |
| Replies: 10 Views: 3,329 |
