| now ShoutBlock is compatible */ /* with PHPNUKE 6.0/6.5/6.7 ... */ /************************************************************************/ global $user, $banners, $sitename, $slogan, $cookie, $prefix, $dbi, $Submit, $comment, $REMOTE_ADDR, $uid; $anon = "no"; //$username = $cookie[1]; //Added by Laurent Wiart to get the right lang file (even in the block file !) require_once('mainfile.php'); $module_name = basename(dirname(__FILE__)); get_lang($module_name); //exit; // LW: THE FOLLOWING ALLOW THE DB ABSTRACTION FOR phpNuke 6.0 AND > 6.5 !! if (file_exists("db/db.php")){ //phpNuke version >= 6.5 new OO SQL abstraction function lwsql_query($sql){ global $db; return $db->sql_query($sql); } function lwsql_fetchrow($result = ''){ global $db; return $db->sql_fetchrow($result); } function lwsql_numrows($result = ''){ global $db; return $db->sql_numrows($result); } function lwsql_error(){ global $db; return $db->sql_error(); } function lwsql_freeresult($result = ''){ global $db; return $db->sql_freeresult($result); } }else{ //phpNuke 6.0 with sql_layer.php function lwsql_query($sql){ global $dbi; return sql_query($sql, $dbi); } function lwsql_fetchrow($result = ''){ global $dbi; return sql_fetch_row($result); } function lwsql_numrows($result = ''){ // global $dbi; return sql_num_rows($result); } //no specific error treatment in old abstraction layer ... function lwsql_error(){ if (function_exists('mysql_error')){ return mysql_error(); }else{ return "SQL Error !!"; } } function lwsql_freeresult($result = ''){ return sql_free_result($result); } } //Get the $conf array for use below and in all files that include this one $result = lwsql_query("select * from ".$prefix."_quiecom_shoutblock_conf"); $conf = lwsql_fetchrow($result); lwsql_freeresult($result); //LW: new function added for the db installation --> used in several places function install() { global $prefix; //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock ( id int(9) DEFAULT '0' NOT NULL auto_increment, name varchar(20) NOT NULL, comment text NOT NULL, date varchar(10) NOT NULL, time varchar(10) NOT NULL, PRIMARY KEY (id))"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock VALUES (1,'Quiecom','Welcome to shoutblock','08-21-02','24:00')"); //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock_conf"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock_conf (id int(9) DEFAULT '0' NOT NULL auto_increment, color1 varchar(20) NOT NULL, color2 varchar(20) NOT NULL, date varchar(5) NOT NULL, time varchar(5) NOT NULL, number varchar(5) NOT NULL, ipblock varchar(5) NOT NULL, nameblock varchar(5) NOT NULL, censor varchar(5) NOT NULL, tablewidth varchar(3) NOT NULL, urlonoff varchar(5) NOT NULL, delyourlastpost varchar(5) NOT NULL, anonymouspost varchar(5) NOT NULL, height varchar(5) NOT NULL, themecolors varchar(5) NOT NULL, username varchar(15) DEFAULT 'Anonymous' NOT NULL, emoticonlen varchar(15) DEFAULT '7' NOT NULL, display_nbshouts_in_module varchar(15) DEFAULT '25' NOT NULL, display_errors varchar(5) DEFAULT 'no' NOT NULL, hour_decal tinyint DEFAULT 0 NOT NULL, PRIMARY KEY (id))"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_conf VALUES (1,'red','blue' ,'yes' ,'yes','10','yes','yes','yes','150','yes','yes','no','150','yes','Anonymous','7', '25', 'no', 0)"); //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock_emoticons"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock_emoticons (id int(9) DEFAULT '0' NOT NULL auto_increment, text varchar(20) NOT NULL, image varchar(50) NOT NULL, PRIMARY KEY (id))"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (1,'%-|', 'confused.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (2,'%-(', 'sigh.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (3,'X-|', 'sleep.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (4,':-(', 'upset.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (5,'$-|', 'rolleyes.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (6,':mad:', 'mad.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (7,':yes:', 'yes.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (8,':no:', 'no.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (9,':shy:', 'shy.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (10,':laugh:', 'laugh.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (11,':dead:', 'dead.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (12,':cry:', 'cry.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (13,':-)', 'smile.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (14,':-(', 'sad.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (15,';-)', 'smilewinkgrin.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (16,':-|', 'none.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (17,'B-)', 'cool.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (18,':-D', 'biggrin.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (19,':-b', 'bigrazz.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (20,':-o', 'bigeek.gif')"); //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock_ipblock"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock_ipblock ( id int(9) DEFAULT '0' NOT NULL auto_increment, name varchar(50) NOT NULL, PRIMARY KEY (id))"); // lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_ipblock VALUES (1,'127.0.0.1')"); //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock_nameblock"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock_nameblock ( id int(9) DEFAULT '0' NOT NULL auto_increment, name varchar(50) NOT NULL, PRIMARY KEY (id))"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_nameblock VALUES (1,'badname')"); //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock_censor"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock_censor ( id int(9) DEFAULT '0' NOT NULL auto_increment, text varchar(20) NOT NULL, replacement varchar(20) NOT NULL, PRIMARY KEY (id))"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(1,'\@\$\$','butt')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(2,'a\$\$','butt')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(3,'anton','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(4,'arse','butt')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(5,'arsehole','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(6,'ass','butt')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(7,'ass muncher','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(8,'asshole','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(9,'asstooling','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(10,'asswipe','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(11,'b\!tch','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(12,'b17ch','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(13,'b1tch','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(14,'bastard','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(15,'beefcurtins','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(16,'bi7ch','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(17,'bitch','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(18,'bitchy','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(19,'boiolas','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(20,'bollocks','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(21,'breasts','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(22,'brown nose','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(23,'bugger','damn')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(24,'butt pirate','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(25,'c0ck','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(26,'cawk','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(27,'chink','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(28,'clitsaq','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(29,'cock','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(30,'cockbite','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(31,'cockgobbler','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(32,'cocksucker','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(33,'cum','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(34,'cunt','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(35,'dago','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(36,'daygo','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(37,'dego','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(38,'dick','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(39,'dick wad','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(40,'dickhead','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(41,'dickweed','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(42,'douchebag','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(43,'dziwka','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(44,'ekto','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(45,'enculer','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(46,'faen','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(47,'fag','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(48,'faggot','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(49,'fart','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(50,'fatass','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(51,'feg','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(52,'felch','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(53,'ficken','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(54,'fitta','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(55,'fitte','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(56,'flikker','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(57,'fok','$#%!')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(58,'fuck','$#%!')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(59,'fu\(k','$#%!')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(60,'fucker','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(61,'fucking','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(62,'fuckwit','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(63,'fuk','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(64,'fuking','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(65,'futkretzn','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(66,'fux0r','$#%!')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(67,'gook','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(68,'h0r','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(69,'handjob','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(70,'helvete','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(71,'honkey','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(72,'hore','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(73,'hump','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(74,'injun','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(75,'kawk','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(76,'kike','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(77,'knulle','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(78,'kraut','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(79,'kuk','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(80,'kuksuger','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(81,'kurac','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(82,'kurwa','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(83,'langer','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(84,'masturbation','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(85,'merd','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(86,'motherfucker','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(87,'motherfuckingcocksucker','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(88,'mutherfucker','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(89,'nepesaurio','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(90,'nigga','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(91,'nigger','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(92,'nonce','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(93,'nutsack','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(94,'one\-eyed\-trouser\-snake','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(95,'penis','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(96,'picka','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(97,'pissant','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(98,'pizda','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(99,'politician','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(100,'prick','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(101,'puckface','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(102,'pule','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(103,'pussy','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(104,'puta','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(105,'puto','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(106,'rimjob','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(107,'rubber','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(108,'scheisse','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(109,'schlampe','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(110,'schlong','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(111,'screw','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(112,'shit','****')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(113,'shiteater','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(114,'shiz','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(115,'skribz','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(116,'skurwysyn','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(117,'slut','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(118,'spermburper','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(119,'spic','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(120,'spierdalaj','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(121,'splooge','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(122,'spunk','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(123,'tatas','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(124,'tits','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(125,'toss the salad','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(126,'twat','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(127,'unclefucker','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(128,'vagina','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(129,'vittu','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(130,'votze','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(131,'wank','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(132,'wanka','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(133,'wanker','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(134,'wankers','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(135,'wankstain','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(136,'whore','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(137,'wichser','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(138,'wop','[censored]')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(139,'yed','[censored]')"); Header("Location: admin.php?op=qshout"); // exit; } //LW: new function added for the db installation --> used in several places // French version for censor, welcome messages, banned names, ... function install_fr() { global $prefix; //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock ( id int(9) DEFAULT '0' NOT NULL auto_increment, name varchar(20) NOT NULL, comment text NOT NULL, date varchar(10) NOT NULL, time varchar(10) NOT NULL, PRIMARY KEY (id))"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock VALUES (1,'Quiecom','Bienvenue sur ShoutBlock','08-21-02','24:00')"); //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock_conf"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock_conf (id int(9) DEFAULT '0' NOT NULL auto_increment, color1 varchar(20) NOT NULL, color2 varchar(20) NOT NULL, date varchar(5) NOT NULL, time varchar(5) NOT NULL, number varchar(5) NOT NULL, ipblock varchar(5) NOT NULL, nameblock varchar(5) NOT NULL, censor varchar(5) NOT NULL, tablewidth varchar(3) NOT NULL, urlonoff varchar(5) NOT NULL, delyourlastpost varchar(5) NOT NULL, anonymouspost varchar(5) NOT NULL, height varchar(5) NOT NULL, themecolors varchar(5) NOT NULL, username varchar(15) DEFAULT 'Anonyme' NOT NULL, emoticonlen varchar(15) DEFAULT '7' NOT NULL, display_nbshouts_in_module varchar(15) DEFAULT '25' NOT NULL, display_errors varchar(5) DEFAULT 'no' NOT NULL, hour_decal tinyint DEFAULT 0 NOT NULL, PRIMARY KEY (id))"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_conf VALUES (1,'red','blue' ,'yes' ,'yes','10','yes','yes','yes','150','yes','yes','no','150','yes','Anonyme','7', '25', 'no', 0)"); //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock_emoticons"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock_emoticons (id int(9) DEFAULT '0' NOT NULL auto_increment, text varchar(20) NOT NULL, image varchar(50) NOT NULL, PRIMARY KEY (id))"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (1,'%-|', 'confused.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (2,'%-(', 'sigh.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (3,'X-|', 'sleep.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (4,':-(', 'upset.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (5,'$-|', 'rolleyes.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (6,':mad:', 'mad.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (7,':yes:', 'yes.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (8,':no:', 'no.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (9,':shy:', 'shy.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (10,':laugh:', 'laugh.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (11,':dead:', 'dead.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (12,':cry:', 'cry.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (13,':-)', 'smile.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (14,':-(', 'sad.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (15,';-)', 'smilewinkgrin.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (16,':-|', 'none.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (17,'B-)', 'cool.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (18,':-D', 'biggrin.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (19,':-b', 'bigrazz.gif')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_emoticons VALUES (20,':-o', 'bigeek.gif')"); //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock_ipblock"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock_ipblock ( id int(9) DEFAULT '0' NOT NULL auto_increment, name varchar(50) NOT NULL, PRIMARY KEY (id))"); // lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_ipblock VALUES (1,'127.0.0.1')"); //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock_nameblock"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock_nameblock ( id int(9) DEFAULT '0' NOT NULL auto_increment, name varchar(50) NOT NULL, PRIMARY KEY (id))"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_nameblock VALUES (1,'mauvaisnom')"); //drop, create, insert lwsql_query("DROP TABLE IF EXISTS ".$prefix."_quiecom_shoutblock_censor"); lwsql_query("CREATE TABLE ".$prefix."_quiecom_shoutblock_censor ( id int(9) DEFAULT '0' NOT NULL auto_increment, text varchar(20) NOT NULL, replacement varchar(20) NOT NULL, PRIMARY KEY (id))"); $censor = '****'; lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(1,'encul','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(2,'trouduc','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(3,'salaud','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(4,'salope','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(5,'pute','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(6,'putain','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(7,'batard','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(8,'couille','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(9,'nibards','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(10,'troufion','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(11,'bite','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(12,'fuck','$#%!')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(13,'fu\(k','$#%!')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(14,'fucker','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(15,'fucking','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(16,'motherfucker','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(17,'fuk','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(18,'fuking','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(19,'penis','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(20,'politicien','$censor')"); lwsql_query("INSERT INTO ".$prefix."_quiecom_shoutblock_censor VALUES(21,'foufoune','$censor')"); Header("Location: admin.php?op=qshout"); // exit; } ?> |
