deathangel00 Posted June 7, 2009 Report Share Posted June 7, 2009 Sveicināti ,man ir divi jautājumiņi. Pirmais : * Es esmu uzlicis teksta failu kā UTF-8 ,bet tikum tā man rāda šādi jaunumus no foruma Teksta fails ir <!-- jaunumu skripts caur invision power board, veidoja duplets, apmekleejiet http://cs.hackers.lv --> <?php //------------------------------------------------------------------------------------------------ // "ipb news to webstite" script by duplets visit http://cs.hackers.lv //------------------------------------------------------------------------------------------------ $forums = "http://boosts.oo.lv/f"; // noraadam urliiti uz forumu $limits = "5"; // topiku limits jaunumos $forumaID = "9"; // forums no kura velkam aaraa jaunumus $host = "localhost"; $dbname = "boost.lv"; $dbuser = "*********"; $dbpass = "********"; $link = mysql_connect($host, $dbuser, $dbpass) or die("NEsanaaca piekontektities: " . mysql_error()); mysql_select_db($dbname) or die("Datubaaze neekstistee"); mysql_query("SET NAMES utf8"); // diezgan noziimiigs kveriijs, ja nee sh un zh vietaa buus nesmuki kjeburi // dabuunam datus no DB $kverisdivi = mysql_query("SELECT * FROM ibf_topics WHERE forum_id=".$forumaID." ORDER BY start_date DESC LIMIT ".$limits.""); // shito nedriikst aizmirst, ja nee baigiee suudi ar charstetiem iznaaks echo "<h1>Jaunumi</h1><br><br>"; // izvadam jaunumus while($row = mysql_fetch_array( $kverisdivi )) { $rowis = mysql_fetch_array( mysql_query("SELECT * FROM ibf_posts WHERE topic_id = ".$row['tid']." ORDER by post_date LIMIT ".$limits."")); echo "<h3><a href=\"$forums/index.php?showtopic=".$row['tid']."\">".$row['title']."</a> <br><br><br /></h3>"; echo "<div>".$rowis['post']."</div><br />"; echo "<div>autors: <a href=\"$forums/index.php?showuser=".$row['starter_id']."\">".$row['starter_name']."</a></div><br><br><hr>"; } ?> otrs jautājums : Es uzliku scriptu ,kas parāda visus jaunākos rakstus forumā ,bet rādās šādi Kods <?php $platums = "160"; // platums px $forums = "http://boosts.oo.lv/f"; // foruma url $limits = "4"; // cik daudz jaunumi uzradisies $host = "localhost"; // db hosts $dbname = "*******"; // foruma datubaze $dbuser = "********"; // foruma db users $dbpass = "********"; // juusu foruma datubaazes parole $link = mysql_connect($host, $dbuser, $dbpass) or die("NEsanaaca piekontektities: " . mysql_error()); mysql_select_db($dbname) or die("Datubaaze neekstistee"); mysql_query("SET NAMES UTF-8"); // lai rada LV alfabetu // dabuunam datus no DB $kverisdivi = mysql_query("SELECT posts, last_poster_name, last_poster_id, title, tid, forum_id, last_post FROM ibf_topics ORDER BY last_post DESC LIMIT ".$limits.""); echo "<div>"; // izvadam jaunumus while($row = mysql_fetch_array( $kverisdivi )) { echo "<p><u> <a style='font-size:10pt' href=\"$forums/index.php?showtopic=".$row[tid]."&view=getnewpost\" title=\"\">".$row[title]."</a><br> <a style='text-decoration: none' href=\"$forums/index.php?showuser=".$row[last_poster_id]."\" title=\"\">"."</a></p>"; } echo "</div>" ; Lūdzu palīdziet Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now