Ciao, ho uno script dove permette anche di inserire semplici commenti/shout. Purtroppo in area amministrativa è possibile unicamente poter gestire gli utenti, quindi cancellarli, modificarli, bannarli.
Io vorrei prendere spunto da questo per i commenti, ricopiando quindi la pagina ma cambiando le variabili che richiamano gli utenti e sostituendole con quelle dei commenti, lasciando la funziona Delete.
Come posso fare?
Provo ad incollare la pagina di gestione utente:
codice:<?php //user_role 3 => admin ?> <?php $users = $db->select("SELECT * FROM `as_users` WHERE `user_role` != '3' ORDER BY `register_date` DESC"); ?> <table cellpadding="0" cellspacing="0" border="0" class="table table-striped users-table" id="users-list" width="100%"> <thead> <th><?php echo ASLang::get('username'); ?></th> <th><?php echo ASLang::get('email'); ?></th> <th><?php echo ASLang::get('register_date'); ?></th> <!-- <th>--><?php //echo ASLang::get('last_login'); ?><!--</th>--> <th><?php echo ASLang::get('confirmed'); ?></th> <th><?php echo ASLang::get('action'); ?></th> </thead> <?php foreach ($users as $user): ?> <?php $tmpUser = new ASUser($user['user_id']); ?> <?php $userRole = $tmpUser->getRole(); ?> <tr class="user-row"> <td><?php echo e($user['username']); ?></td> <td><?php echo e($user['email']); ?></td> <td><?php echo $user['register_date']; ?></td> <!-- <td>--><?php //echo $user['last_login']; ?><!--</td>--> <td> <?php echo $user['confirmed'] == "Y" ? "<p class='text-success'>" . ASLang::get('yes') . "</p>" : "<p class='text-error'>" . ASLang::get('no') . "</p>" ?> </td> <td> <div class="btn-group"> <a class="btn <?php echo $user['banned'] == 'Y' ? 'btn-danger' : 'btn-primary'; ?> btn-user" href="javascript:void(0);" onclick="users.roleChanger(this,<?php echo $user['user_id']; ?>);"> <i class="icon-user icon-white glyphicon glyphicon-user"></i> <span class="user-role"><?php echo ucfirst($userRole); ?></span> </a> <a class="btn <?php echo $user['banned'] == 'Y' ? 'btn-danger' : 'btn-primary'; ?> dropdown-toggle" data-toggle="dropdown" href="#"> <span class="caret"></span> </a> <ul class="dropdown-menu"> <li> <a href="javascript:void(0);" onclick="users.editUser(<?php echo $user['user_id']; ?>);"> <i class="icon-edit glyphicon glyphicon-edit"></i> <?php echo ASLang::get('edit'); ?> </a> </li> <li> <a href="javascript:void(0);" onclick="users.displayInfo(<?php echo $user['user_id']; ?>);"> <i class="icon-pencil glyphicon glyphicon-pencil"></i> <?php echo ASLang::get('details'); ?> </a> </li> <?php if ( $user['banned'] == 'Y' ): ?> <li> <a href="javascript:void(0);" onclick="users.unbanUser(this,<?php echo $user['user_id']; ?>);"> <i class="icon-ban-circle glyphicon glyphicon-ban-circle"></i> <span><?php echo ASLang::get('unban'); ?></span> </a> </li> <?php else: ?> <li> <a href="javascript:void(0);" onclick="users.banUser(this,<?php echo $user['user_id']; ?>);"> <i class="icon-ban-circle glyphicon glyphicon-ban-circle"></i> <span><?php echo ASLang::get('ban'); ?></span> </a> </li> <?php endif; ?> <li> <a href="javascript:void(0);" onclick="users.deleteUser(this,<?php echo $user['user_id']; ?>);"> <i class="icon-trash glyphicon glyphicon-trash"></i> <?php echo ASLang::get('delete'); ?> </a> </li> <li class="divider"></li> <li> <a href="javascript:void(0);" onclick="users.roleChanger(this,<?php echo $user['user_id']; ?>);"> <i class="i"></i> <?php echo ASLang::get('change_role'); ?></a> </li> <?php endforeach; ?> <div class="control-group form-group"> <label class="control-label col-lg-3" for="adduser-username"> <?php echo ASLang::get('username'); ?> </label> <div class="controls col-lg-9"> <input id="adduser-username" name="adduser-username" type="text" class="input-xlarge form-control" > </div> </div> <div class="control-group form-group"> <label class="control-label col-lg-3" for="adduser-password"> <?php echo ASLang::get('password'); ?> </label> <div class="controls col-lg-9"> <input id="adduser-password" name="adduser-password" type="password" class="input-xlarge form-control" > </div> </div> <div class="control-group form-group"> <label class="control-label col-lg-3" for="adduser-confirm_password"> <?php echo ASLang::get('repeat_password'); ?> </label> <div class="controls col-lg-9"> <input id="adduser-confirm_password" name="adduser-confirm_password" type="password" class="input-xlarge form-control" > </div> </div> <hr> <div class="control-group form-group"> <label class="control-label col-lg-3" for="adduser-first_name"> <?php echo ASLang::get('first_name'); ?> </label> <div class="controls col-lg-9"> <input id="adduser-first_name" name="adduser-first_name" type="text" class="input-xlarge form-control" > </div> </div> <div class="control-group form-group"> <label class="control-label col-lg-3" for="adduser-last_name"> <?php echo ASLang::get('last_name'); ?> </label> <div class="controls col-lg-9"> <input id="adduser-last_name" name="adduser-last_name" type="text" class="input-xlarge form-control" > </div> </div> <div class="control-group form-group"> <label class="control-label col-lg-3" for="adduser-address"> <?php echo ASLang::get('address'); ?> </label> <div class="controls col-lg-9"> <input id="adduser-address" name="adduser-address" type="text" class="input-xlarge form-control" > </div> </div> <div class="control-group form-group"> <label class="control-label col-lg-3" for="adduser-phone"> <?php echo ASLang::get('phone'); ?> </label> <div class="controls col-lg-9"> <input id="adduser-phone" name="adduser-phone" type="text" class="input-xlarge form-control" > </div> </div> </form> </div> <div align="center" class="ajax-loading"><img src="assets/img/ajax_loader.gif" /></div> <div class="modal-footer"> <a href="javascript:void(0);" class="btn btn-default" data-dismiss="modal" aria-hidden="true"> <?php echo ASLang::get('cancel'); ?> </a> <a href="javascript:void(0);" id="btn-add-user" class="btn btn-primary"> <?php echo ASLang::get('add'); ?> </a> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div><!-- /.modal --> <script type="text/javascript" src="assets/js/sha512.js"></script> <script type="text/javascript" src="assets/js/jquery.dataTables.min.js"></script> <script type="text/javascript" src="assets/js/dataTables.bootstrap.js"></script> <?php if(BOOTSTRAP_VERSION == 2): ?> <script type="text/javascript" src="assets/js/dataTables.bootstrap2.js"></script> <?php else: ?> <script type="text/javascript" src="assets/js/dataTables.bootstrap3.js"></script> <?php endif; ?> <script src="ASLibrary/js/asengine.js" type="text/javascript" charset="utf-8"></script> <script src="ASLibrary/js/users.js" type="text/javascript" charset="utf-8"></script> <script src="ASLibrary/js/index.js" type="text/javascript" charset="utf-8"></script> <script type="text/javascript"> $(document).ready(function() { $('#users-list').dataTable(); } ); </script>
Le voci database riguardo i commenti sono:
Tabella:
as_comments
Campi interno:
comment_id
posted_by
posted_by_name
post_time
Se possibilmente potreste farmi un esempio di pagina con relativi commenti e la funzione di cancellazione, grazie mille a chi mi vorrà aiutare. (Ho cancellato qualche stringa inutile per il caso per non superare i caratteri massimi)
Rispondi quotando