function sendNewsletter($from, $newsTitle, $newsBody)
{
$sql = "SELECT * FROM mailing_list WHERE active='1'";
$result = MYSQL_QUERY($sql);
$numberOfRows = MYSQL_NUMROWS($result);
$i = 0;
while ($i < $numberOfRows) {
$thisEmail = MYSQL_RESULT($result, $i, "email");
$thisUid = MYSQL_RESULT($result, $i, "uid");
$thisName = MYSQL_RESULT($result, $i, "full_name");
/* recipients */
$to = $thisEmail;
// note the comma
/* subject */
$subject = $newsTitle;
/* message */
$message = "Dear {$thisName} <br>";
$message .= $newsBody . '<br><br><a href="' . _PREF . 'modules/mailing_ilst/deleteMailing_list.php?thisEmailField=' . $thisEmail . '&thisUidField=' . $thisUid . '">
To unsubscribe please click here</a>';
/* To send HTML mail, you can set the Content-type header. */
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
/* additional headers */
$headers .= "To:" . $thisEmail . "\r\n";
$headers .= "From: " . $from;
/* and now mail it */
$s = mail($to, $subject, $message, $headers);
$i++;
}
if ($s) {
echo '<script>correctMessage("Message Sent successfuly");</script>';
} else {
echo '<script>errorMessage("Sorry message has not been sent, an error has occurred");</script>';
}
}
function lookupField($table, $id_field, $lookup_field, $id_value)
{
$sql_lookup = "SELECT `{$lookup_field}` from `{$table}` where `{$id_field}` = '{$id_value}'";
$result_lookup = MYSQL_QUERY($sql_lookup);
$rows_lookup = MYSQL_NUM_ROWS($result_lookup);
if ($rows_lookup == null || ($rows_lookup = 0)) {
return 0;
} else {
$filds = explode(",", $lookup_field);
$ind = 0;
$value = "";
while ($ind < count($filds)) {
$value .= stripslashes(MYSQL_RESULT($result_lookup, 0, $filds[$ind]) . " ");
$ind++;
}
return trim($value);
}
}
function statsMysqlQuery()
{
global $query, $statsData;
global $year, $month, $day, $user;
$qMonthNameH = mysql_query("select date_format('00-{$month}-00', '%M') as monthNameH");
$statsData[monthNameH] = MYSQL_RESULT($qMonthNameH, "monthNameH");
$statsData[monthNameH] = @constant(_ . strtoupper($statsData[monthNameH]));
$qFields = $query[fields][0];
$selectTable = $query[tables][0];
print eval($query[htmlFields] . ";");
eval("\$selectStatsEval = \"{$query['sStats']}\";");
$resultStats = mysql_query("{$selectStatsEval}");
while ($statsData = mysql_fetch_array($resultStats, MYSQL_ASSOC)) {
$statsData[loadbytes] = $statsData[loadbytesuser] + $statsData[loadbyteshost];
$statsData[cachebytes] = $statsData[cachebytesuser] + $statsData[cachebyteshost];
$statsData[totalbytes] = $statsData[loadbytes] + $statsData[cachebytes];
if ($statsData[loadbytes] != "0") {
$statsData[loadbytes_rate] = number_format($statsData[loadbytes] / $statsData[totalbytes] * 100, 2) . "%";
$statsData[cachebytes_rate] = number_format($statsData[cachebytes] / $statsData[totalbytes] * 100, 2) . "%";
}
print eval($query[htmlRow] . ";");
}
print htmlTableEnd();
}
$sql = "SELECT * FROM CHARACTER_SETS WHERE CHARACTER_SET_NAME = '{$thisCHARACTER_SET_NAME}'";
$result = MYSQL_QUERY($sql);
$numberOfRows = MYSQL_NUMROWS($result);
if ($numberOfRows == 0) {
?>
Sorry. No records found !!
<?php
} else {
if ($numberOfRows > 0) {
$i = 0;
$thisCHARACTER_SET_NAME = MYSQL_RESULT($result, $i, "CHARACTER_SET_NAME");
$thisDEFAULT_COLLATE_NAME = MYSQL_RESULT($result, $i, "DEFAULT_COLLATE_NAME");
$thisDESCRIPTION = MYSQL_RESULT($result, $i, "DESCRIPTION");
$thisMAXLEN = MYSQL_RESULT($result, $i, "MAXLEN");
}
}
?>
View Record<br><br>
<table>
<tr height="30">
<td align="right"><b>CHARACTER_SET_NAME : </b></td>
<td><?php
echo $thisCHARACTER_SET_NAME;
?>
</td>
</tr>
<tr height="30">
$result = MYSQL_QUERY($sql);
$numberOfRows = MYSQL_NUMROWS($result);
if ($numberOfRows == 0) {
?>
Sorry. No records found !!
<?php
} else {
if ($numberOfRows > 0) {
$i = 0;
$thisPROPERTY_ID = MYSQL_RESULT($result, $i, "PROPERTY_ID");
$thisPROPERTYDEF_ID = MYSQL_RESULT($result, $i, "PROPERTYDEF_ID");
$thisPROPERTY_MAPPING_ID = MYSQL_RESULT($result, $i, "PROPERTY_MAPPING_ID");
$thisPROPERTY_MAPPING_TYPE = MYSQL_RESULT($result, $i, "PROPERTY_MAPPING_TYPE");
$thisPROPERTY_VALUE = MYSQL_RESULT($result, $i, "PROPERTY_VALUE");
}
}
?>
View Record<br><br>
<table>
<tr height="30">
<td align="right"><b>PROPERTY_ID : </b></td>
<td><?php
echo $thisPROPERTY_ID;
?>
</td>
</tr>
<tr height="30">
$thisEVENT_OBJECT_TABLE = MYSQL_RESULT($result, $i, "EVENT_OBJECT_TABLE");
$thisACTION_ORDER = MYSQL_RESULT($result, $i, "ACTION_ORDER");
$thisACTION_CONDITION = MYSQL_RESULT($result, $i, "ACTION_CONDITION");
$thisACTION_STATEMENT = MYSQL_RESULT($result, $i, "ACTION_STATEMENT");
$thisACTION_ORIENTATION = MYSQL_RESULT($result, $i, "ACTION_ORIENTATION");
$thisACTION_TIMING = MYSQL_RESULT($result, $i, "ACTION_TIMING");
$thisACTION_REFERENCE_OLD_TABLE = MYSQL_RESULT($result, $i, "ACTION_REFERENCE_OLD_TABLE");
$thisACTION_REFERENCE_NEW_TABLE = MYSQL_RESULT($result, $i, "ACTION_REFERENCE_NEW_TABLE");
$thisACTION_REFERENCE_OLD_ROW = MYSQL_RESULT($result, $i, "ACTION_REFERENCE_OLD_ROW");
$thisACTION_REFERENCE_NEW_ROW = MYSQL_RESULT($result, $i, "ACTION_REFERENCE_NEW_ROW");
$thisCREATED = MYSQL_RESULT($result, $i, "CREATED");
$thisSQL_MODE = MYSQL_RESULT($result, $i, "SQL_MODE");
$thisDEFINER = MYSQL_RESULT($result, $i, "DEFINER");
$thisCHARACTER_SET_CLIENT = MYSQL_RESULT($result, $i, "CHARACTER_SET_CLIENT");
$thisCOLLATION_CONNECTION = MYSQL_RESULT($result, $i, "COLLATION_CONNECTION");
$thisDATABASE_COLLATION = MYSQL_RESULT($result, $i, "DATABASE_COLLATION");
?>
<TR BGCOLOR="<?php
echo $bgColor;
?>
">
<TD><?php
echo $thisTRIGGER_CATALOG;
?>
</TD>
<TD><?php
echo $thisTRIGGER_SCHEMA;
?>
</TD>
<TD><?php
echo $thisTRIGGER_NAME;
function updateAfterDelete($table, $newId)
{
$test = 1;
echo $newId;
$s = "select * from {$table} ";
$r = mysql_query($s);
$numberOfRows = MYSQL_NUMROWS($r);
$iz = 0;
$newId = explode(',', $newId);
while ($iz < $numberOfRows) {
$id = MYSQL_RESULT($r, $iz, "id");
$arr = MYSQL_RESULT($r, $iz, "collage_id");
$selected_ids = explode(',', $arr);
$n = "";
foreach ($selected_ids as $c) {
if (!in_array($c, $newId) || $c === '0') {
$n .= $c . ",";
} else {
$test = 0;
}
}
if ($test == 0) {
$n = str_replace(',,', ',', $n);
$wq = 'UPDATE ' . $table . ' SET `collage_id`="' . $n . '" WHERE id=' . $id;
mysql_query($wq);
}
$n = "";
$test = 1;
$iz++;
}
}
</FORM>
<?php
}
while ($i < $numberOfRows) {
if ($i % 2 == 0) {
$bgColor = "#FFFFFF";
} else {
$bgColor = "#C0C0C0";
}
$thisCOLLATION_NAME = MYSQL_RESULT($result, $i, "COLLATION_NAME");
$thisCHARACTER_SET_NAME = MYSQL_RESULT($result, $i, "CHARACTER_SET_NAME");
$thisID = MYSQL_RESULT($result, $i, "ID");
$thisIS_DEFAULT = MYSQL_RESULT($result, $i, "IS_DEFAULT");
$thisIS_COMPILED = MYSQL_RESULT($result, $i, "IS_COMPILED");
$thisSORTLEN = MYSQL_RESULT($result, $i, "SORTLEN");
if ($thisCOLLATION_NAMEFromForm == $thisCOLLATION_NAME) {
?>
<FORM NAME="editForm" METHOD="POST" ACTION="<?php
echo $_SERVER['PHP_SELF'];
?>
">
<input type="hidden" name="action" value="Update">
<input type="hidden" name="thisCOLLATION_NAMEField" value="<?php
echo $thisCOLLATION_NAME;
?>
">
<TR BGCOLOR="<?php
echo $bgColor;
?>
">
die("Query to show fields from table failed");
}
$rows = MYSQL_NUMROWS($result);
if ($rows == 0) {
echo '<div style=" color:red; text-align:center;"><h5>No Comments Found!</h5></div>';
} else {
if ($rows > 0) {
$i = 0;
while ($i < $rows) {
if ($i % 2 == 0) {
$bgcolor = '#FFFFFF';
} else {
$bgcolor = '@C0C0C0';
}
$comment = MYSQL_RESULT($result, $i, "comment");
$comment_id = MYSQL_RESULT($result, $i, "comment_id");
?>
<tr>
<td><?php
echo $comment;
?>
</td>
<td align="center">
<form action="posted.php" method="post">
<input type="hidden" name="comment_id" value="<?php
echo $comment_id;
?>
" />
<input type="submit" name="post" value="Post" />
</form>
<?php
} else {
if ($numberOfRows > 0) {
$i = 0;
$thisCustomer_id = MYSQL_RESULT($result, $i, "customer_id");
$thisFname = MYSQL_RESULT($result, $i, "fname");
$thisLname = MYSQL_RESULT($result, $i, "lname");
$thisCompany = MYSQL_RESULT($result, $i, "company");
$thisAddress1 = MYSQL_RESULT($result, $i, "address1");
$thisAddress2 = MYSQL_RESULT($result, $i, "address2");
$thisCity = MYSQL_RESULT($result, $i, "city");
$thisState_province = MYSQL_RESULT($result, $i, "state_province");
$thisCountry = MYSQL_RESULT($result, $i, "country");
$thisPostal_code = MYSQL_RESULT($result, $i, "postal_code");
$thisPhone = MYSQL_RESULT($result, $i, "phone");
$thisFax = MYSQL_RESULT($result, $i, "fax");
}
}
?>
<h2>更新记录</h2>
<form name="customersUpdateForm" method="POST" action="update.php">
<table cellspacing="2" cellpadding="2" border="0" width="100%">
<tr valign="top" height="20">
<td align="right"> <b> ID : </b> </td>
<td> <input type="text" name="thisCustomer_idField" size="20" value="<?php
echo $thisCustomer_id;
?>
"> </td>
</tr>
$thisSTATE = MYSQL_RESULT($result, $i, "STATE");
$thisDURATION = MYSQL_RESULT($result, $i, "DURATION");
$thisCPU_USER = MYSQL_RESULT($result, $i, "CPU_USER");
$thisCPU_SYSTEM = MYSQL_RESULT($result, $i, "CPU_SYSTEM");
$thisCONTEXT_VOLUNTARY = MYSQL_RESULT($result, $i, "CONTEXT_VOLUNTARY");
$thisCONTEXT_INVOLUNTARY = MYSQL_RESULT($result, $i, "CONTEXT_INVOLUNTARY");
$thisBLOCK_OPS_IN = MYSQL_RESULT($result, $i, "BLOCK_OPS_IN");
$thisBLOCK_OPS_OUT = MYSQL_RESULT($result, $i, "BLOCK_OPS_OUT");
$thisMESSAGES_SENT = MYSQL_RESULT($result, $i, "MESSAGES_SENT");
$thisMESSAGES_RECEIVED = MYSQL_RESULT($result, $i, "MESSAGES_RECEIVED");
$thisPAGE_FAULTS_MAJOR = MYSQL_RESULT($result, $i, "PAGE_FAULTS_MAJOR");
$thisPAGE_FAULTS_MINOR = MYSQL_RESULT($result, $i, "PAGE_FAULTS_MINOR");
$thisSWAPS = MYSQL_RESULT($result, $i, "SWAPS");
$thisSOURCE_FUNCTION = MYSQL_RESULT($result, $i, "SOURCE_FUNCTION");
$thisSOURCE_FILE = MYSQL_RESULT($result, $i, "SOURCE_FILE");
$thisSOURCE_LINE = MYSQL_RESULT($result, $i, "SOURCE_LINE");
}
}
?>
<h2>Confirm Record Deletion</h2><br><br>
<table>
<tr height="30">
<td align="right"><b>QUERY_ID : </b></td>
<td><?php
echo $thisQUERY_ID;
?>
</td>
</tr>
<tr height="30">
$sql = "SELECT * FROM CMS_USERDATA WHERE USER_ID = '{$thisUSER_ID}'";
$result = MYSQL_QUERY($sql);
$numberOfRows = MYSQL_NUMROWS($result);
if ($numberOfRows == 0) {
?>
Sorry. No records found !!
<?php
} else {
if ($numberOfRows > 0) {
$i = 0;
$thisUSER_ID = MYSQL_RESULT($result, $i, "USER_ID");
$thisDATA_KEY = MYSQL_RESULT($result, $i, "DATA_KEY");
$thisDATA_VALUE = MYSQL_RESULT($result, $i, "DATA_VALUE");
$thisDATA_TYPE = MYSQL_RESULT($result, $i, "DATA_TYPE");
}
}
?>
View Record<br><br>
<table>
<tr height="30">
<td align="right"><b>USER_ID : </b></td>
<td><?php
echo $thisUSER_ID;
?>
</td>
</tr>
<tr height="30">
$bgColor = "#FFFFFF";
} else {
$bgColor = "#C0C0C0";
}
$thisHISTORY_ID = MYSQL_RESULT($result, $i, "HISTORY_ID");
$thisPROJECT_ID = MYSQL_RESULT($result, $i, "PROJECT_ID");
$thisPROJECT_NAME = MYSQL_RESULT($result, $i, "PROJECT_NAME");
$thisUSER_ID = MYSQL_RESULT($result, $i, "USER_ID");
$thisPUBLISH_LOCALE = MYSQL_RESULT($result, $i, "PUBLISH_LOCALE");
$thisPUBLISH_FLAGS = MYSQL_RESULT($result, $i, "PUBLISH_FLAGS");
$thisPUBLISH_LIST = MYSQL_RESULT($result, $i, "PUBLISH_LIST");
$thisPUBLISH_REPORT = MYSQL_RESULT($result, $i, "PUBLISH_REPORT");
$thisRESOURCE_COUNT = MYSQL_RESULT($result, $i, "RESOURCE_COUNT");
$thisENQUEUE_TIME = MYSQL_RESULT($result, $i, "ENQUEUE_TIME");
$thisSTART_TIME = MYSQL_RESULT($result, $i, "START_TIME");
$thisFINISH_TIME = MYSQL_RESULT($result, $i, "FINISH_TIME");
$thisHISTORY_ID = highlightSearchTerms($thisHISTORY_ID, $thisKeyword, $highlightColor);
$thisPROJECT_ID = highlightSearchTerms($thisPROJECT_ID, $thisKeyword, $highlightColor);
$thisPROJECT_NAME = highlightSearchTerms($thisPROJECT_NAME, $thisKeyword, $highlightColor);
$thisUSER_ID = highlightSearchTerms($thisUSER_ID, $thisKeyword, $highlightColor);
$thisPUBLISH_LOCALE = highlightSearchTerms($thisPUBLISH_LOCALE, $thisKeyword, $highlightColor);
$thisPUBLISH_FLAGS = highlightSearchTerms($thisPUBLISH_FLAGS, $thisKeyword, $highlightColor);
$thisPUBLISH_LIST = highlightSearchTerms($thisPUBLISH_LIST, $thisKeyword, $highlightColor);
$thisPUBLISH_REPORT = highlightSearchTerms($thisPUBLISH_REPORT, $thisKeyword, $highlightColor);
$thisRESOURCE_COUNT = highlightSearchTerms($thisRESOURCE_COUNT, $thisKeyword, $highlightColor);
$thisENQUEUE_TIME = highlightSearchTerms($thisENQUEUE_TIME, $thisKeyword, $highlightColor);
$thisSTART_TIME = highlightSearchTerms($thisSTART_TIME, $thisKeyword, $highlightColor);
$thisFINISH_TIME = highlightSearchTerms($thisFINISH_TIME, $thisKeyword, $highlightColor);
?>
<TR BGCOLOR="<?php
echo $bgColor;
} else {
if ($numberOfRows > 0) {
$i = 0;
$thisRESOURCE_ID = MYSQL_RESULT($result, $i, "RESOURCE_ID");
$thisRESOURCE_TYPE = MYSQL_RESULT($result, $i, "RESOURCE_TYPE");
$thisRESOURCE_FLAGS = MYSQL_RESULT($result, $i, "RESOURCE_FLAGS");
$thisRESOURCE_STATE = MYSQL_RESULT($result, $i, "RESOURCE_STATE");
$thisRESOURCE_SIZE = MYSQL_RESULT($result, $i, "RESOURCE_SIZE");
$thisDATE_CONTENT = MYSQL_RESULT($result, $i, "DATE_CONTENT");
$thisSIBLING_COUNT = MYSQL_RESULT($result, $i, "SIBLING_COUNT");
$thisDATE_CREATED = MYSQL_RESULT($result, $i, "DATE_CREATED");
$thisDATE_LASTMODIFIED = MYSQL_RESULT($result, $i, "DATE_LASTMODIFIED");
$thisUSER_CREATED = MYSQL_RESULT($result, $i, "USER_CREATED");
$thisUSER_LASTMODIFIED = MYSQL_RESULT($result, $i, "USER_LASTMODIFIED");
$thisPROJECT_LASTMODIFIED = MYSQL_RESULT($result, $i, "PROJECT_LASTMODIFIED");
$thisRESOURCE_VERSION = MYSQL_RESULT($result, $i, "RESOURCE_VERSION");
}
}
?>
View Record<br><br>
<table>
<tr height="30">
<td align="right"><b>RESOURCE_ID : </b></td>
<td><?php
echo $thisRESOURCE_ID;
?>
</td>
</tr>
<tr height="30">
<?php
} else {
if ($numberOfRows > 0) {
$i = 0;
$thisPLUGIN_NAME = MYSQL_RESULT($result, $i, "PLUGIN_NAME");
$thisPLUGIN_VERSION = MYSQL_RESULT($result, $i, "PLUGIN_VERSION");
$thisPLUGIN_STATUS = MYSQL_RESULT($result, $i, "PLUGIN_STATUS");
$thisPLUGIN_TYPE = MYSQL_RESULT($result, $i, "PLUGIN_TYPE");
$thisPLUGIN_TYPE_VERSION = MYSQL_RESULT($result, $i, "PLUGIN_TYPE_VERSION");
$thisPLUGIN_LIBRARY = MYSQL_RESULT($result, $i, "PLUGIN_LIBRARY");
$thisPLUGIN_LIBRARY_VERSION = MYSQL_RESULT($result, $i, "PLUGIN_LIBRARY_VERSION");
$thisPLUGIN_AUTHOR = MYSQL_RESULT($result, $i, "PLUGIN_AUTHOR");
$thisPLUGIN_DESCRIPTION = MYSQL_RESULT($result, $i, "PLUGIN_DESCRIPTION");
$thisPLUGIN_LICENSE = MYSQL_RESULT($result, $i, "PLUGIN_LICENSE");
$thisLOAD_OPTION = MYSQL_RESULT($result, $i, "LOAD_OPTION");
}
}
?>
<h2>Update PLUGINS</h2>
<form name="pluginsUpdateForm" method="POST" action="updatePlugins.php">
<table cellspacing="2" cellpadding="2" border="0" width="100%">
<tr valign="top" height="20">
<td align="right"> <b> PLUGIN_NAME : </b> </td>
<td> <input type="text" name="thisPLUGIN_NAMEField" size="20" value="<?php
echo $thisPLUGIN_NAME;
?>
"> </td>
</tr>
$sql = "SELECT * FROM CMS_ALIASES WHERE path = '{$thisPath}'";
$result = MYSQL_QUERY($sql);
$numberOfRows = MYSQL_NUMROWS($result);
if ($numberOfRows == 0) {
?>
Sorry. No records found !!
<?php
} else {
if ($numberOfRows > 0) {
$i = 0;
$thisPath = MYSQL_RESULT($result, $i, "path");
$thisSite_root = MYSQL_RESULT($result, $i, "site_root");
$thisAlias_mode = MYSQL_RESULT($result, $i, "alias_mode");
$thisStructure_id = MYSQL_RESULT($result, $i, "structure_id");
}
}
?>
<h2>Update CMS_ALIASES</h2>
<form name="cms_aliasesUpdateForm" method="POST" action="updateCms_aliases.php">
<table cellspacing="2" cellpadding="2" border="0" width="100%">
<tr valign="top" height="20">
<td align="right"> <b> Path : </b> </td>
<td> <input type="text" name="thisPathField" size="20" value="<?php
echo $thisPath;
?>
"> </td>
</tr>
require "includes/session_init.php";
}
if ($_SESSION['LOGGEDIN'] != true) {
header("Location: index.php");
exit;
}
$eMail = $_SESSION['EMAIL'];
include "includes/data.php";
$connect = mysql_connect($host, $us, $ps);
if ($connect) {
$db = 'filmidid';
mysql_select_db($db);
$query = "select id from user_login where eMail='{$eMail}'";
$result = MYSQL_QUERY($query);
$numberOfRows4name = MYSQL_NUM_ROWS($result);
$id4login = MYSQL_RESULT($result, 0, "id");
if (!isset($pagenum)) {
$pagenum = 1;
}
$data = mysql_query("SELECT * FROM video_details d,fav_videos f where d.video_id=f.video_id and f.user_id='{$id4login}'") or die(mysql_error());
$rows = mysql_num_rows($data);
$page_rows = 5;
$last = ceil($rows / $page_rows);
if ($pagenum < 1) {
$pagenum = 1;
} elseif ($pagenum > $last) {
$pagenum = $last;
}
$max = 'limit ' . ($pagenum - 1) * $page_rows . ',' . $page_rows;
$data_p = mysql_query("SELECT * FROM video_details d,fav_videos f where d.video_id=f.video_id and f.user_id='{$id4login}' order by Rating{$append} desc {$max}") or die(mysql_error());
$rows4final = mysql_num_rows($data_p);
$result = MYSQL_QUERY($sql);
$numberOfRows = MYSQL_NUMROWS($result);
if ($numberOfRows == 0) {
?>
Sorry. No records found !!
<?php
} else {
if ($numberOfRows > 0) {
$i = 0;
$thisGRANTEE = MYSQL_RESULT($result, $i, "GRANTEE");
$thisTABLE_CATALOG = MYSQL_RESULT($result, $i, "TABLE_CATALOG");
$thisTABLE_SCHEMA = MYSQL_RESULT($result, $i, "TABLE_SCHEMA");
$thisPRIVILEGE_TYPE = MYSQL_RESULT($result, $i, "PRIVILEGE_TYPE");
$thisIS_GRANTABLE = MYSQL_RESULT($result, $i, "IS_GRANTABLE");
}
}
?>
<h2>Confirm Record Deletion</h2><br><br>
<table>
<tr height="30">
<td align="right"><b>GRANTEE : </b></td>
<td><?php
echo $thisGRANTEE;
?>
</td>
</tr>
<tr height="30">
<TD><input type"text" name="thisPROPERTYDEF_TYPEField" value=""></TD>
<TD COLSPAN=2><input type="submit" name="Insert" Value="Insert Record"> </TD>
</TR>
</FORM>
<?php
}
while ($i < $numberOfRows) {
if ($i % 2 == 0) {
$bgColor = "#FFFFFF";
} else {
$bgColor = "#C0C0C0";
}
$thisPROPERTYDEF_ID = MYSQL_RESULT($result, $i, "PROPERTYDEF_ID");
$thisPROPERTYDEF_NAME = MYSQL_RESULT($result, $i, "PROPERTYDEF_NAME");
$thisPROPERTYDEF_TYPE = MYSQL_RESULT($result, $i, "PROPERTYDEF_TYPE");
if ($thisPROPERTYDEF_IDFromForm == $thisPROPERTYDEF_ID) {
?>
<FORM NAME="editForm" METHOD="POST" ACTION="<?php
echo $_SERVER['PHP_SELF'];
?>
">
<input type="hidden" name="action" value="Update">
<input type="hidden" name="thisPROPERTYDEF_IDField" value="<?php
echo $thisPROPERTYDEF_ID;
?>
">
<TR BGCOLOR="<?php
echo $bgColor;
?>
">
$thisTABLE_CATALOG = MYSQL_RESULT($result, $i, "TABLE_CATALOG");
$thisTABLE_SCHEMA = MYSQL_RESULT($result, $i, "TABLE_SCHEMA");
$thisTABLE_NAME = MYSQL_RESULT($result, $i, "TABLE_NAME");
$thisNON_UNIQUE = MYSQL_RESULT($result, $i, "NON_UNIQUE");
$thisINDEX_SCHEMA = MYSQL_RESULT($result, $i, "INDEX_SCHEMA");
$thisINDEX_NAME = MYSQL_RESULT($result, $i, "INDEX_NAME");
$thisSEQ_IN_INDEX = MYSQL_RESULT($result, $i, "SEQ_IN_INDEX");
$thisCOLUMN_NAME = MYSQL_RESULT($result, $i, "COLUMN_NAME");
$thisCOLLATION = MYSQL_RESULT($result, $i, "COLLATION");
$thisCARDINALITY = MYSQL_RESULT($result, $i, "CARDINALITY");
$thisSUB_PART = MYSQL_RESULT($result, $i, "SUB_PART");
$thisPACKED = MYSQL_RESULT($result, $i, "PACKED");
$thisNULLABLE = MYSQL_RESULT($result, $i, "NULLABLE");
$thisINDEX_TYPE = MYSQL_RESULT($result, $i, "INDEX_TYPE");
$thisCOMMENT = MYSQL_RESULT($result, $i, "COMMENT");
$thisINDEX_COMMENT = MYSQL_RESULT($result, $i, "INDEX_COMMENT");
?>
<TR BGCOLOR="<?php
echo $bgColor;
?>
">
<TD><?php
echo $thisTABLE_CATALOG;
?>
</TD>
<TD><?php
echo $thisTABLE_SCHEMA;
?>
</TD>
<TD><?php
echo $thisTABLE_NAME;
$thisCOLUMN_NAME = MYSQL_RESULT($result, $i, "COLUMN_NAME");
$thisORDINAL_POSITION = MYSQL_RESULT($result, $i, "ORDINAL_POSITION");
$thisCOLUMN_DEFAULT = MYSQL_RESULT($result, $i, "COLUMN_DEFAULT");
$thisIS_NULLABLE = MYSQL_RESULT($result, $i, "IS_NULLABLE");
$thisDATA_TYPE = MYSQL_RESULT($result, $i, "DATA_TYPE");
$thisCHARACTER_MAXIMUM_LENGTH = MYSQL_RESULT($result, $i, "CHARACTER_MAXIMUM_LENGTH");
$thisCHARACTER_OCTET_LENGTH = MYSQL_RESULT($result, $i, "CHARACTER_OCTET_LENGTH");
$thisNUMERIC_PRECISION = MYSQL_RESULT($result, $i, "NUMERIC_PRECISION");
$thisNUMERIC_SCALE = MYSQL_RESULT($result, $i, "NUMERIC_SCALE");
$thisCHARACTER_SET_NAME = MYSQL_RESULT($result, $i, "CHARACTER_SET_NAME");
$thisCOLLATION_NAME = MYSQL_RESULT($result, $i, "COLLATION_NAME");
$thisCOLUMN_TYPE = MYSQL_RESULT($result, $i, "COLUMN_TYPE");
$thisCOLUMN_KEY = MYSQL_RESULT($result, $i, "COLUMN_KEY");
$thisEXTRA = MYSQL_RESULT($result, $i, "EXTRA");
$thisPRIVILEGES = MYSQL_RESULT($result, $i, "PRIVILEGES");
$thisCOLUMN_COMMENT = MYSQL_RESULT($result, $i, "COLUMN_COMMENT");
if ($thisTABLE_CATALOGFromForm == $thisTABLE_CATALOG) {
?>
<FORM NAME="editForm" METHOD="POST" ACTION="<?php
echo $_SERVER['PHP_SELF'];
?>
">
<input type="hidden" name="action" value="Update">
<input type="hidden" name="thisTABLE_CATALOGField" value="<?php
echo $thisTABLE_CATALOG;
?>
">
<TR BGCOLOR="<?php
echo $bgColor;
?>
">
echo $limitPerPage;
?>
">
<B>VARIABLE_VALUE</B>
</a>
</TD>
</TR>
<?php
while ($i < $numberOfRows) {
if ($i % 2 == 0) {
$bgColor = "#FFFFFF";
} else {
$bgColor = "#C0C0C0";
}
$thisVARIABLE_NAME = MYSQL_RESULT($result, $i, "VARIABLE_NAME");
$thisVARIABLE_VALUE = MYSQL_RESULT($result, $i, "VARIABLE_VALUE");
?>
<TR BGCOLOR="<?php
echo $bgColor;
?>
">
<TD><?php
echo $thisVARIABLE_NAME;
?>
</TD>
<TD><?php
echo $thisVARIABLE_VALUE;
?>
</TD>
<TD><a href="editSESSION_VARIABLES.php?VARIABLE_NAMEField=<?php
echo $thisVARIABLE_NAME;
<TD><input type"text" name="thisRESOURCE_IDField" value=""></TD>
<TD><input type"text" name="thisFILE_CONTENTField" value=""></TD>
<TD COLSPAN=2><input type="submit" name="Insert" Value="Insert Record"> </TD>
</TR>
</FORM>
<?php
}
while ($i < $numberOfRows) {
if ($i % 2 == 0) {
$bgColor = "#FFFFFF";
} else {
$bgColor = "#C0C0C0";
}
$thisRESOURCE_ID = MYSQL_RESULT($result, $i, "RESOURCE_ID");
$thisFILE_CONTENT = MYSQL_RESULT($result, $i, "FILE_CONTENT");
if ($thisRESOURCE_IDFromForm == $thisRESOURCE_ID) {
?>
<FORM NAME="editForm" METHOD="POST" ACTION="<?php
echo $_SERVER['PHP_SELF'];
?>
">
<input type="hidden" name="action" value="Update">
<input type="hidden" name="thisRESOURCE_IDField" value="<?php
echo $thisRESOURCE_ID;
?>
">
<TR BGCOLOR="<?php
echo $bgColor;
?>
">
$bgColor = "#FFFFFF";
} else {
$bgColor = "#C0C0C0";
}
$thisCONSTRAINT_CATALOG = MYSQL_RESULT($result, $i, "CONSTRAINT_CATALOG");
$thisCONSTRAINT_SCHEMA = MYSQL_RESULT($result, $i, "CONSTRAINT_SCHEMA");
$thisCONSTRAINT_NAME = MYSQL_RESULT($result, $i, "CONSTRAINT_NAME");
$thisTABLE_CATALOG = MYSQL_RESULT($result, $i, "TABLE_CATALOG");
$thisTABLE_SCHEMA = MYSQL_RESULT($result, $i, "TABLE_SCHEMA");
$thisTABLE_NAME = MYSQL_RESULT($result, $i, "TABLE_NAME");
$thisCOLUMN_NAME = MYSQL_RESULT($result, $i, "COLUMN_NAME");
$thisORDINAL_POSITION = MYSQL_RESULT($result, $i, "ORDINAL_POSITION");
$thisPOSITION_IN_UNIQUE_CONSTRAINT = MYSQL_RESULT($result, $i, "POSITION_IN_UNIQUE_CONSTRAINT");
$thisREFERENCED_TABLE_SCHEMA = MYSQL_RESULT($result, $i, "REFERENCED_TABLE_SCHEMA");
$thisREFERENCED_TABLE_NAME = MYSQL_RESULT($result, $i, "REFERENCED_TABLE_NAME");
$thisREFERENCED_COLUMN_NAME = MYSQL_RESULT($result, $i, "REFERENCED_COLUMN_NAME");
?>
<TR BGCOLOR="<?php
echo $bgColor;
?>
">
<TD><?php
echo $thisCONSTRAINT_CATALOG;
?>
</TD>
<TD><?php
echo $thisCONSTRAINT_SCHEMA;
?>
</TD>
<TD><?php
echo $thisCONSTRAINT_NAME;
<option>09</option>
<option>10</option>
<option selected="selected">11</option>
</select>
</label>
<?php
include "include/data.php";
$connect = mysql_connect($host, $us, $ps);
$db = 'vitbifi';
mysql_select_db($db, $connect);
$query = "select * from branch where 1";
$result = mysql_query($query);
$rows = mysql_num_rows($result);
$i = 0;
while ($i < $rows) {
$branch[$i] = MYSQL_RESULT($result, $i, "branch");
$i++;
}
?>
<label>
<select name="branch" size="1" title="Select Branch." class="NormalTextStyle">
<?php
$i = 0;
while ($i < $rows) {
?>
<option><?php
echo $branch[$i];
?>
</option>
<?php
$i++;
while ($rows4job >= $i) {
$thisjob_id = @MYSQL_RESULT($result4job, $rows4job, "job_id");
$thisid = @MYSQL_RESULT($result4job, $rows4job, "id");
$thisjobTitle = @MYSQL_RESULT($result4job, $rows4job, "jobTitle");
$thislanguages = @MYSQL_RESULT($result4job, $rows4job, "languages");
$thiscompanyName = @MYSQL_RESULT($result4job, $rows4job, "companyName");
$thiscompanyProfile = @MYSQL_RESULT($result4job, $rows4job, "companyProfile");
$thiscountry = @MYSQL_RESULT($result4job, $rows4job, "country");
$thisstate = @MYSQL_RESULT($result4job, $rows4job, "location");
$thisdate = @MYSQL_RESULT($result4job, $rows4job, "date");
$thiscategories = @MYSQL_RESULT($result4job, $rows4job, "categories");
$thispaid = @MYSQL_RESULT($result4job, $rows4job, "paid");
$thisamt = @MYSQL_RESULT($result4job, $rows4job, "amt");
$thisexpr = @MYSQL_RESULT($result4job, $rows4job, "expr");
$thisdetails = @MYSQL_RESULT($result4job, $rows4job, "details");
$thiscurr_date = @MYSQL_RESULT($result4job, $rows4job, "curr_date");
?>
<div class="job_box">
<div>
<a href="jobs_desc.php?job_id=<?php
echo $thisjob_id;
?>
">Job Post <?php
echo $k;
$k++;
?>
</a>
<span class="det2 det3">
<?php
$i = 0;
while ($i < $numberOfRows4qty) {
$menuQty[$i]['link'] = MYSQL_RESULT($result4qty, $i, "link");
$i++;
}
$i = 0;
while ($i < $numberOfRows4avail) {
$menuAvail[$i]['menuId'] = MYSQL_RESULT($result4avail, $i, "menuId");
$menuAvail[$i]['deliveryTime'] = MYSQL_RESULT($result4avail, $i, "time");
$menuAvail[$i]['link'] = MYSQL_RESULT($result4avail, $i, "link");
$i++;
}
$i = 0;
while ($i < $numberOfRows4menu) {
$menu[$i]['menuId'] = MYSQL_RESULT($result4menu, $i, "menuId");
$menu[$i]['orderTime'] = MYSQL_RESULT($result4menu, $i, "orderTime");
$i++;
}
// Obtain a list of columns
foreach ($menuAvail as $key => $row) {
$link[$key] = $row['link'];
$delTime[$key] = $row['deliveryTime'];
}
// Add $data as the last parameter, to sort by the common key
array_multisort($link, SORT_ASC, $delTime, SORT_ASC, $menuAvail);
$link = 0;
$i = 0;
while ($i < $numberOfRows4avail) {
if ($i == 0 || $menuAvail[$i]['link'] != $menuAvail[$i - 1]['link']) {
$link = $menuAvail[$i]['link'];
$dTime = $menuAvail[$i]['deliveryTime'];
</a>
</TD>
</TR>
<?php
$highlightColor = "#FFFF99";
while ($i < $numberOfRows) {
if ($i % 2 == 0) {
$bgColor = "#FFFFFF";
} else {
$bgColor = "#C0C0C0";
}
$thisID = MYSQL_RESULT($result, $i, "ID");
$thisALIAS_MODE = MYSQL_RESULT($result, $i, "ALIAS_MODE");
$thisPATTERN = MYSQL_RESULT($result, $i, "PATTERN");
$thisREPLACEMENT = MYSQL_RESULT($result, $i, "REPLACEMENT");
$thisSITE_ROOT = MYSQL_RESULT($result, $i, "SITE_ROOT");
$thisID = highlightSearchTerms($thisID, $thisKeyword, $highlightColor);
$thisALIAS_MODE = highlightSearchTerms($thisALIAS_MODE, $thisKeyword, $highlightColor);
$thisPATTERN = highlightSearchTerms($thisPATTERN, $thisKeyword, $highlightColor);
$thisREPLACEMENT = highlightSearchTerms($thisREPLACEMENT, $thisKeyword, $highlightColor);
$thisSITE_ROOT = highlightSearchTerms($thisSITE_ROOT, $thisKeyword, $highlightColor);
?>
<TR BGCOLOR="<?php
echo $bgColor;
?>
">
<TD><?php
echo $thisID;
?>
</TD>
<TD><?php
$thisNUMBER_PAGES_WRITTEN = MYSQL_RESULT($result, $i, "NUMBER_PAGES_WRITTEN");
$thisPAGES_READ_RATE = MYSQL_RESULT($result, $i, "PAGES_READ_RATE");
$thisPAGES_CREATE_RATE = MYSQL_RESULT($result, $i, "PAGES_CREATE_RATE");
$thisPAGES_WRITTEN_RATE = MYSQL_RESULT($result, $i, "PAGES_WRITTEN_RATE");
$thisNUMBER_PAGES_GET = MYSQL_RESULT($result, $i, "NUMBER_PAGES_GET");
$thisHIT_RATE = MYSQL_RESULT($result, $i, "HIT_RATE");
$thisYOUNG_MAKE_PER_THOUSAND_GETS = MYSQL_RESULT($result, $i, "YOUNG_MAKE_PER_THOUSAND_GETS");
$thisNOT_YOUNG_MAKE_PER_THOUSAND_GETS = MYSQL_RESULT($result, $i, "NOT_YOUNG_MAKE_PER_THOUSAND_GETS");
$thisNUMBER_PAGES_READ_AHEAD = MYSQL_RESULT($result, $i, "NUMBER_PAGES_READ_AHEAD");
$thisNUMBER_READ_AHEAD_EVICTED = MYSQL_RESULT($result, $i, "NUMBER_READ_AHEAD_EVICTED");
$thisREAD_AHEAD_RATE = MYSQL_RESULT($result, $i, "READ_AHEAD_RATE");
$thisREAD_AHEAD_EVICTED_RATE = MYSQL_RESULT($result, $i, "READ_AHEAD_EVICTED_RATE");
$thisLRU_IO_TOTAL = MYSQL_RESULT($result, $i, "LRU_IO_TOTAL");
$thisLRU_IO_CURRENT = MYSQL_RESULT($result, $i, "LRU_IO_CURRENT");
$thisUNCOMPRESS_TOTAL = MYSQL_RESULT($result, $i, "UNCOMPRESS_TOTAL");
$thisUNCOMPRESS_CURRENT = MYSQL_RESULT($result, $i, "UNCOMPRESS_CURRENT");
?>
<TR BGCOLOR="<?php
echo $bgColor;
?>
">
<TD><?php
echo $thisPOOL_ID;
?>
</TD>
<TD><?php
echo $thisPOOL_SIZE;
?>
</TD>
<TD><?php
echo $thisFREE_BUFFERS;
<TD><input type"text" name="thisNAMEField" value=""></TD>
<TD><input type"text" name="thisCOUNTERField" value=""></TD>
<TD COLSPAN=2><input type="submit" name="Insert" Value="Insert Record"> </TD>
</TR>
</FORM>
<?php
}
while ($i < $numberOfRows) {
if ($i % 2 == 0) {
$bgColor = "#FFFFFF";
} else {
$bgColor = "#C0C0C0";
}
$thisNAME = MYSQL_RESULT($result, $i, "NAME");
$thisCOUNTER = MYSQL_RESULT($result, $i, "COUNTER");
if ($thisNAMEFromForm == $thisNAME) {
?>
<FORM NAME="editForm" METHOD="POST" ACTION="<?php
echo $_SERVER['PHP_SELF'];
?>
">
<input type="hidden" name="action" value="Update">
<input type="hidden" name="thisNAMEField" value="<?php
echo $thisNAME;
?>
">
<TR BGCOLOR="<?php
echo $bgColor;
?>
">