本文整理汇总了PHP中getResult函数的典型用法代码示例。如果您正苦于以下问题:PHP getResult函数的具体用法?PHP getResult怎么用?PHP getResult使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了getResult函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: processing
function processing()
{
global $sModule;
global $sFfmpegPath;
global $sModulesPath;
global $sFilesPath;
$iFilesCount = getSettingValue($sModule, "processCount");
if (!is_numeric($iFilesCount)) {
$iFilesCount = 2;
}
$iFailedTimeout = getSettingValue($sModule, "failedTimeout");
if (!is_numeric($iFailedTimeout)) {
$iFailedTimeout = 1;
}
$iFailedTimeout *= 86400;
$sDbPrefix = DB_PREFIX . ucfirst($sModule);
$iCurrentTime = time();
//remove all tokens older than 10 minutes
getResult("DELETE FROM `" . $sDbPrefix . "Tokens` WHERE `Date`<'" . ($iCurrentTime - 600) . "'");
getResult("UPDATE `" . $sDbPrefix . "Files` SET `Date`='" . $iCurrentTime . "', `Status`='" . VC_STATUS_FAILED . "' WHERE `Status`='" . VC_STATUS_PROCESSING . "' AND `Date`<'" . ($iCurrentTime - $iFailedTimeout) . "'");
$rResult = getResult("SELECT * FROM `" . $sDbPrefix . "Files` WHERE `Status`='" . VC_STATUS_PENDING . "' ORDER BY `ID` LIMIT " . $iFilesCount);
for ($i = 0; $i < mysql_num_rows($rResult); $i++) {
$aFile = mysql_fetch_assoc($rResult);
if (!_convert($aFile['ID'])) {
getResult("UPDATE `" . $sDbPrefix . "Files` SET `Status`='" . VC_STATUS_FAILED . "' WHERE `ID`='" . $aFile['ID'] . "'");
}
}
}
示例2: getBlockedUsers
function getBlockedUsers($sBlockerId)
{
$aUsers = array();
$rResult = getResult("SELECT `Profile` FROM `sys_block_list` WHERE `ID`='" . $sBlockerId . "'");
while ($aUser = mysql_fetch_assoc($rResult)) {
$aUsers[] = $aUser['Profile'];
}
return $aUsers;
}
示例3: processing
function processing()
{
global $sModule;
global $sFfmpegPath;
global $sModulesPath;
global $sFilesPath;
$iFilesCount = getSettingValue($sModule, "processCount");
if (!is_numeric($iFilesCount)) {
$iFilesCount = 2;
}
$iFailedTimeout = getSettingValue($sModule, "failedTimeout");
if (!is_numeric($iFailedTimeout)) {
$iFailedTimeout = 1;
}
$iFailedTimeout *= 86400;
$sDbPrefix = DB_PREFIX . ucfirst($sModule);
$iCurrentTime = time();
do {
//remove all tokens older than 10 minutes
if (!getResult("DELETE FROM `" . $sDbPrefix . "Tokens` WHERE `Date`<'" . ($iCurrentTime - 600) . "'")) {
break;
}
if (!getResult("UPDATE `" . $sDbPrefix . "Files` SET `Date`='" . $iCurrentTime . "', `Status`='" . STATUS_FAILED . "' WHERE `Status`='" . STATUS_PROCESSING . "' AND `Date`<'" . ($iCurrentTime - $iFailedTimeout) . "'")) {
break;
}
$rResult = getResult("SELECT * FROM `" . $sDbPrefix . "Files` WHERE `Status`='" . STATUS_PENDING . "' ORDER BY `ID` LIMIT " . $iFilesCount);
if (!$rResult) {
break;
}
for ($i = 0; $i < mysql_num_rows($rResult); $i++) {
$aFile = mysql_fetch_assoc($rResult);
if (convertVideo($aFile['ID'])) {
$sType = 'bx_videos';
//album counter & cover update
if (getSettingValue($sModule, "autoApprove") == TRUE_VAL) {
$oAlbum = new BxDolAlbums($sType);
$oAlbum->updateObjCounterById($aFile['ID']);
if (getParam($oAlbum->sAlbumCoverParam) == 'on') {
$oAlbum->updateLastObjById($aFile['ID']);
}
}
//tags & categories parsing
$oTag = new BxDolTags();
$oTag->reparseObjTags($sType, $aFile['ID']);
$oCateg = new BxDolCategories($aFile['Owner']);
$oCateg->reparseObjTags($sType, $aFile['ID']);
} else {
if (!getResult("UPDATE `" . $sDbPrefix . "Files` SET `Status`='" . STATUS_FAILED . "' WHERE `ID`='" . $aFile['ID'] . "'")) {
break;
}
}
}
} while (false);
}
示例4: contactInfo
function contactInfo($db, $call)
{
$contacts = '';
$q3 = "SELECT contact, validity " . "FROM ares_contact_info " . "WHERE `type` = 4 AND `call`='" . $call . "'";
//echo "<p>[" . $q3 . "]</p>\n";
$r3 = getResult($q3, $db);
if ($row3 = getRow($r3, $db)) {
$contacts = $row3[0];
}
echo $contacts . ", ";
}
示例5: deleteFile
/**
* Delete file
* @param $sFile - file identificator
* @return $bResult - result of operation (true/false)
*/
function deleteFile($sFile)
{
global $sFilesPath;
getResult("DELETE FROM `" . MODULE_DB_PREFIX . "Files` WHERE `ID`='" . $sFile . "'");
getResult("DELETE FROM `" . MODULE_DB_PREFIX . "PlayLists` WHERE `FileId`='" . $sFile . "'");
parseTags($sFile);
$sFileName = $sFilesPath . $sFile;
$bResult = @unlink($sFileName . PLAY_EXTENSION);
$bResult = @unlink($sFileName . SAVE_EXTENSION);
$bResult = @unlink($sFileName . IMAGE_EXTENSION);
return $bResult;
}
示例6: post
function post($sTable, $sId, $sAuthor, $sParent, $sMood, $sFileId)
{
global $sIncPath;
global $sModule;
global $sHomeUrl;
require $sIncPath . "content.inc.php";
$sText = getEmbedCode($sModule, "player", array('id' => $sFileId, 'file' => TRUE_VAL));
$sText = str_replace($sHomeUrl, "[ray_url]", $sText);
$sSql = "INSERT INTO `" . $sTable . "`(`cmt_parent_id`, `cmt_object_id`, `cmt_author_id`, `cmt_text`, `cmt_mood`, `cmt_time`) VALUES('" . $sParent . "', '" . $sId . "', '" . $sAuthor . "', '" . $sText . "', '" . $sMood . "', NOW())";
getResult($sSql);
return getLastInsertId();
}
示例7: updateCascade
function updateCascade($cascade, $auth, $blockID, $xmlData)
{
$id = array('id' => $blockID, 'type' => 'block');
$readParams = array('authentication' => $auth, 'identifier' => $id);
$blockRead = $cascade->read($readParams);
$asset = $blockRead->readReturn->asset->xmlBlock;
$asset->xml = $xmlData;
$editParams = array('authentication' => $auth, 'asset' => array('xmlBlock' => $asset));
$cascade->edit($editParams);
$result = $cascade->__getLastResponse();
getResult($result, $asset->name);
}
示例8: post
function post($sTable, $sId, $sAuthor, $sParent, $sMood, $sFileId)
{
global $sIncPath;
global $sModule;
global $sHomeUrl;
$sText = getEmbedCode($sModule, "player", array('id' => $sFileId));
$sText = str_replace($sHomeUrl, "[ray_url]", $sText);
$sSql = "INSERT INTO `" . $sTable . "`(`cmt_parent_id`, `cmt_object_id`, `cmt_author_id`, `cmt_text`, `cmt_mood`, `cmt_time`) VALUES('" . $sParent . "', '" . $sId . "', '" . $sAuthor . "', '" . $sText . "', '" . $sMood . "', NOW())";
getResult($sSql);
$iCommentId = getLastInsertId();
getResult("UPDATE `" . MODULE_DB_PREFIX . "Files` SET `Description`='" . $iCommentId . "' WHERE `ID`='" . $sFileId . "'");
return $iCommentId;
}
示例9: getResult
function getResult($dir, &$retArray)
{
foreach (glob($dir . "/*") as $filePath) {
if (is_dir($filePath)) {
array_push($retArray, '<li data-options="attributes:{file_path:\'\'}, state:\'closed\'">');
array_push($retArray, '<span>' . basename($filePath) . '</span>');
array_push($retArray, '<ul>');
getResult($filePath, $retArray);
array_push($retArray, '</ul>');
array_push($retArray, '</li>');
} else {
array_push($retArray, '<li data-options="attributes:{file_path:\'' . $filePath . '\'}">');
array_push($retArray, '<span>' . basename($filePath) . '</span>');
array_push($retArray, '</li>');
}
}
}
示例10: contactInfo
function contactInfo($db, $call)
{
$contacts = '';
$q3 = "SELECT ares_contact_type, contact, validity, A.type " . "FROM ares_contact_info A, ares_contact_type B " . "WHERE A.type = B.type AND A.call='" . $call . "'";
//echo "<p>" . $q3 . ",/p>\n";
$r3 = getResult($q3, $db);
while ($row3 = getRow($r3, $db)) {
$xx = $row3[1];
if ($row3[3] < 4) {
$xx = formatNumber($row3[1]);
}
if ($row3[2] == 1) {
$contacts = $contacts . $row3[0] . ": <b>" . $xx . "</b><br>";
} else {
$contacts = $contacts . $row3[0] . ": " . $xx . "<br>";
}
}
echo $contacts;
}
示例11: getOnline
/**
* get online users
* @param aRange - users IDs range to select from
* @param $bInRange - get users that in(not in) range
*/
function getOnline($aRange = array(), $bInRange = true)
{
require_once BX_DIRECTORY_PATH_INC . "db.inc.php";
$iMin = getParam("member_online_time");
$sInRange = $bInRange ? "IN" : "NOT IN";
$sWhere = " WHERE `UserStatus`!='" . USER_STATUS_OFFLINE . "' AND `DateLastNav`>SUBDATE(NOW(), INTERVAL " . $iMin . " MINUTE) ";
if (isset($aRange) && count($aRange) > 0) {
$sQuery = "SELECT `ID` FROM `Profiles`" . $sWhere . "AND `ID` " . $sInRange . " (" . implode(",", $aRange) . ") ORDER BY `ID`";
} else {
$sQuery = "SELECT `ID` FROM `Profiles`" . $sWhere . "ORDER BY `ID`";
}
$rOnline = getResult($sQuery);
$aOnline = array();
while ($aUser = mysql_fetch_array($rOnline)) {
$aOnline[] = $aUser['ID'];
}
return $aOnline;
}
示例12: removeFile
function removeFile($sFileId)
{
global $sFilesPath;
@getResult("DELETE FROM `" . MODULE_DB_PREFIX . "Messages` WHERE `ID`='" . $sFileId . "'");
@unlink($sFilesPath . $sFileId . ".file");
}
示例13: define
}
if (!defined('CURRENT_CATEGORY')) {
define('CURRENT_CATEGORY', 'athletica_tech');
}
if (!defined('CURRENT_PAGE')) {
define('CURRENT_PAGE', 'results');
}
require_once ROOT_PATH . 'lib/inc.init.php';
require_once ROOT_PATH . 'lib/cls.result_tech.php';
$events = getEvents(CFG_CURRENT_MEETING, CFG_CURRENT_EVENT);
$type = $glb_types_results[$events['disc_type']];
$wind = $events['event_wind'];
$result_id = $_GET['result'];
$athlete_id = $_GET['athlete'];
$attempt = $_GET['attempt'];
$result = getResult($result_id);
$athlete = getAthleteDetails($athlete_id, false, 'ath_pos', 0, true);
?>
<script type="text/javascript">
$(document).ready(function(){
$('button').button();
$('#result_edit_result, #result_edit_wind').keyup(function(){
validate();
});
$('#result_edit_result').blur(function(){
var res = $(this).val();
if (res) {
$.ajax({
示例14: MAX
$Q2 = "SELECT MAX(`PERIOD`) FROM `arpsc_ecrept` " . "WHERE `county`='" . $row1[0] . "'";
$last = singleResult($Q2, $db);
$Q3 = "SELECT `ARESMEM` FROM `arpsc_ecrept` " . "WHERE `COUNTY`='" . $row1[0] . "' " . "AND `PERIOD`=" . $last;
$latest = singleResult($Q3, $db);
$Q4 = "SELECT `ARESMEM` FROM `arpsc_ecrept` " . "WHERE `COUNTY`='" . $row1[0] . "' " . "AND `PERIOD`=0";
$zeroth = singleResult($Q4, $db);
echo "<p>" . $row1[0] . ": " . $last . ", ";
if ($latest == $zeroth) {
echo $latest . ", " . $zeroth . "</p>\n";
} else {
if ($zeroth > 0) {
echo "<b>" . $latest . ", " . $zeroth . "</b><br/>\n";
$Q5 = 'UPDATE `arpsc_ecrept` SET `ARESMEM`=' . $latest . " WHERE `COUNTY`='" . $row1[0] . "' AND `PERIOD`=0";
echo "---" . $Q5 . "---</p>\n";
$R5 = getResult($Q5, $db);
} else {
echo "<span style=\"color: red;\">" . $latest . ", " . $zeroth . "</span><br />\n";
$Q5 = "INSERT INTO `arpsc_ecrept` (PERIOD,COUNTY,ARESMEM,UPDATED) " . "VALUES(0,'" . $row1[0] . "'," . $latest . ",NOW());";
echo "---" . $Q5 . "---</p>\n";
$R5 = getResult($Q5, $db);
}
}
}
echo " </div>\n";
sectLeaders($db);
footer($starttime, "2010-11-11", "\$Revision: 1.1 \$ - \$Date: 2010-11-11 10:12:48-04 \$");
?>
</div>
</body>
</html>
示例15: getID
<?php
echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
echo "<board>\n";
include "../ConDBi.php";
/*
==============================================
POST VARS
==============================================
*/
$uid = $_POST["uid"];
$id = getID($application);
$title = $_POST["title"];
$content = $_POST["content"];
/*
==============================================
INSERT REPLY
==============================================
*/
$stmt->prepare("INSERT INTO Board.board\n\t\t\t\t\tSELECT \n\t\t\t\t\t\t'', #uid(auto_increment)\n\t\t\t\t\t\tpid,\n\t\t\t\t\t\tapplication,\n\t\t\t\t\t\tcategory,\n\t\t\t\t\t\t\n\t\t\t\t\t\t?, #--> id\n\t\t\t\t\t\t?, #--> title\n\t\t\t\t\t\t?, #--> content\n\t\t\t\t\t\tnow(), #timestamp\n\t\t\t\t\t\t0, #hit\n\t\t\t\t\t\t\n\t\t\t\t\t\tCASE\n\t\t\t\t\t\t\tWHEN right_depth IS NULL THEN\n\t\t\t\t\t\t\t\tCONCAT(depth, 'A')\n\t\t\t\t\t\t\tELSE\n\t\t\t\t\t\t\t\tCONCAT(depth, CHAR(ASCII(right_depth) + 1))\n\t\t\t\t\t\tEND depth,\n\t\t\t\t\t\t1 #live\n\t\t\t\t\tFROM\n\t\t\t\t\t(\n\t\t\t\t\t\tSELECT B.application, B.category, B.pid, B.depth, right(D.depth, 1) right_depth\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\tBoard.board B LEFT OUTER JOIN Board.board D\n\t\t\t\t\t\t\t\tON B.pid = D.pid AND\n\t\t\t\t\t\t\t\t\tlength(D.depth) = length(B.depth) + 1 AND\n\t\t\t\t\t\t\t\t\tlocate(B.depth, D.depth) = 1\n\t\t\t\t\t\t\tWHERE B.uid = ? #parent uid -> as a role of fid\n\t\t\t\t\t\t\tORDER BY D.depth DESC LIMIT 1\n\t\t\t\t\t) P");
$stmt->bind_param("sssd", $id, $title, $content, $uid);
$stmt->execute();
$result = getResult($stmt);
echo "\t<result>" . $result . "</result>\n";
echo "</board>";
$stmt->close();
$mysqli->close();