10.03.2013, 12:44
Guys, i am using jBan system for banning
here is my inc
But when i start it this happens
You can go on this site http://www.freemysql.net/
and check for my credentials, they are valid for sure.
here is my inc
pawn Код:
/*-----------------------------------------------------------------------------
Title: jBan - The MySQL Ban API
Version: 1
Author: JaTochNietDan (http://www.jatochnietdan.com)
Description:
jBan allows users to create their own SA-MP PAWN gamemodes
and filterscripts while being able to use jBan as their
system for handling bans in a MySQL database. I've done my
best to make this include as compatible as possible with
other scripts, it uses hooks and other methods as
prevention against conflicts with other scripts
and user generated errors.
Credits to:
G-sTyLeZzZ for his MySQL plugin.
****** for his sscanf function and hooking methods.
-------------------------------------------------------------------------------*/
#if !defined mysql_included
#include <a_mysql>
#endif
//--------------------------------------------
// Enter in your MySQL server details
//--------------------------------------------
#define MYSQL_SERVER "SQL09.FREEMYSQL.NET"
#define MYSQL_USER "wawbans"
#define MYSQL_PASS "wawbans1"
#define MYSQL_DATABASE "wawbans"
//--------------------------------------------
// The name of the ban table
//--------------------------------------------
#define J_TABLE samp_ban
//--------------------------------------------
// Set this to 1 to enable logging
//--------------------------------------------
#define J_LOGGING 1
#define COLOR_RED 0xFF0000FF
#define MAX_PLAYER_IP 15
#define MAX_QUERY_LENGTH 400
#define MAX_RESULT_LENGTH 74
#define MAX_MESSAGE_LENGTH 128
#define MAX_REASON_LENGTH 40
#define QUERY_INITIALIZE 100
#define QUERY_BAN 101
#define QUERY_CHECKNAME 102
#define QUERY_UNBAN_NAME 103
#define QUERY_UNBAN_IP 104
new jban_connection;
new
jNames[MAX_PLAYERS][MAX_PLAYER_NAME],
jIP[MAX_PLAYERS][MAX_PLAYER_IP];
new
jBan_Name[MAX_PLAYER_NAME],
jBan_Reason[MAX_REASON_LENGTH],
jBan_Message[MAX_MESSAGE_LENGTH],
jBan_Time,
jQuery[MAX_QUERY_LENGTH],
jResult[MAX_RESULT_LENGTH];
/*-------------------------------------------------------------------
native jBan(pplayer_banned, player_banner, reason[], time = 0);
Usage:
Use this to ban a selected player for a certain amount
of time.
Params:
player_banned - The ID of the player to be banned
player_banner - The ID of the player banning the player
reason - The reason for the ban (Optional)
time - The amount of the ban will last in minutes (Optional)
Note:
If a time is not specified, it will default to a
permanent ban.
-------------------------------------------------------------------*/
stock jBan(player_banned, player_banner, reason[], time = 0)
{
if(strlen(reason) > MAX_REASON_LENGTH) return SendClientMessage(player_banner, 0xFFFFFF, "[jBan]: Sorry, the maximum reason length is "#MAX_REASON_LENGTH" characters!");
format(jQuery, MAX_QUERY_LENGTH, "INSERT INTO `"#J_TABLE"` (user_banned, user_banned_ip, user_banner, ban_reason, ban_timestamp, ban_time) VALUES ('%s', '%s', '%s', '%s', CURRENT_TIMESTAMP, %d)", jNames[player_banned], jIP[player_banned], jNames[player_banner], reason, time);
mysql_query(jQuery, QUERY_BAN, player_banned, jban_connection);
Kick(player_banned);
#if J_LOGGING == 1
printf("[jBan]: Player \"%s\" (%s) banned by \"%s\" with reason \"%s\" for %d minutes", jNames[player_banned], jIP[player_banned], jNames[player_banner], reason, time);
#endif
return 1;
}
/*-------------------------------------------------------------------
native jBanCheck(playerid);
Usage:
This function will find a player with an un-expired
ban or a permanent ban and remove them from the
server with the reason of their ban, the time left
and the person that banned them.
Params:
playerid - ID of the player to check for ban
Note:
This function is already hooked and does not need
to be called manually for any circumstances.
-------------------------------------------------------------------*/
stock jBanCheck(playerid)
{
format(jQuery, MAX_QUERY_LENGTH, "SELECT user_banner, ban_reason, TIMESTAMPDIFF(MINUTE, NOW(), DATE_ADD(ban_timestamp, INTERVAL ban_time MINUTE)) FROM `"#J_TABLE"` WHERE user_banned_ip = '%s' AND (NOW() <= DATE_ADD(ban_timestamp, INTERVAL ban_time MINUTE) OR ban_time = 0)", jIP[playerid]);
mysql_query_callback(QUERY_CHECKNAME, jQuery, "jban_OnQueryFinish", playerid, jban_connection);
return 1;
}
/*-------------------------------------------------------------------
native jUnbanName(name[], bool:expired = false);
Usage:
This function will remove bans for a specified name.
Params:
name[] - The name of the player as a string.
bool:expired - Remove expired bans or not.
Note:
If expired is not set, it will not removed expired
bans by default, it will only remove active bans.
-------------------------------------------------------------------*/
stock jUnbanName(name[], bool:expired = false)
{
if(strlen(name) > MAX_PLAYER_NAME) return 0;
mysql_real_escape_string(name, name);
if(expired == false) format(jQuery, MAX_QUERY_LENGTH, "DELETE FROM `"#J_TABLE"` WHERE user_banned = '%s' AND NOW() <= DATE_ADD(ban_timestamp, INTERVAL ban_time MINUTE)", name);
else format(jQuery, MAX_QUERY_LENGTH, "DELETE FROM `"#J_TABLE"` WHERE user_banned = '%s'", name);
mysql_query(jQuery, QUERY_UNBAN_NAME, 0, jban_connection);
return 1;
}
/*-------------------------------------------------------------------
native jUnbanIP(IP[], bool:expired = false);
Usage:
This function will remove bans for a specified IP address.
Params:
IP[] - The name of the player as a string.
bool:expired - Remove expired bans or not.
Note:
If expired is not set, it will not removed expired
bans by default, it will only remove active bans.
-------------------------------------------------------------------*/
stock jUnbanIP(IP[], bool:expired = false)
{
if(strlen(IP) > MAX_PLAYER_IP) return 0;
mysql_real_escape_string(IP, IP);
if(expired == false) format(jQuery, MAX_QUERY_LENGTH, "DELETE FROM `"#J_TABLE"` WHERE user_banned_ip = '%s' AND NOW() <= DATE_ADD(ban_timestamp, INTERVAL ban_time MINUTE)", IP);
else format(jQuery, MAX_QUERY_LENGTH, "DELETE FROM `"#J_TABLE"` WHERE user_banned_ip = '%s'", IP);
mysql_query(jQuery, QUERY_UNBAN_IP, 0, jban_connection);
return 1;
}
stock jban_SetPlayerName(playerid, name[])
{
format(jNames[playerid], MAX_PLAYER_NAME, name);
return SetPlayerName(playerid, name);
}
public OnPlayerConnect(playerid)
{
GetPlayerName(playerid, jNames[playerid], MAX_PLAYER_NAME);
GetPlayerIp(playerid, jIP[playerid], MAX_PLAYER_IP);
jBanCheck(playerid);
return CallLocalFunction("jban_OnPlayerConnect", "i", playerid);
}
public OnGameModeInit()
{
#if J_LOGGING == 1
mysql_debug(true);
#endif
jban_connection = mysql_connect(MYSQL_SERVER, MYSQL_USER, MYSQL_DATABASE, MYSQL_PASS);
if(mysql_ping() == -1)
{
#if J_LOGGING == 1
print("[jBan Error 001]: Connection to MySQL server failed, check your settings!");
#endif
SendRconCommand("exit");
}
else
{
#if J_LOGGING == 1
print("[jBan]: Connection to MySQL server succeeded!");
#endif
mysql_query(
"CREATE TABLE IF NOT EXISTS `"#J_TABLE"` ("\
"`BanID` int(6) NOT NULL AUTO_INCREMENT,"\
"`user_banned` varchar(24) NOT NULL,"\
"`user_banned_ip` varchar(15) NOT NULL,"\
"`user_banner` varchar(24) NOT NULL,"\
"`ban_reason` varchar(40) NOT NULL,"\
"`ban_timestamp` timestamp NOT NULL,"\
"`ban_time` int(10) NOT NULL,"\
"PRIMARY KEY (`BanID`)"\
") ENGINE=InnoDB DEFAULT CHARSET=latin1;", QUERY_INITIALIZE, 0, jban_connection);
}
return CallLocalFunction("jban_OnGameModeInit", "");
}
public jban_OnQueryFinish(query[], index, extraid, connectionHandle)
{
if(index == QUERY_CHECKNAME)
{
mysql_store_result();
if(mysql_num_rows() > 0)
{
mysql_fetch_row(jResult);
j_sscanf(jResult, "p|ssi", jBan_Name, jBan_Reason, jBan_Time);
format(jBan_Message, MAX_MESSAGE_LENGTH, "[jBan]: You have an existing ban from \"%s\" for \"%s\", it will expire in %d minutes!", jBan_Name, jBan_Reason, jBan_Time);
SendClientMessage(extraid, COLOR_RED, jBan_Message);
Kick(extraid);
}
mysql_free_result();
}
return 1;
}
//---------------------------------
// sscanf by Alex "******" Cole
// http://www.y-less.com
//---------------------------------
stock j_sscanf(string[], format[], {Float,_}:...)
{
#if defined isnull
if (isnull(string))
#else
if (string[0] == 0 || (string[0] == 1 && string[1] == 0))
#endif
{
return format[0];
}
#pragma tabsize 4
new
formatPos = 0,
stringPos = 0,
paramPos = 2,
paramCount = numargs(),
delim = ' ';
while (string[stringPos] && string[stringPos] <= ' ')
{
stringPos++;
}
while (paramPos < paramCount && string[stringPos])
{
switch (format[formatPos++])
{
case '\0':
{
return 0;
}
case 'i', 'd':
{
new
neg = 1,
num = 0,
ch = string[stringPos];
if (ch == '-')
{
neg = -1;
ch = string[++stringPos];
}
do
{
stringPos++;
if ('0' <= ch <= '9')
{
num = (num * 10) + (ch - '0');
}
else
{
return -1;
}
}
while ((ch = string[stringPos]) > ' ' && ch != delim);
setarg(paramPos, 0, num * neg);
}
case 'h', 'x':
{
new
num = 0,
ch = string[stringPos];
do
{
stringPos++;
switch (ch)
{
case 'x', 'X':
{
num = 0;
continue;
}
case '0' .. '9':
{
num = (num << 4) | (ch - '0');
}
case 'a' .. 'f':
{
num = (num << 4) | (ch - ('a' - 10));
}
case 'A' .. 'F':
{
num = (num << 4) | (ch - ('A' - 10));
}
default:
{
return -1;
}
}
}
while ((ch = string[stringPos]) > ' ' && ch != delim);
setarg(paramPos, 0, num);
}
case 'c':
{
setarg(paramPos, 0, string[stringPos++]);
}
case 'f':
{
new changestr[16], changepos = 0, strpos = stringPos;
while(changepos < 16 && string[strpos] && string[strpos] != delim)
{
changestr[changepos++] = string[strpos++];
}
changestr[changepos] = '\0';
setarg(paramPos,0,_:floatstr(changestr));
}
case 'p':
{
delim = format[formatPos++];
continue;
}
case '\'':
{
new
end = formatPos - 1,
ch;
while ((ch = format[++end]) && ch != '\'') {}
if (!ch)
{
return -1;
}
format[end] = '\0';
if ((ch = strfind(string, format[formatPos], false, stringPos)) == -1)
{
if (format[end + 1])
{
return -1;
}
return 0;
}
format[end] = '\'';
stringPos = ch + (end - formatPos);
formatPos = end + 1;
}
case 'u':
{
new
end = stringPos - 1,
id = 0,
bool:num = true,
ch;
while ((ch = string[++end]) && ch != delim)
{
if (num)
{
if ('0' <= ch <= '9')
{
id = (id * 10) + (ch - '0');
}
else
{
num = false;
}
}
}
if (num && IsPlayerConnected(id))
{
setarg(paramPos, 0, id);
}
else
{
#if !defined foreach
#define foreach(%1,%2) for (new %2 = 0; %2 < MAX_PLAYERS; %2++) if (IsPlayerConnected(%2))
#define __SSCANF_FOREACH__
#endif
string[end] = '\0';
num = false;
new
name[MAX_PLAYER_NAME];
id = end - stringPos;
foreach (Player, playerid)
{
GetPlayerName(playerid, name, sizeof (name));
if (!strcmp(name, string[stringPos], true, id))
{
setarg(paramPos, 0, playerid);
num = true;
break;
}
}
if (!num)
{
setarg(paramPos, 0, INVALID_PLAYER_ID);
}
string[end] = ch;
#if defined __SSCANF_FOREACH__
#undef foreach
#undef __SSCANF_FOREACH__
#endif
}
stringPos = end;
}
case 's', 'z':
{
new
i = 0,
ch;
if (format[formatPos])
{
while ((ch = string[stringPos++]) && ch != delim)
{
setarg(paramPos, i++, ch);
}
if (!i)
{
return -1;
}
}
else
{
while ((ch = string[stringPos++]))
{
setarg(paramPos, i++, ch);
}
}
stringPos--;
setarg(paramPos, i, '\0');
}
default:
{
continue;
}
}
while (string[stringPos] && string[stringPos] != delim && string[stringPos] > ' ')
{
stringPos++;
}
while (string[stringPos] && (string[stringPos] == delim || string[stringPos] <= ' '))
{
stringPos++;
}
paramPos++;
}
do
{
if ((delim = format[formatPos++]) > ' ')
{
if (delim == '\'')
{
while ((delim = format[formatPos++]) && delim != '\'') {}
}
else if (delim != 'z')
{
return delim;
}
}
}
while (delim > ' ');
return 0;
}
#if defined _ALS_OnGameModeInit
#undef OnGameModeInit
#else
#define _ALS_OnGameModeInit
#endif
#define OnGameModeInit jban_OnGameModeInit
#if defined _ALS_SetPlayerName
#undef SetPlayerName
#else
#define _ALS_SetPlayerName
#endif
#define SetPlayerName jban_SetPlayerName
#if defined _ALS_OnPlayerConnect
#undef OnPlayerConnect
#else
#define _ALS_OnPlayerConnect
#endif
#define OnPlayerConnect jban_OnPlayerConnect
forward jban_OnGameModeInit();
forward jban_OnQueryFinish(query[], index, extraid, connectionHandle);
forward jban_SetPlayerName(playerid, name[]);
forward jban_OnPlayerConnect(playerid);
pawn Код:
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3x, (C)2005-2013 SA-MP Team
[18:31:01] password = "" (string)
[18:31:01]
[18:31:01] Server Plugins
[18:31:01] --------------
[18:31:01] Loading plugin: streamer
[18:31:01]
*** Streamer Plugin v2.5 by Incognito loaded ***
[18:31:01] Loaded.
[18:31:01] Loading plugin: sscanf
[18:31:01]
[18:31:01] ===============================
[18:31:01] sscanf plugin loaded.
[18:31:01] (c) 2009 Alex "******" Cole
[18:31:01] 0.3d-R2 500 Players "dnee"
[18:31:01] ===============================
[18:31:01] Loaded.
[18:31:01] Loading plugin: mysql
[18:31:01]
> MySQL plugin R5 successfully loaded.
[18:31:01] Loaded.
[18:31:01] Loading plugin: MapAndreas
[18:31:01] Failed.
[18:31:01] Loaded 3 plugins.
[18:31:01]
[18:31:01] Filterscripts
[18:31:01] ---------------
[18:31:01] Loading filterscript 'LaserPoint.amx'...
[18:31:01]
-- Laser Pointer by Skiaffo --
[18:31:01] Loading filterscript 'anims.amx'...
[18:31:01] Loading filterscript 'dmg.amx'...
[18:31:01] DamageVisual, version 1.0.0 by [RSAH]SeriouS loaded successfully!
[18:31:01] Loading filterscript 'WeaponsOnBack.amx'...
[18:31:01] Unable to load filterscript 'WeaponsOnBack.amx'.
[18:31:01] Loading filterscript 'RadioSys.amx'...
[18:31:01]
--------------------------------------
[18:31:01] Blank Filterscript by your name here
[18:31:01] --------------------------------------
[18:31:01] Loading filterscript 'liv.amx'...
[18:31:01] Loading filterscript '1.amx'...
[18:31:01] Loading filterscript 'Duelsys.amx'...
[18:31:01] Unable to load filterscript 'Duelsys.amx'.
[18:31:01] Loaded 6 filterscripts.
[18:31:01]
[18:31:01]
[18:31:01]
[18:31:01]
[18:31:01] =======================================
[18:31:01] | |
[18:31:01] | YSI version 1.06.0002 |
[18:31:01] | By Alex "******" Cole |
[18:31:01] | |
[18:31:01] =======================================
[18:31:01]
[18:31:03] [B][jBan Error 001]: Connection to MySQL server failed, check your settings![/B]
[18:31:03]
-Configuration Settings Loaded
[18:31:03] -43 Forbidden Names Loaded
[18:31:03] -10 Forbidden Tags Loaded
[18:31:03] -34 Forbidden Words Loaded
[18:31:03]
----------------------------------
[18:31:03] Call of duty world at war
[18:31:03] ----------------------------------
[18:31:03] Number of vehicle models: 8
[18:31:03] --- Server Shutting Down.
[18:31:03] NF 0
[18:31:03] NF 1
[18:31:04] NF 2
[18:31:04] NF 3
[18:31:04] NF 4
[18:31:04] DamageVisual, version 1.0.0 by [RSAH]SeriouS unloaded successfully!
[18:31:04]
*** Streamer Plugin v2.5 by Incognito unloaded ***
[18:31:04]
[18:31:04] ===============================
[18:31:04] sscanf plugin unloaded.
[18:31:04] ===============================
and check for my credentials, they are valid for sure.
