brhZQpP5

1function MacAddAlias(player)
2{
3local q = QuerySQL( db, "SELECT * FROM UIDAlias WHERE UID='" + player.UniqueID + "'" );
4if ( GetSQLColumnData( q,0 ) == player.UniqueID )
5{
6if ( GetSQLColumnData( q,1 ).find(player.Name) == null )
7{
8local Fk = GetSQLColumnData( q,1 )
9local mose = Fk + ", " + player.Name
10QuerySQL(db, "UPDATE UIDAlias SET Name='" + mose + "' WHERE UID= '" + player.UniqueID + "'");
11}
12}
13else
14{
15QuerySQL(db,"INSERT INTO UIDAlias VALUES('" + player.UniqueID + "', '" + player.Name + "')");
16}
17}
18QuerySQL(db, "CREATE TABLE IF NOT EXISTS UIDAlias ( UID VARCHAR(255), Name VARCHAR(25) ) ");