Picosystems Ghana

1Script:javaScript Author :Ez script and edited by picosystems
Company:Ez script ltd
Description: Create text around the mouse. Place in of the html code

if (document.all) { yourLogo = " xxxxxxxxxxx "; logoFont = "Tahoma"; logoColor = "blue"; yourLogo = yourLogo.split(''); L = yourLogo.length; TrigSplit = 360 / L; Sz = new Array() logoWidth = 100; logoHeight = -30; ypos = 0; xpos = 0; step = 0.03; currStep = 0; document.write('<div id="outer" style="position:absolute;top:0px;left:0px"><div style="position:relative">'); for (i = 0; i < L; i++) { document.write('<div id="ie" style="position:absolute;top:0px;left:0px;' +'width:10px;height:10px;font-family:'+logoFont+';font-size:12px;' +'color:'+logoColor+';text-align:center">'+yourLogo[i]+'</div>'); } document.write('</div></div>'); function Mouse() { ypos = event.y; xpos = event.x - 5; } document.onmousemove=Mouse; function animateLogo() { outer.style.pixelTop = document.body.scrollTop; for (i = 0; i < L; i++) { ie[i].style.top = ypos + logoHeight * Math.sin(currStep + i * TrigSplit * Math.PI / 180); ie[i].style.left = xpos + logoWidth * Math.cos(currStep + i * TrigSplit * Math.PI / 180); Sz[i] = ie[i].style.pixelTop - ypos; if (Sz[i] < 5) Sz[i] = 5; ie[i].style.fontSize = Sz[i] / 1.7; } currStep -= step; setTimeout('animateLogo()', 20); } window.onload = animateLogo; } // End -->

1 2Script :HTML
Author :Kwesi Gyang-Taah
Company:Picosystems Ltd
Description: Drop-Down Box with all the country names present
<td><select name="country"> <option value="">Please select... </option><option value="Albania">Albania </option><option value="Algeria">Algeria </option><option value="American Samoa">American Samoa </option><option value="Andorra">Andorra </option><option value="Anguilla">Anguilla </option><option value="Antigua & Barbuda">Antigua & Barbuda </option><option value="Argentina">Argentina </option><option value="Aruba">Aruba </option><option value="Australia">Australia </option><option value="Austria">Austria </option><option value="Azerbaijan">Azerbaijan </option><option value="Azores">Azores </option><option value="Bahamas">Bahamas </option><option value="Bahrain">Bahrain </option><option value="Bangladesh">Bangladesh </option><option value="Barbados">Barbados </option><option value="Belgium">Belgium </option><option value="Belize">Belize </option><option value="Belarus">Belarus </option><option value="Benin">Benin </option><option value="Bermuda">Bermuda </option><option value="Bolivia">Bolivia </option><option value="Bonaire">Bonaire </option><option value="Bosnia">Bosnia </option><option value="Botswana">Botswana </option><option value="Brazil">Brazil </option><option value="Brunei">Brunei </option><option value="Bulgaria">Bulgaria </option><option value="Burkina Faso">Burkina Faso </option><option value="Burundi">Burundi </option><option value="Cambodia">Cambodia </option><option value="Cameroon">Cameroon </option><option value="Canada">Canada </option><option value="Canary Islands">Canary Islands </option><option value="Cape Verde Islands">Cape Verde Islands </option><option value="Cayman Islands">Cayman Islands </option><option value="Central African Republic">Central African Republic </option><option value="Chad">Chad </option><option value="Channel Islands">Channel Islands </option><option value="Chile">Chile </option><option value="China, Peoples Republic of">China </option><option value="Colombia">Colombia </option><option value="Congo">Congo </option><option value="Cook Islands">Cook Islands </option><option value="Costa Rica">Costa Rica </option><option value="Croatia">Croatia </option><option value="Curacao">Curacao </option><option value="Cyprus">Cyprus </option><option value="Czech Republic">Czech Republic </option><option value="Denmark">Denmark </option><option value="Djibouti">Djibouti </option><option value="Dominica">Dominica </option><option value="Dominican Republic">Dominican Republic </option><option value="Ecuador">Ecuador </option><option value="Egypt">Egypt </option><option value="El Salvador">El Salvador </option><option value="Equitorial Guinea">Equitorial Guinea </option><option value="Eritrea">Eritrea </option><option value="Estonia">Estonia </option><option value="Ethiopia">Ethiopia </option><option value="Faeroe Islands">Faeroe Islands </option><option value="Fiji">Fiji </option><option value="Finland">Finland </option><option value="France">France </option><option value="French Guiana">French Guiana </option><option value="French Polynesia">French Polynesia </option><option value="Gabon">Gabon </option><option value="Gambia">Gambia </option><option value="Georgia">Georgia </option><option value="Germany">Germany </option><option value="Ghana"selected="selected">Ghana </option><option value="Gibraltar">Gibraltar </option><option value="Greece">Greece </option><option value="Greenland">Greenland </option><option value="Grenada">Grenada </option><option value="Guadeloupe">Guadeloupe </option><option value="Guam">Guam </option><option value="Guatemala">Guatemala </option><option value="Guinea">Guinea </option><option value="Guinea-Bissau">Guinea-Bissau </option><option value="Guyana">Guyana </option><option value="Haiti">Haiti </option><option value="Holland">Holland </option><option value="Honduras">Honduras </option><option value="Hong Kong">Hong Kong </option><option value="Hungary">Hungary </option><option value="Iceland">Iceland </option><option value="India">India </option><option value="Indonesia">Indonesia </option><option value="Israel">Israel </option><option value="Italy">Italy </option><option value="Ivory Coast">Ivory Coast </option><option value="Jamaica">Jamaica </option><option value="Japan">Japan </option><option value="Jordan">Jordan </option><option value="Kazakhstan">Kazakhstan </option><option value="Kenya">Kenya </option><option value="Kiribati">Kiribati </option><option value="Kosrae">Kosrae </option><option value="Kuwait">Kuwait </option><option value="Kyrgyzstan">Kyrgyzstan </option><option value="Laos">Laos </option><option value="Latvia">Latvia </option><option value="Lebanon">Lebanon </option><option value="Lesotho">Lesotho </option><option value="Liberia">Liberia </option><option value="Liechtenstein">Liechtenstein </option><option value="Lithuania">Lithuania </option><option value="Luxembourg">Luxembourg </option><option value="Macau">Macau </option><option value="Macedonia">Macedonia </option><option value="Madagascar">Madagascar </option><option value="Madeira">Madeira </option><option value="Malawi">Malawi </option><option value="Malaysia">Malaysia </option><option value="Maldives">Maldives </option><option value="Mali">Mali </option><option value="Malta">Malta </option><option value="Marshall Islands">Marshall Islands </option><option value="Martinique">Martinique </option><option value="Mauritania">Mauritania </option><option value="Mauritius">Mauritius </option><option value="Mexico">Mexico </option><option value="Moldova">Moldova </option><option value="Monaco">Monaco </option><option value="Montserrat">Montserrat </option><option value="Morocco">Morocco </option><option value="Mozambique">Mozambique </option><option value="Myanmar">Myanmar </option><option value="Namibia">Namibia </option><option value="Nepal">Nepal </option><option value="Netherlands">Netherlands </option><option value="New Caledonia">New Caledonia </option><option value="New Zealand">New Zealand </option><option value="Nicaragua">Nicaragua </option><option value="Niger">Niger </option><option value="Nigeria">Nigeria </option><option value="Norfolk Island">Norfolk Island </option><option value="Northern Ireland">Northern Ireland </option><option value="Norway">Norway </option><option value="Oman">Oman </option><option value="Pakistan">Pakistan </option><option value="Palau">Palau </option><option value="Panama">Panama </option><option value="Papua New Guinea">Papua New Guinea </option><option value="Paraguay">Paraguay </option><option value="Peru">Peru </option><option value="Philippines">Philippines </option><option value="Poland">Poland </option><option value="Ponape">Ponape </option><option value="Portugal">Portugal </option><option value="Puerto Rico">Puerto Rico </option><option value="Qatar">Qatar </option><option value="Republic of Ireland">Republic of Ireland </option><option value="Republic of Yemen">Republic of Yemen </option><option value="Reunion">Reunion </option><option value="Romania">Romania </option><option value="Rota">Rota </option><option value="Russia">Russia </option><option value="Rwanda">Rwanda </option><option value="Saba">Saba </option><option value="Saipan">Saipan </option><option value="Saudi Arabia">Saudi Arabia </option><option value="Scotland">Scotland </option><option value="Senegal">Senegal </option><option value="Seychelles">Seychelles </option><option value="Sierra Leone">Sierra Leone </option><option value="Singapore">Singapore </option><option value="Slovakia">Slovakia </option><option value="Slovenia">Slovenia </option><option value="Solomon Islands">Solomon Islands </option><option value="South Africa">South Africa </option><option value="South Korea">South Korea </option><option value="Spain">Spain </option><option value="Sri Lanka">Sri Lanka </option><option value="St. Barthelemy">St. Barthelemy </option><option value="St. Christopher">St. Christopher </option><option value="St. Croix">St. Croix </option><option value="St. Eustatius">St. Eustatius </option><option value="St. John">St. John </option><option value="St. Kitts & Nevis">St. Kitts & Nevis </option><option value="St. Lucia">St. Lucia </option><option value="St. Maarten">St. Maarten </option><option value="St. Martin">St. Martin </option><option value="St. Thomas">St. Thomas </option><option value="Sudan">Sudan </option><option value="Suriname">Suriname </option><option value="Swaziland">Swaziland </option><option value="Sweden">Sweden </option><option value="Switzerland">Switzerland </option><option value="Syria">Syria </option><option value="Tahiti">Tahiti </option><option value="Taiwan">Taiwan </option><option value="Tajikistan">Tajikistan </option><option value="Tanzania">Tanzania </option><option value="Thailand">Thailand </option><option value="Tinian">Tinian </option><option value="Togo">Togo </option><option value="Tonga">Tonga </option><option value="Tortola">Tortola </option><option value="Truk">Truk </option><option value="Trinidad & Tobago">Trinidad & Tobago </option><option value="Tunisia">Tunisia </option><option value="Turkey">Turkey </option><option value="Tuvalu">Tuvalu </option><option value="Uganda">Uganda </option><option value="Ukraine">Ukraine </option><option value="Union Island">Union Island </option><option value="United Arab Emirates">United Arab Emirates </option><option value="United Kingdom">United Kingdom </option><option value="United States" >United States </option><option value="Uruguay">Uruguay </option><option value="US Virgin Islands">US Virgin Islands </option><option value="Uzbekistan">Uzbekistan </option><option value="Vanuatu">Vanuatu </option><option value="Venezuela">Venezuela </option><option value="Vietnam">Vietnam </option><option value="Virgin Islands">Virgin Islands </option><option value="Virgin Gorda">Virgin Gorda </option><option value="Wake Island">Wake Island </option><option value="Wales">Wales </option><option value="Western Samoa">Western Samoa </option><option value="Yap">Yap </option><option value="Yugoslavia">Yugoslavia </option><option value="Zaire">Zaire </option><option value="Zambia">Zambia </option><option value="Zimbabwe">Zimbabwe </option></select>

3Script :CSS
Author :Kwesi Gyang-Taah
Company:Picosystems Ltd
Description: Some general declarations in CSS
td { text-align: left; vertical-align: top; font-family:Tahoma; font-size:11px; } a { text-decoration: underline; color:#6B70BD; } A:Hover { color : #9EA3DE; text-decoration : underline; } H5 { font-weight: bold; font-family:Tahoma; } H4 { font-weight: bold; font-family:Tahoma; } H3 { color: #3D429E; font-weight: bold; font-size : 20px; font-family:Tahoma; } i { color: #3D429E; font-weight: bold; font-family:Tahoma; } H2 { font-weight: bold; font-family:Tahoma; } H1 { font-weight: bold; font-family:Tahoma; } BODY{ overflow:scroll; overflow-x:hidden; } img{ border=0 } .s1 { position : absolute; font-size : 10pt; color : blue; visibility: hidden; } .s2 { position : absolute; font-size : 18pt; color : red; visibility : hidden; } .s3 { position : absolute; font-size : 14pt; color : gold; visibility : hidden; } .s4 { position : absolute; font-size : 12pt; color : lime; visibility : hidden; } <DIV ID="div1" CLASS="s1">*</DIV> <DIV ID="div2" CLASS="s2">*</DIV> <DIV ID="div3" CLASS="s3">*</DIV> <DIV ID="div4" CLASS="s4">*</DIV>
14 Script :vbCodes
Author :Kwesi Gyang-Taah
Company:Picosystems Ltd
Description: Deleting a data in a database by an ID
Dim ans As String 'confirm deletion.. ans = MsgBox("Delete " & itemname & "?", _ vbYesNo + vbQuestion, _ "Confirm Deletion") If ans = vbNo Then: clearbox: Exit Sub 'delete from transaction file... 'Delete from Sales file..... dbs.Execute "Delete from sales where item_code='" & delID & "'"

5Script :vbCodes
Author :Kwesi Gyang-Taah
Company:Picosystems Ltd
Description: Connection String to Access database Using ADODB
Option Explicit Public dbs As New ADODB.Connection Public aPath As String Sub Main() aPath = App.Path dbs.CursorLocation = adUseClient dbs.Provider = "Microsoft.Jet.oLEDB.4.0" dbs.ConnectionString = "Persist Security Info=False;Data Source=" & aPath _ & "\Data\database.mdb;Jet OLEDB:Database Password=your password" dbs.Open End Sub

Script :PHP
Author :Kwesi Gyang-Taah
Company:Picosystems Ltd
Description:Connection String to MYSQL database and login Using PHP codes
<? // Connects to your Database mysql_connect("localhost", "val", "mod") or die(mysql_error()); mysql_select_db("dbs") or die(mysql_error()); $data = mysql_query("SELECT * FROM pass where U_name='$username'") or die(mysql_error()); while($info = mysql_fetch_array( $data )) { if ($txtPassword != $info['password']) { header("Location: index.html"); } else { header("Location: staff.php"); } } ?>

6Script :SQL
Author :Kwesi Gyang-Taah
Company:Picosystems Ltd

Description: create the various database and Tables

*************************************************** | The code below is used to create the various | * database and Table * | | * * | | *************************************************** # CREAT DATABASE (dbs) CREATE DATABASE dbs; # SELECT DATABASE USE dbs; # CREATING TABLE ( Card_tb) CREATE TABLE Card_tb ( CID VARCHAR( 21 ) NOT NULL , EMAIL VARCHAR( 21 ) NOT NULL , CARD_N VARCHAR( 16 ) NOT NULL , EXPIRING DATE VARCHAR( 10 ) NOT NULL , V_CODE VARCHAR( 3 ) NOT NULL , PRIMARY KEY ( CID ) ); # CREATING TABLE (CUSTOMER_tb) CREATE TABLE CUSTOMER_tb ( CID INT( 21 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , NAME VARCHAR( 244 ) NOT NULL , ADDRESS VARCHAR( 244 ) NOT NULL , COUNTRY VARCHAR( 18 ) NOT NULL , CITY VARCHAR( 18 ) NOT NULL , ZIPCODE VARCHAR( 7 ) NOT NULL , PHONE VARCHAR( 21 ) NOT NULL , FAX VARCHAR( 21 ) NOT NULL , EMAIL VARCHAR( 21 ) NOT NULL , COMMENT VARCHAR( 244 ) NOT NULL ); # CREATING TABLE (enquir_tb) CREATE TABLE enquir_tb ( EID INT( 21 ) NOT NULL AUTO_INCREMENT, EMAIL VARCHAR( 21 ) NOT NULL , ENQUIR VARCHAR( 244 ) NOT NULL , PRIMARY KEY ( EID ) ); # CREATING TABLE (pass_tb) CREATE TABLE enquir_tb ( U_NAME VARCHAR( 21 ) NOT NULL , Password VARCHAR( 21 ) NOT NULL , Priv VARCHAR( 244 ) NOT NULL , PRIMARY KEY ( PID ) ); # CREATING TABLE (registration_tb CREATE TABLE registration_tb ( RID INT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , FIRST NAME VARCHAR( 21 ) NOT NULL , LAST NAME VARCHAR( 21 ) NOT NULL , ADDRESS VARCHAR( 244 ) NOT NULL , PHONE VARCHAR( 21 ) NOT NULL , EMAIL VARCHAR( 21 ) NOT NULL , PASSWORD VARCHAR( 21 ) NOT NULL ); # CREATING TABLE (registration_tb) CREATE TABLE Product_tb ( PID INT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , Item VARCHAR( 244 ) NOT NULL , Quantity VARCHAR( 100 ) NOT NULL , Price VARCHAR( 100 ) NOT NULL , Total VARCHAR( 100 ) NOT NULL , Shipping` VARCHAR( 100 ) NOT NULL , CID VARCHAR( 20 ) NOT NULL ); # CREATING TABLE (ID) CREATE TABLE ID ( CID VARCHAR( 20 ) NOT NULL , PID VARCHAR( 20 ) NOT NULL , PRIMARY KEY ( CID , `PID ) ) ;

7Script :vbCodes
Author :Kwesi Gyang-Taah
Company:Picosystems Ltd
Description: Sound Function
Public dbs As New ADODB.Connection Public apath As String Public ir As String Public Unam As String Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long Declare Function CreateEllipticRgn Lib "gdi32" (ByVal X1 As Long, ByVal Y1 As Long, ByVal X2 As Long, ByVal Y2 As Long) As Long Declare Function CreateRoundRectRgn Lib "gdi32" (ByVal X1 As Long, ByVal Y1 As Long, ByVal X2 As Long, ByVal Y2 As Long, ByVal X3 As Long, ByVal Y3 As Long) As Long Declare Function CombineRgn Lib "gdi32" (ByVal hDestRgn As Long, ByVal hSrcRgn1 As Long, ByVal hSrcRgn2 As Long, ByVal nCombineMode As Long) As Long Declare Function SetWindowRgn Lib "user32" (ByVal hwnd As Long, ByVal hRgn As Long, ByVal bRedraw As Boolean) As Long Public Declare Function sndPlaySound Lib "WINMM.DLL" Alias _ "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As _ Long) As Long ' Const SND_SYNC = &H0 'Const SND_ASYNC = &H1 'Const SND_NODEFAULT = &H2 'Const SND_LOOP = &H8 'Const SND_NOSTOP = &H10

8Script :vbCodes
Author :Kwesi Gyang-Taah
Company:Picosystems Ltd
Description: Currency Convertor
Download Now !

9Script :vbCodes
Author :Kwesi Gyang-Taah
Company:Picosystems Ltd
Description: Ceasor Cypher
Download Now !