Monday, April 15, 2013

Exponent Example

https://www.box.com/s/1nnx6n8wsbvl2s4nmrc0

Search Music PHP


Search Music PHP
$link = mysqli_connect("localhost", "root", "", "musicbuydb");
if(mysqli_connect_errno()){
die(mysqli_connect_error());
}
$id = trim($_POST["txtmusicsearch"]);
echo $id;
$query = "select * from musictbl WHERE music_id = $id";
$res = mysqli_query($link,$query);
echo "
";
Music IdMusic NameMusic Downloaded Times

while($record = mysqli_fetch_assoc($res))

{
echo " ";
echo "
". $record['music_id'] ."
";
echo "
". $record['music_title'] ."
";
echo "
". $record['music_no_times'] ."
";
echo "
"; }
echo "
";?>

text Files:
https://www.box.com/s/w7snqebceufl1jn4saon

Search Music:
https://www.box.com/s/f7e1zqftdu09j3phb72f







Thursday, December 20, 2012

Twitch Tv Eve Online

Lately I have been streaming some Eve Online on my Twitch Channel: CapApollo Twitch Channel Come Check me out as I stream Mission Running and Answer any Questions in Chat. Come Hang out and follow me on Twitch as I run Missions and Listen to Music!

Here is a Link for a Free 21 Day Trial of EVE Online:
https://secure.eveonline.com/trial/?invc=7d956c46-392e-497b-ae6e-6f5011b409d9&action=buddy

Come join me and have some fun!

Thursday, September 20, 2012

Translink Addon

Check out the new Translink blog addon, located on the right hand side.
Use this to check out bus times for the Lower Mainland and Greater Vancouver Regions for bus schedules!

Sunday, July 1, 2012

Ventrilo and Minecraft Server!!!!!

Ventrilo Server Information (VoIP Server):
  • Server name: Stasis
  • IP/Address: 184.154.207.170
  • Port: 44128
  • Password: canada
Minecraft Server Connect using Hamachi:
  • Download Hamachi : Download Hamachi UnManaged
  • Run install Hamachi
  • Network > Join Network: 
    • Network Id: davidslegit
    • Password: packetstealer
  • Hit Ok
  • Open Minecraft
  • Multiplayer
    • add new server
    • Server IP: 5.9.102.231
    • Hit ok
    • Connect
  • Success you are now connected to the Minecraft Server.
Rules for Minecraft Server:
  • No griefing!
  • Don't ask for op!
  • Optional: Join Ventrilo 

Tuesday, June 12, 2012

Link for criteria sheet

Link to the file needed to attach to the routine letter assignment. https://www.box.com/s/4a570c0d055bbd5052f0

Monday, April 16, 2012

btnDelete for ClientServers

Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click Dim cmdStudent As New SqlCommand Dim daStudent As New SqlDataAdapter Dim dsStudent As New DataSet Dim dtStudent As New DataTable conn = GetConnect() conn.Open() cmdStudent = conn.CreateCommand cmdStudent.CommandText = "Delete from UniversityStudent where Studentid = '" & Trim(txtSID.Text) & "'" intcheck = cmdStudent.ExecuteReader.RecordsAffected If intcheck > 0 Then MsgBox("Record Deleted") Else MsgBox("No Records Deleted") End If conn.Close() RefreshDataGrid() End Sub

Client Servers Final Add Edit Delete

Client Servers Final Add Edit Delete:
http://www.box.com/s/bd7533e04f836df67075

Sunday, April 15, 2012

Final Client Servers

http://www.box.com/s/2843e0ebd3055ee86117

Thursday, April 12, 2012

asdjfioashdfuauipshfuiphas

 use dchotel35




SELECT ResID, Arrival_Date, Departure_Date, RoomID

FROM Reservation

WHERE Eeservations.Arrival_Date > @dtpStart AND Reservations.Departure_Date < dtpEnd

ORDER BY RoomID

Sunday, March 18, 2012

Funny Guild Names

Here are some funny guild names:


  • When In Doubt AFK Out
  • Naga Stole My Bike
  • Sapped Girls Cant Say No
  • STDs are BOP
  • Secret Squirrel Society
  • Sorry babe, I'm on cooldown
  • Teen Girl Squad
  • YOU CANT COMPETE
  • And two stealthed rogues
  • Magically Malicious
  • Just AFK Out
  • Straight Outta Hillsbrad
  • Dont You Peon Me
  • AFK Getting Coffee
  • AFK Till Expansion
  • Seal Clubbers Clubbing Club
  • Sorry were you questing
  • Chucknorris is AFK in AV
  • It Burns When I PVP
  • We Are Not Disbanding
  • Pie Vendors
  • Forsaken Ate MyKodo
  • Molten Core Swim Team
  • I Farm or Family Dies
  • AFK
  • Ctrl Alt Elite
  • Insert guild name here
  • Invalid Target
  • Power Word :DRUNK
  • What would McGyver do?
  • Guildless
  • right click to attack
  • Dyslexics Untied
  • Set Sail for Fail
  • Power Word: Awesome
  • I Has A Bucket
  • Resilience is Futile
  • Stormwind Pizza Delivery
  • no more guild invites
  • the cake is a lie
  • Potion Vendor
  • Our Server Is Down
  • We Have ADD and
  • Gold Farmer

Friday, March 2, 2012

SQL - Port to SQL from Access 2010

Chapter 2 +3 Client Servers:
Create Database in SQL Server 2008
Port Access Database to SQL Server 2008

http://www.box.com/s/rb01llihjlg7sgtu8y19

Monday, November 28, 2011

Update

Below you will find example of database coding (VBA) Feel free to comment and ask questions

ETL Extract/Transform/Load

Example with 2 Dimension tables: Product Dimension, Seminar Dimension tables
Dim rsProduct As ADODB.Recordset
Dim rsSeminar As ADODB.Recordset
1. Extract Information From Tables using select Statement

Private Sub cmbExtract_Click

Dim cn As New ADODB.Connection
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & CurrentProject.Path & "\NameofDatabaseBackEnd.accdb;"


Set rsProduct = New ADODB.Recordset
With rsProduct
    Set .ActiveConnection = cn
    .Source = "Select * From Product"
    .CursorType = adOpenStatic
    .Open
End With

Set rsSeminar = New ADODB.Recordset
With rsSeminar
    Set .ActiveConnection = cn
        .Source = "Select * from Seminar"
        .CursorType = adOpenStatic
        .Open
End With

Set cn = Nothing

End Sub

2. Transform the data (if need be/any) Then load the data into the new Data Warehouse:
(Set the connection to the Warehouse!!!)
Private Sub cmbTransform_Click()
Dim cnwh As New ADODB.Connection
cnwh.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & CurrentProject.Path & "\NameofDataWarehouse.accdb;"

Dim rsProductwh As ADODB.Recordset
Set rsProductwh = New ADODB.Recordset

    Set rsProductwh.ActiveConnection = cnwh
    
Dim strInsert2 As String
rsProduct.MoveFirst
Do While Not rsProduct.EOF
    strInsert2 = "insert into ProductDim (ProductNumber, Description, UnitPrice)" & _
 " values ('" & rsProduct!ProductNumber & "','" & rsProduct!Description & "','" & rsProduct!Unitprice & "')"
    
    rsProductwh.Open strInsert2
    
    rsProduct.MoveNext
Loop

Set rsProductwh = Nothing

Dim rsSeminarwh As ADODB.Recordset
Set rsSeminarwh = New ADODB.Recordset
    Set rsSeminarwh.ActiveConnection = cnwh

Dim strInsert3 As String
rsSeminar.MoveFirst
Do While Not rsSeminar.EOF
    strInsert3 = "insert into SeminarDim (SeminarDate, SeminarTime, Location, Title)" & _
" values ('" & rsSeminar!SeminarDate & "','" & rsSeminar!SeminarTime & "','" & rsSeminar!Location & "','" & rsSeminar!SeminarTitle & "')"
    
    rsSeminarwh.Open strInsert3
    rsSeminar.MoveNext
Loop

Set cnwh = Nothing ' close the connection
Set rsSeminarwh = Nothing

End Sub

VBA (Visual Basic) Coding for Databases

Posting of Database Coding Review
Set connection to Back end database:


Dim cn As New ADODB.Connection
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & CurrentProject.Path & "\NameofDatabase.accdb;"

Write the Select Statement to get data:
Dim rsName As ADODB.Recordset ' put this at top

Set rsName = New ADODB.Recordset
With rsName
    Set .ActiveConnection = cn
    .Source = "Select * From TableName"
    .LockType = adLockOptimistic
    .CursorType = adOpenStatic
    .Open
End With

Fill text boxes on Form with data retrieved:
With rsName
    If Not (.EOF) Then
        .Find strcriteria
        Me.txtTransactionID = !transactionid
        Me.txtDateAcquired = !DateAcquired
        Me.txtAcquisitionPrice = !AcquisitionPrice
                
        Me.txtAskingPrice = !AskingPrice
        Me.txtDateSold = !datesold
        Me.txtSalesPrice = !salesprice
    End If
End With

Example of Form Load where lsTransaction (Listbox) is filled with transaction ID, Date Acquired and artwork ID:
Dim rsTransactions As ADODB.Recordset
Private Sub Form_Load()
Dim cn As New ADODB.Connection

cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & CurrentProject.Path & "\VRG+Art+BE.accdb;"

Set rsTransactions = New ADODB.Recordset

With rsTransactions
    Set .ActiveConnection = cn
    .Source = "Select * from GalleryTransactions"
    .LockType = adLockOptimistic
    .CursorType = adOpenStatic
    .Open
End With

Do While (Not rsTransactions.EOF)
Me.lsTransactions.AddItem rsTransactions![transactionid] & ", " & rsTransactions![DateAcquired] & ", " & rsTransactions![artworkid]
rsTransactions.MoveNext
Loop
rsTransactions.MoveFirst

Set cn = Nothing

End Sub

Friday, January 29, 2010

Update!!!

Well as you can all see I have not had the time to post here, since I am a dedicated World of Warcraft player, if anyone plays my name is Badunkadunk on the Bladefist Server. I am a Shadow/Disc Priest on the Alliance side, I'm the night elf.

With this upcoming update I'd like to post some guides and tips on leveling characters and making gold.