Raised This Month: $ Target: $400
 0% 

Mysql handle returning 0 on query problem


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
SaintK
Veteran Member
Join Date: Mar 2004
Old 02-27-2006 , 09:12  
Reply With Quote #3

Code:
#include <amxmodx> #include <amxmisc> #include <dbi> #define PLUGIN "Nick Protection" #define VERSION "1.0" #define AUTHOR "[DumB]SteamSucks" new clientname[32] new usersteam[32] new user_id[32] new user_steamid[32]         new Sql:dbc new Result:result new query[256] new error[33] new num new i public plugin_init() {     register_plugin(PLUGIN, VERSION, AUTHOR)         dbc = dbi_connect("localhost", "root", "", "dk", error, 32)     if (dbc == SQL_FAILED)         {         server_print("[AMXX] Could Not Connect To SQL Database. Check your login details.")         return PLUGIN_HANDLED         }     result = dbi_query(dbc,"CREATE TABLE IF NOT EXISTS `savednames` (`id` int,`steamid` varchar(30), `name` varchar(30), PRIMARY KEY(`id`))")     server_print("[AMXX] Connected to SQL Database, logging all users.")     dbi_free_result(result)     return PLUGIN_CONTINUE } public client_authorized(id){         get_user_name(id,clientname,31)     get_user_authid(id,usersteam,31)         result = dbi_query(dbc,"select * from `savednames` where name = '%s'", clientname)          if (result < RESULT_NONE) {           new err[255]           new errNum = dbi_error(dbc, err, 254)           server_print("error2: %s|%d", err, errNum)                                         }           num = dbi_num_rows(result)     i = 1         while ( i < num )     {            dbi_nextrow(result)     dbi_result(result,"steamid", user_steamid, 31)     dbi_free_result(result)     dbi_result(result,"name", user_id, 31)     dbi_free_result(result)     i++;     }                                         if (  contain(user_id,clientname) && contain(user_steamid,usersteam)   )         {     server_print("[Logger-ClientAuth-1] Logged into database: %s (%s).", user_id, user_steamid)     return PLUGIN_HANDLED     }         else if(result == RESULT_NONE)     {        server_print("[Logger-ClientAuth-1] ERROR. User(%s)(%s) does not exist in database.", user_id, user_steamid)     return PLUGIN_HANDLED     }         else         {     client_print(id, print_chat, "You are not allowd to use this name please chose another !!!")     server_cmd("kick %d This name cannot be used",id)     client_cmd(id , "disconnect")     }         return PLUGIN_HANDLED         }

the error comes back as

Adding master server 68.142.72.250:27010
Adding master server 69.28.151.162:27010
L 02/27/2006 - 14:09:22: [MYSQL] Invalid database handle 0
L 02/27/2006 - 14:09:22: [AMXX] Displaying debug trace (plugin "NickProtect.amxx")
L 02/27/2006 - 14:09:22: [AMXX] Run time error 10: native error (native "dbi_query")
L 02/27/2006 - 14:09:22: [AMXX] [0]
SaintK is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 20:17.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode