Navigacija

Vartotojų tinkle

Prisijungusių svečių: 107
Prisijungusių narių: 0
Prisijungusių narių nėra

Registruoti nariai: 25,963
Naujausias narys: WolfHammer

Naujausi straipsniai

Paskutiniai nariai

N-20 3 dienos
Reikalas 4 dienos
Rytis 1 savaitė
DjArtas 2 savaitės
WolfHammer 2 savaitės
Nostesi12 savaitės
Wisedocs13 savaitės
asdasdddz16 savaitės
Paslapties K...17 savaitės
Audrius_1720 savaitės
Simbijanas32 savaitės
Karinacraft33 savaitės
Žmogus36 savaitės
Bruksnys40 savaitės
Darexs42 savaitės
Nepas43 savaitės
keistuole45 savaitės
Gizmis47 savaitės
MaFetas60 savaitės
ozzWANTED62 savaitės

Informacija:


OS: Unknown
Naršyklė: Nežinoma
IP: 216.73.216.163
Naujienų: 529
Straipsnių: 235
Temų: 52,590
Postų: 522,550
Postų pask. parą: 0
Shout'ų pask. parą: 0
P.S.C. pask. parą: 0
Nuorodų kataloge: 13

Lankomumo Statistika

Peržiūrų šiandien: 22

Iš viso peržiūrų: 22948724

Prisijungti

REGISTRUOTIS
Nario vardas

Slaptažodis



Pamiršai slaptažodį?
Paprašyk naujo

Aktyvuoti save

Šaukykla

Jei norite rašyti žinutes, turite prisijungti.

N-20
2026 Vas. 6 21:02:05
O mes dar gyvi šypsosi)

WolfHammer
2026 Sau. 25 01:01:35
drovus

Žmogus
2025 Geg. 31 10:05:18
Kas geresnio? šypsosi

Nepas
2025 Bal. 9 17:04:13
drovus

Nepas
2025 Bal. 9 17:04:08
drovus

Šaukyklos archyvas

Apklausa

Ar esate patenkinti lietuviško vertimo kokybe?

Taip!

Taip, bet yra ką taisyti (parašysiu komentaruose)

Ne

Norėdamas balsuoti turite prisijungti.
Archyvas
Reklama 400x60
Pagalbos dėl profilio komentavimo
Forumas | PHP-Fusion, WordPress, Shopify, PHP ir MySQL (PROGRAMAVIMAS) | Expert PHP, MySQL klausimai

Autorius: Enzo Peržiūrų: 1714      Spausdinti temą
2008 Sau. 22 17:01:57          1 žinutė iš 7
Spausdinti pranešimą
Taigi pasidariau savo saite, kad vietoj user_id būtų user_name profile.php?lookup=nick Ir iškilo tokia problema. Pavyzdžiui pakomentuoju kito nario profilyje ir visuose automatiškai tas pats komentaras atsiranda visuose saito profiliuose. Galbūt žinote kaip galima būtų tai sutvarkyti? Būčiau labai dėkingasšypsosi

FCBarcelona
mes que un club
2008 Sau. 22 17:01:24          2 žinutė iš 7
Spausdinti pranešimą
Rodyk kodą, žiūrėsim.

2008 Sau. 22 17:01:41          3 žinutė iš 7
Spausdinti pranešimą
Va profilio

<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
/*--------------------------------------------+
| Profile Page MOD for PHP-Fusion v6      |
|---------------------------------------------|
| author: UworldIRC - Riadi © 2006            |
| web: http://www.uworldirc.com/              |
| email: riadi@gcinet.org                     |
|---------------------------------------------|
| Released under the terms and conditions of  |
| the GNU General Public License (Version 2)  |
+--------------------------------------------*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."members-profile.php";
include LOCALE.LOCALESET."members-profile-extention.php";
include LOCALE.LOCALESET."user_fields.php";

//profile.php settings
# max items for Threads/Posts/News on the normal profile page 
$profile_index_limit = 5;
# max items for the profile page Threads/Posts/News listing
$profile_list_limit = 20;
# width of the profile
$profile_width = 600;
# include the right side panels, set to true or 1 if you want include the right side
$profile_include_rightside = false;

if  (!isset($group_id))  {
   if ((isset($list)) && ($list != 'threads') && ($list != 'posts') && ($list != 'news')) redirect("index.php");
   if (!isset($list)) $list = "profile";

   $result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_name='$lookup'");
   if (dbrows($result)) $data = dbarray($result);
   else redirect("index.php");

   if ($list == 'profile') {
      echo "<script language='javascript' type='text/javascript'>\n"
      ."function expandcollaps(img, id) {"
      ."var currentstatus = img.src.indexOf('_on') == -1 ? '_on' : '_off';"
      ."var newstatus = currentstatus == '_on' ? '_off' : '_on';"
      ."document.getElementById(id).style.display = newstatus == '_on' ? '' : 'none';"
      ."img.src = img.src.replace(newstatus, currentstatus);"
      ."img.alt = newstatus == '_off' ? img.alt.replace('".$locale['pe207']."', '".$locale['pe206']."') : img.alt.replace('".$locale['pe206']."', '".$locale['pe207']."');"
      ."img.title = newstatus == '_off' ? img.title.replace('".$locale['pe207']."', '".$locale['pe206']."') : img.title.replace('".$locale['pe206']."', '".$locale['pe207']."');"
      ."}"
      ."</script>\n";
   }

   opentable($locale['420']);
   echo "<table align='center' cellpadding='0' cellspacing='0' width='$profile_width' id='profile'>\n<tr>\n<td>\n<br>\n";

   // Start of Profile
   echo "<table cellpadding='0' cellspacing='1' class='tbl-border' width='100%'>\n"
   ."<tr>\n<td align='center' class='tbl1' style='white-space:nowrap;' width='100' valign='top'>\n";
   if ($list == 'profile') {
      echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'><br><br>\n<hr>\n" : "")
      .($data['user_hide_email'] != 1 || iADMIN ? "<button class='button' onclick=\"window.location = 'mailto:".str_replace("@","&#64;",$data['user_email'])."';\" style='margin-bottom:1px;width:100px;' title='".str_replace("@","&#64;",$data['user_email'])."'>".$locale['u051']."</button><br>\n" : "")
      .($data['user_web'] ? "<button class='button' onclick=\"window.open('".(!strstr($data['user_web'], "http://") ? "http://" : "").$data['user_web']."');\" style='margin-bottom:1px;width:100px;' title='".(!strstr($data['user_web'], "http://") ? "http://" : "").$data['user_web']."'>".$locale['u052']."</button><br>\n" : "")
      .(!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id'] ? "<button class='button' onclick=\"window.location = 'messages.php?msg_send=".$data['user_id']."';\" style='margin-bottom:1px;width:100px;' title='".$locale['u060']."'>".$locale['u053']."</button><br>\n" : "")
      .($data['user_aim'] || $data['user_icq'] || $data['user_msn'] || $data['user_yahoo'] ? "<br><hr>\n" : "")
      .($data['user_aim'] ? "<button class='button' onclick=\"alert('".$data['user_aim']."');\" style='margin-bottom:1px;width:100px;' title='".$data['user_aim']."'>".$locale['pe040']."</button><br>\n" : "")
      .($data['user_icq'] ? "<button class='button' onclick=\"alert('".$data['user_icq']."');\" style='margin-bottom:1px;width:100px;' title='".$data['user_icq']."'>".$locale['pe041']."</button><br>\n" : "")
      .($data['user_msn'] ? "<button class='button' onclick=\"alert('".$data['user_msn']."');\" style='margin-bottom:1px;width:100px;' title='".$data['user_msn']."'>".$locale['pe042']."</button><br>\n" : "")
      .($data['user_yahoo'] ? "<button class='button' onclick=\"alert('".$data['user_yahoo']."');\" style='margin-bottom:1px;width:100px;' title='".$data['user_yahoo']."'>".$locale['pe043']."</button><br>\n" : "")
      .(iSUPERADMIN ? "<br>\n<hr>\n<button class='button' onclick=\"alert('".$data['user_ip']."');\" style='margin-bottom:1px;width:100px;' title='".$data['user_ip']."'>".$locale['pe044']."</button><br>\n" : "");
   } else {
      echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : "&nbsp;");
   }
   echo "</td>\n<td class='tbl1' style='white-space:nowrap;' valign='top'>\n"
   ."<strong>".$data['user_name']."</strong><br>\n"
   ."<span style='float:left;'>";
   if ($data['user_level'] == 103) $color = "CC0000";
   elseif ($data['user_level'] == 102) $color = "006600";
   else $color = "006600";
   echo "<font color='#$color'>".getuserlevel($data['user_level'])."</font>";
   echo "</span>\n<span style='float:right;'>";
   $lvisit = time() - $data['user_lastvisit'];
   if ($lvisit < 60) echo "<span style='color:#006600;font-weight:normal;'>".$locale['pe000']."</span>";
   elseif ($lvisit < 300) echo "<span style='color:#006600;font-weight:normal;'>".$locale['pe001']."</span>";
   else echo "<span style='color:#AA0000;font-weight:normal;'>".$locale['pe002']."</span>";
   echo "</span>\n"
   ."<br style='clear:both;'><br>\n";
   if ($list == 'profile') {
      echo "<hr>\n<table cellpadding='0' cellspacing='0' width='100%'>\n"
      ."<tr><td class='small' width='30%'>".$locale['u009']."</td><td class='small2'>".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td></tr>\n"
      ."<tr><td class='small' width='30%'>".$locale['u010']."</td><td class='small2'>";
      if ($data['user_birthdate'] != "0000-00-00") {
         $months = explode("|", $locale['months']);
         $user_birthdate = explode("-", $data['user_birthdate']);
         echo $months[number_format($user_birthdate['1'])]." ".number_format($user_birthdate['2'])." ".$user_birthdate['0'];
      } else {
         echo $locale['u048'];
      }
      echo "</td>\n</tr>\n"
      ."</table>\n<br>\n"
      ."<hr>\n<table cellpadding='0' cellspacing='0' width='100%'>\n"
      ."<tr><td class='small' width='30%'>".$locale['u040']."</td><td class='small2'>".showdate("longdate", $data['user_joined'])."</td></tr>\n"
      ."<tr><td class='small' width='30%'>".$locale['u044']."</td><td class='small2'>".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td></tr>\n"
      ."<tr><td class='small' width='30%'>".$locale['u041']."</td><td class='small2'>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</td></tr>\n"
      ."<tr><td class='small' width='30%'>".$locale['u042']."</td><td class='small2'>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</td></tr>\n"
      ."<tr><td class='small' width='30%'>".$locale['u043']."</td><td class='small2'>".number_format($data['user_posts'])."</td></tr>\n"
      ."</table>\n<br>\n";
      if ($data['user_groups']) {
         echo "<hr>\n<table cellpadding='0' cellspacing='0' width='100%'>\n"
         ."<tr><td class='small' width='30%' valign='top'>".$locale['423'].":</td>"
         ."<td>";
         $user_groups = (strpos($data['user_groups'], ".") == 0 ? explode(".", substr($data['user_groups'], 1)) : explode(".", $data['user_groups']));
         for ($i = 0;$i < count($user_groups);$i++) {
            echo "<a class='small2' href='".FUSION_SELF."?group_id=".$user_groups[$i]."'><strong>".getgroupname($user_groups[$i])."</strong></a>";
            if ($i != (count($user_groups)-1)) { echo ","; }
         }
         echo "</td></tr>\n"
         ."</table>\n<br>\n";
      }   
   } else {
      echo "<hr>\n"
      .($data['user_hide_email'] != 1 || iADMIN ? "<button class='button' onclick=\"window.location = 'mailto:".str_replace("@","&#64;",$data['user_email'])."';\" style='width:100px;' title='".str_replace("@","&#64;",$data['user_email'])."'>".$locale['u051']."</button>&nbsp;\n" : "")
      .($data['user_web'] ? "<button class='button' onclick=\"window.open('".(!strstr($data['user_web'], "http://") ? "http://" : "").$data['user_web']."');\" style='width:100px;' title='".(!strstr($data['user_web'], "http://") ? "http://" : "").$data['user_web']."'>".$locale['u052']."</button>&nbsp;\n" : "")
      .(!isset($userdata['user_id']) || $data['user_id'] != $userdata['user_id'] ? "<button class='button' onclick=\"window.location = 'messages.php?msg_send=".$data['user_id']."';\" style='width:100px;' title='".$locale['u060']."'>".$locale['u053']."</button>&nbsp;\n" : "")
      .(iSUPERADMIN ? "<button class='button' onclick=\"alert('".$data['user_ip']."');\" style='width:100px;' title='".$data['user_ip']."'>".$locale['pe044']."</button><br>\n" : "");
   }
   echo "</td>\n</tr>\n</table>\n<br>\n";
   // End of Profile
   
   // Start of Threads/Posts/News listing
   $limit = $list == 'profile' ? $profile_index_limit : $profile_list_limit;
   if (!isset($rowstart) || !isNum($rowstart) || $list == 'profile') $rowstart = 0;

   // Forum Threads listing
   if (($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 "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n"
      ."<thead><tr><td class='forum-caption' colspan='4'><span style='float:left;'><strong>".$locale['pe100'].$data['user_name']."</strong></span>".($list == 'profile' ? "<span style='float:right;'><img onclick=\"expandcollaps(this, 'forum_threads')\" alt='".$alttitle.$data['user_name']."' src='".THEME."images/panel_".($numrows == 0 ? 'on' : 'off').".gif' title='".$alttitle.$data['user_name']."'></span>" : "")."</td></tr></thead>\n"
      ."<tbody id='forum_threads' style='margin:0;padding0;".($numrows == 0 ? "display:none;" : "")."'>\n"
      ."<tr><td class='tbl2' width='35%'><strong>".$locale['pe103']."</strong></td><td class='tbl2' width='45%'><strong>".$locale['pe104']."</strong></td><td align='center' class='tbl2' width='10%'><strong>".$locale['pe105']."</strong></td><td align='center' class='tbl2' width='10%'><strong>".$locale['pe106']."</strong></td></tr>\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)."&amp;" : "");
            echo "<tr>"
            ."<td class='tbl1'>".trimlink($row['forum_name'], 30)."</td>"
            ."<td class='tbl1'><a style='font-weight:normal;' href='".FORUM."viewthread.php?forum_id=".$row['forum_id']."&amp;thread_id=".$row['thread_id']."' title='".$row['thread_subject']."'>".trimlink($row['thread_subject'], 30)."</a></td>"
            ."<td align='center' class='tbl1'><span class='small2'>".$row['thread_views']."</span></td>"
            ."<td align='center' class='tbl1'><span class='small2'>".ceil($replies-1)."</span></td>"
            ."</tr>\n";
         }
         if (($numrows > $limit) && ($list == 'profile')) echo "<tr><td align='center' class='tbl2' colspan='4'><a href='".FUSION_SELF."?lookup=$lookup&amp;list=threads'><strong>".$locale['pe112']."</strong></a></td></tr>";
         elseif ($numrows > $limit) $pagenav = makePageNav($rowstart,$limit,$numrows,3,FUSION_SELF."?lookup=$lookup&amp;list=threads&amp;");
      } else {
         echo "<tr><td align='center' class='tbl1' colspan='4'><span class='small'><strong>".$data['user_name']."</strong> ".$locale['pe109']."</span></td></tr>";
      }
      echo "</tbody>\n</table>\n<br>\n";
      if ($list != 'profile') echo "<table cellpadding='0' cellspacing='0' width='100%'><tr><td align='left'><a href='".FUSION_SELF."?lookup=$lookup'>".$locale['pe113']."</a></td><td align='right'>".$pagenav."</td></tr></table>\n<br>\n";
   }
   // Forum Posts listing
   if (($list == 'profile') || ($list == 'posts')) {
      $pagenav = false;
      $result = dbquery(
         "SELECT tp.*, tf.* FROM ".$db_prefix."posts tp
         INNER JOIN ".$db_prefix."forums tf USING(forum_id)
         WHERE ".groupaccess('forum_access')." AND post_author='$lookup' LIMIT 100"
      );
      $numrows = dbrows($result);
      $alttitle = $numrows == 0 ? $locale['pe202'] : $locale['pe203'];   
      echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n"
      ."<thead><tr><td class='forum-caption' colspan='3'><span style='float:left;'><strong>".$locale['pe101'].$data['user_name']."</strong></span>".($list == 'profile' ? "<span style='float:right;'><img onclick=\"expandcollaps(this, 'forum_posts')\" alt='".$alttitle.$data['user_name']."' src='".THEME."images/panel_".($numrows == 0 ? 'on' : 'off').".gif' title='".$alttitle.$data['user_name']."'></span>" : "")."</td></tr></thead>\n"
      ."<tbody id='forum_posts' style='margin:0;padding0;".($numrows == 0 ? "display:none;" : "")."'>\n"
      ."<tr><td class='tbl2' width='30%'><strong>".$locale['pe103']."</strong></td><td class='tbl2' width='40%'><strong>".$locale['pe107']."</strong></td><td class='tbl2' width='30%' nowrap='nowrap'><strong>".$locale['pe108']."</strong></td></tr>\n";
      if ($numrows != 0) {
         $result = dbquery(
            "SELECT tp.*, tf.* FROM ".$db_prefix."posts tp
            INNER JOIN ".$db_prefix."forums tf USING(forum_id)
            WHERE ".groupaccess('forum_access')." AND post_author='".$data['user_id']."'
            ORDER BY post_datestamp DESC LIMIT $rowstart,$limit"
         );
         while ($row = dbarray($result)) {
            $replies = dbcount("(thread_id)", "posts", "thread_id='".$row['thread_id']."'");
            $rstart = ($replies > 20 ? "rowstart=".((ceil($replies / 20)-1)*20)."&amp;" : "");
            echo "<tr>"
            ."<td class='tbl1'>".trimlink($row['forum_name'], 30)."</td>"
            ."<td class='tbl1'><a style='font-weight:normal;' href='".FORUM."viewthread.php?".$rstart."forum_id=".$row['forum_id']."&amp;thread_id=".$row['thread_id']."&amp;pid=".$row['post_id']."#post_".$row['post_id']."' title='".$row['post_subject']."'>".trimlink($row['post_subject'], 30)."</a></td>"
            ."<td align='center' class='tbl1'><span class='small2'>".showdate("forumdate", $row['post_datestamp'])."</span></td>"
            ."</tr>\n";
         }
         if (($numrows > $limit) && ($list == 'profile')) echo "<tr><td align='center' class='tbl2' colspan='3'><a href='".FUSION_SELF."?lookup=$lookup&amp;list=posts'><strong>".$locale['pe112']."</strong></a></td></tr>\n";
         elseif ($numrows > $limit) $pagenav = makePageNav($rowstart,$limit,$numrows,3,FUSION_SELF."?lookup=$lookup&amp;list=posts&amp;");
      } else {
         echo "<tr><td align='center' class='tbl1' colspan='3'><span class='small'><strong>".$data['user_name']."</strong> ".$locale['pe110']."</span></td></tr>\n";
      }
      echo "</tbody>\n</table>\n<br>\n";
      if ($list != 'profile') echo "<table cellpadding='0' cellspacing='0' width='100%'><tr><td align='left'><a href='".FUSION_SELF."?lookup=$lookup'>".$locale['pe113']."</a></td><td align='right'>".$pagenav."</td></tr></table>\n<br>\n";
   }
   // News Items listing
   if (($list == 'profile') || ($list == 'news')) {
      $pagenav = false;
      $result = dbquery(
         "SELECT * FROM ".$db_prefix."news
         WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_name='".$data['user_id']."'
         LIMIT 100"
      );
      $numrows = dbrows($result);
      $alttitle = $numrows == 0 ? $locale['pe204'] : $locale['pe205'];   
      echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n"
      ."<thead><tr><td class='forum-caption' colspan='2'><span style='float:left;'><strong>".$locale['pe102'].$data['user_name']."</strong></span>".($list == 'profile' ? "<span style='float:right;'><img onclick=\"expandcollaps(this, 'news_items')\" alt='".$alttitle.$data['user_name']."' src='".THEME."images/panel_".($numrows == 0 ? 'on' : 'off').".gif' title='".$alttitle.$data['user_name']."'></span>" : "")."</td></tr></thead>\n"
      ."<tbody id='news_items' style='margin:0;padding0;".($numrows == 0 ? "display:none;" : "")."'>\n"
      ."<tr><td class='tbl2' width='70%'><strong>".$locale['pe107']."</strong></td><td class='tbl2' width='30%' nowrap='nowrap'><strong>".$locale['pe108']."</strong></td></tr>\n";
      if ($numrows != 0) {   
         $result = dbquery(
            "SELECT * FROM ".$db_prefix."news
            WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_name='".$data['user_id']."'
            ORDER BY news_datestamp DESC LIMIT $rowstart,$limit"
         );
         while ($row = dbarray($result)) {
            echo "<tr>"
            ."<td class='tbl1'><a style='font-weight:normal;' href='news.php?readmore=".$row['news_id']."'>".trimlink($row['news_subject'], 50)."</a></td>"
            ."<td align='center' class='tbl1'><span class='small2'>".showdate("forumdate", $row['news_datestamp'])."</span></td>"
            ."</tr>\n";
         }
         if (($numrows > $limit) && ($list == 'profile')) echo "<tr><td align='center' class='tbl2' colspan='2'><a href='".FUSION_SELF."?lookup=$lookup&amp;list=news'><strong>".$locale['pe112']."</strong></a></td></tr>";
         elseif ($numrows > $limit) $pagenav = makePageNav($rowstart,$limit,$numrows,3,FUSION_SELF."?lookup=$lookup&amp;list=news&amp;");
      } else {
         echo "<tr><td align='center' class='tbl1' colspan='2'><span class='small'><strong>".$data['user_name']."</strong> ".$locale['pe111']."</span></td></tr>";
      }
      echo "</tbody>\n</table>\n<br>\n";
      if ($list != 'profile') echo "<table cellpadding='0' cellspacing='0' width='100%'><tr><td align='left'><a href='".FUSION_SELF."?lookup=$lookup'>".$locale['pe113']."</a></td><td align='right'>".$pagenav."</td></tr></table>\n<br>\n";
   }      
   echo "</td>\n</tr>\n</table>\n";
   closetable();
      
} elseif ((isset($group_id)) && (!isset($lookup)) && (isNum($group_id))) {
   $profile_include_rightside = true;
   $result = dbquery("SELECT * FROM ".$db_prefix."user_groups WHERE group_id='$group_id'");
   if (dbrows($result)) {
      $data = dbarray($result);
      $result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_groups REGEXP('^\\\.{$group_id}$|\\\.{$group_id}\\\.|\\\.{$group_id}$') ORDER BY user_level DESC, user_name");
      opentable($locale['410']);
      echo "<table align='center' cellpadding='0' cellspacing='0' width='100%' id='profile'>\n<tr>\n<td>\n<br>\n";
      echo "<table cellpadding='0' cellspacing='1' class='tbl-border' width='100%'>\n"
      ."<tr>\n<td class='tbl1' style='white-space:nowrap;' width='100%'>"
      ."<span style='float:left;'><strong>".$data['group_name']."</strong></span>"
      ."<span class='small2' style='float:right;'>(".sprintf((dbrows($result)==1?$locale['411']:$locale['412']), dbrows($result)).")</span><br><br><hr>\n"
      ."<table cellpadding='0' cellspacing='0' width='100%'>\n";
      while ($data = dbarray($result)) {
         echo "<tr><td width='75%'><a href='".FUSION_SELF."?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>"
         ."<td align='center' nowrap='nowrap'>".getuserlevel($data['user_level'])."</td></tr>\n";
      }
      echo "</table>\n";
      echo "</td>\n</tr>\n</table>\n<br>\n";
      echo "</td>\n</tr>\n</table>\n";
      closetable();
   } else {
      fallback(BASEDIR."index.php");
   }
} else fallback("index.php");

include INCLUDES."comments_include.php";
showcomments("U","users","user_name",$lookup);

if ($profile_include_rightside) require_once "side_right.php";
else echo "</td>\n";
require_once "footer.php";
?>




FCBarcelona
mes que un club
2008 Sau. 22 19:01:30          4 žinutė iš 7
Spausdinti pranešimą
object'as yra tik INT galimas, o user_name yra varchar'as. Commentų table objektui leisk pvz. 50 ženklų varcharą.

BR#1, Most Wanted
2008 Sau. 22 19:01:03          5 žinutė iš 7
Spausdinti pranešimą
ozzWANTED parašė:
object'as yra tik INT galimas, o user_name yra varchar'as. Commentų table objektui leisk pvz. 50 ženklų varcharą.


Gal galėtum aiškiau paaiškint arba parodyt bo nelabai suprantušypsosi

FCBarcelona
mes que un club
2008 Sau. 22 20:01:01          6 žinutė iš 7
Spausdinti pranešimą
PMA -> Table structure -> edit row -> Change... [INT] -> [Varchar] -> Lenght nustatai 50, singed/unsigned - tuščią palieki.

BR#1, Most Wanted
2008 Sau. 23 17:01:07          7 žinutė iš 7
Spausdinti pranešimą
Taip ir nustatyta tačiau nepadedagalvoja

FCBarcelona
mes que un club
Peršokti į forumą: