|
The Fanlistings about latest rules join codes members update extra skins webring affiliates home Coven Network ![]() ![]() ![]() Other Skins? ![]() ![]() Random TVCORC $database="thedarkh_stuff"; //the name of the database containing all your FLs $user="thedarkh_stuff"; // the username that has access to the above database $pass="o979wjEN620197620"; // your MySQL password mysql_connect(localhost,$user,$pass); mb_internal_encoding ('utf8'); mysql_query ("SET CHARACTER SET 'utf8'"); mysql_query ("SET NAMES 'utf8'"); mysql_query("SET CHARACTER_SET_CLIENT='utf8'"); mysql_query("SET CHARACTER_SET_RESULTS='utf8'"); mysql_query("SET character_set_connection = 'utf8'"); @mysql_select_db($database) or die( "Unable to select database"); // Random images.. $recentquery1 = mysql_query("select t1.id, t1.name, t1.path, t1.level, t2.image_id, t2.category_id from piwigo_images as t1 inner join piwigo_image_category t2 on t1.id=t2.image_id where t1.level=0 group by t1.id order by rand () desc limit 0, 1"); while(list($id1, $name1, $path1, $level1, $image_id1, $category_id1) = mysql_fetch_row($recentquery1)) { $image_url1 .= substr($path1, 2); $thumb_img1 .= substr($path1, 20, -4); $thumb_path1 .= substr($path1, 2, 17); $thumb_file1 .= substr($path1, -4); $recent_images1 .= " "; } $recent_images1 .= ""; ?> |