_Tomas
VIP narys
Terminatorius
Pranešimai: 1319
Įstojęs: 2007 Rugp. 26 20:08:12
|
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šė.
|
Dandžu
Narys
Ekspertas
Pranešimai: 3265
Įstojęs: 2007 Lie. 23 13:07:47
|
Taip manau įmanoma. Bet reiks kurti mysql užklausą.
|
Black psycho
Narys
Kapitonas
Pranešimai: 785
Įstojęs: 2007 Rugs. 29 10:09:40
|
ymanoma ir yra gan paprasta tik darbo yra už kurį reikės mokėt
„Ne alkoholis sukelia girtumą ir alkoholizmą, bet neprotingas jo vartojimo būdas.“ |
_Tomas
VIP narys
Terminatorius
Pranešimai: 1319
Įstojęs: 2007 Rugp. 26 20:08:12
|
o tai jeigu sakot lengva? Kiek jau užtokį dalyka mokėt?
|
Black psycho
Narys
Kapitonas
Pranešimai: 785
Įstojęs: 2007 Rugs. 29 10:09:40
|
as tai imciau kokius 20-25Lt už darbą nes dabar tikrai turiu ir taip ką veikti Infiliacija xDDD
„Ne alkoholis sukelia girtumą ir alkoholizmą, bet neprotingas jo vartojimo būdas.“
Redagavo Black psycho 2008 Kov. 24 13:03:15 |
kiskiss
Narys
Terminatorius
Pranešimai: 1545
Įstojęs: 2006 Rugs. 11 17:09:58
|
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>
|
Dandžu
Narys
Ekspertas
Pranešimai: 3265
Įstojęs: 2007 Lie. 23 13:07:47
|
Aš ir pradėjau šitą jau daryti.
|
NoNy
Narys
Ekspertas
Pranešimai: 2803
Įstojęs: 2008 Vas. 14 13:02:57
|
Laukiu, ir man reikėtų.
|
Dandžu
Narys
Ekspertas
Pranešimai: 3265
Įstojęs: 2007 Lie. 23 13:07:47
|
Taigi jau padarė.
|
NoNy
Narys
Ekspertas
Pranešimai: 2803
Įstojęs: 2008 Vas. 14 13:02:57
|
O tavo toks pat?
|
kiskiss
Narys
Terminatorius
Pranešimai: 1545
Įstojęs: 2006 Rugs. 11 17:09:58
|
Nu tai jeigu aš jau padariau kam jam bedaryt?
|
Black psycho
Narys
Kapitonas
Pranešimai: 785
Įstojęs: 2007 Rugs. 29 10:09:40
|
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)
„Ne alkoholis sukelia girtumą ir alkoholizmą, bet neprotingas jo vartojimo būdas.“
Redagavo Black psycho 2008 Kov. 24 13:03:46 |
_Tomas
VIP narys
Terminatorius
Pranešimai: 1319
Įstojęs: 2007 Rugp. 26 20:08:12
|
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";
?>
|
kiskiss
Narys
Terminatorius
Pranešimai: 1545
Įstojęs: 2006 Rugs. 11 17:09:58
|
Nepastebėjau tos 2 dalies bet sukurti nesunku
O kaip įdėti, dabar nežinau nes čia tikrai kad ne defaultinis profile.php
|
_Tomas
VIP narys
Terminatorius
Pranešimai: 1319
Įstojęs: 2007 Rugp. 26 20:08:12
|
O tai ka man rašyt kai kuriu vcode table?
|
NoNy
Narys
Ekspertas
Pranešimai: 2803
Įstojęs: 2008 Vas. 14 13:02:57
|
Čia ne į tėmą. Tavo ten uber strike saite pamačiau panėlę Demo, galėtum man ją į PM? 
|
Dandžu
Narys
Ekspertas
Pranešimai: 3265
Įstojęs: 2007 Lie. 23 13:07:47
|
Modų saite yra. MAnjack sukūrė ir į forumą parašė paieškok ten.
|
_Tomas
VIP narys
Terminatorius
Pranešimai: 1319
Įstojęs: 2007 Rugp. 26 20:08:12
|
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 
O tai kas nors gali padėt?
Redagavo _Tomas 2008 Kov. 24 18:03:00 |
kiskiss
Narys
Terminatorius
Pranešimai: 1545
Įstojęs: 2006 Rugs. 11 17:09:58
|
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);
|
_Tomas
VIP narys
Terminatorius
Pranešimai: 1319
Įstojęs: 2007 Rugp. 26 20:08:12
|
aš kaip dėjau užklausa dėjau savo prefixa nes pas mane nėra default
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 |
