Ná myndum úr Gallery2
Skrifađ af
Birkir Rafn Guđjónsson ţann
20. febrúar 2008 - 20:51
Fjöldi lestra: 1340Ţađ er ansi strembiđ ađ ná myndum úr nýja gallery2, en mér tókst ţađ međ greynilega einhverju móti.
gagnagrunnurinn er ţvers og kruss, en međ nokkrum mysql skipunum og lúppum tókst mér ţetta.
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
26 |
27 |
28 |
29 |
30 |
31 |
32 |
33 |
34 |
35 |
36 |
37 |
38 |
39 |
40 |
41 |
42 |
43 |
44 |
45 |
46 |
47 |
48 |
49 |
50 |
51 |
52 |
53 |
54 |
55 |
56 |
57 |
58 |
59 |
60 |
61 |
62 |
63 |
64 |
|
<?php
/**
* @author Birkir Rafn Guđjónsson
* @copyright 2008
**/
## Filesystem check...
function gallery2_fs($id){
$rt = mysql_query("SELECT g_pathComponent FROM g2_FileSystemEntity WHERE g_id = $id");
$rt = mysql_fetch_row($rt);
return $rt[0];
}
$i=1;
while($i<=3){
$sql = mysql_query("SELECT * FROM g2_Item WHERE g_canContainChildren = '0' ORDER BY rand() LIMIT 1")or die(mysql_error());
$mynd = mysql_fetch_assoc($sql);
$id = $mynd["g_id"];
$titill = $mynd["g_title"];
## Flokka shitty
$flokkar = mysql_query("SELECT g_parentId FROM g2_ChildEntity WHERE g_id = $id");
$flokkar = mysql_fetch_row($flokkar);
$flokkar = $flokkar[0];
$slodir = array();
$slodir[0] = gallery2_fs($flokkar);
$x = 1;
while($flokkar != 7){
$flokkar = mysql_query("SELECT g_parentId FROM g2_ChildEntity WHERE g_id = $flokkar");
$flokkar = mysql_fetch_row($flokkar);
$flokkar = $flokkar[0];
$slodir[$x] = gallery2_fs($flokkar);
$x++;
}
$slodir = array_reverse($slodir);
$slod = '';
foreach($slodir as $num => $jee){
if($jee != ''){
$slod = $slod . '/'.$jee;
}
}
$getimg = mysql_query("SELECT g_pathComponent FROM g2_FileSystemEntity WHERE g_id = $id ORDER BY rand() LIMIT 1")or die(mysql_error());
$mynd = mysql_fetch_row($getimg);
$mynd = $mynd[0];
$getpath = mysql_query("SELECT g_id FROM g2_ChildEntity WHERE g_parentId = $id")or die(mysql_error());
$getpath = mysql_fetch_row($getpath);
$getpath = $getpath[0];
echo "<br><center><a href=\"http://gallery.com/v$slod/$mynd.html?g2_imageViewsIndex=1\" style='border:0px;'><img src=\"http://gallery.com/d/$getpath-3/$mynd\"></a><a href=\"http://gallery.com/v$slod/$mynd.html?g2_imageViewsIndex=1\"><br>$titill</a></center>";
$i++;
}
?>
|
24. febrúar 2008 - 12:31#1 - Tómas
Loopur eru svo yesterday, JOIN er today. Algjör óţarfi ađ querya grunninn mörgum sinnum, betra ađ gera ţađ bara í einni join skipun.
1 athugasemd skrifuđ -