Advertisement
Xzempt

Untitled

Feb 2nd, 2012
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. alias details { return  }
  2. on *:INPUT:*: {
  3.   if ($regex(sql,$1,/(/|/{2})/)) { return }
  4.   if ($1 == ~createtable) && ($2) {
  5.     var %info_db = $mysql_connect($readini(db.info.ini, info, host), $readini(db.info.ini, info, user), $readini(db.info.ini, info, pass))
  6.     if (%info_db) {
  7.       var %sql = CREATE TABLE $2-
  8.       var %stmt = $mysql_exec(%info.db, %sql)
  9.       if (!%stmt) {
  10.         echo -a $str($chr(160),25) $+(7Error Message:12 %mysql_errstr,$chr(32),07,$chr(40),$chr(32),09Error:,$chr(32),%mysql_errno,$chr(32),07,$chr(41))
  11.       }
  12.       else {
  13.         mysql_exec %info.db %stmt
  14.       }
  15.     }
  16.   }
  17.  
  18.   if ($1 == ~insert) && ($2) {
  19.     %insertdata = $3-
  20.     var %x = 1
  21.     %testvar = $numtok(%insertdata,32)
  22.     while (%x <= %testvar) {
  23.       set %testvar_result $instok(%testvar_result,$mysql_qt($gettok(%insertdata,%x,32)),0,44)
  24.       inc %x
  25.     }
  26.     var %info.db = $mysql_connect($readini(db.info.ini, info, host), $readini(db.info.ini, info, user), $readini(db.info.ini, info, pass), $readini(db.info.ini, info, db))
  27.     if (%info.db) {
  28.       %sql = INSERT INTO $2 VALUES ( %testvar_result );
  29.       var %stmt = $mysql_exec(%info.db, %sql)
  30.       unset %testvar* %insertdata
  31.       if (!%stmt) {
  32.         echo -a $str($chr(160),25) $+(7Error Message:12 %mysql_errstr,$chr(32),07,$chr(40),$chr(32),09Error:,$chr(32),%mysql_errno,$chr(32),07,$chr(41))
  33.       }
  34.       else {
  35.         mysql_exec %info.db %stmt
  36.       }
  37.  
  38.     }
  39.   }
  40.  
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement