hlmod.hu

Magyar Half-Life Mód közösség!
Pontos idő: 2025.11.01. 00:36

Megválaszolatlan témák | Aktív témák



» » »


Navigáció
Jelenlévő felhasználók

Jelenleg 281 felhasználó van jelen :: 1 regisztrált, 0 rejtett és 280 vendég

A legtöbb felhasználó (2883 fő) 2025.07.30. 16:00-kor tartózkodott itt.

Regisztrált felhasználók: Bing [Bot]az elmúlt 5 percben aktív felhasználók alapján

Utoljára aktív
Ahhoz hogy lásd ki volt utoljára aktív, be kell jelentkezned.



Az oldal teljeskörű
használatához regisztrálj.

Regisztráció

Kereső


Új téma nyitása Hozzászólás a témához  Oldal: 1 / 1
  [5 hozzászólás ] 
 Nyomtatóbarát verzió |Barát értesítése e-mailben Előző téma | Következő téma 
Szerző Üzenet
pixxa112
 Hozzászólás témája: Bank
HozzászólásElküldve:2013.08.24. 18:23 
Offline
Őskövület
Avatar

Csatlakozott:2011.12.28. 00:35
Hozzászólások:2736
Megköszönt másnak: 56 alkalommal
Megköszönték neki: 275 alkalommal
Hali.

Valaki ezt ki tudná javítani, nem tudom miért írja ezt ha rakok hozzá print_colort:
SMA Forráskód: [ Mindet kijelol ]
  1. #include <amxmodx>
  2. #include <amxmisc>
  3. #include <fakemeta>
  4. #include <sqlx>
  5. #include <zombieplague>
  6. #include <colorchat>
  7.  
  8. #pragma semicolon 1
  9.  
  10. #if !defined MAX_PLAYERS
  11. #define MAX_PLAYERS 32
  12. #endif
  13.  
  14. new PLUGIN_NAME[] = "[ZP]Addons: Bank SQL";
  15. new PLUGIN_VERSION[] = "0.9.2";
  16. new PLUGIN_AUTHOR[] = "Epmak";
  17. new PLUGIN_PREFIX[] = "[Bank]";
  18.  
  19. enum vars_struct {
  20. mode=0,
  21. annonce,
  22.  
  23. save_limit,
  24. save_days,
  25. save_type,
  26.  
  27. block_cname,
  28. startedammo,
  29. allow_passwd,
  30. allow_donate,
  31.  
  32. bool:round_end,
  33.  
  34. _pw_str[32],
  35. table[32],
  36. config_dir[128]
  37. };
  38.  
  39. enum bank_struct {
  40. bool:ingame,
  41. bool:async,
  42. bool:loggin,
  43. auth[36],
  44. passwd[32],
  45. amount
  46. }
  47.  
  48. new g_vars[vars_struct];
  49. new g_Bank[MAX_PLAYERS+1][bank_struct];
  50. new Handle:g_Sql = Empty_Handle,Handle:g_SqlTuple = Empty_Handle;
  51.  
  52. public plugin_init()
  53. {
  54. register_plugin(PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_AUTHOR);
  55. register_cvar("zp_bank_sql", PLUGIN_VERSION, FCVAR_SERVER);
  56.  
  57. register_dictionary("zp_bank.txt");
  58. register_dictionary("common.txt");
  59.  
  60. register_clcmd("say", "handle_say");
  61. register_clcmd("say_team", "handle_say");
  62.  
  63. register_concmd("zp_bank_show", "cmdBankShow", ADMIN_ADMIN);
  64. register_concmd("zp_bank_set", "cmdBankSet", ADMIN_RCON, "<name or #userid> <+ or ->amount");
  65.  
  66. g_vars[startedammo] = get_cvar_pointer("zp_starting_ammo_packs");
  67.  
  68. register_srvcmd("zp_bank_connect", "db_connect");
  69.  
  70. register_forward(FM_ClientUserInfoChanged, "fwClientUserInfoChanged");
  71.  
  72. server_cmd("zp_bank_connect");
  73. }
  74.  
  75. public plugin_precache()
  76. {
  77. get_configsdir(g_vars[config_dir], 127);
  78.  
  79. g_vars[mode] = register_cvar("zp_bank", "1");
  80. g_vars[annonce] = register_cvar("zp_bank_annonce", "360.0");
  81. g_vars[save_limit] = register_cvar("zp_bank_save_limit", "1000");
  82. g_vars[save_days] = register_cvar("zp_bank_save_days", "24");
  83. g_vars[save_type] = register_cvar("zp_bank_save_type", "2");
  84. g_vars[block_cname] = register_cvar("zp_bank_block_name_change", "1");
  85. g_vars[allow_passwd] = register_cvar("zp_bank_allow_passwd", "1");
  86. g_vars[allow_donate] = register_cvar("zp_bank_allow_donate", "1");
  87.  
  88. register_cvar("zp_bank_host", "");
  89. register_cvar("zp_bank_user", "");
  90. register_cvar("zp_bank_pass", "");
  91. register_cvar("zp_bank_db", "");
  92. register_cvar("zp_bank_type", "mysql");
  93. register_cvar("zp_bank_table", "zp_bank");
  94. register_cvar("zp_bank_pw_str", "_bpw");
  95.  
  96. server_cmd("exec %s/zp_bank.cfg", g_vars[config_dir]);
  97. server_exec();
  98. }
  99.  
  100. public plugin_cfg()
  101. {
  102. g_vars[mode] = get_pcvar_num(g_vars[mode]);
  103. g_vars[save_limit] = get_pcvar_num(g_vars[save_limit]);
  104. g_vars[save_days] = get_pcvar_num(g_vars[save_days]);
  105. g_vars[save_type] = get_pcvar_num(g_vars[save_type]);
  106. g_vars[block_cname] = get_pcvar_num(g_vars[block_cname]);
  107. g_vars[allow_passwd] = get_pcvar_num(g_vars[allow_passwd]);
  108. g_vars[allow_donate] = get_pcvar_num(g_vars[allow_donate]);
  109.  
  110. if(g_vars[save_limit] < 0) g_vars[save_limit] = 0;
  111.  
  112. if(get_pcvar_num(g_vars[annonce]))
  113. set_task(get_pcvar_float(g_vars[annonce]), "print_annonce",_,_,_,"b");
  114.  
  115. get_cvar_string("zp_bank_pw_str", g_vars[_pw_str], 31);
  116. }
  117.  
  118. public plugin_end()
  119. {
  120. if(g_Sql != Empty_Handle) SQL_FreeHandle(g_Sql);
  121. if(g_SqlTuple != Empty_Handle) SQL_FreeHandle(g_SqlTuple);
  122. }
  123.  
  124. public zp_round_started(gamemode, id)
  125. {
  126. g_vars[round_end] = false;
  127. }
  128.  
  129. public zp_round_ended(winteam)
  130. {
  131. if (!g_vars[mode] || g_Sql == Empty_Handle)
  132. return ;
  133.  
  134. static i;
  135. for(i=1;i<=MAX_PLAYERS;i++)
  136. {
  137. if(!g_Bank[i][ingame] || !g_Bank[i][loggin] || !g_Bank[i][async])
  138. continue;
  139.  
  140. SaveClientBank(i);
  141. }
  142.  
  143. g_vars[round_end] = true;
  144. }
  145.  
  146. public client_connect(id)
  147. {
  148. if (!g_vars[mode])
  149. return ;
  150.  
  151. GetAuthId(id, g_Bank[id][auth],35);
  152.  
  153. g_Bank[id][amount] = 0;
  154. g_Bank[id][async] = false;
  155. g_Bank[id][loggin] = false;
  156.  
  157. if(g_vars[mode] == 2)
  158. zp_set_user_ammo_packs(id, get_pcvar_num(g_vars[startedammo]));
  159.  
  160. LoadClientBank(id);
  161. }
  162.  
  163. public client_putinserver(id)
  164. {
  165. g_Bank[id][ingame] = true;
  166.  
  167. if(g_Bank[id][async] == true && g_Bank[id][loggin] == true)
  168. SetAmmoBank(id, g_Bank[id][amount]);
  169. }
  170.  
  171. public client_disconnect(id)
  172. {
  173. if (!g_vars[mode] || g_Sql == Empty_Handle)
  174. return ;
  175.  
  176. if(g_vars[round_end] == false && g_Bank[id][async] == true && g_Bank[id][loggin] == true)
  177. SaveClientBank(id);
  178.  
  179. g_Bank[id][ingame] = false;
  180. g_Bank[id][auth][0] = '^0';
  181. g_Bank[id][passwd][0] = '^0';
  182. }
  183.  
  184. public cmdBankShow(id, level, cid)
  185. {
  186. if (!cmd_access(id, level, cid, 1))
  187. return PLUGIN_HANDLED;
  188.  
  189. static pl_name[32], pl_amount[11], i;
  190. console_print(id, "%33s amount","name");
  191. for(i=1;i<=MAX_PLAYERS;i++)
  192. {
  193. if(!g_Bank[i][ingame]) continue;
  194.  
  195. get_user_name(i,pl_name,31);
  196.  
  197. if(!g_Bank[i][async])
  198. pl_amount = "not loaded";
  199. else if(!g_Bank[i][loggin])
  200. pl_amount = "not loggin";
  201. else
  202. num_to_str(GetAmmoBank(i),pl_amount,10);
  203.  
  204. console_print(id, "%33s %s", pl_name, pl_amount);
  205. }
  206.  
  207. return PLUGIN_HANDLED;
  208. }
  209.  
  210. public cmdBankSet(id, level, cid)
  211. {
  212. if (!cmd_access(id, level, cid, 3))
  213. return PLUGIN_HANDLED;
  214.  
  215. static s_player[32], player, s_amount[12], i_amount;
  216. read_argv(1, s_player, 31);
  217. player = cmd_target(id, s_player, CMDTARGET_ALLOW_SELF);
  218.  
  219. if (!player)
  220. return PLUGIN_HANDLED;
  221.  
  222. get_user_name(player,s_player,31);
  223. if(!g_Bank[player][async])
  224. {
  225. console_print(id,"The player '%s' has not loaded bank", s_player);
  226. return PLUGIN_HANDLED;
  227. }
  228. else if(!g_Bank[player][loggin])
  229. {
  230. console_print(id,"The player '%s' has not loggin bank", s_player);
  231. return PLUGIN_HANDLED;
  232. }
  233.  
  234. read_argv(2, s_amount, 11);
  235. remove_quotes(s_amount);
  236. i_amount = str_to_num(s_amount);
  237.  
  238. switch(s_amount[0])
  239. {
  240. case '+':
  241. SetAmmoBank(player, GetAmmoBank(player)+i_amount);
  242. case '-':
  243. SetAmmoBank(player, GetAmmoBank(player)-(0-i_amount));
  244. default:
  245. SetAmmoBank(player,i_amount);
  246. }
  247.  
  248. return PLUGIN_HANDLED;
  249. }
  250.  
  251. public print_annonce()
  252. {
  253. if (!g_vars[mode] || g_Sql == Empty_Handle)
  254. return ;
  255.  
  256. print_color(0, "!g[Bank]!t A szerver lőszercsomag bankot használ.");
  257. if(g_vars[mode] == 1)
  258. {
  259. print_color(0, "!g[Bank]!y A berakáshoz használd a!t /deposit <érték>!y parancsot.");
  260. print_color(0, "!g[Bank]!y A kiszedéshez használd a!t /withdraw <érték>!y parancsot.");
  261. }
  262. else
  263. {
  264. print_color(0, "!g[Bank]!t A lőszercsomagjaidat automatikusan menti.");
  265. }
  266. }
  267.  
  268. public db_loadcurrent()
  269. {
  270. for(new i=1;i<=MAX_PLAYERS;i++)
  271. {
  272. if(g_Bank[i][async] || !g_Bank[i][ingame]) continue;
  273.  
  274. LoadClientBank(i);
  275. }
  276. }
  277.  
  278. public db_connect(count)
  279. {
  280. if(!g_vars[mode])
  281. return ;
  282.  
  283. new host[64], user[32], pass[32], db[128];
  284. new get_type[13], set_type[12];
  285. new error[128], errno;
  286.  
  287. get_cvar_string("zp_bank_host", host, 63);
  288. get_cvar_string("zp_bank_user", user, 31);
  289. get_cvar_string("zp_bank_pass", pass, 31);
  290. get_cvar_string("zp_bank_type", set_type, 11);
  291. get_cvar_string("zp_bank_db", db, 127);
  292. get_cvar_string("zp_bank_table", g_vars[table], 31);
  293.  
  294. if(is_module_loaded(set_type) == -1)
  295. {
  296. server_print("^r^n%s error: module '%s' not loaded.^r^n%s Add line %s to %s/modules.ini and restart server^r^n", PLUGIN_PREFIX, set_type, PLUGIN_PREFIX, set_type, g_vars[config_dir]);
  297. return ;
  298. }
  299.  
  300. SQL_GetAffinity(get_type, 12);
  301.  
  302. if (!equali(get_type, set_type))
  303. if (!SQL_SetAffinity(set_type))
  304. log_amx("Failed to set affinity from %s to %s.", get_type, set_type);
  305.  
  306. g_SqlTuple = SQL_MakeDbTuple(host, user, pass, db);
  307.  
  308. g_Sql = SQL_Connect(g_SqlTuple, errno, error, 127);
  309.  
  310. if (g_Sql == Empty_Handle)
  311. {
  312. server_print("%s SQL Error #%d - %s", PLUGIN_PREFIX, errno, error);
  313.  
  314. count += 1;
  315. set_task(10.0, "db_connect", count);
  316.  
  317. return ;
  318. }
  319.  
  320. SQL_QueryAndIgnore(g_Sql, "SET NAMES utf8");
  321.  
  322. if (equali(set_type, "sqlite") && !sqlite_TableExists(g_Sql, g_vars[table])) SQL_QueryAndIgnore(g_Sql, "CREATE TABLE %s (auth VARCHAR(36) PRIMARY KEY, password VARCHAR(32) NOT NULL DEFAULT '', amount INTEGER DEFAULT 0, timestamp INTEGER NOT NULL DEFAULT 0)",g_vars[table]);
  323. else if (equali(set_type, "mysql")) SQL_QueryAndIgnore(g_Sql,"CREATE TABLE IF NOT EXISTS `%s` (`auth` VARCHAR(36) NOT NULL, `password` VARCHAR(32) NOT NULL DEFAULT '', `amount` INT(10) NOT NULL DEFAULT 0, `timestamp` INT(10) NOT NULL DEFAULT 0, PRIMARY KEY (`auth`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;", g_vars[table]);
  324.  
  325. CleanDataBase();
  326. if(count > 1)
  327. db_loadcurrent();
  328.  
  329. server_print("%s connected to: '%s://%s:****@%s/%s/%s'",PLUGIN_PREFIX, set_type, user, host, db, g_vars[table]);
  330. }
  331.  
  332. public CleanDataBase()
  333. {
  334. SQL_QueryAndIgnore(g_Sql, "DELETE FROM %s WHERE amount='0' AND password = '';", g_vars[table]);
  335.  
  336. if (!g_vars[save_days]) return ;
  337.  
  338. new curTime = get_systime();
  339. curTime -= ((g_vars[save_days] * 24) * 3600);
  340.  
  341. SQL_QueryAndIgnore(g_Sql,"DELETE FROM %s WHERE timestamp < '%d';", g_vars[table], curTime);
  342. }
  343.  
  344. public fwClientUserInfoChanged(id, buffer)
  345. {
  346. if (!g_vars[mode] || !is_user_connected(id))
  347. return FMRES_IGNORED;
  348.  
  349. new name[32], val[32], name_1[] = "name";
  350. get_user_name(id, name, 31);
  351. engfunc(EngFunc_InfoKeyValue, buffer, name_1, val, 31);
  352. if (equal(val, name))
  353. return FMRES_IGNORED;
  354.  
  355. if(g_vars[block_cname])
  356. {
  357. engfunc(EngFunc_SetClientKeyValue, id, buffer, name_1, name);
  358. client_cmd(id, "name ^"%s^"; setinfo name ^"%s^"", name, name);
  359. console_print(id, "A nev valtas nem engedelyezett!");
  360. }
  361. else
  362. {
  363. GetAuthId(id,g_Bank[id][auth],35);
  364. return FMRES_IGNORED;
  365. }
  366.  
  367. return FMRES_SUPERCEDE;
  368. }
  369.  
  370. public handle_say(id)
  371. {
  372. if(!g_vars[mode])
  373. {
  374. print_color(id, "!g[Bank]!t A bank le van tiltva.");
  375.  
  376. return PLUGIN_CONTINUE;
  377. }
  378. else if(g_Sql == Empty_Handle)
  379. {
  380. print_color(id, "!g[Bank]!t A bank ideiglenesen nem elérhető!");
  381.  
  382. return PLUGIN_CONTINUE;
  383. }
  384. else if (!g_Bank[id][async])
  385. return PLUGIN_CONTINUE;
  386.  
  387. new text[60], command[16], command2[32], password[32], set_packs;
  388. read_args(text, 59);
  389. remove_quotes(text);
  390.  
  391. command[0] = '^0';
  392. command2[0] = '^0';
  393. password[0] = '^0';
  394. parse(text, command, 15, command2, 31, password, 31);
  395.  
  396. if (equali(command, "/", 1))
  397. format(command, 15, command[1]);
  398.  
  399. if (g_vars[allow_donate] && equali(command, "kuldes", 6))
  400. {
  401. donate(id, command2, str_to_num(password));
  402. }
  403. else if (equali(command, "mybank", 6) || equali(command, "bank", 4))
  404. {
  405. if(g_vars[save_type] == 2 && g_vars[allow_passwd])
  406. {
  407. if(equali(command2, "login", 5))
  408. {
  409. if(g_Bank[id][loggin]) {
  410. print_color(id, "!g[Bank]!t Már be vagy jelentkezve.");
  411. return PLUGIN_HANDLED;
  412. }
  413.  
  414. if(g_Bank[id][passwd][0] && equal(password, g_Bank[id][passwd]))
  415. {
  416. g_Bank[id][loggin] = true;
  417. SetAmmoBank(id, g_Bank[id][amount]);
  418. client_cmd(id, "setinfo %s ^"%s^"", g_vars[_pw_str], password);
  419. print_color(id, "!g[Bank]!t Sikeresen beléptél.");
  420. }
  421. else
  422. {
  423. print_color(id, "!g[Bank]!t Hibás jelszó.");
  424. }
  425.  
  426. return PLUGIN_HANDLED;
  427. }
  428. else if(!g_Bank[id][loggin])
  429. {
  430. print_color(id, "!g[Bank]!y Belépéshez írd a chatbe, hogy:!t /bank login <jelszavad>!y parancsot.");
  431. return PLUGIN_HANDLED;
  432. }
  433. else if(equali(command2, "password", 8))
  434. {
  435. if(password[0])
  436. {
  437. g_Bank[id][passwd] = password;
  438. client_cmd(id, "setinfo %s ^"%s^"", g_vars[_pw_str], password);
  439. print_color(id, "!g[Bank]!y Jelszó beállítva! Ne felejtsd el a jelszavad:!t %s", g_Bank[id][passwd]);
  440. }
  441. else
  442. {
  443. print_color(id, "!g[Bank]!y Jelenlegi jelszó:!t %s", g_Bank[id][passwd]);
  444. }
  445. return PLUGIN_HANDLED;
  446. }
  447. else if(!g_Bank[id][passwd][0])
  448. print_color(id, "!g[Bank]!y Jelszó beállításhoz írd a chatbe, hogy:!t /bank password <jelszo>");
  449. }
  450.  
  451. if(g_vars[mode] == 2)
  452. {
  453. print_color(id, "!g[Bank]!t A lőszercsomagjaidat automatikusan menti.");
  454. return PLUGIN_CONTINUE;
  455. }
  456.  
  457. print_color(id, "!g[Bank]!y Jelenleg!t %d!y lőszercsomagod van a bankodban.", g_Bank[id][amount]);
  458. print_color(id, "!g[Bank]!y A berakáshoz használd a!t /deposit <ertek>!y parancsot.");
  459. print_color(id, "!g[Bank]!y A kiszedéshez használd a!t /withdraw <ertek>!y parancsot.");
  460. }
  461. else if (g_vars[mode] == 2)
  462. return PLUGIN_CONTINUE;
  463. else if (equali(command, "deposit", 7) || equali(command, "send", 4) || equali(command, "store", 5))
  464. {
  465. new user_ammo_packs = zp_get_user_ammo_packs(id);
  466.  
  467. if (equali(command2, "all")) set_packs = user_ammo_packs;
  468. else set_packs = str_to_num(command2);
  469.  
  470. new limit_exceeded=false;
  471.  
  472. if (g_vars[save_limit] && set_packs > 0 && g_Bank[id][amount] + set_packs > g_vars[save_limit])
  473. {
  474. new overflow = g_Bank[id][amount] + set_packs - g_vars[save_limit];
  475. set_packs -= overflow;
  476.  
  477. print_color(id, "!g[Bank]!y Meghaladtad a megengedhető lőszercsomagot, maximum:!t %d", g_vars[save_limit]);
  478.  
  479. limit_exceeded = true;
  480. }
  481.  
  482. if (set_packs > 0)
  483. {
  484. if (user_ammo_packs >= set_packs)
  485. {
  486. g_Bank[id][amount] += set_packs;
  487. zp_set_user_ammo_packs(id, user_ammo_packs - set_packs);
  488. print_color(id, "!g[Bank]!y Beraktál!t %d$!y lőszercsomagot, jelenleg a bankodban!t %d!y lőszercsomag van.", set_packs, g_Bank[id][amount]);
  489. }
  490. else
  491. print_color(id, "!g[Bank]!y Ez!t %d!y több, mint amennyi lőszercsomag van!t %d", set_packs, user_ammo_packs);
  492.  
  493. return PLUGIN_HANDLED;
  494. }
  495. else if(!limit_exceeded)
  496. print_color(id, "!g[Bank]!y A berakáshoz használd a!t /deposit <ertek>!y parancsot.");
  497. }
  498. else if (equali(command, "withdraw", 8) || equali(command, "take", 4) || equali(command, "retrieve", 8) || equali(command, "wd", 2))
  499. {
  500. new user_ammo_packs = zp_get_user_ammo_packs(id);
  501.  
  502. if (equali(command2, "all")) set_packs = g_Bank[id][amount];
  503. else set_packs = str_to_num(command2);
  504.  
  505. if (set_packs > 0)
  506. {
  507. if (g_Bank[id][amount] >= set_packs)
  508. {
  509. zp_set_user_ammo_packs(id, user_ammo_packs + set_packs);
  510. g_Bank[id][amount] -= set_packs;
  511. print_color(id, "!g[Bank]!y Kivettél!t %d!y lőszercsomagot, már csak!t %d!y lőszercsomag van a bankodban.", set_packs, g_Bank[id][amount]);
  512. }
  513. else
  514. print_color(id, "!g[Bank]!y Ez!t %d!y több, mint amennyi a bankodban van!t %d", set_packs, g_Bank[id][amount]);
  515.  
  516. return PLUGIN_HANDLED;
  517. }
  518. else
  519. print_color(id, "!g[Bank]!y A kiszedéshez használd a!t /withdraw <ertek>!y parancsot.");
  520. }
  521.  
  522. return PLUGIN_CONTINUE;
  523. }
  524.  
  525. public donate(donater, const reciever_name[], ammo)
  526. {
  527. if(!reciever_name[0] || ammo <= 0 || zp_get_user_ammo_packs(donater) < ammo)
  528. {
  529. print_color(0, "!g[Bank]!t >>!y Lőszercsomag küldés:!t /donate <jatekos> <ertek>");
  530. return ;
  531. }
  532.  
  533. new reciever = cmd_target(donater, reciever_name, CMDTARGET_ALLOW_SELF);
  534. if (!reciever || reciever == donater)
  535. {
  536. ColorChat(0, GREEN, "[Bank]^3 %L", PLUGIN_PREFIX, LANG_PLAYER, "CL_NOT_FOUND");
  537. return ;
  538. }
  539.  
  540. zp_set_user_ammo_packs(donater, zp_get_user_ammo_packs(donater)-ammo);
  541. zp_set_user_ammo_packs(reciever, zp_get_user_ammo_packs(reciever)+ammo);
  542. }
  543.  
  544. public LoadClientBank(id)
  545. {
  546. if (g_SqlTuple == Empty_Handle || g_Sql == Empty_Handle || g_Bank[id][async] == true)
  547. return ;
  548.  
  549. new szQuery[120];
  550. format(szQuery, 119,"SELECT amount,password FROM %s WHERE auth='%s';", g_vars[table], g_Bank[id][auth]);
  551.  
  552. new szData[2];
  553. szData[0] = id;
  554. szData[1] = get_user_userid(id);
  555.  
  556. SQL_ThreadQuery(g_SqlTuple, "LoadClient_QueryHandler", szQuery, szData, 2);
  557. }
  558.  
  559. public LoadClient_QueryHandler(iFailState, Handle:hQuery, szError[], iErrnum, szData[], iSize, Float:fQueueTime)
  560. {
  561. if(iFailState != TQUERY_SUCCESS)
  562. {
  563. log_amx("%s SQL Error #%d - %s", PLUGIN_PREFIX, iErrnum, szError);
  564. return ;
  565. }
  566.  
  567. new id = szData[0];
  568.  
  569. if (szData[1] != get_user_userid(id))
  570. return ;
  571.  
  572. new packs=0,info_pw[32];
  573.  
  574. if(g_vars[mode] == 2)
  575. packs = get_pcvar_num(g_vars[startedammo]);
  576.  
  577. if(SQL_NumResults(hQuery))
  578. {
  579. packs = SQL_ReadResult(hQuery, SQL_FieldNameToNum(hQuery, "amount"));
  580. SQL_ReadResult(hQuery, SQL_FieldNameToNum(hQuery, "password"), g_Bank[id][passwd], 31);
  581. }
  582.  
  583. g_Bank[id][amount] = CheckLimit(packs);
  584. if(g_vars[allow_passwd] && g_Bank[id][passwd][0])
  585. {
  586. get_user_info(id,g_vars[_pw_str],info_pw,31);
  587. if(equal(info_pw, g_Bank[id][passwd]))
  588. {
  589. g_Bank[id][loggin] = true;
  590. }
  591. }
  592. else
  593. g_Bank[id][loggin] = true;
  594.  
  595. if(g_Bank[id][ingame] == true && g_Bank[id][loggin] == true)
  596. {
  597. SetAmmoBank(id, g_Bank[id][amount]);
  598. }
  599. g_Bank[id][async] = true;
  600. }
  601.  
  602. public SaveClientBank(id)
  603. {
  604. if (g_Sql == Empty_Handle)
  605. return ;
  606.  
  607. new packs = GetAmmoBank(id);
  608. packs = CheckLimit(packs);
  609.  
  610. SQL_QuoteString(g_Sql, g_Bank[id][passwd], 31, g_Bank[id][passwd]);
  611. SQL_QueryAndIgnore(g_Sql, "REPLACE INTO %s (auth,password,amount,timestamp) VALUES('%s', '%s', %d, %d);", g_vars[table], g_Bank[id][auth], g_Bank[id][passwd], packs, get_systime());
  612. }
  613.  
  614. stock GetAuthId(id, Buffer[]="", BufferSize=0)
  615. {
  616. switch(g_vars[save_type])
  617. {
  618. case 1: get_user_authid(id,Buffer,BufferSize);
  619. case 2:
  620. {
  621. new name[32];
  622. get_user_name(id,name,31);
  623. SQL_QuoteString(g_Sql, Buffer, BufferSize, name);
  624. }
  625. case 3: get_user_ip(id,Buffer,BufferSize,true);
  626. }
  627. }
  628.  
  629. public CheckLimit(packs)
  630. {
  631. if(g_vars[save_limit] && packs > g_vars[save_limit])
  632. {
  633. packs = g_vars[save_limit];
  634. }
  635. return packs;
  636. }
  637.  
  638. public SetAmmoBank(id, packs)
  639. {
  640. if(g_vars[mode] == 2)
  641. zp_set_user_ammo_packs(id,packs);
  642. else
  643. g_Bank[id][amount] = packs;
  644. }
  645.  
  646. public GetAmmoBank(id)
  647. {
  648. if(g_vars[mode] == 2)
  649. return zp_get_user_ammo_packs(id);
  650.  
  651. return g_Bank[id][amount];
  652. }
  653.  
  654. stock print_color(const id, const input[], any:...)
  655. {
  656.         new count = 1, players[32]
  657.         static msg[191]
  658.         vformat(msg, 190, input, 3)
  659.  
  660.         replace_all(msg, 190, "!g", "^4")
  661.         replace_all(msg, 190, "!y", "^1")
  662.         replace_all(msg, 190, "!t", "^3")
  663.         replace_all(msg, 190, "á", "á")
  664.         replace_all(msg, 190, "é", "Ă©")
  665.         replace_all(msg, 190, "í", "Ă­")
  666.         replace_all(msg, 190, "ó", "Ăł")
  667.         replace_all(msg, 190, "ö", "ö")
  668.         replace_all(msg, 190, "ő", "Ĺ‘")
  669.         replace_all(msg, 190, "ú", "Ăş")
  670.         replace_all(msg, 190, "ü", "ĂĽ")
  671.         replace_all(msg, 190, "ű", "ű")
  672.         replace_all(msg, 190, "Á", "Á")
  673.         replace_all(msg, 190, "É", "É")
  674.         replace_all(msg, 190, "Í", "ĂŤ")
  675.         replace_all(msg, 190, "Ó", "Ă“")
  676.         replace_all(msg, 190, "Ö", "Ă–")
  677.         replace_all(msg, 190, "Ő", "Ő")
  678.         replace_all(msg, 190, "Ú", "Ăš")
  679.         replace_all(msg, 190, "Ü", "Ăś")
  680.         replace_all(msg, 190, "Ű", "Ĺ°")       
  681.  
  682.         if (id) players[0] = id; else get_players(players, count, "ch")
  683.         {
  684.                 for (new i = 0; i < count; i++)
  685.                 {
  686.                         if (is_user_connected(players[i]))
  687.                         {
  688.                                 message_begin(MSG_ONE_UNRELIABLE, get_user_msgid("SayText"), _, players[i])
  689.                                 write_byte(players[i])
  690.                                 write_string(msg)
  691.                                 message_end()
  692.                         }
  693.                 }
  694.         }
  695.         return PLUGIN_HANDLED
  696. }


És le írnátok, hogy lehet javítani.
Előre is köszi.

_________________
****


Hozzászólás jelentése
Vissza a tetejére
   
Hozzászólás az előzmény idézésével  
stupid
 Hozzászólás témája: Re: Bank
HozzászólásElküldve:2013.08.26. 17:25 
Offline
Felfüggesztve

Csatlakozott:2013.08.09. 22:37
Hozzászólások:571
Megköszönt másnak: 10 alkalommal
Megköszönték neki: 85 alkalommal
SMA Forráskód: [ Mindet kijelol ]
  1. #include <colorchat>


Őőő. ezalatt most te inc. re gondolsz? de amúgy.

ColorChat(id, GREEN, "Szöveg") Ha ez volt a hiba akkor szívesen ha csak offolok akk sajnálom :D


Csatolmányok:
ColorChat.inc [2.51KiB]
Letöltve 55 alkalommal.
Hozzászólás jelentése
Vissza a tetejére
   
Hozzászólás az előzmény idézésével  
TooMuchPower
 Hozzászólás témája: Re: Bank
HozzászólásElküldve:2013.08.26. 17:38 
Offline
Lelkes
Avatar

Csatlakozott:2013.08.22. 19:45
Hozzászólások:17
Megköszönték neki: 1 alkalommal
1. A print_color-t azt beilleszted a végére vagy inc-vel?

Ha beilleszted akkor minden sor végére ; jelet kell tenni vagy csak egyszerűen kiveszed az elejéről a
SMA Forráskód: [ Mindet kijelol ]
  1. #pragma semicolon 1
-et

_________________
[kozep]Kép[/kozep]

[kozep]Dat Power! It Was OP[/kozep]


Hozzászólás jelentése
Vissza a tetejére
   
Hozzászólás az előzmény idézésével  
InFeCt
 Hozzászólás témája: Re: Bank
HozzászólásElküldve:2013.08.26. 17:47 
Offline
Tud valamit
Avatar

Csatlakozott:2013.07.01. 23:32
Hozzászólások:122
Megköszönt másnak: 1 alkalommal
Megköszönték neki: 23 alkalommal
Szia Ittvan! :D Igaz hogy az "Angol Verzio" de remekül fut :D am "Txt-ben vannak a szövegek" :)
SMA Forráskód: [ Mindet kijelol ]
  1.  
  2. #include <amxmodx>
  3. #include <amxmisc>
  4. #include <fakemeta>
  5. #include <sqlx>
  6. #include <zombieplague>
  7. #include <colorchat>
  8.  
  9. #define MAX_PLAYERS 32
  10.  
  11. new PLUGIN_NAME[] = "[ZP]Addons: Bank SQL";
  12. new PLUGIN_VERSION[] = "0.9";
  13. new PLUGIN_AUTHOR[] = "Epmak";
  14. new PLUGIN_PREFIX[] = "[ZP][Bank]";
  15.  
  16. enum vars_struct {
  17. 	mode=0,
  18. 	annonce,
  19.  
  20. 	save_limit,
  21. 	save_days,
  22. 	save_type,
  23.  
  24. 	block_cname,
  25. 	startedammo,
  26. 	allow_passwd,
  27. 	allow_donate,
  28.  
  29. 	_pw_str[32],
  30. 	table[32],
  31. 	config_dir[128]
  32. };
  33.  
  34. enum bank_struct {
  35. 	bool:ingame,
  36. 	bool:async,
  37. 	bool:loggin,
  38. 	auth[36],
  39. 	passwd[32],
  40. 	amount
  41. }
  42.  
  43. new g_vars[vars_struct];
  44. new g_Bank[MAX_PLAYERS+1][bank_struct];
  45. new Handle:g_Sql = Empty_Handle,Handle:g_SqlTuple = Empty_Handle;
  46.  
  47. public plugin_init() {
  48. 	register_plugin(PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_AUTHOR);
  49. 	register_cvar("zp_bank_sql", PLUGIN_VERSION, FCVAR_SERVER);
  50.  
  51. 	register_dictionary("zp_bank.txt");
  52. 	register_dictionary("common.txt");
  53.  
  54. 	register_clcmd("say", "handle_say");
  55. 	register_clcmd("say_team", "handle_say");
  56.  
  57. 	register_concmd("zp_bank_show", "cmdBankShow", ADMIN_ADMIN);
  58. 	register_concmd("zp_bank_set", "cmdBankSet", ADMIN_RCON, "<name or #userid> <+ or ->amount");
  59.  
  60. 	register_srvcmd("zp_bank_connect", "db_connect");
  61.  
  62. 	g_vars[startedammo] = get_cvar_pointer("zp_starting_ammo_packs");
  63.  
  64. 	register_forward(FM_ClientUserInfoChanged, "fwClientUserInfoChanged");
  65.  
  66. 	server_cmd("zp_bank_connect");
  67. }
  68.  
  69. public plugin_precache() {
  70. 	get_configsdir(g_vars[config_dir], 127);
  71.  
  72. 	g_vars[mode] = register_cvar("zp_bank", "1");
  73. 	g_vars[annonce] = register_cvar("zp_bank_annonce", "360.0");
  74. 	g_vars[save_limit] = register_cvar("zp_bank_save_limit", "1000");
  75. 	g_vars[save_days] = register_cvar("zp_bank_save_days", "24");
  76. 	g_vars[save_type] = register_cvar("zp_bank_save_type", "2");
  77. 	g_vars[block_cname] = register_cvar("zp_bank_block_name_change", "1");
  78. 	g_vars[allow_passwd] = register_cvar("zp_bank_allow_passwd", "1");
  79. 	g_vars[allow_donate] = register_cvar("zp_bank_allow_donate", "1");
  80.  
  81. 	register_cvar("zp_bank_host", "127.0.0.1");
  82. 	register_cvar("zp_bank_user", "root");
  83. 	register_cvar("zp_bank_pass", "");
  84. 	register_cvar("zp_bank_db", "amxx");
  85. 	register_cvar("zp_bank_type", "mysql");
  86. 	register_cvar("zp_bank_table", "zp_bank");
  87. 	register_cvar("zp_bank_pw_str", "_bpw");
  88.  
  89. 	server_cmd("exec %s/zp_bank.cfg", g_vars[config_dir]);
  90. 	server_exec();
  91. }
  92.  
  93. public plugin_cfg() {
  94. 	g_vars[mode] = get_pcvar_num(g_vars[mode]);
  95. 	g_vars[save_limit] = get_pcvar_num(g_vars[save_limit]);
  96. 	g_vars[save_days] = get_pcvar_num(g_vars[save_days]);
  97. 	g_vars[save_type] = get_pcvar_num(g_vars[save_type]);
  98. 	g_vars[block_cname] = get_pcvar_num(g_vars[block_cname]);
  99. 	g_vars[allow_passwd] = get_pcvar_num(g_vars[allow_passwd]);
  100. 	g_vars[allow_donate] = get_pcvar_num(g_vars[allow_donate]);
  101.  
  102. 	if(g_vars[save_limit] < 0) g_vars[save_limit] = 0;
  103.  
  104. 	if(get_pcvar_num(g_vars[annonce])) set_task(get_pcvar_float(g_vars[annonce]), "print_annonce",_,_,_,"b");
  105.  
  106. 	get_cvar_string("zp_bank_pw_str", g_vars[_pw_str], 31);
  107. } 
  108.  
  109. public plugin_end() {
  110. 	if(g_Sql != Empty_Handle) SQL_FreeHandle(g_Sql);
  111. 	if(g_SqlTuple != Empty_Handle) SQL_FreeHandle(g_SqlTuple);
  112. }
  113.  
  114. public zp_round_started(zpmode, id) {
  115. 	if (!g_vars[mode] || g_Sql == Empty_Handle)
  116. 		return ;
  117.  
  118. 	static i;
  119. 	for(i=1;i<=MAX_PLAYERS;i++) {
  120. 		if(!g_Bank[i][ingame] || !g_Bank[i][loggin] || !g_Bank[i][async]) continue;
  121.  
  122. 		SaveClientBank(i);
  123. 	}
  124. }
  125.  
  126. public client_authorized(id) {
  127. 	if (!g_vars[mode])
  128. 		return ;
  129.  
  130. 	GetAuthId(id,g_Bank[id][auth],35);
  131.  
  132. 	g_Bank[id][amount] = 0;
  133. 	g_Bank[id][async] = false;
  134. 	g_Bank[id][loggin] = false;
  135.  
  136. 	if(g_vars[mode] == 2)
  137. 		zp_set_user_ammo_packs(id, get_pcvar_num(g_vars[startedammo]));
  138.  
  139. 	LoadClientBank(id);
  140. }
  141.  
  142. public client_putinserver(id) {
  143. 	g_Bank[id][ingame] = true;
  144.  
  145. 	if(g_Bank[id][async] == true && g_Bank[id][loggin] == true)
  146. 		SetAmmoBank(id, g_Bank[id][amount]);
  147. }
  148.  
  149. public client_disconnect(id) {
  150. 	if (!g_vars[mode] || g_Sql == Empty_Handle)
  151. 		return ;
  152.  
  153. 	if(g_Bank[id][async] == true && g_Bank[id][loggin] == true)
  154. 		SaveClientBank(id);
  155.  
  156. 	g_Bank[id][ingame] = false;
  157. 	g_Bank[id][auth][0] = '^0';
  158. 	g_Bank[id][passwd][0] = '^0';
  159. }
  160.  
  161. public cmdBankShow(id, level, cid) {
  162. 	if (!cmd_access(id, level, cid, 1))
  163. 		return PLUGIN_HANDLED;
  164.  
  165. 	static pl_name[32], pl_amount[11], i;
  166. 	console_print(id, "%33s amount","name");
  167. 	for(i=1;i<=MAX_PLAYERS;i++) {
  168. 		if(!g_Bank[i][ingame]) continue;
  169.  
  170. 		get_user_name(i,pl_name,31);
  171.  
  172. 		if(!g_Bank[i][async])
  173. 			pl_amount = "not loaded";
  174. 		else if(!g_Bank[i][loggin])
  175. 			pl_amount = "not loggin";
  176. 		else
  177. 			num_to_str(GetAmmoBank(i),pl_amount,10);
  178.  
  179. 		console_print(id, "%33s %s", pl_name, pl_amount);
  180. 	}
  181.  
  182. 	return PLUGIN_HANDLED;
  183. }
  184.  
  185. public cmdBankSet(id, level, cid) {
  186. 	if (!cmd_access(id, level, cid, 3))
  187. 		return PLUGIN_HANDLED;
  188.  
  189. 	static s_player[32], player, s_amount[12], i_amount;
  190. 	read_argv(1, s_player, 31);
  191. 	player = cmd_target(id, s_player, CMDTARGET_ALLOW_SELF);
  192.  
  193. 	if (!player)
  194. 		return PLUGIN_HANDLED;
  195.  
  196. 	get_user_name(player,s_player,31);
  197. 	if(!g_Bank[player][async]) {
  198. 		console_print(id,"The player '%s' has not loaded bank", s_player);
  199. 		return PLUGIN_HANDLED;
  200. 	}
  201. 	else if(!g_Bank[player][loggin]) {
  202. 		console_print(id,"The player '%s' has not loggin bank", s_player);
  203. 		return PLUGIN_HANDLED;
  204. 	}
  205.  
  206. 	read_argv(2, s_amount, 11);
  207. 	remove_quotes(s_amount);
  208. 	i_amount = str_to_num(s_amount);
  209.  
  210. 	switch(s_amount[0]) {
  211. 		case '+':
  212. 			SetAmmoBank(player, GetAmmoBank(player)+i_amount);
  213. 		case '-':
  214. 			SetAmmoBank(player, GetAmmoBank(player)-(0-i_amount));
  215. 		default:
  216. 			SetAmmoBank(player,i_amount);
  217. 	}
  218.  
  219. 	return PLUGIN_HANDLED;
  220. }
  221.  
  222. public print_annonce() {
  223. 	if (!g_vars[mode] || g_Sql == Empty_Handle)
  224. 		return ;
  225.  
  226. 	colorChat(0, CHATCOLOR_GREY, "%L", LANG_PLAYER, "BANK_ANNOUNCE1");
  227. 	if(g_vars[mode] == 1) {
  228. 		colorChat(0, CHATCOLOR_GREY, "%L", LANG_PLAYER, "BANK_ANNOUNCE2");
  229. 		colorChat(0, CHATCOLOR_GREY, "%L", LANG_PLAYER, "BANK_ANNOUNCE3");
  230. 	}
  231. }
  232.  
  233. public db_loadcurrent() {
  234. 	for(new i=1;i<=MAX_PLAYERS;i++) {
  235. 		if(g_Bank[i][async] || !g_Bank[i][ingame]) continue;
  236.  
  237. 		LoadClientBank(i);
  238. 	}
  239. }
  240.  
  241. public db_connect(count) {
  242. 	if(!g_vars[mode]) return ;
  243.  
  244. 	new host[64], user[32], pass[32], db[128];
  245. 	new get_type[13], set_type[12];
  246. 	new error[128], errno;
  247.  
  248. 	get_cvar_string("zp_bank_host", host, 63);
  249. 	get_cvar_string("zp_bank_user", user, 31);
  250. 	get_cvar_string("zp_bank_pass", pass, 31);
  251. 	get_cvar_string("zp_bank_type", set_type, 11);
  252. 	get_cvar_string("zp_bank_db", db, 127);
  253. 	get_cvar_string("zp_bank_table", g_vars[table], 31);
  254.  
  255. 	if(is_module_loaded(set_type) == -1) {
  256. 		server_print("^r^n%s error: module '%s' not loaded.^r^n%s Add line %s to %s/modules.ini and restart server^r^n", PLUGIN_PREFIX, set_type, PLUGIN_PREFIX, set_type, g_vars[config_dir]);
  257. 		return ;
  258. 	}
  259.  
  260. 	SQL_GetAffinity(get_type, 12);
  261.  
  262. 	if (!equali(get_type, set_type))
  263. 		if (!SQL_SetAffinity(set_type))
  264. 			log_amx("Failed to set affinity from %s to %s.", get_type, set_type);
  265.  
  266. 	g_SqlTuple = SQL_MakeDbTuple(host, user, pass, db);
  267.  
  268. 	g_Sql = SQL_Connect(g_SqlTuple, errno, error, 127);
  269.  
  270. 	if (g_Sql == Empty_Handle) {
  271. 		server_print("%s SQL Error #%d - %s", PLUGIN_PREFIX, errno, error);
  272.  
  273. 		count += 1;
  274. 		set_task(10.0, "db_connect", count);
  275.  
  276. 		return ;
  277. 	}
  278.  
  279. 	SQL_QueryAndIgnore(g_Sql, "SET NAMES utf8");
  280.  
  281. 	if (equali(set_type, "sqlite") && !sqlite_TableExists(g_Sql, g_vars[table])) SQL_QueryAndIgnore(g_Sql, "CREATE TABLE ^"%s^" (^"auth^" VARCHAR NOT NULL PRIMARY KEY, ^"password^" VARCHAR NOT NULL DEFAULT '', ^"amount^" INTEGER DEFAULT 0, ^"timestamp^" INTEGER NOT NULL DEFAULT 0)",g_vars[table]);
  282. 	else if (equali(set_type, "mysql")) SQL_QueryAndIgnore(g_Sql,"CREATE TABLE IF NOT EXISTS `%s` (auth VARCHAR(36) NOT NULL PRIMARY KEY, password VARCHAR(36) NOT NULL DEFAULT '', amount INT(10) NOT NULL DEFAULT 0, timestamp INT(10) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;", g_vars[table]);
  283.  
  284. 	CleanDataBase();
  285. 	if(count > 1) db_loadcurrent();
  286.  
  287. 	server_print("%s connected to: '%s://%s:****@%s/%s/%s'",PLUGIN_PREFIX, set_type, user, host, db, g_vars[table]);
  288. }
  289.  
  290. public CleanDataBase() {
  291. 	SQL_QueryAndIgnore(g_Sql, "DELETE FROM %s WHERE amount='0' AND password = '';", g_vars[table]);
  292.  
  293. 	if (!g_vars[save_days]) return ;
  294.  
  295. 	new curTime = get_systime();
  296. 	curTime -= ((g_vars[save_days] * 24) * 3600);
  297.  
  298. 	SQL_QueryAndIgnore(g_Sql,"DELETE FROM %s WHERE timestamp < '%d';", g_vars[table], curTime);
  299. }
  300.  
  301. public fwClientUserInfoChanged(id, buffer) {
  302. 	if (!g_vars[mode] || !is_user_connected(id))
  303. 		return FMRES_IGNORED;
  304.  
  305. 	new name[32], val[32], name_1[] = "name";
  306. 	get_user_name(id, name, 31);
  307. 	engfunc(EngFunc_InfoKeyValue, buffer, name_1, val, 31);
  308. 	if (equal(val, name))
  309. 		return FMRES_IGNORED;
  310.  
  311. 	if(g_vars[block_cname]) {
  312. 		engfunc(EngFunc_SetClientKeyValue, id, buffer, name_1, name);
  313. 		client_cmd(id, "name ^"%s^"; setinfo name ^"%s^"", name, name);
  314. 		console_print(id, "%L", id ,"NO_NAME_CHANGE");
  315. 	}
  316. 	else {
  317. 		GetAuthId(id,g_Bank[id][auth],35);
  318. 		return FMRES_IGNORED;
  319. 	}
  320.  
  321. 	return FMRES_SUPERCEDE;
  322. }
  323.  
  324. public handle_say(id) {
  325. 	if(!g_vars[mode]) {
  326. 		colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_DISABLED");
  327.  
  328. 		return PLUGIN_CONTINUE;
  329. 	}
  330. 	else if(g_Sql == Empty_Handle) {
  331. 		colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_ERR");
  332.  
  333. 		return PLUGIN_CONTINUE;
  334. 	}
  335. 	else if (!g_Bank[id][async])
  336. 		return PLUGIN_CONTINUE;
  337.  
  338. 	new text[60], command[16], command2[32], password[32], set_packs;
  339. 	read_args(text, 59);
  340. 	remove_quotes(text);
  341.  
  342. 	command[0] = '^0';
  343. 	command2[0] = '^0';
  344. 	password[0] = '^0';
  345. 	parse(text, command, 15, command2, 31, password, 31);
  346.  
  347. 	if (equali(command, "/", 1))
  348. 		format(command, 15, command[1]);
  349.  
  350. 	if (g_vars[allow_donate] && equali(command, "donate", 6)) {
  351. 		donate(id, command2, str_to_num(password));
  352. 	}
  353. 	else if (equali(command, "mybank", 6) || equali(command, "bank", 4)) {
  354. 		if(g_vars[save_type] == 2 && g_vars[allow_passwd]) {
  355. 			if(equali(command2, "login", 5)) {
  356. 				if(g_Bank[id][loggin]) {
  357. 					colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_LOGIN_ALREADY");
  358. 					return PLUGIN_HANDLED;
  359. 				}
  360.  
  361. 				if(g_Bank[id][passwd][0] && equal(password, g_Bank[id][passwd])) {
  362. 					g_Bank[id][loggin] = true;
  363. 					SetAmmoBank(id, g_Bank[id][amount]);
  364. 					client_cmd(id, "setinfo %s ^"%s^"", g_vars[_pw_str], password);
  365. 					colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_LOGIN_SUCCESS");
  366. 				}
  367. 				else {
  368. 					colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_LOGIN_BAD");
  369. 				}
  370.  
  371. 				return PLUGIN_HANDLED;
  372. 			}
  373. 			else if(!g_Bank[id][loggin]) {
  374. 				colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_LOGIN");
  375. 				return PLUGIN_HANDLED;
  376. 			}
  377. 			else if(equali(command2, "password", 8)) {
  378. 				if(password[0]) {
  379. 					g_Bank[id][passwd] = password;
  380. 					client_cmd(id, "setinfo %s ^"%s^"", g_vars[_pw_str], password);
  381. 					colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_LOGIN_PASSWORD_SET", g_Bank[id][passwd]);
  382. 				}
  383. 				else {
  384. 					colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_LOGIN_PASSWORD", g_Bank[id][passwd]);
  385. 				}
  386. 				return PLUGIN_HANDLED;
  387. 			}
  388. 			else if(!g_Bank[id][passwd][0])
  389. 				colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_LOGIN_PASSWORD_SETHELP");
  390. 		}
  391.  
  392. 		if(g_vars[mode] == 2)
  393. 			return PLUGIN_CONTINUE;
  394.  
  395. 		colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK", g_Bank[id][amount]);	
  396. 		colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_ANNOUNCE2");
  397. 		colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_ANNOUNCE3");
  398. 	}
  399. 	else if (g_vars[mode] == 2)
  400. 		return PLUGIN_CONTINUE;
  401. 	else if (equali(command, "deposit", 7) || equali(command, "send", 4) || equali(command, "store", 5)) {
  402. 		new user_ammo_packs = zp_get_user_ammo_packs(id);
  403.  
  404. 		if (equali(command2, "all")) set_packs = user_ammo_packs;
  405. 		else set_packs = str_to_num(command2);
  406.  
  407. 		new limit_exceeded=false;
  408.  
  409. 		if (g_vars[save_limit] && set_packs > 0 && g_Bank[id][amount] + set_packs > g_vars[save_limit]) {
  410.  
  411. 			new overflow = g_Bank[id][amount] + set_packs - g_vars[save_limit];
  412. 			set_packs -= overflow;
  413.  
  414. 			colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "DEPOSIT_MAX", g_vars[save_limit]);
  415.  
  416. 			limit_exceeded = true;
  417. 		}
  418.  
  419. 		if (set_packs > 0) {
  420. 			if (user_ammo_packs >= set_packs) {
  421. 				g_Bank[id][amount] += set_packs;
  422. 				zp_set_user_ammo_packs(id, user_ammo_packs - set_packs);
  423. 				colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "DEPOSIT", set_packs, g_Bank[id][amount]);
  424. 			}
  425. 			else
  426. 				colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "DEPOSIT_ERR", set_packs, user_ammo_packs);
  427.  
  428. 			return PLUGIN_HANDLED;
  429. 		}
  430. 		else if(!limit_exceeded)
  431. 			colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_ANNOUNCE2");
  432. 	}
  433. 	else if (equali(command, "withdraw", 8) || equali(command, "take", 4) || equali(command, "retrieve", 8) || equali(command, "wd", 2)) {
  434. 		new user_ammo_packs = zp_get_user_ammo_packs(id);
  435.  
  436. 		if (equali(command2, "all")) set_packs = g_Bank[id][amount];
  437. 		else set_packs = str_to_num(command2);
  438.  
  439. 		if (set_packs > 0) {
  440. 			if (g_Bank[id][amount] >= set_packs) {
  441. 				zp_set_user_ammo_packs(id, user_ammo_packs + set_packs);
  442. 				g_Bank[id][amount] -= set_packs;
  443. 				colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "WITHDRAW", set_packs, g_Bank[id][amount]);
  444. 			}
  445. 			else
  446. 				colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "WITHDRAW_ERR", set_packs, g_Bank[id][amount]);
  447.  
  448. 			return PLUGIN_HANDLED;
  449. 		}
  450. 		else
  451. 			colorChat(id, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_ANNOUNCE3");
  452. 	}
  453.  
  454. 	return PLUGIN_CONTINUE;
  455. }
  456.  
  457. public donate(donater, const reciever_name[], ammo) {
  458.  
  459. 	if(!reciever_name[0] || ammo <= 0) {
  460. 		colorChat(donater, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_DONATE_USAGE");
  461. 		return ;
  462. 	}
  463.  
  464. 	if(zp_get_user_ammo_packs(donater) <= 0) {
  465. 		colorChat(donater, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "BANK_DONATE_USAGE");
  466. 		return ;
  467. 	}
  468.  
  469. 	new reciever = cmd_target(donater, reciever_name, CMDTARGET_ALLOW_SELF);
  470. 	if (!reciever || reciever == donater) {
  471. 		colorChat(donater, CHATCOLOR_GREY, "$g%s$t %L", PLUGIN_PREFIX, LANG_PLAYER, "CL_NOT_FOUND");	
  472. 		return ;
  473. 	}
  474.  
  475. 	zp_set_user_ammo_packs(donater, zp_get_user_ammo_packs(donater)-ammo);
  476. 	zp_set_user_ammo_packs(reciever, zp_get_user_ammo_packs(reciever)+ammo);
  477. }
  478.  
  479. public LoadClientBank(id) {
  480. 	if (g_SqlTuple == Empty_Handle || g_Sql == Empty_Handle || g_Bank[id][async] == true) return ;
  481.  
  482. 	new szQuery[120];
  483. 	format(szQuery, 119,"SELECT amount,password FROM %s WHERE auth='%s';", g_vars[table], g_Bank[id][auth]);
  484.  
  485. 	new szData[2];
  486. 	szData[0] = id;
  487. 	szData[1] = get_user_userid(id);
  488.  
  489. 	SQL_ThreadQuery(g_SqlTuple, "LoadClient_QueryHandler", szQuery, szData, 2);
  490. }
  491.  
  492. public LoadClient_QueryHandler(iFailState, Handle:hQuery, szError[], iErrnum, szData[], iSize, Float:fQueueTime) {
  493. 	if(iFailState != TQUERY_SUCCESS) {
  494. 		log_amx("%s SQL Error #%d - %s", PLUGIN_PREFIX, iErrnum, szError);
  495. 		return ;
  496. 	}
  497.  
  498. 	new id = szData[0];
  499.  
  500. 	if (szData[1] != get_user_userid(id))
  501. 		return ;
  502.  
  503. 	new packs=0,info_pw[32];
  504.  
  505. 	if(g_vars[mode] == 2)
  506. 		packs = get_pcvar_num(g_vars[startedammo]);
  507.  
  508. 	if(SQL_NumResults(hQuery)) {
  509. 		packs = SQL_ReadResult(hQuery, SQL_FieldNameToNum(hQuery, "amount"));
  510. 		SQL_ReadResult(hQuery, SQL_FieldNameToNum(hQuery, "password"), g_Bank[id][passwd], 31);
  511. 	}
  512.  
  513. 	g_Bank[id][amount] = CheckLimit(packs);
  514. 	if(g_vars[allow_passwd] && g_Bank[id][passwd][0]) {
  515. 		get_user_info(id,g_vars[_pw_str],info_pw,31);
  516. 		if(equal(info_pw, g_Bank[id][passwd])) {
  517. 			g_Bank[id][loggin] = true;
  518. 		}
  519. 	}
  520. 	else
  521. 		g_Bank[id][loggin] = true;
  522.  
  523. 	if(g_Bank[id][ingame] == true && g_Bank[id][loggin] == true) {
  524. 		SetAmmoBank(id, g_Bank[id][amount]);
  525. 	}
  526. 	g_Bank[id][async] = true;
  527. }
  528.  
  529. public SaveClientBank(id) {
  530. 	if (g_Sql == Empty_Handle) return ;
  531.  
  532. 	new packs = GetAmmoBank(id);
  533. 	packs = CheckLimit(packs);
  534.  
  535. 	SQL_QuoteString(g_Sql, g_Bank[id][passwd], 31, g_Bank[id][passwd]);
  536. 	SQL_QueryAndIgnore(g_Sql, "REPLACE INTO %s (auth,password,amount,timestamp) VALUES('%s', '%s', %d, %d);", g_vars[table], g_Bank[id][auth], g_Bank[id][passwd], packs, get_systime());
  537. }
  538.  
  539. stock GetAuthId(id, Buffer[]="", BufferSize=0) {
  540. 	switch(g_vars[save_type]) {
  541. 		case 1: get_user_authid(id,Buffer,BufferSize);
  542. 		case 2: {
  543. 			new name[32];
  544. 			get_user_name(id,name,31);
  545. 			SQL_QuoteString(g_Sql, Buffer, BufferSize, name);
  546. 		}
  547. 		case 3: get_user_ip(id,Buffer,BufferSize,true);
  548. 	}
  549. }
  550.  
  551. public CheckLimit(packs) {
  552. 	if(g_vars[save_limit] && packs > g_vars[save_limit]) {
  553. 		packs = g_vars[save_limit];
  554. 	}
  555. 	return packs;
  556. }
  557.  
  558. public SetAmmoBank(id, packs) {
  559. 	if(g_vars[mode] == 2)
  560. 		zp_set_user_ammo_packs(id,packs);
  561. 	else
  562. 		g_Bank[id][amount] = packs;
  563. }
  564.  
  565. public GetAmmoBank(id) {
  566. 	if(g_vars[mode] == 2)
  567. 		return zp_get_user_ammo_packs(id);
  568.  
  569. 	return g_Bank[id][amount];
  570. }
  571.  


Csatolmányok:
Magyarázat:Ebben Megtalálod a txt-t stb....!
zp_bank_sql_0.9.zip [35.31KiB]
Letöltve 54 alkalommal.

_________________
Kép
Hozzászólás jelentése
Vissza a tetejére
   
Hozzászólás az előzmény idézésével  
pixxa112
 Hozzászólás témája: Re: Bank
HozzászólásElküldve:2013.08.27. 04:54 
Offline
Őskövület
Avatar

Csatlakozott:2011.12.28. 00:35
Hozzászólások:2736
Megköszönt másnak: 56 alkalommal
Megköszönték neki: 275 alkalommal
Köszi mindenkinek, de egyikkel se fut le.
Angol meg nem kell, mert amint látod a txt fájlt kivettem.
Se a colorchat nem kell.

_________________
****


Hozzászólás jelentése
Vissza a tetejére
   
Hozzászólás az előzmény idézésével  
Hozzászólások megjelenítése: Rendezés 
Új téma nyitása Hozzászólás a témához  Oldal: 1 / 1
  [5 hozzászólás ] 

» » »


Ki van itt

Jelenlévő fórumozók: nincs regisztrált felhasználó valamint 10 vendég

Nyithatsz új témákat ebben a fórumban.
Válaszolhatsz egy témára ebben a fórumban.
Nem szerkesztheted a hozzászólásaidat ebben a fórumban.
Nem törölheted a hozzászólásaidat ebben a fórumban.
Nem küldhetsz csatolmányokat ebben a fórumban.

Keresés:
Ugrás:  
Powered by phpBB® Forum Software © phpBB Limited
Magyar fordítás © Magyar phpBB Közösség
Portal: Kiss Portal Extension © Michael O'Toole