Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #if !defined _samp_included
- #error samp is not included
- #endif
- #if defined _AKA
- #endinput
- #endif
- #define _AKA
- static DB:database;
- LoadAKADatabase()
- {
- database = db_open("aka.db");
- db_query(database,"CREATE TABLE IF NOT EXISTS `akas` (`Username`,`Ip`)");
- }
- InitOnConnect(playerid)
- {
- if(IsPlayerNPC(playerid)) return 1;
- new ip[16],name[MAX_PLAYER_NAME],DBResult:result,string[128];
- GetPlayerIp(playerid,ip,16);
- GetPlayerName(playerid,name,MAX_PLAYER_NAME);
- format(string,sizeof(string),"SELECT `Ip` FROM `akas` WHERE `Username`='%s'",name);
- result = db_query(database,string);
- switch(db_num_rows(result))
- {
- case 0: format(string,sizeof(string),"INSERT INTO `akas` (`Username`,`Ip`) VALUES ('%s','%s')",name,ip);
- default: format(string,sizeof(string),"UPDATE `akas` SET `Ip`='%s' WHERE `Username`='%s'",ip,name);
- }
- db_free_result(result);
- db_query(database,string);
- return 1;
- }
- stock AKA(playerid,tmp[][],const size=sizeof(tmp))
- {
- new ip[16],name[MAX_PLAYER_NAME],DBResult:result,string[128],rows;
- GetPlayerIp(playerid,ip,16);
- GetPlayerName(playerid,name,MAX_PLAYER_NAME);
- format(string,sizeof(string),"SELECT `Username` FROM `akas` WHERE `Ip`='%s'",ip);
- result = db_query(database,string);
- rows = db_num_rows(result);
- if(rows>1)
- {
- for(new i,j; i<rows; i++)
- {
- if(j==size) break;
- db_get_field(result,0,tmp[j++],MAX_PLAYER_NAME);
- db_next_row(result);
- }
- }
- return db_free_result(result);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement