[Doggie52]

Doggie52 (dG52) PHP SourceMod Plugin Updater

After hours of work I am finally done with what I think can be of great help to server administrators. I would appreciate if someone could test this on their server and report back with suggestions, feedback or problems! I would also appreciate if someone took their time and helped me out with the UI part of the script!

dG52 PHP SourceMod Plugin Updater grabs a list of the plugins (through 'sm plugins list' via RCON) installed on your server. It then queries both the SourceMod plugin search and the AlliedModders forums for the latest version. After having found the URL of the plugin's forum post it saves this in an SQLite database for future searches.

Usage instructions

Download the archive and extract to your webserver's `htdocs` directory.
Configure the script by opening `config.php` in your favorite text-editor and editing the variables listed.
Then, open the `install.php` file in your browser and let it create the database.

You're done! Open `plugins.php` in your browser and let it do its job.

If the plugin can not find a matching forum URL for a certain plugin, it will tell you so. You can then choose to click the affected plugin's name and add the forum URL yourself!

Changelog

The code lies on an SVN repository - the source code changes can be viewed here. If you prefer to have this in feed format, you can access that here.

Notes

Make sure your script is hosted somewhere only YOU can access it. Do NOT put this on a public webserver - bad things can happen.
Please report any issues in the issue tracker!
The script queries the search and forum pages directly - these can take a long time to download so be patient! The script can take around a minute to complete.
The script uses the srcds rcon PHP class by Geert Broekmans.
The script entirely relies on that plugin authors keep their plugin version up-to-date on the forum post.

Download

http://code.google.com/p/dg52-php-sm...downloads/list

Screenshot

[HSFighter]

Very nice Job

I try to check it tomorrow, and will give you feedback.

[DeaD_EyE82]

Nice Work.
Can you add a function to add the URLS for the Plugins manually?

[Doggie52]

DeaD_EyE82 - that's basically already implemented - simply edit the SQLite database (with something like SQLite DB browser 1.0) and add a row with the plugin's exact name in the `name` field and the corresponding URL in the `url` field. I'll add an easier way to do this in the near future!

EDIT: I have added this functionality in revision 5! Simply click the plugin's name and it will take you to a page where you can add your own URL. The new download is available on the main post.

[HSFighter]

Sorry for my late feedback.

All fine, it's working great

It's would be nice if your script watch the new plugins to,
and not only the approved plugins:

PHP Code:

// Match the plugin search page against patterns for URL and author
$searchpattern = "/(?:title=\"Approved\")(?:.*?)(?:\")(.*?)(?:\")(?:.*?)(?:<a href=\")(?:.*?)(?:\">)(.*?)(<\/a>)/i"; 


ELSE very nice Work ^^

[Cleric]

This is just great, kudos to you.

Will give this a go on my server in the near future and will hopefully give some feedback.

How about a choice between SQLite and Mysql?

[Dravu]

Did you get permission to have your script crawl and scrape the forum? I already have enough problems accessing it to be honest. Don't need extra load on the server.

Ask nicely and they might even come up with a much more light-weight search feature for finding plugin versions.

[Xsinthis]

I'll be up front, i don't know nothing about coding, so i'm purely saying this based on what i've read. By the sounds of it your crawling the forums, why not instead query/crawl the list of plugins they keep on the main pages? (http://www.sourcemod.net/plugins.php)

Also, why not get it to work with HSFighter's Wedadmin package

[HSFighter]

Originally Posted by Xsinthis I'll be up front, i don't know nothing about coding, so i'm purely saying this based on what i've read. By the sounds of it your crawling the forums, why not instead query/crawl the list of plugins they keep on the main pages? (http://www.sourcemod.net/plugins.php)

He get the plugin Version from the forum entrys.
The version appears in the headline of the plugin topic.
But the version doun't be show in a row in the pluginlist.

Originally Posted by Xsinthis Also, why not get it to work with HSFighter's Wedadmin package

If i get the permission from Doggie52 to do this,
i will add this nice function to the Webadmin and give the credits to Doggie52.

[Doggie52]

Hello everyone! Thank you all for the great feedback you've given me - please keep it coming ! I'll try to respond to your posts, bear with me for the wall of text..

Originally Posted by HSFighter Sorry for my late feedback. All fine, it's working great It's would be nice if your script watch the new plugins to, and not only the approved plugins: PHP Code: // Match the plugin search page against patterns for URL and author $searchpattern = "/(?:title=\"Approved\")(?:.*?)(?:\")(.*?)(?:\")(?:.*?)(?:<a href=\")(?:.*?)(?:\">)(.*?)(<\/a>)/i";  ELSE very nice Work ^^

The problem is that I then would have to search using something else than SourceMod's own plug-in search (since, AFAIK, it only returns approved plugins. If it can return unapproved plugins, please let me know how this would be done!). If you can recommend a search-tool I am able to GET request then I'd be glad to implement it. It would, however, take some additional time to load!

Originally Posted by Cleric This is just great, kudos to you. Will give this a go on my server in the near future and will hopefully give some feedback. How about a choice between SQLite and Mysql?

The ability to select between SQLite and MySQL is on my to-do list . But to be honest, there's no real downside to SQLite in this case. If you're struggling to edit the database, there are a number of tools you can use. One which I use is SQLite Browser 1.1.

Originally Posted by Dravu Did you get permission to have your script crawl and scrape the forum? I already have enough problems accessing it to be honest. Don't need extra load on the server. Ask nicely and they might even come up with a much more light-weight search feature for finding plugin versions.

What this script does is to simply query a URL for its HTML. When searching for plugins (on www.sourcemod.net) what it downloads is, on average, ~10KB per load - i.e. not too much to worry about. Also, due to the nature of PHP, no concurrent connections are made. What is queried is queried one after another, meaning less stress on the web server than if things happened simultaneously.

I cannot deny, however, that the script does indeed use a quite cumbersome method of obtaining plugin URLs and version. If you have any suggestions as to how I can improve it, please let me know or make a post in the Issue Tracker (linked in my original post). I will speak with the administrators of the site - perhaps they can give me an alternative to what I am using today.

Originally Posted by Xsinthis I'll be up front, i don't know nothing about coding, so i'm purely saying this based on what i've read. By the sounds of it your crawling the forums, why not instead query/crawl the list of plugins they keep on the main pages? (http://www.sourcemod.net/plugins.php) Also, why not get it to work with HSFighter's Wedadmin package

I'm not sure exactly what you mean in this case - the script is, in fact, crawling that page but with certain GET parameters that search for the plugin's name directly. If you mean that I should use the entire list of plugins (http://www.sourcemod.net/plugins.php...tion=&search=1) to gather my URL's then I must remind you about the following - that list includes all SourceMod-approved plugins and is a far larger (totals at around 800KB) download than 10-15 individual plugin's search pages.

Also, I have implemented a feature that caches each plugin's URL in a local database which means that next time the script is loaded, the SourceMod plugin search won't be queried at all (instead, the cached URL will be used).

What I can not do anything about, however, is the querying of forum pages. For each plugin, the script queries its corresponding forum URL to gather the latest version of the plugin. I have tried in different ways to minimize the HTML that is being downloaded without success:
- cURL's range option doesn't work with AM's server
- using a less intensive forum skin won't render the needed "Plugin Version:"
- only querying the first post (&postcount=1) won't render the "Plugin Version:" field either

I will suggest, to the administrators, some sort of change to the way plugin versions are handled on the site.

About the WebAdmin-package - if HSFighter is interested in obtaining a version of the script for his package he may contact me at any time. I would recommend, however, that this plugin is run by itself and not more than a few times per week due to the nature of what it does. I would, to be honest, prefer to keep the script to myself until it has "taken off" a bit, too (what I mean by that is that I'd prefer to keep my code from being redistributed although yes, I do know that is part of open source software). HSFighter, you may advice users to download the script and use it together with your package, but I would prefer if you sent them to the script's Google Code site for the actual download.