Advertisement
Guest User

mysql erro??

a guest
Mar 12th, 2012
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. #include <amxmodx>
  2. #include <csx>
  3. #include <sqlx>
  4.  
  5. #define PLUGIN "Tests"
  6. #define AUTHOR ""
  7. #define VERSION "1.00"
  8.  
  9. #define DB_CALL "INSERT INTO `lol` ( lol ) VALUES ( 'lol' )"
  10.  
  11. new Handle:SqlConnection;
  12. new mysql_user, mysql_host, mysql_pass, mysql_db, mysql_table
  13. new szHost[ 16 ], szUser[ 20 ], szPass[ 32 ], szDb[ 32 ], szTable[ 32 ]
  14.  
  15.  
  16. public plugin_init()
  17. {
  18. mysql_db = register_cvar( "ca_mysql_db", "dd2_ban" )
  19. mysql_host = register_cvar( "ca_mysql_host", "127.0.0.1" )
  20. mysql_user = register_cvar( "ca_mysql_user", "root" )
  21. mysql_pass = register_cvar( "ca_mysql_pass", "parole" )
  22. register_clcmd("say /test","calltest")
  23. }
  24.  
  25. public plugin_cfg( )
  26. {
  27. get_pcvar_string( mysql_host, szHost, charsmax( szHost ) );
  28. get_pcvar_string( mysql_user, szUser, charsmax( szUser ) );
  29. get_pcvar_string( mysql_pass, szPass, charsmax( szPass ) );
  30. get_pcvar_string( mysql_db, szDb, charsmax( szDb ) );
  31. get_pcvar_string( mysql_table, szTable, charsmax( szTable ) );
  32.  
  33. SqlConnection = SQL_MakeDbTuple( szHost, szUser, szPass, szDb );
  34. }
  35.  
  36. public calltest(id)
  37. {
  38. new Query[ 1001 ]
  39. format( Query, 1000, DB_CALL)
  40. SQL_ThreadQuery( SqlConnection, "QueryCreateTable", Query )
  41. return PLUGIN_HANDLED
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement