[FilterScript] sbAdmin - Advanced MySQL Administration System

[FilterScript] sbAdmin - Advanced MySQL Administration 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)
+--- Thread: [FilterScript] sbAdmin - Advanced MySQL Administration System (/showthread.php?tid=593359)

Pages: 1 2 3

Re: sbAdmin - Advanced MySQL Administration System - gurmani11 - 11.11.2015

It just needs some more admin command like

Код:

/GpciScan » lvl1
/IPScan » lvl1
/offlineGpciScan » lvl2
/HeadText » player or vip
/DelHeadText » lvl3
/SetHeadText »lvl3
/Jailed » lvl1
/Frozen » lvl1
/Reports  » lvl1 to see last 5 or 10 reports
/Afk » player, and must have auto afk detector
/Re or Back » player to reture
/FakeAfk » lvl2
/AfkList  » player
/Move » lvl2
/Cage » lvl1
/AdminLogin » lvl1, just because if some people break into admin account
/ChangeAdminPass » lvl1
/AdminActions » lvl3 to see recent 5 or 10 admin actions

Its what i would put into my admin system.
But above all, your admin system is very nice.

Re: sbAdmin - Advanced MySQL Administration System - SecretBoss - 11.11.2015

Quote:

Originally Posted by gurmani11

It just needs some more admin command like

Код:

/GpciScan » lvl1
/IPScan » lvl1
/offlineGpciScan » lvl2
/HeadText » player or vip
/DelHeadText » lvl3
/SetHeadText »lvl3
/Jailed » lvl1
/Frozen » lvl1
/Reports  » lvl1 to see last 5 or 10 reports
/Afk » player, and must have auto afk detector
/Re or Back » player to reture
/FakeAfk » lvl2
/AfkList  » player
/Move » lvl2
/Cage » lvl1
/AdminLogin » lvl1, just because if some people break into admin account
/ChangeAdminPass » lvl1
/AdminActions » lvl3 to see recent 5 or 10 admin actions

Its what i would put into my admin system.
But above all, your admin system is very nice.

Thanks for your suggestions but I don't know how to save gpci, all the others commands are possible I will try to add them as soon as possible

About AFK system I am not so sure this script will may be used from other guys who may have already a system like this...

Re: sbAdmin - Advanced MySQL Administration System - gurmani11 - 12.11.2015

i did not test it with this [easy-mysql] but i think it must work,

PHP код:



native gpci (playerid, serial [], len); /// at top


enum sbAdmin

{

    pGPCI[128]

};

new User[MAX_PLAYERS][sbAdmin];


stock GetPlayerGPCI(playerid)

{

    new GPCI[128];

    gpci(playerid, GPCI, 128);

    return GPCI;

}


CMD:gpciscan(playerid,params[])

{

    new target;

    if(sscanf(params, "u", target)) return SendClientMessage(playerid,"/GPCIScan [ID]");

    if(target == INVALID_PLAYER_ID)   return SendClientMessage(playerid,"Invalid Player id");


    if(SQL::RowExistsEx(""PLAYERS_TABLE"", "username", GetName(target)))

    {

        new handle = SQL::OpenEx(SQL::READ, ""PLAYERS_TABLE"", "username", GetName(target));

        SQL::ReadString(handle, "GPCI", User[target][pGPCI], 128);

        SQL::Close(handle);

    }

    new string[250];

    format(string,sizeof(string), "%s's GPCI - %s", GetName(target), User[target][pGPCI]);

    SendClientMessage(playerid,-1,string);

    return 1;

}


//    SQL::WriteString(handle, "GPCI", GetPlayerGPCI(playerid));     //write it

Re: sbAdmin - Advanced MySQL Administration System - SecretBoss - 12.11.2015

Quote:

Originally Posted by gurmani11

i did not test it with this [easy-mysql] but i think it must work,

PHP код:



native gpci (playerid, serial [], len); /// at top


enum sbAdmin

{

    pGPCI[128]

};

new User[MAX_PLAYERS][sbAdmin];


stock GetPlayerGPCI(playerid)

{

    new GPCI[128];

    gpci(playerid, GPCI, 128);

    return GPCI;

}


CMD:gpciscan(playerid,params[])

{

    new target;

    if(sscanf(params, "u", target)) return SendClientMessage(playerid,"/GPCIScan [ID]");

    if(target == INVALID_PLAYER_ID)   return SendClientMessage(playerid,"Invalid Player id");


    if(SQL::RowExistsEx(""PLAYERS_TABLE"", "username", GetName(target)))

    {

        new handle = SQL::OpenEx(SQL::READ, ""PLAYERS_TABLE"", "username", GetName(target));

        SQL::ReadString(handle, "GPCI", User[target][pGPCI], 128);

        SQL::Close(handle);

    }

    new string[250];

    format(string,sizeof(string), "%s's GPCI - %s", GetName(target), User[target][pGPCI]);

    SendClientMessage(playerid,-1,string);

    return 1;

}


//    SQL::WriteString(handle, "GPCI", GetPlayerGPCI(playerid));     //write it

Gpci will give a lot of false warnings, since it just get player's computer name for example my computer's name is Administrator if another guy there is another registered guy with the same computer name it will also print his account so it's not safe

Re: sbAdmin - Advanced MySQL Administration System - gurmani11 - 12.11.2015

it comes handy against ban evaders

Re: sbAdmin - Advanced MySQL Administration System - Vin Diesel - 12.11.2015

this admin system is copied SB you know how to copy , how to edit but not how to create anything from the first scratch and the proof this topic wasn't about "Administration System" it was about "Ban System" or something epic fail

Re: sbAdmin - Advanced MySQL Administration System - SecretBoss - 12.11.2015

Quote:

Originally Posted by Vin Diesel

this admin system is copied SB you know how to copy , how to edit but not how to create anything from the first scratch and the proof this topic wasn't about "Administration System" it was about "Ban System" or something epic fail

You are always posting without thinking, and thats why you are immatured, this script is made from scratch, just I got some functions from GAdmin because I couldn't do it myself I also got the permission from Gammix to release them and why I should copy and paste a script? What am I supposed to win? You are thinking like a kid

Re: sbAdmin - Advanced MySQL Administration System - SecretBoss - 13.11.2015

Update 1.1
Check changelog for updates, downloads for new download link
Also if you face any other bug please let me know also do not forget that I tested the script so it will may have some bugs

P.S
Sorry for double posting, I just wanted to let everyone know that script updated

Re: sbAdmin - Advanced MySQL Administration System - Max_Andolini - 13.11.2015

Quote:

Originally Posted by SecretBoss

Update 1.1
Check changelog for updates, downloads for new download link
Also if you face any other bug please let me know also do not forget that I tested the script so it will may have some bugs

P.S
Sorry for double posting, I just wanted to let everyone know that script updated

"Script Version: 1.1 | MySQL Version: R39-3"

MySQL release R39-4 and update the pastebin link.

Re: sbAdmin - Advanced MySQL Administration System - iKarim - 13.11.2015

Quote:

Originally Posted by Vin Diesel

Lol, its the second release for SB, I wish you get a head mate.
Heres the topic you're talking about:
https://sampforum.blast.hk/showthread.php?tid=592669
Which is created by SB.
Mr.Smart.
How would he copied while the owner is the same owner in other script?
Please, use common sense.

Re: sbAdmin - Advanced MySQL Administration System - SecretBoss - 14.11.2015

Quote:

Originally Posted by eco1999

"Script Version: 1.1 | MySQL Version: R39-3"

MySQL release R39-4 and update the pastebin link.

Since I am using easy-mysql for queries, I can't edit the include to work with R39-4, nonetheless I will try to update it myself

Pastebin will be updated in next few minutes

Re: sbAdmin - Advanced MySQL Administration System - ognyanov - 15.11.2015

Full package link please ?

Re: sbAdmin - Advanced MySQL Administration System - SecretBoss - 15.11.2015

Quote:

Originally Posted by ognyanov

Full package link please ?

Link seems to be broken

here is the new link

http://www.mediafire.com/download/5xt08aj7ad3jaoc

Topic updated with new link

Re: sbAdmin - Advanced MySQL Administration System - KnowNN - 17.11.2015

Beautiful, good job man!

Re: sbAdmin - Advanced MySQL Administration System - SecretBoss - 17.11.2015

Quote:

Originally Posted by KnowNN

Beautiful, good job man!

Thanks

___________

Script updated to the newest mysql plugin R39-4 as requested on previous posts, check the first post for the new link

Note: There is no change in the script I only updated mysql include, plugins and libmysql files

Re: sbAdmin - Advanced MySQL Administration System - Bolex_ - 18.11.2015

Updated ?

Re: sbAdmin - Advanced MySQL Administration System - SecretBoss - 18.11.2015

Quote:

Originally Posted by Scripter18

Updated ?

Updated to the R39-4 mysql plugin

Re: sbAdmin - Advanced MySQL Administration System - Shady - 07.02.2016

Perfecto, but, tell me, are you planning to release the second version along with more commands features?

Re: sbAdmin - Advanced MySQL Administration System - SecretBoss - 07.02.2016

Quote:

Originally Posted by ShadyEG

Perfecto, but, tell me, are you planning to release the second version along with more commands features?

Maybe in next months since I have a project to work on

Re: sbAdmin - Advanced MySQL Administration System - TwiiKzz - 07.02.2016

What about this for Helper cmds:
Helpers can talk like a chatbot .. Example:
TwiiKzz:[Player Name]: [He can here say something to the player ( for help ) ]
That would be awesome

And i like that Admin system ..
+REP