Seditio ve Ldu hakkında sınırsız arama yapın
 
 
> 1 <

Etiketler: cevaplanmayan konular hakkında

Author Message

Sender

Members


Online status

334 posts

Location: Turkey
Occupation:
Age:

#713   2007-03-25 22:56 GMT      

Bu sitedeki gibi cevaplanmayan konular bölümü yapmak istiyorum.Şöyle bir şey çok mu yanlış olur ?


Code:
if ( !defined('LDU_CODE') ) { die("Wrong URL."); }

$plimit = "1";   

$sql = ldu_query("SELECT t.ft_id, t.ft_sectionid, t.ft_title, t.ft_updated, t.ft_postcount, t.ft_viewcount, t.ft_lastposterid, t.ft_lastpostername, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_topics t,$db_forum_sections s
WHERE t.ft_sectionid=s.fs_id AND t.ft_movedto=0 AND t.ft_mode=0 ORDER by t.ft_updated DESC LIMIT $plimit");

$latestposts = "<table border='1' width='100%' cellspacing='0' cellpadding='1' align='center'>";
$latestposts .= "<tr><td>Konu</td><td>Okunma</td><td>Cevaplanmayan konular</td><td>Tarih</td></tr>";

$ii=0;
while ($row = ldu_fetch_array($sql))
{
$ii++;
$img = ($usr['id']>0 && $row['ft_updated']>$usr['lastvisit']) ? "<a href=\"forums.php?m=posts&amp;q=".$row['ft_id']."&amp;n=unread#unread\"><img src=\"skins/$skin/img/system/arrow-unread.gif\" alt=\"\" /></a>" : "<a href=\"forums.php?m=posts&amp;q=".$row['ft_id']."\"><img src=\"skins/$skin/img/system/arrow-follow.gif\" alt=\"\" /></a> ";

$latestposts .= "<tr><td> &nbsp;";
$latestposts .= $img." <a href=\"forums.php?m=posts&amp;q=".$row['ft_id']."\">".ldu_cc(ldu_cutstring(stripslashes($row['ft_title']),38))."</a></td>";

$latestposts .="<td>&nbsp;(" .$row["ft_postcount"]. ") </td>";
$latestposts .="<td>&nbsp;(" .$row["ft_viewcount"]. ")</td>";
$latestposts .= "<td>&nbsp;<a href='users.php?m=details&amp;id=".$row["ft_lastposterid"]."'>".$row["ft_lastpostername"]."</a></td>";$latestposts .= "<td>&nbsp; ".date($cfg['formatmonthdayhourmin'], $row['ft_updated'] + $usr['timezone'] * 3600)."</td></tr>";
}

Dvdbil

Administrator


Online status

2,096 posts
http://www.seditio-tr.com
Pagerank: 3

Location: Turkey istanbul
Occupation: Web Tasarım & Yazılım
Age: 28

#714   2007-03-25 23:51 GMT      
postcount kontrolü yap <2 (2 den az ise gibi..)

Sender

Members


Online status

334 posts

Location: Turkey
Occupation:
Age:

#715   2007-03-25 23:55 GMT      

if mi kullanıcam?Biraz daha açık olabilirsen?

Dvdbil

Administrator


Online status

2,096 posts
http://www.seditio-tr.com
Pagerank: 3

Location: Turkey istanbul
Occupation: Web Tasarım & Yazılım
Age: 28

#716   2007-03-26 00:01 GMT      
Sqlde WHERE ile yer belirlerken t.ft_postcount<2 işini görür.

Code:
$sql = ldu_query("SELECT t.ft_id, t.ft_sectionid, t.ft_title, t.ft_updated, t.ft_postcount, t.ft_viewcount, t.ft_lastposterid, t.ft_lastpostername, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_topics t,$db_forum_sections s
WHERE t.ft_sectionid=s.fs_id AND t.ft_movedto=0 AND t.ft_mode=0 AND t.ft_postcount<2 ORDER by t.ft_updated DESC LIMIT $plimit");

Sender

Members


Online status

334 posts

Location: Turkey
Occupation:
Age:

#717   2007-03-26 00:07 GMT      
Sadece bu kod yeterlimi?Bunun için bir etiket belirlemem gerekir mi?

Dvdbil

Administrator


Online status

2,096 posts
http://www.seditio-tr.com
Pagerank: 3

Location: Turkey istanbul
Occupation: Web Tasarım & Yazılım
Age: 28

#718   2007-03-26 00:10 GMT      
Dene..

Sender

Members


Online status

334 posts

Location: Turkey
Occupation:
Age:

#719   2007-03-26 11:20 GMT      
olmadı .Hiç bir şey çıkmıyor tagde ekledim.

Dvdbil

Administrator


Online status

2,096 posts
http://www.seditio-tr.com
Pagerank: 3

Location: Turkey istanbul
Occupation: Web Tasarım & Yazılım
Age: 28

#726   2007-03-26 17:12 GMT      
Anlayamadım tam olarak ne çıkmıyor ?
Cevaplanmayan konun yoktur ?

Sender

Members


Online status

334 posts

Location: Turkey
Occupation:
Age:

#727   2007-03-26 17:13 GMT      

dvdbil şöyle bir şey yaptım ama,

http://rapidshare.com/files/22872908/unlastestpost.rar.html

olmadı :S

Dvdbil

Administrator


Online status

2,096 posts
http://www.seditio-tr.com
Pagerank: 3

Location: Turkey istanbul
Occupation: Web Tasarım & Yazılım
Age: 28

#729   2007-03-26 17:16 GMT      
Yahu sırf sql kodu ile nasıl forumu almayı düşünüyorsun ?

sana verdiğim örnek sql kodlarını, en üstte verdiğin sql ile değiştirip diğer kodlarla beraber çalıştıracaksın.

Sender

Members


Online status

334 posts

Location: Turkey
Occupation:
Age:

#732   2007-03-26 18:51 GMT      
Kurulum dosyası bulunamıyor diyor.Dediğin gibi yaptım

Code:
<?PHP

/* ====================
Land Down Under - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_LDU]
File=plugins/extended/unlatestposts/unlatestposts.php
Version=2
Updated=
Type=Plugin
Author=*****
Description=
[END_LDU]

[BEGIN_LDU_EXTPLUGIN]
Code=unlatestposts
Part=main
File=unlatestposts
Hooks=index.tags
Tags=index.tpl:{PLUGIN_unlatestposts}
Minlevel=0
Order=10
[END_LDU_EXTPLUGIN]
==================== */

if ( !defined('LDU_CODE') ) { die("Wrong URL."); }

$plimit = "1";   

$sql = ldu_query("SELECT t.ft_id, t.ft_sectionid, t.ft_title, t.ft_updated, t.ft_postcount, t.ft_viewcount, t.ft_lastposterid, t.ft_lastpostername, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_topics t,$db_forum_sections s
WHERE t.ft_sectionid=s.fs_id AND t.ft_movedto=0 AND t.ft_mode=0 AND t.ft_postcount<2 ORDER by t.ft_updated DESC LIMIT $plimit");

$latestposts = "<table border='1' width='100%' cellspacing='0' cellpadding='1' align='center'>";
$latestposts .= "<tr><td>Konu</td><td>Okunma</td><td>Cevaplanmayan konular</td><td>Tarih</td></tr>";

$ii=0;
while ($row = ldu_fetch_array($sql))
{
$ii++;
$img = ($usr['id']>0 && $row['ft_updated']>$usr['lastvisit']) ? "<a href=\"forums.php?m=posts&amp;q=".$row['ft_id']."&amp;n=unread#unread\"><img src=\"skins/$skin/img/system/arrow-unread.gif\" alt=\"\" /></a>" : "<a href=\"forums.php?m=posts&amp;q=".$row['ft_id']."\"><img src=\"skins/$skin/img/system/arrow-follow.gif\" alt=\"\" /></a> ";

$latestposts .= "<tr><td> &nbsp;";
$latestposts .= $img." <a href=\"forums.php?m=posts&amp;q=".$row['ft_id']."\">".ldu_cc(ldu_cutstring(stripslashes($row['ft_title']),38))."</a></td>";

$latestposts .="<td>&nbsp;(" .$row["ft_postcount"]. ") </td>";
$latestposts .="<td>&nbsp;(" .$row["ft_viewcount"]. ")</td>";
$latestposts .= "<td>&nbsp;<a href='users.php?m=details&amp;id=".$row["ft_lastposterid"]."'>".$row["ft_lastpostername"]."</a></td>";$latestposts .= "<td>&nbsp; ".date($cfg['formatmonthdayhourmin'], $row['ft_updated'] + $usr['timezone'] * 3600)."</td></tr>";
}

Dvdbil

Administrator


Online status

2,096 posts
http://www.seditio-tr.com
Pagerank: 3

Location: Turkey istanbul
Occupation: Web Tasarım & Yazılım
Age: 28

#733   2007-03-26 18:57 GMT      
Sen önce plugini normal bir şekilde çalıştır sonra cevaplanmayan olayını dediğim gibi yap.

Pluginin çalışmamasının konuyla ilgisi yok.

Sender

Members


Online status

334 posts

Location: Turkey
Occupation:
Age:

#737   2007-03-26 21:30 GMT      

Dvdbil halletim.Ama Forumdaki konular içerisinde cevaplanmayanlarda çıkıyor bunu nasıl engellerim?

Dvdbil

Administrator


Online status

2,096 posts
http://www.seditio-tr.com
Pagerank: 3

Location: Turkey istanbul
Occupation: Web Tasarım & Yazılım
Age: 28

#738   2007-03-26 23:41 GMT      
AND t.ft_postcount>2 tam tersini uygulayacaksın.

Sender

Members


Online status

334 posts

Location: Turkey
Occupation:
Age:

#758   2007-03-27 23:34 GMT      
Latestpost'da

$sql = ldu_query("SELECT t.ft_id, t.ft_sectionid, t.ft_title, t.ft_updated, AND t.ft_postcount<2, t.ft_viewcount, t.ft_lastposterid, t.ft_lastpostername, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_topics t,$db_forum_sections s
WHERE t.ft_sectionid=s.fs_id AND t.ft_movedto=0 AND t.ft_mode=0 ORDER by t.ft_updated DESC LIMIT $plimit");

şeklinde yaptım ama olmadı
> 1 <

Benzer konular (Similar topics) #BETA

Keywords (beta):

Forum Arşiv (beta):

[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] [65] [66] [67] [68] [69] [70] [71] [72] [73] [74] [75] [76] [77] [78] [79] [80] [81] [82] [83] [84] [85] [86] [87] [88] [89] [90] [91] [92] [93] [94] [95] [96] [97] [98] [99] [100] [101] [102] [103] [104] [105] [106] [107] [108] [109] [110] [111] [112] [113] [114] [115] [116] [117] [118] [119] [120] [121] [122] [123] [124] [125] [126] [127] [128] [129] [130] [131] [132] [133] [134] [135] [136] [137] [138] [139] [140] [141] [142] [143] [144] [145] [146] [147] [148] [149] [150] [151] [152] [153] [154] [155] [156] [157] [158] [159] [160] [161] [162] [163] [164] [165] [166] [167] [168] [169] [170] [171] [172] [173] [174] [175] [176] [177] [178] [179] [180] [181] [182] [183] [184] [185] [186] [187] [188] [189] [190] [191] [192] [193] [194] [195] [196] [197] [198] [199] [200] [201] [202] [203] [204] [205] [206] [207] [208] [209] [210] [211] [212] [213] [214] [215] [216] [217] [218] [219] [220] [221] [222] [223] [224] [225] [226] [227] [228] [229] [230] [231] [232] [233] [234] [235] [236] [237] [238] [239] [240] [241] [242] [243] [244] [245] [246] [247] [248] [249] [250] [251] [252] [253] [254] [255] [256] [257] [258] [259] [260] [261] [262] [263] [264] [265] [266] [267] [268] [269] [270] [271] [272] [273] [274] [275] [276] [277] [278] [279] [280] [281] [282] [283] [284] [285] [286] [287] [288] [289] [290] [291] [292] [293] [294] [295] [296] [297] [298] [299] [300] [301] [302] [303] [304] [305] [306] [307] [308] [309] [310] [311] [312] [313] [314] [315] [316] [317] [318] [319] [320] [321] [322] [323] [324] [325] [326] [327] [328] [329] [330] [331] [332] [333]