get_charset_collate(); $daritmysql = array( "CREATE TABLE IF NOT EXISTS `".$wpdb->prefix ."smscenas` ( `id` int(255) NOT NULL AUTO_INCREMENT, `cena` int(255) NOT NULL, `nosaukums` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `".$wpdb->prefix ."smssettings` ( `par` varchar(255) NOT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `val` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `".$wpdb->prefix ."useriarkodiem` ( `id` int(255) NOT NULL AUTO_INCREMENT, `kods` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` int(4) NOT NULL, `cena` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `".$wpdb->prefix ."itapforms` ( `id` int(255) NOT NULL AUTO_INCREMENT, `desk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;" ); require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); foreach ($daritmysql as $mysqldarbs){ dbDelta( $mysqldarbs ); //veidoju tabulas ja nav... } } function smspcont_ieliekudatus () { global $wpdb; $wpdb->insert( $wpdb->prefix . 'smssettings', array( 'id' => '1', 'par' => 'apikey', 'val' => 'apiatslega', ) ); $wpdb->insert( $wpdb->prefix . 'smssettings', array( 'id' => '2', 'par' => 'kliind', 'val' => '999', ) ); } add_action( 'admin_menu', 'smspcont_adminnavigacija' ); add_shortcode( 'itapcontent', 'smspcont_itapformcontentshortcode' ); wp_register_style( 'smspcont_stils', plugins_url( 'style.css' , __FILE__ ) ); add_action( 'admin_notices', 'smscont_adminnotice' ); function smspcont_adminnavigacija() { add_menu_page( 'TB', 'ITAP MAKSAS SATURS ', 'admin', 'galva','dashicons-smartphone','dashicons-smartphone',24); add_submenu_page( 'galva', 'APIKEY - ID ', 'APIKEY - ID ', 'manage_options', 'smspcont_iestatijumi','smspcont_iestatijumi'); add_submenu_page( 'galva', 'PIETEIKTIE KODI', 'PIETEIKTIE KODI', 'manage_options', 'smspcont_pieteiktiekodi','smspcont_pieteiktiekodi'); add_submenu_page( 'galva', 'SATURA FORMAS', 'SATURA FORMAS', 'manage_options', 'smspcont_contents','smspcont_contents'); } function smscont_adminnotice(){ wp_enqueue_style('smspcont_stils'); global $wpdb; $apiecho = $wpdb->get_row( $wpdb->prepare("SELECT * FROM `".$wpdb->prefix."smssettings` where par='apikey' ")); $clidsecho = $wpdb->get_row($wpdb->prepare("SELECT * FROM `".$wpdb->prefix."smssettings` where par='kliind' ")); if ((($apiecho -> val) == 'apiatslega') || (($clidsecho -> val) == 999) || (($clidsecho -> val) == '') || ($apiecho -> val) == ''){ echo "

Lūdzu norādiet pareizus APIKEY un klienta ID || Please check your APIKEY and client ID

"; }else{} } function smspcont_iestatijumi(){ wp_enqueue_style('smspcont_stils'); global $wpdb; // JO nepieciešams mysql if (isset($_POST['updatesettings']) && ($_POST['updatesettings'] !='' ) || wp_verify_nonce( $_POST['slepenanonce'], 'apiupdate' ) ){ if(isset( $_POST ) && !empty( $_POST )){ if (!$_POST['api']){ echo "
Api nevar būt tukšums!
"; }else if (!$_POST['klientaid']){ echo "
Klienta id nevar būt tukšums!
"; }else if (!is_numeric($_POST['klientaid'])){ echo "
Klienta id nevar būt teksts!
"; }else{ $wpdb->query($wpdb->prepare("UPDATE `".$wpdb->prefix."smssettings` SET val='".sanitize_text_field($_POST['api'])."' WHERE par='apikey' ")); $wpdb->query($wpdb->prepare("UPDATE `".$wpdb->prefix."smssettings` SET val='".sanitize_text_field($_POST['klientaid'])."' WHERE par='kliind' ")); echo "Dati samainīti"; } } } $apiecho = $wpdb->get_row( $wpdb->prepare("SELECT * FROM `".$wpdb->prefix."smssettings` where par='apikey' ")); $clidsecho = $wpdb->get_row($wpdb->prepare("SELECT * FROM `".$wpdb->prefix."smssettings` where par='kliind' ")); ?>

APIKEY un ID

APIKEY un ID atrodams Jūsu ITAP profilā - SMS Uzstādījumi





Saņemts

get_row( $wpdb->prepare( "SELECT SUM(cena) as cen FROM ".$wpdb->prefix."useriarkodiem where status = 1 ")); $summa = 0; echo "

".number_format( ($suma->cen) * 0.01, 2, '.', ' ')." €

"; ?>

Saņemtā summa var nesakrist ar ITAP kontā saņemto.

ITAP . gadā
Shortcode id nav pareizs!'; }else{ global $wpdb; // JO nepieciešams mysql $forma = $wpdb->get_row( $wpdb->prepare("SELECT * FROM `".$wpdb->prefix."itapforms` where id='$itapformid' ")); $apiecho = $wpdb->get_row( $wpdb->prepare("SELECT * FROM `".$wpdb->prefix."smssettings` where par='apikey' ")); $clidsecho = $wpdb->get_row($wpdb->prepare("SELECT * FROM `".$wpdb->prefix."smssettings` where par='kliind' ")); //sāku pārbaudi datiem echo "
". $forma -> desk ."
"; $client_id = $apiecho -> val; $client_api_key = $clidsecho -> val; if( isset( $_POST['key'] ) && !empty( $_POST['key'] ) ) { $answer = file_get_contents("http://itap.lv/sms/unlock/?key=" . $_POST['key'] . "&client=" . $client_id . "&price=" . (int)$forma->price . "&apikey=" . $client_api_key. "&site=".$_SERVER['HTTP_HOST'], FALSE, NULL, 0, 10 ); if( !$answer ) { echo '
file_get_contents() netika izpildīts veiksmīgi. Domājams ka arī nesaņēmi kodu! Ja tev ir kods ienāc pēc 10 minūtem un mēģini vēlreiz, ja nekas nesanāk dod ziņu uz support@itap.lv un mēs paskatīsimes, kas noticis un atrisināsim šo ķibeli
'; exit; } $answer = strtoupper( $answer ); // 1 veiksmīgi // 0 neveiksmigi if($answer === 'OK') { $_SESSION['ITAPANSWER'] = 'ok'; } else if($answer === 'FAILED') { $msg = '
Kods netika pieņemts. Tas ir nederīgs, jeb jau iztērēts.
'; $_SESSION['ITAPANSWER'] = 'den'; } else if($answer === 'PENDING') { $msg = '
SMS vēl tiek apstrādāta, lūdzu pamēģini vēlreiz pēc pāris minūtēm.
'; $_SESSION['ITAPANSWER'] = 'den'; } else if($answer === 'ABORTED') { $msg = '
Lūdzu izmaini savā PHP konfigurācijā: allow_url_fopen = On
'; $_SESSION['ITAPANSWER'] = 'den'; } else { $msg = '
Serveris atbildēja ar neparedzētu paziņojumu: ' . $answer.'
'; $_SESSION['ITAPANSWER'] = 'den'; } }else{ echo "
Cena vai atslēga netika norādīta
"; $_SESSION['ITAPANSWER'] = 'den'; } if ($answer == 'OK'){ $status = 1 ; }else{ $status = 0; } echo $msg; if(!empty( $_POST['key'] ) ) { $wpdb->query( $wpdb->prepare( "INSERT INTO `".$wpdb->prefix."useriarkodiem`(`kods`, `status`,`cena`,`ip`) VALUES ('".sanitize_text_field($_POST['key'])."','".$status."','".$forma->price."','".$_SERVER['HTTP_X_FORWARDED_FOR']."')")); } if ($_SESSION['ITAPANSWER'] == 'ok'){ $formassastavs = $wpdb->get_row( $wpdb->prepare("SELECT * FROM `".$wpdb->prefix."itapforms` where id='$itapformid' ")); switch ($formassastavs -> type){ case 1:// shortcode echo do_shortcode($formassastavs -> value); break; case 2: echo ""; break; case 3: echo "
Tūlīt tiksi pārvirzīts
"; echo ''; break; case 4: echo "
".$formassastavs ->value . "
"; break; default: echo 'FAIL'; break; } }else{ ?>
price." uz 144"; ?> Kods:
get_results( $wpdb->prepare( 'SELECT * FROM '.$wpdb->prefix.'useriarkodiem')); echo '

Pieteiktie kodi

'; echo ""; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ""; foreach ($kodi as $kt){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
ID Pieteiktais kods CenaLaikspiedogsIPStatus
".$kt->id." ".$kt->kods." ".number_format( $kt->cena * 0.01, 2, '.', ' ') ." ".$kt->ts." ".$kt->ip." ".(($kt->status) == 1 ? '

Veiksmīgi

':'

Neizdevās "; echo "

"; } function smspcont_contents(){ wp_enqueue_style('smspcont_stils'); global $wpdb; // JO nepieciešams mysql echo "
"; echo ""; echo ""; echo ""; if (isset($_POST['deleteform'])){ if (!is_numeric($_POST['id'])){ echo "
Neatrad id!
"; }else{ if ( ! isset( $_POST['deletenonce'] ) || ! wp_verify_nonce( $_POST['deletenonce'], 'deleteshortcode' ) ) { echo "
Nekad.
"; exit; } else { $wpdb->query( $wpdb->prepare( "delete from `".$wpdb->prefix."itapforms` where id='".sanitize_text_field($_POST['id'])."' ")); } } } $contenti = $wpdb->get_results('SELECT * FROM '.$wpdb->prefix.'itapforms'); echo ""; echo ""; echo "
"; echo'

Jauna satura forma

'.wp_nonce_field( 'shortcodeadd', 'slepenanonceaddshortc' ).'

Apraksts:

Cena (3.00 -> 300) :

Type:

Vērtība(shortcode, bildes adrese utt.):

'; if (isset($_POST['newform'])){ $desk = sanitize_text_field($_POST['desc']); // CHECHING HERE!!!!! NOT NEEDED TO CHECK AGAIN LATER!! $cena = sanitize_text_field($_POST['price']); $tips = sanitize_text_field($_POST['type']); $vertiba = sanitize_text_field($_POST['val']); if ($cena < 1){ echo "
Neapreiza cena
"; }else if (!$desk ){ echo "
Nepieciešams apraksts
"; }else if ( (!$cena) || !is_numeric($cena) || is_float($cena)){ echo "
Nepieciešama cena
"; }else if (!$tips ){ echo "
Nepieciešams tips
"; }else if (!$vertiba ){ echo "
Nepieciešams vertiba laukam
"; }else{ if ( ! isset( $_POST['slepenanonceaddshortc'] ) || ! wp_verify_nonce( $_POST['slepenanonceaddshortc'], 'shortcodeadd' ) ) { echo "
Nekad.
"; exit; } else { $irieraksts = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM '.$wpdb->prefix.'itapforms WHERE desk='$desk' and price='$cena' and type='$tips' and value='$vertiba' ")); if ($irieraksts > 0){ echo "
Tāds ieraksts jau eksistē
"; }else{ $wpdb->query( $wpdb->prepare( "INSERT INTO `".$wpdb->prefix."itapforms`(`desk`, `price`, `type`, `value`) VALUES ('".$desk."','".$cena."','".$tips."','".$vertiba."')")); echo "
Forma izveidota
"; } } } } echo '
'; echo "		"; echo '

New content

'; foreach ($contenti as $c ){ echo " "; } echo'
Apraksts Cena Tips Vērtība Shortcode *
".$c->desk." " . number_format( $c->price * 0.01, 2, '.', ' ') . " euro ".smspcont_veidi($c->type)." ".$c->value." [itapcontent id='".$c->id."']
".wp_nonce_field( 'deleteshortcode', 'deletenonce' )."
'; echo "
"; } function smspcont_veidi ($a){ switch ($a){ case 1: return 'Shortcode'; break; case 2: return 'Show image'; break; case 3: return 'Open url'; break; case 4: return 'Show text'; break; default : return 'FAIL'; break; } } ?>