Weapon-X Posted November 25, 2009 Posted November 25, 2009 First off, I'm in no way skilled at site administration, although I can quickly pick up things with code if I have an initial guide/help source. That said, here's my issue. I have spent this last week updating info, mainly product, for the company owner's website, which is for a local computer store. What I am trying to accomplish currently is updating old links with accompanying banners on the Links page (links.php). The problem I'm running into here is, I cannot find where the references to this page and the files are. When I view the page source, I can see the information I'm looking for, but when I go in to view the actual files, I can find the folder where the images for those links are, but cannot find any reference to these links themselves when looking at the actual PHP files. I've probably downloaded about 20 different .php files to my local PC and viewed them with Notepad++, but have come up with a complete blank, and I have yet to, in a day and a half of web searches, come up with even a reasonable reference that talks about the links page, much less how to manage it. I should specify that I'm not talking about the Banner Manager, in case this might confuse anyone. Again, I'm a n00b with all this, and I don't have full physical server access at this time, only admin panel and FTP. There's bound to be a simple solution, assuming the person who originally setup and maintained the site and is long gone didn't do something squirrely in the way the links page is setup. Any help would be very much appreciated, thanks in advance!
germ Posted November 25, 2009 Posted November 25, 2009 First off, I'm in no way skilled at site administration, although I can quickly pick up things with code if I have an initial guide/help source. That said, here's my issue. I have spent this last week updating info, mainly product, for the company owner's website, which is for a local computer store. What I am trying to accomplish currently is updating old links with accompanying banners on the Links page (links.php). The problem I'm running into here is, I cannot find where the references to this page and the files are. When I view the page source, I can see the information I'm looking for, but when I go in to view the actual files, I can find the folder where the images for those links are, but cannot find any reference to these links themselves when looking at the actual PHP files. I've probably downloaded about 20 different .php files to my local PC and viewed them with Notepad++, but have come up with a complete blank, and I have yet to, in a day and a half of web searches, come up with even a reasonable reference that talks about the links page, much less how to manage it. I should specify that I'm not talking about the Banner Manager, in case this might confuse anyone. Again, I'm a n00b with all this, and I don't have full physical server access at this time, only admin panel and FTP. There's bound to be a simple solution, assuming the person who originally setup and maintained the site and is long gone didn't do something squirrely in the way the links page is setup. Any help would be very much appreciated, thanks in advance! They might have installed a contribution where the page content is managed in the admin somewhere. If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Ben Nevis Posted November 25, 2009 Posted November 25, 2009 There are a large number of files in osc, but 'links.php' is not one of them. So if you have such a file it sounds like it's something someone has bolted on and you will most likely not find it referenced in the osc files, and it will be difficult for anyone here to guide you about it without knowing more. If you're sure the links page is what's managing your connection to the store then if you post the code to it here and an explanation of what you are trying to do exactly someone might be able to point you in the right direction. Giving the store url might help too. www.jyoshna.com. Currently using OsC with STS, Super Download Store, Categories Descriptons, Manufacturers Description, Individual Item Status, Infopages unlimited, Product Sort, Osplayer with flashmp3player, Product Tabs 2.1 with WebFx Tabpane and other bits and pieces including some I made myself. Many thanks to all whose contributions I have used!
Weapon-X Posted November 27, 2009 Author Posted November 27, 2009 Main web URL: http://www.onlinecomputercorner.com/ Links page: http://www.onlinecomputercorner.com/links.php Here's the View Page Source info: <html> <head> <script language="JavaScript"> function goBack() { history.back(); } function adjustPrice(form) { var price1 = form.elements["pricePaid"].value*1; // pricePaid var price2 = form.elements["newPrice"].value*1; // priceNew var markupPrice = 0; if(price1 && price2) { markupPrice = Math.round((price2 - price1)/price2 * 100); form.elements["markup"].value = markupPrice + "%"; } } /* function adjustPrice2(form) { var price = form.elements["pricePaid"].value*1; // pricePaid var percent = form.elements["percent"].value*1; // percentage var updatePrice = 0; // what's the mark up? if(price && percent) { updatePrice = (percent / 100 * price) + price; form.elements["newPrice"].value = updatePrice; // $markup = round(($newPrice-$pricePaid)/$newPrice * 100); } } */ </script> <title>Computer Corner</title> <META HTTP-EQUIV="Content-Type" CONTENT="text/html;"> <meta name="description" content="Computer Corner Dallas, specializing in PC Repair and Computer resale. We offer cheap affordable computers, desktops and laptops in our friendly store !"> <meta name="keywords" content="Dallas cheap computers, Dallas cheap pc, Carrollton computers, Carrollton cheap Computer"> <meta name="robots" content="index,follow"> <META name="Author" content="online computer corner"> <style> input { border-top-width: 1px; border-left-width: 1px; font-size: 9pt; border-left-color: #000000; border-bottom-width: 1px; border-bottom-color: #000000; border-top-color: #000000; font-style: normal; font-family: arial; height: 20px; background-color: #f3f3f3; border-right-width: 1px; border-right-color: #000000 } select { border-top-width: 0px; border-left-width: 0px; font-size: 9pt; border-left-color: #000000; border-bottom-width: 0px; border-bottom-color: #000000; border-top-color: #000000; font-style: normal; font-family: arial; height: 20px; background-color: #f3f3f3; border-right-width: 0px; border-right-color: #000000 } textarea { border-top-width: 1px; border-left-width: 1px; font-size: 9pt; border-left-color: #000000; border-bottom-width: 1px; border-bottom-color: #000000; border-top-color: #000000; font-style: normal; font-family: arial; background-color: #f3f3f3; border-right-width: 1px; border-right-color: #000000 } .btn { border-top-width: 1px; font-weight: bold; border-left-width: 1px; font-size: 9pt; border-left-color: #000000; border-bottom-width: 1px; border-bottom-color: #000000; border-top-color: #000000; font-style: normal; font-family: arial; background-color: #c3c3c3; border-right-width: 1px; border-right-color: #000000 } body { margin-left: 0em; margin-right: 0em; margin-top: 0em; margin-bottom: 0em; font-style: normal; font-family: arial; font-size: 8pt; } .small { font-style: normal; font-family: arial; font-size: 8pt; text-indent: 0; } td { font-style: normal; font-family: arial; font-size: 9pt; color: gray; } .text { font-style: normal; font-family: arial; font-size: 9pt; color: gray; } .big { font-style: normal; font-family: arial; font-weight: bold; font-size: 11pt; text-indent: 0; color: #000000; } .white { color: #FFFFFF; } </style> </HEAD> <BODY BGCOLOR=#ffffff alink="#000000" link="#000000" vlink="#000000" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH="0" MARGINHEIGHT="0" background="images/background.gif"> <div align="center"> <table width="760" border="0" cellspacing="0" cellpadding="0"> <tr> <TD WIDTH=760 HEIGHT=134 COLSPAN=3><a href="/index.php"><img src="/images/header.jpg" width="760" height="134" border="0"></a></TD> </tr> </table> <table width="760" border="0" cellspacing="0" cellpadding="0" height="800" bgcolor=#ffffff> <tr> <td valign=top width="760" style="border-right: 1px solid #c3c3c3; border-left: 1px solid #c3c3c3;"> <table width="760" cellspacing="0" cellpadding="0" border="0"> <tr> <td> <map name="header"> <area shape="rect" alt="Contact Computer Corner" href="/contact.php" title="Contact Computer Corner" coords="668,2,753,24" /> <area shape="rect" alt="About Computer Corner" href="/about.php" title="About Computer Corner" coords="576,3,650,26" /> <area shape="rect" alt="Links" href="/links.php" title="Links" coords="464,2,556,24" /> <area shape="rect" alt="Our Location" href="/location.php" title="Our Carrollton Computer Corner Location" coords="349,4,447,22" /> <area shape="rect" alt="Support" href="/support.php" title="Technical Support" coords="240,4,339,22" /> <area shape="rect" alt="Shop Online" href="/catalog/" title="Buy Computers & Equipments online" coords="114,3,226,24" /> <area shape="rect" alt="Home" href="/" title="Home" coords="15,4,95,23" /> </map> <img border="0" src="/images/navigate.gif" usemap="#header" width="760" height="29"></td> </tr> </table> <table width="760" cellspacing="0" cellpadding="0" border="0"> <tr> <td style="padding-left: 10px; padding-top: 20px; padding-right: 10px;"> <b>Links</b><br><br><center><b></b><br><a href="http://www.mikeshobbyshop.com" target="_blank"><img src="/links/5354c24cff6aee67b3ac8104729d5ecb.gif" border="0"></a><b></b><br><a href="http://housecall.trendmicro.com/" target="_blank"><img src="/links/e00ce8475d6cb28bc7fcc18c81bedcb6.gif" border="0"></a><b></b><br><a href="http://stores.ebay.com/onlinecomputercorner_W0QQstorecachemissZonlinecomputercornerQQtZkm" target="_blank"><img src="/links/6a0d4b071bb47d68cb74cf7ff7ff8a58.jpg" border="0"></a><b></b><br><a href="http://download.com/3000-2144-10045910.html?part=69274&subj=dlpage&tag=button" target="_blank"><img src="/links/89c1ced9c248ad63bc013bbfce5c82f6.jpg" border="0"></a></center> <span> </td> </tr> <tr> <td align=center> <br> <img src="images/spacer_blue.gif" width="75%" height="1"> </td> </tr> <tr> <td valign="middle" align="center"><br> <a href="/quote.php"><font color="#FFFFFF">Get a Quote!</font></a> <br> <a href="/about.php">About Us</a> | <a href="/catalog/">Shop Online </a> | <a href="/location.php">Location </a>| <a href="/support.php">Support</a> | <a href="/links.php">Links</a><br><br><a href="/warranty.php">Warranty Information</a><br><br> <a href="/recycle.php"><img src="/images/recycle.jpg" border="0" height="40" width="40"><br>Please click for more information</a> <br><br><script language="Javascript" src="https://seal.godaddy.com/getSeal?sealID=2064326581013f5ee68127109703e719617eec040984471271731631"></script><br> <a href="/admin.php"><font color="#FFFFFF">Administration</font></a> <br> <!-- PayPal Logo --><table border="0" cellpadding="10" cellspacing="0" align="center"><tr><td align="center"></td></tr> <tr><td align="center"><a href="#" onclick="javascript:window.open('https://www.paypal.com/us/cgi-bin/webscr?cmd=xpt/popup/OLCWhatIsPayPal-outside','olcwhatispaypal','toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no', width='400', height='350');"><img src="https://www.paypal.com/en_US/i/bnr/horizontal_solution_PPeCheck.gif" border="0" alt="Solution Graphics"></a></td></tr></table> <!-- PayPal Logo --> Copyright 2009, © Computer Corner Inc. </span> </td> </tr> </table> </td> </tr> </table> </div> </body> </html> When I look here, Line 137 shows the links on the page, and the associated images. However, not a single instance of "links.php" in the database has this, or even half the amount of code as the info listed above. I have a "Links" folder (inside this site's main folder, as there is more than one site run off this server, each in their own separate folders) that holds the images referenced in the code above, but the links.php file which is also in the main folder doesn't have this information, and in fact actually looks like a blank template, with no info added to it for links to be called. I can't find another instance of "links.php" anywhere, now that I've had another look. Unfortunately, this doesn't give me much hope, especially if this was an add-on, which both of you have mentioned as a distinct possibility. I could rename the new images I want to use for links to match the old ones, but that sadly would not help me get rid of links I no longer want, to be replaced with different ones. If there's anything else I can provide that might help further, please let me know. Otherwise, I'll probably end up letting the boss man know that he's going to need to pay someone to solve this mystery. your replies thus far are greatly appreciated.
germ Posted November 27, 2009 Posted November 27, 2009 So what code does the links.php in the site's root folder have? :unsure: If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Weapon-X Posted November 27, 2009 Author Posted November 27, 2009 Sorry about that, I meant to include it and forgot. <? include("header.php"); ?> <? echo "<b>Links</b><br><br><center>"; $sql = mysql_query("SELECT id, linkURL, linkPicture FROM links WHERE status='1'"); if (mysql_num_rows($sql)>0) { $num = 1; while(list($id, $linkURL, $linkPicture) = mysql_fetch_row($sql)) { if ($linkPicture!='') { echo "<b></b><br><a href=\"$linkURL\" target=\"_blank\"><img src=\"/links/$linkPicture\" border=\"0\"></a>"; } else { echo "<b></b><br><a href=\"$linkURL\" target=\"_blank\">$linkURL</a><br><br>"; } $num++; } } else { echo "There aren't any links available at the moment. Please check back soon."; } echo "</center>"; ?> <? include("footer.php"); ?>
germ Posted November 27, 2009 Posted November 27, 2009 Sorry about that, I meant to include it and forgot. <? include("header.php"); ?> <? echo "<b>Links</b><br><br><center>"; $sql = mysql_query("SELECT id, linkURL, linkPicture FROM links WHERE status='1'"); if (mysql_num_rows($sql)>0) { $num = 1; while(list($id, $linkURL, $linkPicture) = mysql_fetch_row($sql)) { if ($linkPicture!='') { echo "<b></b><br><a href=\"$linkURL\" target=\"_blank\"><img src=\"/links/$linkPicture\" border=\"0\"></a>"; } else { echo "<b></b><br><a href=\"$linkURL\" target=\"_blank\">$linkURL</a><br><br>"; } $num++; } } else { echo "There aren't any links available at the moment. Please check back soon."; } echo "</center>"; ?> <? include("footer.php"); ?> Look at the code closely. It has mysql statements in it that retrieve the info from the DB. :thumbsup: If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Weapon-X Posted November 27, 2009 Author Posted November 27, 2009 I guess that's my dilemma then, in that I don't know what it's looking at, or where, in order to be able to change things. As I said, I'm pretty much jumping into the deep end here, and I don't know exactly what I'm looking at, or for, here. I don't know if it's looking to another specific PHP module for this data, or another file type, since I don't have any experience with PHP/SQL before jumping in this last week. I am smart enough not to change anything without a backup, and smart enough not to touch something if I'm not sure of what it does. I'm just at a bit of a loss, because I can't make the connection between the function call and where it's calling to/from to get that information. If this is falling into the realm of needing professional help, due to it being an involved issue, please let me know and I'll take the appropriate measures, so as not to tie up things here and keep others from getting help a little faster.
germ Posted November 27, 2009 Posted November 27, 2009 I guess that's my dilemma then, in that I don't know what it's looking at, or where, in order to be able to change things. As I said, I'm pretty much jumping into the deep end here, and I don't know exactly what I'm looking at, or for, here. I don't know if it's looking to another specific PHP module for this data, or another file type, since I don't have any experience with PHP/SQL before jumping in this last week. I am smart enough not to change anything without a backup, and smart enough not to touch something if I'm not sure of what it does. I'm just at a bit of a loss, because I can't make the connection between the function call and where it's calling to/from to get that information. If this is falling into the realm of needing professional help, due to it being an involved issue, please let me know and I'll take the appropriate measures, so as not to tie up things here and keep others from getting help a little faster. If the previous person didn't leave an obvious program capable of editing these via a web interface he probably used PHPMYADMIN to do it. If you are any good with that, it would be one course of action. If you are any good with HTML you can take the existing code, and do this: <? include("header.php"); ?> ******** DELETE THIS LINE AND PUT YOUR HTML FOR THE LINKS HERE ******** <? include("footer.php"); ?> If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Ben Nevis Posted November 27, 2009 Posted November 27, 2009 I guess that's my dilemma then, in that I don't know what it's looking at, or where, in order to be able to change things. As I said, I'm pretty much jumping into the deep end here, and I don't know exactly what I'm looking at, or for, here. I don't know if it's looking to another specific PHP module for this data, or another file type, since I don't have any experience with PHP/SQL before jumping in this last week. I am smart enough not to change anything without a backup, and smart enough not to touch something if I'm not sure of what it does. I'm just at a bit of a loss, because I can't make the connection between the function call and where it's calling to/from to get that information. If this is falling into the realm of needing professional help, due to it being an involved issue, please let me know and I'll take the appropriate measures, so as not to tie up things here and keep others from getting help a little faster. Well, behind your links page is a pretty standard looking osc store. links.php just displays a few products that some has decided to put in the links table. There may or may not be any admin screen behind it, as Germ said it could be done just using phpadmin to make manual entries directly in the database. The sql statement just says get all the link urls and link pictures from the links table that have a status set to 1 - presumably means they are active. The link url is just a path to the product_info page using the product_id. As Germ said the same thing could be done just using standard html, the call to the links table doesn't really do much. www.jyoshna.com. Currently using OsC with STS, Super Download Store, Categories Descriptons, Manufacturers Description, Individual Item Status, Infopages unlimited, Product Sort, Osplayer with flashmp3player, Product Tabs 2.1 with WebFx Tabpane and other bits and pieces including some I made myself. Many thanks to all whose contributions I have used!
Weapon-X Posted November 28, 2009 Author Posted November 28, 2009 When we're talking about phpmyadmin, I'm going to assume we're talking about the admin panel that I log into when I want to edit the store's items, etc. As far as that, the Banner Manager has already been ruled out, and in File Manager, I find the previously mentioned Links folder. That shows the current links images, 4 active, 1 inactive, as it's not showing up on the site. I can upload new images into this folder via admin panel or FTP, but clicking Edit on any of these simply yields an edit box full of ascii, which I assume is data from the images themselves, which obviously does me no good. There is nothing else in admin panel pertaining to links/images that would be relevant, and believe me, I've been over every category. So, in following your lines of thinking, there is likely a manual addition somewhere. This is where I'm still getting stuck: Any idea if I'm looking for a .php file that would have the link references, or a .sql file, or what? I feel like a dummy asking this, and I'm thinking this is going to end up as an exercise in frustration, but if you never ask, you never get help, so I ask anyway. I figure there has to be a source file where it determines what images to use, and where the links for those images are stored, since there is no info in the admin panel to do so, and if I add new images, they don't get used. I just don't know what I'm looking for. As germ suggested, I could edit the links.php file in the root folder, but then I'm assuming I would either get duplicate links, or have some possible failure where I either fubar the page, or the site, which I really would like to avoid, LOL. Adding the link references from the View Source info on the Links page itself wouldn't be an issue, but I would really rather be able to find where links.php is finding the info to display, so I can either edit it, or remove it if I choose to add the HTML info to links.php myself, and this is why I keep hammering the same point. I realize you two are doing what you can to help, and I want to say I really appreciate the help thus far.
germ Posted November 28, 2009 Posted November 28, 2009 When we're talking about phpmyadmin, I'm going to assume we're talking about the admin panel that I log into when I want to edit the store's items, etc. As far as that, the Banner Manager has already been ruled out, and in File Manager, I find the previously mentioned Links folder. That shows the current links images, 4 active, 1 inactive, as it's not showing up on the site. I can upload new images into this folder via admin panel or FTP, but clicking Edit on any of these simply yields an edit box full of ascii, which I assume is data from the images themselves, which obviously does me no good. There is nothing else in admin panel pertaining to links/images that would be relevant, and believe me, I've been over every category. So, in following your lines of thinking, there is likely a manual addition somewhere. This is where I'm still getting stuck: Any idea if I'm looking for a .php file that would have the link references, or a .sql file, or what? I feel like a dummy asking this, and I'm thinking this is going to end up as an exercise in frustration, but if you never ask, you never get help, so I ask anyway. I figure there has to be a source file where it determines what images to use, and where the links for those images are stored, since there is no info in the admin panel to do so, and if I add new images, they don't get used. I just don't know what I'm looking for. As germ suggested, I could edit the links.php file in the root folder, but then I'm assuming I would either get duplicate links, or have some possible failure where I either fubar the page, or the site, which I really would like to avoid, LOL. Adding the link references from the View Source info on the Links page itself wouldn't be an issue, but I would really rather be able to find where links.php is finding the info to display, so I can either edit it, or remove it if I choose to add the HTML info to links.php myself, and this is why I keep hammering the same point. I realize you two are doing what you can to help, and I want to say I really appreciate the help thus far. phpmyadmin is (or should be) located in the cPanel control for the site, totally separate from the osC admin. If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Weapon-X Posted November 28, 2009 Author Posted November 28, 2009 Ah, I see. Well, that's something I don't have access to at present, will have to find out from the owner the info I need to access that.
Weapon-X Posted January 2, 2010 Author Posted January 2, 2010 Resolution: I ended up doing as germ suggested, deleting all the SQL references from the links.php file, and just adding the HTML into it, worked like a charm. All your help was much appreciated, both of you.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.