How to install PHP-Nuke on GoDaddy without a command line?

Nuke Cadet Joined: Oct 21, 2003 Posts: 3

Hi all,
I have an account with GoDaddy. Installing PHPBB was a breeze since there was a script that created the SQL database entries. With Nuke, you get an SQL file and command-line instructions. GoDaddy doesn't provide a command line, just a web-based query interface. They don't support telnet or ssh at all; just ftp, and I can't ftp into the server where the SQL database lives, I'm only allowed to ftp into my site. I'm at my wits end. Is there a way to take nuke.sql and wrap something around it that will create the database for me? Thanks.

Mike

Posted: Wed Oct 22, 2003 12:26 am

Upload PHPMyadmin, via ftp, to your site Wink

Nuke Cadet Joined: Oct 21, 2003 Posts: 3

I'm sorry...I should have mentioned that the web-based interface that GoDaddy provides IS PHPMyAdmin. The problem is that it doesn't allow me to do anything except queries and create entries one at a time. Will installing PHPMyAdmin in my own space help?

Mike

Nuke Cadet Joined: Oct 22, 2003 Posts: 4

yes with your own pma install it should be possible.

I have created a script.

I have created a Script that fill the Data automaticly:

Code:

<html>
<head>
<title>SqlData.php - by Alex B. </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php

if($fehler) {
$fehler=urldecode($fehler);
}

if($submit=="Uebertragen")
{
   echo "<br>Verbinde zu Datenbank...<br>";
   $conn=mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbdb, $conn);

   echo "<br>Starting $sqlfile...<br>";

   $filep=file("./$sqlfile");
   $buf="";
   while (list($nr,$val) = each($filep)) {
      if(substr($val,0,1)!="#")
      {
         $buf.=" ".trim($val);
         if(substr(trim($buf),-1,1)==";")
         {
            $res=mysql_query($buf,$conn);
            if(!$res) {$fehler .= $buf."\r\n\r\n";}
            $buf="";
         }
      }
   }

   echo "<br>READY.";
}

if(!$sqlfile) {$sqlfile="sqldata.sql";}
if(!$dbhost) {$dbhost="localhost";}

?>
<form name="sqlselect" method="POST" action="sqldata.php">
<table border="1">
<tr>
<td valign="top"><font size="+1"><strong>SQL-datei</strong></font></td>
<td><input name="sqlfile" type="text" id="sqlfile" value="<?php echo $sqlfile; ?>" size="80"></td>
</tr>
<tr>
<td valign="top"><font size="+1"><strong>DB Host</strong></font></td>
<td><input name="dbhost" type="text" id="dbhost" value="<?php echo $dbhost; ?>" size="80"></td>
</tr>
<tr>
<td valign="top"><font size="+1"><strong>DB User</strong></font></td>
<td><input name="dbuser" type="text" id="dbuser" value="<?php echo $dbuser; ?>" size="80"></td>
</tr>
<tr>
<td valign="top"><font size="+1"><strong>DB Pass</strong></font></td>
<td><input name="dbpass" type="text" id="dbpass" value="<?php echo $dbpass; ?>" size="80"></td>
</tr>
<tr>
<td valign="top"><font size="+1"><strong>DB Database</strong></font></td>
<td><input name="dbdb" type="text" id="dbdb" value="<?php echo $dbdb; ?>" size="80"></td>
</tr>
<tr>
<td valign="top"> </td>
<td><input type="submit" name="submit" value="Uebertragen"></td>
</tr>
<tr>
<td valign="top">Fehlerhafte<br>
Anweisungen:</td>
<td><textarea name="fehler" cols="74" rows="10"><?php echo $fehler; ?></textarea></td>
</tr>
</table>
</form>
</body>
</html>

Posted: Wed Oct 22, 2003 6:50 am

soulmate.. great script, would be even better if you could possibly translate german language sections into English please? Wink

Nuke Cadet Joined: Oct 21, 2003 Posts: 3

That did it!

I had to take all the comments out of the nuke.sql file but after that it worked fine. Thanks!

Mike

Nuke Cadet Joined: Oct 22, 2003 Posts: 4

aehm yes sorry Wink

here it is:

Code:

<html>
<head>
<title>SqlData.php - by Alex B. </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php

if($fehler) {
$fehler=urldecode($fehler);
}

if($submit=="Send")
{
echo "<br>Connect to database...<br>";
$conn=mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbdb, $conn);

echo "<br>Starting $sqlfile...<br>";

$filep=file("./$sqlfile");
$buf="";
while (list($nr,$val) = each($filep)) {
if(substr($val,0,1)!="#")
{
$buf.=" ".trim($val);
if(substr(trim($buf),-1,1)==";")
{
$res=mysql_query($buf,$conn);
if(!$res) {$fehler .= $buf."\r\n\r\n";}
$buf="";
}
}
}

echo "<br>READY.";
}

if(!$sqlfile) {$sqlfile="sqldata.sql";}
if(!$dbhost) {$dbhost="localhost";}

?>
<form name="sqlselect" method="POST" action="sqldata.php">
<table border="1">
<tr>
<td valign="top"><font size="+1"><strong>SQL-datei</strong></font></td>
<td><input name="sqlfile" type="text" id="sqlfile" value="<?php echo $sqlfile; ?>" size="80"></td>
</tr>
<tr>
<td valign="top"><font size="+1"><strong>DB Host</strong></font></td>
<td><input name="dbhost" type="text" id="dbhost" value="<?php echo $dbhost; ?>" size="80"></td>
</tr>
<tr>
<td valign="top"><font size="+1"><strong>DB User</strong></font></td>
<td><input name="dbuser" type="text" id="dbuser" value="<?php echo $dbuser; ?>" size="80"></td>
</tr>
<tr>
<td valign="top"><font size="+1"><strong>DB Pass</strong></font></td>
<td><input name="dbpass" type="text" id="dbpass" value="<?php echo $dbpass; ?>" size="80"></td>
</tr>
<tr>
<td valign="top"><font size="+1"><strong>DB Database</strong></font></td>
<td><input name="dbdb" type="text" id="dbdb" value="<?php echo $dbdb; ?>" size="80"></td>
</tr>
<tr>
<td valign="top"> </td>
<td><input type="submit" name="submit" value="Send"></td>
</tr>
<tr>
<td valign="top">Error:<br>
:</td>
<td><textarea name="fehler" cols="74" rows="10"><?php echo $fehler; ?></textarea></td>
</tr>
</table>
</form>
</body>
</html>

The Variable Fehler you can translate with error.

The script should be upload in thes same dictornary there the config.php is.

Cu
alex

Nuke Cadet Joined: Jul 08, 2003 Posts: 3

I know this post is old news but I'm looking to do the same thing however I feel like I just stepped off the plane in Japan for the first time with this.

Is it possible to run me through some basics on setting this up? To show my greeness, I think the code above is saved to notepad and renamed to something.php right?

So far I've uploaded all php files to the root of the server... and that's about it. godaddy isn't the best hosting out there I know but it's not my site.. just trying to build it correctly. This is nothing like cpanel.

Thank you for the help and please don't smack me yet, I'll catch on. Very Happy

Captain Joined: Mar 08, 2004 Posts: 319 Location: USA

go download phpmyadmin and then upload it to your site, it will help administer your databases.

Wiit

Nuke Soldier Joined: Nov 03, 2005 Posts: 20

Hi, I could use some help here. I tried to install phpadmin, but i can't even seem to do that. godaddy already uses phpadmin and I tried the script, but when i click send it just goes to a 404page. any ideas here?

Nuke Soldier Joined: Nov 03, 2005 Posts: 10

Not sure if this is the appropriate thread, but what the hey...

Noob here... I too have GoDaddy.com hosting (its cheap as hell, what can i say) but I'm having trouble getting the PHPNuke off the ground... for one, what are the settings to use in the config.php? like the dbhost etc etc some deatiled response guiding me through this would be awesome.

I have tried a number of combinations, but no success, may not be my only problem, but hey, first things first.

Thanks for the help.

SN on AIM is TheBeefToad if that is easier.

Posted: Fri Nov 04, 2005 4:16 pm

Try this -

Quote:

$dbhost = "localhost";
$dbuname = "yourdbname";
$dbpass = "yourpw";
$dbname = "nuke";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "yoursitekeygoeshere";
$gfx_chk = 0;
$subscription_url = "";
$admin_file = "admin";
$tipath = "images/topics/";
$nuke_editor = 0;
$display_errors = true;
$AllowAllHTML = 1;
$AllowNonAlphaCode = 1;

I have several domains on GoDaddy servers with no phpNuke problems

Nuke Cadet Joined: Aug 31, 2007 Posts: 2

i'm a toltal newbie at this so im not even sure where to put all that stuff in at tho a step by step guide would really be handy for us newbies