/** * 增加一条feed * @param $ArrData 表单内容 * @param $StrTag tags */ function AddFeed($ArrData, $StrTag) { $ArrData = $this->ArrRebuild($ArrData); $query = 'INSERT INTO .`feeds` (' . $ArrData['key'] . ') VALUES (' . $ArrData['value'] . ');'; // print_r($query); $result = mysql_query($query, $this->ObDb) or die(mysql_error()); $result = mysql_query('SELECT LAST_INSERT_ID( )', $this->ObDb) or die(mysql_error()); $LastId = mysql_fetch_array($result); $LastId = $LastId[0]; $StrTag = spliti(',', $StrTag); $ArrTag = array(); foreach ($StrTag as $value) { !in_array($value, $ArrTag) ? $ArrTag[] = $value : true; } foreach ($ArrTag as $value) { if (trim($value)) { $Str .= "('{$LastId}' , '{$value}'),"; } } $Str = rtrim($Str, ','); $query = 'INSERT INTO `feeds-tags` (fid,tag) VALUES ' . $Str . ';'; // print_r($query); $result = mysql_query($query, $this->ObDb) or die(mysql_error()); return true; }
/** * Function returns the Query for the relationhips * @param <Vtiger_Record_Model> $recordModel * @param type $actions * @return <String> */ public function getQuery($recordModel, $actions = false) { $parentModuleModel = $this->getParentModuleModel(); $relatedModuleModel = $this->getRelationModuleModel(); $relatedModuleName = $relatedModuleModel->get('name'); $parentModuleName = $parentModuleModel->get('name'); $functionName = $this->get('name'); $focus = CRMEntity::getInstance($parentModuleName); $focus->id = $recordModel->getId(); if (method_exists($parentModuleModel, $functionName)) { $query = $parentModuleModel->{$functionName}($recordModel, $relatedModuleModel); } else { $result = $focus->{$functionName}($recordModel->getId(), $parentModuleModel->getId(), $relatedModuleModel->getId(), $actions); $query = $result['query']; } //modify query if any module has summary fields, those fields we are displayed in related list of that module $relatedListFields = $relatedModuleModel->getConfigureRelatedListFields(); if (count($relatedListFields) > 0) { $currentUser = Users_Record_Model::getCurrentUserModel(); $queryGenerator = new QueryGenerator($relatedModuleName, $currentUser); $queryGenerator->setFields($relatedListFields); $selectColumnSql = $queryGenerator->getSelectClauseColumnSQL(); $newQuery = spliti('FROM', $query); $selectColumnSql = 'SELECT DISTINCT vtiger_crmentity.crmid,' . $selectColumnSql; } if ($functionName == ('get_pricebook_products' || 'get_pricebook_services')) { $selectColumnSql = $selectColumnSql . ', vtiger_pricebookproductrel.listprice'; } $query = $selectColumnSql . ' FROM ' . $newQuery[1]; return $query; }
function efGroupPortal_MediaWikiPerformAction($output, $article, $title, $user, $request) { $action = $request->getVal('action', 'view'); $redirect = $request->getVal('redirect'); if ($action === 'view' && $redirect === null) { if ($title->equals(Title::newMainPage())) { $groupPortals = spliti("\n", wfMsgForContentNoTrans('groupportal')); $groups = $user->getGroups(); $targetPortal = ''; foreach ($groupPortals as $groupPortal) { $mcount = preg_match('/^(.+)\\|(.+)$/', $groupPortal, $matches); if ($mcount > 0) { if (in_array($matches[1], $groups) || $matches[1] == '*' && empty($targetPortal)) { $targetPortal = $matches[2]; } } } if (!empty($targetPortal)) { $target = Title::newFromText($targetPortal); if (is_object($target)) { $output->redirect($target->getLocalURL()); return false; } } } } return true; }
function parsePlaylist($txt, $type = false) { $txt = explode("\n", $txt); // trim will remove the \r $res = array(); if ($type == "pls" || $type === false) { foreach ($txt as $t) { $t = trim($t); if (stripos($t, "file") !== false) { $pos = spliti("^file[0-9]*=", $t); if (count($pos) == 2 && strlen($pos[1]) > 0) { $res[] = $pos[1]; } } } } else { if ($type == "m3u" || $type === false && count($res) == 0) { foreach ($txt as $t) { $t = trim($t); if (strpos($t, "#") !== false || strlen($t) == 0) { echo "skipping: {$t}\n"; continue; } $res[] = $t; } } } return $res; }
/** * Function to get list view query for popup window * @param <String> $sourceModule Parent module * @param <String> $field parent fieldname * @param <Integer> $record parent id * @param <String> $listQuery * @return <String> Listview Query */ public function getQueryByModuleField($sourceModule, $field, $record, $listQuery) { if (in_array($sourceModule, array('Leads', 'Accounts', 'Contacts'))) { switch ($sourceModule) { case 'Leads': $tableName = 'vtiger_campaignleadrel'; $relatedFieldName = 'leadid'; break; case 'Accounts': $tableName = 'vtiger_campaignaccountrel'; $relatedFieldName = 'accountid'; break; case 'Contacts': $tableName = 'vtiger_campaigncontrel'; $relatedFieldName = 'contactid'; break; } $condition = " vtiger_campaign.campaignid NOT IN (SELECT campaignid FROM {$tableName} WHERE {$relatedFieldName} = '{$record}')"; $pos = stripos($listQuery, 'where'); if ($pos) { $split = spliti('where', $listQuery); $overRideQuery = $split[0] . ' WHERE ' . $split[1] . ' AND ' . $condition; } else { $overRideQuery = $listQuery . ' WHERE ' . $condition; } return $overRideQuery; } }
public function getQueryByModuleField($sourceModule, $field, $record, $listQuery) { $bmqdivx = "sourceModule"; $zlolzuy = "sourceModule"; ${${"GLOBALS"}["qrqojbhxesaz"]} = array("Leads", "Accounts", "HelpDesk", "Potentials"); if (${$bmqdivx} == "PriceBooks" && ${${"GLOBALS"}["tebjrruj"]} == "priceBookRelatedList" || in_array(${$zlolzuy}, ${${"GLOBALS"}["qrqojbhxesaz"]}) || in_array(${${"GLOBALS"}["smtqzdj"]}, getInventoryModules())) { ${${"GLOBALS"}["vdridpr"]} = " vtiger_service.discontinued = 1 "; $csusxhsru = "field"; $hxsdmdnrcwm = "sourceModule"; $hxnvgeuqzxj = "supportedModulesList"; if (${$hxsdmdnrcwm} == "PriceBooks" && ${$csusxhsru} == "priceBookRelatedList") { ${${"GLOBALS"}["vdridpr"]} .= " AND vtiger_service.serviceid NOT IN (SELECT productid FROM vtiger_pricebookproductrel WHERE pricebookid = '{$record}') "; } elseif (in_array(${${"GLOBALS"}["smtqzdj"]}, ${$hxnvgeuqzxj})) { $hcfqbvtwpxs = "condition"; ${$hcfqbvtwpxs} .= " AND vtiger_service.serviceid NOT IN (SELECT relcrmid FROM vtiger_crmentityrel WHERE crmid = '{$record}' UNION SELECT crmid FROM vtiger_crmentityrel WHERE relcrmid = '{$record}') "; } ${${"GLOBALS"}["myxgfagm"]} = stripos(${${"GLOBALS"}["texkhgc"]}, "where"); if (${${"GLOBALS"}["myxgfagm"]}) { ${"GLOBALS"}["jstyvedywb"] = "overRideQuery"; ${"GLOBALS"}["duyhsdq"] = "split"; ${"GLOBALS"}["tarygvij"] = "condition"; $ahusbk = "listQuery"; $lxqmuyuxd = "split"; ${${"GLOBALS"}["duyhsdq"]} = spliti("where", ${$ahusbk}); ${${"GLOBALS"}["jstyvedywb"]} = ${${"GLOBALS"}["wdrbrwcxv"]}[0] . " WHERE " . ${$lxqmuyuxd}[1] . " AND " . ${${"GLOBALS"}["tarygvij"]}; } else { $arzttzsxki = "overRideQuery"; ${$arzttzsxki} = ${${"GLOBALS"}["texkhgc"]} . " WHERE " . ${${"GLOBALS"}["vdridpr"]}; } return ${${"GLOBALS"}["mvklfvtelnt"]}; } }
function PHPruDirs() { global $HOME_DIR, $STOP_DIR, $STOP_FILE, $CONFIG, $input, $sizetotal; $dir = opendir('.'); $ff = readdir($dir); while ($ff != '') { $flag = 0; if (is_dir($ff)) { foreach($STOP_DIR as $VALUE) { if (strtolower($ff) == strtolower(trim($VALUE))) $flag = 1; } if (($ff != '.') && ($ff != '..') && ($flag != 1)) { chdir($ff); PHPruDirs(); chdir('..'); } } $ff = readdir($dir); if ($ff != '..' && !is_dir($ff)) { $hlam = str_replace($STOP_FILE, "!", $ff); if ($hlam != $ff) continue; else { $NOW_DIR = getcwd(); $LINK = str_replace($HOME_DIR, trim($CONFIG[0]), $NOW_DIR); $LINK = str_replace('\\', '/', $LINK); $mtime = date("d.m.Yг.",filemtime($ff)); $size = round(filesize($ff)/1024); $sizetotal += $size; $ff = trim($ff); $FILE = file($ff); $text = implode(' ',$FILE); unset ($FIND); if($CONFIG[3] == 1) { @list($start,$end) = spliti('</TITLE>',$text,2); @list($recycle,$FIND) = spliti('<TITLE>',$start,2); } if (!isset($FIND)) $FIND = $LINK.'/'.$ff; $clear = PHPruClear($text); $text = wordwrap ($clear, 100, "%^%"); $input .= '<A HREF=\''.$LINK.'/'.$ff.'\' TARGET=_new>'.$FIND.'</A>'; $input .= '^!^'.$size.'^!^'.$text.'^!^'.$mtime."\r\n"; } } } closedir($dir); }
/** * Function to get list view query for popup window * @param <String> $sourceModule Parent module * @param <String> $field parent fieldname * @param <Integer> $record parent id * @param <String> $listQuery * @return <String> Listview Query */ public function getQueryByModuleField($sourceModule, $field, $record, $listQuery) { if ($sourceModule === 'Emails' && $field === 'composeEmail') { $condition = ' (( vtiger_notes.filelocationtype LIKE "%I%")) AND vtiger_notes.filename != "" AND vtiger_notes.filestatus = 1'; } else { $condition = " vtiger_notes.notesid NOT IN (SELECT notesid FROM vtiger_senotesrel WHERE crmid = '{$record}') AND vtiger_notes.filestatus = 1"; } $pos = stripos($listQuery, 'where'); if ($pos) { $split = spliti('where', $listQuery); $overRideQuery = $split[0] . ' WHERE ' . $split[1] . ' AND ' . $condition; } else { $overRideQuery = $listQuery . ' WHERE ' . $condition; } return $overRideQuery; }
/** * Function to get list view query for popup window * @param <String> $sourceModule Parent module * @param <String> $field parent fieldname * @param <Integer> $record parent id * @param <String> $listQuery * @return <String> Listview Query */ public function getQueryByModuleField($sourceModule, $field, $record, $listQuery, $currencyId = false) { $relatedModulesList = array('Products', 'Services'); if (in_array($sourceModule, $relatedModulesList)) { $pos = stripos($listQuery, ' where '); if ($currencyId && in_array($field, array('productid', 'serviceid'))) { $condition = " vtiger_pricebook.pricebookid IN (SELECT pricebookid FROM vtiger_pricebookproductrel WHERE productid = {$record})\n\t\t\t\t\t\t\t\tAND vtiger_pricebook.currency_id = {$currencyId} AND vtiger_pricebook.active = 1"; if ($pos) { $split = spliti(' where ', $listQuery); $overRideQuery = $split[0] . ' WHERE ' . $split[1] . ' AND ' . $condition; } else { $overRideQuery = $listQuery . ' WHERE ' . $condition; } } return $overRideQuery; } }
/** * Smarty plugin * ------------------------------------------------------------- * File: block.sortlinks.php * Type: block * Name: sortlinks * ------------------------------------------------------------- */ function smarty_block_sortlinks($params, $content, &$gBitSmarty) { if ($content) { $links = spliti("\n", $content); $links2 = array(); foreach ($links as $value) { $splitted = preg_split("/[<>]/", $value, -1, PREG_SPLIT_NO_EMPTY); $links2[$splitted[2]] = $value; } if (isset($params['order']) && $params['order'] == 'reverse') { krsort($links2); } else { ksort($links2); } foreach ($links2 as $value) { echo $value; } } }
/** * INIT DIRECTORY. * @param: none */ private function initdirectory() { # no need to urldecode => $_GET already do this! if (isset($_GET['p']) && $_GET['p'] != '') { $url = $_GET['p']; $tabParams = spliti($this->slash, $url); $this->url_params = $tabParams; } else { $this->url_params = NULL; } # get params from url $directory = $this->userDataPath; if (!empty($this->url_params)) { foreach ($this->url_params as $id) { $directory .= $id . $this->slash; } } $this->absoluteDirectoryPath = $directory; }
/** * Reply to the operation. * @param $event event that triggered the operation. * @return BotMessage with magic 8's answer. */ public function reply(BotEvent $event) { $sender = $event->getSender(); $message = $event->getMessage(); if (preg_match("/([^\\s]+)\\s+ou\\s+([^\\s?]+)/i", $message)) { $responses = spliti(" ou ", $message); } else { $responses = $this->responses; } $response = mt_rand(0, count($responses) - 1); $reply = $responses[$response]; $reply = trim(str_replace("?", "", $reply)); if ($event->isPrivate()) { $destination = $sender; } else { $reply = "{$sender}: {$reply}"; $destination = $event->getDestination(); } return new BotMessage($destination, $reply); }
/** * Function to get list view query for popup window * @param <String> $sourceModule Parent module * @param <String> $field parent fieldname * @param <Integer> $record parent id * @param <String> $listQuery * @return <String> Listview Query */ public function getQueryByModuleField($sourceModule, $field, $record, $listQuery) { $supportedModulesList = array('Leads', 'Accounts', 'HelpDesk', 'Potentials'); if ($sourceModule == 'PriceBooks' && $field == 'priceBookRelatedList' || in_array($sourceModule, $supportedModulesList) || in_array($sourceModule, getInventoryModules())) { $condition = " vtiger_service.discontinued = 1 "; if ($sourceModule == 'PriceBooks' && $field == 'priceBookRelatedList') { $condition .= " AND vtiger_service.serviceid NOT IN (SELECT productid FROM vtiger_pricebookproductrel WHERE pricebookid = '{$record}') "; } elseif (in_array($sourceModule, $supportedModulesList)) { $condition .= " AND vtiger_service.serviceid NOT IN (SELECT relcrmid FROM vtiger_crmentityrel WHERE crmid = '{$record}' UNION SELECT crmid FROM vtiger_crmentityrel WHERE relcrmid = '{$record}') "; } $pos = stripos($listQuery, 'where'); if ($pos) { $split = spliti('where', $listQuery); $overRideQuery = $split[0] . ' WHERE ' . $split[1] . ' AND ' . $condition; } else { $overRideQuery = $listQuery . ' WHERE ' . $condition; } return $overRideQuery; } }
function html2cell($html) { #Parse what's inside the table in $html into a nice PHP array #Helena F Deus if (eregi('<TABLE>(.*)</TABLE>', $html, $table_contents)) { #parse teh lines if (eregi('<TR>(.*)</TR>', $table_contents[1], $row_contents)) { #$row = explode('<TR>', $row_contents[0]); $row = spliti('<TR>', $row_contents[0]); $row = array_filter($row); #explode has this annoying habit of adding empty values foreach ($row as $rowi => $a_row) { #remove </tr> $a_row = str_ireplace('</TR>', '', $a_row); #parse teh cells if (eregi('<TD>(.*)</TD>', $a_row, $cell_contents)) { $cells[$rowi] = spliti('<TD>', $cell_contents[1]); #remove emptyes $cells[$rowi] = array_filter($cells[$rowi]); #remove the /td $cells[$rowi] = array_filter($cells[$rowi]); foreach ($cells[$rowi] as $col => $a_cell) { $a_cell = str_ireplace('</TD>', '', $a_cell); $cells[$rowi][$col] = $a_cell; if ($rowi > 1) { $cells[$rowi][trim($cells[1][$col])] = $a_cell; } } } else { return 'No cells'; } } } else { return 'No rows'; } } else { 'No html tables found'; } return $cells; }
function wmv_bot($url, $ext) { foreach (url_bot($url) as $url) { $file = file($url); $file[-1] = ""; $file = implode("\n", $file); $file = spliti("http://", $file); //print_r($file); $urlz[-1] = ""; $i = 0; foreach ($file as $url) { $url = explode(">", $url); $url = $url[0]; if (eregi(".com", $url) && eregi($ext, $url) && !eregi(" |\"", $url)) { $urlz[$i] = "http://" . $url; $i++; } } print_r($urlz); } return $urlz; }
/** * Function to get the list view entries * @param Vtiger_Paging_Model $pagingModel * @return <Array> - Associative array of record id mapped to Vtiger_Record_Model instance. */ public function getListViewCount() { $db = PearDatabase::getInstance(); $queryGenerator = $this->get('query_generator'); $listQuery = $queryGenerator->getQuery(); $listQuery = preg_replace("/vtiger_crmentity.deleted\\s*=\\s*0/i", 'vtiger_crmentity.deleted = 1', $listQuery); $position = stripos($listQuery, 'from'); if ($position) { $split = spliti('from', $listQuery); $splitCount = count($split); $listQuery = 'SELECT count(*) AS count '; for ($i = 1; $i < $splitCount; $i++) { $listQuery = $listQuery . ' FROM ' . $split[$i]; } } if ($this->getModule()->get('name') == 'Calendar') { $listQuery .= ' AND activitytype <> "Emails"'; } $listResult = $db->pquery($listQuery, array()); $listViewCount = $db->query_result($listResult, 0, 'count'); return $listViewCount; }
/** * Function to get list view query for popup window * @param <String> $sourceModule Parent module * @param <String> $field parent fieldname * @param <Integer> $record parent id * @param <String> $listQuery * @return <String> Listview Query */ public function getQueryByModuleField($sourceModule, $field, $record, $listQuery) { $supportedModulesList = array($this->getName(), 'Vendors', 'Leads', 'Accounts', 'Contacts', 'Potentials'); if ($sourceModule == 'PriceBooks' && $field == 'priceBookRelatedList' || in_array($sourceModule, $supportedModulesList) || in_array($sourceModule, getInventoryModules())) { $condition = " vtiger_products.discontinued = 1 "; if ($sourceModule === $this->getName()) { $condition .= " AND vtiger_products.productid NOT IN (SELECT productid FROM vtiger_seproductsrel UNION SELECT crmid FROM vtiger_seproductsrel WHERE productid = '{$record}') AND vtiger_products.productid <> '{$record}' "; } elseif ($sourceModule === 'PriceBooks') { $condition .= " AND vtiger_products.productid NOT IN (SELECT productid FROM vtiger_pricebookproductrel WHERE pricebookid = '{$record}') "; } elseif ($sourceModule === 'Vendors') { $condition .= " AND vtiger_products.vendor_id != '{$record}' "; } elseif (in_array($sourceModule, $supportedModulesList)) { $condition .= " AND vtiger_products.productid NOT IN (SELECT productid FROM vtiger_seproductsrel WHERE crmid = '{$record}')"; } $pos = stripos($listQuery, 'where'); if ($pos) { $split = spliti('where', $listQuery); $overRideQuery = $split[0] . ' WHERE ' . $split[1] . ' AND ' . $condition; } else { $overRideQuery = $listQuery . ' WHERE ' . $condition; } return $overRideQuery; } }
/** * Function to get list view query for popup window * @param <String> $sourceModule Parent module * @param <String> $field parent fieldname * @param <Integer> $record parent id * @param <String> $listQuery * @return <String> Listview Query */ public function getQueryByModuleField($sourceModule, $field, $record, $listQuery) { if ($sourceModule == 'Accounts' && $field == 'account_id' && $record || in_array($sourceModule, array('Campaigns', 'Products', 'Services', 'Emails'))) { if ($sourceModule === 'Campaigns') { $condition = " vtiger_account.accountid NOT IN (SELECT accountid FROM vtiger_campaignaccountrel WHERE campaignid = '{$record}')"; } elseif ($sourceModule === 'Products') { $condition = " vtiger_account.accountid NOT IN (SELECT crmid FROM vtiger_seproductsrel WHERE productid = '{$record}')"; } elseif ($sourceModule === 'Services') { $condition = " vtiger_account.accountid NOT IN (SELECT relcrmid FROM vtiger_crmentityrel WHERE crmid = '{$record}' UNION SELECT crmid FROM vtiger_crmentityrel WHERE relcrmid = '{$record}') "; } elseif ($sourceModule === 'Emails') { $condition = ' vtiger_account.emailoptout = 0'; } else { $condition = " vtiger_account.accountid != '{$record}'"; } $position = stripos($listQuery, 'where'); if ($position) { $split = spliti('where', $listQuery); $overRideQuery = $split[0] . ' WHERE ' . $split[1] . ' AND ' . $condition; } else { $overRideQuery = $listQuery . ' WHERE ' . $condition; } return $overRideQuery; } }
/** * Function returns export query * @param <String> $where * @return <String> export query */ public function getExportQuery($focus, $query) { $baseTableName = $focus->table_name; $splitQuery = spliti(' FROM ', $query); $columnFields = explode(',', $splitQuery[0]); foreach ($columnFields as $key => &$value) { if ($value == ' vtiger_inventoryproductrel.discount_amount') { $value = ' vtiger_inventoryproductrel.discount_amount AS item_discount_amount'; } else { if ($value == ' vtiger_inventoryproductrel.discount_percent') { $value = ' vtiger_inventoryproductrel.discount_percent AS item_discount_percent'; } else { if ($value == " {$baseTableName}.currency_id") { $value = ' vtiger_currency_info.currency_name AS currency_id'; } } } } $joinSplit = spliti(' WHERE ', $splitQuery[1]); $joinSplit[0] .= " LEFT JOIN vtiger_currency_info ON vtiger_currency_info.id = {$baseTableName}.currency_id"; $splitQuery[1] = $joinSplit[0] . ' WHERE ' . $joinSplit[1]; $query = implode(',', $columnFields) . ' FROM ' . $splitQuery[1]; return $query; }
function line($head, $textok, $info, $running, $notonload, $command) { $host = "127.0.0.1"; $timeout = "1"; global $i, $TEXT; $curdir = getcwd(); list($partwampp, $directorwampp) = spliti('\\\\security', $curdir); $htaccess = ".htaccess"; $configinc = "config.inc.php"; $notrun = 0; $status = 0; $notload = 0; $newstatus = "nok"; global $htxampp; global $phpmyadminconf; $htxampp = $partwampp . "\\htdocs\\xampp\\" . $htaccess; $phpmyadminconf = $partwampp . "\\phpmyadmin\\" . $configinc; if ($command == "phpmyadmin") { if (file_exists($phpmyadminconf)) { $datei = fopen($phpmyadminconf, 'r'); $status = 1; while (!feof($datei)) { $zeile = fgets($datei, 255); @(list($left, $right) = split('=', $zeile)); if (preg_match("/'auth_type'/i", $left)) { if (preg_match("/'http'/i", $right)) { $newstatus = "ok"; } elseif (preg_match("/'cookie'/i", $right)) { $newstatus = "ok"; } if ($newstatus == "ok") { $status = 0; } else { $status = 1; } } } fclose($datei); } else { $notrun = 1; } } if ($command == "mysqlroot") { if (($handle = @fsockopen($host, 3306, $errno, $errstr, $timeout)) == true) { @fclose($handle); if (@mysql_connect($host, "root", "")) { $status = 1; } else { $status = 0; } } else { $notrun = 1; } } if ($command == "xampp") { if (file_exists($htxampp)) { $status = 0; } else { $status = 1; } } if ($command == "php") { if (ini_get('safe_mode')) { $status = 0; } else { $status = 1; } } if ($command == "ftp") { if (($handle = @fsockopen($host, 21, $errno, $errstr, $timeout)) == true) { @fclose($handle); $conn_id = ftp_connect("127.0.0.1"); $login_result = @ftp_login($conn_id, "newuser", "wampp"); if (!$conn_id || !$login_result) { $status = 0; } else { $status = 1; ftp_quit($conn_id); } } else { $notrun = 1; } } if (extension_loaded("imap")) { if ($command == "pop") { if (($handle = @fsockopen($host, 110, $errno, $errstr, $timeout)) == true) { @fclose($handle); if ($mbox = @imap_open("{localhost/pop3:110}INBOX", "newuser", "wampp")) { $status = 1; imap_close($mbox); } else { $status = 0; } } else { $notrun = 1; } } } else { $notload = 1; } if ($i > 0) { echo "<tr valign='bottom'>"; echo "<td bgcolor='#ffffff' height='1' style='background-image:url(img/strichel.gif)' colspan='4'></td>"; echo "</tr>"; } echo "<tr bgcolor='#ffffff' valign='middle'><td><img src='img/blank.gif' alt='' width='1' height='20'></td><td class='tabval'>"; if ($notload == 1) { echo $notonload; } if ($status == 0 && ($notrun == "" || $notrun < 1)) { echo $textok; } elseif ($notrun == 1) { echo $running; } else { echo $head; } echo "</td>"; if ($status == 0 && $notrun != 1) { echo "<td> <span class='green'> " . $TEXT['security-ok'] . " </span></td>"; } elseif ($status == 1) { echo "<td> <span class='red'> " . $TEXT['security-nok'] . " </span></td>"; } elseif ($notrun == 1) { echo "<td> <span class='yellow'> " . $TEXT['security-noidea'] . " </span></td>"; } else { echo "<td> <span class='yellow'> " . $TEXT['security-noidea'] . " </span></td>"; } echo "<td> </td></tr>"; if ($notrun == 1) { echo "<tr bgcolor='#ffffff'><td></td><td colspan='1' class='small'>{$running}<br><img src='img/blank.gif' alt='' width='10' height='10' border='0'></td><td></td><td></td></tr>"; } elseif ($status) { echo "<tr bgcolor='#ffffff'><td></td><td colspan='1' class='small'>{$info}<br><img src='img/blank.gif' alt='' width='10' height='10' border='0'></td><td></td><td></td></tr>"; } $i++; }
/** * Created by PhpStorm. * User: pagrawal * Date: 10/12/15 * Time: 3:23 PM */ $host = '127.0.0.1'; $user = '******'; $password = ''; $link = mysql_connect($host, $user, $password) or die('Error'); //var_dump($link); mysql_select_db('chat') or die('Database Error'); header("Content-Type: text/xml"); $path = $_SERVER['PATH_INFO']; if ($path != null) { $path_params = spliti("/", $path); } if ($_SERVER['REQUEST_METHOD'] == 'GET') { if ($path_params[1] != null) { settype($path_params[1], 'integer'); $query = 'SELECT name, author, isbn FROM book where id = $path_params[1]'; } else { $query = 'SELECT name, author, isbn FROM book'; } $result = mysql_query($query) or die('Query Failed' . mysql_error()); echo "<books>"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "<book>"; foreach ($line as $key => $col_value) { echo "<key>{$col_value}</key>"; }
/** * This function is used to filter the post content * and replace particulars tags with the right sobstitution code * NOTE: * [[Image:image/name.ext|align|width|height|Caption or description]] * | 0 | 1 | 2 | 3 | 4 | * words[]: * [0] image file (path) Obligatory * [1] alignment * [2] width * [3] height * [4] caption */ function parse_posts_for_images($content) { global $wpdb, $post, $gallery_root, $gallery_address; // Check if in the post there are [[image]]'s tags, if not content is returned else it is processed if (strpos(strtolower($content), "[[image") === false || strpos(strtolower($content), "<code>[[image") == true) { return $content; } else { $gallery_uri = get_option('lg_gallery_uri'); // Fix for permalinks if (strlen(get_option('permalink_structure')) != 0) { $gallery_uri = $gallery_uri . '?'; } else { $gallery_uri = $gallery_uri . '&'; } $imagedata = array(); $posstags = spliti("\\[\\[Image:", $content); $new_content = $content; // Search for tags for ($i = 0; $i <= count($posstags); $i++) { $smartlink = array(); eregi('([^\\[]*)\\]\\]', $posstags[$i], $smartlink); if (strlen($smartlink[1]) > 0) { $imagedata[] = $smartlink[1]; } } // Process tags foreach ($imagedata as $imgdata) { $folder = ""; if (isset($imgdata)) { if (strpos($content, $imgdata) === false) { return $content; } $words = explode("|", $imgdata); // Trimming spaces for ($i = 0; $i < count($words); $i++) { $words[$i] = trim($words[$i]); } // extracts the image from the array $words = array_reverse($words); $image = array_pop($words); $width = ''; $height = ''; $align = array("center", "left", "right"); $done = false; $alt = ''; // assigning the right values foreach ($words as $key) { if (is_numeric($key) && $width == '') { $width = $key; } else { if (is_numeric($key) && $height == '') { $height = $key; } else { if (!$done && in_array($key, $align)) { $align = $key; $done = true; } else { $alt = $key; } } } } if ($width == '') { $height = get_option('lg_thumbheight'); $width = get_option('lg_thumbwidth'); } else { if ($height == '') { $height = $width; } } // Fixing CSS issues if ($align == "center") { $center_style = "margin:auto !important;"; } $thumb_width = "width:" . ($width + 2) . "px;"; // End of CSS issue /* ======================== * Sobstitution code header * ======================== */ $url = "<div class='thumb t{$align}'>\r\n\t\t\t\t\t\t\t<div style='{$thumb_width}{$center_style}' >"; /* =========================== * Gathering misc informations * =========================== */ $img = basename($image); $folder = str_replace($img, "", $image); $title = $alt; if (strlen($title) == 0) { $caption = clean_image_caption($img, $folder); $title = ereg_replace("<[^>]*>", "", $caption); } $xhtml_url = str_replace(" ", "%20", $image); // Cache System code (used for lightbox) $slide_folder = get_option('lg_slide_folder'); if (file_exists($gallery_root . $folder . $img)) { if (!file_exists($gallery_root . $folder . $slide_folder . $img) && strlen($image) > 0) { // Not thumb = false createCache($folder, $img, false); } } $urlImg = str_replace(" ", "%20", $gallery_address . $folder . $slide_folder . $img); /* ============= * The Right URL * ============= */ // Lightbox Informations $lb_enabled = get_option('lg_enable_lb_support'); $lb_posts = get_option('lg_enable_lb_posts_support'); $lb_force = get_option('lg_force_lb_support'); // Thickbox informations $tb_enabled = get_option('lg_enable_tb_support'); $tb_posts = get_option('lg_enable_tb_posts_support'); $tb_force = get_option('lg_force_tb_support'); // Slides' cache infos $lg_scache = get_option('lg_enable_slides_cache'); // Lightbox code if ($lb_enabled == "TRUE" && $lb_posts == "TRUE" && $lg_scache == "TRUE" && some_lightbox_plugin() || $lb_force == "TRUE") { $url .= "<a href='{$urlImg}' rel='lightbox' title='{$title}' class='internal'>"; } elseif ($tb_enabled == "TRUE" && $tb_posts == "TRUE" && $lg_scache == "TRUE" && some_thickbox_plugin() || $tb_force == "TRUE") { $url .= "<a href='{$urlImg}' class='thickbox' title='{$title}'>"; } else { $url .= "<a href='{$gallery_uri}" . "file={$xhtml_url}' class='internal'>"; } /* ================ * End of Right URL * ================ */ /* ======================== * Sobstitution code footer * ======================== */ $url .= "<img src='" . get_option('siteurl') . "/wp-content/plugins/lazyest-gallery/lazyest-thumbnailer.php?file={$xhtml_url}&height={$height}&width={$width}' alt='{$alt}'/>\r\n\t\t\t\t\t\t\t\t</a>\r\n\t\t\t\t\t\t\t\t<div class='thumbcaption'>\r\n\t\t\t\t\t\t\t\t\t<div class='gallerylink' style='float:right'><a href='{$gallery_uri}" . "file={$xhtml_url}' class='internal' >\r\n\t\t\t\t\t\t\t\t\t\t<img src='" . get_option('siteurl') . "/wp-content/plugins/lazyest-gallery/images/magnify-clip.png' alt='' />\r\n\t\t\t\t\t\t\t\t\t</a></div>\r\n\t\t\t\t\t\t\t\t\t{$title}\r\n\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t</div>"; if (phpversion() >= 5) { $new_content = str_ireplace("[[image:" . $imgdata . "]]", $url, $new_content); } else { $new_content = str_replace("[[Image:" . $imgdata . "]]", $url, $new_content); } } } return $new_content; } }
if ($riga->FKEY == "SesName") { $data['SesName'] = $riga->VALUE; } } if (!$_REQUEST['edit']) { layout($data); die; } else { $postdata['bsession'] = $_REQUEST['bsession']; $postdata['bind'] = $_REQUEST['bind']; $postdata['bport'] = $_REQUEST['bport']; $postdata['directory'] = $_REQUEST['directory']; UpdateDb($postdata, $data); // sovrascrivo chkdir.bat in modo da forzare una autoconfigurazione al prossimo avvio $curdir = getcwd(); list($phpdir, $installdir) = spliti('\\\\WEBSERVER\\\\HTTPD\\\\setup', $curdir); $apachedir = ereg_replace("\\\\", "/", $phpdir); $filename = "{$apachedir}/COMMON/script/chkdir.bat"; $chkdir = "@echo off\r\n\t\tECHO DIRECTORY CHECK\r\n\t\tIF EXIST \"{$phpdir}\\WEBSERVER\\Apache\\conf\fakefile.null\" GOTO fine\r\n\t\tECHO KEYFORUM NEEDS CONFIGURATION\r\n\t\tECHO;\r\n\t\tinstall_keyforum.bat\r\n\t\t:fine\r\n\t\tECHO OK\r\n\t\tECHO;\r\n\t\t"; $handle = fopen($filename, 'w'); fwrite($handle, $chkdir); fclose($handle); echo "<CENTER><b><H3>Board {$_REQUEST['ws']} " . $lang['mngws_updated'] . "</H3></b>"; echo "<font color=red><b><H3>" . $lang['mngws_reboot'] . "</H3></b></font><br><br></center></body></html>"; } } function layoutws($data = array()) { if (!$_REQUEST['lang']) { $blanguage = GetUserLanguage(); } else {
<?php if ($language == 'ru' || $language == 'ua' || $language == 'be' || $language == 'en' || $language == 'de') { } else { $language = 'ru'; } $lang = parse_ini_file("application/lang/" . $language . ".ini"); $rout = spliti('/', $_SERVER['REQUEST_URI'], 3); if (isset($message)) { echo "\n\t\t<script type='text/javascript'>\n\t\t\talert('" . $message . "');\n\t\t</script>\n\t"; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Тест</title> <meta http-equiv="Content-Type" content="charset=UTF-8"/> <link rel="stylesheet" type="text/css" href="/css/style.css"/> <script type="text/javascript" src="/js/jquery.js"></script> <script type="text/javascript"> $(document).ready(function(){ $("#showPortfolio").click(function(){ $("#portfolio").animate({width:"1024px", opacity:"1"}, 800); }); }); </script> </head> <body> <div id="container">
/** * Takes a string representation of a file path (eg. 'path/to/file.ext') and * returns that path minus the filename as an array (eg. array('path', 'to') ). * * @param $mixedPath a string representation of a file path. * @return array of strings representing directory paths. */ function getPathArray($mixedPath) { $toReturn = array(); $matchResult = preg_match('/^[\\\\|\\/]+/', $mixedPath); if ($matchResult != 0) { $toReturn[] = DS; // add / or \ to beginning of path if that is intended. } $splitPath = spliti('[/\\]', $mixedPath); for ($i = 0; $i < count($splitPath) - 1; ++$i) { $toReturn[] = $splitPath[$i]; // add all the directories minus the filename. } return $toReturn; }
function test_spliti() { $str = "aBBBaCCCADDDaEEEaGGGA"; $chunks = spliti("a", $str, 5); VS($chunks[0], ""); VS($chunks[1], "BBB"); VS($chunks[2], "CCC"); VS($chunks[3], "DDD"); VS($chunks[4], "EEEaGGGA"); }
/** * Function to get relation query for particular module with function name * @param <record> $recordId * @param <String> $functionName * @param Vtiger_Module_Model $relatedModule * @return <String> */ public function getRelationQuery($recordId, $functionName, $relatedModule) { $relatedModuleName = $relatedModule->getName(); $focus = CRMEntity::getInstance($this->getName()); $focus->id = $recordId; $result = $focus->{$functionName}($recordId, $this->getId(), $relatedModule->getId()); $query = $result['query'] . ' ' . $this->getSpecificRelationQuery($relatedModuleName); $nonAdminQuery = $this->getNonAdminAccessControlQueryForRelation($relatedModuleName); //modify query if any module has summary fields, those fields we are displayed in related list of that module $relatedListFields = $relatedModule->getConfigureRelatedListFields(); if ($relatedModuleName == 'Documents') { $relatedListFields['filelocationtype'] = 'filelocationtype'; $relatedListFields['filestatus'] = 'filestatus'; } if (count($relatedListFields) > 0) { $currentUser = Users_Record_Model::getCurrentUserModel(); $queryGenerator = new QueryGenerator($relatedModuleName, $currentUser); $queryGenerator->setFields($relatedListFields); $selectColumnSql = $queryGenerator->getSelectClauseColumnSQL(); $newQuery = spliti('FROM', $query); $selectColumnSql = 'SELECT DISTINCT vtiger_crmentity.crmid,' . $selectColumnSql; $query = $selectColumnSql . ' FROM ' . $newQuery[1]; } if ($nonAdminQuery) { $query = appendFromClauseToQuery($query, $nonAdminQuery); } return $query; }
/** * Function to update relation query * @param <String> $relationQuery * @return <String> $updatedQuery */ public function updateQueryWithWhereCondition($relationQuery) { $condition = ''; $whereCondition = $this->get("whereCondition"); $count = count($whereCondition); if ($count > 1) { $appendAndCondition = true; } $i = 1; foreach ($whereCondition as $fieldName => $fieldValue) { $condition .= " {$fieldName} = '{$fieldValue}' "; if ($appendAndCondition && $i++ != $count) { $condition .= " AND "; } } $pos = stripos($relationQuery, 'where'); if ($pos) { $split = spliti('where', $relationQuery); $updatedQuery = $split[0] . ' WHERE ' . $split[1] . ' AND ' . $condition; } else { $updatedQuery = $relationQuery . ' WHERE ' . $condition; } return $updatedQuery; }
/** * Function to get the list view entries * @param Vtiger_Paging_Model $pagingModel * @return <Array> - Associative array of record id mapped to Vtiger_Record_Model instance. */ public function getListViewCount() { $db = PearDatabase::getInstance(); $queryGenerator = $this->get('query_generator'); $moduleName = $this->getModule()->get('name'); $moduleModel = Vtiger_Module_Model::getInstance($moduleName); $searchParams = $this->get('search_params'); if (empty($searchParams)) { $searchParams = array(); } $glue = ""; if (count($queryGenerator->getWhereFields()) > 0 && (count($searchParams)) > 0) { $glue = QueryGenerator::$AND; } $queryGenerator->parseAdvFilterList($searchParams, $glue); $searchKey = $this->get('search_key'); $searchValue = $this->get('search_value'); $operator = $this->get('operator'); if (!empty($searchKey)) { $queryGenerator->addUserSearchConditions(array('search_field' => $searchKey, 'search_text' => $searchValue, 'operator' => $operator)); } $listQuery = $this->getQuery(); $sourceModule = $this->get('src_module'); if (!empty($sourceModule)) { if (method_exists($moduleModel, 'getQueryByModuleField')) { $overrideQuery = $moduleModel->getQueryByModuleField($sourceModule, $this->get('src_field'), $this->get('src_record'), $listQuery, $this->get('currency_id')); if (!empty($overrideQuery)) { $listQuery = $overrideQuery; } } } $position = stripos($listQuery, ' from '); if ($position) { $split = spliti(' from ', $listQuery); $splitCount = count($split); $listQuery = 'SELECT count(*) AS count '; for ($i = 1; $i < $splitCount; $i++) { $listQuery = $listQuery . ' FROM ' . $split[$i]; } } if ($this->getModule()->get('name') == 'Calendar') { $listQuery .= ' AND activitytype <> "Emails"'; } $listResult = $db->pquery($listQuery, array()); return $db->query_result($listResult, 0, 'count'); }
/** * Function to get the list view entries * @param Vtiger_Paging_Model $pagingModel * @return <Array> - Associative array of record id mapped to Vtiger_Record_Model instance. */ public function getListViewCount() { $db = PearDatabase::getInstance(); $listQuery = $this->getQuery(); $position = stripos($listQuery, 'from'); if ($position) { $split = spliti('from', $listQuery); $splitCount = count($split); $listQuery = 'SELECT count(*) AS count '; for ($i = 1; $i < $splitCount; $i++) { $listQuery = $listQuery . ' FROM ' . $split[$i]; } } $searchKey = $this->get('search_key'); $searchValue = $this->get('search_value'); if (!empty($searchKey) && !empty($searchValue)) { $listQuery .= " WHERE {$searchKey} LIKE '{$searchValue}%'"; } $listResult = $db->pquery($listQuery, array()); return $db->query_result($listResult, 0, 'count'); }