[ScottCFR]

Is there a way to display my ban list on my forum/site?

I just want it to show the Name and Time of ban... I know it's possible, but that's a lot of coding that I don't want to do if I don't have to.

[WackoX]

Yes, make your ban system on MySQL and use the php example.

[ScottCFR]

Yeh, I got the PHP part. and the query set.

How/Where can I get something for dob (Date of Ban)?

Like, it would show 8/04/10?

Код:

stock CreateBan(playerid)
{
	new query[512],name[MAX_PLAYER_NAME]+1;
	GetPlayerName(playerid, name, sizeof(name));
	format(query, sizeof(query),"INSERT INTO bans (name, dob) VALUES ('%s', '%s')",name,dob);
	mysql_query(query);
	return 1;
}

[Carlton]

pawn Код:

stock CreateBan(playerid)
{
    new query[128],name[MAX_PLAYER_NAME]+1;
    GetPlayerName(playerid, name, sizeof(name));
    new Hour, Minute, Second;
    gettime(Hour, Minute, Second);
    format(query, sizeof(query),"INSERT INTO bans (name, dob) VALUES ('%s', %02d:%02d:%02d)",name,Hour, Minute, Second);
    mysql_query(query);
    return 1;
}

[[NoV]LaZ]

pawn Код:

stock CreateBan(playerid)
{
    new query[128],name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, name, sizeof(name));
    format(query, sizeof(query),"INSERT INTO bans (name, dob) VALUES ('%s', NOW())",name);
    mysql_query(query);
    return 1;
}

________
MEDICAL MARIJUANA PATIENT

[ScottCFR]

Thanks, Carlton && WackoX

Used code the Carlton gave me. Compiled fine, didn't post. And got an error: in my logs

[Daren_Jacobson]

using day-month-year not second-minute-hour, it makes more sense

pawn Код:

stock CreateBan(playerid)
{
    new query[128],name[MAX_PLAYER_NAME]+1;
    GetPlayerName(playerid, name, sizeof(name));
    new Year, Month, Day;
    getdate(Year, Month, Day);
    format(query, sizeof(query),"INSERT INTO `bans` (`name`, `dob`) VALUES ('%s', '%02d-%02d-%02d');",name,Day,Month,Year);
    mysql_query(query);
    return 1;
}

[ScottCFR]

What did you change?

I don't wanna take code and not understand how to do it next time.

[Daren_Jacobson]

I added proper SQL syntax, and changed it to day-month-year.

[ScottCFR]

What does this mean:

Quote:

[14:25:13] MySQL Error (0): Could not execute query. Data truncated for column 'dob' at row 1.

?