Advertisement
Guest User

Untitled

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