Advertisement
Guest User

Untitled

a guest
Jul 6th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.65 KB | None | 0 0
  1. /client/proc/librarycheck()
  2. var/dat
  3. var/id
  4. dat += "<h3>External Archive</h3>"
  5. var/DBConnection/dbcon = new()
  6. dbcon.Connect("dbi:mysql:[sqldb]:[sqladdress]:[sqlport]","[sqllogin]","[sqlpass]")
  7. if(!dbcon.IsConnected())
  8. dat += "<font color=red><b>ERROR</b>: Unable to contact External Archive. Please contact your system administrator for assistance.</font>"
  9. else
  10. dat += "<table>"
  11. dat += "<tr><td>AUTHOR</td><td>TITLE</td><td>CATEGORY</td><td>UPLOADKEY</td></tr>"
  12. var/DBQuery/query = dbcon.NewQuery("SELECT id, author, title, category, uploadkey FROM library")
  13. query.Execute()
  14. while(query.NextRow())
  15. id = query.item[1]
  16. var/author = query.item[2]
  17. var/title = query.item[3]
  18. var/category = query.item[4]
  19. var/uploadkey = query.item[5]
  20. dat += "<tr><td>[author]</td><td>[title]</td><td>[category]</td><td>[uploadkey]</td><td><A href='?src=\ref[src];delete=1'>\[Delete\]</A></td></tr>"
  21. dat += "</table><BR>"
  22. dbcon.Disconnect()
  23. usr << browse(dat, "window=librarycheck")
  24. onclose(usr, "librarycheck")
  25.  
  26. /client/librarycheck/
  27. ...()
  28. Topic(href, href_list)
  29. if(href_list["delete"])
  30. var/DBConnection/dbcon = new()
  31. dbcon.Connect("dbi:mysql:[sqldb]:[sqladdress]:[sqlport]","[sqllogin]","[sqlpass]")
  32. if(!dbcon.IsConnected())
  33. alert("Connection to Archive has been severed. Aborting.")
  34. else
  35. dbcon.Connect("dbi:mysql:[sqldb]:[sqladdress]:[sqlport]","[sqllogin]","[sqlpass]")
  36. var/DBQuery/query = dbcon.NewQuery("DELETE FROM `tgstation`.`library` WHERE `library`.`id` = '[id]'")
  37. if(!query.Execute())
  38. usr << query.ErrorMsg()
  39. else
  40. usr << "Book successfully deleted."
  41. dbcon.Disconnect()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement