This repository has been archived by the owner on Mar 5, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 7
/
Copy pathlibrary.php
executable file
·95 lines (82 loc) · 5.36 KB
/
library.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
<?php
include 'language.php';
global $wpdb;
global $language;
if(@$_POST['action'] == 'delete' || @$_POST['action2'] == 'delete'){
$option = get_option('SMMS_DATA');
$auth = $option['Authorization'];
$smapi = new SMApi($auth);
foreach ($_POST['imglist'] as $v) {
$wpdb->get_results("DELETE FROM `". MY_NEW_TABLE ."` WHERE ((`hash` = '$v'))");
$smapi->Delete($v);
}
}
$pages = $_GET['paged']? : 1;
$limit = 10;
$offset = ($pages - 1) * 10;
$sql = $wpdb->prepare('SELECT * FROM `'. MY_NEW_TABLE .'` ORDER BY `id` DESC LIMIT %d OFFSET %d', $limit, $offset);
$rs = $wpdb->get_results($sql);
$count = $wpdb->get_results('SELECT COUNT(*) FROM `'. MY_NEW_TABLE .'`');
$t = 'COUNT(*)';
$count = $count[0]->$t;
$all_pages = (int) ($count/10) + 1;
?>
<div class="wrap">
<h1 class="wp-heading-inline">
<? echo $language[1]; ?></h1>
<?php if(@$_POST['action'] == 'delete' || @$_POST['action2'] == 'delete'){ ?>
<div id="message" class="updated notice is-dismissible"><p><? echo $language[14]; ?></p><button type="button" class="notice-dismiss"><span class="screen-reader-text"><? echo $language[15]; ?></span></button></div>
<?php } ?>
<form method="post">
<div class="tablenav top">
<div class="alignleft actions bulkactions">
<label for="bulk-action-selector-top" class="screen-reader-text"><? echo $language[16]; ?></label><select name="action" id="bulk-action-selector-top">
<option value="-1"><? echo $language[17]; ?></option>
<option value="delete"><? echo $language[18]; ?></option>
</select>
<input type="submit" id="doaction" name="test" class="button action" value="<? echo $language[19]; ?>" />
</div>
<div class='tablenav-pages one-page'><span class="displaying-num"><?php echo $count;?><? echo $language[20]; ?></span></div>
<br class="clear" />
</div>
<h2 class='screen-reader-text'><? echo $language[21]; ?></h2><table class="wp-list-table widefat fixed striped users">
<thead>
<tr>
<td id='cb' class='manage-column column-cb check-column'><label class="screen-reader-text" for="cb-select-all-1"><? echo $language[22]; ?></label><input id="cb-select-all-1" type="checkbox" /></td><th scope="col" id='username' class='manage-column column-username column-primary sortable desc'><a><span><? echo $language[24]; ?></span></a></th><th scope="col" id='name' class='manage-column column-name'><? echo $language[23]; ?></th><th scope="col" id='email' class='manage-column column-email sortable desc'><a><span><? echo $language[25]; ?></span></a></th><th scope="col" id='role' class='manage-column column-role'>URL</th><th scope="col" id='posts' class='manage-column column-posts num'>HASH</th> </tr>
</thead>
<tbody id="the-list"
data-wp-lists='list:user' >
<?php foreach($rs as $res){ ?>
<tr>
<th scope='row' class='check-column'><input type="checkbox" name="imglist[]" id="user_1" class="administrator" value="<?php echo $res->hash; ?>" /></th>
<td class='username column-username has-row-actions column-primary' data-colname="图片"><img alt='' src='<?php echo $res->url; ?>' class='avatar avatar-32 photo' height='100' width='100' /> </td>
<td><?php echo $res->width; ?> * <?php echo $res->height; ?></td>
<td><?php echo $res->size; ?></td>
<td><?php echo $res->url; ?></td>
<td><?php echo $res->hash; ?></td>
</tr>
<? } ?>
</tbody>
<tfoot>
<tr>
<td class='manage-column column-cb check-column'><label class="screen-reader-text" for="cb-select-all-2"><? echo $language[22]; ?></label><input id="cb-select-all-2" type="checkbox" /></td><th scope="col" class='manage-column column-username column-primary sortable desc'><a><span><? echo $language[24]; ?></span></a></th><th scope="col" class='manage-column column-name'><? echo $language[23]; ?></th><th scope="col" class='manage-column column-email sortable desc'><a><span><? echo $language[25]; ?></span></a></th><th scope="col" class='manage-column column-role'>URL</th><th scope="col" class='manage-column column-posts num'>HASH</th> </tr>
</tfoot>
</table>
<div class="tablenav bottom">
<div class="alignleft actions bulkactions">
<label for="bulk-action-selector-bottom" class="screen-reader-text"><? echo $language[16]; ?></label><select name="action2" id="bulk-action-selector-bottom">
<option value="-1"><? echo $language[17]; ?></option>
<option value="delete"><? echo $language[18]; ?></option>
</select>
<input type="submit" id="doaction2" class="button action" value="<? echo $language[19]; ?>" />
</div>
<div class="tablenav-pages"><span class="displaying-num"><?php echo $count;?><? echo $language[20]; ?></span>
<a <?php if($pages != 1){ ?>href="admin.php?page=smms-image-library&paged=<?php echo ($pages - 1);?>"<?php }?>>
<span class="tablenav-pages-navspan button <?php if($pages == 1){ ?>disabled<?php }?>" aria-hidden="true">‹</span></a>
<span class="screen-reader-text"><? echo $language[26]; ?></span><span id="table-paging" class="paging-input"><span class="tablenav-paging-text"><? echo $language[27]; ?><?php echo $pages;?><? echo $language[28]; ?>，<? echo $language[29]; ?><span class="total-pages"><?php echo $all_pages;?></span><? echo $language[28]; ?></span></span>
<a class="next-page button <?php if($pages == $all_pages){ ?>disabled<?php }?>" <?php if($pages != $all_pages){ ?>href="admin.php?page=smms-image-library&paged=<?php echo ($pages + 1);?>"<?php }?>><span aria-hidden="true">›</span></a></span></div>
<br class="clear" />
</div>
</form>
<br class="clear" />
</div>