#Sql120640_5 CREATE TABLE JGB_smilies ( smilie_id mediumint(4) NOT NULL auto_increment, smilietext varchar(20) NOT NULL, smilieurl varchar(255) NOT NULL, PRIMARY KEY (smilie_id), UNIQUE smilie_id (smilie_id)); CREATE TABLE JGB_settings ( setting_id smallint(4) NOT NULL auto_increment, title varchar(255) NOT NULL, content mediumtext NOT NULL, PRIMARY KEY (setting_id), UNIQUE setting_id (setting_id)); CREATE TABLE JGB_entries ( id smallint(4) NOT NULL auto_increment, name varchar(150) NOT NULL, email varchar(250) NOT NULL, homepage longtext, location varchar(200), icq varchar(50), aim varchar(50), yim varchar(50), age smallint(2), entry longtext NOT NULL, ipaddress varchar(150) NOT NULL, hostname varchar(150) NOT NULL, entrydate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, active tinyint(1) DEFAULT '0' NOT NULL, spamid varchar(200) NOT NULL, PRIMARY KEY (id), UNIQUE id (id)); INSERT INTO JGB_settings VALUES ( '1', 'tablewidth_gb', '90%'); INSERT INTO JGB_settings VALUES ( '2', 'tablewidth_reg', '80%'); INSERT INTO JGB_settings VALUES ( '3', 'tbheader_bgcolor', '#113274'); INSERT INTO JGB_settings VALUES ( '4', 'fontface', 'Verdana, Arial'); INSERT INTO JGB_settings VALUES ( '5', 'fontheader', '2'); INSERT INTO JGB_settings VALUES ( '6', 'fontnormal', '2'); INSERT INTO JGB_settings VALUES ( '7', 'fontsmall', '1'); INSERT INTO JGB_settings VALUES ( '8', 'fontheadercolor', '#FFFFFF'); INSERT INTO JGB_settings VALUES ( '9', 'fontnormalcolor', '#000000'); INSERT INTO JGB_settings VALUES ( '10', 'fontentrycolor', '#000000'); INSERT INTO JGB_settings VALUES ( '11', 'Submit', 'Invia le modifiche al testo'); INSERT INTO JGB_settings VALUES ( '12', 'tb_bgcolor', '#C3C3EB'); INSERT INTO JGB_settings VALUES ( '13', 'totalentries_text', 'Messaggi totali:'); INSERT INTO JGB_settings VALUES ( '14', 'name_text', 'Nome:'); INSERT INTO JGB_settings VALUES ( '15', 'homepage_text', 'Homepage:'); INSERT INTO JGB_settings VALUES ( '16', 'location_text', 'Provenienza:'); INSERT INTO JGB_settings VALUES ( '17', 'entry_text', 'Messaggio:'); INSERT INTO JGB_settings VALUES ( '18', 'postdate_text', 'Data:'); INSERT INTO JGB_settings VALUES ( '19', 'email_text', 'Email:'); INSERT INTO JGB_settings VALUES ( '20', 'tbentryheader_text', 'Justice Guestbook'); INSERT INTO JGB_settings VALUES ( '21', 'entryrequire_text', 'Campo obbligatorio'); INSERT INTO JGB_settings VALUES ( '22', 'entrysubmit_text', 'Aggiungi messaggio al Guestbook'); INSERT INTO JGB_settings VALUES ( '23', 'welcome_text', 'Benvenuto nel Guestbook di Justice Media. Inserisci un tuo commento (ma NON richieste o suggerimenti) nel guestbook!'); INSERT INTO JGB_settings VALUES ( '24', 'entrytop_text', 'Scrivi il tuo messaggio compilando il modulo qui sotto. Grazie!'); INSERT INTO JGB_settings VALUES ( '25', 'contacturl', 'http://www.tuosito.it'); INSERT INTO JGB_settings VALUES ( '26', 'contacturl_text', 'Tuo sito'); INSERT INTO JGB_settings VALUES ( '27', 'contactemail', 'info@tuosito.it'); INSERT INTO JGB_settings VALUES ( '28', 'contactemail_text', 'Scrivimi'); INSERT INTO JGB_settings VALUES ( '29', 'postsperpage', '15'); INSERT INTO JGB_settings VALUES ( '32', 'addentry_graphic', 'img/addentry.jpg'); INSERT INTO JGB_settings VALUES ( '33', 'addentry_alt', 'Aggiungi messaggio al Guestbook'); INSERT INTO JGB_settings VALUES ( '34', 'email_graphic', 'img/email.gif'); INSERT INTO JGB_settings VALUES ( '35', 'email_alt', 'Email dell\'autore'); INSERT INTO JGB_settings VALUES ( '36', 'homepage_graphic', 'img/home.gif'); INSERT INTO JGB_settings VALUES ( '37', 'homepage_alt', 'Homepage dell\'autore'); INSERT INTO JGB_settings VALUES ( '38', 'edit_graphic', 'img/edit.gif'); INSERT INTO JGB_settings VALUES ( '39', 'edit_alt', 'Modifica / Cancella Messaggio'); INSERT INTO JGB_settings VALUES ( '40', 'thankyou_text', 'Grazie per aver aggiunto il tuo messaggio.'); INSERT INTO JGB_settings VALUES ( '41', 'backtogb_text', 'Torna al Guestbook'); INSERT INTO JGB_settings VALUES ( '42', 'addentrylink_text', 'Aggiungi messaggio al Guestbook'); INSERT INTO JGB_settings VALUES ( '43', 'notfilled_text', 'Non tutti i campi obbligatori sono stati compilati in modo corretto !'); INSERT INTO JGB_settings VALUES ( '45', 'emailtomaster', '0'); INSERT INTO JGB_settings VALUES ( '44', 'censorwords', 'fuck;anal;suck;ass;shit;hitler;nazi;adolf;communism;stalin;guevara'); INSERT INTO JGB_settings VALUES ( '46', 'masteremail', 'webmaster@tuosito.it'); INSERT INTO JGB_settings VALUES ( '47', 'emailtouser', '0'); INSERT INTO JGB_settings VALUES ( '48', 'emailsubject', 'Grazie per il tuo messaggio in Justice Media'); INSERT INTO JGB_settings VALUES ( '49', 'emailtext', 'Ciao,abbiamo ricevuto il tuo messaggio nel guestbook e speriamo che il sito ti sia piaciuto. Torna presto a trovarci.'); INSERT INTO JGB_settings VALUES ( '50', 'censor', '0'); INSERT INTO JGB_settings VALUES ( '51', 'smilies', '0'); INSERT INTO JGB_settings VALUES ( '52', 'pages_text', 'Pagine'); INSERT INTO JGB_settings VALUES ( '53', 'moderate', '0'); INSERT INTO JGB_settings VALUES ( '54', 'version', '1.3'); INSERT INTO JGB_settings VALUES ( '55', 'maxlength', '50'); INSERT INTO JGB_settings VALUES ( '56', 'maxpages', '10'); INSERT INTO JGB_settings VALUES (57,'allowemail','1'); INSERT INTO JGB_settings VALUES (58,'allowhomepage','1'); INSERT INTO JGB_settings VALUES (59,'allowicq','0'); INSERT INTO JGB_settings VALUES (60,'allowaim','0'); INSERT INTO JGB_settings VALUES (61,'allowyim','0'); INSERT INTO JGB_settings VALUES (62,'allowage','0'); INSERT INTO JGB_settings VALUES (63,'allowlocation','1'); INSERT INTO JGB_settings VALUES (64,'requireemail','1'); INSERT INTO JGB_settings VALUES (65,'requirehomepage','0'); INSERT INTO JGB_settings VALUES (66,'requireicq','0'); INSERT INTO JGB_settings VALUES (67,'requireaim','0'); INSERT INTO JGB_settings VALUES (68,'requireyim','0'); INSERT INTO JGB_settings VALUES (69,'requireage','0'); INSERT INTO JGB_settings VALUES (70,'requirelocation','0'); INSERT INTO JGB_settings VALUES (71,'icq_text','ICQ:'); INSERT INTO JGB_settings VALUES (72,'aim_text','AIM:'); INSERT INTO JGB_settings VALUES (73,'yim_text','Yahoo:'); INSERT INTO JGB_settings VALUES (74,'age_text','Età:'); INSERT INTO JGB_settings VALUES (75,'icq_graphic',''); INSERT INTO JGB_settings VALUES (76,'icq_alt','ICQ dell\'autore'); INSERT INTO JGB_settings VALUES (77,'aim_graphic','img/aim.gif'); INSERT INTO JGB_settings VALUES (78,'aim_alt','AIM dell\'autore'); INSERT INTO JGB_settings VALUES (79,'yim_graphic','img/yim.gif'); INSERT INTO JGB_settings VALUES (80,'yim_alt','YIM dell\'autore'); INSERT INTO JGB_settings VALUES (81,'smile_count','10'); INSERT INTO JGB_settings VALUES (82,'nextpage_text','Pagina seguente'); INSERT INTO JGB_settings VALUES (83,'lastpage_text','Pagina precedente'); INSERT INTO JGB_smilies VALUES ( '1', ':)', 'img/smilies/smile.gif'); INSERT INTO JGB_smilies VALUES ( '2', ':(', 'img/smilies/mad.gif'); INSERT INTO JGB_smilies VALUES ( '3', ':D', 'img/smilies/biggrin.gif'); INSERT INTO JGB_smilies VALUES ( '4', '8)', 'img/smilies/cool.gif'); INSERT INTO JGB_smilies VALUES ( '5', ':o', 'img/smilies/ohh.gif'); INSERT INTO JGB_smilies VALUES ( '6', ';)', 'img/smilies/wink.gif'); INSERT INTO JGB_smilies VALUES ( '7', ':p', 'img/smilies/tongue.gif');