Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- on *:text:!quote *:#:{
- var %db = $mysql_connect(*censored*, *censored*, *censored*)
- if (%db) {
- mysql_select_db %db database
- set %2 = $2
- msg $nick %2
- var %sql = SELECT id, datum, text FROM loonakia_quotes WHERE id = %2
- var %res = $mysql_query(%db, %sql)
- if (%res) {
- while ($mysql_fetch_row(%res, row, $MYSQL_ASSOC)) {
- var %date $hget(row, date)
- var %text $hget(row, text)
- msg $chan /me > %text - %date
- }
- mysql_free %res
- mysql_close %db
- }
- else {
- msg $nick Error executing query: %mysql_errstr
- }
- }
- else {
- echo -a Error connecting: %mysql_errstr
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement