Jump to content
Fórum Script Brasil

drodrigo

Membros
  • Posts

    32
  • Joined

  • Last visited

About drodrigo

  • Birthday 11/24/1983

Contatos

drodrigo's Achievements

0

Reputation

  1. O cÓDIGO E ESSE? <script type="text/javascript"> /*********************************************** * Conveyor belt slideshow script- © Dynamic Drive DHTML code library (www.dynamicdrive.com) * This notice MUST stay intact for legal use * Visit Dynamic Drive at http://www.dynamicdrive.com/ for full source code ***********************************************/ //Specify the slider's width (in pixels) var sliderwidth="300px" //Specify the slider's height var sliderheight="150px" //Specify the slider's slide speed (larger is faster 1-10) var slidespeed=3 //configure background color: slidebgcolor="#EAEAEA" //Specify the slider's images var leftrightslide=new Array() var finalslide='' leftrightslide[0]='<a href="http://"><img src="dynamicbook1.gif" border=1></a>' leftrightslide[1]='<a href="http://"><img src="dynamicbook2.gif" border=1></a>' leftrightslide[2]='<a href="http://"><img src="dynamicbook3.gif" border=1></a>' leftrightslide[3]='<a href="http://"><img src="dynamicbook4.gif" border=1></a>' leftrightslide[4]='<a href="http://"><img src="dynamicbook5.gif" border=1></a>' //Specify gap between each image (use HTML): var imagegap=" " //Specify pixels gap between each slideshow rotation (use integer): var slideshowgap=5 ////NO NEED TO EDIT BELOW THIS LINE//////////// var copyspeed=slidespeed leftrightslide='<nobr>'+leftrightslide.join(imagegap)+'</nobr>' var iedom=document.all||document.getElementById if (iedom) document.write('<span id="temp" style="visibility:hidden;position:absolute;top:-100px;left:-9000px">'+leftrightslide+'</span>') var actualwidth='' var cross_slide, ns_slide function fillup(){ if (iedom){ cross_slide=document.getElementById? document.getElementById("test2") : document.all.test2 cross_slide2=document.getElementById? document.getElementById("test3") : document.all.test3 cross_slide.innerHTML=cross_slide2.innerHTML=leftrightslide actualwidth=document.all? cross_slide.offsetWidth : document.getElementById("temp").offsetWidth cross_slide2.style.left=actualwidth+slideshowgap+"px" } else if (document.layers){ ns_slide=document.ns_slidemenu.document.ns_slidemenu2 ns_slide2=document.ns_slidemenu.document.ns_slidemenu3 ns_slide.document.write(leftrightslide) ns_slide.document.close() actualwidth=ns_slide.document.width ns_slide2.left=actualwidth+slideshowgap ns_slide2.document.write(leftrightslide) ns_slide2.document.close() } lefttime=setInterval("slideleft()",30) } window.onload=fillup function slideleft(){ if (iedom){ if (parseInt(cross_slide.style.left)>(actualwidth*(-1)+8)) cross_slide.style.left=parseInt(cross_slide.style.left)-copyspeed+"px" else cross_slide.style.left=parseInt(cross_slide2.style.left)+actualwidth+slideshowgap+"px" if (parseInt(cross_slide2.style.left)>(actualwidth*(-1)+8)) cross_slide2.style.left=parseInt(cross_slide2.style.left)-copyspeed+"px" else cross_slide2.style.left=parseInt(cross_slide.style.left)+actualwidth+slideshowgap+"px" } else if (document.layers){ if (ns_slide.left>(actualwidth*(-1)+8)) ns_slide.left-=copyspeed else ns_slide.left=ns_slide2.left+actualwidth+slideshowgap if (ns_slide2.left>(actualwidth*(-1)+8)) ns_slide2.left-=copyspeed else ns_slide2.left=ns_slide.left+actualwidth+slideshowgap } } if (iedom||document.layers){ with (document){ document.write('<table border="0" cellspacing="0" cellpadding="0"><td>') if (iedom){ write('<div style="position:relative;width:'+sliderwidth+';height:'+sliderheight+';overflow:hidden">') write('<div style="position:absolute;width:'+sliderwidth+';height:'+sliderheight+';background-color:'+slidebgcolor+'" onMouseover="copyspeed=0" onMouseout="copyspeed=slidespeed">') write('<div id="test2" style="position:absolute;left:0px;top:0px"></div>') write('<div id="test3" style="position:absolute;left:-1000px;top:0px"></div>') write('</div></div>') } else if (document.layers){ write('<ilayer width='+sliderwidth+' height='+sliderheight+' name="ns_slidemenu" bgColor='+slidebgcolor+'>') write('<layer name="ns_slidemenu2" left=0 top=0 onMouseover="copyspeed=0" onMouseout="copyspeed=slidespeed"></layer>') write('<layer name="ns_slidemenu3" left=0 top=0 onMouseover="copyspeed=0" onMouseout="copyspeed=slidespeed"></layer>') write('</ilayer>') } document.write('</td></table>') } } </script> <p align="center"><font face="Arial" size="-2">Free DHTML scripts provided by<br> <a href="http://dynamicdrive.com">Dynamic Drive</a></font></p>
  2. Ola galera beleza. eu não sei se vocês podem me ajudar mais eu vou tentar. Eu estou com uma pequena duvida numa linha de código que irei mostrar a vocês. O código está otimo e funcionando beleza, ele vai passando pro lado esquerdo esse eu já consegui, so que agora eu queria que ele fosse subindo para cima, e não sei aonde mudar a linha do código ou qual nome dar, e gostária de saber se vocês podem me ajudar com essa pequena duvida. o site do exemplo com o código e esse. Exemplo do Código fonte Aqueles que puderem me ajudar obrigado. Não é vírus viu galera, e so a página de sites de código Obrigado pela atenção.
  3. Po legal, e d euma rádio assim que eu tb estou atraz... será que alguém tem algum script ou algum tutorial que ensina como montar uma rádio assim... Abraços
  4. Boa tarde galera, Pessoal eu to aqui a procura de um script de uma rádio online ou uma rádio virtual, acho que e a mesma coisa. Será que alguém poderia me indicar algum script bom, pois to querendo colocar uma rádio em meu site. A rádio mais ou menos que eu quero pode ser parecida com essa, mais eu não queria igual, queria outra diferente. www.bsbcountry.com.br alguém poderir alguma dica onde posso encontrar? Abraços
  5. drodrigo

    Upload De Imagem

    Ahhh... agora deu para entender! bem, vou testar aqui. Valeu Obrigado.
  6. drodrigo

    Upload De Imagem

    Bem, então o problema está comigo.. rss nem descobri aonde coloca o o e-mail para que as informações sejam enviadas para ele. Pode me ajudar?
  7. drodrigo

    Upload De Imagem

    Humm esse tópicpo que me passou, o código não funciona... ta cheio de erros.... Algum outro topíco?
  8. drodrigo

    Upload De Imagem

    Galera, alguém conheçe algum script ou algum site que eu possa encontrar um Upload de imagens com um pequeno formulário junto, onde todas as informações em vez de ser enviada para o diretório do servidor ir para o e-mail? Abraços
  9. Pessoal, eu queria uma ajuda em meu site. Eu estou com um mural linkdado em um iframe, so que o mural está cortando o iframe, para direita e eu queria deixar ele so com a barra de rolagem para horizontal. No entando, eu estava querendo é diminuir o quadro cinza onde os usuários estão postando as mensagem, sendo q não fique aquela barra rolando para direita incluindo normal so a página decendo. alguém pode me ajudar a onde eu posso modificar esse código para que fique com o quadro um pouco menor? Para verificar melhor, de uma olhadinha em meu site como está. BsBCountry - Mural Abraços
  10. drodrigo

    Help Desk

    Boa tarde galera. Pessoal eu estou com um pequeno problema. Eu estou colocando um helpdesk no site da minha empresa, e peguei ele aqui do próprio ScriptBrasil. Fui tudo certo, so que na hora de executar ele no mysql ele ocorre erro e não consigo criar as tabelas para fazer rodar o sistema. será que alguém poderia me ajudar nesse código do mysql e ver o que tem de errado? Abraços /* helpdesk.sql ** ** This is the SQL schema file for Liberum Helpdesk. ** It was created using SQL Server 2000 but should work fine under ** 6.5 or newer. ** ** Before using, change the FILENAME locations in the CREATE DATABASE ** statement to match your SQL server settings. ** ** Version: 0.97 ** ** $Revision: 1.10 $ ** $Date: 2002/01/02 21:18:56 $ */ USE master GO CREATE DATABASE HelpDesk ON ( NAME = HelpDesk, FILENAME = 'c:\mssql\data\helpdesk.mdf', SIZE = 5, FILEGROWTH = 5 ) LOG ON ( NAME = 'HelpDesk_log', FILENAME = 'c:\mssql\data\helpdesk_log.ldf', SIZE = 5MB, FILEGROWTH = 5MB ) GO USE HelpDesk GO CREATE TABLE [dbo].[categories] ( [category_id] [int] NOT NULL , [cname] [varchar] (50) NULL , [rep_id] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[db_keys] ( [problems] [int] NULL , [departments] [int] NULL , [categories] [int] NULL , [users] [int] NULL , [Lang] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[departments] ( [department_id] [int] NOT NULL , [dname] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[priority] ( [priority_id] [int] NOT NULL , [pname] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[problems] ( [id] [int] NOT NULL , [uid] [varchar] (50) NULL , [uemail] [varchar] (50) NULL , [ulocation] [varchar] (50) NULL , [uphone] [varchar] (50) NULL , [rep] [int] NULL , [status] [int] NULL , [time_spent] [int] NULL , [category] [int] NULL , [priority] [int] NULL , [department] [int] NULL , [title] [varchar] (50) NULL , [description] [text] NULL , [solution] [text] NULL , [start_date] [datetime] NULL , [close_date] [datetime] NULL , [entered_by] [int] NULL , [kb] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[status] ( [status_id] [int] NOT NULL , [sname] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblConfig] ( [SiteName] [varchar] (50) NULL , [BaseURL] [varchar] (50) NULL , [AdminPass] [varchar] (50) NULL , [EmailType] [int] NULL , [SMTPServer] [varchar] (50) NULL , [HDName] [varchar] (50) NULL , [HDReply] [varchar] (50) NULL , [BaseEmail] [varchar] (50) NULL , [EnablePager] [int] NULL , [NotifyUser] [int] NULL , [EnableKB] [int] NULL , [DefaultPriority] [int] NULL , [DefaultStatus] [int] NULL , [CloseStatus] [int] NULL , [AuthType] [int] NULL , [Version] [varchar] (6) NULL , [UseSelectUser] [int] NULL , [UseInoutBoard] [int] NULL , [KBFreeText] [int] NULL , [DefaultLanguage] [int] NULL , [AllowImageUpload] [int] NULL , [MaxImageSize] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblConfig_Auth] ( [ID] [int] NOT NULL , [Type] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblConfig_Email] ( [ID] [int] NOT NULL , [Type] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblEmailMsg] ( [type] [varchar] (50) NOT NULL , [subject] [varchar] (50) NULL , [body] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[tblLangStrings] ( [id] [int] NOT NULL , [variable] [varchar] (50) NOT NULL , [LangText] [text] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[tblLanguage] ( [id] [int] NOT NULL , [LangName] [varchar] (50) NULL , [Localized] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblNotes] ( [id] [int] NOT NULL , [note] [text] NULL , [addDate] [datetime] NULL , [uid] [varchar] (50) NULL , [private] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[tblUsers] ( [sid] [int] NOT NULL , [uid] [varchar] (50) NULL , [password] [varchar] (50) NULL , [fname] [varchar] (50) NULL , [email1] [varchar] (50) NULL , [email2] [varchar] (50) NULL , [phone] [varchar] (50) NULL , [location1] [varchar] (50) NULL , [location2] [varchar] (50) NULL , [department] [int] NULL , [IsRep] [int] NULL , [dtCreated] [datetime] NULL , [dtLastAccess] [datetime] NULL , [ListOnInoutBoard] [int] NOT NULL , [firstname] [varchar] (50) NULL , [lastname] [varchar] (50) NULL , [inoutadmin] [int] NOT NULL , [phone_home] [varchar] (50) NULL , [phone_mobile] [varchar] (50) NULL , [jobfunction] [text] NULL , [userresume] [text] NULL , [statustext] [varchar] (255) NULL , [statuscode] [int] NOT NULL , [statusdate] [datetime] NULL , [Language] [int] NULL , [RepAccess] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[categories] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [category_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[departments] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [department_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[priority] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [priority_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[problems] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[status] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [status_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblConfig_Auth] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblConfig_Email] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblEmailMsg] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [type] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [sid] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD CONSTRAINT [DF_tblUsers_department] DEFAULT (0) FOR [department], CONSTRAINT [DF_tblUsers_IsRep] DEFAULT (0) FOR [IsRep], CONSTRAINT [DF_tblUsers_dtCreated] DEFAULT (getdate()) FOR [dtCreated], CONSTRAINT [DF_tblUsers_dtLastAccess] DEFAULT (getdate()) FOR [dtLastAccess], CONSTRAINT [DF__tblUsers__ListOn__267ABA7A] DEFAULT (1) FOR [ListOnInoutBoard], CONSTRAINT [DF__tblUsers__inouta__276EDEB3] DEFAULT (0) FOR [inoutadmin], CONSTRAINT [DF__tblUsers__status__286302EC] DEFAULT (0) FOR [statuscode], CONSTRAINT [DF__tblUsers__RepAcc__2B3F6F97] DEFAULT (0) FOR [RepAccess] GO INSERT INTO tblconfig ( SiteName, BaseURL, AdminPass, EmailType, SMTPServer, HDName, HDReply, BaseEmail, EnablePager, NotifyUser, EnableKB, DefaultPriority, DefaultStatus, CloseStatus, AuthType, Version, UseSelectUser, UseInoutBoard, KBFreeText, DefaultLanguage, AllowImageUpload, MaxImageSize ) VALUES ( 'Company Name', 'http://www.company.com/helpdesk', 'admin', 1, 'smtp.company.com', 'Consultant', '[email protected]', '@company.com', 0, 0, 2, 1, 1, 100, 2, '0.97', 1, 0, 0, 1, 0, 100000 ) GO INSERT INTO tblConfig_Auth (ID, Type) VALUES (1, 'NT Authentication') INSERT INTO tblConfig_Auth (ID, Type) VALUES (2, 'Database') INSERT INTO tblConfig_Auth (ID, Type) VALUES (3, 'External Authentication') GO INSERT INTO tblConfig_Email (ID, Type) VALUES (0, 'Disabled') INSERT INTO tblConfig_Email (ID, Type) VALUES (1, 'CDONTS') INSERT INTO tblConfig_Email (ID, Type) VALUES (2, 'JMail') INSERT INTO tblConfig_Email (ID, Type) VALUES (3, 'ASPEmail') INSERT INTO tblConfig_Email (ID, Type) VALUES (4, 'ASPMail') GO INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'repclose', 'HELPDESK: Problem [problemid] Closed', 'The following problem has been closed. You can view the problem at [rurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'Category: [category]' + CHAR(13) + CHAR(13) + 'SOLUTION' + CHAR(13) + '--------' + CHAR(13) + '[solution]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'repnew', 'HELPDESK: Problem [problemid] Assigned', 'The following problem has been assigned to you. You can update the problem at [rurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'Category: [category]' + CHAR(13) + CHAR(13) + 'USER INFORMATION' + CHAR(13) + '----------------' + CHAR(13) + 'Username: [uid]' + CHAR(13) + 'Email: [uemail]' + CHAR(13) + 'Phone: [phone]' + CHAR(13) + 'Location: [location]' + CHAR(13) + 'Department: [department]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'reppager', 'HELPDESK: Problem [problemid] Assigned', 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'User: [uid]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'repupdate', 'HELPDESK: Problem [problemid] Updated', 'The following problem has been updated. You can view the problem at [rurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'Category: [category]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' + CHAR(13) + CHAR(13) + 'NOTES' + CHAR(13) + '-----------' + CHAR(13) + '[notes]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'userclose', 'HELPDESK: Problem [problemid] Closed', 'Your help desk problem has been closed. You can view the solution below or at: [uurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + CHAR(13) + 'SOLUTION' + CHAR(13) + '--------' + CHAR(13) + '[solution]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ('usernew', 'HELPDESK: Problem [problemid] Created', 'Thank you for submitting your problem to the help desk. You can view or update the problem at: [uurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ('userupdate', 'HELPDESK: Problem [problemid] Updated', 'Your help desk problem has been updated. You can view the problem at: [uurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' + CHAR(13) + CHAR(13) + 'NOTES' + CHAR(13) + '-----------' + CHAR(13) + '[notes]' ) GO INSERT INTO tblUsers(sid, uid, fname, email1) VALUES (0, 'unknown', 'Unknown', '[email protected]') GO INSERT INTO db_keys(problems, departments, categories, users, Lang) VALUES (1,2,1,1,2) GO INSERT INTO status(status_id, sname) VALUES (0,'UNKNOWN') INSERT INTO status(status_id, sname) VALUES (1,'OPEN') INSERT INTO status(status_id, sname) VALUES (100,'CLOSED') GO INSERT INTO priority(priority_id, pname) VALUES (0,'UNKNOWN') INSERT INTO priority(priority_id, pname) VALUES (1,'LOW') INSERT INTO priority(priority_id, pname) VALUES (2,'HIGH') GO INSERT INTO departments(department_id, dname) VALUES (0,'UNKNOWN') INSERT INTO departments(department_id, dname) VALUES (1,'Dept1') GO INSERT INTO tblLanguage (id, LangName, Localized) VALUES (1, 'English', 'English') GO
  11. Bom dia galera. Pessoal eu estou com uma dificuldade que pra mim está dificil mais creio que para vocês deva ser simples. Seguinte eu estou tentando colocar o menu centralizado na página, que funcione em qualquer resolução ele tando sempre centralizado na página, e essa e minha difucldade, colocar ele na tabela para centralizar sem ta dando erro como está comigo. Estarei enviando o código do menu para vocês verificarem, e me ajudar como faço para colocar ele dentro da tabela, como faço para colocar as tags e mais. Ok. Claro se puder me ajudar nessa dúvida... Abraços galera. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="pt-br" xml:lang="pt-br"> <head> <meta name="keywords" content="tutorial,acessibilidade,css,css menu,estilo,folhas estilo,layout css,layout sites,menu css,paginas web,tutorial css,web design,web standards,webdesign,tableless" /> <meta name="description" content=" Tutoriais, macetes, dicas sobre uso das CSS para projetar sites." /> <meta name="author" content="Nick Rigby" /> <meta name="MSSmartTagsPreventParsing" content="true" /> <meta http-equiv="imagetoolbar" content="no" /> <meta http-equiv="Pragma" content="no-cache" /> <meta name="robots" content="all" /> <meta name="language" content="pt-br" /> <meta name="ICBM" content="-22.975781,-43.193082" /> <meta name="DC.title" content="CSS para Web Design" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Horizontal Drop Down Menus - Parte 3</title> <script type="text/javascript"> function IEHoverPseudo() { var navItems = document.getElementById("primary-nav").getElementsByTagName("li"); for (var i=0; i<navItems.length; i++) { if(navItems[i].className == "menuparent") { navItems[i].onmouseover=function() { this.className += " over"; } navItems[i].onmouseout=function() { this.className = "menuparent"; } } } } window.onload = IEHoverPseudo; </script> <style type="text/css"> body { font: normal 62.5% verdana; } ul#primary-nav, ul#primary-nav ul { margin: 0; padding: 0; /* width: 600px; */ /* Width of Menu Items */ border-bottom: 0px; solid #ccc; background: #fff; /* IE6 Bug */ /* background: blue; /* IE6 Bug */ cor do fundo dos menus font-size: 100%; } ul#primary-nav li { position: relative; list-style: none; display: inline; float:left; } ul#primary-nav li a { display: block; text-decoration: none; float:left; color: #777; /* color: red; cor das letras do menu */ padding: 5px; border: 1px solid #ccc; border-bottom: 1; } /* Fix IE. Hide from IE Mac \*/ * html ul#primary-nav li { float: left; height: 1%; } * html ul#primary-nav li a { height: 1%; } /* End */ ul#primary-nav ul { position: absolute; display: none; left: 0px; /* Set 1px less than menu width */ top: 23px; } ul#primary-nav li ul li a { padding: 2px 5px; } /* Sub Menu Styles */ ul#primary-nav li:hover ul ul , ul#primary-nav li:hover ul ul ul, ul#primary-nav li.over ul ul, ul#primary-nav li.over ul ul ul { display: none; top: 17px;} /* Hide sub-menus initially */ ul#primary-nav li:hover ul, ul#primary-nav li li:hover ul, ul#primary-nav li li li:hover ul, ul#primary-nav li.over ul, ul#primary-nav li li.over ul, ul#primary-nav li li li.over ul { display: block; } /* The magic */ ul#primary-nav li.menuparent { background: transparent url(arrow-down.gif) right center no-repeat; } /* ul#primary-nav li.menuparent { background: yellow url(arrow-down.gif) right center no-repeat; } Cor dos que tem o -> */ ul#primary-nav li.menuparent:hover, ul#primary-nav li.over { background-color: #f9f9f9; } /*ul#primary-nav li.over { background-color: blue } cor da selecao quando tem submenu */ ul#primary-nav li a:hover { color: #E2144A; } /*ul#primary-nav li a:hover { color: blue; background-color: blue} cor da letra dos menus com selecao / cor do fundo */ </style> </head> <body> <h1>EXEMPLO DE MENU PRINCIPAL NA HORIZONTAL</h1> <h2>Adaptação feita por:</h2>Marcos Antunes Moleiro<br><br> <ul id="primary-nav"> <li><a href="#">Home</a></li> <li class="menuparent"><a href="#">About </a> <ul> <li><a href="#">History</a></li> <li><a href="#">Team</a></li> <li><a href="#">Offices</a></li> </ul> </li> <li class="menuparent"><a href="#">Services </a> <ul> <li><a href="#">Web Design</a></li> <li><a href="#">Internet Marketing</a></li> <li class="menuparent"><a href="#">Hosting </a> <ul> <li><a href="#">Dedicated</a></li> <li><a href="#">Virtual</a></li> <li><a href="#">Shared</a></li> <li><a href="http://www.uem.br" target="_blank">Managed</a></li> </ul> </li> <li><a href="#">Domain Names</a></li> <li><a href="#">Broadband</a></li> </ul> </li> <li class="menuparent"><a href="#">Contact Us </a> <ul> <li><a href="#">United Kingdom</a></li> <li><a href="#">France</a></li> <li><a href="#">USA</a></li> <li><a href="#">Australia</a></li> </ul> </li> </ul> </body> </html>
  12. drodrigo

    Banco De Dados

    fala paulo, beleza ... pode deixar que vou dar uma lida legal nesses ai. abraços
  13. drodrigo

    Banco De Dados

    Boa noite pessoal. Galera, eu estou aqui para pedir uma ajuda, claro como eu e todos. Eu estou começando com php mysql asp e tudo mais, e estou desenvolvendo alguns sites com banco de dados, so que eu não conheço nenhum programa que posso rodar um banco de dados com php bom com configuraão simple mais boa. Preciso de um programa para fazer teste com banco, com php ou asp. Me indicaram alguns mais não consegui resolver pois n tinha um totu legal para ir passo a passo. será que alguém poderia me indicar um legal para mim fazer rodar o php em minha máquina. Grato. Rodrigo. :rolleyes:
  14. drodrigo

    Erro

    humm... cara não sei, pelo que um amigo disse falou que roda no mysql, bem vou tentar do seu modo e retorno ok. Abraços
  15. drodrigo

    Erro

    Boa noite galera. Eu estou com um problema na hora de executar o banco de dados que eu tenho aqui de Suporte Online. Quando executo ele original do jeito que veio no arquivo ele demostra uma mensagem de erro e não consigo resolver este problema, por isso vim aqui pedir alguma ajuda se possivel e claro, me auxiliar neste problema. Código do Erro consulta SQL: /* helpdesk.sql ** ** This is the SQL schema file for Liberum Helpdesk. ** It was created using SQL Server 2000 but should work fine under ** 6.5 or newer. ** ** Before using, change the FILENAME locations in the CREATE DATABASE ** statement to match your SQL server settings. ** ** $Revision: 1.6 $ ** $Date: 2001/09/17 15:22:11 $ */ USE MASTER GO CREATE DATABASE HelpDesk ON ( NAME = HelpDesk, FILENAME = 'c:\mssql\data\helpdesk.mdf', SIZE =5, FILEGROWTH =5 )LOG ON ( NAME = 'HelpDesk_log', FILENAME = 'c:\mssql\data\helpdesk_log.ldf', SIZE = 5MB, FILEGROWTH = 5MB )GO USE HelpDeskGO CREATE TABLE [dbo].[categories]( [category_id][int] NOT NULL , [cname][varchar]( 50 ) NULL , [rep_id][int] NULL ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[db_keys]( [problems][int] NULL , [departments][int] NULL , [categories][int] NULL , [users][int] NULL ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[departments]( [department_id][int] NOT NULL , [dname][varchar]( 50 ) NULL ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[priority]( [priority_id][int] NOT NULL , [pname][varchar]( 50 ) NULL ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[problems]( [id][int] NOT NULL , [uid][varchar]( 50 ) NULL , [uemail][varchar]( 50 ) NULL , [ulocation][varchar]( 50 ) NULL , [uphone][varchar]( 50 ) NULL , [rep][int] NULL , [ STATUS ][int] NULL , [time_spent][int] NULL , [category][int] NULL , [priority][int] NULL , [department][int] NULL , [title][varchar]( 50 ) NULL , [description][text] NULL , [solution][text] NULL , [start_date][datetime] NULL , [close_date][datetime] NULL ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[ STATUS ]( [status_id][int] NOT NULL , [sname][varchar]( 50 ) NULL ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[tblConfig]( [SiteName][varchar]( 50 ) NULL , [BaseURL][varchar]( 50 ) NULL , [AdminPass][varchar]( 50 ) NULL , [EmailType][int] NULL , [SMTPServer][varchar]( 50 ) NULL , [HDName][varchar]( 50 ) NULL , [HDReply][varchar]( 50 ) NULL , [BaseEmail][varchar]( 50 ) NULL , [EnablePager][int] NULL , [NotifyUser][int] NULL , [EnableKB][int] NULL , [DefaultPriority][int] NULL , [DefaultStatus][int] NULL , [CloseStatus][int] NULL , [AuthType][int] NULL , [Color1][varchar]( 15 ) NULL , [Color2][varchar]( 15 ) NULL , [BGColor][varchar]( 15 ) NULL , [TextColor][varchar]( 15 ) NULL , [LinkColor][varchar]( 15 ) NULL , [VLinkcolor][varchar]( 15 ) NULL , [ALinkColor][varchar]( 15 ) NULL , [Version][varchar]( 6 ) NULL ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[tblConfig_Auth]( [ID][int] NOT NULL , [ TYPE ][varchar]( 50 ) NULL ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[tblConfig_Email]( [ID][int] NOT NULL , [ TYPE ][varchar]( 50 ) NULL ) ON [ PRIMARY ]GO CREATE TABLE [dbo].[tblEmailMsg]( [ TYPE ][varchar]( 50 ) NOT NULL , [subject][varchar]( 50 ) NULL , [body][text] NULL ) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[tblUsers]( [sid][int] NOT NULL , [uid][varchar]( 50 ) NULL , [ PASSWORD ][varchar]( 50 ) NULL , [fname][varchar]( 50 ) NULL , [email1][varchar]( 50 ) NULL , [email2][varchar]( 50 ) NULL , [phone][varchar]( 50 ) NULL , [location1][varchar]( 50 ) NULL , [location2][varchar]( 50 ) NULL , [department][int] NULL , [IsRep][int] NULL , [dtCreated][datetime] NULL , [dtLastAccess][datetime] NULL ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[categories] WITH NOCHECK ADD PRIMARY KEY CLUSTERED( [category_id] ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[departments] WITH NOCHECK ADD PRIMARY KEY CLUSTERED( [department_id] ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[priority] WITH NOCHECK ADD PRIMARY KEY CLUSTERED( [priority_id] ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[problems] WITH NOCHECK ADD PRIMARY KEY CLUSTERED( [id] ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[ STATUS ] WITH NOCHECK ADD PRIMARY KEY CLUSTERED( [status_id] ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[tblConfig_Auth] WITH NOCHECK ADD PRIMARY KEY CLUSTERED( [ID] ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[tblConfig_Email] WITH NOCHECK ADD PRIMARY KEY CLUSTERED( [ID] ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[tblEmailMsg] WITH NOCHECK ADD PRIMARY KEY CLUSTERED( [ TYPE ] ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD PRIMARY KEY CLUSTERED( [sid] ) ON [ PRIMARY ]GO ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD CONSTRAINT [DF_tblUsers_department]DEFAULT( 0 ) FOR [department], CONSTRAINT [DF_tblUsers_IsRep]DEFAULT( 0 ) FOR [IsRep], CONSTRAINT [DF_tblUsers_dtCreated]DEFAULT( getdate( ) ) FOR [dtCreated], CONSTRAINT [DF_tblUsers_dtLastAccess]DEFAULT( getdate( ) ) FOR [dtLastAccess]GO INSERT INTO tblconfig( SiteName, BaseURL, AdminPass, EmailType, SMTPServer, HDName, HDReply, BaseEmail, EnablePager, NotifyUser, EnableKB, DefaultPriority, DefaultStatus, CloseStatus, AuthType, Color1, Color2, BGColor, TextColor, LinkColor, VLinkColor, ALinkColor ) VALUES ( 'Company Name', 'http://www.company.com/helpdesk', 'admin', 1, 'smtp.company.com', 'Consultant', '[email protected]', '@company.com', 0, 0, 1, 1, 1, 100, 2, '#6080B0', '#EEEEEE', '#FFFFFF', '#000000', '#6080B0', '#7090C0', '#7090C0' )GO INSERT INTO tblConfig_Auth( ID, TYPE ) VALUES ( 1, 'NT Authentication' ) INSERT INTO tblConfig_Auth( ID, TYPE ) VALUES ( 2, 'Database' ) INSERT INTO tblConfig_Auth( ID, TYPE ) VALUES ( 3, 'External Authentication' ) GO INSERT INTO tblConfig_Email( ID, TYPE ) VALUES ( 0, 'Disabled' ) INSERT INTO tblConfig_Email( ID, TYPE ) VALUES ( 1, 'CDONTS' ) INSERT INTO tblConfig_Email( ID, TYPE ) VALUES ( 2, 'JMail' ) INSERT INTO tblConfig_Email( ID, TYPE ) VALUES ( 3, 'ASPEmail' ) GO INSERT INTO tblEmailMsg( TYPE , subject, body ) VALUES ( 'repclose', 'HELPDESK: Problem [problemid] Closed', 'The following problem has been closed. You can view the problem at [rurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'User: [uid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + 'Priority: [priority]' + CHAR( 13 ) + 'Category: [category]' + CHAR( 13 ) + CHAR( 13 ) + 'SOLUTION' + CHAR( 13 ) + '--------' + CHAR( 13 ) + '[solution]' ) INSERT INTO tblEmailMsg( TYPE , subject, body ) VALUES ( 'repnew', 'HELPDESK: Problem [problemid] Assigned', 'The following problem has been assigned to you. You can update the problem at [rurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + 'Priority: [priority]' + CHAR( 13 ) + 'Category: [category]' + CHAR( 13 ) + CHAR( 13 ) + 'USER INFORMATION' + CHAR( 13 ) + '----------------' + CHAR( 13 ) + 'Username: [uid]' + CHAR( 13 ) + 'Email: [uemail]' + CHAR( 13 ) + 'Phone: [phone]' + CHAR( 13 ) + 'Location: [location]' + CHAR( 13 ) + 'Department: [department]' + CHAR( 13 ) + CHAR( 13 ) + 'DESCRIPTION' + CHAR( 13 ) + '-----------' + CHAR( 13 ) + '[description]' ) INSERT INTO tblEmailMsg( TYPE , subject, body ) VALUES ( 'reppager', 'HELPDESK: Problem [problemid] Assigned', 'Title: [title]' + CHAR( 13 ) + 'Priority: [priority]' + CHAR( 13 ) + 'User: [uid]' ) INSERT INTO tblEmailMsg( TYPE , subject, body ) VALUES ( 'repupdate', 'HELPDESK: Problem [problemid] Updated', 'The following problem has been updated. You can view the problem at [rurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'User: [uid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + 'Priority: [priority]' + CHAR( 13 ) + 'Category: [category]' + CHAR( 13 ) + CHAR( 13 ) + 'DESCRIPTION' + CHAR( 13 ) + '-----------' + CHAR( 13 ) + '[description]' ) INSERT INTO tblEmailMsg( TYPE , subject, body ) VALUES ( 'userclose', 'HELPDESK: Problem [problemid] Closed', 'Your help desk problem has been closed. You can view the solution below or at: [uurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'User: [uid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + CHAR( 13 ) + 'SOLUTION' + CHAR( 13 ) + '--------' + CHAR( 13 ) + '[solution]' ) INSERT INTO tblEmailMsg( TYPE , subject, body ) VALUES ( 'usernew', 'HELPDESK: Problem [problemid] Created', 'Thank you for submitting your problem to the help desk. You can view or update the problem at: [uurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'User: [uid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + CHAR( 13 ) + 'DESCRIPTION' + CHAR( 13 ) + '-----------' + CHAR( 13 ) + '[description]' ) INSERT INTO tblEmailMsg( TYPE , subject, body ) VALUES ( 'userupdate', 'HELPDESK: Problem [problemid] Updated', 'Your help desk problem has been updated. You can view the problem at: [uurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'User: [uid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + CHAR( 13 ) + 'DESCRIPTION' + CHAR( 13 ) + '-----------' + CHAR( 13 ) + '[description]' )GO INSERT INTO tblUsers( sid, uid, fname, email1 ) VALUES ( 0, 'unknown', 'Unknown', '[email protected]' ) GO INSERT INTO db_keys( problems, departments, categories, users ) VALUES ( 1, 2, 1, 1 ) GO INSERT INTO STATUS ( status_id, sname ) VALUES ( 0, 'UNKNOWN' ) INSERT INTO STATUS ( status_id, sname ) VALUES ( 1, 'OPEN' ) INSERT INTO STATUS ( status_id, sname ) VALUES ( 100, 'CLOSED' ) GO INSERT INTO priority( priority_id, pname ) VALUES ( 0, 'UNKNOWN' ) INSERT INTO priority( priority_id, pname ) VALUES ( 1, 'LOW' ) INSERT INTO priority( priority_id, pname ) VALUES ( 2, 'HIGH' ) GO INSERT INTO departments( department_id, dname ) VALUES ( 0, 'UNKNOWN' ) INSERT INTO departments( department_id, dname ) VALUES ( 1, 'Dept1' ) GO Mensagens do MySQL : Documentação #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 'GO CREATE DATABASE HelpDesk ON ( NAME = HelpDesk, Aqui está o Código Original do Arquivo. /* helpdesk.sql ** ** This is the SQL schema file for Liberum Helpdesk. ** It was created using SQL Server 2000 but should work fine under ** 6.5 or newer. ** ** Before using, change the FILENAME locations in the CREATE DATABASE ** statement to match your SQL server settings. ** ** $Revision: 1.6 $ ** $Date: 2001/09/17 15:22:11 $ */ USE master GO CREATE DATABASE HelpDesk ON ( NAME = HelpDesk, FILENAME = 'c:\mssql\data\helpdesk.mdf', SIZE = 5, FILEGROWTH = 5 ) LOG ON ( NAME = 'HelpDesk_log', FILENAME = 'c:\mssql\data\helpdesk_log.ldf', SIZE = 5MB, FILEGROWTH = 5MB ) GO USE HelpDesk GO CREATE TABLE [dbo].[categories] ( [category_id] [int] NOT NULL , [cname] [varchar] (50) NULL , [rep_id] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[db_keys] ( [problems] [int] NULL , [departments] [int] NULL , [categories] [int] NULL , [users] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[departments] ( [department_id] [int] NOT NULL , [dname] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[priority] ( [priority_id] [int] NOT NULL , [pname] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[problems] ( [id] [int] NOT NULL , [uid] [varchar] (50) NULL , [uemail] [varchar] (50) NULL , [ulocation] [varchar] (50) NULL , [uphone] [varchar] (50) NULL , [rep] [int] NULL , [status] [int] NULL , [time_spent] [int] NULL , [category] [int] NULL , [priority] [int] NULL , [department] [int] NULL , [title] [varchar] (50) NULL , [description] [text] NULL , [solution] [text] NULL , [start_date] [datetime] NULL , [close_date] [datetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[status] ( [status_id] [int] NOT NULL , [sname] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblConfig] ( [SiteName] [varchar] (50) NULL , [BaseURL] [varchar] (50) NULL , [AdminPass] [varchar] (50) NULL , [EmailType] [int] NULL , [SMTPServer] [varchar] (50) NULL , [HDName] [varchar] (50) NULL , [HDReply] [varchar] (50) NULL , [BaseEmail] [varchar] (50) NULL , [EnablePager] [int] NULL , [NotifyUser] [int] NULL , [EnableKB] [int] NULL , [DefaultPriority] [int] NULL , [DefaultStatus] [int] NULL , [CloseStatus] [int] NULL , [AuthType] [int] NULL , [Color1] [varchar] (15) NULL , [Color2] [varchar] (15) NULL , [BGColor] [varchar] (15) NULL , [TextColor] [varchar] (15) NULL , [LinkColor] [varchar] (15) NULL , [VLinkcolor] [varchar] (15) NULL , [ALinkColor] [varchar] (15) NULL , [Version] [varchar] (6) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblConfig_Auth] ( [ID] [int] NOT NULL , [Type] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblConfig_Email] ( [ID] [int] NOT NULL , [Type] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblEmailMsg] ( [type] [varchar] (50) NOT NULL , [subject] [varchar] (50) NULL , [body] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[tblUsers] ( [sid] [int] NOT NULL , [uid] [varchar] (50) NULL , [password] [varchar] (50) NULL , [fname] [varchar] (50) NULL , [email1] [varchar] (50) NULL , [email2] [varchar] (50) NULL , [phone] [varchar] (50) NULL , [location1] [varchar] (50) NULL , [location2] [varchar] (50) NULL , [department] [int] NULL , [IsRep] [int] NULL , [dtCreated] [datetime] NULL , [dtLastAccess] [datetime] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[categories] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [category_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[departments] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [department_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[priority] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [priority_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[problems] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[status] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [status_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblConfig_Auth] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblConfig_Email] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblEmailMsg] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [type] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [sid] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD CONSTRAINT [DF_tblUsers_department] DEFAULT (0) FOR [department], CONSTRAINT [DF_tblUsers_IsRep] DEFAULT (0) FOR [IsRep], CONSTRAINT [DF_tblUsers_dtCreated] DEFAULT (getdate()) FOR [dtCreated], CONSTRAINT [DF_tblUsers_dtLastAccess] DEFAULT (getdate()) FOR [dtLastAccess] GO INSERT INTO tblconfig ( SiteName, BaseURL, AdminPass, EmailType, SMTPServer, HDName, HDReply, BaseEmail, EnablePager, NotifyUser, EnableKB, DefaultPriority, DefaultStatus, CloseStatus, AuthType, Color1, Color2, BGColor, TextColor, LinkColor, VLinkColor, ALinkColor ) VALUES ( 'Company Name', 'http://www.company.com/helpdesk', 'admin', 1, 'smtp.company.com', 'Consultant', '[email protected]', '@company.com', 0, 0, 1, 1, 1, 100, 2, '#6080B0', '#EEEEEE', '#FFFFFF', '#000000', '#6080B0', '#7090C0', '#7090C0' ) GO INSERT INTO tblConfig_Auth (ID, Type) VALUES (1, 'NT Authentication') INSERT INTO tblConfig_Auth (ID, Type) VALUES (2, 'Database') INSERT INTO tblConfig_Auth (ID, Type) VALUES (3, 'External Authentication') GO INSERT INTO tblConfig_Email (ID, Type) VALUES (0, 'Disabled') INSERT INTO tblConfig_Email (ID, Type) VALUES (1, 'CDONTS') INSERT INTO tblConfig_Email (ID, Type) VALUES (2, 'JMail') INSERT INTO tblConfig_Email (ID, Type) VALUES (3, 'ASPEmail') GO INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'repclose', 'HELPDESK: Problem [problemid] Closed', 'The following problem has been closed. You can view the problem at [rurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'Category: [category]' + CHAR(13) + CHAR(13) + 'SOLUTION' + CHAR(13) + '--------' + CHAR(13) + '[solution]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'repnew', 'HELPDESK: Problem [problemid] Assigned', 'The following problem has been assigned to you. You can update the problem at [rurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'Category: [category]' + CHAR(13) + CHAR(13) + 'USER INFORMATION' + CHAR(13) + '----------------' + CHAR(13) + 'Username: [uid]' + CHAR(13) + 'Email: [uemail]' + CHAR(13) + 'Phone: [phone]' + CHAR(13) + 'Location: [location]' + CHAR(13) + 'Department: [department]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'reppager', 'HELPDESK: Problem [problemid] Assigned', 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'User: [uid]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'repupdate', 'HELPDESK: Problem [problemid] Updated', 'The following problem has been updated. You can view the problem at [rurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'Category: [category]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'userclose', 'HELPDESK: Problem [problemid] Closed', 'Your help desk problem has been closed. You can view the solution below or at: [uurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + CHAR(13) + 'SOLUTION' + CHAR(13) + '--------' + CHAR(13) + '[solution]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ('usernew', 'HELPDESK: Problem [problemid] Created', 'Thank you for submitting your problem to the help desk. You can view or update the problem at: [uurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ('userupdate', 'HELPDESK: Problem [problemid] Updated', 'Your help desk problem has been updated. You can view the problem at: [uurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' ) GO INSERT INTO tblUsers(sid, uid, fname, email1) VALUES (0, 'unknown', 'Unknown', '[email protected]') GO INSERT INTO db_keys(problems, departments, categories, users) VALUES (1,2,1,1) GO INSERT INTO status(status_id, sname) VALUES (0,'UNKNOWN') INSERT INTO status(status_id, sname) VALUES (1,'OPEN') INSERT INTO status(status_id, sname) VALUES (100,'CLOSED') GO INSERT INTO priority(priority_id, pname) VALUES (0,'UNKNOWN') INSERT INTO priority(priority_id, pname) VALUES (1,'LOW') INSERT INTO priority(priority_id, pname) VALUES (2,'HIGH') GO INSERT INTO departments(department_id, dname) VALUES (0,'UNKNOWN') INSERT INTO departments(department_id, dname) VALUES (1,'Dept1') GO Obrigado. Abraços
×
×
  • Create New...