mysql script help and looking for an older file

You can run a mysql query to do that in myphpadmin

my php version is a little older than yours so this might not work:

update yourtableprefix_authorprefs set userskin =
replace(userskin,'oldskinname','newskinname');

Thanks jacci! I'm going to try this out now.

Good luck

and here is the  /blocks/info/info.php  file for a 3.1 install

i cant post attacment so here is the code

<?php
if(!defined("_CHARSET")) exit( );

if(file_exists(_BASEDIR."blocks/info/{$language}.php")) include_once(_BASEDIR."blocks/info/{$language}.php");
else include_once(_BASEDIR."blocks/info/en.php");
global $noskin, $tpl;
$storiesquery =dbquery("SELECT COUNT(sid) as totals, COUNT(DISTINCT uid) as totala, SUM(wordcount) as totalwords FROM ".$tableprefix."fanfiction_stories WHERE validated > 0");
$storyresult = dbassoc($storiesquery);

$chapterquery = dbquery("SELECT COUNT(chapid) as chapters FROM ".$tableprefix."fanfiction_chapters where validated > 0");
list($chaptercount) = dbrow($chapterquery);

$authorquery = mysql_query("SELECT COUNT("._UIDFIELD.") as totalm FROM "._AUTHORTABLE);
$authorresult = mysql_fetch_assoc($authorquery);

$newest = mysql_fetch_assoc(mysql_query("SELECT "._UIDFIELD." as uid, "._PENNAMEFIELD." as penname FROM "._AUTHORTABLE." ORDER BY "._UIDFIELD." DESC LIMIT 1"));
$reviewquery = mysql_query("SELECT COUNT(reviewid) as totalr FROM ".$tableprefix."fanfiction_reviews");
$reviewresult = mysql_fetch_assoc($reviewquery);
$submissions = "";
if($adminloggedin) {
if(file_exists(_BASEDIR."languages/".$language."_admin.php")) include_once(_BASEDIR."languages/".$language."_admin.php");
else include_once(_BASEDIR."languages/en_admin.php");
$countquery = dbquery("SELECT COUNT(DISTINCT chapid) FROM ".$tableprefix."fanfiction_chapters WHERE validated = '0'");
list($count) = dbrow($countquery);
if($count) $submissions = sprintf(_QUEUECOUNT, $count);
}
if(!empty($blocks['info']['style']) && $blocks['info']['style'] == 2) {
$tpl->assignGlobal("totalstories", $storyresult['totals']);
$tpl->assignGlobal("totalauthors", $storyresult['totala']);
$tpl->assignGlobal("totalmembers", $authorresult['totalm']);
$tpl->assignGlobal("totalreviews", $reviewresult['totalr']);
$tpl->assignGlobal("totalwords", !empty($storyresult['totalwords']) ? $storyresult['totalwords'] : "0");
$tpl->assignGlobal("totalchapters", $chaptercount);
$tpl->assignGlobal("newestmember", "<a href=""viewuser.php?uid=".$newest['uid'"]."">".$newest['penname']."</a>");
if($loggedin) $tpl->assignGlobal("loggedinas", _LOGGEDINAS." $userpenname. ".($noskin ? _NOSKIN : ""));
$tpl->assignGlobal("submissions", $submissions);
}
else {
if($loggedin) $loggedinas = _LOGGEDINAS." $userpenname. ".($noskin ? _NOSKIN : "");
else $loggedinas = "";
if(empty($blocks['info']['style'])) {
$content = "<div id="info_left" style="float: left; text-align: right;" class='label'>"._STORIES.": <br />"._CHAPTERS.": <br/>"._WORDCOUNT.": <br/>"._AUTHORS.": <br />"._MEMBERS.": <br />"._REVIEWS.": <br/></div><div id="info_right" style="text-align: left;">".$storyresult['totals']."<br />".$chaptercount."<br />".(!empty($storyresult['totalwords']) ? $storyresult['totalwords'] : "0")."<br />".$storyresult['totala']."<br />".$authorresult['totalm']."<br />".$reviewresult['totalr']."<br /></div><div id="newestmember"><span class='label'>"._NEWESTMEMBER.":</span> <br /><a href=""viewuser.php?uid=".$newest['uid'"]."">".$newest['penname']."</a><br /></div><div id="loggedinas">$loggedinas</div>";
}
else if($blocks["info"]["style"] == 1) {
$replace = array($storyresult['totala'], $authorresult['totalm'], $reviewresult['totalr'], $storyresult['totalwords'], $chaptercount, $storyresult['totals'], "<a href=""viewuser.php?uid=".$newest['uid'"]."">".$newest['penname']."</a>", $loggedinas, $submissions);
$search = array("@{authors}@", "@{members}@", "@{reviews}@", "@{totalwords}@","@{chapters}@", "@{stories}@", "@{newest}@", "@{loggedinas}@", "@{submissions}@");
$content = preg_replace($search, $replace, (!empty($blocks['info']['template']) ? stripslashes($blocks['info']['template']) : _NARTEXT));
}
}
?>

The mysql script works perfectly! Thank you 😀