[Include] Also Know As-(AKA) system

[Include] Also Know As-(AKA) system - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+---- Forum: Includes (https://sampforum.blast.hk/forumdisplay.php?fid=83)
+---- Thread: [Include] Also Know As-(AKA) system (/showthread.php?tid=614762)

Also Know As-(AKA) system - xTURBOx - 12.08.2016

Introduction
AKA(Alias) include allows to retrieve the names of different accounts on the same ip(very easily)

Why did i make this?
Few months ago i wanted a aka system, i could not find one, so i thought why not make one and today i finally got enough free time to make one...

Features
-Uses SQLite for storing AKA data
-Simple and Easy
-You can choose the maximum number of names retrieved from database

How to use?

Put "#include <aka>" under samp include
Put "LoadAKADatabase();" Under "OnGameModeInt"(or "FilterscriptInit" , if you want to use it in a filterscript)
Put "InitAKAOnConnect(playerid);" under "OnPlayerConnect"
Then use the function "AKA" to retrieve the multiple accounts where needed

Usage Examples
Command

PHP код:



CMD:aka(playerid,params[])  

{  

    new pID;  

    if(!sscanf(params,"u",pID)) return SendClientMessage(playerid,-1,"/aka (playerid)");  

    if(!IsPlayerConnected(pID)) return SendClientMessage(playerid,-1,"Invalid playerid");  

    new accounts[*][MAX_PLAYER_NAME],string[256]; //change * to the maximum number of names you want to retrieve.

    AKA(playerid,accounts);  

    if(accounts[0][0] == '\0') return SendClientMessage(playerid,-1,"This Player has no mutli accounts!");  

    for(new i; i<sizeof(accounts); i++)  

    {  

        if(accounts[i][0] == '\0') break;  

        format(string,sizeof(string),"%sPlayerName: %s\n",string,accounts[i]);  

    }  

    return ShowPlayerDialog(playerid,999,DIALOG_STYLE_MSGBOX,"All Player Accounts",string,!"Okay",!"");  

}

Example Filterscript
coming soon

Download V1.0

PHP код:



#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`)");

}


InitAKAOnConnect(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,accs[][],const size=sizeof(accs))

{

    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,accs[j++],MAX_PLAYER_NAME);

            db_next_row(result);

        }

    }

    return db_free_result(result);

}

Re: Also Know As-(AKA) system - oMa37 - 12.08.2016

If it's MySQL I would use it. =/
Anyway, Good job.

Re: Also Know As-(AKA) system - Crayder - 12.08.2016

Quote:

Originally Posted by oMa37

If it's MySQL I would use it. =/
Anyway, Good job.

So make your own personal version. This system is meant to be a localized system.

Re: Also Know As-(AKA) system - Stinged - 12.08.2016

You should escape the player names (%q), or else an SQL Injection might occur.

Also, read this: https://sampforum.blast.hk/showthread.php?tid=570910
If you convert to that (Which would eliminate the need to add stuff to the script like InitAKA and LoadAKA),
make sure to check if FILTERSCRIPT is defined, so you'd do it under OnFilterScriptInit, if not, under OnGameModeInit

Re: Also Know As-(AKA) system - Gammix - 12.08.2016

http://forum.sa-mp.com/showpost.php?...postcount=4569

Use ipmatch to detect similar IPs, because this is the main purpose of AKA. Your code just checks accounts registered on same IPs not similar.

So in case of IP match, you have to: go through all rows > get their IP > use ipmatch > store matched ones.

Re: Also Know As-(AKA) system - xTURBOx - 14.08.2016

Quote:

Originally Posted by oMa37

If it's MySQL I would use it. =/
Anyway, Good job.

Why so?
I don't think the data stored in the db needed to be retrieved by another application

Quote:

Originally Posted by Stinged

You should escape the player names (%q), or else an SQL Injection might occur.

Also, read this: https://sampforum.blast.hk/showthread.php?tid=570910
If you convert to that (Which would eliminate the need to add stuff to the script like InitAKA and LoadAKA),
make sure to check if FILTERSCRIPT is defined, so you'd do it under OnFilterScriptInit, if not, under OnGameModeInit

Thanks I will improve this

Quote:

Originally Posted by Gammix

http://forum.sa-mp.com/showpost.php?...postcount=4569

Use ipmatch to detect similar IPs, because this is the main purpose of AKA. Your code just checks accounts registered on same IPs not similar.

So in case of IP match, you have to: go through all rows > get their IP > use ipmatch > store matched ones.

okay thanks..

Thanks all

Respuesta: Also Know As-(AKA) system - Franco33 - 23.09.2016

filtercript please!!!

Re: Also Know As-(AKA) system - vannesenn - 24.09.2016

Why you don't use GPCI?

Re: Also Know As-(AKA) system - SickAttack - 24.09.2016

Quote:

Originally Posted by vannesenn

Why you don't use GPCI?

It isn't accurate.

Re: Also Know As-(AKA) system - Richie - 24.09.2016

Quote:

Originally Posted by SickAttack

It isn't accurate.

More accurate when combined with IP, compared to IP only.

Respuesta: Also Know As-(AKA) system - !R1Ch@rD! - 15.10.2016

SOLVED!