Help With MySQL Ban List Script
#2

Код:
INSERT INTO `"bans"` (Name, Reason, Admin, IP) VALUES ('%s',md5('%s'))
If you need only name and reason to be added add like this:
Код:
INSERT INTO `"bans"` (Name, Reason) VALUES ('%s',md5('%s'))
You don't need to fill up all the rows with custom values, just make sure that you define default values in mysql table ,so it knows what to add if you don't specific otherwise.

And btw, that encryption (md5) is pretty useless there since you don't have any passwords. If you encrypt something you won't be able to unencrypt that ever again.
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)