 | nightrider... quick incase the archive dissappears lol |  |
Posted: 08/19/2007 3:47 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 5:44 AM
Location: Birmingham, UK.
|

|
|
|
|
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: nightrider... quick incase the archive dissappears lol |  |
Posted: 08/19/2007 4:24 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 5:44 AM
Location: Birmingham, UK.
|

|
|
|
|
 |
Haha it worked as well
[url=]http://www.christopher-powell.co.uk/links.php[/url]
obviously when adding/editing/removing links from the admin panel won't affect the links page itself because a lot of php code is missing from the links page that the archive doesn't store but at least I’ve got the look back  |
|
|
 |
 |
| Back to Top |
|
|
 | Re: nightrider... quick incase the archive dissappears lol |  |
Posted: 08/19/2007 5:58 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 12:44 AM
Location: St Pete, FL
|

|
|
|
|
 |
That's kind of neat how the text fades in when you click on a Category link. I don't think I've ever seen a page work like that...
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: nightrider... quick incase the archive dissappears lol |  |
Posted: 08/20/2007 4:08 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 5:44 AM
Location: Birmingham, UK.
|

|
|
|
|
 |
Very neat imo. I dont think ive seen it used anywhere else
Do you think it would be possible to use the old code from the links page that is in the old_website rar folder on the server? No doubt the code will be very similar, just a matter of changing the a few codes like the connections code eg database code  |
|
|
 |
 |
| Back to Top |
|
|
 | Re: nightrider... quick incase the archive dissappears lol |  |
Posted: 08/20/2007 10:01 AM |
|
|
|
|
|
| Citation |
| Posts |
826 |
| Word Cnt. |
37,329 |
| BDay |
Oct 2 |
| Sign |
Libra |
| Sex |
 |
|
|
|
Joined: Apr 03, 2007
Local time: 11:44 PM
Location: Somewhere in Maryland
|

|
|
|
|
 |
| Nightrider wrote:
|
That's kind of neat how the text fades in when you click on a Category link. I don't think I've ever seen a page work like that...
|
On both accounts, I agree.  |
|
|
 |
 |
| Back to Top |
|
|
 | Re: nightrider... quick incase the archive dissappears lol |  |
Posted: 08/21/2007 1:27 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 12:44 AM
Location: St Pete, FL
|

|
|
|
|
 |
| Chris Powell wrote:
|
|
Do you think it would be possible to use the old code from the links page that is in the old_website rar folder on the server?
|
I don't have a clue what's in it, so I really don't know. I have a copy of a links.php file stored in a subfolder named cp_old in a christopher-powell.co.uk directory on my PC. I imagine that would be the same as what you have though...
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: nightrider... quick incase the archive dissappears lol |  |
Posted: 08/21/2007 3:01 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 5:44 AM
Location: Birmingham, UK.
|

|
|
|
|
 |
I mean the like try and use the code from the old links page from my old christopher-powell.co.uk website and some how try rebuild the code for the new links.php page that's on the server now. I'm not sure if it's possible. That's why I'm asking you Blake. You will have a better idea whether it can be done or not
| Code:
|
<?php require_once('Connections/cpsite.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_cpsite, $cpsite);
$query_cpLinks1 = "SELECT * FROM links WHERE links.links_cat = 'Dance Music Related Websites' AND links.links_isactive = 1 ORDER BY links.links_sitename ASC";
$cpLinks1 = mysql_query($query_cpLinks1, $cpsite) or die(mysql_error());
$row_cpLinks1 = mysql_fetch_assoc($cpLinks1);
$totalRows_cpLinks1 = mysql_num_rows($cpLinks1);
mysql_select_db($database_cpsite, $cpsite);
$query_cpLinksFriends = "SELECT * FROM links WHERE links.links_cat = 'Friends Sites' AND links.links_isactive = 1 ORDER BY links.links_sitename ASC";
$cpLinksFriends = mysql_query($query_cpLinksFriends, $cpsite) or die(mysql_error());
$row_cpLinksFriends = mysql_fetch_assoc($cpLinksFriends);
$totalRows_cpLinksFriends = mysql_num_rows($cpLinksFriends);
mysql_select_db($database_cpsite, $cpsite);
$query_cpLinksProfile = "SELECT * FROM links WHERE links.links_cat = 'Profile page sites' AND links.links_isactive = 1 ORDER BY links.links_sitename ASC";
$cpLinksProfile = mysql_query($query_cpLinksProfile, $cpsite) or die(mysql_error());
$row_cpLinksProfile = mysql_fetch_assoc($cpLinksProfile);
$totalRows_cpLinksProfile = mysql_num_rows($cpLinksProfile);
$thisPage="Links"; ?>
<?php require_once("header.php");?>
<h3>Links</h3>
<h4>Music Related</h4>
<?php do { ?>
<p><a href="<?php echo $row_cpLinks1['links_url']; ?>" target="_blank"><?php echo $row_cpLinks1['links_sitename']; ?></a> - <?php echo $row_cpLinks1['links_description']; ?></p>
<?php } while ($row_cpLinks1 = mysql_fetch_assoc($cpLinks1)); ?>
<h4>DJs / Producers</h4>
<?php do { ?>
<p><a href="<?php echo $row_cpLinksFriends['links_url']; ?>" target="_blank"><?php echo $row_cpLinksFriends['links_sitename']; ?></a> - <?php echo $row_cpLinksFriends['links_description']; ?></p>
<?php } while ($row_cpLinksFriends = mysql_fetch_assoc($cpLinksFriends)); ?>
<h4>Profile page sites</h4>
<?php do { ?>
<p><a href="<?php echo $row_cpLinksProfile['links_url']; ?>" target="_blank"><?php echo $row_cpLinksProfile['links_sitename']; ?></a> - <?php echo $row_cpLinksProfile['links_description']; ?></p>
<?php } while ($row_cpLinksProfile = mysql_fetch_assoc($cpLinksProfile)); ?>
</div>
<div style="clear:both"></div>
<?php require_once('footer.php');?>
</div><!-- End Container -->
</body>
</html>
<?php
mysql_free_result($cpLinks1);
mysql_free_result($cpLinksFriends);
mysql_free_result($cpLinksProfile);
?>
|
If Karlos used the same coding it may be possible to rebuild the code for the new links.php page. By doing this I can add/remove/edit links from the admin panel then. If you want login details for the admin section so you can see how it works i can pm you them Blake  |
|
|
 |
 |
| Back to Top |
|
|
 | Re: nightrider... quick incase the archive dissappears lol |  |
Posted: 08/22/2007 11:23 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 12:44 AM
Location: St Pete, FL
|

|
|
|
|
 |
Is the code above from a View Source or did you copy and paste it from a file? Typically the code from a View Source is pretty useless since it contains parsed code that you would never see in the original code. For instance. If you do a View Source on our Index page, it would include all the Categories and Forums even though that code is stored in the Database rather than the source code. What you see in a View Source is the combined source code and data...
If you have a file that sort of has the code for this, we might be able to engineer it to display like the page you found from the Google search in your first post. It really depends on how much of a difference there is whether it can be made to work like the file that you lost. If I have to recreate any triggers, that is probably going to be a show-stopper...
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: nightrider... quick incase the archive dissappears lol |  |
Posted: 08/23/2007 2:44 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 5:44 AM
Location: Birmingham, UK.
|

|
|
|
|
 |
Ok. I copied and pasted it from a file. the rar folder is in the /root of the server named cp-old-website.rar !
....  |
|
|
 |
 |
| Back to Top |
|
|
 | Re: nightrider... quick incase the archive dissappears lol |  |
Posted: 08/24/2007 12:24 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 12:44 AM
Location: St Pete, FL
|

|
|
|
|
 |
I had already downloaded this a while back. I'm really not sure what to do next. Do you have all of the links from the original page entered in your Admin section right now???
 |
|
|
 |
 |
| Back to Top |
|
|
 | Information |  |
|