All the wordpress blogs that I do maintenance for have the Super Cache plugin installed. However for some reason one of the sites keeps locking up when it’s enabled, despite a nearly identical site by the same author not having the problem. At least not at this time.
I’ll wait for an update or bugfix to coincide with the current Wordpress version before trying to enable it again. If it’s really just a problem with the php/web browser configuration, why has it not affected the other sites?
I haven’t played any other MMO game. The game I currently play has the ability to create music. Now you would think this would give some people with music talent to create original music. However I have rarely heard anything in the game that wasn’t familiar outside the game.
On the server I play on, music from the Touhou Project ranks up there as frequently played. The next most frequent are popular Anime Opening’s like Naruto and Neon Genesis Evangelion. Michael Jackson songs from the 80’s also show up sometimes. The battle theme from Final Fantasy 7 also shows up once in a while. Where do people get them from?
The game itself also supports having “Jam Session”, so people can have their own scores to play the same song using instruments that match. Flute, Lute, various drum types and some unique instruments that only play one note (whistle, bottle and bell.) Do other games have this feature? I’m sure it can be emulated if everyone can time things just right.
Today I updated a clients Wordpress site from the PDO over Sqlite wrapper. It was a good idea at the time, however Wordpress itself lacks a proper database abstraction system, so ultimately stuff broke with every update.
That said, the hype over “hacked blogs” is a bit overblown. If you’ve been keeping backups you could compare the database. But the much faster thing to do is to simply pull the user list via the MySQL command line.
mysql> select * from wp_users;
Take note of the last user names added. In this case the last username added, didn’t even have an email address. To top it off the usermeta table had marked the account as an administrator. The security model can be improved.
In the case of the client, the ID was 10. So I went:
DELETE from wp_users where ID=10;
DELETE from wp_usermeta where user_id=10;
The two larger clients sites I actually updated yesterday. You know them as marrymemovie.com and lastblood.keenspot.com . These sites actually had no “attack” on them, but rather had around 200,000 spam comment posts contributed by only 4 IP addresses. Too bad I didn’t save the list. After these spam comments were deleted, the comment tables went from 2GB down to about 80MB.
How to do this with your own Wordpress if you aren’t using something like Askimet:
select comment_author_IP, count(*) as X from wp_comments group by comment_author_IP order by X;
You’ll get a list of IP addresses that comments have been posted from. Chances are that unless your blog has been running for 10 years, one person hasn’t posted 50,000 comments. You can cross-reference the ip address with wordpress itself, use the search function on the comments to see if every comment from that IP address is spam. You can even google it, and you’ll find several blacklists.
To get rid of the most egregious spam, it’s faster to bulk delete:
delete from wp_comments where comment_author_IP=’213.163.65.163′;
delete from wp_comments where comment_author_IP like ‘194.8.7%’;
delete from wp_comments where comment_author_IP=’62.90.102.148′;
delete from wp_comments where comment_author_IP=’62.90.102.146′;
and so forth.
If you feel like cutting them off for good and save processing time on your system. Make use of the .htaccess and deny ip addresses that are a significant source of repeat spam.
Hello and welcome to the next generation wordpress blog. If you previously visited this site last year, you may have been subjected to the drupal CMS system. While I thought it may be a good idea at the time, drupal is overly complex for what was necessary. All I needed was a blog, and something to keep active track of wordpress development since some clients use it.
This site has no relation to the Kisai Denshoku LED watch found here at their website. My site, and domains long predate their product. I’ve used Kisai as my primary name in online activity since at least 1998. If you came here looking for the watch, click above instead.
If you visited the site between 2004 and 2007 you would have seen the remains of the old keenspace.com site. Most of that data still exists, but I feel that keeping old sites around, other than to test something is a bad idea.
Here’s what I currently do:
I am the primary system administrator for keenspot.com
I play a MMO game called Mabinogi. I do not play any any other online game.
I have a Twitter account also called ‘Kisai’
I do not use any instant messenger programs, anyone identified as ‘Kisai’ in these applications is unlikely to be me.
I develop perl and php applications for website backend and frontends. I do not do “web design”, and mostly just do integration of such systems with web designs from artists.
I have and use Adobe Production Premium CS4, and have some interest in creating things in flash.