Help With MySQL Ban List Script
#3

So how may I take out the encryption, just delete it? I did realize the problem, how it wouldn't need an md5 encryption... I just didn't know how to take it out... Also, is there a way to log a time to one of the column things too?

***EDIT*** I have changed it to this, but Pawno still crashes:

Код:
#define SQL_HOST "secret_host?"
#define SQL_DB "roleplay_bans"
#define SQL_USER "roleplay_bans"
#define SQL_PASS "secret?"

GetPlayerName(playerid,Name,sizeof(Name));
GetPlayerIp(playerid, plrIP, sizeof(plrIP));
mysql_real_escape_string(Name,Name);
mysql_real_escape_string(output,output);
mysql_real_escape_string(bannername,bannername);
mysql_real_escape_string(plrIP,plrIP);
format(query,sizeof(query),"INSERT INTO `"bans"` (Name, Reason, Admin, IP) VALUES ('%s',md5('%s'))";
mysql_query(query);
mysql_query("INSERT INTO bans (Name, Reason, Admin, IP)
Reply


Messages In This Thread
Help With MySQL Ban List Script - by jeff223 - 09.08.2009, 12:39
Re: Help With MySQL Ban List Script - by Sergei - 09.08.2009, 12:53
Re: Help With MySQL Ban List Script - by jeff223 - 09.08.2009, 13:21
Re: Help With MySQL Ban List Script - by Sergei - 09.08.2009, 13:34
Re: Help With MySQL Ban List Script - by jeff223 - 09.08.2009, 13:44
Re: Help With MySQL Ban List Script - by Sergei - 09.08.2009, 13:53
Re: Help With MySQL Ban List Script - by jeff223 - 09.08.2009, 14:00
Re: Help With MySQL Ban List Script - by WrathOfGenesis - 09.08.2009, 14:01
Re: Help With MySQL Ban List Script - by bogeymanEST - 09.08.2009, 14:04
Re: Help With MySQL Ban List Script - by jeff223 - 09.08.2009, 14:26

Forum Jump:


Users browsing this thread: 1 Guest(s)