Download Google Positioner WordPress plugin v1.2
*UPDATE*: For all of you people who were so kind to download this plugin, and get DB errors, please update your plugin to the latest version (1.2) and all should be well. I’ve tested the installation procedure over and over, and eventually didn’t come up with any bugs or errors. The plugin has both been tested in WP 2.3.x and WP 2.5.x.
My plugin is meant to get the search results from Google for your targeted keywords and to match these results with your wordpress domain.
This way people can quickly get an idea how and where their website ranks in Google.
Changelog:
19/05/2008 v1.1: Updated to version 1.1 to fix aPHP 5 vs PHP 4 bug involving private member functions in classes.
28/04/2008 v1.0: Fully working version of the positioner, complete with database keywordtracking!
19/12/2007 v0.1: Working version of the positioner
20/12/2007 v0.1: Enabled the localization of my plugin
I’m always open for suggestions, so please don’t hesitate to contact me @home kim.kennof@gmail.com or @work kim.kennof@queromedia.com.
Lamag responded on 18 May 2008 at 18:41 #
hey, the plugin doenst work in wordpress 2.5.
look at this fatal error.
Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or ‘}’ in /home/cibao3/public_html/cibao3/wp-content/plugins/positioner/includes/classes.php on line 90
David responded on 19 May 2008 at 1:45 #
Nice idea but it triggers a fatal error. Keep trying.
kim responded on 19 May 2008 at 13:07 #
Hi David and Lamag,
If you’re webserver is running PHP 5, there should not be any problem or bug.
PHP 4.x on the other hand is not able to parse these private functions, thus triggering a fatal error.
The fatal error you guys mention is triggered by some private functions in the GoogleQuery class (classes.php).
I removed this access restriction (the “private “) piece in the beginning of the line and updated all plugin files through SVN to version 1.1, thus creating an update notice in your wordpress plugin screen.
I hope this solves all your troubles.
Greets,
Kim
Daniel responded on 19 May 2008 at 16:07 #
Hi Kim,
I always get this error message when clicking on “Position Me”:
[Table 'xxxxxxx.wp_py_jobs' doesn't exist]
INSERT INTO wp_py_jobs (start, end, region, language, meta, num_results) VALUES (’2008-05-19 17:02:52′, ‘2008-05-19 17:03:01′, ‘de’, ‘en’, ”, 30)
I’m using wp 2.5.1 on php 5.2.5.
Oh, and could you please add German to the language selection?
Thx, Daniel
kim responded on 20 May 2008 at 10:17 #
Hi Daniel, I’ve tested everything and nothing came up. My Database tables got created upon plugin-activation.
I will pay extra attention to this when updating the plugin, but in the mean time I will put the plugins DB tables on this webpage, so you can create them through PHPMYADMIN.
CREATE TABLE `wp_py_jobs_data` (
`ID` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`job_id` BIGINT NOT NULL ,
`keyword` VARCHAR( 255 ) NOT NULL ,
`position` INT NOT NULL DEFAULT '0',
`type` ENUM( 'own', 'competitor' ) NOT NULL ,
`match_url` VARCHAR( 255 ) NOT NULL ,
`result_url` TEXT NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE `wp_py_jobs` (
`ID` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`start` DATETIME NOT NULL ,
`end` DATETIME NOT NULL ,
`region` VARCHAR( 10 ) NOT NULL DEFAULT 'com',
`language` VARCHAR( 10 ) NOT NULL DEFAULT 'en',
`meta` VARCHAR( 255 ) NOT NULL ,
`num_results` INT NOT NULL DEFAULT '30'
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
Hope this solves your problem, Greets
David responded on 20 May 2008 at 16:48 #
I used Total Commander to delete it but it still won’t go away. It’s in my list of plugins to stay apparently.
kim responded on 21 May 2008 at 8:55 #
Hi David,
Thanks for your feedback. It rather disturbs me to read your comment.
For me it is impossible to imagine this situation, as I have never experienced this kind of behaviour by my plugin.
It seems my plugin has some kindof Artificial Intelligence built-in
as it is doing all kinds of funkiness which he appearently doesn’t do with me (or any of my testrabbit-colleagues).
I will do a full recode of my plugin, as to meet all requested bug-fixes and updates.
I want to thank all of you for your feedback, without you I wouldn’t be able to fix these issues!
Greets
Pat Guest responded on 21 May 2008 at 16:40 #
Hi Kim,
Cool plugin.
I was getting the following error:
[MySQL server has gone away] …… etc..
I used a workaround and updated the wp-db.php file. Here is the link to the workaround. http://robsnotebook.com/wordpress-mysql-gone-away
Thanks
Daniel responded on 21 May 2008 at 16:44 #
Hi Kim,
thanks for posting the tables. I’ve created them via PHPMYADMIN. And now I know why they have not been created upon activation: the command COLLATE is not supported by MySQL 4.0 and less. I’m using MySQL 4.0, so the tables could not have been created. Maybe you can fix this in any way!?
Thanks for your help and thanks for the great plugin!
Greets, Daniel
tum responded on 21 May 2008 at 19:36 #
Thanks for plugin.
it’s Cool!!
kim responded on 22 May 2008 at 13:47 #
Thx Daniel, Pat and Tum for your feedback!
I will update the create table statements and leave out the collation (utf8-general) and database type (MyIsam) for future versions.
This way the create statements will be executed with the default database collation and database-type and hopefully not return any errors.
I’ve added the feeds for robsnotebook.com and bbgb.com to my feedreader to stay uptodate
Again, Thanks for your comments, appreciate it a lot! I hope my plugin does what it’s supposed to do and saves you guys some work.
Greets,
Kim
ovidiu responded on 22 May 2008 at 15:06 #
I am wondering a little about the options. REGION means the area I am based? and is there a problem, if that area differs from the language I chose? also what do I input into the meta field?
Kim responded on 23 May 2008 at 18:09 #
Hi Ovidiu,
Thank you for commenting and providing feedback on my plugin. I appreciate this a lot.
As for your question about the Google options:
Region aims at the TLD for “your” google domain (www.google.TLD).
Ex. In Belgium it would be “be”, in Russia it would be “ru”, in Spain “es”, Italy “it” and so on.
For the question about the difference between language and region:
As “region” aims at the TLD, language aims at the default language in which YOU visit the google website.
In Belgium this can be Dutch, English or French as we have a multilanguage country. Americans will then again simple choose English, as they don’t have any other languages.
I’m not well informed about Russia, but I will add the option “Russian” or provide an open text field, so people can fill in what they need/want.
Please provide me with the necessairy information (languages and parameter values as for “hl=xx” in the querystring), so I can update the plugin ASAP. I will do my best to track down this info myself, but can’t make any promises.
For the meta-field:
Currently this is only for advanced use. This field can be used to add extra parameters to the keyword query url.
For ex. If I would google “Wordpress” in Belgium, it would result in this URL:
http://www.google.be/search?hl=nl&q=Wordpress&btnG=Google+zoeken&meta=cr%3DcountryBE
The parameters in this url are easy.
“hl=” is used for the interface language.
“q=” is used for the query.
“btnG=” is used for the button text.
“meta=” can be used for extra parameters, as in content filters, or country restrictions.
As I am currently still working on implementing as much options as I can, the meta field will remain only for experienced users, otherwise it can be left empty.
Greets,
Kim
baron responded on 26 May 2008 at 12:22 #
hi. Thanks for plugin
perfect.
Regards
Geitfromboy responded on 26 May 2008 at 12:27 #
hi. i am interested with the concept of this plugin..could you please make a step by step info/q&a for this as i don’t understand much of SEO. thank you
kim responded on 26 May 2008 at 14:32 #
Hi Getitfromboy,
Thanks for commenting.
SEO or Search Engine Optimization is the art of building a well structured website, for your human visitors as well as for search engine spiders. This meaning that you should use proper sourcecode (headers, div’s, etc…), use proper css / javascript techniques, provide usefull information on hyperlinks and images (alt & title tags) and much more.
This whole process is mostly focussed on a certain list of terms which are important for your website or business, and thus have to be present in your website’s content and titles, as well as other strategic places.
For example: If you have an electronics shop, “tv”, “stereo”, “mp3 player”, “dvd”, “blue-ray player” etc will be important as they will be used by visitors to find your website through search engines like Google.
After you have built your website and added some content (products?), it is important that your website is visible and findable through search engines. For this to happen, you have to build up a certain amount of relevance for the earlier mentioned terms.
When you have accentuated some of these words in the correct places like
- page title (<title>),
- meta description (<meta name="description">),
- page headers (<h1 -2-3-4-5-6>),
- in emphasis-tags (<em> or <strong>), ...
your website will build up history and relevance through time. (A matter of months, not days)
Lets say a user googles the term “plasma tv” and you have a page about plasma-tv’s, for example about the pro’s and con’s of plasma-technology,
This way search engines will place you higher in the search engine result pages then your competitors’ websites as your website has more relevance and history for the search term.
To follow your website for your wanted keywords, you can use my wordpress plugin to track these in your favorite Google mirror.
In our Electronic-shop example this would result in:
- “tv” on position 5 in google.com,
- “stereo” op position 3 in google.com,
etc
I hope you now have a clearer view on SEO and what my plugin actually does.
Greets,
Kim
Diego responded on 26 May 2008 at 14:58 #
Kim, Excellent plugin, Excellent work. This was a manual task before this plugin. I’m sending you an email because I make the spanish translation of the plugin and I’ve some comments about that.
Thanks
Diego
Diego Cabai | Blog responded on 26 May 2008 at 18:34 #
Position Yourself / Posiciónate Tu Mismo Plugin en Español…
Position Yourself es un plugin que encontré recientemente gracias al Dashboard de mi instalación…
john oneill responded on 30 May 2008 at 12:17 #
Looks like a great tool. I have just downloaded it so I cant comment on functionality yet. It did however install no problem. I went trough the settings and added keywords. A couple of setting questions.
The default region is be. Where is this? My site is hosted in Ireland and targeted at UK and Irish audience. What are the cosed for UK and / or Ireland?
What should go in the meta box? One word or a series of words. If a series, is it a phrase or words seperated by commas?
Thanks
John
kim responded on 01 Jun 2008 at 12:52 #
Dear John Oneill,
Thanks for your comments!
The settings panel is laid out as follows:
- Region: The geographical extension used by Google. For ex. If France -> google.FR, if Belgium -> google.BE
- Language: The language in which users will probably visit the Google site. For ex. If France -> French, if Belgium -> Dutch, if UK -> English, and so on.
- Meta: The meta option is solely for advanced users, who want to put something behind every query-url. For ex. If you entered “TV” as a keyword, this would result in http://www.google.com/search?hl=en&q=TV. If you wanted to put customized parameters behind this query-url, you can by filling them out in the meta field. You can use this field to add a Country restriction.
I recommend on leaving this EMPTY if you don’t know what you’re doing.
- Number of results: The number of results on the Google SERPs page you want to check for matches with your domain (or any competitor’s).
I hope my explanation has clarified everything, otherwise feel free to contact me through email or commenting.
Greets,
Kim
Cedric responded on 02 Jun 2008 at 23:52 #
Hi,
Looks like a great plugin. I tried it but it gave me some MySQL errors when trying to insert the return results in the DB:
—
WordPress database error: [MySQL server has gone away]
INSERT INTO wp_py_jobs (
——
I got the error on a Wordpress 2.3.3 installation. i used the latest version of the plugin (I guess). Seems like the issue already mentioned above still remains.
I’m not really comfortable with patching the wp-db.php file
Any other workarounds?
Best regards,
Cedric
Chris responded on 03 Jun 2008 at 6:30 #
sorry, it does not work for me (WP 2.5.1):
here is the error… please come back to me when it works:
Fehlerausgabe / Error output:
Fehler beim Verarbeiten des Skript-Headers / Error parsing script headers:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘`wp_py_jobs_data`’ at line 1 for query SHOW TABLES LIKE `wp_py_jobs_data` made by positionyourself_install
Skript-Ausgabe (531 Bytes) folgt / Script output (531 bytes) follows:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘`wp_py_jobs`’ at line 1 for query SHOW TABLES LIKE `wp_py_jobs` made by positionyourself_install
Status: 302
X-Powered-By: PHP/4.4.7
Content-Type: text/html; charset=UTF-8
Expires: Wed, 11 Jan 1984 05:00:00 GMT
Last-Modified: Tue, 03 Jun 2008 05:24:38 GMT
Cache-Control: no-cache, must-revalidate, max-age=0
Pragma: no-cache
Location: plugins.php?activate=true
windwardtrades responded on 08 Jun 2008 at 1:35 #
I’m having trouble also. WP 2.5.1 & PHP5. Problem is the mysql tables are empty except for the headers. I enter the keywords, press position me, and then nothing. Ideas?
schmittzer responded on 09 Jun 2008 at 19:48 #
Hello.
I’m getting this error when i try to activate the plugin
Fatal error: Cannot redeclare class snoopy in /var/www/html/virtual/scherzo.dm.cl/www/blog/wp-includes/class-snoopy.php on line 48
Do u have any idea about what could be causing this error?.
Menentukan Posisi Blog di Google SERP | Belajar SEO, Wordpress dan Internet Make Money G N U P I . C O M responded on 15 Jun 2008 at 12:22 #
[...] plugin Google Positioner ini, kita tinggal memasukkan keyword yang kita optimasi di blog kita, melakukan pengaturan untuk [...]
Black jack mountian oklahoma.. responded on 20 Jun 2008 at 6:59 #
Lyrics to black jack s lady….
Samsung - black jack. Black jack game. Lyrics to black jack s lady….
Samara Beach responded on 04 Jul 2008 at 16:29 #
July 3rd install of WordPress 2.5.3
Fatal error: Cannot redeclare class snoopy in /home/content/e/d/i/editormule/html/samarabeach/wp-includes/class-snoopy.php on line 48
Colleen Kulikowski responded on 11 Jul 2008 at 1:05 #
I am getting the following error and I have the latest version of the plugin installed:
WordPress database error: [MySQL server has gone away]
Can you point me in the right direction to correct the situation.
Thank you…
Robert Irizarry responded on 26 Jul 2008 at 11:45 #
Any plans to test with WordPress 2.6? I’m currently on 2.6 and PHP5 and seeing the MySQL has gone away errors as well.
Wordpress Plugin: Google Positioner | Wordpress Plugins responded on 04 Aug 2008 at 14:59 #
[...] Plugin Homepage » [...]
Jan responded on 06 Aug 2008 at 12:55 #
Hey Kim,
Great plugin - really helps a lot. Just a quick questions.
Do you mind editing your plugin for presonal use ? I mean I would like to add strings for my localization / language (Polish) and extend number of positions in google that plugin will check for each keyword.
Regarding people that got mistake with MySQL server has gone away —> look here: http://wordpress.org/support/topic/187416
cheers,
Position Yourself / Posiciónate Tu Mismo Plugin en Español | Diego Cabai | Blog responded on 08 Aug 2008 at 10:43 #
[...] Position Yourself es un plugin que encontré recientemente gracias al Dashboard de mi instalación de Wordpress. Cuando leí de que se trataba me interesó y lo instalé. Para todos los que tienen un blog siempre el SEO (Search Engine Optimization) es importante. Gran cantidad de visitas a los sitios se deben al buen posicionamiento en buscadores y ahí es donde el SEO entra en contacto. [...]
SuretyHound responded on 28 Aug 2008 at 16:19 #
The product works fine with me, but I was wondering in the options section were it says meta what should we put there should it be our meta keywords?
Bytetips responded on 01 Sep 2008 at 4:17 #
I get this error when i try to activate this Plugin
Plugin could not be activated because it triggered a fatal error.Fatal error: Cannot redeclare class snoopy in .../public_html/wp-includes/class-snoopy.php on line 47
Buy alprazolam. responded on 04 Sep 2008 at 20:04 #
Buy alprazolam….
Buy alprazolam….
Plugins WordPress Untuk Toko Online | Arhan's Adventure responded on 12 Sep 2008 at 19:31 #
[...] Position Yourself [...]
WordPress Plugins | thephotographer4you responded on 13 Sep 2008 at 4:18 #
[...] Position Yourself [...]
Andy responded on 14 Sep 2008 at 11:04 #
The plug in works if I keep the default values for region and language i.e. “BE” and “DUTCH”.
If I change to “UK” and “English” I get an error:
“Warning: fsockopen() [function.fsockopen]: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/thealevi/public_html/wp-includes/class-snoopy.php on line 1157″
I change back, and it works again.
So at the moment I am keeping it on the default settings but I don’t know if this gives me a different result from what it would be if I was able to set UK and English.
The other thing to mention is that the actual results received don’t match the result if I search ‘manually’.
Still a very useful plugin, so thank you.
Scubaman responded on 25 Sep 2008 at 20:29 #
I have version 1.2 but get this error anytime I try and use it.
WordPress database error: [MySQL server has gone away]
INSERT INTO wp_py_jobs (start, end, region, language, meta, num_results) VALUES (’2008-09-25 14:24:57′, ‘2008-09-25 14:25:58′, ‘us’, ‘en’, ”, 20)
The Best Blog » Blog Archive » Membuat Toko Online dengan WordPress responded on 26 Sep 2008 at 5:04 #
[...] Position Yourself [...]
wordpress提速 | 一个伪linux粉丝的blog responded on 15 Oct 2008 at 10:28 #
[...] Position Yourself By Kim Kennof [...]
stefanomavilio.com » Blog Archive » plugin da vedere responded on 20 Oct 2008 at 2:53 #
[...] Position Yourself » Kim Kennof (url) Gets matches from Google results for your keywords [...]
selif responded on 25 Oct 2008 at 22:56 #
Tried it on WordPress 2.5.1 and also tried on WP 2.6.2
My question is: Is there a version of this or something like it that works?
Anywhere?
…. Tired of farking with stuff that doesn’t work right
##Lilu responded on 09 Nov 2008 at 11:38 #
soft tabs tongue non prescription levitra
Many thanks towww.queromediashare.com
Easy Internet Money responded on 21 Nov 2008 at 17:14 #
Hi Kim,
Excellent plugin, I really love it
Thanks
Nilna