Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: rekomendavo.

Parašė _Tomas· 2008 Kov. 24 13:03:44
#1

1. taigi ar butu įmanoma idėti į register.php failą kaip registruojes tokią eilutę:
Kas rekomendavo į saitą?: [Lente kur butu galima įrašyt nicką ]
Ir kaip įrašo nicka arba nerašo ir užsiregistruojas. profile.php kokioj nors eilutei butu: Rekomendavo: [ nickas ].

2. Ir jeigu įrašo teisingai nicka įmanoma sujungti user_gold_panel su register.php rekomendavo. ir kad gautu kažkiek aukso tas žmogus kurio nicką tenais įrašė.

Parašė Dandžu· 2008 Kov. 24 13:03:21
#2

Taip manau įmanoma. Bet reiks kurti mysql užklausą.

Parašė Black psycho· 2008 Kov. 24 13:03:25
#3

ymanoma ir yra gan paprasta tik darbo yra už kurį reikės mokėti;)

Parašė _Tomas· 2008 Kov. 24 13:03:57
#4

o tai jeigu sakot lengva? Kiek jau užtokį dalyka mokėt?

Parašė Black psycho· 2008 Kov. 24 13:03:35
#5

as tai imciau kokius 20-25Lt už darbą nes dabar tikrai turiu ir taip ką veikti:s Infiliacija xDDD

Redagavo Black psycho· 2008 Kov. 24 13:03:15

Parašė kiskiss· 2008 Kov. 24 13:03:32
#6

Vyrai baikim tuos žaidimus, čia 2 minučių darbas.
Failus prisegu, jeigu nepavyksta

Atsidarom phpmyadmin ir įvykdom užklausa
alter table PREFISKAS_users add column user_rekomendavo varchar(30);


Dabar keičiam register.php:
<?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."register.php";
include LOCALE.LOCALESET."user_fields.php";


if (iMEMBER) fallback("index.php");

if ($settings['enable_registration']) {

if (isset($activate)) {
   if (!preg_match("/^[0-9a-z]{32}$/", $activate)) fallback("index.php");
   $result = dbquery("SELECT * FROM ".$db_prefix."new_users WHERE user_code='$activate'");
   if (dbrows($result) != 0) {
      $data = dbarray($result);
      $user_info = unserialize($data['user_info']);
      $activation = $settings['admin_activation'] == "1" ? "2" : "0";
      $result = dbquery("INSERT INTO ".$db_prefix."users (user_name, user_password, user_email, user_hide_email, user_location, user_birthdate, user_aim, user_rekomendavo, user_icq, user_msn, user_yahoo, user_web, user_theme, user_offset, user_avatar, user_sig, user_posts, user_joined, user_lastvisit, user_ip, user_rights, user_groups, user_level, user_status) VALUES('".$user_info['user_name']."', '".md5($user_info['user_password'])."', '".$user_info['user_email']."', '".$user_info['user_hide_email']."', '', '0000-00-00', '', '', '', '', '', 'Default', '0', '', '', '0', '".time()."', '0', '".USER_IP."', '', '', '101', '$activation')");
      $result = dbquery("DELETE FROM ".$db_prefix."new_users WHERE user_code='$activate'");   
      opentable($locale['401']);
      if ($settings['admin_activation'] == "1") {
         echo "<center><br>\n".$locale['455']."<br><br>\n".$locale['453']."<br><br>\n</center>\n";
      } else {
         echo "<center><br>\n".$locale['455']."<br><br>\n".$locale['452']."<br><br>\n</center>\n";
      }
      closetable();
   } else {
      fallback("index.php");
   }
} else if (isset($_POST['register'])) {
   $error = "";
   $username = stripinput(trim(eregi_replace(" +", " ", $_POST['username'])));
   $email = stripinput(trim(eregi_replace(" +", "", $_POST['email'])));
   $password1 = stripinput(trim(eregi_replace(" +", "", $_POST['password1'])));
   
   if ($username == "" || $password1 == "" || $email == "") $error .= $locale['402']."<br>\n";
   
   if (!preg_match("/^[-0-9A-Z_@\s]+$/i", $username)) $error .= $locale['403']."<br>\n";
   
   if (preg_match("/^[0-9A-Z@]{6,20}$/i", $password1)) {
      if ($password1 != $_POST['password2']) $error .= $locale['404']."<br>\n";
   } else {
      $error .= $locale['405']."<br>\n";
   }
 
   if (!preg_match("/^[-0-9A-Z_\.]{1,50}@([-0-9A-Z_\.]+\.){1,50}([0-9A-Z]){2,4}$/i", $email)) {
      $error .= $locale['406']."<br>\n";
   }
   
   $email_domain = substr(strrchr($email, "@"), 1);
   $result = dbquery("SELECT * FROM ".$db_prefix."blacklist WHERE blacklist_email='".$email."' OR blacklist_email='$email_domain'");
   if (dbrows($result) != 0) $error = $locale['411']."<br>\n";

   $result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_email='".$email."'");
   if (dbrows($result) != 0) $error = $locale['408']."<br>\n";
   
   if ($settings['email_verification'] == "1") {
      $result = dbquery("SELECT * FROM ".$db_prefix."new_users");
      while ($new_users = dbarray($result)) {
         $user_info = unserialize($new_users['user_info']);
         if ($new_users['user_email'] == $email) { $error = $locale['409']."<br>\n"; }
         if ($user_info['user_name'] == $username) { $error = $locale['407']."<br>\n"; break; }
      }
   }
   
   if ($settings['display_validation'] == "1") {
      $user_code = stripinput($_POST['user_code']);
      $result = dbquery("SELECT * FROM ".$db_prefix."vcode WHERE vcode_1='$user_code'");
      if (dbrows($result) == 0) {
         $error .= $locale['410']."<br>\n";
      } else {
         $result = dbquery("DELETE FROM ".$db_prefix."vcode WHERE vcode_1='$user_code'");
      }
   }
   
   $user_hide_email = isNum($_POST['user_hide_email']) ? $_POST['user_hide_email'] : "1";
   
   if ($settings['email_verification'] == "0") {
      $user_location = isset($_POST['user_location']) ? stripinput(trim($_POST['user_location'])) : "";
      if ($_POST['user_month'] != 0 && $_POST['user_day'] != 0 && $_POST['user_year'] != 0) {
         $user_birthdate = (isNum($_POST['user_year']) ? $_POST['user_year'] : "0000")
         ."-".(isNum($_POST['user_month']) ? $_POST['user_month'] : "00")
         ."-".(isNum($_POST['user_day']) ? $_POST['user_day'] : "00");
      } else {
         $user_birthdate = "0000-00-00";
      }
      $user_aim = isset($_POST['user_aim']) ? stripinput(trim($_POST['user_aim'])) : "";
      $user_rekomendavo = isset($_POST['user_rekomendavo']) ? stripinput(trim($_POST['user_rekomendavo'])) : "";
      $user_icq = isset($_POST['user_icq']) ? stripinput(trim($_POST['user_icq'])) : "";
      $user_msn = isset($_POST['user_msn']) ? stripinput(trim($_POST['user_msn'])) : "";
      $user_yahoo = isset($_POST['user_yahoo']) ? stripinput(trim($_POST['user_yahoo'])) : "";
      $user_web = isset($_POST['user_web']) ? stripinput(trim($_POST['user_web'])) : "";
      $user_theme = stripinput($_POST['user_theme']);
      $user_offset = is_numeric($_POST['user_offset']) ? $_POST['user_offset'] : "0";
      $user_sig = isset($_POST['user_sig']) ? stripinput(trim($_POST['user_sig'])) : "";
   }
   if ($error == "") {
      if ($settings['email_verification'] == "1") {
         require_once INCLUDES."sendmail_include.php";
         mt_srand((double)microtime()*1000000); $salt = "";
         for ($i=0;$i<=7;$i++) { $salt .= chr(rand(97, 122)); }
         $user_code = md5($email.$salt);
         $activation_url = $settings['siteurl']."register.php?activate=".$user_code;
         if (sendemail($username,$email,$settings['siteusername'],$settings['siteemail'],$locale['449'], $locale['450'].$activation_url)) {
            $user_info = serialize(array(
               "user_name" => $username,
               "user_password" => $password1,
               "user_email" => $email,
               "user_hide_email" => isNum($_POST['user_hide_email']) ? $_POST['user_hide_email'] : "1"
            ));
            $result = dbquery("INSERT INTO ".$db_prefix."new_users (user_code, user_email, user_datestamp, user_info) VALUES('$user_code', '".$email."', '".time()."', '$user_info')");
            opentable($locale['400']);
            echo "<center><br>\n".$locale['454']."<br><br>\n</center>\n";
            closetable();
         } else {
            opentable($locale['456']);
            echo "<center><br>\n".$locale['457']."<br><br>\n</center>\n";
            closetable();
         }
      } else {
         $activation = $settings['admin_activation'] == "1" ? "2" : "0";
         $result = dbquery("INSERT INTO ".$db_prefix."users (user_name, user_password, user_email, user_hide_email, user_location, user_birthdate, user_aim, user_rekomendavo, user_icq, user_msn, user_yahoo, user_web, user_theme, user_offset, user_avatar, user_sig, user_posts, user_joined, user_lastvisit, user_ip, user_rights, user_groups, user_level, user_status) VALUES('$username', md5('".$password1."'), '".$email."', '$user_hide_email', '$user_location', '$user_birthdate', '$user_aim', '$user_rekomendavo', '$user_icq', '$user_msn', '$user_yahoo', '$user_web', '$user_theme', '$user_offset', '', '$user_sig', '0', '".time()."', '0', '".USER_IP."', '', '', '101', '$activation')");
         opentable($locale['400']);
         if ($settings['admin_activation'] == "1") {
            echo "<center><br>\n".$locale['451']."<br><br>\n".$locale['453']."<br><br>\n</center>\n";
         } else {
            echo "<center><br>\n".$locale['451']."<br><br>\n".$locale['452']."<br><br>\n</center>\n";
         }
         closetable();
      }
   } else {
      opentable($locale['456']);
      echo "<center><br>\n".$locale['458']."<br><br>\n$error<br>\n<a href='".FUSION_SELF."'>".$locale['459']."</a></div></br>\n";
      closetable();
   }
} else {
   if ($settings['email_verification'] == "0") {
      $theme_files = makefilelist(THEMES, ".|..", true, "folders");
      array_unshift($theme_files, "Default");
      $offset_list = "";
      for ($i=-13;$i<17;$i++) {
         if ($i > 0) { $offset="+".$i; } else { $offset=$i; }
         $offset_list .= "<option".($offset == "0" ? " selected" : "").">$offset</option>\n";
      }
   }
   if ($settings['display_validation'] == "1") {
      srand((double)microtime()*1000000);
      $temp_num = md5(rand(0,9999));
      $vcode_1 = substr($temp_num, 17, 5);
      $vcode_2 = md5($vcode_1);
      unset($temp_num);
      $result = dbquery("INSERT INTO ".$db_prefix."vcode VALUES('".time()."', '$vcode_1', '$vcode_2')");
   }
   opentable($locale['400']);
   echo "<center>".$locale['500']."\n";
   if ($settings['email_verification'] == "1") echo $locale['501']."\n";
   echo $locale['502'];
   if ($settings['email_verification'] == "1") echo "\n".$locale['503'];
   echo "</center><br>
<table align='center' cellpadding='0' cellspacing='0'>
<form name='inputform' method='post' action='".FUSION_SELF."' onSubmit='return ValidateForm(this)'>
<tr>
<td class='tbl'>".$locale['u001']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='username' maxlength='30' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u002']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='password' name='password1' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u004']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='password' name='password2' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u005']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='email' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u006']."</td>
<td class='tbl'><input type='radio' name='user_hide_email' value='1'>".$locale['u007']."
<input type='radio' name='user_hide_email' value='0' checked>".$locale['u008']."</td>
</tr>\n";
   if ($settings['display_validation'] == "1") {
      echo "<tr>\n<td class='tbl'>".$locale['504']."</td>\n<td class='tbl'>";
      if ($settings['validation_method'] == "image") {
         echo "<img src='?vimage=$vcode_2'>\n";
      } else {
         echo "<b>$vcode_1</b>\n";
      }
      unset($vcode_1,$vcode_2);
      echo "</td>\n</tr>\n";
      echo "<tr>
<td class='tbl'>".$locale['505']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='user_code' class='textbox' style='width:100px'></td>
</tr>\n";
   }
   if ($settings['email_verification'] == "0") {
      echo "<tr>
<td class='tbl'>".$locale['u009']."</td>
<td class='tbl'><input type='text' name='user_location' maxlength='50' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u010']." <span class='small2'>(mm/dd/yyyy)</span></td>
<td class='tbl'><select name='user_month' class='textbox'>\n<option> </option>\n";
      for ($i=1;$i<=12;$i++) echo "<option".($user_month == $i ? " selected" : "").">$i</option>\n";
      echo "</select>\n<select name='user_day' class='textbox'>\n<option> </option>\n";
      for ($i=1;$i<=31;$i++) echo "<option".($user_day == $i ? " selected" : "").">$i</option>\n";
      echo "</select>\n<select name='user_year' class='textbox'>\n<option> </option>\n";
      for ($i=1900;$i<=2004;$i++) echo "<option".($user_year == $i ? " selected" : "").">$i</option>\n";
      echo "</select>
</td>
</tr>
<tr>
<td class='tbl'>".$locale['u021']."</td>
<td class='tbl'><input type='text' name='user_aim' maxlength='16' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>Rekomendavo:</td>
<td class='tbl'><input type='text' name='user_rekomendavo' maxlength='30' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u011']."</td>
<td class='tbl'><input type='text' name='user_icq' maxlength='15' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u012']."</td>
<td class='tbl'><input type='text' name='user_msn' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u013']."</td>
<td class='tbl'>
<input type='text' name='user_yahoo' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u014']."</td>
<td class='tbl'><input type='text' name='user_web' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u015']."</td>
<td class='tbl'><select name='user_theme' class='textbox' style='width:200px;'>
".makefileopts($theme_files)."
</select></td>
</tr>
<tr>
<td class='tbl'>".$locale['u016']."</td>
<td class='tbl'><select name='user_offset' class='textbox'>
$offset_list</select></td>
</tr>
<tr>
<td valign='top'>".$locale['u020']."</td>
<td class='tbl'>
<textarea name='user_sig' rows='5' class='textbox' style='width:295px'>".$userdata['user_sig']."</textarea><br>
<input type='button' value='b' class='button' style='font-weight:bold;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='i' class='button' style='font-style:italic;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='u' class='button' style='text-decoration:underline;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='url' class='button' style='width:30px;' onClick=\"addText('user_sig', '[url]', '[/url]');\">
<input type='button' value='mail' class='button' style='width:35px;' onClick=\"addText('user_sig', '[mail]', '[/mail]');\">
<input type='button' value='img' class='button' style='width:30px;' onClick=\"addText('user_sig', '[img]', '[/img]');\">
<input type='button' value='center' class='button' style='width:45px;' onClick=\"addText('user_sig', '
', '
');\">
<input type='button' value='small' class='button' style='width:40px;' onClick=\"addText('user_sig', '', '');\">
</td>
</tr>\n";
   }
   echo "<tr>
<td align='center' colspan='2'><br>
<input type='submit' name='register' value='".$locale['506']."' class='button'>
</td>
</tr>
</form>
</table>";
   closetable();
   echo "<script language='JavaScript'>
function ValidateForm(frm) {
   if (frm.username.value==\"\") {
      alert(\"".$locale['550']."\");
      return false;
   }
   if (frm.password1.value==\"\") {
      alert(\"".$locale['551']."\");
      return false;
   }
   if (frm.email.value==\"\") {
      alert(\"".$locale['552']."\");
      return false;
   }
}
</script>\n";
}

} else {
   opentable($locale['400']);
   echo "<center><br>\n".$locale['507']."<br><br>\n</center>\n";
   closetable();
}

require_once "side_right.php";
require_once "footer.php";
?>




Ir profile.php pridedam laukelį:

Po šiuo tekstu:
<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>



Pridedam:
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Rekomendavo</b></td>
<td class='tbl1'>".($data['user_rekomendavo'] ? $data['user_rekomendavo'] : $locale['u048'])."</td>
</tr>



Redagavo kiskiss· 2008 Kov. 24 13:03:14

Parašė Dandžu· 2008 Kov. 24 13:03:12
#7

Aš ir pradėjau šitą jau daryti.

Parašė NoNy· 2008 Kov. 24 13:03:56
#8

Laukiu, ir man reikėtų. ;)

Parašė Dandžu· 2008 Kov. 24 13:03:41
#9

Taigi jau padarė.

Parašė NoNy· 2008 Kov. 24 13:03:43
#10

O tavo toks pat?

Parašė kiskiss· 2008 Kov. 24 13:03:18
#11

Nu tai jeigu aš jau padariau kam jam bedaryt?

Parašė Black psycho· 2008 Kov. 24 13:03:54
#12

kiskiss parodyk kodą kuris automatiškai prideda pinigų tam useriui nes kažkaip nepastebejau? (čia jei ką ne tam kad pyktis parašiau tiesiog nepastebėjau):?

Redagavo Black psycho· 2008 Kov. 24 13:03:46

Parašė _Tomas· 2008 Kov. 24 14:03:21
#13

Man virš Registracija Cellpic Meta Table 'PREFIXAS_vcode' doesn't exist
Kaip kuriu ta table ka joje įrašyt?


Kaip man šitą kodą idėt ne į default profile.php po Gimimo Data.
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Rekomendavo</b></td>
<td class='tbl1'>".($data['user_rekomendavo'] ? $data['user_rekomendavo'] : $locale['u048'])."</td>
</tr>


Profile.php

<?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."profile-ratings.php";
include LOCALE.LOCALESET."user_fields.php";
//SF Gift System lang start
// Check if locale file is available matching the current site locale setting.
if (file_exists(INFUSIONS."sf_gift_system/locale/".LOCALESET."/profile.php")) {   
// Load the locale file matching the current site locale setting.   
include INFUSIONS."sf_gift_system/locale/".LOCALESET."/profile.php";
} else {
// Load the infusion's default locale file.
include INFUSIONS."sf_gift_system/locale/Lithuanian/profile.php";}
//SF Gift System lang end
//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($lookup)) && (!isset($group_id)) && (isNum($lookup))) {
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_id='$lookup'");
if (dbrows($result)) $data = dbarray($result);
else redirect("index.php");
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("'profile.php?lookup=".$userdata['user_id']."'");
}
}

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("@","@",$data['user_email'])."';\" style='margin-bottom:1px;width:100px;' title='".str_replace("@","@",$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']."'>" : " ");
}
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'] == 105) $color = "#009900";
elseif ($data['user_level'] == 104) $color = "#cc0000";
elseif ($data['user_level'] == 103) $color = "#ff9900";
elseif ($data['user_level'] == 102) $color = "#6600ff";
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";
echo "<hr>";
$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) : "".$locale['re001']."");
$rdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."user_ratings WHERE rate_subject = '$lookup' ORDER BY rate_date DESC LIMIT 1"));
echo "".$locale['re000']." $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";
}
}
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['sfgift700']."</td><td class='small2'>";
if ((iMEMBER) && ($data['user_id'] != $userdata['user_id'])) { echo "<a href='".INFUSIONS."sf_gift_system/brows_gifts.php?user_id=".$lookup."'>".$locale['sfgift701']." ".$data['user_name']."</a>";} else { echo $locale['sfgift701']." ".$data['user_name'];}
echo"</td></tr>\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("@","@",$data['user_email'])."';\" style='width:100px;' title='".str_replace("@","@",$data['user_email'])."'>".$locale['u051']."</button> \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> \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> \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)."&" : "");
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']."&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&list=threads'><strong>".$locale['pe112']."</strong></a></td></tr>";
elseif ($numrows > $limit) $pagenav = makePageNav($rowstart,$limit,$numrows,3,FUSION_SELF."?lookup=$lookup&list=threads&");
} 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)."&" : "");
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']."&thread_id=".$row['thread_id']."&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&list=posts'><strong>".$locale['pe112']."</strong></a></td></tr>\n";
elseif ($numrows > $limit) $pagenav = makePageNav($rowstart,$limit,$numrows,3,FUSION_SELF."?lookup=$lookup&list=posts&");
} 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&list=news'><strong>".$locale['pe112']."</strong></a></td></tr>";
elseif ($numrows > $limit) $pagenav = makePageNav($rowstart,$limit,$numrows,3,FUSION_SELF."?lookup=$lookup&list=news&");
} 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";
echo "</table>\n";

echo "<script type='text/javascript'>
function ShowHide(id)
{
obj = document.getElementsByTagName(\"div\");
if (obj[id].style.visibility == 'visible')
{
obj[id].style.visibility = 'hidden';
}
else
{
obj[id].style.visibility = 'visible';
}
}
</script>\n";
closetable();
} else {
fallback(BASEDIR."index.php");
}
} else fallback("index.php");
if (isset($_GET['lookup']) && !isset($_GET['view'])) {
include INCLUDES."comments_include.php";
showcomments("U","users","user_id",$_GET['lookup'],FUSION_SELF."?lookup=".$_GET['lookup']);
}
// 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
if ($profile_include_rightside) require_once "side_right.php";
else echo "</td>\n";
require_once "footer.php";
?>



Redagavo kiskiss· 2008 Kov. 24 14:03:43

Parašė kiskiss· 2008 Kov. 24 14:03:22
#14

Nepastebėjau tos 2 dalies bet sukurti nesunku

O kaip įdėti, dabar nežinau nes čia tikrai kad ne defaultinis profile.php

Redagavo kiskiss· 2008 Kov. 24 14:03:33

Parašė _Tomas· 2008 Kov. 24 15:03:58
#15

O tai ka man rašyt kai kuriu vcode table?

Parašė NoNy· 2008 Kov. 24 15:03:18
#16

Čia ne į tėmą. Tavo ten uber strike saite pamačiau panėlę Demo, galėtum man ją į PM? :)

Parašė Dandžu· 2008 Kov. 24 15:03:32
#17

Modų saite yra. MAnjack sukūrė ir į forumą parašė paieškok ten.

Parašė _Tomas· 2008 Kov. 24 18:03:44
#18

CeeZ parašė:
Čia ne į tėmą. Tavo ten uber strike saite pamačiau panėlę Demo, galėtum man ją į PM? :)


Čia ne mano saitas :D

O tai kas nors gali padėt?

Redagavo _Tomas· 2008 Kov. 24 18:03:00

Parašė kiskiss· 2008 Kov. 24 18:03:32
#19

Savizudisz parašė:

O tai kas nors gali padėt?


PREFIXAS_vcode
PREFIXAS keisk į savo fusiono prefixa, defaultinis yra
fusion_
todėl kai kuri nauja lentelę turėtu atrodyti taip
alter table fusion_users add column user_rekomendavo varchar(30);

Redagavo kiskiss· 2008 Kov. 24 18:03:19

Parašė _Tomas· 2008 Kov. 24 19:03:08
#20

aš kaip dėjau užklausa dėjau savo prefixa nes pas mane nėra default :D

manes tiesiog prašo sukurti prefixas_vcode table... o aš kurdamas nežinau ka rašyt kad atitiktu viskas.

Redagavo _Tomas· 2008 Kov. 24 19:03:17