Raised This Month: $ Target: $400
 0% 

Can anyone change this sql plugin to non sql.


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
GarbageBox
Senior Member
Join Date: Feb 2010
Old 11-15-2010 , 05:41   Can anyone change this sql plugin to non sql.
Reply With Quote #1

Here is the sql version, I dont know how to change to be a non sql version.
Can sb help me to change it.
I want save the stuff in amxmodx\data.
Code:
//-----------------// Funname
new fun_name[33][32];
new steam_id[33][35];
//-----------------// Funname


// Funname System
register_cvar("amx_funname","0");						// Enable/Disable Funname System
register_cvar("amx_funname_save","0");					// Enable/Disable Funname Save System


// Funname System
setting_funname				= get_cvar_num("amx_funname");				// Enable/Disable Funname System
setting_funname_save		= get_cvar_num("amx_funname_save");			// Enable/Disable Funname Save System


register_clcmd("say","allchat")






public client_putinserver(id) 
{
	if(setting_sqlserver_open && setting_funname && setting_funname_save)
	{
		sql_load_data(id)
	}
	return PLUGIN_CONTINUE
}


public sql_load_data(id)
{
	new NetAddr[32]
	get_user_ip(id, NetAddr, 31, 1)

	new Handle:hkcs_sql_connect = SQL_MakeDbTuple(hkcs_host,hkcs_user,hkcs_pass,hkcs_db)
	new Handle:hkcs_sql = SQL_Connect(hkcs_sql_connect, errno, hkcs_error, 511)
	
	get_user_authid(id, steam_id[id], 34)
	if(equal(steam_id[id],"VALVE_ID_LAN"))
	{
		new Handle:hkcs_query_acc = SQL_PrepareQuery(hkcs_sql, "SELECT * FROM `%s` WHERE name_ip= '%s';",hkcs_tab,NetAddr);
		SQL_Execute(hkcs_query_acc)
			
		if(SQL_NumResults(hkcs_query_acc))
		{
			SQL_ReadResult(hkcs_query_acc, 2, fun_name[id],30)		// Set Funname
		}
		else
		if(!SQL_NumResults(hkcs_query_acc))
		{
			new Handle:query = SQL_PrepareQuery(hkcs_sql, "INSERT INTO `%s` (`name_ip`,`name`) VALUES ('%s','%s');",hkcs_tab,NetAddr,default_name);
			SQL_Execute(query)			// Set Up Funaname
			format(fun_name[id], 12, "%s",default_name)
		}
	}
	else
	{
		new Handle:hkcs_query_acc = SQL_PrepareQuery(hkcs_sql, "SELECT * FROM `%s` WHERE steam_id= '%s';",hkcs_tab,steam_id[id]);
		SQL_Execute(hkcs_query_acc)
			
		if(SQL_NumResults(hkcs_query_acc))
		{
			SQL_ReadResult(hkcs_query_acc, 2, fun_name[id],30)
		}
		else
		if(!SQL_NumResults(hkcs_query_acc))
		{
			new Handle:query = SQL_PrepareQuery(hkcs_sql, "INSERT INTO `%s` (`steam_id`,`name_ip`) VALUES ('%s','%s');",hkcs_tab,steam_id[id],NetAddr);
			SQL_Execute(query)
			format(fun_name[id], 12, "%s",default_name)
		}
	}
	SQL_FreeHandle(hkcs_sql)
}


public allchat(id)
{
	if(!is_user_connected(id))
	{
		return PLUGIN_HANDLED
	}
	new system_msg[150]	
	new all_msg[200]
	new name[32]
	get_user_name(id, name, 31)
	
	read_args(all_msg, 200)
	remove_quotes(all_msg)

	replace_all(all_msg, 200, "%", "%") 
	format(all_msg, 200, " %s", all_msg)			// Get Say Message

	new check_name[32]
	new send_msg[192],get_msg[256]
	format(get_msg, 200, "%s", all_msg)			// Copy Message
	strtok(get_msg[1],check_name,30,send_msg,170,' ')	// Separate Message

	if(containi(check_name,"/fun_name") != -1 && setting_funname)
	{
		if(!send_msg[0])
		{
			format(system_msg, 149, "%s^x04 Funname must long than 1 word", setting_plugin_name)
			client_color(id, id, system_msg)
			return PLUGIN_HANDLED
		}
		new fun_len = strlen(send_msg);
		if(fun_len > 15)
		{
			format(system_msg, 149, "%s^x04 Funname must less then 15 words", setting_plugin_name)
			client_color(id, id, system_msg)
			return PLUGIN_HANDLED
		}
		format(fun_name[id], 30, "%s",send_msg)
		format(system_msg, 149, "%s^x04 Funname change to^x03 %s", setting_plugin_name,fun_name[id])
		client_color(id, id, system_msg)
		if(setting_sqlserver_open && setting_funname_save)
		{
			if(equal(steam_id[id],"VALVE_ID_LAN"))
			{
				new NetAddr[32]
				get_user_ip(id, NetAddr, 31, 1)
				new Handle:hkcs_sql_connect = SQL_MakeDbTuple(hkcs_host,hkcs_user,hkcs_pass,hkcs_db)
				new Handle:hkcs_sql = SQL_Connect(hkcs_sql_connect, errno, hkcs_error, 511)
				new Handle:query = SQL_PrepareQuery(hkcs_sql, "UPDATE `%s` SET `name` = '%s' WHERE ( `name_ip` = '%s');",hkcs_tab,fun_name[id],NetAddr)
				SQL_Execute(query)
				SQL_FreeHandle(hkcs_sql)
			}
			else
			{
				new NetAddr[32]
				get_user_ip(id, NetAddr, 31, 1)
				new Handle:hkcs_sql_connect = SQL_MakeDbTuple(hkcs_host,hkcs_user,hkcs_pass,hkcs_db)
				new Handle:hkcs_sql = SQL_Connect(hkcs_sql_connect, errno, hkcs_error, 511)
				new Handle:query = SQL_PrepareQuery(hkcs_sql, "UPDATE `%s` SET `name` = '%s',`name_ip` = '%s' WHERE ( `steam_id` = '%s');",hkcs_tab,fun_name[id],NetAddr,steam_id[id])
				SQL_Execute(query)
				SQL_FreeHandle(hkcs_sql)
			}
		}
		return PLUGIN_HANDLED
	}
	return PLUGIN_HANDLED
}
__________________
You can be a SUPER coder but you Haven't to say such as "stupid, etc." words to the others
GarbageBox 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 11:19.


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