Advertisement
Guest User

Untitled

a guest
Nov 21st, 2015
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. on *:text:!quote *:#:{
  2. var %db = $mysql_connect(*censored*, *censored*, *censored*)
  3. if (%db) {
  4. mysql_select_db %db database
  5. set %2 = $2
  6. msg $nick %2
  7. var %sql = SELECT id, datum, text FROM loonakia_quotes WHERE id = %2
  8. var %res = $mysql_query(%db, %sql)
  9. if (%res) {
  10. while ($mysql_fetch_row(%res, row, $MYSQL_ASSOC)) {
  11. var %date $hget(row, date)
  12. var %text $hget(row, text)
  13. msg $chan /me > %text - %date
  14. }
  15. mysql_free %res
  16. mysql_close %db
  17. }
  18. else {
  19. msg $nick Error executing query: %mysql_errstr
  20. }
  21. }
  22. else {
  23. echo -a Error connecting: %mysql_errstr
  24. }
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement