Tuesday, April 20, 2004

Web Queries and Dynamic Chart Data In Excel 2002

213730 - XL2000: How to Programmatically Perform a Web Query
Sub create_web_query()
Dim parameters As String
parameters = "jt=supply+chain+analyst"
With ActiveSheet.QueryTables.Add(Connection:="URL;http://jobsearch.beta.monster.com/jobsearch.asp?" & parameters, Destination:=Range("A1"))
.Name = "query_name74"
'.PostText = "jt=[""jt"",""supply+chain+analyst""]"
.WebTables = "9"
.Refresh
End With
End Sub

Sub create_New_web_query()
Dim parameters As String
With ActiveSheet.QueryTables.Add(Connection:="URL;http://jobsearch.beta.monster.com/jobsearch.asp?" & "jt=[""jt"",""supply+chain+analyst""]", Destination:=Range("A1"))
.Name = "query_name74"
'.PostText = "jt=[""jt"",""supply+chain+analyst""]"
.WebTables = "9"
.Refresh
End With
End Sub

Monday, April 19, 2004

Learning Page-Independent Heuristics for Extracting Data from Web Pages
Abstract:

One bottleneck in implementing a system that intelligently queries the Web is developing ``wrappers''--programs that extract data from Web pages. Here we describe a method for learning general, page-independent heuristics for extracting data from HTML documents. The input to our learning system is a set of working wrapper programs, paired with HTML pages they correctly wrap. The output is a general procedure for extracting data that works for many formats and many pages. In experiments with a collection of 84 constrained but realistic extraction problems, we demonstrate that 30% of the problems can be handled perfectly by learned extraction heuristics, and around 50% can be handled acceptably. We also demonstrate that learned page-independent extraction heuristics can substantially improve the performance of methods for learning page-specific wrappers.


Keywords: information integration, machine learning, extraction.

Sunday, April 18, 2004

ASP Web Hosting Services, Free ASP Hosting, Free Hosting, Free Web Hosting, WebSAMBA Hosts 30 Megabytes Free

Tuesday, April 13, 2004

Editing => http://www.contenteditable.com/index.shtml

How to Create an HTML Editor Application
Reference:
http://www.hyperwrite.com/aspscripts/framer.asp?target=../features/contenteditable.htm
http://msdn.microsoft.com/workshop/author/editing/tutorials/html_editor.asp

direct page edit and blog?


First, make page editable:
javascript:document.body.contentEditable = 'true'; document.designMode='on'; void 0
Second, make copy of page:
javascript:x=window.open();x.document.write(document.documentelement.innerhtml);

About My Pictures Photo Support

Monday, April 12, 2004

Gallery :: your photos on your website
Gallery is a web based software product that lets you manage your photos on your own website. You must have your own website with PHP support in order to install and use it. With Gallery you can easily create and maintain albums of photos via an intuitive interface. Photo management includes automatic thumbnail creation, image resizing, rotation, ordering, captioning, searching and more. Albums can have read, write and caption permissions per individual authenticated user for an additional level of privacy. Give accounts to your friends and family and let them upload and manage their own photos on your website!

Thursday, April 08, 2004

uk rss resources and rsslite

uk rss resources and rsslite

xslt rss client

ISO Recorder Power Toy

Creating a Multi-Boot DVD - MSFN.org

Wednesday, April 07, 2004

PHPkitchen - Come See What's Cookin'

PHPMailer - full featured email transfer class for PHP
Features
Can send emails with multiple TOs, CCs, BCCs and REPLY-TOs
Redundant SMTP servers
Multipart/alternative emails for mail clients that do not read HTML email
Support for 8bit, base64, binary, and quoted-printable encoding
Uses the same methods as the very popular AspEmail active server (COM) component
SMTP authentication
Word wrap
Address reset functions
HTML email
Tested on multiple SMTP servers: Sendmail, qmail, Postfix, Imail, Exchange, Mercury, Courier
Works on any win32 or *nix platform
Flexible debugging
Custom mail headers
Multiple fs, string, and binary attachments (those from database, string, etc)
Embedded image support

Monday, April 05, 2004

What Is Trackback?

Six Log: Secure Email-to-Blog: "Alex at slackerbit.ch came up with a mail2blog script that uses PGP signatures to securely authenticate the sender. Specifically, it uses the GnuPG.pm perl module to interface with gpg--after you've added your public key to the keyring used by the mail2blog script, signing your email messages provides all of the authentication necessary. Very cool, particularly the bit that assigns categories and pings TrackBack URLs."

Moblogger - Overview: "This application runs as a background process that monitors a POP3 email account for new email, then downloads it, detaches any files such as pictures, sound or video, uses the Blogger API to post the text in the email to your blog and uses FTP to post the files to your server. Send the email from a phone and you immediately start 'moblogging'. Take a look at the completed tasks for a list of features. "

Web Services Architecture: "This document defines the Web Services Architecture. It identifies the functional components and defines the relationships among those components to effect the desired properties of the overall architecture."

EasyMoblog - an open source blog and moblog platform: "Updating your blog contents has never been easier: just send an email from your personal computer or your mobile phone, and it will be automatically published on your blog!

EasyMoblog 0.4.1 provides:
a Web based wizard, which will guide you through the installation process
layout personalization
language localization
additional plug-in supports
support for HTML formatted messages
RSS syndication
... and much more "

ImageMagick - Convert, Edit, and Compose Images
ImageMagickTM 6.0.0 is a robust collection of tools and libraries offered under a usage license to read, write, and manipulate an image in many image formats (over 89 major formats) including popular formats like TIFF, JPEG, PNG, PDF, PhotoCD, and GIF. With ImageMagick you can create images dynamically, making it suitable for Web applications. You can also resize, rotate, sharpen, color reduce, or add special effects to an image or image sequence and save your completed work in the same or differing image format. Image processing operations are available from the command line, or from the C, C++, Perl, Java, PHP, Python, or Ruby programming languages. A high-quality 2D renderer is included, which provides a subset of SVG capabilities. ImageMagick's focus is on performance, minimizing bugs, and providing stable APIs and ABIs.

Here are just a few examples of what ImageMagick can do:

Convert an image from one format to another (e.g. TIFF to JPEG)
Resize, rotate, sharpen, color reduce, or add special effects to an image
Create a montage of image thumbnails
Create a transparent image suitable for use on the Web
Turn a group of images into a GIF animation sequence
Create a composite image by combining several separate images
Draw shapes or text on an image
Decorate an image with a border or frame
Describe the format and characteristics of an image

HTTP - Hypertext Transfer Protocol Overview

Coppermine Photo Gallery
Web Server + PHP + MySQL + IM/GD = CPG!
Coppermine Photo Gallery has been tested working well on IIS, Apache 1.3.24 onwards to the latest Apache 2, on Linux, UNIX, OSX, and Win32 systems. The following settings are required:

Apache Survey: Apache Module Report

Friday, April 02, 2004

http://www.really-fine.com/SQL_union.html
phpbb union sql injection
The exploit included in the BugTraq post DOES NOT work. Here is why.

Both the TO and FROM fields hold the username and md5 hash in his exploit. The problem is each field only is able to hold 25 characters at most.

Most of you might be saying "Well, an MD5 hash is 32bytes" You are correct. So you may get a incomplete hash, but an incomplete hash cannot be cracked.

Now lets look at how to get it to work. Lets have a look at the table strcuture of phpbb_privmsgs We need a place that will hold at LEAST 32 bytes. Well, the subject field is varchar(255) Lets go ahead and put the username there.

Now, we will place the password in privmsgs_text and we are good to go :)


CODE
/privmsg.php?folder=savebox&mode=read&p=99&pm_sql_user=AND pm.privmsgs_type=-99 UNION SELECT 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,username,0,0,0,0,0,0,0,0,0,user_password FROM phpbb_users WHERE user_id=2 LIMIT 1/*



Thats all there is to it :)