HLMOD.HU Forrás Megtekintés - www.hlmod.hu
  1. #include <amxmodx>
  2. #include <amxmisc>
  3. #include <sqlx>
  4. #include <ironvip>
  5.  
  6. #define PLUGIN "SQL VIP"
  7. #define VERSION "1.0"
  8. #define AUTHOR "IrOn"
  9.  
  10. new Handle:g_SqlTuple
  11. new g_error[512]
  12.  
  13. new sqllekerdezes[1024];
  14.  
  15. new bool:is_user_vip[33]=false;
  16.  
  17.  
  18. public plugin_init() {
  19. 	register_plugin(PLUGIN, VERSION, AUTHOR)
  20.  
  21. 	register_clcmd("vip_belepes", "vip_belepes")
  22. 	register_clcmd("vip_kilepes", "vip_kilepes")
  23.  
  24. 	register_clcmd("say /viphelp", "viphelp")
  25. 	register_clcmd("say /vip", "viponline")
  26.  
  27. 	g_SqlTuple = SQL_MakeDbTuple("kiszolgalo(host)","felhasznalo", "jelszo","adatbazis")
  28. 	new errorcode, Handle:SqlConnection = SQL_Connect(g_SqlTuple, errorcode, g_error, charsmax(g_error))
  29. 	SQL_FreeHandle(SqlConnection)
  30. }
  31.  
  32. public plugin_natives()
  33. {
  34. 	register_library("ironvip_sql")
  35. 	register_native("is_vip", "_is_vip")
  36. }
  37.  
  38. public _is_vip(plugin, parameters)
  39. {
  40. 	if(parameters != 1)
  41. 		return false
  42.  
  43. 	new id = get_param(1)
  44.  
  45. 	if(!id)
  46. 		return false
  47.  
  48. 	if(is_user_vip[id])
  49. 	{
  50. 		return true
  51. 	}
  52.  
  53. 	return false
  54. }
  55.  
  56. public viphelp(id)
  57. {
  58. 	show_motd( id,"addons/amxmodx/configs/vip/info.txt");
  59. }
  60.  
  61. public viponline(id)
  62. {
  63. 	new players[32], pnum, vip=0;
  64. 	get_players(players, pnum)
  65. 	for(new i = 0; i < pnum; i++)
  66. 	{
  67. 		if(is_user_vip[players[i]])
  68. 			vip++
  69. 	}
  70. 	client_print(id, print_chat, "Jelenleg online %d VIP!", vip)
  71. }
  72.  
  73. public client_connect(id)
  74. {
  75. 	is_user_vip[id] = false;
  76. 	new userip[64], usersteamid[64];
  77. 	get_user_ip(id, userip, charsmax(userip));
  78. 	get_user_authid(id, usersteamid, charsmax(usersteamid));
  79. 	new data[1]
  80. 	data[0] = id
  81. 	formatex(sqllekerdezes, charsmax(sqllekerdezes), "SELECT * FROM `vipek` WHERE tipusadat = ^"%s^" AND tipus=^"1^" AND aktiv=^"1^";", usersteamid)	
  82. 	SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", sqllekerdezes, data, 1)
  83. 	formatex(sqllekerdezes, charsmax(sqllekerdezes), "SELECT * FROM `vipek` WHERE tipusadat = ^"%s^" AND tipus=^"2^" AND aktiv=^"1^";", userip)	
  84. 	SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", sqllekerdezes, data, 1)
  85. }
  86.  
  87. public vip_belepes(id)
  88. {
  89. 	new vipuser[32], vippass[32]
  90. 	read_argv(1,vipuser,31)
  91. 	read_argv(2,vippass,31)
  92. 	new userip[64], usersteamid[64];
  93. 	get_user_ip(id, userip, charsmax(userip), 1);
  94. 	get_user_authid(id, usersteamid, charsmax(usersteamid));
  95.  
  96. 	if(vipuser[0] > 0)
  97. 	{
  98. 		if(vippass[0] > 0)
  99. 		{
  100. 			new data[1]
  101. 			data[0] = id
  102. 			formatex(sqllekerdezes, charsmax(sqllekerdezes), "SELECT * FROM `vipek` WHERE tipusadat = ^"%s^" AND jelszo = ^"%s^" AND tipus=^"3^" AND aktiv=^"1^";", vipuser, vippass)	
  103. 			SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", sqllekerdezes, data, 1)
  104. 		}
  105. 		else
  106. 		{
  107. 			if(equal(vipuser, "ip"))
  108. 			{
  109. 				new data[1]
  110. 				data[0] = id
  111. 				formatex(sqllekerdezes, charsmax(sqllekerdezes), "SELECT * FROM `vipek` WHERE tipusadat = ^"%s^" AND tipus=^"2^" AND aktiv=^"1^";", userip)	
  112. 				SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", sqllekerdezes, data, 1)
  113. 			}
  114. 			else if(equal(vipuser, "id"))
  115. 			{
  116. 				new data[1]
  117. 				data[0] = id
  118. 				formatex(sqllekerdezes, charsmax(sqllekerdezes), "SELECT * FROM `vipek` WHERE tipusadat = ^"%s^" AND tipus=^"1^" AND aktiv=^"1^";", usersteamid)	
  119. 				SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", sqllekerdezes, data, 1)
  120. 			}
  121. 			else
  122. 			{
  123. 				client_print(id, print_console, "VIP | Hibas adatok!")
  124. 			}
  125. 		}
  126. 	}
  127. 	else
  128. 	{
  129. 		client_print(id, print_console, "VIP | Nem adtal meg mindent!")
  130. 	}
  131. 	return PLUGIN_HANDLED;
  132. }
  133.  
  134. public vip_kilepes(id)
  135. {
  136. 	is_user_vip[id] = false;
  137. 	client_print(id, print_console, "VIP | Kijelentkeztel!")
  138. 	return PLUGIN_HANDLED
  139. }
  140.  
  141. public QuerySelectData(FailState, Handle:Query, error[], errorcode, data[], datasize, Float:fQueueTime)
  142. { 
  143. 	if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED)
  144. 	{
  145. 		log_amx("%s", error)
  146. 		return
  147. 	}
  148. 	else
  149. 	{
  150. 		new id = data[0];
  151. 		while(SQL_MoreResults(Query)) 
  152. 		{
  153. 			is_user_vip[id] = true;
  154. 			client_print(id, print_console, "VIP | Sikeres bejelentkezes!")
  155. 			SQL_NextRow(Query)
  156. 		}
  157. 		if(is_user_vip[id] == false)
  158. 			client_print(id, print_console, "VIP | Hibas adatok, nem vagy VIP!")
  159. 	}
  160. }
  161.  
  162. public QuerySetData(FailState, Handle:Query, error[],errcode, data[], datasize)
  163. {
  164. 	if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED)
  165. 	{
  166. 		return
  167. 	}
  168. }
  169.