|
Para?ytos naujienos profilyje
|
| Toonis |
parašyta 2007-05-02 19:01
|
Apšylantis
Reputacija:
0
Pranešimai: 59
Įstojo: 2007-01-26
|
Reikt kodo,kad rodytu kokias naujienas yra djas/pateiks tas narys (ia viskas yra profile.php) js profily naudojama tai ;) Gal duosit? :p |
| |
|
|
| mindaugaz3 |
parašyta 2007-05-02 19:10
|
Savekas
Reputacija:
0
Pranešimai: 200
Įstojo: 2007-01-12
|
 Codeif (($list == 'profile') || ($list == 'threads')) {
$pagenav = false;
$result = dbquery(
\"SELECT tt.*, tf.*, tu.user_id,user_name FROM \".$db_prefix.\"threads tt
INNER JOIN \".$db_prefix.\"forums tf USING(forum_id)
INNER JOIN \".$db_prefix.\"users tu ON tt.thread_lastuser=tu.user_id
WHERE \".groupaccess('forum_access').\" AND thread_author='$lookup' LIMIT 100\"
);
$numrows = dbrows($result);
$alttitle = $numrows == 0 ? $locale['pe200'] : $locale['pe201'];
echo \"\n\"
.\"| \".$locale['pe100'].$data['user_name'].\"\".($list == 'profile' ? \">\" : \"\").\" | \n\"
.\"\n\"
.\"| \".$locale['pe103'].\" | \".$locale['pe104'].\" | \".$locale['pe105'].\" | \".$locale['pe106'].\" | \n\";
if ($numrows != 0) {
$result = dbquery(
\"SELECT tt.*, tf.*, tu.user_id,user_name FROM \".$db_prefix.\"threads tt
INNER JOIN \".$db_prefix.\"forums tf USING(forum_id)
INNER JOIN \".$db_prefix.\"users tu ON tt.thread_lastuser=tu.user_id
WHERE \".groupaccess('forum_access').\" AND thread_author='$lookup'
ORDER BY thread_lastpost DESC LIMIT $rowstart,$limit\"
);
while ($row = dbarray($result)) {
$replies = dbcount(\"(thread_id)\", \"posts\", \"thread_id='\".$row['thread_id'].\"'\");
$row2 = dbarray(dbquery(\"SELECT post_id FROM \".$db_prefix.\"posts WHERE thread_id='\".$row['thread_id'].\"' ORDER BY post_id DESC LIMIT 1\"));
$rstart = ($replies > 20 ? \"rowstart=\".((ceil($replies / 20)-1)*20).\"&\" : \"\");
echo \"\"
.\"\".trimlink($row['forum_name'], 30).\" | \"
.\"\".trimlink($row['thread_subject'], 30).\" | \"
.\"\".$row['thread_views'].\" | \"
.\"\".ceil($replies-1).\" | \"
.\" \n\";
}
if (($numrows > $limit) && ($list == 'profile')) echo \"| \".$locale['pe112'].\" | \";
elseif ($numrows > $limit) $pagenav = makePageNav($rowstart,$limit,$numrows,3,FUSION_SELF.\"?lookup=$lookup&list=threads&\");
} else {
echo \"| \".$data['user_name'].\" \".$locale['pe109'].\" | \";
}
echo \"\n \n
\n\";
if ($list != 'profile') echo \"\n
\n\";
}
Redagavo mindaugaz3 2007-05-02 19:11 |
| |
|
|
| MAnjack |
parašyta 2007-05-02 19:17
|
Puikusis
Reputacija:
0
Pranešimai: 1111
Įstojo: 2007-01-04
|
Atsidaryk profile.php ir ten susirask:
Code closetable();
Po juo terpk:
Code tablebreak();
$row_max = 20; // eilui skaiius
$rows = dbcount(\"(news_id)\", \"news\", \"news_name='\".$data['user_id'].\"'\");
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
opentable(\"Naujienos pateiktos: \".$data['user_name']);
echo \"
\";
$usernews = dbquery(\"SELECT * FROM \".$db_prefix.\"news WHERE news_name='\".$data['user_id'].\"' ORDER BY news_datestamp DESC LIMIT $rowstart,$row_max\");
//tablebreak();
$newsd = \"\";
while ($news=dbarray($usernews)) {
if ($newsd != \"\") $newsd .= \"
\";
$newsd .= \"![]('\".THEME.\"images/bullet.gif') \".$news['news_subject'].\"\";
}
if ($data['user_id'] != $userdata['user_id']) { $whatuser = \"?is narys turi\"; } else { $whatuser = \"Tu turi\"; }
if ($newsd != \"\") { echo $newsd; } else { echo \"\".$whatuser.\" Naujien nedjo.\"; }
echo \" |
\";
if ($rows > $row_max) echo \"\n\".makePageNav($rowstart,$row_max,$rows,3,FUSION_SELF.\"?lookup=\".$data['user_id'].\"&\").\"\n \n\";
closetable();
|
| |
|
|
| mindaugaz3 |
parašyta 2007-05-02 19:20
|
Savekas
Reputacija:
0
Pranešimai: 200
Įstojo: 2007-01-12
|
blyn djau, kad rodyt forumo temas, o ne naujienas :D |
| |
|
|
| MAnjack |
parašyta 2007-05-02 19:22
|
Puikusis
Reputacija:
0
Pranešimai: 1111
Įstojo: 2007-01-04
|
:D gal ir tas pravers :) |
| |
|
|
| Toonis |
parašyta 2007-05-02 19:30
|
Apšylantis
Reputacija:
0
Pranešimai: 59
Įstojo: 2007-01-26
|
MAnjack'o man nepatinka :DB) Reikia ka?ko pana?aus kaip:http://www.wtfthemes.com/profile.php?lookup=428
Tik reikia,kad bt kaip sakiau naujienos ;] |
| |
|
|
| Nepster |
parašyta 2007-05-02 20:28
|
S.Administratorius
Reputacija:
0
Pranešimai: 670
Įstojo: 2007-01-02
|
http://phpfusion....?mod_id=52
is cia issiimk sau reikiama koda... jei ka ten surasytos sritys kas kur :)
Redagavo Sharkman 2007-12-16 14:09 |
| |
|
