<?


//


// Quick php script to test if database table is writeable by this user


// Author: Raven 11/26/2005


//


include("mainfile.php");


// Attempt to retrieve current sitename from nuke_config table


echo "<b><u>Attempting to retrieve current value</u></b>";


$sql = "SELECT sitename from ".$prefix."_config";


$result = $db->sql_query($sql);


echo '<br />$result = '.$result;


echo '<br />Number of rows retrieved = '.$db->sql_numrows($result);


$record = $db->sql_fetchrow($result);


$oldSiteName = $record['sitename'];


echo '<br />Sitename before write attempt = '.$oldSiteName;





// Attempt to update current sitename in nuke_config table


echo "<br /><br /><b><u>Attempting to update current value</u></b>";


$sql = "UPDATE ".$prefix."_config SET sitename = 'TEST SITE'";


$result = $db->sql_query($sql);


if (mysql_error()) {


   echo '<br /><br /><b>ERROR: MySQL said '.mysql_error().'</b>';


   die();


}


$sql = "SELECT sitename from ".$prefix."_config";


$result = $db->sql_query($sql);


echo '<br />$result = '.$result;


echo '<br />Number of rows retrieved = '.$db->sql_numrows($result);


$record = $db->sql_fetchrow($result);


$newSiteName = $record['sitename'];


echo '<br />Sitename after write attempt = '.$newSiteName;





// Attempt to reset sitename in nuke_config table to original value


echo "<br /><br /><b><u>Attempting to restore original value</u></b>";


$sql = "UPDATE ".$prefix."_config SET sitename = '$oldSiteName'";


$result = $db->sql_query($sql);


$sql = "SELECT sitename from ".$prefix."_config";


$result = $db->sql_query($sql);


echo '<br />$result = '.$result;


echo '<br />Number of rows retrieved = '.$db->sql_numrows($result);


$record = $db->sql_fetchrow($result);


echo '<br />Sitename after restoring attempt = '.$record['sitename'];


?>