Messages

Whats the point of this protocol?

I had UNIONs in a previous encarnation of this query, however it seemed overly large and inefficient.  Why is it bad to use LEFT JOINs this way?  Im not all that familiar with SQL optimization yet.

Im having alot of trouble creating an SQL query to select the data that I need to view.  I have 6 relevant tables in this database: clients, users, wildcards, groups, users_groups, and vouchers.  Now what I want to do is select 1 row that contains information from all those tables.  The problem I'm having is that if theres not matching data in a table it will always return an Empty set.  Heres a really simple version of my query:

Code Select Expand


SELECT u.flags as uf, g.flags as gf, w.flags as wf, c.flags as cf \
FROM users u, groups g, users_groups ug, wildcards w, clients c \
WHERE u.username='secretshop' AND (ug.username='secretshop' AND g.groupname=ug.groupname) AND 'secretshop' LIKE w.pattern AND c.client='WAR3';


This works unless theres no matching client or pattern or users_groups association or username.  I have this query semi working with LEFt JOIN statements as show below:

Code Select Expand



SELECT u.flags as uf, g.flags as gf, w.flags as wf, c.flags as cf \
FROM users as u \
LEFT JOIN (groups as g, users_groups as ug) ON(ug.username='secretshop' AND g.groupname=ug.groupname) \
LEFT JOIN clients as c ON(c.client='WAR3') \
LEFT JOIN wildcards as w ON('secretshop' LIKE w.pattern)
WHERE u.username='secretshop';

However this too will return nothing if there is no user entry. Using mass joins also causes a performance hit that Id rather not take, but will obviously if its required.

If anyone has any advise on this query and how I can get it to do what I want, please post.  Also It has occured to me that Im going about it completly wrong so if anyone wants to suggest a different approach that would be great aswell.

Alright then, here ya go. This is a shot of one of my computers, this one is running modular Xgl with a heavily patched version of Compiz window manager and the latest Gnome desktop.  glxgears is spanning 2 of my desktops and I have them rotated so you can see both in perspective.  Also firefox is set transparent so you can see glxgears behind it.  As you can see Im reading about the GTK C api :)

http://www.schoolgrounds.net/images/ss1.png

The impression I got from a superficial look at their site was that everything is rendered in 3d.  If they make better use of the graphics card to render my same 2d desktop, then that's fine, I made a faulty assumption.

Well Cairo is a vector graphics backend based on opengl that GTK and other 2d applications can use to render their content on the GPU as GL textures.  The obvious implications of this have given way to the GUI junkies to produce desktop window managers and plugins for those that can use obscene ammounts of CPU power to produce useless yet cool looking effects on the desktop.  That part is obviously questionably practical, but the ideas and reasons behind Xgl and cairo are good.  Apparently even the mozilla foundation is planning to use Cairo as a render backend for its new version of Gecko so soon we should see hardware accelerated web page displays for smoother fonts and faster scrolling using less CPU.  Anyhw I think its atleast interesting and should be looked at by all.

Well for those of you interested the B model is $586.99 after rebates while the A model which comes with several extended features is $876.99 and has no rebate option.  We also carry a Secret Care Plan which can get you an extended warentee so make sure to ask our sales representative about it.

You can use most window managers with Gnome, it just comes with Metacity by default :)

So the idea of taking grapics operations and moving them off the hardworking CPU to the better suited GPU is a bad idea? Seems like good design to me.  Thats really what Xgl and Cairo provide, hardware acceleration for all graphics operations, not just those done in games.

Code Select Expand

<?php	require_once("DB.php"); // Using PEAR::DB because it supports alot more stuff than the mysql api supplied with PHP		$result = "";	$db =& DB::connect("mysqli://$DB_USER:$DB_PASS@$DB_SERVER/$DB_USE");    if(DB::isError($db)) {        $result = "Cannot connect to database server.";    }else if (isset($_POST['query']) && strlen($_POST['query']) > 0) {		$sth = $db->query($_POST['query']);		if(DB::isError($db)) {        	$result = "Query error";   		}else {			$result = "Query completed";		}		$sth->free();		$db->disconnect();	}?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpMyAdmin RIVAL</title>
</head>

<body>

<?php if (strlen($result)) { echo "<h3>$result</h3>"; } ?>

<form action="rival.php" method="post">
<input name="query" type="text" value="

<?php echo $_POST['query']; ?>

" />
<input type="submit" />
</form>
</body>
</html>


I am a former Bnet junkie, Computer Science student, and aspiring IT professional.  I come here because there are few small communities on the net where people can discuss a broad range of topics.  I am a Linux and Windows user, I also own an Apple computer but I have donated it to my parents for eBay usage.  I consider myself well versed in multiple software development platforms including Linux and Win32.  It is important for me to keep my skillset inline with that of the industry so that I can provide clients with cutting edge technology that can easily be supported.  Most of the programming I do is either for work or in contribution to some of the Open Source Software that makes systems like Linux a viable platform in the modern day.

Because in the C language it is not necessary to add syntax to refrence a function my memory address the line
if (geteuid == 0) {  made it into the X code.  This statement compares the memory address of the geteuid function with zero (NULL in ansi C) and returns false always.  Because of this, X does not check the effective uid properly and is therefore vunerable to exploitation on versions of the system where the bug has not been corrected.  It should state :
if (geteuid() == 0) to determine if the user is root or not by effective user id.

So whos running Xgl/Compiz yet, besides me ?

Nice, I was writing this exact thing when someone notified me of this thread, thanks alot iago! You saved me about a day of hard work ;)