Reserve user name / Bad words

[tripleA]

Hi everyone.

I have a list of several hundred usernames that I want to reserve and many bad words that I want to exclude.

Is there a way to submit these on my site in a batch instead of one by one?

[grynmoors]

1) copy and paste the name or word you want to restrict into the box

2) rinse and repeat

Or possibly, have a look at the mysql table that stores this stuff. You might be able to copy/paste the list there. IDK. Good Luck.

[Scuzz]

I agree. If you have phpmyadmin, then it's easy. just put a few in by hand through the script, then go into phpmyadmin and export that particular table as a sql file.
Take a look at it, and edit to your hearts' content.
Then just import it back in, and yer done!
PHPmyadmin is very forgiving. If you screw up somewhere, it'll let you know.

[tripleA]

1) copy and paste the name or word you want to restrict into the box

2) rinse and repeat

Or possibly, have a look at the mysql table that stores this stuff. You might be able to copy/paste the list there. IDK. Good Luck.

Hey thanks grynmoors. rince and repeat ..LOL.

[tripleA]

I agree. If you have phpmyadmin, then it's easy. just put a few in by hand through the script, then go into phpmyadmin and export that particular table as a sql file.
Take a look at it, and edit to your hearts' content.
Then just import it back in, and yer done!
PHPmyadmin is very forgiving. If you screw up somewhere, it'll let you know.

Scuzz my hosting company provides PHPmyadmin, so I will check out your suggestion.


You guys are really great - thank you both very much.

[grynmoors]

Please let us know if it works and how you got it to work. :D Thanks!

[Scuzz]

Just saw your reply Grynmoors, and thought I'd take a whack at it just for fun.
I put in 3 words, and did an export as file from PhpMyAdmin.
I got this:

-- phpMyAdmin SQL Dump
-- version 2.10.3-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 14, 2008 at 01:04 AM
-- Server version: 4.1.20
-- PHP Version: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `vshare`
--

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

--
-- Table structure for table `words`
--

CREATE TABLE IF NOT EXISTS `words` (
`word_id` mediumint(8) unsigned NOT NULL auto_increment,
`word` varchar(255) NOT NULL default '',
`replacement` varchar(255) NOT NULL default '',
PRIMARY KEY (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `words`
--

REPLACE INTO `words` (`word_id`, `word`, `replacement`) VALUES
(1, 'poopoo', ''),
(2, 'heck', ''),
(3, 'phooey', '');

So, I added line 4,5, and 6: and tried an import.
Worked like a charm.
Couple things to note though....
When you do the export, make sure that the export type is set to REPLACE, not INSERT.
If it's set to insert, then you will get an error for duplicate entries.
Also, If yer lazy like me, and you copy and paste from the stuff in the lines above and just change the numbers and words, make sure that each line ends with a comma, except for the last line which must have a semi-colon.
Here's what I wound up with:

-- phpMyAdmin SQL Dump
-- version 2.10.3-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 14, 2008 at 01:14 AM
-- Server version: 4.1.20
-- PHP Version: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `vshare`
--

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

--
-- Table structure for table `words`
--

CREATE TABLE IF NOT EXISTS `words` (
`word_id` mediumint(8) unsigned NOT NULL auto_increment,
`word` varchar(255) NOT NULL default '',
`replacement` varchar(255) NOT NULL default '',
PRIMARY KEY (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `words`
--

REPLACE INTO `words` (`word_id`, `word`, `replacement`) VALUES
(1, 'poopoo', ''),
(2, 'heck', ''),
(3, 'phooey', ''),
(4, 'darn', ''),
(5, 'ratss', ''),
(6, 'rats', '');

It worked perfectly :mrgreen:

[tripleA]

Hi scuzz.

Finally I had a go at populating the reserved words table. Your suggestions helped me a lot. Without it I would have been stuck.

However, I had a lot of problems with the format in which I was to save the file. Finally, I settled with excel/csv. I had to reject the PHPmyadmin default of separating fields with semicolom and I instead used comma.

[Scuzz]

However, I had a lot of problems with the format in which I was to save the file. Finally, I settled with excel/csv. I had to reject the PHPmyadmin default of separating fields with semicolom and I instead used comma.

All I did was export it as an sql file, which is actually just a text file.
Then all you need to do is put in the new stuff and import it.

[tripleA]

Hi again. I forgot to mention earlier that I had had been successful. However, I will try exporting as sql file next time. Thanks very much!