Jump to content
php.lv forumi

izvelk jaunumus no ipb


SKuLs

Recommended Posts

Tātad dabūju scriptu ,brt man met erroru uz php-fusion jo scripts nav ar database conection un vai to varētu izveidot uz šī scripta? Šis scripts izvelk jaunumus no foruma galvenajā lapā!

<?php

############################

### SCRIPT CONFIGURATION ###

############################

//Server Path to The Forum

$cfg['forum_path'] = "./forums"; //DO NOT ADD A TRAILING SLASH!!

//Which Forum to Read from (You can have multiple of these)

$cfg['forums_id'][] = "16";

//$cfg['forums_id'][] = "1";

//$cfg['forums_id'][] = "1";

//$cfg['forums_id'][] = "1";

//Position of the Newest Post (DESC = Top, ASC = Bottom)

$cfg['latest_pos'] = "DESC";

//Display News per Page

$cfg['per_page'] = "4";

//News Limit - Global Limit (0 - No Limit)

$cfg['news_limit'] = "60";

//Message to Display when there are no News

$cfg['no_news'] = "There is currently no News.";

//Show page selector (true, false)

$cfg['page_select'] = "true";

//DEBUG MODE -- MAKE SURE YOU KNOW WHAT YOU ARE DOING

$cfg['debug'] = "false";

 

##############

### SCRIPT ###

##############

require_once( $cfg['forum_path'] . "/conf_global.php" );

 

$mysql = mysql_connect( $INFO['sql_host'], $INFO['sql_user'], $INFO['sql_pass'] /*, $INFO['sql_driver'] */ );

if ( !$mysql ) {

die( "<b>mysql_connect()</b>: ". mysql_error() );

}

 

$select_db = mysql_select_db( $INFO['sql_database'], $mysql );

if ( !$select_db ) {

die( "<b>mysql_select_db()</b>: ". mysql_error() );

}

 

for ($i = 0; $i < count( $cfg['forums_id'] ); $i++ ) {

$cfg['forum_id'] = $cfg['forums_id'][$i];

 

if ( $cfg['news_limit'] != "0" ) {

$query = mysql_query( "SELECT t.tid, t.title, t.topic_firstpost, p.pid, p.topic_id, p.post_date, p.author_id, m.id, m.name, p.post, t.posts

FROM ". $INFO['sql_tbl_prefix'] ."topics t, ". $INFO['sql_tbl_prefix'] ."posts p, ". $INFO['sql_tbl_prefix'] ."members m

WHERE t.forum_id = '". $cfg['forum_id'] ."'

AND t.tid = p.topic_id

AND p.author_id = m.id

AND p.pid = t.topic_firstpost

ORDER BY p.post_date ". $cfg['latest_pos'] ."

LIMIT ". $cfg['news_limit'] );

} else {

$query = mysql_query( "SELECT t.tid, t.title, t.topic_firstpost, p.pid, p.topic_id, p.post_date, p.author_id, m.id, m.name, p.post, t.posts

FROM ". $INFO['sql_tbl_prefix'] ."topics t, ". $INFO['sql_tbl_prefix'] ."posts p, ". $INFO['sql_tbl_prefix'] ."members m

WHERE t.forum_id = '". $cfg['forum_id'] ."'

AND t.tid = p.topic_id

AND p.author_id = m.id

AND p.pid = t.topic_firstpost

ORDER BY p.post_date ". $cfg['latest_pos'] );

}

 

if ( !$query ) {

die( "<b>mysql_query()</b>: ". mysql_error() );

}

 

$iNews = mysql_num_rows( $query );

$iRun = 0;

$iCurrent = 0;

 

if ( $iNews == 0 ) {

echo "<center><span style=\"font-family: Tahoma; font-size: 13px\">". $cfg['no_news'] ."</span></center><br>";

}

 

while ( $row = mysql_fetch_array( $query, MYSQL_NUM ) ) {

if ( $cfg['debug'] == "true" ) {

print_r( $row );

}

 

$iRun++;

if ( $iRun > ( $_GET['pg'] - 1 ) * $cfg['per_page'] && $iCurrent < $cfg['per_page'] ) {

 

/* EDIT THE DISPLAY DESIGN BELOW - CAREFUL (BEGIN) */

$sTemplate = <<<EOT

<table width="100%" cellpadding="3" cellspacing="3" border="0" class="forumline">

<tr>

<th class="thTop" height="20"><A NAME="<!-- TOPIC -->" title="<!-- TITLE -->"><FONT class="topic_title"><!-- TITLE --></FONT></a></th>

</tr>

<tr>

<td class="row1" style="font-size:11px;align:left;width:100%;">

Pievienoja <a href="<!-- FORUM -->/index.php?showuser=<!-- USER -->" target="_blank" title="Click Here For <!-- AUTHOR -->'s Profile!"><B><!-- AUTHOR --></B></a>

<DIV style="text-align:left;font-size:10px;">

<br>

<!-- POST -->

</DIV>

<br>

<DIV style="text-align:right;font-size:10px;">

<a href="<!-- FORUM -->/index.php?showtopic=<!-- TOPIC -->" title="View This Topic" target="_blank"> Apskat?t /koment?ri</a> [<!-- REPLIES -->

]</DIV>

</td>

</tr>

</table>

<BR />

EOT;

 

/* EDIT THE DISPLAY DESIGN BELOW - CAREFUL (END) */

 

$sParsed = str_replace( array( "<!-- TITLE -->",

"<!-- POST -->",

"<!-- TIME -->",

"<!-- AUTHOR -->",

"<!-- REPLIES -->",

"<!-- FORUM -->",

"<!-- TOPIC -->",

"style_emoticons/<#EMO_DIR#>", //SMILEY FIX

"<!-- USER -->",

"

",

"

",

"class='quotetop'",

"class='quotemain'",

"class='codetop'",

"class='codemain'" ),

array( $row[1],

$row[9],

//Begin NuclearGeneral Custom Date

date( "l, F j, Y h:i A", $row[5] ),

//End NuclearGeneral Custom Date

//Begin Orginal Date

//date( "F m, Y", $row[5] ),

//End Orginal Date

$row[8],

$row[10],

$cfg['forum_path'],

$row[0],

$cfg['forum_path'] ."/style_emoticons/default",

$row[7],

"<blockquote>",

"</blockquote>",

"style='background: #E4EAF2; border: 1px dotted #000; border-bottom: 0; border-left: 4px solid #8394B2; color: #000; font-weight: bold; font-size: 10px; margin: 8px auto 0 auto; padding: 3px;'",

"style='background: #FAFCFE; border: 1px dotted #000; border-left: 4px solid #8394B2; border-top: 0; color: #465584; padding: 4px; margin: 0 auto 8px auto;'",

"style='background: #FDDBCC; color: #000; font-weight: bold; margin: 0 auto 0 auto; padding: 3px; width: 98%;'",

"style='background: #FAFCFE; border: 1px dotted #000; color: #465584; font-family: Courier, Courier New, Verdana, Arial; margin: 0 auto 0 auto; padding: 2px; width: 98%;'" ),

$sTemplate );

 

if ( $cfg['debug'] != "true" ) {

echo $sParsed;

}

 

$iCurrent++;

}

}

 

mysql_free_result( $query );

}

 

mysql_close( $mysql );

 

if ( $cfg['page_select'] == "true" ) {

if ( $_GET['pg'] == "1" || $_GET['pg'] == "" ) {

echo "<span style=\"font-family: Tahoma; font-size: 13px\"><center><b><a style=\"text-decoration: none\" href=\"". $_SERVER['PHP_SELF'] ."?pg=1\"><<</a></b>";

} else {

echo "<span style=\"font-family: Tahoma; font-size: 13px\"><center><b><a style=\"text-decoration: none\" href=\"". $_SERVER['PHP_SELF'] ."?pg=". ( $_GET['pg'] - 1 ) ."\"><<</a></b>";

}

 

for ( $i = 0; $i < $iNews / $cfg['per_page']; $i++ ) {

if ( $i == $_GET['pg'] - 1 || ( $i == 0 && $_GET['pg'] == "" ) ) {

echo " <u>". ( $i + 1 ) ."</u> ";

} else {

echo " <a style=\"text-decoration: none\" href=\"". $_SERVER['PHP_SELF'] ."?pg=". ( $i + 1 ) ."\">". ( $i + 1 ) ."</a> ";

}

}

 

if ( $_GET['pg'] == $i ) {

echo "<b><a style=\"text-decoration: none\" href=\"". $_SERVER['PHP_SELF'] ."?pg=". $_GET['pg'] ."\">>></a></b>";

} else if ( $i > 1 && $_GET['pg'] == "" ) {

echo "<b><a style=\"text-decoration: none\" href=\"". $_SERVER['PHP_SELF'] ."?pg=". ( $_GET['pg'] + 2 ) ."\">>></a></b>";

} else if ( $i <= 1 && $_GET['pg'] == "" ) {

echo "<b><a style=\"text-decoration: none\" href=\"". $_SERVER['PHP_SELF'] ."?pg=". ( $_GET['pg'] + 1 ) ."\">>></a></b>";

} else {

echo "<b><a style=\"text-decoration: none\" href=\"". $_SERVER['PHP_SELF'] ."?pg=". ( $_GET['pg'] + 1 ) ."\">>></a></b>";

}

}

echo "";

?>

Ja var izpalīdzat!

Link to comment
Share on other sites

  • 1 year later...
  • 1 year later...

The Sharing Of Marriage (humor)

 

The old man placed an order for one hamburger,

French fries and a drink.

 

He unwrapped the plain hamburger and

carefully cut it in half, placing one half in front of his wife.

 

He then carefully counted out the French fries, dividing them into two piles and neatly placed one pile in front of his wife.

 

He took a sip of the drink, his wife took a sip and then set the cup down between them

.... As he began to eat his few bites of hamburger, the people around them were looking over and whispering.

 

Obviously they were thinking, 'That poor old couple - all they can afford is one meal for the two of them.'

 

As the man began to eat his fries a young man came to the table and politely offered to buy another meal for the old couple. The old man said, they were just fine - they were used to sharing everything

 

People closer to the table noticed the little old lady hadn't eaten a bite. She sat there watching her husband eat and occasionally taking turns sipping the drink.

 

Again, the young man came over and begged them to let him buy another meal for them.

This time the old woman said 'No, thank you, we are used to sharing everything..'

 

Finally, as the old man finished and was wiping his face neatly with the napkin, the young man again came over to the little old lady who had yet to eat a single bite of food and asked 'What is it you are waiting for?'

 

She answered

 

_______________________

investment banks

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...