Jump to content

Need help with database(??) tags or code called from html


springer-

Recommended Posts

Here's the background.  A company developed a site and hosted it.  They disappeared from the face of the earth.  The site is currently hosted on their server.  There is no support, no one answers the lone phone number that rings and the rest of the numbers are disconnected.  No one answers emails and they stopped sending out invoices about 6 months ago.

 

Since figuring this out, I am trying to move the site to another hosting service.  The site is pretty basic but I am not a programmer.  I have resolved many of the issues but I am left with one that I can not figure out and don't know where to start.

 

Basically it is a "news" posting page.  It uses only html files.  There are no database type config files for mysql or php or anything else that I can find.  For the most part I can follow the logic behind a script and I feel I basically understand the script but I do not know enough of the specifics to know how it works.

 

Here is the html from two of the key pages that contain all of the hints to solving this.

 

The first one is the page that adds new "posts" to the news page.  Here is the code that handles that function.

<!-- start new stuff -->
<b><font face="verdana" size="4" color="#003366">Add NEWS Content</font></b><br>
<form action="lbnews.html" method="post">
<input type="hidden" name="addeddel_action" value="1">
<input type="hidden" name="addeddel_db" value="news">
<input type="hidden" name="addeddel_table" value="news">
<input type="hidden" name="addeddel_add" value="1">
<input type="hidden" name="field_1_date" value="[time format="%m-%d-%Y"][/time]">
<table border="0" cellpadding="1" cellspacing="1" width="">
<tr>
<td><font face="verdana" size="2">Link:</font></td>
<td><input type="text" size="50" name="field_1_link"></td>
</tr>
<tr>
<td><font face="verdana" size="2">Title:</font></td>
<td><input type="text" size="50" name="field_1_title"></td>
</tr>
<tr>
<td valign="top"><font face="verdana" size="2">Body:</font></td><td><textarea name="field_1_body" rows="40" cols="50"></textarea></td>
</tr>
<td colspan="2" align="center"><input type="submit" value="Submit"></td>
</tr>
</table>
</form>

 

The next page is the "news" page and displays posts on the site.  Here is the code from that page.

<!-- start new stuff -->
<a name="top">
<font face="verdana">
<b><font face="verdana" size="4" color="#003366">Late Breaking News</font></b><br>
[auth user="admin"]<font size="2">&#91;</font><font size="1"><a href="add0.html">ADD NEW CONTENT</a></font><font size="2">&#93;</font><br>[/auth]<br>
[search table="news" order="news.id desc" "where_news.archive"="no"]
[row]
<font size="2"><a href="lbnews.html#[field name='id'/]">[field name="link"/]</a>
<font size="1">(posted on [field name="date"/])<br>
[/row]
[/search]
<br>
<hr>
[search table="news" order="news.id desc" "where_news.archive"="no"]
[row]
<a name="[field name='id'/]">
<font size="4" color="#800040"><b>[upper][field name="title"/][/upper]</b></font><br>
[auth user="admin"]                                                                                                                       <font size="2">&#91;</font><font size="1"><a href="edit.html?item_id=[field name='id'/]">Edit</a> | <a href="delete.html?item_id=[field name='id'/]">Delete</a> | <a href="lbnews.html?addeddel_action=1&addeddel_db=news&addeddel_table=news&addeddel_ed=1&addeddel_original_id=[field name='id'/]&field_1_archive=yes">Archive</a></font><font size="2">&#93;</font>
[/auth]<br>
<font size="2" color="#000000">[field name="body"/]<br></font>
<br>
<p align="center">
<a href="lbnews.html#top">Go To Top</a> <a href="lbnews.html#top"><img align="absmiddle" src="../images/top.gif" border="0"></a><br>
</p>
<hr>
[/row]
[/search]

 

There are additional pages to edit and delete posts.  One of the functions in the edit page is the ability to archive it.

 

I only posted the code that pertains to the issue, the rest of the code in the html pages is the fluff that styles the page to fit the site look.

 

Additionally here is the code from the head of the html pages.

<META HTTP-EQUIV= "pragma" CONTENT="no-cache">
<META NAME="description" CONTENT="Adobe ImageReady(tm) HTML Output">
<META NAME="author" CONTENT="Adobe ImageReady(tm)">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

 

The server it is hosted on seems to be running debain linux.  I have managed to gain access to most of the server files through my ftp account but do not know what I am looking for.

 

I can send all the html files from the site in zip format and link the active funtioning website if it will help solve the issue.

 

Thanks for any input and help.

Link to comment
Share on other sites

Well, you haven't shown us the processing script. It should be in a file called lbnews.html (probably at the top).

 

Also, there has to be some database somewhere, or else the news posts wouldn't be saved. The trick is to find out where the database processing is happening.

Link to comment
Share on other sites

Well, you haven't shown us the processing script. It should be in a file called lbnews.html (probably at the top).

 

Also, there has to be some database somewhere, or else the news posts wouldn't be saved. The trick is to find out where the database processing is happening.

 

The second script posted above is all the script from the lbnews.html file.  But here is the entire html.

<HTML>
<HEAD>
<TITLE>The xxxxx xxxxxxxxxx Association - Late Breaking News</TITLE>
<META HTTP-EQUIV= "pragma" CONTENT="no-cache">
<META NAME="description" CONTENT="Adobe ImageReady(tm) HTML Output">
<META NAME="author" CONTENT="Adobe ImageReady(tm)">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!-- <LINK rel="stylesheet" href="/css/xxx.css"> -->
</HEAD>

<BODY leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" bgcolor="#FFFFFF" link="#003366" alink="#CC9900" vlink="#CC9900">
<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=760>
  <TR>
    <TD width="193" align="left" valign="top"><IMG SRC="images/layout-01-01.gif" WIDTH="193" HEIGHT="46" BORDER="0"></TD>
    <TD width="567" align="left" valign="top"><IMG SRC="images/layout-01-02.gif" WIDTH="567" HEIGHT="46" BORDER="0"></TD>
  </TR>
  <TR>
    <TD width="193" align="left" valign="top" background="images/leftnavback.jpg">
      <IMG src="images/layout-02-01.gif" width="193" height="494" border="0" usemap="#Map"><MAP name="Map"><AREA shape="rect" coords="105,17,182,34" href="../whoweare.html"><AREA shape="rect" coords="82,34,182,51" href="/cgi-bin/calendar/display"><AREA shape="rect" coords="57,52,182,69" href="lbnews.html"><AREA shape="rect" coords="39,70,182,88" href="../admin_changes.html"><AREA shape="rect" coords="53,106,182,123" href="../prof_division.html"><AREA shape="rect" coords="42,123,182,140" href="../inter_division.html"><AREA shape="rect" coords="44,141,182,158" href="../contact.html"><AREA shape="rect" coords="144,161,182,176" href="../links.html"><AREA shape="rect" coords="98,196,182,214" href="../membership.html"></MAP></TD>
    <TD width="567" align="left" valign="top">
      <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" height="100%" align="left">
        <TR align="left" valign="top">
          <TD height="37"><IMG src="images/layout2-01-01.gif" width="36" height="38"></TD>
          <TD height="37" valign="middle"><font face="Verdana, Arial, Helvetica, sans-serif"><a href="../index.html"><font size="2">Home</font></a><font size="2">
            | <a href="lbnewsarchive.html">Archived News</a></font></font></TD>
        </TR>
        <TR align="left" valign="top">
          <TD><A name="Top"> </A></TD>
          <TD>
<!-- start new stuff -->
<a name="top">
<font face="verdana">
<b><font face="verdana" size="4" color="#003366">Late Breaking News</font></b><br>
[auth user="admin"]<font size="2">&#91;</font><font size="1"><a href="add0.html">ADD NEW CONTENT</a></font><font size="2">&#93;</font><br>[/auth]<br>
[search table="news" order="news.id desc" "where_news.archive"="no"]
[row]
<font size="2"><a href="lbnews.html#[field name='id'/]">[field name="link"/]</a>
<font size="1">(posted on [field name="date"/])<br>
[/row]
[/search]
<br>
<hr>
[search table="news" order="news.id desc" "where_news.archive"="no"]
[row]
<a name="[field name='id'/]">
<font size="4" color="#800040"><b>[upper][field name="title"/][/upper]</b></font><br>
[auth user="admin"]                                                                                                                       <font size="2">&#91;</font><font size="1"><a href="edit.html?item_id=[field name='id'/]">Edit</a> | <a href="delete.html?item_id=[field name='id'/]">Delete</a> | <a href="lbnews.html?addeddel_action=1&addeddel_db=news&addeddel_table=news&addeddel_ed=1&addeddel_original_id=[field name='id'/]&field_1_archive=yes">Archive</a></font><font size="2">&#93;</font>
[/auth]<br>
<font size="2" color="#000000">[field name="body"/]<br></font>
<br>
<p align="center">
<a href="lbnews.html#top">Go To Top</a> <a href="lbnews.html#top"><img align="absmiddle" src="../images/top.gif" border="0"></a><br>
</p>
<hr>
[/row]
[/search]
              <font face="Verdana, Arial, Helvetica, sans-serif">
              </FONT>
              <P align="center"><FONT face="Verdana, Arial, Helvetica, sans-serif" size="1">Copyright
                © 1996 All rights reserved. Reproduction in whole or in part in
                any form or medium without express written permission of the xxxxx
                xxxxxxxxxxx Association is prohibited.</FONT></P>
              <P align="center"><FONT face="Verdana, Arial, Helvetica, sans-serif" size="1"><A href="../index.html"><FONT size="2">Home</FONT></A><FONT size="2">
                | <A href="../whoweare.html">About our Internal Organization</A>
                | <A href="../mission.html">Our Mission</A> <BR>
                <A href="../officers.html">About our Officers and Staff</A> | <A href="../contact.html">Contact
                & Directions</A>
                                    </FONT></FONT></P>
              <P align="center"><FONT face="Verdana, Arial, Helvetica, sans-serif" size="1">If
                you wish to comment on any aspect of our site we can be reached
                at <A href="mailto:xxx@xxx.com">xxx@xxx.com</A></FONT></P>
              <P align="center"> </P>
            </dir>
            </TD>
        </TR>
        <TR align="left" valign="top">
          <TD> </TD>
          <TD> </TD>
        </TR>
      </TABLE>
    </TD>
  </TR>
</TABLE>
</BODY>
</HTML>

Link to comment
Share on other sites

Is this part of a CMS? He has some calls in there that are not HTML - everything with square brackets around it ([]). I'm suspecting that it is part of some system, and what you are looking at is just the template.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.