Acedeal : Help

[Father-Time.]

Hi Ace, any chance of having a copy of your bad words SQL query please.
Also remember when we had a chat about a TAG Board Here is the addy http://www.tag-board.com/ , have a look and one last thing how can i get a hit counter on my portal any ideas?

Thanks

Sel

[Father-Time.]

Does anyone but me read this area? :(

[Innox]

I read most every area, I don't know any php though :cry:

[TR-JustinMc06-]

I read everything but i feel no reason to reply hmmm....interestined father, i just don't know what to do to help you

[Acedeal]

I read it, just forgot to reply :)..

[Acedeal]

Here ya go,
Let's see if this works without being censored.

[php:1:728baca617]
<?php
#
# Table structure for table `phpbb_words`
#

DROP TABLE IF EXISTS phpbb_words;
CREATE TABLE phpbb_words (
word_id mediumint(8) unsigned NOT NULL auto_increment,
word char(100) NOT NULL default '',
replacement char(100) NOT NULL default '',
PRIMARY KEY (word_id)
) TYPE=MyISAM;

#
# Dumping data for table `phpbb_words`
#

INSERT INTO phpbb_words VALUES (141, 'Fuck', 'f:_censore:k');
INSERT INTO phpbb_words VALUES (2, 'Shit', 'S:_censore:t');
INSERT INTO phpbb_words VALUES (143, 'damn', ':_censore:');
INSERT INTO phpbb_words VALUES (13, 'asswhole', 'butt-head');
INSERT INTO phpbb_words VALUES (5, 'horeshit', 'horsecrap');
INSERT INTO phpbb_words VALUES (6, 'cunt', 'girl');
INSERT INTO phpbb_words VALUES (17, 'motherf*', 'motherf :_censore: er');
INSERT INTO phpbb_words VALUES (9, 'bullshit', 'bull :_censore:');
INSERT INTO phpbb_words VALUES (11, 'GodDamn', 'GD');
INSERT INTO phpbb_words VALUES (142, 'dam', ':_censore:');
INSERT INTO phpbb_words VALUES (14, 'asshole', 'butt-head');
INSERT INTO phpbb_words VALUES (15, 'goddam', 'GD');
INSERT INTO phpbb_words VALUES (16, 'fucker', 'f :_censore: er');
INSERT INTO phpbb_words VALUES (19, 'shit*', 's:_censore:t');
INSERT INTO phpbb_words VALUES (20, 'fag', 'boy-liker');
INSERT INTO phpbb_words VALUES (21, 'Homo', 'same-sex');
INSERT INTO phpbb_words VALUES (22, 'sucks', 'blows');
INSERT INTO phpbb_words VALUES (23, '*fuck*', 'F:_censore:k');
INSERT INTO phpbb_words VALUES (24, 'cunt*', ':_censore:');
INSERT INTO phpbb_words VALUES (25, 'dick*', ':_censore:');
INSERT INTO phpbb_words VALUES (26, '*shit*', 's:_censore:t');
INSERT INTO phpbb_words VALUES (28, 'Cock', ':_censore:');
INSERT INTO phpbb_words VALUES (29, 'motherfucker', '*beep*');
INSERT INTO phpbb_words VALUES (30, 'slut', 'sl :_censore: ut');
INSERT INTO phpbb_words VALUES (31, 'pussy', 'p:_censore:y');
INSERT INTO phpbb_words VALUES (32, 'prick', 'p:_censore:k');
INSERT INTO phpbb_words VALUES (33, 'screw', '*beep*');
INSERT INTO phpbb_words VALUES (34, 'tits', 'hooters');
INSERT INTO phpbb_words VALUES (35, 'kike', '*beep*');
INSERT INTO phpbb_words VALUES (156, 'Y\'allz', ':_censore:');
INSERT INTO phpbb_words VALUES (38, 'nigger', '*beep*');
INSERT INTO phpbb_words VALUES (39, 'piss*', 'PO\'d');
INSERT INTO phpbb_words VALUES (40, 'dego', '*beep*');
INSERT INTO phpbb_words VALUES (43, 'honkey', '*beep*');
INSERT INTO phpbb_words VALUES (44, 'cum', '*beep*');
INSERT INTO phpbb_words VALUES (45, 'nutsack', '*beep*');
INSERT INTO phpbb_words VALUES (46, 'testicles', '*beep*');
INSERT INTO phpbb_words VALUES (47, 'clits', '*beep*');
INSERT INTO phpbb_words VALUES (48, 'masturbat*', '*beep*');
INSERT INTO phpbb_words VALUES (50, 'twat', 'tw :_censore:t');
INSERT INTO phpbb_words VALUES (51, 'gay', '*beep*');
INSERT INTO phpbb_words VALUES (52, 'dago', '*beep*');
INSERT INTO phpbb_words VALUES (53, 'c0ck', '*beep*');
INSERT INTO phpbb_words VALUES (54, 'fuk*', '*beep*');
INSERT INTO phpbb_words VALUES (56, 'teets', '*beep*');
INSERT INTO phpbb_words VALUES (57, 'bastard', ':_censore:');
INSERT INTO phpbb_words VALUES (58, 'twaty', '*beep*');
INSERT INTO phpbb_words VALUES (59, 'assramer', '*beep*');
INSERT INTO phpbb_words VALUES (60, 'puta', '*beep*');
INSERT INTO phpbb_words VALUES (146, 'b*tch', 'B:_censore:h');
INSERT INTO phpbb_words VALUES (63, 'hore', '*beep*');
INSERT INTO phpbb_words VALUES (64, 'kuk', '*beep*');
INSERT INTO phpbb_words VALUES (65, 'kuksuger', '*beep*');
INSERT INTO phpbb_words VALUES (66, 'fag*', '*beep*');
INSERT INTO phpbb_words VALUES (67, 'ficken', '*beep*');
INSERT INTO phpbb_words VALUES (68, 'fcuk', '*beep*');
INSERT INTO phpbb_words VALUES (69, 'queef*', '*beep*');
INSERT INTO phpbb_words VALUES (70, 'sphencter', '*beep*');
INSERT INTO phpbb_words VALUES (71, 'b!tch', '*beep*');
INSERT INTO phpbb_words VALUES (72, 'titties', 'hooters');
INSERT INTO phpbb_words VALUES (74, 'Puto', '*beep*');
INSERT INTO phpbb_words VALUES (75, 'pr0n', '*beep*');
INSERT INTO phpbb_words VALUES (78, 'spic', '*beep*');
INSERT INTO phpbb_words VALUES (79, 'chink', '*beep*');
INSERT INTO phpbb_words VALUES (80, 'gook', '*beep*');
INSERT INTO phpbb_words VALUES (81, 'feg', '*beep*');
INSERT INTO phpbb_words VALUES (82, 'nigga', '*beep*');
INSERT INTO phpbb_words VALUES (83, 'h0r', '*beep*');
INSERT INTO phpbb_words VALUES (84, 'fux0r', '*beep*');
INSERT INTO phpbb_words VALUES (85, 'b17ch', '*beep*');
INSERT INTO phpbb_words VALUES (86, 'b1tch', '*beep*');
INSERT INTO phpbb_words VALUES (87, 'bi7ch', '*beep*');
INSERT INTO phpbb_words VALUES (88, 'h4x0r', '*beep*');
INSERT INTO phpbb_words VALUES (89, 'fatass', '*beep*');
INSERT INTO phpbb_words VALUES (90, 'feces', '*beep*');
INSERT INTO phpbb_words VALUES (91, 'pimpis', '*beep*');
INSERT INTO phpbb_words VALUES (93, 'dildo', '*beep*');
INSERT INTO phpbb_words VALUES (94, 'poontsee', '*beep*');
INSERT INTO phpbb_words VALUES (147, 'Hell', ':_censore:');
INSERT INTO phpbb_words VALUES (96, 'kraut', '*beep*');
INSERT INTO phpbb_words VALUES (97, 'nazis', 'N :_censore: s');
INSERT INTO phpbb_words VALUES (98, '@$$', '*beep*');
INSERT INTO phpbb_words VALUES (99, 'preud', '*beep*');
INSERT INTO phpbb_words VALUES (100, 'hoer', '*beep*');
INSERT INTO phpbb_words VALUES (101, 'scrotum', '*beep*');
INSERT INTO phpbb_words VALUES (102, 'whoar', '*beep*');
INSERT INTO phpbb_words VALUES (103, 'w00se', '*beep*');
INSERT INTO phpbb_words VALUES (104, 'lesbian', '*beep*');
INSERT INTO phpbb_words VALUES (105, 'foreskin', '*beep*');
INSERT INTO phpbb_words VALUES (107, 'sh!t*', '*beep*');
INSERT INTO phpbb_words VALUES (108, 'queer*', '*beep*');
INSERT INTO phpbb_words VALUES (109, 'nigger*', '*beep*');
INSERT INTO phpbb_words VALUES (110, 'shemale', '*beep*');
INSERT INTO phpbb_words VALUES (112, 'hoer*', '*beep*');
INSERT INTO phpbb_words VALUES (113, 'd4mn', '*beep*');
INSERT INTO phpbb_words VALUES (114, 'titty', 'hooter');
INSERT INTO phpbb_words VALUES (115, 'pendejo', '*beep*');
INSERT INTO phpbb_words VALUES (116, 'phuck', '*beep*');
INSERT INTO phpbb_words VALUES (117, 'cabron', '*beep*');
INSERT INTO phpbb_words VALUES (120, 'qaHbeh', '*beep*');
INSERT INTO phpbb_words VALUES (122, 'pusse', '*beep*');
INSERT INTO phpbb_words VALUES (123, 'lesbo', '*beep*');
INSERT INTO phpbb_words VALUES (124, 'teez', '*beep*');
INSERT INTO phpbb_words VALUES (125, '*dyke', '*beep*');
INSERT INTO phpbb_words VALUES (144, 'f*ck', 'F:_censore:k');
INSERT INTO phpbb_words VALUES (129, 'dike*', '*beep*');
INSERT INTO phpbb_words VALUES (131, 'ejackulate', '*beep*');
INSERT INTO phpbb_words VALUES (132, 'wetback*', '*beep*');
INSERT INTO phpbb_words VALUES (133, 'jism', '*beep*');
INSERT INTO phpbb_words VALUES (134, 'jizz', '*beep*');
INSERT INTO phpbb_words VALUES (137, 'b!+ch', '*beep*');
INSERT INTO phpbb_words VALUES (138, 'bi+ch', '*beep*');
INSERT INTO phpbb_words VALUES (139, 'l3itch', '*beep*');
INSERT INTO phpbb_words VALUES (140, 'l3i+ch', '*beep*');
INSERT INTO phpbb_words VALUES (148, '"f*ck"', '*Beep*');
INSERT INTO phpbb_words VALUES (151, 'Allah', 'A:_censore:h');
INSERT INTO phpbb_words VALUES (150, 'punk', 'Censored');
INSERT INTO phpbb_words VALUES (153, 'RA', ':_censore:');
INSERT INTO phpbb_words VALUES (154, 'Zeus', 'Z:_censore:S');
INSERT INTO phpbb_words VALUES (155, 'suck', 'S:_censore:K');

[/php:1:728baca617]


#
# Table structure for table `phpbb_words`
#

DROP TABLE IF EXISTS phpbb_words;
CREATE TABLE phpbb_words (
word_id mediumint(8) unsigned NOT NULL auto_increment,
word char(100) NOT NULL default '',
replacement char(100) NOT NULL default '',
PRIMARY KEY (word_id)
) TYPE=MyISAM;

#
# Dumping data for table `phpbb_words`
#

INSERT INTO phpbb_words VALUES (141, 'Fuck', 'f:_censored:k');
INSERT INTO phpbb_words VALUES (2, 'Shit', 'S:_censored:t');
INSERT INTO phpbb_words VALUES (143, 'damn', ':_censored:');
INSERT INTO phpbb_words VALUES (13, 'asswhole', 'butt-head');
INSERT INTO phpbb_words VALUES (5, 'horeshit', 'horsecrap');
INSERT INTO phpbb_words VALUES (6, 'cunt', 'girl');
INSERT INTO phpbb_words VALUES (17, 'motherf*', 'motherf :_censored: er');
INSERT INTO phpbb_words VALUES (9, 'bullshit', 'bull :_censored:');
INSERT INTO phpbb_words VALUES (11, 'GodDamn', 'GD');
INSERT INTO phpbb_words VALUES (142, 'dam', ':_censored:');
INSERT INTO phpbb_words VALUES (14, 'asshole', 'butt-head');
INSERT INTO phpbb_words VALUES (15, 'goddam', 'GD');
INSERT INTO phpbb_words VALUES (16, 'fucker', 'f :_censored: er');
INSERT INTO phpbb_words VALUES (19, 'shit*', 's:_censored:t');
INSERT INTO phpbb_words VALUES (20, 'fag', 'boy-liker');
INSERT INTO phpbb_words VALUES (21, 'Homo', 'same-sex');
INSERT INTO phpbb_words VALUES (22, 'sucks', 'blows');
INSERT INTO phpbb_words VALUES (23, '*fuck*', 'F:_censored:k');
INSERT INTO phpbb_words VALUES (24, 'cunt*', ':_censored:');
INSERT INTO phpbb_words VALUES (25, 'dick*', ':_censored:');
INSERT INTO phpbb_words VALUES (26, '*shit*', 's:_censored:t');
INSERT INTO phpbb_words VALUES (28, 'Cock', ':_censored:');
INSERT INTO phpbb_words VALUES (29, 'motherfucker', '*beep*');
INSERT INTO phpbb_words VALUES (30, 'slut', 'sl :_censored: ut');
INSERT INTO phpbb_words VALUES (31, 'pussy', 'p:_censored:y');
INSERT INTO phpbb_words VALUES (32, 'prick', 'p:_censored:k');
INSERT INTO phpbb_words VALUES (33, 'screw', '*beep*');
INSERT INTO phpbb_words VALUES (34, 'tits', 'hooters');
INSERT INTO phpbb_words VALUES (35, 'kike', '*beep*');
INSERT INTO phpbb_words VALUES (156, 'Y\'allz', ':_censored:');
INSERT INTO phpbb_words VALUES (38, 'nigger', '*beep*');
INSERT INTO phpbb_words VALUES (39, 'piss*', 'PO\'d');
INSERT INTO phpbb_words VALUES (40, 'dego', '*beep*');
INSERT INTO phpbb_words VALUES (43, 'honkey', '*beep*');
INSERT INTO phpbb_words VALUES (44, 'cum', '*beep*');
INSERT INTO phpbb_words VALUES (45, 'nutsack', '*beep*');
INSERT INTO phpbb_words VALUES (46, 'testicles', '*beep*');
INSERT INTO phpbb_words VALUES (47, 'clits', '*beep*');
INSERT INTO phpbb_words VALUES (48, 'masturbat*', '*beep*');
INSERT INTO phpbb_words VALUES (50, 'twat', 'tw :_censored:t');
INSERT INTO phpbb_words VALUES (51, 'gay', '*beep*');
INSERT INTO phpbb_words VALUES (52, 'dago', '*beep*');
INSERT INTO phpbb_words VALUES (53, 'c0ck', '*beep*');
INSERT INTO phpbb_words VALUES (54, 'fuk*', '*beep*');
INSERT INTO phpbb_words VALUES (56, 'teets', '*beep*');
INSERT INTO phpbb_words VALUES (57, 'bastard', ':_censored:');
INSERT INTO phpbb_words VALUES (58, 'twaty', '*beep*');
INSERT INTO phpbb_words VALUES (59, 'assramer', '*beep*');
INSERT INTO phpbb_words VALUES (60, 'puta', '*beep*');
INSERT INTO phpbb_words VALUES (146, 'b*tch', 'B:_censored:h');
INSERT INTO phpbb_words VALUES (63, 'hore', '*beep*');
INSERT INTO phpbb_words VALUES (64, 'kuk', '*beep*');
INSERT INTO phpbb_words VALUES (65, 'kuksuger', '*beep*');
INSERT INTO phpbb_words VALUES (66, 'fag*', '*beep*');
INSERT INTO phpbb_words VALUES (67, 'ficken', '*beep*');
INSERT INTO phpbb_words VALUES (68, 'fcuk', '*beep*');
INSERT INTO phpbb_words VALUES (69, 'queef*', '*beep*');
INSERT INTO phpbb_words VALUES (70, 'sphencter', '*beep*');
INSERT INTO phpbb_words VALUES (71, 'b!tch', '*beep*');
INSERT INTO phpbb_words VALUES (72, 'titties', 'hooters');
INSERT INTO phpbb_words VALUES (74, 'Puto', '*beep*');
INSERT INTO phpbb_words VALUES (75, 'pr0n', '*beep*');
INSERT INTO phpbb_words VALUES (78, 'spic', '*beep*');
INSERT INTO phpbb_words VALUES (79, 'chink', '*beep*');
INSERT INTO phpbb_words VALUES (80, 'gook', '*beep*');
INSERT INTO phpbb_words VALUES (81, 'feg', '*beep*');
INSERT INTO phpbb_words VALUES (82, 'nigga', '*beep*');
INSERT INTO phpbb_words VALUES (83, 'h0r', '*beep*');
INSERT INTO phpbb_words VALUES (84, 'fux0r', '*beep*');
INSERT INTO phpbb_words VALUES (85, 'b17ch', '*beep*');
INSERT INTO phpbb_words VALUES (86, 'b1tch', '*beep*');
INSERT INTO phpbb_words VALUES (87, 'bi7ch', '*beep*');
INSERT INTO phpbb_words VALUES (88, 'h4x0r', '*beep*');
INSERT INTO phpbb_words VALUES (89, 'fatass', '*beep*');
INSERT INTO phpbb_words VALUES (90, 'feces', '*beep*');
INSERT INTO phpbb_words VALUES (91, 'pimpis', '*beep*');
INSERT INTO phpbb_words VALUES (93, 'dildo', '*beep*');
INSERT INTO phpbb_words VALUES (94, 'poontsee', '*beep*');
INSERT INTO phpbb_words VALUES (147, 'Hell', ':_censored:');
INSERT INTO phpbb_words VALUES (96, 'kraut', '*beep*');
INSERT INTO phpbb_words VALUES (97, 'nazis', 'N :_censored: s');
INSERT INTO phpbb_words VALUES (98, '@$$', '*beep*');
INSERT INTO phpbb_words VALUES (99, 'preud', '*beep*');
INSERT INTO phpbb_words VALUES (100, 'hoer', '*beep*');
INSERT INTO phpbb_words VALUES (101, 'scrotum', '*beep*');
INSERT INTO phpbb_words VALUES (102, 'whoar', '*beep*');
INSERT INTO phpbb_words VALUES (103, 'w00se', '*beep*');
INSERT INTO phpbb_words VALUES (104, 'lesbian', '*beep*');
INSERT INTO phpbb_words VALUES (105, 'foreskin', '*beep*');
INSERT INTO phpbb_words VALUES (107, 'sh!t*', '*beep*');
INSERT INTO phpbb_words VALUES (108, 'queer*', '*beep*');
INSERT INTO phpbb_words VALUES (109, 'nigger*', '*beep*');
INSERT INTO phpbb_words VALUES (110, 'shemale', '*beep*');
INSERT INTO phpbb_words VALUES (112, 'hoer*', '*beep*');
INSERT INTO phpbb_words VALUES (113, 'd4mn', '*beep*');
INSERT INTO phpbb_words VALUES (114, 'titty', 'hooter');
INSERT INTO phpbb_words VALUES (115, 'pendejo', '*beep*');
INSERT INTO phpbb_words VALUES (116, 'phuck', '*beep*');
INSERT INTO phpbb_words VALUES (117, 'cabron', '*beep*');
INSERT INTO phpbb_words VALUES (120, 'qaHbeh', '*beep*');
INSERT INTO phpbb_words VALUES (122, 'pusse', '*beep*');
INSERT INTO phpbb_words VALUES (123, 'lesbo', '*beep*');
INSERT INTO phpbb_words VALUES (124, 'teez', '*beep*');
INSERT INTO phpbb_words VALUES (125, '*dyke', '*beep*');
INSERT INTO phpbb_words VALUES (144, 'f*ck', 'F:_censored:k');
INSERT INTO phpbb_words VALUES (129, 'dike*', '*beep*');
INSERT INTO phpbb_words VALUES (131, 'ejackulate', '*beep*');
INSERT INTO phpbb_words VALUES (132, 'wetback*', '*beep*');
INSERT INTO phpbb_words VALUES (133, 'jism', '*beep*');
INSERT INTO phpbb_words VALUES (134, 'jizz', '*beep*');
INSERT INTO phpbb_words VALUES (137, 'b!+ch', '*beep*');
INSERT INTO phpbb_words VALUES (138, 'bi+ch', '*beep*');
INSERT INTO phpbb_words VALUES (139, 'l3itch', '*beep*');
INSERT INTO phpbb_words VALUES (140, 'l3i+ch', '*beep*');
INSERT INTO phpbb_words VALUES (148, '"f*ck"', '*Beep*');
INSERT INTO phpbb_words VALUES (151, 'Allah', 'A:_censored:h');
INSERT INTO phpbb_words VALUES (150, 'punk', 'Censored');
INSERT INTO phpbb_words VALUES (153, 'RA', ':_censored:');
INSERT INTO phpbb_words VALUES (154, 'Zeus', 'Z:_censored:S');
INSERT INTO phpbb_words VALUES (155, 'suck', 'S:_censored:K');





I'll have to figure out how to get it to post into here so that it does not censore it..

[Acedeal]

That did not work.
Here try this
http://www.dow-sniper.net/test/phpbb_bad_words_sql.txt

Yes, this works.. Once installed, just go into admin control panel and take out the ones you do not want. Some words are in here just to mess with Coby :).

[Father-Time.]

Great thanks man.
Did you have a look at the Tag-Board? Not quite sure really where it could go on this site even if you liked it. But wortth a look i think.

Couple of other things i need to look at, i am using invision the prefix on tables is different, presumably alli do is change it? The path to the smilies, that is local to your site, which area would i have to copy a smilie to? Any ideas, i am guessing it just picks it up from the smilie dir, but there is no way of seeing is there?

Sel

Thanks again

[Acedeal]

no clue on how your system is setup, in PhpBB it's forum/images/smilie or something like that..
it really does not matter where the smiles are, as long as your board knows.. What you are doing is replacing a word with a smiley code is all..

[-=DoW=- MauryMac]

Some words are in here just to mess with Coby :).

:lol:

[Father-Time.]

Thanks Ace!! :banger:

Father