Forums

Latest Neocron News and Information

Parse error: parse error, unexpected T_VARIABLE

For all discussion about the Neocron 2 world.

Moderator: Tech Haven Network - Moderator team

Post a reply

Parse error: parse error, unexpected T_VARIABLE

Postby Syntax-Error » Fri Oct 03, 2003 9:26 pm

Parse error: parse error, unexpected T_VARIABLE in d:\program files\apache group\apache\htdocs\install_db.php on line 50


this is the code

Code: Select all
<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>

<body>
<p>Thank you for downloading EliteSquadrons.</p>
<p>EliteSquadrons is based off the Promisance™ Enhanced Engine. This install
  script and system is provided &quot;as-is&quot; without warrenty and by clicking
  &quot;INSTALL&quot; you agree to release Kirk Fickert (aka Unimatrix) Fickert
  Online Media, LLC and all others involved from liablity from damages</p>
<hr>
<p>Okay with that out of the way lets get EliteSquadrons installed. Are you ready
  for this? Let's go through a simple checklist and find out!</p>
<p>1. Did you read and understand the BSD licences?<br />
  2. Do you know that all graphics are copyright &copy; by its designer and may
  <strong>ONLY</strong> be used by PERMISSION of Lorian. <br />
  3. Do you have at least PHP 4.2.x installed? <br />
  4. Do you have MySQL installed and ready?<br />
  5. Did you edit const.php to match your server?<br />
  6. Did you take a shower this morning?<br />
  7. Did you remember to grab a cup of espresso before installing?<br />
  8. Do you think this is getting sarcastic and out of hand?<br />
  9. Do you have 5 hours a day to spend being an admin?<br />
  10. Do you have your own Code Monkey named Albert to chase down bugs?</p>
<p>If you answered &quot;no&quot; to one or more of the above, think twice before
  installing!</p>
<form name="form1" id="form1" method="post" action="">
  <p align="center">
    <label>Install Password
    <input type="password" name="textfield" />
    </label>
  </p>
  <p align="center">
    <label>
    <input name="submit" type="submit" id=" submit" value="install" />
    </label>
  </p>
</form>
<p>&nbsp;</p>
</body>
</html>

<?php
include('const.php') or die('damn const.php file is missing, kicking you out of the install process;')

$link = @mysql_connect("$dbhost", "$dbuser", "$dbpass") or die("cannot find the database, captain");
mysql_select_db($dbname) or die('cannot select the database');
   
//check the password

if ($installpwd == $textfield)
{      
//table structure for clanforum
mysql_query('CREATE TABLE '.$clanForumdb.' (
  num int(11) NOT NULL default '0',
  name text NOT NULL,
  PRIMARY KEY  (num)
)') or die('can forum db error, install aborted');
//Clan threads table structure
mysql_query('CREATE TABLE beta_clanthread (
  forum int(11) NOT NULL default '0',
  parent_id int(11) NOT NULL default '0',
  thread_id int(11) NOT NULL auto_increment,
  modified datetime NOT NULL default '0000-00-00 00:00:00',
  author text NOT NULL,
  title text NOT NULL,
  content text NOT NULL,
  added datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (thread_id)
) TYPE=MyISAM');
//fourm datastucture
mysql_query('CREATE TABLE beta_forum (
  forum_id tinyint(4) NOT NULL auto_increment,
  forum_name varchar(40) NOT NULL default '',
  notes tinytext NOT NULL,
  mod tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (forum_id)
) TYPE=MyISAM');
//
$query = 'INSERT INTO '.$forumdb.' (forum_id, forum_name, notes, mod) VALUES (6, 'General', 'Talk about anything under the sky.', 0)';
mysql_query($query);
$query2 = 'INSERT INTO '.$forumdb.' (forum_id, forum_name, notes, mod) VALUES (7, 'Alliance Talk', 'Diplomacy of Alliances.', 0)';
mysql_query($query2);
$query3 = 'INSERT INTO '.$forumdb.' (forum_id, forum_name, notes, mod) VALUES (9, 'Bugs and Suggestions', 'Have an idea about the game that you would like to be heard?', 0)';
mysql_query($query3);
//forum titles stricture
mysql_query('CREATE TABLE '.$titlesdb.' (
  `id` int(11) NOT NULL default '0',
  `title` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT="table for titles"');
mysql_query('INSERT INTO '.$titlesdb.' (`id`, `title`) VALUES (0, 'Normal User'),
(1, 'Special User'),
(2, 'Banned From Forum'),
(3, 'Banned From Game'),
(4, 'Forum Moderator'),
(5, 'Forum Admin'),
(6, 'Game Admin'),
(7, 'Owner')');
//clan db structure
mysql_query('CREATE TABLE '.$clandb.' (
  num smallint(5) unsigned NOT NULL auto_increment,
  founder mediumint(8) unsigned NOT NULL default '0',
  asst mediumint(8) unsigned NOT NULL default '0',
  fa1 mediumint(8) unsigned NOT NULL default '0',
  fa2 mediumint(8) unsigned NOT NULL default '0',
  ally1 smallint(5) unsigned NOT NULL default '0',
  ally2 smallint(5) unsigned NOT NULL default '0',
  ally3 smallint(5) unsigned NOT NULL default '0',
  war1 smallint(5) unsigned NOT NULL default '0',
  war2 smallint(5) unsigned NOT NULL default '0',
  war3 smallint(5) unsigned NOT NULL default '0',
  pic tinytext NOT NULL,
  url tinytext NOT NULL,
  motd text NOT NULL,
  members smallint(6) NOT NULL default '1',
  name tinytext NOT NULL,
  tag tinytext NOT NULL,
  password tinytext NOT NULL,
  PRIMARY KEY (num)
) TYPE=MyISAM');
//forum config
mysql_query('CREATE TABLE '.$forumconfig.' (
  forum_id int(11) default '0',
  all_html varchar(4) default 'NO',
  pre varchar(4) default 'NO',
  links varchar(4) default 'NO',
  images varchar(4) default 'NO',
  show_ip varchar(4) default 'YES',
  show_info varchar(4) default 'YES',
  block_hosts varchar(4) default 'NO'
) TYPE=MyISAM');



   else
echo "Nice try, but the passwords do not match!  Install Aborted!";
}

 ?>



anyone help????

$link = @mysql_connect("$dbhost", "$dbuser", "$dbpass") or die("cannot find the database, captain");

this is line 50
Since wars begin in the minds of men, it is in the minds of men that the defence of peace must be constructed.
- UNESCO Constitution
User avatar
Syntax-Error
THN Supahfan
 
Posts: 254
Joined: Wed Aug 20, 2003 9:35 am
Top

Postby HusK » Fri Oct 03, 2003 11:47 pm

try creating a config.php with the following:
Code: Select all
<?php
$dbms = 'mysql';

$dbhost = 'localhost';
$dbname = 'thenameofthedatabase';
$dbuser = 'thenameofthedatabaseuser_usualywebmasterloginname';
$dbpasswd = 'passwordofthedatabaseuser';

?>


Not sure if php auto looks for the config file, otherwise specify these variables in your current php file for testing purposes.
I'm no PhP/Sql guru but thats what I think of it.


You might first wanna check that 'const.php' file which is included in this page to be used as external resource, there might be some variables missing or not filled in correctly.
Tech Haven Network - Former Lead Moderator / Former co-administrator
User avatar
HusK
THN Whore
 
Posts: 1385
Joined: Thu Aug 21, 2003 8:19 pm
Location: Holland
Top

hmm

Postby Syntax-Error » Sat Oct 04, 2003 10:40 am

Code: Select all
<? // All the constants in the game

$dbhost = 'localhost';         // MySQL server hostname
$dbuser = 'syntax';         // MySQL username
$dbpass = 'tigger';         // MySQL password
$dbname = 'elitesqu_promgames';   // MySQL database name
$version = 'ES 2.3.1';      // Game version number
$tbl = 'game3m_';         // Table prefix to run multiple games from the same DB
$playerdb = $tbl.'players';      // Player table name
$racedb = $tbl.'races';      // Races table name
$eradb = $tbl.'eras';      // Eras table name
$lotterydb = $tbl.'lottery';      // Lottery table name
$marketdb = $tbl.'market';      // Public Market table name
$messagedb = $tbl.'messages';   // Messages table name
$newsdb = $tbl.'news';      // News table name
$clandb = $tbl.'clan';    // Clans table name
$forumdb= $tbl.'forum';   //Forums table name
$threaddb= $tbl.'thread';   //Thread table name
$clanForumdb= $tbl.'clanForum';   //clan forum table name
$clanThreaddb= $tbl.'clanThread';   //clan forum's thread table name
$titledb= $tbl.'titles'; //table for titles
$forumconfig = $tbl.'config'; //forum config file

//INSTALLER
$installpwd = 'iamgod'; //this is the password to allow the installer script to install the db CHANGE IT

// REQUIRED
$httpref[1] = 'elitesquadrons.net'; // You can put here your full host: prom.test.com or part of it: test.com or: test
$httpref[2] = '127.0.0.1'; // You put here your IP or part of it: 127.0.0.1 or 127.0.0

//solve the WB bug
$config[allowwb] = 1; //0 = no, 1= yes

$config[protection] = 200;   // Duration of protection
$config[initturns] = 150;   // Turns given on signup
$config[maxturns] = 480;   // Max accumulated turns (Default: 960 = 48 hours)
$config[maxstoredturns] = 240;   // Max stored turns (Default: 480 = 24 hours)
$config[valturns] = 175;   // How long before validation is necessary
$config[shamemult] = 5; // The 3% Multiplier. (Default: 5)
$config[nonattack] = 20; // The "Can't attack" (Default: 50)
$config[edneed] = 65000; // Acres Need for casting Emminent Domain (Default: 10000)
$config[edcap] = 750; // Emminent Domain Cap (Default: 5000)
$config[buymarket] = 0; // Let users in protection buy in the public market? (Default: 0) (0 = no) (1 = yes)
$config[maxattacks] = 20; // Too many attacks

$config[clans] = 1; // Let clans? (0=no)(1=yes)

$config[wmd] = 0; // Allow weapons of Mass Destruction? (0=no)(1=yes) note this is not yet available

$config[minvacation] = 48;   // Minimum vacation duration
$config[vacationdelay] = 6;   // Delay before empire is protected

//Cheating config created by Unimatrix
$cheat[ipcheck] = 1; //On sign up checks to see if anyone else has signed up using same IP.  While it helps stop multis, families with multiple players and those behind proxies will have problems (0=no)(1=Yes)
$cheat[multiwait] = 48; //How many hours long until declared multi accounts are deleted (Default = 48 hour)
$cheat[cheatadmin] = 'cheating@mydomain.com'; //this is the email of who is incharge of dealing with cheaters. 


// Styles Configuration

$config[maxstyles] = 5; // Max Styles
$styles[0] = "Default Style"; // 2nd Style
$styles[1] = "EZCLAN"; //3rd styles
$styles[2] = "EliteRed"; //4th style
$styles[3] = "QM Standard"; //5th style
$styles[4] = "Nuitari"; //Christmass theme

// Message Configuration

$config[maxmsg] = 10; // Max Messages you can send. (Default: 10)

// Aid Configuration

$config[canaid] = 1; // Can Send Aid? (0 = No, 1 = Yes)
$config[aidtax] = .33; // Aid Tax (Default: .10) (.10 = 10%)
$config[nonaid] = 3; // The Aid multiplier (Default: .75) meaning you can aid someone 1/75 your size.
$config[aid_ac] = 1; // This is an anti cheating measure, if you want to turn it off put 0 (Default: 1)
$config[maxaid] = 2; // This is the max aiding you can do. (Default: 1)
$config[aidhours] = 24; // The hours to reset the aiding :P (Default: 24) (From 1-24 please)
$config[maxaidget] = 1; // This is how many aid can you get (Default: 1)

// DB Configuration

$signupsclosed = 0;      // Signups closed?
$lockdb = 0;         // Lock the players database?
$lastweek = 0;         // Last week of the game? don't allow loans

$turnsper = 10;         // X turns
$perminutes = 30;      // per Y minutes
$turnoffset = 0;      // in case we don't run exactly 0 minutes after the hour
            // Note: perminutes must divide evenly into 60
$healthper = 2;       // how many health points do you recover everytime the turns.php script is runned.

$maxtickets = 5;      // Maximum # of lottery tickets per empire
$config[jackpot] = 250000000000;  //lottery base jackpot

$tick_curjp = 0;      // DO NOT MODIFY THESE
$tick_lastjp = 1;      // DO NOT MODIFY THESE
$tick_lastnum = 2;      // DO NOT MODIFY THESE
$tick_lastwin = 3;      // DO NOT MODIFY THESE
$tick_jpgrow = 4;      // DO NOT MODIFY THESE

$trplst[0] = 'armtrp';      // an array of troop names so for loops can be used when all types are referenced
$trplst[1] = 'lndtrp';      // DO NOT MODIFY THESE
$trplst[2] = 'flytrp';      // DO NOT MODIFY THESE
$trplst[3] = 'seatrp';      // DO NOT MODIFY THESE
$trplst[4] = 'food';      // this commonly follows the troop listings


$config[armtrp] = 120;      // Base market costs
$config[lndtrp] = 220;
$config[flytrp] = 360;
$config[seatrp] = 550;
$config[food] = 25;

$config[loanbase] = 6;      // Base savings/loan rates
$config[savebase] = 4;
$config[buildings] = 2000;   // Base building cost
$config[maxbuild] = 1000; // max builds
$config[market] = 1;      // Hours to arrive on market
$config[mktshops] = 0.25;   // percentage of cost black market bonus for which shops are responsible



            // News text
$config[news] = '<span class="gnews">Prom Enhanced Patch installed<br><a href="http://www.hotscripts.com/cgi-bin/rate.cgi?ID=19896" target=_blank>Rate Our Program @ HotScripts.com</a>';

            // Name of primary script file. DO NOT MODIFY
$config[main] = 'promisance.php';

            // Site/path in which the game resides (always end it with /)
$config[sitedir] = 'http://server1.elitesquadrons.net/';

            // server title
$config[servname] = 'Server1: Clans | Game 3';

            // where we go when we logout
$config[home] = 'http://www.elitesquadrons.net/';

            // link to forum for this game
$config[forums] = 'http://forums.elitesquadrons.net/index.php?c=6';

            // administrative contact
$config[adminemail] = 'kfickert@drury.edu';

            // From address of validation emails
$config[valemail] = 'nobody@elitesquadrons.net';

$config[updater] = 1; // Default: 1

DEFINE("VSI",10202012); //not sure what this is, let it be



$time = time();         // not really constants, but stuff used for all pages
$datetime = date('r');
$cookie = $HTTP_COOKIE_VARS;
?>



thats const.php
Since wars begin in the minds of men, it is in the minds of men that the defence of peace must be constructed.
- UNESCO Constitution
User avatar
Syntax-Error
THN Supahfan
 
Posts: 254
Joined: Wed Aug 20, 2003 9:35 am
Top

hmm

Postby Syntax-Error » Sat Oct 04, 2003 10:42 am

Brammers get ure ass here..

i fixed the error message.. infact now i get a blank page, no error and its says "done" rest of pages are fine. just ask me to login so PHP is ok.. just pages

install_db.php:


Code: Select all
<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>

<body>
<p>Thank you for downloading EliteSquadrons.</p>
<p>EliteSquadrons is based off the Promisance™ Enhanced Engine. This install
  script and system is provided &quot;as-is&quot; without warrenty and by clicking
  &quot;INSTALL&quot; you agree to release Kirk Fickert (aka Unimatrix) Fickert
  Online Media, LLC and all others involved from liablity from damages</p>
<hr>
<p>Okay with that out of the way lets get EliteSquadrons installed. Are you ready
  for this? Let's go through a simple checklist and find out!</p>
<p>1. Did you read and understand the BSD licences?<br />
  2. Do you know that all graphics are copyright &copy; by its designer and may
  <strong>ONLY</strong> be used by PERMISSION of Lorian. <br />
  3. Do you have at least PHP 4.2.x installed? <br />
  4. Do you have MySQL installed and ready?<br />
  5. Did you edit const.php to match your server?<br />
  6. Did you take a shower this morning?<br />
  7. Did you remember to grab a cup of espresso before installing?<br />
  8. Do you think this is getting sarcastic and out of hand?<br />
  9. Do you have 5 hours a day to spend being an admin?<br />
  10. Do you have your own Code Monkey named Albert to chase down bugs?</p>
<p>If you answered &quot;no&quot; to one or more of the above, think twice before
  installing!</p>
<form name="form1" id="form1" method="post" action="">
  <p align="center">
    <label>Install Password
    <input type="password" name="textfield" />
    </label>
  </p>
  <p align="center">
    <label>
    <input name="submit" type="submit" id=" submit" value="install" />
    </label>
  </p>
</form>
<p>&nbsp;</p>
</body>
</html>

<?php
include('const.php') or die('damn const.php file is missing, kicking you out of the install process;')

$link = @mysql_connect($dbhost, $dbuser, $dbpass) or die('cannot find the database, captain');
mysql_select_db($dbname) or die('cannot select the database');
   
//check the password

if ($installpwd == $textfield)
{      
//table structure for clanforum
mysql_query('CREATE TABLE '.$clanForumdb.' (
  num int(11) NOT NULL default '0',
  name text NOT NULL,
  PRIMARY KEY  (num)
)') or die('can forum db error, install aborted');
//Clan threads table structure
mysql_query('CREATE TABLE beta_clanthread (
  forum int(11) NOT NULL default '0',
  parent_id int(11) NOT NULL default '0',
  thread_id int(11) NOT NULL auto_increment,
  modified datetime NOT NULL default '0000-00-00 00:00:00',
  author text NOT NULL,
  title text NOT NULL,
  content text NOT NULL,
  added datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (thread_id)
) TYPE=MyISAM');
//fourm datastucture
mysql_query('CREATE TABLE beta_forum (
  forum_id tinyint(4) NOT NULL auto_increment,
  forum_name varchar(40) NOT NULL default '',
  notes tinytext NOT NULL,
  mod tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (forum_id)
) TYPE=MyISAM');
//
$query = 'INSERT INTO '.$forumdb.' (forum_id, forum_name, notes, mod) VALUES (6, 'General', 'Talk about anything under the sky.', 0)';
mysql_query($query);
$query2 = 'INSERT INTO '.$forumdb.' (forum_id, forum_name, notes, mod) VALUES (7, 'Alliance Talk', 'Diplomacy of Alliances.', 0)';
mysql_query($query2);
$query3 = 'INSERT INTO '.$forumdb.' (forum_id, forum_name, notes, mod) VALUES (9, 'Bugs and Suggestions', 'Have an idea about the game that you would like to be heard?', 0)';
mysql_query($query3);
//forum titles stricture
mysql_query('CREATE TABLE '.$titlesdb.' (
  `id` int(11) NOT NULL default '0',
  `title` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT="table for titles"');
mysql_query('INSERT INTO '.$titlesdb.' (`id`, `title`) VALUES (0, 'Normal User'),
(1, 'Special User'),
(2, 'Banned From Forum'),
(3, 'Banned From Game'),
(4, 'Forum Moderator'),
(5, 'Forum Admin'),
(6, 'Game Admin'),
(7, 'Owner')');
//clan db structure
mysql_query('CREATE TABLE '.$clandb.' (
  num smallint(5) unsigned NOT NULL auto_increment,
  founder mediumint(8) unsigned NOT NULL default '0',
  asst mediumint(8) unsigned NOT NULL default '0',
  fa1 mediumint(8) unsigned NOT NULL default '0',
  fa2 mediumint(8) unsigned NOT NULL default '0',
  ally1 smallint(5) unsigned NOT NULL default '0',
  ally2 smallint(5) unsigned NOT NULL default '0',
  ally3 smallint(5) unsigned NOT NULL default '0',
  war1 smallint(5) unsigned NOT NULL default '0',
  war2 smallint(5) unsigned NOT NULL default '0',
  war3 smallint(5) unsigned NOT NULL default '0',
  pic tinytext NOT NULL,
  url tinytext NOT NULL,
  motd text NOT NULL,
  members smallint(6) NOT NULL default '1',
  name tinytext NOT NULL,
  tag tinytext NOT NULL,
  password tinytext NOT NULL,
  PRIMARY KEY (num)
) TYPE=MyISAM');
//forum config
mysql_query('CREATE TABLE '.$forumconfig.' (
  forum_id int(11) default '0',
  all_html varchar(4) default 'NO',
  pre varchar(4) default 'NO',
  links varchar(4) default 'NO',
  images varchar(4) default 'NO',
  show_ip varchar(4) default 'YES',
  show_info varchar(4) default 'YES',
  block_hosts varchar(4) default 'NO'
) TYPE=MyISAM');



   else
echo "Nice try, but the passwords do not match!  Install Aborted!";
}

 ?>



and index.php

Code: Select all
<?
include("const.php");
Header("Location: ".$config[sitedir].$config[main]."?action=login");
?>
Since wars begin in the minds of men, it is in the minds of men that the defence of peace must be constructed.
- UNESCO Constitution
User avatar
Syntax-Error
THN Supahfan
 
Posts: 254
Joined: Wed Aug 20, 2003 9:35 am
Top

Postby Brammers » Sat Oct 04, 2003 12:28 pm

Check you php.ini file and ensure the mysql.dll module is enabled - the windows version of php has a habbit of having everything turned off by default - this includes error handling.
Brammers - THN Admin & CEO Phoenix Ltd.
Image
User avatar
Brammers
THN Lead Administrator
 
Posts: 4036
Joined: Tue Aug 19, 2003 9:49 am
Location: Phoenix Ltd: CEO office
Clan: Phoenix Ltd
Faction: Fallen Angels
Top

Postby HusK » Sat Oct 04, 2003 5:11 pm

Another reason not to run a webserver on windows :p

...or mayb it is as good as a reason to do so, having everything on at default is the thing I hate most about windows, glad to see the php windows version does the oposit.

Anyway, backup what you got now and put the origional ones back in place, these auto builded pages are always working on good configured servers ( why? because there tested by hundreds of peoples who don't have this problem :x )

the usual way is that index.php takes you to the installer scripts and won't anymore after they have been finished, it sounds to me like you never even got there.
For best testing I'd say put the origional ones back and only edit the const.php file with the database name, location, user and pass.
It looks like you filled them in correctly.
Also make sure there are enough rights to edit, read, add etc etc to the database, since your talking windows I wouldn't be surprised if the database file(s) itself where readonline :p would be just a thing that windows might do.

Now for the rest, I'll leave it to the profesionals, I've only just started writing my own php pages and this is way beyond my league, altho I do understand alot of the code since its just like how most other program language codes look.
Last edited by HusK on Sat Oct 04, 2003 5:19 pm, edited 2 times in total.
Tech Haven Network - Former Lead Moderator / Former co-administrator
User avatar
HusK
THN Whore
 
Posts: 1385
Joined: Thu Aug 21, 2003 8:19 pm
Location: Holland
Top

hmm

Postby Syntax-Error » Sat Oct 04, 2003 5:15 pm

;Windows Extensions
;Note that MySQL and ODBC support is now built in, so no dll is needed for it.



now what?
Since wars begin in the minds of men, it is in the minds of men that the defence of peace must be constructed.
- UNESCO Constitution
User avatar
Syntax-Error
THN Supahfan
 
Posts: 254
Joined: Wed Aug 20, 2003 9:35 am
Top

Postby HusK » Sat Oct 04, 2003 5:21 pm

As I have no knowladge of how the windows versions of php and (my-)sql work I can't say more than to look for more help on deja ( google newsgroups ) just do a view searches till you find someone with a simular problem, with most likely peoples ideas and fixes for them ;)
Tech Haven Network - Former Lead Moderator / Former co-administrator
User avatar
HusK
THN Whore
 
Posts: 1385
Joined: Thu Aug 21, 2003 8:19 pm
Location: Holland
Top

Postby HusK » Sat Oct 04, 2003 5:23 pm

Ow erm, did I mention PHP extentions? Mayb this thing your trying to get working uses a few that you don't have or uses PHP functions you disabled slash never enabled.


Anoter thing that comes to mind, you said support is build in, which means the database system itself is not ( duh? :p ) I gues your using MySql and have that up and running....anyway if your not sure about something try www.webmonkey.com aswell for some help.
Tech Haven Network - Former Lead Moderator / Former co-administrator
User avatar
HusK
THN Whore
 
Posts: 1385
Joined: Thu Aug 21, 2003 8:19 pm
Location: Holland
Top

Postby Brammers » Sat Oct 04, 2003 8:39 pm

Ok in a page called say info.php

Code: Select all
<?
phpinfo();
?>



Call up the page and make sure it has a section with Mysql in it. If you need an example I'll PM a url to you.
Brammers - THN Admin & CEO Phoenix Ltd.
Image
User avatar
Brammers
THN Lead Administrator
 
Posts: 4036
Joined: Tue Aug 19, 2003 9:49 am
Location: Phoenix Ltd: CEO office
Clan: Phoenix Ltd
Faction: Fallen Angels
Top

hmm

Postby Syntax-Error » Sun Oct 05, 2003 1:05 am

Code: Select all
mysql
MySQL Support enabled
Active Persistent Links  0 
Active Links  0 
Client API version  3.23.49 

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout -1 -1
mysql.default_host localhost localhost
mysql.default_password no value no value
mysql.default_port 3306 3306
mysql.default_socket no value no value
mysql.default_user root root
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
Since wars begin in the minds of men, it is in the minds of men that the defence of peace must be constructed.
- UNESCO Constitution
User avatar
Syntax-Error
THN Supahfan
 
Posts: 254
Joined: Wed Aug 20, 2003 9:35 am
Top

Postby Brammers » Sun Oct 05, 2003 10:56 am

Hmm I get Parse error: parse error in /home/httpd/domains/tintagel.monolight.org/in.php on line 50 - what version of PHP are you using?

Add a missing ; to the line above so it reads

Code: Select all
include('const.php') or die('damn const.php file is missing, kicking you out of the install process;');


Then on the mysql query lines change the open and closing ' to " or within the query string escape the ' s eg \' So...

Code: Select all
mysql_query("CREATE TABLE beta_clanthread (
  forum int(11) NOT NULL default '0',
  parent_id int(11) NOT NULL default '0',
  thread_id int(11) NOT NULL auto_increment,
  modified datetime NOT NULL default '0000-00-00 00:00:00',
  author text NOT NULL,
  title text NOT NULL,
  content text NOT NULL,
  added datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (thread_id)
) TYPE=MyISAM");


or

Code: Select all
mysql_query('CREATE TABLE beta_clanthread (
  forum int(11) NOT NULL default \'0\',
  parent_id int(11) NOT NULL default \'0\',
  thread_id int(11) NOT NULL auto_increment,
  modified datetime NOT NULL default \'0000-00-00 00:00:00\',
  author text NOT NULL,
  title text NOT NULL,
  content text NOT NULL,
  added datetime NOT NULL default \'0000-00-00 00:00:00\',
  PRIMARY KEY  (thread_id)
) TYPE=MyISAM');


and do the same for the others...
Brammers - THN Admin & CEO Phoenix Ltd.
Image
User avatar
Brammers
THN Lead Administrator
 
Posts: 4036
Joined: Tue Aug 19, 2003 9:49 am
Location: Phoenix Ltd: CEO office
Clan: Phoenix Ltd
Faction: Fallen Angels
Top

hmm

Postby Syntax-Error » Mon Oct 06, 2003 8:49 am

sorted one of them with the help of some guy. (i sent it to him he fixed it sent it back)

now i get lots of new errors.. so im working on those :P
Since wars begin in the minds of men, it is in the minds of men that the defence of peace must be constructed.
- UNESCO Constitution
User avatar
Syntax-Error
THN Supahfan
 
Posts: 254
Joined: Wed Aug 20, 2003 9:35 am
Top
Post a reply

Return to Tech Haven Sector 2

Who is online

Users browsing this forum: No registered users and 7 guests