Hi Own3mall so as starting point using your kfm can you change all the mysql access and fields to point to a central X-null database on AAAA as a test to see if you can use the existing data their - I can post all the fields and details..............
Also can anyone help with creating a new basic page to see if we can read the data off a shared X-null database on AAAA - I am wondering if we can just rip some of this -: which is a main record page for an entry on the database
Code:
<!-- TemplateBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- TemplateEndEditable -->
<style type="text/css">
<!--
.style2 {color: #FFFFFF}
.style3 {color: #FFBF55}
-->
</style>
<div class="field field-type-text field-field-mapname style2">
<table width="1091" border="1" cellpadding="3" cellspacing="3">
<tr>
<td width="272"><h3 class="field-label style3">Mod Name</h3>
<div class="field-items ">
<div class="field-item"><?php print $node->field_modname[0]['view'] ?>
</div>
</div></td>
<td width="284"><h3 class="field-label style3">Mod File (number of downloads)</h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modfile[0]['view'] ?><?php
$item = $node->field_modfile[0]; // change this to the correct field name
if($item['filesize'] < 1024) {
print ($item['filesize']);
print (" bytes");
}
elseif ($item['filesize'] < 1048576) {
$filesize = $item['filesize'];
$filesize = $filesize / 1024;
$filesize = round($filesize, 2);
print ($filesize);
print (" kB");
}
else {
$filesize = $item['filesize'];
$filesize = $filesize / 1048576;
$filesize = round($filesize, 2);
print ($filesize);
print (" MB");
}
?></div>
</div>
</td>
<td width="243" rowspan="2"><h3 class="field-label style3">Mod Screen shot</h3>
<div class="field-items">
<?php foreach ((array)$node->field_modscreen as $item) { ?>
<div class="field-item"><?php print $item['view'] ?></div>
<?php } ?>
</div></td>
<td width="243" rowspan="2"><h3 class="field-label style3">Total Views of this Mod </h3>
<div class="field-items ">
<div class="field-item"><?php print $node->links['statistics_counter']['title'] ?></div>
</div> </td>
</tr>
<tr>
<td><h3 class="field-label style3">Mod Version </h3>
<div class="field-items ">
<div class="field-item"><?php print $node->field_modversion[0]['view'] ?> </div>
</div></td>
<td width="284"><h3 class="field-label style3">Mod File Tested and Validated </h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modtested[0]['view'] ?> <span class="style3 field-label"><strong>By - <?php print $node->field_modtestedby[0]['view'] ?></strong></span></div>
</div></td>
</tr>
<tr>
<td rowspan="2"><h3 class="field-label style3"> Mod Type</h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_typeofmod[0]['view'] ?> </div>
</div> </td>
<td rowspan="2"><h3 class="field-label style3">Server or Client Mod </h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_serverclient[0]['view'] ?>
<?php
$item = $node->field_serverclient[0]; // change this to the correct field name
if($item['filesize'] < 1024) {
print ($item['filesize']);
print (" ");
}
elseif ($item['filesize'] < 1048576) {
$filesize = $item['filesize'];
$filesize = $filesize / 1024;
$filesize = round($filesize, 2);
print ($filesize);
print (" kB");
}
else {
$filesize = $item['filesize'];
$filesize = $filesize / 1048576;
$filesize = round($filesize, 2);
print ($filesize);
print (" MB");
}
?>
</div>
</div> </td>
<td rowspan="2"><h3 class="field-label style3"> </h3>
<h3 class="field-label style3">Mod Info External</h3> <div class="field-items">
<?php foreach ((array)$node->field_modextlinks as $item) { ?>
<div class="field-item"><?php print $item['view'] ?></div>
<?php } ?>
</div> </td>
<td><h3 class="field-label style3">Mod Status</h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modstatus[0]['view'] ?></div>
</div></td>
</tr>
<tr>
<td><h3 class="field-label style3">Mod compatable with Reborn </h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modreborncompat[0]['view'] ?></div>
</div></td>
</tr>
<tr>
<td colspan="4"><h3 class="field-label style3">Mod Short Description </h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_shortdescription[0]['view'] ?></div>
</div> </td>
</tr>
<tr>
<td colspan="4"><h3 class="field-label style3">Mod Description</h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_moddescription[0]['view'] ?></div>
</div> <div class="field-items"></div> <div class="field-items"></div> </td>
</tr>
<tr>
<td><div class="field field-type-text field-field-submitterrating">
<div class="field-items"></div>
</div>
<div class="field field-type-fivestar field-field-maprating">
<h3 class="field-label style3">Mod Rating </h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modrating[0]['view'] ?>
<p> </p>
</div>
</div>
</div></td>
<td><h3 class="field-label style3"> </h3>
<div class="field-items">
<h3 class="field-label style3">Mod videoDirect Link </h3>
<div class="field-items">
<?php foreach ((array)$node->field_modvideolink as $item) { ?>
<div class="field-item"><?php print $item['view'] ?></div>
<?php } ?>
</div>
</div></td>
<td colspan="2" rowspan="2"><h3 class="field-label style3">Mod Xfire / Youtube Video of Map </h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modvideoembed[0]['view'] ?></div>
</div> <div class="field-items"></div></td>
</tr>
<tr>
<td><h3 class="field-label style3">Submitter Initial Rating </h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modsubratiing[0]['view'] ?></div>
</div> </td>
<td><h3 class="field-label style3">Please Vote for This Mod</h3>
<div class="field-items">
<div class="field-item">
<?php
print fivestar_widget_form($node);
?>
</div>
</div></td>
</tr>
<tr>
<td><h3 class="field-label style3">Mod Percentage</h3>
<div class="field-items">
<div class="field-item">
<p><?php print $node->field_modrating[0]['rating'] ?></p>
</div>
</div></td>
<td><h3 class="field-label style3">Mod's File External Link </h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modfileext[0]['view'] ?> </div>
</div> <div class="field-items"></div></td>
<td><h3 class="field-label style3">Mod Creator</h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modcreator[0]['view'] ?></div>
</div></td>
<td><h3 class="field-label style3">Mod Support </h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modsupport[0]['view'] ?></div>
</div></td>
</tr>
<tr>
<td colspan="4"><h3 class="field-label style3">Mod Credits </h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modcredits[0]['view'] ?> </div>
</div> <div class="field-items"></div></td>
</tr>
<tr>
<td colspan="4"><h3 class="field-label style3">Mod Requirements </h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modrequires[0]['view'] ?></div>
</div></td>
</tr>
<tr>
<td colspan="4"><h3 class="field-label style3">Mod Install Info</h3>
<div class="field-items">
<div class="field-item"><?php print $node->field_modinstall[0]['view'] ?></div>
</div></td>
</tr>
<tr>
<td colspan="4"><h3 class="field-label style3">Mod Config / setup </h3>
<div class="field-items"><div class="field-item">
<div class="field-items">
<div class="field-item"><?php print $node->field_modconfigs[0]['view'] ?></div>
</div>
</div>
</div> <div class="field-items"></div> <div class="field-items"></div></td>
</tr>
</table>
<h3 class="field-label"> </h3>
</div>