Exemple #1
0
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);
     }
 }
Exemple #3
0
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();
}
Exemple #4
0
$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">
Exemple #6
0
            $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;
Exemple #7
0
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++;
    }
}
Exemple #8
0
</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;
                ?>
">
Exemple #9
0
    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>
Exemple #11
0
        $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">
Exemple #12
0
$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">
Exemple #13
0
                $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">
Exemple #15
0
<?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>
Exemple #16
0
$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>
Exemple #17
0
    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;
                ?>
">
Exemple #20
0
            $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;
Exemple #21
0
            $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;
                ?>
">
Exemple #22
0
        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;
                ?>
">
Exemple #24
0
                $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;
Exemple #25
0
				 <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++;
Exemple #26
0
    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 
Exemple #27
0
$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'];
Exemple #28
0
			</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;
Exemple #30
0
		<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;
                ?>
">