Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Is kur galeciau gaut?

Parašė mariuxxxx· 2009 Rugp. 1 13:08:04
#1



Is kur galeciau gaut toki ivertinimo moda randu kazkoki bet kazkoks netoks:D

Parašė WyPuk· 2009 Rugp. 1 13:08:59
#2

Siųskis

Parašė mariuxxxx· 2009 Rugp. 1 13:08:04
#3

pl pl mano profile php redaguotas man reik tik sito:(

Redagavo mariuxxxx· 2009 Rugp. 1 13:08:38

Parašė mariuxxxx· 2009 Rugp. 1 13:08:51
#4

tai gal kas galetu imesti?:s

Parašė ChecK· 2009 Rugp. 1 13:08:29
#5

Siųskis

Parašė mariuxxxx· 2009 Rugp. 1 14:08:21
#6

raso table_no ....:(

Parašė WyPuk· 2009 Rugp. 1 14:08:03
#7

Sukurk lenteles PME
CREATE TABLE `prefix_user_ratings` (
`rated_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
`rate_user` BIGINT( 20 ) NOT NULL ,
`rate_subject` BIGINT( 20 ) NOT NULL ,
`rate_opt` ENUM( '1', '2', '3', '4', '5', '6', '7', '8', '9', '10' ) NOT NULL ,
`rate_date` BIGINT( 20 ) NOT NULL ,
`rate_ip` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (`rated_id`)
) TYPE = innodb;



Parašė mariuxxxx· 2009 Rugp. 1 16:08:54
#8

kur ta lentele det?:(

Parašė adulis· 2009 Rugp. 1 16:08:28
#9

Į phpmyadmin. Pasirinksi SQL ir ten įdėsi tą kodą ir sukurs.

Parašė mariuxxxx· 2009 Rugp. 1 17:08:23
#10

raso: #1046 - No database selected

Parašė TaduXxX· 2009 Rugp. 1 17:08:07
#11

mariuxxxx parašė:
raso: #1046 - No database selected


Pasikeisk prefix

Parašė mariuxxxx· 2009 Rugp. 1 17:08:00
#12

TaduXxX parašė:
mariuxxxx parašė:
raso: #1046 - No database selected


Pasikeisk prefix



Kaip ji pakeist as zalias?:D
nu kaip gali padet?:s

Redagavo mariuxxxx· 2009 Rugp. 1 17:08:43

Parašė iStyle· 2009 Rugp. 1 17:08:29
#13

Kaip įeini į phpmyadmin,tada pasirenki savo duomenų bazę mėlyname fone: Tarkim,ten yra fusion_,tai jį ir spaudi,poto spaudi sql,ir įvedi:

CREATE TABLE `fusion_user_ratings` (
`rated_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
`rate_user` BIGINT( 20 ) NOT NULL ,
`rate_subject` BIGINT( 20 ) NOT NULL ,
`rate_opt` ENUM( '1', '2', '3', '4', '5', '6', '7', '8', '9', '10' ) NOT NULL ,
`rate_date` BIGINT( 20 ) NOT NULL ,
`rate_ip` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (`rated_id`)
) TYPE = innodb;



Parašė mariuxxxx· 2009 Rugp. 1 17:08:20
#14

pl paziuresiu?|

Parašė mariuxxxx· 2009 Rugp. 1 17:08:57
#15

Kandžiulnikas parašė:
Kaip įeini į phpmyadmin,tada pasirenki savo duomenų bazę mėlyname fone: Tarkim,ten yra fusion_,tai jį ir spaudi,poto spaudi sql,ir įvedi:

CREATE TABLE `fusion_user_ratings` (
`rated_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
`rate_user` BIGINT( 20 ) NOT NULL ,
`rate_subject` BIGINT( 20 ) NOT NULL ,
`rate_opt` ENUM( '1', '2', '3', '4', '5', '6', '7', '8', '9', '10' ) NOT NULL ,
`rate_date` BIGINT( 20 ) NOT NULL ,
`rate_ip` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (`rated_id`)
) TYPE = innodb;





aciu tau issamiai paaiskinai;)

Parašė iStyle· 2009 Rugp. 1 17:08:26
#16

Prašom :)

Parašė mariuxxxx· 2009 Rugp. 1 18:08:30
#17

Daba susiduriau su kita klaida ziurekit noriu padaryt profili toki dalyka viska padarau bet ten dar buvo sitas profile.php 1 scriptas o mano anntras as noriu ta vertinima idet i savo profile.php paziurekit kur klaida apatiniam!


Is Sito 1 bandziau perkelt i 2 raudonai paryskintus nes man nevertina nariu!:


<?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
+----------------------------------------------------*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."members-profile.php";
include LOCALE.LOCALESET."user_fields.php";
if (!isset($lookup) || !isNum($lookup)) {
   fallback("index.php");
} else {
   $result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='$lookup'");
   if (dbrows($result)) { $data = dbarray($result); } else { redirect("index.php"); }
}
if (!isset($group_id) && !isset($_GET['view'])) {
   if (isset($_POST['rate'])) {
      if (isNum($_POST['rating']) && !dbcount("(*)","user_ratings","rate_user = '".$userdata['user_id']."' AND rate_subject = '$lookup'") && iMEMBER) {
         $result = dbquery("INSERT INTO ".$db_prefix."user_ratings (rate_user,rate_subject,rate_opt,rate_date,rate_ip) VALUES ('".$userdata['user_id']."','$lookup','".$_POST['rating']."','".time()."','".$_SERVER['REMOTE_ADDR']."');");
         if ($result) redirect(FUSION_SELF."?lookup=$lookup");
      } else {
         fallback("http://www.google.lt/");
      }
   }

   opentable($locale['420']);
   echo "<center><a href='".FUSION_SELF."?lookup=$lookup&view=last_comments'>Paskutiniai komentarai</a> | <a href='".FUSION_SELF."?lookup=$lookup&view=last_posts'>Paskutin&#235;s &#254;inut&#235;s forume</a> | <a href='".FUSION_SELF."?lookup=$lookup&view=last_shouts'>Paskutiniai prane&#240;imai &#240;aukykloje</a></center>\n";
   echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>
<tr>
<td colspan='3'>
<table align='center' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td class='tbl2'><b>".$data['user_name']."</b>
</td>
<td align='right' class='tbl2'>".getuserlevel($data['user_level'])."</td>
</tr>
</table>
</td>
<tr>
<td align='center' width='160' rowspan='5' class='tbl2'>\n";
   $v = 0;
   $result = dbquery("SELECT * FROM ".$db_prefix."user_ratings WHERE rate_subject = '$lookup'");
   while ($datax = dbarray($result)) $v = $v+$datax['rate_opt'];
   $res = $v;
   $vert = (dbrows($result) != 0 ? round($res/dbrows($result),2) : "N&#235;ra");
   $rdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."user_ratings WHERE rate_subject = '$lookup' ORDER BY rate_date DESC LIMIT 1"));
   echo "Vartotojø &#225;vertinimas: $vert<br>\n";
   if (iMEMBER) {
      if (!dbcount("(*)","user_ratings","rate_user = '".$userdata['user_id']."' AND rate_subject = '$lookup'")) {
         echo " <form method='post' action='".FUSION_SELF."?lookup=$lookup'>\n<select name='rating' class='textbox'>\n";
         for ($i = 1; $i < 11; $i++) echo "<option value='$i'>$i</option>\n";
         echo "</select> <input name='rate' type='submit' value='Vertinti' class='textbox'>\n</form>\n";
      }
   }

      echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u009']."</b></td>
<td class='tbl1'>".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u010']."</b></td>
<td class='tbl2'>";
      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>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u021']."</b></td>
<td class='tbl1'>".($data['user_aim'] ? $data['user_aim'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u011']."</b></td>
<td class='tbl2'>".($data['user_icq'] ? $data['user_icq'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u012']."</b></td>
<td class='tbl1'>".($data['user_msn'] ? $data['user_msn'] : $locale['u048'])."</td>
</tr>
<tr>
<td align='center' class='tbl1'>\n";
      if ($data['user_hide_email'] != "1" || iADMIN) echo "[<a href='mailto:".str_replace("@","&#64;",$data['user_email'])."' title='".str_replace("@","&#64;",$data['user_email'])."'>".$locale['u051']."</a>]\n";
      if ($data['user_web']) {
         $urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
         echo "[<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$locale['u052']."</a>]\n";
      }
      if (iMEMBER && $data['user_id'] != $userdata['user_id']) echo "[<a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>".$locale['u053']."</a>]\n";
      echo "</td>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u013']."</b></td>
<td class='tbl2'>".($data['user_yahoo'] ? $data['user_yahoo'] : $locale['u048'])."</td>
</tr>
</table>\n";

      tablebreak();

      echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>
<tr>
<td class='tbl2' colspan='2'><b>".$locale['422']."</b></td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u040']."</b></td>
<td class='tbl1'>".showdate("longdate", $data['user_joined'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u044']."</b></td>
<td class='tbl2'>".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u041']."</b></td>
<td class='tbl1'>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u042']."</b></td>
<td class='tbl2'>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u043']."</b></td>
<td class='tbl1'>".number_format($data['user_posts'])."</td>
</tr>\n";
   $c = dbcount("(comment_id)","comments","comment_name = '".$data['user_id']."'");
   $s = dbcount("(shout_id)","shoutbox","shout_name = '".$data['user_id']."'");
   $pvid = $data['user_posts'] != 0 ? round($data['user_posts']/((time()-$data['user_joined'])/86400),2) : 0;
   $cvid = $c != 0 ? round($c/((time()-$data['user_joined'])/86400),2) : 0;
   $svid = $s != 0 ? round($s/((time()-$data['user_joined'])/86400),2) : 0;
   echo "<tr>
  <td width='1%' class='tbl1' style='white-space:nowrap'><b>&#222;inu&#232;iø per par&#224; forume:</b></td>
  <td class='tbl1'>".($pvid > $data['user_posts'] ? $data['user_posts'] : $pvid)."</td>
</tr>
<tr>
  <td width='1%' class='tbl1' style='white-space:nowrap'><b>Komentarø per par&#224;:</b></td>
  <td class='tbl1'>".($cvid > $c ? $c : $cvid)."</td>
</tr>
<tr>
  <td width='1%' class='tbl1' style='white-space:nowrap'><b>&#222;inu&#232;iø &#240;aukykloje per par&#224;:</b></td>
  <td class='tbl1'>".($svid > $s ? $s : $svid)."</td>
</tr>
</table>\n";
      if ($data['user_groups']) {
         tablebreak();
         echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>\n";
         echo "<tr>\n<td class='tbl2'><b>".$locale['423']."</b></td>\n\n</tr>\n<tr>\n<td class='tbl1'>\n";
         $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 href='".FUSION_SELF."?group_id=".$user_groups[$i]."'>".getgroupname($user_groups[$i])."</a>";
            if ($i != (count($user_groups)-1)) { echo ",\n"; } else { echo "\n"; }
         }
         echo "</td>\n</tr>\n</table>\n";
      }
   closetable();
} else {
   if (isset($group_id)) {
   if (!isNum($group_id)) fallback("index.php");
   $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='1' width='100%' class='tbl-border'>
<tr>
<td align='center' colspan='2' class='tbl1'><b>".$data['group_name']."</b> (".sprintf((dbrows($result)==1?$locale['411']:$locale['412']), dbrows($result)).")</td>
</tr>
<tr>
<td class='tbl2'><b>".$locale['401']."</b></td>
<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['402']."</b></td>
</tr>\n";
      while ($data = dbarray($result)) {
         $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
         echo "<tr>\n<td class='$cell_color'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>\n";
         echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>\n</tr>";
      }
      echo "</table>\n";
   } else {
      fallback(BASEDIR."index.php");
   }
   }
}
if (isset($_GET['view'])) {
   $view = $_GET['view'];
   if ($view == "last_comments") {
      opentable("Paskutiniai komentarai");
      $result = dbquery("SELECT * FROM ".$db_prefix."comments WHERE comment_name = '".$data['user_id']."' ORDER BY comment_datestamp DESC LIMIT 0,10");
      if (dbrows($result)) {
         while ($datac = dbarray($result)) {
            if ($datac['comment_type'] == "U") {
                  $place = BASEDIR."profile.php?lookup=".$datac['comment_item_id'];
            } elseif ($datac['comment_type'] == "N") {
               $place = BASEDIR."news.php?readmore=".$datac['comment_item_id'];
            } elseif ($datac['comment_type'] == "A") {
               $place = BASEDIR."readarticle.php?article_id=".$datac['comment_item_id'];
            } elseif ($datac['comment_type'] == "P") {
               $place = BASEDIR."photogallery.php?photo_id=".$datac['comment_item_id'];
            }
            echo "<table width='100%' style='border:1px solid #000;'>
<tr>
  <td><img src='".THEME."images/bullet.gif'> ".ucfirst(showdate("longdate",$datac['comment_datestamp']))." - <a href='$place'>Eiti &#225; komentaro viet&#224;</a>".(iADMIN ? " - <b>IP:</b> ".$datac['comment_ip']."\n" : "")."
</tr>
<tr>
  <td>".($datac['comment_smileys'] == 1 ? parseubb(parsesmileys($datac['comment_message'])) : parseubb($datac['comment_message']))."</td>
</tr>
".(iADMIN ? "<tr>
  <td><a href='".ADMIN."comments.php$aidlink&step=edit&comment_id=".$datac['comment_id']."&ctype=".$datac['comment_type']."&cid=".$datac['comment_item_id']."'>Taisyti</a> - <a href='".ADMIN."comments.php$aidlink&step=delete&comment_id=".$datac['comment_id']."&ctype=".$datac['comment_type']."&cid=".$datac['comment_item_id']."'>Trinti</a></td>
</tr>" : "")."
</table><br>\n";
         }
      } else {
         echo "<center>&#208;is vartotojas komentarø dar nepara&#240;&#235;</center>\n";
      }
      closetable();
   } elseif ($view == "last_posts") {
      $result = dbquery("SELECT * FROM ".$db_prefix."posts WHERE post_author = '".$data['user_id']."' ORDER BY post_datestamp DESC LIMIT 0,5");
      opentable("Paskutiniai forumo prane&#240;imai");
      if (dbrows($result)) {
         while ($pdata = dbarray($result)) {
            echo "<table width='100%' style='border:1px solid #000;'>
<tr>
  <td><img src='".THEME."images/bullet.gif'> ".ucfirst(showdate("longdate",$pdata['post_datestamp']))." - <a href='".FORUM."viewthread.php?forum_id=".$pdata['forum_id']."&thread_id=".$pdata['thread_id']."&pid=".$pdata['post_id']."#post_".$dpata['post_id']."'>Eiti &#225; &#254;inut&#235;s viet&#224;</a>".(iADMIN ? " - <b>IP:</b> ".$pdata['post_ip']."\n" : "")."</td>
</tr>
<tr>
  <td>".($pdata['post_smileys'] == 1 ? nl2br(parsesmileys(parseubb($pdata['post_message']))) : nl2br(parseubb($pdata['post_message'])))."</td>
</tr>".(iADMIN ? "<tr>
  <td><a href='".FORUM."post.php?action=edit&forum=".$pdata['forum_id']."&thread_id=".$pdata['thread_id']."&post_id=".$pdata['post_id']."'>Taisyti</a></td>
</tr>\n" : "")."</table><br>\n";
         }
      } else {
         echo "<center>&#208;is vartotojas prane&#240;imø forume dar nepara&#240;&#235;</center>\n";
      }
      closetable();
   } elseif ($view == "last_shouts") {
      $result = dbquery("SELECT * FROM ".$db_prefix."shoutbox WHERE shout_name = '".$data['user_id']."' ORDER BY shout_datestamp DESC LIMIT 0,10");
      opentable("Paskutiniai &#240;aukyklos prane&#240;imai");
      if (dbrows($result)) {
         while ($sdata = dbarray($result)) {
            echo "<table width='100%' style='border:1px solid #000;'>
<tr>
  <td><img src='".THEME."images/bullet.gif'> ".ucfirst(showdate("longdate",$sdata['shout_datestamp'])).(iADMIN ? " - <b>IP:</b> ".$sdata['shout_ip']."\n" : "")."</td>
</tr>
<tr>
  <td>".parsesmileys($sdata['shout_message'])."</td>
</tr>".(iADMIN ? "<tr>
  <td><a href='".ADMIN."shoutbox.php$aidlink&action=edit&shout_id=".$sdata['shout_id']."'>Taisyti</a> - <a href='".ADMIN."shoutbox.php$aidlink&action=delete&shout_id=".$sdata['shout_id']."'>Trinti</a></td>
</tr>" : "")."
</table><br>\n";
         }
      } else {
         echo "<center>&#208;is vartotojas &#240;aukykloje &#254;inu&#232;iø dar nepara&#240;&#235;</center>\n";
      }
      closetable();
   }
}
if (isset($_GET['lookup']) && !isset($_GET['view'])) {
   include INCLUDES."comments_include.php";
   showcomments("U","users","user_id",$_GET['lookup'],FUSION_SELF."?lookup=".$_GET['lookup']);
}
require_once "side_right.php";
require_once "footer.php";
?>





Sita reik taisyt!


<?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
+----------------------------------------------------*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."members-profile.php";
include LOCALE.LOCALESET."user_fields.php";
if (!isset($lookup) || !isNum($lookup)) {
   fallback("index.php");
} else {
   $result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='$lookup'");
   if (dbrows($result)) { $data = dbarray($result); } else { redirect("index.php"); }
}
if (!isset($group_id) && !isset($_GET['view'])) {
   if (isset($_POST['rate'])) {
      if (isNum($_POST['rating']) && !dbcount("(*)","user_ratings","rate_user = '".$userdata['user_id']."' AND rate_subject = '$lookup'") && iMEMBER) {
         $result = dbquery("INSERT INTO ".$db_prefix."user_ratings (rate_user,rate_subject,rate_opt,rate_date,rate_ip) VALUES ('".$userdata['user_id']."','$lookup','".$_POST['rating']."','".time()."','".$_SERVER['REMOTE_ADDR']."');");
         if ($result) redirect(FUSION_SELF."?lookup=$lookup");
      } else {
         fallback("http://www.google.lt/");
      }
   }
if (file_exists(LOCALE.LOCALESET."warns.php")) {
   include LOCALE.LOCALESET."warns.php";
} else {
   include LOCALE."English/warns.php";
}

if (!isset($group_id)) {
   if (!isset($lookup) || !isNum($lookup)) fallback("index.php");
   $result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='$lookup'");
   if (dbrows($result)) { $data = dbarray($result); } else { redirect("index.php"); }
   opentable($locale['420']);
   echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>
<tr>
<td colspan='3'>
<table align='center' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td class='tbl2'><b>".$data['user_name']."</b>";

   if ($data['gender'] == 0) {
echo "&nbsp; Lytis: <i>Nenustatyta</i>";
} elseif ($data['gender'] == 1) {
echo "&nbsp; Lytis: <i>Vyras</i>";
} elseif ($data['gender'] == 2) {
echo "&nbsp; Lytis: <i>Moteris</i>";
}

echo "</td>
<td align='right' class='tbl2'>".getuserlevel($data['user_level'])."</td>
</tr>
</table>
</td>
<tr>
<td align='center' width='150' rowspan='5' class='tbl2'>\n";
$v = 0;
   $result = dbquery("SELECT * FROM ".$db_prefix."user_ratings WHERE rate_subject = '$lookup'");
   while ($datax = dbarray($result)) $v = $v+$datax['rate_opt'];
   $res = $v;
   $vert = (dbrows($result) != 0 ? round($res/dbrows($result),2) : "N&#235;ra");
   $rdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."user_ratings WHERE rate_subject = '$lookup' ORDER BY rate_date DESC LIMIT 1"));
   echo "Vartotojø &#225;vertinimas: $vert<br>\n";
   if (iMEMBER) {
      if (!dbcount("(*)","user_ratings","rate_user = '".$userdata['user_id']."' AND rate_subject = '$lookup'")) {
         echo " <form method='post' action='".FUSION_SELF."?lookup=$lookup'>\n<select name='rating' class='textbox'>\n";
         for ($i = 1; $i < 11; $i++) echo "<option value='$i'>$i</option>\n";
         echo "</select> <input name='rate' type='submit' value='Vertinti' class='textbox'>\n</form>\n";
      }
   }
//show warns
      if ($data['user_level'] == 101) {
echo "<img src='".IMAGES."warns/".$data['warnings'].".gif' alt='".$locale['warns_04']." ".$data['warnings']." ".$locale['warns_05']."' title='".$locale['warns_04']." ".$data['warnings']." ".$locale['warns_05']."' border='0' style='padding-bottom:5px;'><br>";
}
//

   echo ($data['user_avatar'] ? "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['u017']."'>" : $locale['u046'])."</td>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u009']."</b></td>
<td class='tbl1'>".($data['user_location'] ? $data['user_location'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u010']."</b></td>
<td class='tbl2'>";
   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>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Skype:</b></td>
<td class='tbl1'>
".($data['user_aim'] ? "
<a href='skype:".$data['user_aim']."?chat'><img src='http://mystatus.skype.com/smallclassic/".$data['user_aim']."' style='border: none;' width='114' height='20' alt='".$data['user_aim']."' /></a>" : $locale['u048'])."
</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u011']."</b></td>
<td class='tbl2'>".($data['user_icq'] ? $data['user_icq'] : $locale['u048'])."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u012']."</b></td>
<a href='one.php?lookup=".$data['user_id']."'><td class='tbl1'>".($data['user_msn'] ? $data['user_msn'] : $locale['u048'])."</a></td></tr>
<tr>
<td align='center' class='tbl1'>\n";
   if ($data['user_hide_email'] != "1" || iADMIN) {
      echo "[<a href='mailto:".str_replace("@","&#64;",$data['user_email'])."' title='".str_replace("@","&#64;",$data['user_email'])."'>".$locale['u051']."</a>]\n";
   }
   if ($data['user_web']) {
      $urlprefix = !strstr($data['user_web'], "http://") ? "http://" : "";
      echo "[<a href='".$urlprefix.$data['user_web']."' title='".$urlprefix.$data['user_web']."' target='_blank'>".$locale['u052']."</a>]\n";
   }
   if (iMEMBER && $data['user_id'] != $userdata['user_id']) {
      echo "[<a href='messages.php?msg_send=".$data['user_id']."' title='".$locale['u060']."'>".$locale['u053']."</a>]\n";
   }
   echo "</td>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u013']."</b></td>
<td class='tbl2'>".($data['user_yahoo'] ? $data['user_yahoo'] : $locale['u048'])."</td>
</tr>
</table>\n";

   //warns start
   if (iADMIN && checkrights("M")) {
   //give warn
   if ($_POST['warn']) {
   $result = dbquery("UPDATE ".$db_prefix."users SET warnings=warnings+1 WHERE user_id='$lookup'");
   redirect(FUSION_SELF."?lookup=$lookup");
   }
   //ban for warns
   if ($_POST['baninti']) {
   $result = dbquery("UPDATE ".$db_prefix."users SET warnings=warnings+1 WHERE user_id='$lookup'");
   $result = dbquery("UPDATE ".$db_prefix."users SET user_status='1' WHERE user_id='$lookup'");
   redirect(FUSION_SELF."?lookup=$lookup");
   }
   //unwarn
   if ($_POST['unwarn']) {
   $result = dbquery("UPDATE ".$db_prefix."users SET warnings=warnings-1 WHERE user_id='$lookup'");
   redirect(FUSION_SELF."?lookup=$lookup");
   }
   //delete user
   if ($_POST['delete']) {
      $result = dbquery("DELETE FROM ".$db_prefix."users WHERE user_id='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."articles WHERE article_name='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."comments WHERE comment_name='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."messages WHERE message_to='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."messages WHERE message_from='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."news WHERE news_name='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."poll_votes WHERE vote_user='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."ratings WHERE rating_user='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."shoutbox WHERE shout_name='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."threads WHERE thread_author='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."posts WHERE post_author='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."thread_notify WHERE notify_user='$lookup'");
      $result = dbquery("DELETE FROM ".$db_prefix."user_ratings WHERE rate_user='$lookup'");
   redirect(FUSION_SELF."?lookup=$lookup");
   }
   //ban
      if ($_POST['ban']) {
   $result = dbquery("UPDATE ".$db_prefix."users SET user_status=1 WHERE user_id='$lookup'");
   redirect(FUSION_SELF."?lookup=$lookup");
   }
   //unban
         if ($_POST['unban']) {
   $result = dbquery("UPDATE ".$db_prefix."users SET user_status=0 WHERE user_id='$lookup'");
   redirect(FUSION_SELF."?lookup=$lookup");
   }
   //form
   if ($data['user_status'] == 1) { $act = unban; $title = $locale['warns_02']; } else { $act = ban; $title = $locale['warns_01']; }
   tablebreak();
   echo "<table cellpadding='0' cellspadding='0' align='center' width='400' style='border: 1px solid #ccc;'><tr>";
   
   echo "<td class='tbl1'><form method='post' action='".ADMIN."members.php".$aidlink."&step=edit&user_id=$lookup'><input class='button' value='".$locale['warns_10']."' type='submit' name='edit' title='".$locale['warns_10']."'></form></td>";
   echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup'><input class='button' value='$title' type='submit' name='$act' title='$title ".$locale['warns_09']."'  OnClick=\"if (confirm('".$locale['warns_06']."')) return true; else return false;\"></form></td>";
   echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup'><input class='button' value='".$locale['warns_03']."' type='submit' name='delete' title='".$locale['warns_03']."' OnClick=\"if (confirm('".$locale['warns_06']."')) return true; else return false;\"></form></td>";
   
   
   
         //for admins
      if ($data['user_level'] == 101 && $data['user_status'] != 1) {
if ($data['warnings'] <= 3) {
echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup'>";
echo "<input type='submit' name='warn' value='".$locale['warns_07']."' class='button'>";
echo "</form></td>";
} else {
echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup'>";
echo "<input type='submit' name='baninti' value='".$locale['warns_01']."' class='button'>";
echo "</form></td>";
}
if ($data['warnings'] != 0) {
echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup'>";
echo "<input type='submit' name='unwarn' value='".$locale['warns_08']."' class='button'>";
echo "</form></td>";
}
}
   
   
   
   echo "</tr></table>";
   }
   
   tablebreak();
   //warnings ends
   
   
   echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>
<tr>
<td class='tbl2' colspan='2'><b>".$locale['422']."</b></td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u040']."</b></td>
<td class='tbl1'>".showdate("longdate", $data['user_joined'])."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u044']."</b></td>
<td class='tbl2'>".($data['user_lastvisit'] != 0 ? showdate("longdate", $data['user_lastvisit']) : $locale['u049'])."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u041']."</b></td>
<td class='tbl1'>".number_format(dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'"))."</td>
</tr>
<tr>
<td width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['u042']."</b></td>
<td class='tbl2'>".number_format(dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'"))."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>".$locale['u043']."</b></td>
<td class='tbl1'>".number_format($data['user_posts'])."</td>
</tr>
</table>\n";
   if ($data['user_groups']) {
      tablebreak();
      echo "<table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'>\n";
      echo "<tr>\n<td class='tbl2'><b>".$locale['423']."</b></td>\n\n</tr>\n<tr>\n<td class='tbl1'>\n";
      $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 href='".FUSION_SELF."?group_id=".$user_groups[$i]."'>".getgroupname($user_groups[$i])."</a>";
         if ($i != (count($user_groups)-1)) { echo ",\n"; } else { echo "\n"; }
      }
      echo "</td>\n</tr>\n</table>\n";
   }
} else {
   if (!isNum($group_id)) fallback("index.php");
   $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='1' width='100%' class='tbl-border'>
<tr>
<td align='center' colspan='2' class='tbl1'><b>".$data['group_name']."</b> (".sprintf((dbrows($result)==1?$locale['411']:$locale['412']), dbrows($result)).")</td>
</tr>
<tr>
<td class='tbl2'><b>".$locale['401']."</b></td>
<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['402']."</b></td>
</tr>\n";
      while ($data = dbarray($result)) {
         $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2"); $i++;
         echo "<tr>\n<td class='$cell_color'>\n<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>\n";
         echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>\n</tr>";
      }
      echo "</table>\n";
   } else {
      fallback(BASEDIR."index.php");
   }
}
closetable();

//ispejimu uzklausos
   if ($_GET['veiksmas'] == "warn") {
if (iADMIN && checkrights("F")) {
$result = dbquery("UPDATE ".$db_prefix."users SET warnings=warnings+1 WHERE user_id='$lookup'");
redirect(FUSION_SELF."?lookup=$lookup");
} else { fallback(BASEDIR."index.php"); }
}

if ($_GET['veiksmas'] == "ban") {
if (iADMIN && checkrights("F")) {
$result = dbquery("UPDATE ".$db_prefix."users SET warnings=warnings+1 WHERE user_id='$lookup'");
$result = dbquery("UPDATE ".$db_prefix."users SET user_status='1' WHERE user_id='$lookup'");
redirect(FUSION_SELF."?lookup=$lookup");
} else { fallback(BASEDIR."index.php"); }
}

if ($_GET['veiksmas'] == "unwarn") {
if (iADMIN && checkrights("F")) {
$result = dbquery("UPDATE ".$db_prefix."users SET warnings=warnings-1 WHERE user_id='$lookup'");
redirect(FUSION_SELF."?lookup=$lookup");
} else { fallback(BASEDIR."index.php"); }
}
//

// SF Gift System start
if ((isset($lookup)) && (isNum($lookup))) {
   if (file_exists(INFUSIONS."sf_gift_system/profile_include.php")) {
      include INFUSIONS."sf_gift_system/profile_include.php";
   }
}
// SF Gift System end


//nario parasas
if ($data['user_sig']) {
opentable("Vartotojo Para&#240;as");
echo "<center>".parseubb(parsesmileys($data['user_sig']))."</center>";
closetable();
}
//

//nario komentaru rodymas
include INCLUDES."comments_include.php";
   showcomments("U","users","user_id",$lookup,BASEDIR."profile.php?lookup=$lookup");
//
   
require_once "side_right.php";
require_once "footer.php";
?>



Redagavo mariuxxxx· 2009 Rugp. 2 13:08:45

Parašė mariuxxxx· 2009 Rugp. 1 18:08:29
#18

padekit jei kas mokat:(

Parašė mariuxxxx· 2009 Rugp. 1 18:08:10
#19

kasnors:(