Navigacija

Vartotojų tinkle

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

Registruoti nariai: 25,952
Naujausias narys: tomeem

Naujausi straipsniai

Paskutiniai nariai

asirija 6 dienos
tomeem 2 savaitės
Reikalas 3 savaitės
weberiz 6 savaitės
mRokass 8 savaitės
kartoonas 9 savaitės
iaescortsmap 9 savaitės
ozzWANTED10 savaitės
grunskiz12 savaitės
Bruksnys12 savaitės
illusion13 savaitės
ordo14 savaitės
Jurgaila14 savaitės
originalcs1614 savaitės
Rytis15 savaitės
halis16 savaitės
junkus19 savaitės
morlis19 savaitės
Majakas21 savaitės
andsoft22 savaitės

Informacija:


OS: Unknown
Naršyklė: Nežinoma
IP: 3.144.86.134
Naujienų: 529
Straipsnių: 235
Temų: 52,585
Postų: 522,523
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.

ozzWANTED
2024 Sau. 17 01:01:00
Desperatiškus komentarus šaukykloje su accountu po mėnesio prasibuvimo, ištryniau. Pasaulis ir taip juodas. Įjungiam šviesą, prašviesės. šypsosi

Majakas
2023 Gru. 10 19:12:39
Negaliu patikėti jog žinutės/pranešimai visi yra nuo 2008 m akinanti šypsen

Žmogus
2023 Rugs. 7 21:09:14
O gal BloodKiller pasijungs?

Apocal
2023 Rugs. 2 18:09:23
Nu davai nuveikiam kažką akinanti šypsen. Prisijungti kada visi čia akinanti šypsen.

Apocal
2023 Rugs. 2 00:09:18
Šiaip atėjau pažiūrėti ar dar lopas nesby yra ar koks ten buvo.

Š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ų: 1250      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ą: