Date: 08/07/06 (Web Development)    Keywords: web

My boss doesn't want to run streaming video through our website. If I make video clips available in quick time format so that when people click the links the quick time player opens up and plays the video - it should work without any bandwidth issues on our end right? Ofcourse I would let the user know that they need to download it if they don't have it.

Source: http://community.livejournal.com/webdev/341712.html

Date: 08/07/06 (MySQL Communtiy)    Keywords: php, mysql, html, sql, web

in my last post -
http://community.livejournal.com/mysql/100762.html

I asked about how to speed up a query using many NOT LIKE %45% statements. I am starting to understand what I need to do, thanks to some advice. Since I am a newbie sql wannabee, it will take me a while. I am still not there yet, I think the best plan is to make another column tinyint, and mark the records I do not want to show. I am not quite sure of they syntax and how to do "if this, insert this data into the records column tinyint" so that I use that as a marker of a record NOT to show. I would figure I do that every once a month or so to mark all the records I don't want to show during a query. Any other ideas? Maybe it's easier to just filter them in the php web code?

One thing I did find out was that mysql had query_cache_size = 0. I set it to 80 megabytes and now any duplicate query is instant!! Nice. . .I was wondering why it couldn't cache duplicate searchs and some other things like that.

Source: http://community.livejournal.com/mysql/101221.html

Date: 08/07/06 (Web Development)    Keywords: css, html, web

http://www.angry-pigeon.com/oakorchard/Pages/eng_choosing01.html

I'm currently converting a web site to table-less code, and am having problems with links in Firefox. On the page I've linked to, I've made the text float to the right while the menu stays on the left, but this makes it so you cannot click on the links. It works fine in IE. Any help would be greatly appreciated. The CSS code is under the cut.


/* ---------------------General--------------------- */
* {
padding: 0;
margin: 0;
}

body {
background: #333300;
}

img {
border: none;
}

p {
font: 14px "Georgia", "Times New Roman", serif;
line-height: 20px;
}

a:link {
color: #333300;
font: 14px "Georgia", "Times New Roman", serif;
line-height: 20px;
background-color: transparent;
}

a:active {
color: white;
font: 14px "Georgia", "Times New Roman", serif;
line-height: 20px;
background: #333300;
text-decoration: none;
}

a:hover {
color: white;
font: 14px "Georgia", "Times New Roman", serif;
line-height: 20px;
background: green;
text-decoration: none;
}

h2 {
color: #000000;
font: 16px "Lucida Grande", "Arial", "Verdana", sans-serif;
font-weight: 800;
line-height: 22px;
}

h3 {
color: #000000;
font: 14px "Georgia", "Times New Roman", serif;
line-height: 20px;
}

/* ---------------------Layout--------------------- */
#container {
background: #ffffff;
margin: 15px auto;
width: 740px;
text-align: left;
position: relative;
}

#header {
}

#topMenu {
position: absolute;
top: 73px;
left: 0px;
}

#banner {
background: #ffffff;
position: absolute;
top: 91px;
text-align: center;
width: 740px;
}

#mainContent {
background: #ffffff;
width: 740px;
position: absolute;
top: 320px;
}

#contentBox {
width: 634px;
margin-left: auto;
margin-right: auto;
}

#footer {
width: 740px;
position: relative;
top: 10px;
}

#botMenu {
background: #ffffff;
position: relative;
bottom: 3px;
}

#copy {
text-align: center;
background: #333300;
position: relative;
bottom: 6px;
}

#contentLeft {
margin-right: 5px;
float: left;
}

#contentRight {
float: right;
}

/* ---------------------Properties--------------------- */
#t2, #t3, #t4, #t5, #t6 {
position: absolute;
top: 0px;
}

#t2 {
left: 116px;
}

#t3 {
left: 180px;
}

#t4 {
left: 242px;
}

#t5 {
left: 414px;
}

#t6 {
left: 608px;
}

#b2, #b3, #b4, #b5, #b6, #b7 {
position: absolute;
}

#b2 {
left: 157px;
}

#b3 {
left: 237px;
}

#b4 {
left: 332px;
}

#b5 {
left: 454px;
}

#b6 {
left: 542px;
}

#b7 {
left: 609px;
}

.h4 {
font-size: 12px;
line-height: 16px;
}

#copy p {
color: gray;
font: 10px "Arial", "Verdana", sans-serif;
line-height: 17px;
}

#footerLink {
color: gray;
font: 10px "Arial", "Verdana", sans-serif;
}

.ital {
font-style: italic;
}

Source: http://community.livejournal.com/webdev/341794.html

Date: 08/08/06 (Web Development)    Keywords: web

Quick one: Tried googling for this but so far it nilch.

Situation:

I have access to /web_root/tracking  and /web_root/library/ but not /web_root/.    Is there a way to set Dreamweaver to let me work in ./tracking and put/get files from ./library/ at the same time?  No biggy if it won't but its annoying.   And I guess as a work around I could just create a link between the two while I am working then have the user kill it later.

Source: http://community.livejournal.com/webdev/342028.html

Date: 08/09/06 (Java Web)    Keywords: web

Cancelling an AOL account can become a royal pain. As easy as it is to get an AOL account, they make it extremely hard to get out of it. This article lists three sure-fire time-tested methods of cancelling your AOL account in three minutes or less, one of them using the web. A fun bonus [...]

Source: http://blog.taragana.com/index.php/archive/3-ways-to-cancel-aol-account-under-3-minutes/

Date: 08/09/06 (Java Web)    Keywords: web, spyware

Windows Genuine Advantage (how to remove WGA) has been alleged as Spyware, creates innumerable problems for genuine users and yet it is very simple to fool with 15 minutes or less of effort. Ed Bott spent about 15 minutes to find a web page containing five volume license keys that had reportedly been posted on [...]

Source: http://blog.taragana.com/index.php/archive/how-to-fool-windows-genuine-advantage-in-15-minutes/

Date: 08/09/06 (Java Web)    Keywords: web, google

The Sony mylo (short for “my life online”) is a nifty handheld device that will allow you to access a fun set of features from a WiFi network. With 1GB of memory you can store music and photos, browse the web, or use email and IM (with QWERTY keyboard). The mylo comes with built-in Google [...]

Source: http://blog.taragana.com/index.php/archive/google-talk-marries-sony-mylo-handheld-device/

Date: 08/09/06 (Java Web)    Keywords: security, web

Recently AOL released 20 million web search queries, over a period of three months, from 650, 000 AOL search engine users. The data anonymizes user identity by assigning them numerical id. However that is not much security as users can be easily identified. With such leaks it is easy to find out what you are [...]

Source: http://blog.taragana.com/index.php/archive/1-minute-guide-to-protect-against-search-engines-tracking-using-firefox-browser/

Date: 08/09/06 (PHP Community)    Keywords: php, web

I've been using a form mail script from CosmicPHP for a while now, it was the only thing that I got to work on my server. The emails I recieved came from the email address no_reply@itweb.no (IT Web is my domain host). But now ITweb has hooked up with another host and they recently closed the itweb server, so I am not recieving the emails since the sender address does not exist.

I looked at the script to see where I would specify the sender address but I couldn't find it. I included the two files the script uses below in the lovely cuts.



include('config.php');

global $emailfield;
global $required;
global $sentmessage;
global $toemail;
global $fields;
global $subject;


$msg = array($name, $email, $message);
$name = 'name';
$email = 'email';
$message = 'message';

$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";

$filename = "email.htm";
$handle = fopen ($filename, "r");
$contents = fread ($handle, filesize ($filename));
fclose ($handle);

foreach ($fields as $field)
{
$entry = $_POST[$field];
if (!$entry) $entry = "No data submitted";
$contents = str_replace ("::$field::",$entry,$contents);
}

mail($toemail, $subject, $contents, $headers);

$filename = "sent.htm";
$handle = fopen ($filename, "r");
$contents = fread ($handle, filesize ($filename));
fclose ($handle);

$contents = str_replace ("::SentMessage::",$sentmessage,$contents);

echo $contents;
?>



## fields contains all the variables from the form to be sent in the email - CaSe SeNsItIvE
$fields = array('email','episode');

## required contains all the variables that MUST be filled in - CaSe SeNsItIvE
$required = array();

## emailfield contains the name of the variable to be validated as an email address
$emailfield = "Email";

## subject of the email to be sent
$subject = 'Quote Quiz Results';

## email address to send responses to
$toemail = 'kristine@perander.no';

## message displayed when email has been sucessfully sent
$sentmessage = "Your message has been sent."
?>

So my question is this; is it possible to add something to the script that spesifies a sender address and put one of my addresses there (and is it easy?), or should I look for a new script? My php knownledge: It is safe to let me customize it but not code it myself:p

Source: http://community.livejournal.com/php/480662.html

Date: 08/10/06 (Web Technology)    Keywords: web

Democratic politician says flap shows new laws are necessary to force Web sites to delete data. Not everyone is convinced.

Source: http://news.zdnet.com/2100-9588_22-6104040.html

Date: 08/11/06 (PHP Community)    Keywords: php, database, sql, security, web, hosting

Sorry to be posting again with nothing to actually contribute, but I'm having a hacker issue with one of my websites. I'm not one to jump on sudden suspicions of hackers, and I don't victimize myself, but this is the second time someone's hacked my site.

After the first time, I was extremely cautious. I uploaded my site to a new server and made sure not to install any interactive PHP scripts. I did, however, continue to code my website in basic PHP, but nothing that required a connection with an SQL database or any sort of log in - just simple PHP pages with dynamic inclusion and switch functions.

[/END SOB STORY]

My friend's webhost (my friend was hosting me at the time) sent this as a response to my e-mail:

"Do NOT put any php pages back up on this site if you wish to host it with us and certainly not any phpbb boards which were most likely used in the attempt to hack our server."

include("language.php");

"; include("layout.php"); echo " "; include("nav.php"); echo " "; // --- DYNAMIC INCLUSION $page = basename($x); if(!$x) include("main.php"); else include("$x.php"); echo "

";
?>

Source: http://community.livejournal.com/php/481154.html

Date: 08/10/06 (Web Technology)    Keywords: web

People who download movies off the Web will soon be able to copy them to specially made DVDs.

Source: http://news.zdnet.com/2100-9588_22-6104388.html

Date: 08/11/06 (PHP Community)    Keywords: web, shopping

Hello,

I was wondering if anyone might have any suggestions for taking credit card payments from a website. I don't need a traditional shopping cart, as it's not as simple as selecting a product and using a shopping cart to pay. What I need to do is have my site generate the cost due (which I'm working on) and then have the user click a link to pay, at which time they enter their credit card info.

Thanks for your time

Source: http://community.livejournal.com/php/481825.html

Date: 08/11/06 (PHP Community)    Keywords: mysql, sql, java, web

What I got now:

SignUP

Phase 1
Basic webform with Javascript helper script that isn't required.

Phase 2
Collect user information for sale from previous form, validate/normalize the information (anti-everything but alphanumeric except ' and -), insert information into DB with pending flag.

Embed record ID into hidden form field
Present user with sales choice (invoice, electr invoice, credit).

Phase 3
Grab the embedded form field, validate ID by "x = (int) y;", and compare REMOTE_ADDR to the DB Record, and update record via a super-limited DB user account ( it only has privileges set by MySQL to update "accountInfo.payMethod" and select "accountInfo.ID" and "accountInfo.IP"

Display confirmation page of their order then either jump to the CCard service and out of my responsiblity.


I can't see how someone could break this system as it stands, but I am tempted to do the entire thing with Session handling, passing the SID to the second form and retrieving it on the third to get $_SESSION['myID'] just to make it even harder to break.

Source: http://community.livejournal.com/php/481637.html

Date: 08/12/06 (WebDesign)    Keywords: web

This is more on the design side, rather than the technical side, but I'm finally getting around to doing some actual web designing for my personal site, HelloKen.net. I'm not sure whether to be satisfied with what I have or not so I'm going to sleep on it. A friend and I have been looking at it for the past hour and we both agree that something is intrinsically wrong with it, but can't figure it out. Any thoughts?

HelloKen - version 1.2 Kiiroi Tori

x-posted to community web_design

Source: http://community.livejournal.com/webdesign/1149787.html

Date: 08/13/06 (MySQL Communtiy)    Keywords: mysql, html, sql, web

I have these files generated by a perl script, called something.hwd.

Format of each file is the title separated by a pipe symbol and then the html of the article. Example:

This is the title | Some html about the article goes here

Does anyone know how to mass import about 500 of these files into MySQL as records in a single table? I was going to write a script that would grab the date and time stamp of each file and then make the file format like this

2006-06-06 | Title | The HTML

I almost had it working but some records were skipped, I was using mysql's import command.

Anyway, if you can't figure it out, no problem. The client is willing to start with a fresh website.

Source: http://community.livejournal.com/mysql/101402.html

Date: 08/13/06 (Web Technology)    Keywords: web

Septuagenarian widower's soft-spoken, humble manner has won the hearts of users of the youth-dominated Web site.

Source: http://news.zdnet.com/2100-9588_22-6105018.html

Date: 08/14/06 (WebDesign)    Keywords: web, hosting

i am looking for relatively inexpensive hosting (less than or equal to $5 a month) for http://1919hemphill.org. right now we are using a free webhost that provides to us because we are a DIY music venue and a not for profit group. but they have been having a lot of problems lately and we need alternatives. i was wondering if anyone knew of anyone that gives discounts or something to stuff related to punk rock, and if not, just good reliable webhosts. right now we have 50mb of space and 500mb of bandwidth. not great but it's free. i've been looking around and i just don't know of reliability of stuff. there are a few that are definitely reliable but not within our price range.

anyway i know this question gets asked all the time. maybe we should put it on the memories or something.

Source: http://community.livejournal.com/webdesign/1150011.html

Date: 08/14/06 (WebDesign)    Keywords: mysql, database, sql, web, google

ok i've picked a new web host. i googled this but couldn't make it give me an answer. i would like to transfer emails that are stored on my current host's server to the new host and make them viewable thru the new host's webmail. is this kind of thing possible? would it depend on the web host and the email program they use?

also i would like to transfer my message board as well. would it be as simple as downloading the mysql database and uploading it to the new server?

thanks again for all your help!

Source: http://community.livejournal.com/webdesign/1150308.html

Date: 08/14/06 (Web Development)    Keywords: database, web

I currently have a VBScript that connects to a database, pulls out some information, does a compairson and then sends an email if conditions are met. It works online but I need to find a way to make this run on a schedule and I think the best way is probably to write it as a Visual Basic exe and set it up on the web server using the Windows scheduler.

It's been about 5 years since I wrote a VB program so I was wondering if anyone out there could help me sort how to go about doing the same thing in VB as I did in VBScript? Or point me towards a tutorial that will let me connect to a database, run a query and send an email.

Source: http://community.livejournal.com/webdev/344647.html