What are you working on? v6

[Sharpshooter]

Doesn't look bad but I think its the background that makes it 'something'. I think the logo itself needs something to set it off rater than it just being your standard typeface with a 3px hard drop shadow.

[adamjon858]

[QUOTE=Sharpshooter;31927124]Doesn't look bad but I think its the background that makes it 'something'. I think the logo itself needs something to set it off rater than it just being your standard typeface with a 3px hard drop shadow.[/QUOTE]

This. Try lowering the drop shadow to 1px and adding a gradient overlay as well as a slight 1px inner glow.

[Vietnow]

[QUOTE=TehWhale;31925819]I wanted to have a web design class but turns out to do web design you have to take a course to learn how to use Dreamweaver first, what the flying fuck[/QUOTE]

Pretend to use GUI
Use code view for everything

[TehWhale]

yeah well i'm not gonna spent a semester taking a dreamweaver and microsoft word class so i can go use dreamweaver design view in a shit class

NO

[editline]24th August 2011[/editline]

then again they want me to take an AP college-level programming class online that's worth 2 high school credits and is transferable, hmmmmm

[PieClock]

I had to sit through a year of Dreamweaver, it was fucking awful. I wanted to use the code view but I had to explain how I went about making everything using the design view in an essay as well. I could have lied but that's more bother than it's worth. I just ended up making an absolute shit website and came out with the top grade.

It's not worth it really, you'd be better off spending the time building a strong portfolio.

[moonage]

Compwhizii was telling me a while ago how InnoDB doesn't know how many rows a table has, so 'SELECT COUNT(*) FROM some_table" is slow and requires a full table scan. He then went on to say how if you include a WHERE constraint, COUNT(*) becomes really fast. So I tried it out:

[img]http://i.imgur.com/xbsip.png[/img]
[img]http://i.imgur.com/86lhr.png[/img]

[img]http://i.imgur.com/qYHb3.png[/img]
[img]http://i.imgur.com/h1pYM.png[/img]

I tried executing the queries several items in different orders and the timing was always consistent. Interesting.

[fw0p]

[QUOTE=Sharpshooter;31927124]Doesn't look bad but I think its the background that makes it 'something'. I think the logo itself needs something to set it off rater than it just being your standard typeface with a 3px hard drop shadow.[/QUOTE]

I agree

[QUOTE=adamjon858;31927523]This. Try lowering the drop shadow to 1px and adding a gradient overlay as well as a slight 1px inner glow.[/QUOTE]

[img]http://f.cl.ly/items/2o011F2T330m1a342S0X/logo.png[/img]

Improvement?

[Crhem van der B]

Turb what times you get with MyISAM with the same database?

[moonage]

[QUOTE=Crhem van der B;31933241]Turb what times you get with MyISAM with the same database?[/QUOTE]

Not going to try it, but MyISAM would be instant for SELECT COUNT(*) FROM some_table, and maybe a little slower if you throw in that WHERE clause

[Fizzadar]

COUNT( col ) could be a better option/interesting read: [url]http://www.mysqlperformanceblog.com/2007/04/10/count-vs-countcol/[/url]

[moonage]

[QUOTE=Fizzadar;31933719]COUNT( col ) could be a better option/interesting read: [url]http://www.mysqlperformanceblog.com/2007/04/10/count-vs-countcol/[/url][/QUOTE]

That's for MyISAM, but I'll try it on my InnoDB database and see what happens.

[editline]25th August 2011[/editline]

COUNT(*) and COUNT(id) both ran at comparable times with and without the where clause for me

[EJay]

[QUOTE=moonage;31933791]That's for MyISAM, but I'll try it on my InnoDB database and see what happens.

[editline]25th August 2011[/editline]

COUNT(*) and COUNT(id) both ran at comparable times with and without the where clause for me[/QUOTE]

What's the actual difference between MyISAM and InnoDB?

[moonage]

innodb has row-level locking, myisam only does whole table locking

[adamjon858]

aka, myisam will fuck your shit up if you have to do a lot of writes.

[hzy]

MyISAM is about as elegant as greping a text file.

[moonage]

[QUOTE=H4Z3Y;31934484]MyISAM is about as elegant as greping a text file.[/QUOTE]

Hey, don't be so harsh!

grep is a fantastic tool

[Fizzadar]

Resolution problem solved, thanks to a tiny bit of PHP :)

[img]http://f.anyhub.net/3XK5[/img]

[editline]25th August 2011[/editline]

(backgrounds still need doing)

[KmartSqrl]

Ur mom stil needs doing. O wait no she doesn't.

[adamjon858]

Has anyone ever ever used the satin layer effect in Photoshop?

What is it even useful for...it's just.....

[bbang]

[QUOTE=adamjon858;31935749]Has anyone ever ever used the satin layer effect in Photoshop?

What is it even useful for...it's just.....[/QUOTE]

I used it when i was making some random stuff with photoshop when i was just starting to use.

[editline]25th August 2011[/editline]

but, it's unnecessary

[Sharpshooter]

[QUOTE=adamjon858;31935749]Has anyone ever ever used the satin layer effect in Photoshop?

What is it even useful for...it's just.....[/QUOTE]

If you toy with the contour you can achieve some effects I guess, but I can't say I use it very often.

also, finished up my php search engine system for my project!

<link rel="stylesheet" type="text/css" href="css/itemboxstyling.css" />
<?php

Include "DatabaseConnectionHandler.php";

$sql = "SELECT * FROM item_database WHERE ";

$searchquery = ($_GET['searchbox']);
$searchpresent = false;

if (!empty($searchquery))
{
	$sql .= "itemname LIKE '%" . ($searchquery) . "'";
	$searchpresent = true;
	$searchquery = mysql_real_escape_string($searchquery);
	$searchquery = htmlspecialchars($searchquery);
	$searchquery = str_replace(array("s ", "'s", "-", "'", " "), "%", $searchquery . " ");

}

$classes = array("all", "demoman", "engineer", "heavy", "medic", "pyro", "scout", "sniper", "soldier", "spy");

$isclass = 0;
foreach ($classes as &$class)
{
  if (isset($_GET[$class]))
  {
    if (!$isclass) 
    {
      if ($searchpresent) { $sql .= " AND"; }
      $sql .= " (";
    }
    $sql .= ($isclass ? " OR " : "") . "class='$class'";
    $isclass = 1;
  }
}
if ($isclass) { $sql .= ")"; }
unset($class);

if (!$isclass == 1 and !$searchpresent == True)
{
	echo('<span class="searcherrortext"> Well atleast try searching for something ya mumbling devil!</span>');
}
else
{
	$result = mysql_query($sql);
	$recordcount = 0; /*keeps track of number of records returned from search */
	if(!mysql_num_rows($result) == 0)
	{
		while ($row = mysql_fetch_array($result))
		{
		echo "<div id = 'item'>";
		echo "<div id = 'itemtitle'>" . $row['itemname'] . "</div>";
		echo "<div id = 'itemimage' style = 'background-image:url(images/items/" . $row['imagename'] . ".png)'></div>";
		echo "<div id = 'itemvalue'> <span class = 'valuetext'>" . $row['value'] . " " . "</span>" . $row['currency'] . "</div>";
		echo "</div>";
		echo "\n";
		$recordcount += 1;
		}
	}
	else
	{
		echo('<span class="searcherrortext"> No items found! Oh dis is bad! </span>');
	}

}
mysql_close($con);

?>

[jaybuz]

[QUOTE=Fizzadar;31934708]Resolution problem solved, thanks to a tiny bit of PHP :)

[img]http://f.anyhub.net/3XK5[/img]

[editline]25th August 2011[/editline]

(backgrounds still need doing)[/QUOTE]

How can you write code in 58C heat!

[sp]Looks great by the way. :)[/sp]

[yngndrw]

[QUOTE=moonage;31932768]Compwhizii was telling me a while ago how InnoDB doesn't know how many rows a table has, so 'SELECT COUNT(*) FROM some_table" is slow and requires a full table scan. He then went on to say how if you include a WHERE constraint, COUNT(*) becomes really fast. So I tried it out:

[img]http://i.imgur.com/xbsip.png[/img]
[img]http://i.imgur.com/86lhr.png[/img]

[img]http://i.imgur.com/qYHb3.png[/img]
[img]http://i.imgur.com/h1pYM.png[/img]

I tried executing the queries several items in different orders and the timing was always consistent. Interesting.[/QUOTE]
That's quite interesting. I managed to find out that the reason that InnoDB doesn't cache the number of rows is because InnoDB supports row-level locking and therefore there can be multiple concurrent transactions. This means that if there are other transactions in-progress, there can be cases when there is not a single correct row count for the table.

I believe that counting with a where clause should have about the same performance for both InnoDB and MyISAM but I can't understand why counting without a where clause is so much slower than when using a where clause on InnoDB - It's almost as if it's not using an index.

I wonder what the effect of adding the where clause has on concurrency.

[Jelly_]

[QUOTE=jaybuz;31941392]How can you write code in 58C heat!

[sp]Looks great by the way. :)[/sp][/QUOTE]

Air conditioner or a fan.

[yngndrw]

[QUOTE=Sharpshooter;31939433]If you toy with the contour you can achieve some effects I guess, but I can't say I use it very often.

also, finished up my php search engine system for my project!

<snip>

[/QUOTE]This is vulnerable to SQL injection - You're sanitising your $searchquery parameter after you have already concatenated it.

[Sharpshooter]

[QUOTE=yngndrw;31942391]This is vulnerable to SQL injection - You're sanitising your $searchquery parameter after you have already concatenated it.[/QUOTE]

Thanks for pointing that out, I had been jiggling bits of the code around all day trying to find the best solution and have overlooked that I had done that.

[adamjon858]

Grumble Grumble...

I've come to realize that there's no such thing as a perfect framework or even a near perfect framework. I've been working with Django recently and it's possibly the nicest bit of code I've ever worked with. However, it's still got problems. Need to allow users to login with email instead of username? Need to use an external login service? Too bad...it's going to take you a while to figure out how to implement it.

A lot of times, it seems like the best framework is one that you build yourself. It's tailored to your programming style and you know it inside and out.

[B]/programming wisdom[/B]

[Crhem van der B]

Just before going to sleep thought of a new project, making a logo for it:
[img]http://img1.uploadscreenshot.com/images/orig/8/23702463915-orig.png[/img]
Of course, as always, I think something is wrong with it, any advices?

Made another variant:
[img]http://img1.uploadscreenshot.com/images/orig/8/23703070237-orig.png[/img]

[Buck.]

Fly cheap huh? Hopefully I'l get some cheap flights when your'e done!

How does it look scaled down? Looks like it will be hard to read on smaller size.

[Fizzadar]

[QUOTE=adamjon858;31948645]Grumble Grumble...

I've come to realize that there's no such thing as a perfect framework or even a near perfect framework. I've been working with Django recently and it's possibly the nicest bit of code I've ever worked with. However, it's still got problems. Need to allow users to login with email instead of username? Need to use an external login service? Too bad...it's going to take you a while to figure out how to implement it.

A lot of times, it seems like the best framework is one that you build yourself. It's tailored to your programming style and you know it inside and out.

[B]/programming wisdom[/B][/QUOTE]

White a tiny micro-framework of you're basic stuff and work with that!