Raised This Month: $ Target: $400
 0% 

[help plz] tag mismatch


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
aTei
Junior Member
Join Date: Dec 2008
Old 02-18-2009 , 11:50   [help plz] tag mismatch
Reply With Quote #1

DB:
1st colum - steamid
2nd - hp

Plugin must:
if player steamid exist in DB he get hp

Sma
PHP Code:
#include <amxmodx>
#include <amxmisc>
#include <dbi>
#include <fun>

new Sql:g_SqlConnection
new g_Error[512]



public 
plugin_init() {
    
register_plugin("Donate HP SQL","0.1","aTei")
    
    new 
Host[64],User[64],Pass[64],Db[64]
    
get_cvar_string("amx_sql_host",Host,63)
    
get_cvar_string("amx_sql_user",User,63)
    
get_cvar_string("amx_sql_pass",Pass,63)
    
get_cvar_string("amx_sql_db",Db,63)
   
    
g_SqlConnection dbi_connect(Host,User,Pass,Db,g_Error,511)
    if(
g_SqlConnection SQL_OK)
       
set_fail_state(g_Error)

    if (!
g_SqlConnection)
    {
       
console_print(0,"[Donate HP] Can't connect to DB!")
    }
       
    
dbi_query(g_SqlConnection,"CREATE TABLE IF NOT EXISTS donate_hp (steamid text,hp INT(11))")
}


public 
client_putinserver (id){
    new 
steamid[38]
    
get_user_authid(idsteamid37)
    new 
result dbi_query(g_SqlConnection"SELECT * FROM donate_hp WHERE steamid = '%s'"steamid);
    if (
result){
       new 
db_hp dbi_field(result,2)
       
set_user_health(iddb_hp)    
    }
    return 
PLUGIN_CONTINUE

Errors
Compiler
PHP Code:
//// donate_hp.sma
// F:\servers\files\amxmodx 1.8.1\addons\amx
arning 213tag mismatch
// F:\servers\files\amxmodx 1.8.1\addons\amx
arning 213tag mismatch
// Header size:            364 bytes
// Code size:              980 bytes
// Data size:             2908 bytes
// Stack/heap size:      16384 bytes; estima
)
// Total requirements:   20636 bytes
//
// 2 Warnings.
// Done.
//
// Compilation Time: 0,58 sec 
Server
PHP Code:
L 02/18/2009 19:12:36: [AMXXPlugin ("donate_hp.amxx"is setting itself as f
ailed
.
L 02/18/2009 19:12:36: [AMXXPlugin saysAccess denied for user 'root'@'loca
lhost' 
(using passwordNO)
L 02/18/2009 19:12:36: [AMXXRun time error 1 (plugin "donate_hp.amxx") - for
ced exit 
Help plz

Last edited by aTei; 02-18-2009 at 12:15. Reason: add errors on server
aTei 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 17:00.


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