WordPress database error: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay]
SELECT * FROM wp_bas_visitors, wp_bas_refer, wp_bas_ua, wp_bas_os WHERE referer = referer_id AND osystem = os_id AND useragent = ua_id AND lasthere > DATE_SUB(NOW(), INTERVAL 20 MINUTE) AND visit_ip = 644300561 AND ua_string = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)' ORDER BY lasthere DESC LIMIT 1
I've been learning a bit of JavaScript - and this is one of the things I've come up with, so far.
Reddit Filter is fairly simple; it allows you to filter out submissions from certain URLs using a regular expression. Want to give it a shot? Follow these brief instructions:
Install GreaseMonkey - this is a neat […]
Google has surprised me again. I've always known you can search for 'Speed of Light' and before the results google will give you the answer. But it turns out you can enter pretty much any equation and be given the result straight off:
It gets better: if you use Firefox 2 or have the Google toolbar, […]
You've read Daniel's article on becoming a coder, you've had a look at PHP/Python, and maybe even written some programs. Now you've decided to move on and create some nifty code that uses a GUI, with menus, buttons, and all the other things that users expect. Using Python or PHP this can be done, but with rather a lot of difficulty.
In my opinion, a much better solution, especially for Windows developers, is to use Microsoft's C# (pronounced as C-Sharp) language. You can download Visual Studio Express 2008 C# edition for free, a complete C# Integrated Development Environment, with an easy-to-use form editor and a nice code editor. Also in the install program is the option to install SQL Server Express, a database server that works well with C#. SQL Server is a nice addition to have, if you decide to do some programs with databases, but be wary that it is an additional ~30mb to download.
My last article detailed how to write a very simple mod for Counter Strike Source servers; here, I plan to go into more detail. I will assume basic knowledge of Python, and an understanding of how to create a simple addon on your source server - essentially I plan to discuss Eventscripts' API and features.
Userids
Each […]
It surprises me that there is not more fraud on the internet. In fact, it's enough to give a renewed faith in the majority people that run their own websites.
I'm a student, and in my spare time I do some web design, and some coding - among other things. I'd consider myself fairly adept at […]
Here are a few handy tips and tricks, to use when writing in Python.
Based on the relative success of the last article, here are five more CS source mods you should definitely try out, given the chance. They all include download links for the server addons, and a link to all of the servers running them, should you wish to try them out. Don't forget - if you want to try writing your own addons for CS Source, you can get into it within a week, and with minimal experience.
Starting projects for anything new can be fairly daunting - but if you're a fan of Valve's Source games, you can be writing addons for their games within a week. Mattie's Eventscripts makes writing server addons a breeze - and if you want to see the kind of things you can create, look no further than my post on CS Source Mods.
Eventscripts actually comes with two languages built in - I've chosen to write about Python because in my opinion it's both easier and more readable than the inbuilt shell language - and if you're coming to it without knowing either, you might as well begin with it. If you already have experiences with interpreted languages, you'll find Python infinitely easier to follow anyway - plus it's magnitudes faster than the built in language, and has more power.
If you've ever wanted to learn to write code, with no prior experience, now is the best time to do it. There are so many simple languages that are possible to learn from the ground up, picking up the basics of programming languages along the way, and improving your code as you learn new techniques. If you've ever wanted to write code to achieve something simple without downloading a program to do it, now's your chance.
In order to give the best examples I can, I'll be referencing Python and PHP - they're both simple and powerful, and they're how I initially started coding.