<?
if (!$submit || !$title || !$url || !$description || !$email || !$userrecipURL)
{
?>
Your listing will appear in the following category:
<?
if (count ($arPath) > 0)
{
for ($i = 0; $i < count ($arPath); $i++)
{
array_push ($arSubPath, $arPath[$i]);
if ($i == 0)
{
$parent = 0;
}
else
{
$parent = $arIds[count ($arIds) - 1];
echo ' | ';
}
$thisCat = mysql_query ("SELECT id, name FROM link_cats WHERE name LIKE '$arPath[$i]' AND parent = $parent ");
if (mysql_num_rows ($thisCat) > 0)
{
$row = mysql_fetch_assoc ($thisCat);
array_push ($arIds, $row['id']);
$subPath = implode ('/', $arSubPath);
?>
<span class="book_tab_head2"><?php echo $row['name'] ?></span>
<?
}
}
echo "n";
}
?>
<?php
if ($listID)
{
?>
<?php
}
if ($row[‘id’])
{
?><?php
}
else
{
?><?php
}
?>
<?
if ($submit && !$fName)
{
?>
<tr><td valign="top" class="search_input_err">Please enter your Firstname:</td>
<td><input name="fName" type="text" id="sName" style="width: 400px;"/></td></tr>
<?
}
else
{
?>
<tr><td valign="top" class="lis_tab_cont">Firstname:</td>
<td><input name="fName" type="text" class="search_input" id="fName" style="width: 400px;" value="<? echo stripslashes ($fName); ?>" /></td></tr>
<?
}
?>
<?
if ($submit && !$title)
{
?>
<tr><td valign="top" class="search_input_err">Please enter your Surname:</td>
<td><input name="sName" type="text" id="sName" style="width: 400px;"/></td></tr>
<?
}
else
{
?>
<tr><td valign="top" class="lis_tab_cont">Surname:</td>
<td><input name="sName" type="text" class="search_input" id="sName" style="width: 400px;" value="<? echo stripslashes ($sName); ?>" /></td></tr>
<?
}
?>
<?
if ($submit && !$title)
{
?>
<tr><td valign="top" class="search_input_err">Please enter the website Title:</td>
<td><input type="text" name="title" id="title" value="" style="width: 400px;" /></td></tr>
<?
}
else
{
?>
<tr><td valign="top" class="lis_tab_cont">Title:</td>
<td><input name="title" type="text" class="search_input" id="title" style="width: 400px;" value="<? echo stripslashes ($title); ?>" /></td></tr>
<?
}
?>
<?
if ($submit && !$url)
{
?>
<tr><td valign="top" class="search_input_err">Please enter a URL:</td>
<td><input type="text" name="url" id="url" value="http://" style="width: 400px;"/></td></tr>
<?
}
else
{
if (!$url)
{
$url = 'http://';
}
?>
<tr><td valign="top" class="lis_tab_cont">URL:</td>
<td><input name="url" type="text" class="search_input" id="url" style="width: 400px;" value="<? echo stripslashes ($url); ?>" /></td></tr>
<?
}
?>
<?
if ($submit && !$description)
{
?>
<tr><td valign="top" class="search_input_err">Please enter a Description:</td>
<td><textarea name="description" id="description" style="width: 400px;"></textarea></td></tr>
<?
}
else
{
?>
<tr><td valign="top" class="lis_tab_cont">Description:</td>
<td><textarea name="description" class="search_input" id="description" style="width: 400px;"><? echo stripslashes ($description); ?></textarea></td></tr>
<?
}
?>
<?
if ($submit && !$email)
{
?>
<tr><td valign="top" class="search_input_err">Please enter your Email Address:</td>
<td><input type="text" name="email" id="email" value="" style="width: 400px" /></td></tr>
<?
}
else
{
?>
<tr><td valign="top" class="lis_tab_cont">Email Address:</td>
<td><input name="email" type="text" class="search_input" id="email" style="width: 400px;" value="<? echo stripslashes ($email); ?>" /></td></tr>
<?
}
?>
<?
if ($submit && !$userrecipURL)
{
?>
Please enter the Reciprocal Link Location: |
<td><input name="userrecipURL" type="text" class="search_input_err" id="userrecipURL" style="width: 400px;" value="" /></td></tr>
<?
}
else
{
?>
<tr><td valign="top" class="lis_tab_cont">Reciprocal Link Location:</td>
<td><input name="userrecipURL" type="text" class="search_input" id="userrecipURL" style="width: 400px;" value="<? echo stripslashes ($userrecipURL); ?>" /></td></tr>
<?
}
?>
<tr><td colspan="2" align="center"><p style="margin:20px"><input name="submit" type="submit" class="search_input" style="font-family: Trebuchet MS; font-size: 8pt" value="Save Listing" />
</p></td></tr>
<?
}
else if ($listID)
{
$listDate = date ("Y-m-d");
$queryStr = "UPDATE listings SET fName = '$fName', sName = '$sName', cat = '$catID', email = '$email', title = '$title', description = '$description', site = '$url', recip_url = '$userrecipURL)', added = '$listDate', `check` = '0' WHERE id = '$listID'";
if (mysql_query ($queryStr))
{
?>
<p><span class="lis_tab_head">Your have successfully edited this link.</span><br />
<br />
<a href="../links.php" class="countries"><span class="countries">Back</span></a></p>
<?
}
else
{
echo 'Error: ', mysql_errno (), ': ', mysql_error ();
}
}
else
{
$listDate = date ("Y-m-d");
$queryStr = "INSERT INTO links (fName, sName, cat, email, title, description, site, recip_url, added, `check`) VALUES
('$fName', '$sName', '$catID', '$email', '$title', '$description', '$url','$userrecipURL', '$listDate', '0')";
if (mysql_query ($queryStr))
{
$listID = mysql_insert_id ();
$parent = $catID;
while (isset ($parent))
{
mysql_query ("UPDATE link_cats SET children = children + 1 WHERE id = $parent ");
$parentExists = mysql_query ("SELECT parent FROM link_cats WHERE id = $parent ");
if (mysql_num_rows ($parentExists) > 0)
{
$parentID = mysql_fetch_assoc ($parentExists);
$parent = $parentID['parent'];
}
else
{
unset ($parent);
}
}
?>
<p class="lis_tab_head">Your listing has been saved successfully.<br />
<br />
<a href="../links.php" class="countries"><span class="countries">Back to Link Index</span></a></p>
<?
}
else
{
echo 'Error: ', mysql_errno (), ': ', mysql_error ();
}
}
mysql_close ($connection);
?>
[/php]