<?
echo'<h2>Userawards-Addon by FIRSTBORN e.V. </h2>';
function install(){
mysql_query("DROP TABLE IF EXISTS "webs_"user_award_list");
mysql_query("DROP TABLE IF EXISTS "webs_"user_awards");
$don=mysql_query("CREATE TABLE "webs_"user_award_list (
uawardID int(11) auto_increment PRIMARY KEY,
name varchar(255),
info text,
image varchar(255)
)");

$don1=mysql_query("CREATE TABLE "webs_"user_awards (
uwID int(11) auto_increment PRIMARY KEY,
userID int(11),
awardID int(11)
)");

if($don AND $don1)return true;
else return false;
}
$do=install();
if($do) echo"Install complete! Delete installuserawards.php from your system!";
else echo'Install failed! <br> Enter the following code into your Database manually:<br>
<textarea style="width:100%" rows="10">DROP TABLE IF EXISTS 'webs_'user_award_list;
DROP TABLE IF EXISTS 'webs_'user_awards;
CREATE TABLE 'webs_'user_award_list (
uawardID int(11) auto_increment PRIMARY KEY,
name varchar(255),
info text,
image varchar(255)
);
CREATE TABLE 'webs_'user_awards (
uwID int(11) auto_increment PRIMARY KEY,
userID int(11),
awardID int(11)
);</textarea>';
?>