Saber.
That is all.
Okay, I am going to provide this mini-tutorial for those around here who want to reset their comment ids to managable numbers. Some themes, such as this, display the comment id, and blogs that have been bitten by spam may benefit from this. No real improvements in performance or anything, just the feeling of lower numbers.
First, I’m going to assume that you have PhpMyAdmin or know how to send commands to mysql on your server.
Second, run Spam Nuker by Chris J Davis (link if you don’t have it already)
In the database that you store wordpress in, run these 2 queries.
ALTER TABLE `wp_comments` DROP `comment_ID`;
ALTER TABLE `wp_comments` ADD `comment_ID` BIGINT( 20 ) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
*beats you with my Stick of Beating™*
[Post Powered By: So Sedated So Secure by Darkest Hour from So Sedated So Secure (4:09)]
all hail filemirrors.com
[Post Powered By: Eclipse by Darkest Hour from Mark Of The Judas (4:56)]
Someone find me a torrent for America’s Army 2.4…
I can’t seem to get it off any of the official sites since most of the ones updated are sign up services, of the 2 that aren’t, one is always full and the other won’t let me download the file again for 2 days, considering it died after an hour.
I’m very pissed right now, all I wanted to do was play some AA before bed, and I can’t even f’ing do that.
[Post Powered By: Last Dance Massacre by Darkest Hour from So Sedated So Secure (8:45)]
Well, I got my free Microsoft Visual Studio 2005 Beta 2 disks today, all 3 of ‘em.
So far, I haven’t gotten it installed because SQL Server 2005 has to go first, and it decided to install onto my C drive, even though I selected H. I gotta completely uninstall and reinstall everything to get it to work. How annoying.
I’ll give updates later.
[Post Powered By: Lithium Flower by Yoko Kanno/Time Jensen from Ghost in the Shell Stand Alone Complex OST (3:25)]
So, I now demand the opinions of this theme!
I got this theme from geeksmakemehot and hacked it a bit to my tastes.
Yes, I need to tweak things, I am a tweaker.
Fear it.
[Post Powered By: Fast Car by David Usher from Morning Orbit (4:42)]
Spam is evil. I install this new theme. I get it to a workable point (for now) and I realize that the comment pages have the comment ID numbers on them. I like this.
Of course, I notice the ID to one of the most recent posts is 8237. Now, according to my dashboard, I have all of 397 comments on there, and I do realize that I have in fact cleaned a heck of a lot of spam off my blog over time.
I export my comments portion of the db, and lo-and-behold, there is only 397 lines (spam-nuker++). I notice that the numbers go up sharply at the end, so I manaually edit them, drop the table, and import this new code.
Viola, latest post is ~422, which makes a hell of a lot more sense than 8237.
[Post Powered By: The Doge's Palace by Mike Oldfield from The Millennium Bell (3:07)]
Yes, I am working on getting a new theme going, so it may be a little rough for a while as I tweak it nearly constantly over the next 2 weeks.
[Post Powered By: The Watchful Eye by Mike Oldfield from The Complete Tubular Bells (2:09)]