<?
/*****************************************************************
* install.php                                                    *
******************************************************************
* Programm:      Thank You Mod                                   *
* By:            DIN1031 (http://www.ayu-kult.de/)               *
* Copyright:     DIN1031 (http://www.ayu-kult.de/)               *
*****************************************************************/

global $db_prefix, $modSettings;

//I can't install it if this on <<
$old_querycheck = isset($modSettings['disableQueryCheck']) ? $modSettings['disableQueryCheck'] : 0;
$modSettings['disableQueryCheck'] = 1;

// create the maps table
db_query("
CREATE TABLE IF NOT EXISTS {$db_prefix}thank_you (
ID_THX INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
ID_TOPIC MEDIUMINT(8) UNSIGNED NOT NULL ,
ID_MEMBER MEDIUMINT(8) UNSIGNED NOT NULL ,
memberName VARCHAR(80) NOT NULL ,
PRIMARY KEY (ID_THX) ,
INDEX (ID_TOPIC, ID_MEMBER)
) TYPE = MYISAM ;", __FILE__, __LINE__);

//ALTER the Topics to set thank you :)
//First check if it not allready set :X
$request = db_query("SHOW COLUMNS FROM {$db_prefix}topics", __FILE__, __LINE__);

$nothankinstalled = TRUE;

while($row = mysql_fetch_assoc($request))
	$nothankinstalled = $row['Field'] !== 'thank_you';

mysql_free_result($request);

if($nothankinstalled)
	db_query("ALTER TABLE {$db_prefix}topics ADD thank_you TINYINT(4) DEFAULT '0' NOT NULL;", __FILE__, __LINE__);

//Board premissions to add?
$request = db_query("SHOW COLUMNS FROM {$db_prefix}boards", __FILE__, __LINE__);

$nothankinstalled = TRUE;

while($row = mysql_fetch_assoc($request))
	$nothankinstalled = $row['Field'] !== 'thank_you_automatic';

mysql_free_result($request);

if($nothankinstalled)
	db_query("ALTER TABLE {$db_prefix}boards ADD thank_you_automatic TINYINT(4) DEFAULT '0' NOT NULL;", __FILE__, __LINE__);

//Okay Work done ;) (Replace the Varibale back...)
$modSettings['disableQueryCheck'] = $old_querycheck;
?>