Advertisement
Guest User

Untitled

a guest
Mar 27th, 2015
240
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. CREATE TABLE wp_tokens (
  2. ID int(12) NOT NULL AUTO_INCREMENT,
  3. USER varchar(128) NOT NULL COMMENT 'User name',
  4. TS timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  5. IP varchar(64) NOT NULL,
  6. TOKEN varchar(128) NOT NULL COMMENT 'Hashed tokens',
  7. VALID (12),
  8. PRIMARY KEY (`ID`)
  9. )
  10.  
  11. <?php
  12. global $wpdb;
  13. global $user_login;
  14. $token = uniqid();
  15. $hashedtoken = md5($token);
  16. $user = $user_login;
  17. $ip = $_SERVER['REMOTE_ADDR'];
  18. $valid = "1";
  19. $chkdb = mysql_query("SELECT valid FROM wp_tokens WHERE user=$user");
  20.  
  21. if(mysql_num_rows($chkdb) == 1)
  22. {
  23. echo $hashedtoken;
  24. }
  25. else
  26. {
  27. $wpdb->insert('wp_tokens',
  28. array('user' => $user, 'token' => $hashedtoken, 'ip' => $ip, 'valid' => $valid),
  29. array('%s','%s','%s'));
  30. }
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement