Guest User

Untitled

a guest
Aug 16th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. Rename all files in folder
  2. <?php
  3. $dbc = mysql_connect('hostname', 'login', 'password');
  4. if(!$dbc){
  5. die('not connected : ' . mysql_error());
  6. }
  7.  
  8. $db_selected = mysql_select_db("database", $dbc);
  9. if(!$db_selected){
  10. die("could not connect to DB : " . mysql_error());
  11. }
  12.  
  13. $username = $_GET['username'];
  14. $image = $_GET['imagename'];
  15.  
  16. $check = mysql_query("SELECT image FROM members WHERE username='$username'");
  17. $findMem = mysql_num_rows($check);
  18.  
  19. if($findMem > 0){
  20.  
  21. while($row = mysql_fetch_array($check) or die(mysql_error())){
  22. $images = $row["image"];
  23. $images = $images - 1;
  24. unlink("./$image");
  25.  
  26. mysql_query("UPDATE members SET image='$images'
  27. WHERE username='$username'");
  28. }
  29.  
  30. $path = "$username/default/";
  31.  
  32.  
  33. $files = glob("{$path}/{*.jpg,*.jpeg,*.png}", GLOB_BRACE);
  34.  
  35.  
  36. function filetime_callback($a, $b)
  37. {
  38. if (filemtime($a) === filemtime($b)) return 0;
  39. return filemtime($a) > filemtime($b) ? -1 : 1;
  40. }
  41.  
  42. // Then sort with usort()
  43. usort($files, "filetime_callback");
  44.  
  45. }
  46.  
  47. ?>
Add Comment
Please, Sign In to add comment