Version Check in vb3.6

[rogersnm]

What exactly do you put in the target page for a version check?

Regards,
Nick.

PS. Someone must know but i don't.

[derekivey]

You have to put the following on a page:
<version productid="x">1.2.3</version>

I made myself a PHP script that I just put my hacks version info in a database and it prints it out for me for each of my hacks.

[rogersnm]

thanks, could you share the script?

[derekivey]

Sure let me zip it up. I'll edit my post and attach the script in a sec.

Derek

Here is the script:


<?php

if ($_REQUEST['product'])
{
mysql_connect('localhost', 'username', 'password') or die('<strong>Error:</strong> Could not connect to the MySQL Server.');
mysql_select_db('database') or die('<strong>Error:</strong> Could not select database.');
$query = "SELECT version FROM versions WHERE productid = '" . mysql_real_escape_string($_REQUEST['product']) . "' LIMIT 1";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);

if ($num_rows == 1)
{
$info = mysql_fetch_array($result);

print '<version productid="' . $_REQUEST['product'] . '">' . $info['version'] . '</version>';
}
else
{
exit;
}
}
else
{
exit;
}

?>


And you will need to create a database, edit the script code with the database info, and import the following SQL:

CREATE TABLE `versions` (
`id` int(10) unsigned NOT NULL auto_increment,
`productid` varchar(50) NOT NULL default '',
`version` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

INSERT INTO `versions` VALUES (1, 'productid', '1.0.0');


You will have to manually add products through PHPMyAdmin.

For the version check field in vB's product manage just type http://www.yourdomain.com/file_name_of_script.php?product=yourscriptsproduct id

Derek

[Revan]

Thanks for the script, but why not use the version column in the product table already in vBulletin?

[Dan]

Revan i think that's for the version checker on your own website. But not sure.

[Revan]

Yeah but its quite possible to get that to connect to a vB database too ennit :p

[derekivey]

Didn't think of that. Good idea!