Thread subject: muscapaul's PHP-Fusion website :: Missing table

Posted by muscapaul on 13-11-2006 13:31
#9

Another try, Please report any error messages here again.
Code
<?php
$result = dbquery("CREATE TABLE ".$db_prefix."term_settings (
  term_org varchar(100) NOT NULL default '',
  term_to varchar(100) NOT NULL default '',
  term_ratings tinyint(1) NOT NULL default '0',
  term_usergroup tinyint(3) NOT NULL default '0',
  term_type tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;");
if (!$result) $fail = "error one";
echo $fail;

$locale['term204'] = "one"; //replace 'one' for 'Term' (Glossary), 'Word' (Dictionary), 'Term/Word' (Default) or the translation into your language
$locale['term605'] = "Please, set Target Language in Dictionary - General Settings]"; //or replace for the translation into your language
$result = dbquery("INSERT INTO ".$db_prefix."term_settings (term_org, term_to, term_ratings, term_usergroup, term_type) VALUES ('".$locale['term204']."', '".$locale['term605']."', '0', '103', '2')");
   if (!$result) $fails = "error two";
echo $fails;
?>