File: //opt/plugins/atalantini/pages/fanpage.inc.php
<?
global $wpdb;
$rs = $wpdb->get_results("select id, filmtitolo from wp_elettrotecafilm;");
foreach ( $rs as $line ) {
$arrayFilm[] = '"' . $line->filmtitolo . '"';
}
?>
<div class="container" id="grigliaFanpage">
<br>
<a href="#" onClick="creaFanpage();" style="float:right;">Aggiungi Fanpage</a> <div id="paginatorFanpage" style="float:left;"></div><br>
<table class="wp-list-table widefat fixed posts">
<thead>
<tr>
<th>Id</th>
<th>Titolo</th>
<th>Trailer</th>
<th>Azioni</th>
</tr>
</thead>
<tbody id="lista_fanpage">
</tbody>
</table>
</div>
<div class="container" id="grigliaAdesioni">
<br>
<a href="#" onClick="listaFanpage(1);" style="float:right;">Torna alla lista Fanpage</a><br>
<table class="wp-list-table widefat fixed posts">
<thead>
<tr>
<th>Id</th>
<th>Username Utente</th>
<th>Citta'</th>
<th>Azione</th>
</tr>
</thead>
<tbody id="lista_adesioni">
</tbody>
</table>
</div>
<div class="container" id="formFanpage"><br><br>
<form method="post" action="./admin.php?page=subadd-fanpage" enctype="multipart/form-data">
<div id="post-body">
<div id="post-body-content">
<div id="titlediv">
<table width="90%" border=0>
<tr>
<td id="titlewrap">Titolo:</td>
<td id="titlewrap"><input name="fanpagetitolo" id="fanpagetitolo" type="text" class="span3" placeholder="Type something…"></td>
<td id="titlewrap">Trailer:</td>
<td id="titlewrap"><input name="fanpagetrailer" id="fanpagetrailer" type="text" class="span3" placeholder="Type something…"></td>
</tr>
<tr>
<td id="titlewrap">Film:</td>
<td id="titlewrap"><input name="fanpagefilm" id="fanpagefilm" type="text" class="span3" placeholder="Type something…"></td>
<td colspan=2>
</td>
</tr>
<tr>
<td>ID Pagina Facebook:</td>
<td><input name="txtFiltroFbpage" id="txtFiltroFbpage" type="text" class="span3" placeholder="Type something…"> (<a href="http://blog.swixhq.com/how-to-find-your-facebook-fanpage-id/" target="_new">?</a>) <input type="button" id="addFiltroFbpage" value="Aggiungi" onClick="confermaFiltroFbpage();">
</td>
<td colspan="2"></td>
</tr>
<tr>
<td colspan=4>
<div id="risultatiFbpage" style="display:none;">
<table class="wp-list-table widefat">
<thead>
<tr>
<th>Codice Pagina</th>
<th>Azione</th>
</tr>
</thead>
<tbody id="lista_filtro_Fbpage">
</tbody>
</table>
</div>
</td>
</tr>
<tr>
<td id="titlewrap">Citta':</td>
<td id="titlewrap">
<select name="fanpagetipocitta" id="fanpagetipocitta" class="span3">
<option value="">Seleziona..... </option>
<option value="A">Tutte con soglia minima fissa a</option>
<option value="C">Associa citta' e soglia</option>
<option value="D">Tutte le citta' senza soglia</option>
<option value="E">Scegli le citta' senza soglia</option>
</select>
</td>
<td id="titlewrap"><span id="tabSpettatori" style="display:none;"><input type="text" name="fanpagespettatori" id="fanpagespettatori" size="4"> Spettatori</span></td>
<td>
</td>
</tr>
<tr>
<td colspan="4">
<div id="filtroCitta" style="display:none;">
<table width="90%">
<tr>
<td>Cerca Provincia:</td>
<td>
<select id="selectProvincia" name="selectProvincia" onChange="selectComuniFromProvincia();">
<option value="-1">Seleziona la provincia</option>
<?
unset($rs);
$rs = $wpdb->get_results("select id, long_name from provinces;");
foreach ( $rs as $line ) {
?>
<option value="<?= $line->id ?>"><?= $line->long_name ?></option>
<?
}
?>
</select>
</td>
<td>
<select id="selectComune" name="selectComune" onChange="">
</select>
</td>
<td></td>
</tr>
<tr>
<td>Cerca citta':</td>
<td><input name="txtFiltroCitta" id="txtFiltroCitta" type="text" class="span3" placeholder="Type something…"><input type="button" id="cercaxFiltroCitta" value="Cerca" onClick="cercaFiltroCitta();"></td>
<td><span id="labelFiltroCitta"></span></td>
<td><input type="button" id="addFiltroCitta" value="Aggiungi" onClick="confermaFiltroCitta();"></td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td colspan=4>
<div id="risultatiCitta" style="display:none;">
<table class="wp-list-table widefat">
<thead>
<tr>
<th>Citta'</th>
<th>Soglia</th>
<th>Azione</th>
</tr>
</thead>
<tbody id="lista_filtro_citta">
</tbody>
</table>
</div>
</td>
</tr>
<tr>
<td id="titlewrap">Banner:</td>
<td><input name="fanpagebanner" id="fanpagebanner" type="file" class="span3" placeholder="Type something…"> <span id="bannerLabel"></span></td>
<td colspan=2>
</td>
</tr>
<tr>
<td id="titlewrap">Descrizione:</td>
<td><textarea class="span3" name="fanpagedescrizione" id="fanpagedescrizione"></textarea></td>
<td colspan=2>
</td>
</tr>
<tr>
<td id="titlewrap"><button type="button" class="btn" id="btnEsciFanpage">Esci</button></td>
<td id="titlewrap"><button type="submit" class="btn" >Salva</button></td>
<td><input type="hidden" name="fanpageAction" id="fanpageAction" value=""></td>
<td><input type="hidden" name="fanpageId" id="fanpageId" value=""></td>
</tr>
</table>
</div></div></div>
<script>
$(function() {
var availableFilms = [
<?= implode($arrayFilm, ",")?>
];
$( "#fanpagefilm" ).autocomplete({
source: availableFilms
// //onSelect: function(value, data){ $('#delega_username').val(data); }
});
});
</script>
</form>
</div>
<div class="container" id="registerFanpage"><br><br>
<div id="post-body">
<div id="post-body-content">
<div id="titlediv">
<input type="hidden" name="fanpageRegisterId" id="fanpageRegisterId" value="">
<table border=0>
<tr>
<td id="titlewrap" colspan="2"><img src="" id="fanpageLocandina"></td>
</tr>
<tr>
<td id="titlewrap"><b>Titolo:</b></td>
<td id="titlewrap"><span id="fanpageTitolo"></span></td>
</tr>
<tr>
<td id="titlewrap"><b>Film:</b></td>
<td id="titlewrap"><span id="fanpageFilm"></span></td>
</tr>
<tr>
<td id="titlewrap" valign="top"><b>Trailer:</b></td>
<td><iframe width="300" height="203" src="" id="fanpageTrailer" frameborder="0" allowfullscreen></iframe></td>
</tr>
<tr>
<td id="titlewrap"><b>Descrizione:</b></td>
<td><span id="fanpageDescrizione"></span></td>
</tr>
<tr>
<td id="titlewrap"><b>Citta':</b></td>
<td><span id="fanpageCitta"></span></td>
</tr>
<tr>
<td id="titlewrap"><button type="button" class="btn" id="btnRegisterEsciFanpage">Esci</button>
<button type="button" class="btn" id="btnRegisterSalvaFanpage">Salva su Facebook</button></td>
</tr>
</table>
</div></div></div>
</div>
<script>
listaFanpage(1);
</script>