Packet Stealer

Exponent Example

2013-04-15T17:34:00.003-07:00

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

Search Music PHP

2013-04-15T13:47:00.002-07:00

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 Id	Music Name	Music 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

Twitch Tv Eve Online

2012-12-20T19:42:00.002-08:00

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!

Translink Addon

2012-09-20T21:35:00.001-07:00

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!

Ventrilo and Minecraft Server!!!!!

2012-07-01T20:51:00.003-07:00

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

Link for criteria sheet

2012-06-12T18:44:00.003-07:00

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

btnDelete for ClientServers

2012-04-16T19:38:00.000-07:00

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

2012-04-16T15:03:00.004-07:00

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

Final Client Servers

2012-04-15T12:20:00.000-07:00

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

asdjfioashdfuauipshfuiphas

2012-04-12T19:02:00.001-07:00

use dchotel35

SELECT ResID, Arrival_Date, Departure_Date, RoomID

FROM Reservation

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

ORDER BY RoomID

Crystal reports tutorial select a date

2012-04-11T12:53:00.002-07:00

http://vb.net-informations.com/crystal-report/vb.net_crystal_report_parameter_date.htm

asp Final

2012-04-11T08:34:00.000-07:00

For ASP.net Final
http://www.box.com/s/f83cf6c825742be8759f

For Everybody

2012-04-04T18:46:00.002-07:00

http://www.box.com/s/8842db9cc75d6fb92b79

For Ricky

2012-04-04T08:15:00.000-07:00

http://www.box.com/s/83636cdb62fede1895b4

Funny Guild Names

2012-03-18T01:25:00.002-07:00

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

SQL - Port to SQL from Access 2010

2012-03-02T14:02:00.000-08:00

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

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

Update

2011-11-28T18:09:00.000-08:00

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

ETL Extract/Transform/Load

2011-11-28T18:07:00.000-08:00

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

2011-11-28T17:50:00.000-08:00

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

Update!!!

2010-01-29T13:58:00.000-08:00

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.

Increase Blog Traffic (No Problem)

2009-11-10T18:37:00.000-08:00

Over the past couple of days, I've noticed that my blog has been viewed considerably more. Yes I have done some Google sleuthing and discovered websites that give tips on increasing blog traffic. Its as simple and takes little to nothing at all to setup.

Do a Google search on "Increase Blog Traffic"
Read what they offer and muse over if some of the options are available to you.
Follow up and actually do what they say because:

they have done this from experience
they know what they are doing, obviously since the link was found on Google's first page search

Ok, sounds simple right? Yes and No. Beware of scamming. In other words just follow some of the steps that I did.

Noticed how other blogs are setup, some have rss feeds and other promoting blog websites, hint look at mine ------->
Blogtoplist sign up there and you will definitely get hits to your blog
Search out other blog promo sites, such as technorati, buzzerhut.com
Sign up with StumbleUpon, Reddit, or Digg and submit your site
Lastly sign up with Sitemeter, this will tell you how many people visit your blog

Ok alright now your ready, and hopefully getting increased traffic to your blog.
Additional steps, such as linking, correctly labeling and creating a title that increases search traffic.

Gimp Update

2009-11-03T20:17:00.000-08:00

Well after many frustrating breaks, going from Photoshop to GIMP was not an easy task, tools were relatively the same with a few difficulties here and there, such as the scale tool and gradient tool. Layers behaved similarly to Photoshop as well. Setup was a breeze and was fast with no problems, although at first finding where to download the program took a little time. Program design was a bit impressive compared to Photoshop, as all the tools are displayed and there respective calibrations shown when clicked on. As far as availability of tools, I have yet to explore them all and have to remove it from the ratings list.
As Far the ratings goes like this:

A Rating for Ease of Install and Initial Setup - 9/10
A Rating for Overall program design in terms of layout of tools (easy to difficult) - Medium (Some Frustration) 7/10
A Rating for Amount of tools available for photo manipulation - N/A (Still need to Explore and Tryout)

Next is the test banner that I have put together using GIMP.

There it is, I thought I have done a wonderful job in creating this banner with 0 experience using GIMP.
The image comes from a Desktop Background with the color taken out of it, originally blue on white background that has been desaturated and colors inverted to white and black. The text is the font Scriptina, which can be downloaded Here, however the gradient color is from a background color, with an overlay blend mode and transparency set to around 62%.
Put all this together and Voila the image is made.

As a side note to all, read the manual before using, it will help greatly in figuring out how to use the program better and more efficiently.

Gimp

2009-11-03T18:52:00.001-08:00

Today, I decided to download GIMP and see what everyone has been talking about. I am very familiar with Photoshop and as far love the program, however as seeing as the laptop is the only computer that is available to me, I have opted to get GIMP and look at the comparision to Photoshop. I will post and update with my ratings on 3 subjects.
The 3 areas of rating will be:

A Rating for Ease of Install and Initial Setup
A Rating for Overall program design in terms of layout of tools (easy to difficult)
A Rating for Amount of tools available for photo manipulation

For this test I will create a proper banner for packetstealer

New Game

2009-11-03T15:06:00.000-08:00

Hey everyone, just got a link from a friend that all you gamers out there should take a look at.
The game is called Shattered Horizon. Here is a link to there site, Shattered Horizon check it out and don't forget to watch the trailer, it looks awesome.

TV Shows Automatic Downloading Using RSS

2009-11-02T12:18:00.000-08:00

Ok, torrenting is a bit of a hard point for some people, and many a times a controversial subject for some, but I find myself more and more doing other things in life than watching t.v. I find that downloading and watching is much easier because:

You can watch it anytime and at your own pace
No commercials at all
Sometimes the download is of better quality and sound
More options for portability

Now knowing these points, I will tell you how you can setup a hassel free way of downloading shows with little to none difficulty. Ok, so the one way I go about doing this is to first introduce and explain how RSS feeds work. RSS -"Really Simple Syndication" (http://en.wikipedia.org/wiki/RSS) is a web feed that is published to the web that contains a list of summerized text, links or other data. This allows for followers to be able to be updated 24/7 any time and on a timely basis using a RSS reader, such as firefox inbuilt rss reader. Now how will RSS help me? Well here is my setup, My laptop uses a torrenting program such as uTorrent (http://www.utorrent.com/) which has a rss reader included. Now once that is installed we can start adding TV shows rss feeds. The site that I use is http://eztv.it/ they have rss feeds for lots of tv shows and are pretty reliable. The rss feeds and links can be found here http://www.ezrss.it/ . Now if i wanted to download every week the tv show "House" i use ezrss and using the search button I search for House and click on exact match. I then am returned with a list of the shows, I look at the page and in the title header "SEARCH RESULTS" I will see "Search-Based RSS feed" click on that.

Now in Firefox a page will come up with a list of the episodes and at the top will be a subscribe button and a drop down menu, subscribe to that and add the link to the toolbar for easy access. When the rss feed is added to the toolbar, right-click the link and select "copy link." Now open up utorrent, and look for add rss feed, and paste the link in there and select smart-ep filter (later I will show how to customize the link so that there is no double downloading of the show)

However, for those of you using, IE8, a similar page will come up and a subscribe button will appear as well. after subscribing the feed will be under favorites>rss feeds and you can also right-click and select cut.

Now open up utorrent, and look for add rss feed, and paste the link in there and select automatically download episodes and also select smart-ep filter. Once added the rss feed will show up on the side, now select the feed by right-clicking on it and select rss downloader, select the feed from the list and in the "save download" location select the location on the hard drive where to download the shows. Once done that press ok and now you are done.

Once the rss feed is added to uTorrent, everytime a new show is published to the feed, uTorrent will automatically start downloading the tvshow, now as long as the uTorrent is running and internet access is available, the tv show will now automatically download. Amazing, I will be adding photos for better step by step explaination.

Hope this helps people, and please comment.