Logo

PHP Tutorial: A Simple Banning System Part 1

Comments

Avatar jsa005
25 Feb 2012 17:50
Quoth BeckieBird:
Takis stop assuming everything is copy/pasta'd -.-

o_o
Avatar jsa005
25 Feb 2012 17:49
Try this:

-- phpMyAdmin SQL Dump
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 25, 2012 at 12:45 PM
-- Server version: 5.1.58
-- PHP Version: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `MySite_DB`
--

-- --------------------------------------------------------

--
-- Table structure for table `bans`
--

CREATE TABLE IF NOT EXISTS `bans` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) COLLATE latin1_general_ci NOT NULL,
`time` varchar(50) COLLATE latin1_general_ci NOT NULL,
`reason` text COLLATE latin1_general_ci NOT NULL,
`banned_by` varchar(50) COLLATE latin1_general_ci NOT NULL,
`date` varchar(20) COLLATE latin1_general_ci NOT NULL,
`length` varchar(25) COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;


Should do it.
Avatar Chanishyy
15 Feb 2012 14:30
I get it now.
Avatar PrincessChanny
06 Dec 2011 18:25
What do you mean by (id)?
Avatar jsa005
22 Nov 2011 13:08
Just recoding it myself.
I'm using the PMA graphical wizard.
Avatar jsa005
22 Nov 2011 13:00
(!) #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(id) )' at line 10
What am I doing wrong?
Avatar Star Shadow
24 Aug 2011 05:18
Heheheheh... ban bypassing. o.o
Avatar BeckieBird
23 Aug 2011 23:03
Takis stop assuming everything is copy/pasta'd -.-
Avatar victimtimizr21
23 Aug 2011 21:56
i got banned for no reason :p
Avatar conversechic
23 Aug 2011 20:36
...What? lol I'm dumb I don't get it x]
Avatar Skittles
23 Aug 2011 19:52
@takis I didn't. I'm fully capable of coding. o_O
Avatar Skittles
23 Aug 2011 19:50
@commander Actually, both ways work. I always use </br>.
Avatar The Ram
23 Aug 2011 19:03
Takis, it's kind of annoying to see you ask that on literally every Blog.

Good to know for someone who understands that kind of stuff. I am not someone who understands that kind of stuff. XD
Avatar COMMANDER
23 Aug 2011 18:59
It was not copied/pasted.
but his line break tags are backwards. It's <br />, not </br>. Please fix that if I accept this.
Home
Nintendo 3DS is ™ Nintendo Co. Ltd. This website is ©2009-2019 HullBreach Studios. All rights reserved. Members are responsible for their own content. No account information will be given to third-parties without your consent.