[Jarnu]

Introduction

Hello guys,

Today i am releasing my first "MySQL Based" register system! Its a basic register system with some commands!

Features:

• MySQL Based Register system for faster results
• Anti-Ban Evade
• Extra admin commands added
• Login/Register system perfect for every server!
• Attractive dialog colors
• Clean FilterScript without bugs
• Login/Register dialog will be shown OnPlayerConnect
• Easy to use and user friendly

ChangeLog

Код:

5/10/2012 V0.1
-----
Officially released BETA version!
-----

Images:

/imageshack/slidesho...d=samp219z.png

How to set up database?

-Download WAMP server [VERY IMPORTANT else it will not work!]
-Open WAMP server
-Click on create database!
-Create a new database named "sa-mp" ---- Will be changed according to this line:

pawn Код:

#define MYSQL_DB "sa-mp"

-Just you are ready with setting up the database!

Bug Report

No bugs found yet!

How to add extra admin commands?

I already added the example commands like /setadmin /sethelper /setscore /kick /ban in script!

Example command for set kills and set deaths:

pawn Код:

CMD:setkills(playerid, params[])
{
  new player1, amount;
  if(PlayerInfo[playerid][pAdmin] >= 4)
  {
    if(sscanf(params,"dd", player1, amount)) return SendClientMessage(playerid, RED,"USAGE: /setkills [playerid][amount]");
    if(!IsPlayerConnected(player1)) return SendClientMessage(playerid, RED,"[ERROR]: Player not connected!");
    PlayerInfo[playerid][pKills] = amount;
    TargetCMDMessage(playerid, player1,"SETKILLS");
    new str[100], str1[100];
    format(str, sizeof(str),"Administrator %s has setted your kill(s) to %d", PlayerName(playerid),amount);
    format(str1, sizeof(str1),"You have setted %s's kill(s) to %d", PlayerName(player1), amount);
    SendClientMessage(player1, BLUE, str);
    SendClientMessage(playerid, BLUE, str1);
  }
  else return SendClientMessage(playerid, RED,"[ERROR]: You need to be admin level 4 to use this command!");
  return 1;
}
CMD:setdeaths(playerid, params[])
{
  new player1, amount;
  if(PlayerInfo[playerid][pAdmin] >= 4)
  {
    if(sscanf(params,"dd", player1, amount)) return SendClientMessage(playerid, RED,"USAGE: /setdeaths [playerid][amount]");
    if(!IsPlayerConnected(player1)) return SendClientMessage(playerid, RED,"[ERROR]: Player not connected!");
    PlayerInfo[playerid][pDeaths] = amount;
    TargetCMDMessage(playerid, player1,"SETDEATHS");
    new str[100], str1[100];
    format(str, sizeof(str),"Administrator %s has setted your death(s) to %d", PlayerName(playerid),amount);
    format(str1, sizeof(str1),"You have setted %s's death(s) to %d", PlayerName(player1), amount);
    SendClientMessage(player1, BLUE, str);
    SendClientMessage(playerid, BLUE, str1);
  }
  else return SendClientMessage(playerid, RED,"[ERROR]: You need to be admin level 4 to use this command!");
  return 1;
}

Credits

-Jarnu - for main scripting!
-Ronaldo_raul™ - for helping in fixing small bugs ^^
-****** - sscanf
-BlueG - mysql plugin!
-Zeex - zcmd

Download:

Package [included plugins, includes, filterscript!]: http://www.mediafire.com/?7i38eu2qnosx2h5

Hoping to get some nice comments as it is my first "MySQL based filter-script"

[MA_proking]

woah Nice work
+1 rep

[Lordzy]

Looks pretty good.
But I've got a doubt regarding Anti-Ban evade.

Usually samp.ban doesn't allows the player from the same IP to join the server.
So is there anything special in this script?

[Jarnu]

samp.ban is not included in this.. ! see the pic in the slideshow you'll know
and also .. check //----- MySQL_BanCheck --///stock in Script ^^

And Thank you

[Gangs_Rocks]

O_O

That indentation...
Hurts
My
Eyes!


Great job bro

[Jarnu]

Lol .. i'll try to improve my indentation next time

Thank you

[Danyal]

nice work mate

[Grevious]

Wow ..i need this script