'UTF-8',
'connection_timeout' => 5,
'exceptions' => 1,
);
$location = 'http://www.OpenLigaDB.de/Webservices/Sportsdata.asmx?WSDL';
try {
$client = new SoapClient( $location, $options );
$response = $client->{$endpoint}( $params );
// $response = $client->GetAvailSports();
} catch ( SoapFault $e ) {
die( $e->faultcode . ': ' . $e->faultstring );
} catch ( Exception $e ) {
die( $e->getCode() . ': ' . $e->getMessage() );
}
return $response;
}
function wpc_openligadbimport_cb() {
// get sql object
global $wpdb;
require( dirname( __FILE__ ) . '/globals.php' );
if ( ! empty( $_POST ) ) {
if ( ! isset( $_POST['wpc_nonce_oldbimport'] ) ) {
die( "
Looks like you didn't send any credentials. Please reload the page. " );
}
if ( ! wp_verify_nonce( $_POST['wpc_nonce_oldbimport'], 'wpc_nonce_oldbimport' ) ) {
die( "
Looks like you didn't send any credentials. Please reload the page. " );
}
$league = '';
if ( array_key_exists( 'league', $_POST ) ) {
$league = esc_attr( $_POST['league'] );
$leagueShortcut = substr( $league, 0, strpos( $league, ';' ) );
$leagueSaison = substr( $league, strpos( $league, ';' ) + 1 );
}
$csv_delall = false;
if ( array_key_exists( 'csv_delall', $_POST ) ) {
$csv_delall = ( esc_attr( $_POST['csv_delall'] ) == 'true' ? true : false );
}
// check if current data should be deleted
if ( $csv_delall === true ) {
$sql = "truncate table $cs_team;"; // this also resets the auto increment counter
$result = $wpdb->query( $sql );
$sql = "truncate table $cs_match;";
$result = $wpdb->query( $sql );
echo __( 'Data deleted.', 'wp-championship' ) . '
';
}
// hole OpenLigaDB Daten
$p = new stdClass();
$p->leagueSaison = $leagueSaison;
$p->leagueShortcut = $leagueShortcut;
// hole OpenLigaDB Teams
$resteam = do_soapcall( 'GetTeamsByLeagueSaison', $p );
// hole OpenLigaDB Matches
$resmatch = do_soapcall( 'GetMatchdataByLeagueSaison', $p );
// insert new data
foreach ( $resteam->GetTeamsByLeagueSaisonResult->Team as $t ) {
$sql = sprintf(
"insert into %s (tid,name,shortname,icon,groupid,qualified,penalty) values (%d,'%s', '', '%s','A',0,0);",
$cs_team,
intval( $t->teamID ),
esc_attr( $t->teamName ),
property_exists( $t, 'teamIconURL' ) ? sanitize_url( $t->teamIconURL ) : ''
);
$result = $wpdb->query( $sql );
if ( $result ) {
echo __( 'Teamrecord inserted successfully', 'wp-championship' ) . '.
';
} else {
echo __( 'Database error, record not inserted.', 'wp-championship' ) . '
';
}
}
foreach ( $resmatch->GetMatchdataByLeagueSaisonResult->Matchdata as $m ) {
$sql = sprintf(
"insert into %s (mid,round,spieltag,tid1,tid2,location,matchtime,result1,result2,winner,ptid1,ptid2)
values (%d,'V', %d, %d, %d, '','%s',-1,-1,-1,-1,-1);",
$cs_match,
intval( $m->matchID ),
intval( $m->groupOrderID ),
intval( $m->idTeam1 ),
intval( $m->idTeam2 ),
esc_attr( $m->matchDateTime )
);
$result = $wpdb->query( $sql );
if ( $result ) {
echo __( 'Matchrecord inserted successfully', 'wp-championship' ) . '.
';
} else {
echo __( 'Database error, record not inserted.', 'wp-championship' ) . '
';
}
}
// you must end here to stop the displaying of the html below
exit( 0 );
}
// import formular aufbauen ===================================================
$out = '';
// add log area style
$out .= '';
$out .= '\n";
echo $out;
wp_die();
}
//
// Holt die zur Sportart vorhandenen Ligen von OpenLigaDB und gibt sie als json zurück (Aufruf über ajax)
//
function wpc_openligadb_getleagues() {
$out = array();
if ( ! empty( $_POST ) ) {
$sport = '';
if ( array_key_exists( 'sport', $_POST ) ) {
$sport = esc_attr( $_POST['sport'] );
// get ligen
$p = new stdClass();
$p->sportID = $sport;
$res = do_soapcall( 'GetAvailLeaguesBySports', $p );
$out = $res->GetAvailLeaguesBySportsResult->League;
}
}
echo json_encode( $out );
wp_die();
}