Black psycho
Narys
Kapitonas
Pranešimai: 785
Įstojęs: 2007 Rugs. 29 10:09:40
Cia mano forum_ranks :
<?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 BASEDIR."subheader.php";
require_once ADMIN."navigation.php";
include LOCALE.LOCALESET."admin/forums.php";
if (!checkrights("F") || !defined("iAUTH") || $aid != iAUTH) fallback("../index.php");
if (!isset($action)) $action = "";
if (isset($status))
{
if ($status == "savefr")
{
$title = $locale['494'];
$message = "<b>".$locale['495']."</b>";
}
elseif ($status == "delfr")
{
$title = $locale['494'];
$message = "<b>".$locale['496']."</b>";
}
opentable($title);
echo "<div align='center'>".$message."</div>\n";
closetable();
tablebreak();
}
if (isset($_POST['save_rank']))
{
$rank_title = stripinput($_POST['rank_title']);
$rank_image = stripinput($_POST['rank_image']);
if($rank_image != "")
{
if ( !preg_match("/(\.gif|\.png|\.jpg)$/is", $rank_image))
{
$rank_image = "";
}
}
$rank_post = isNum($_POST['rank_post']) ? $_POST['rank_post'] : "0";
$rank_special = isNum($_POST['rank_special']) ? $_POST['rank_special'] : "0";
if($action=="radd")
{
if($rank_title != "")
{
$result = dbquery("INSERT INTO ".$db_prefix."ranks (rank_title,rank_image,rank_post,rank_special) VALUES('$rank_title', '$rank_image', '$rank_post', '$rank_special')");
}
}
else
{
$result = dbquery("UPDATE ".$db_prefix."ranks SET rank_title='$rank_title', rank_image='$rank_image', rank_post='$rank_post', rank_special='$rank_special' WHERE rank_id='$rank_id'");
}
redirect(FUSION_SELF.$aidlink."&status=savefr");
}
elseif (isset($_POST['save_special']))
{
$insql="";
$resultd = dbquery("UPDATE ".$db_prefix."users SET user_rank='0' WHERE user_rank='$rank_id'");
if (is_array($_POST['special_user']) && count($_POST['special_user']) > 0)
{
foreach ($_POST['special_user'] as $thisnum)
{
if (isNum($thisnum)) $insql .= ($insql ? "," : "").$thisnum;
}
$result = dbquery("UPDATE ".$db_prefix."users SET user_rank='$rank_id' WHERE user_id IN($insql)");
}
redirect(FUSION_SELF.$aidlink."&status=savefr");
}
else
{
if ($action=="redit")
{
$result = dbquery("SELECT * FROM ".$db_prefix."ranks WHERE rank_id='$rank_id'");
$rdata = dbarray($result);
$rank_title = $rdata['rank_title'];
$rank_image = $rdata['rank_image'];
$rank_post = $rdata['rank_post'];
$rank_special = $rdata['rank_special'];
}
else
{
$rank_title="";
$rank_image="";
$rank_posts="0";
$rank_special="0";
}
opentable($locale['494']);
switch($action)
{
case "radd":
case "redit":
echo "<form name='ranksform2' method='post' action=''>
<table align='center' cellpadding='0' cellspacing='1' class='tbl'>
<tr>
<td class='tbl'>".$locale['498']."</td>
<td><input type='text' name='rank_title' value='".$rank_title."' maxlength='50' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['499']."<br>".$locale['500']."</td>
<td><input type='text' name='rank_image' value='".$rank_image."' maxlength='255' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['501']."</td>
<td><input type='text' name='rank_post' value='".$rank_post."' maxlength='5' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['502']."</td>
<td class='tbl'><select name='rank_special' class='textbox'>
<option value='0'".(!$rank_special ? " selected" : "").">".$locale['505']."</option>
<option value='1'".($rank_special ? " selected" : "").">".$locale['504']."</option>
</select></td>
</tr>
<tr><td> </td></tr>
<tr>
<td class='tbl' align='center' colspan='2'><input type='submit' name='save_rank' value='".$locale['503']."' class='button'></td>
</tr></table></form>";
break;
case "rdelete":
$result = dbquery("UPDATE ".$db_prefix."users SET user_rank='0' WHERE user_rank='".$rank_id."'");
$result = dbquery("DELETE FROM ".$db_prefix."ranks WHERE rank_id='".$rank_id."'");
redirect(FUSION_SELF.$aidlink."&status=delfr");
break;
case "rspecial":
$result = dbquery("SELECT * FROM ".$db_prefix."ranks WHERE rank_id='$rank_id' AND rank_special='1'");
if(dbrows($result)!=0)
{
$user_list="";
$result2 = dbquery("SELECT user_id,user_name,user_rank FROM ".$db_prefix."users WHERE user_rank='0' OR user_rank='$rank_id' ORDER BY user_name ASC");
while($data=dbarray($result2))
{
$user_list .="<option value='".$data['user_id']."'".($data['user_rank'] == $rank_id ? " selected" : "").">".$data['user_name']."</option>\n";
}
echo "<form name='ranksform3' method='post' action=''>
<table align='center' cellpadding='0' cellspacing='1' width='100%'>
<tr>
<td class='tbl' align='center'>".$locale['508']."</td>
</tr>
<tr>
<td class='tbl' align='center'><select multiple size='15' name='special_user[]' class='textbox'>$user_list</select></td>
</tr>
<tr>
<td class='tbl' align='center'><input type='submit' name='save_special' value='".$locale['509']."' class='button'></td>
</tr>
</table></form>";
}
else
{
echo "<center>".$locale['507']."</center>";
}
break;
default:
echo "<form name='ranksform' method='post' action=''>
<table align='center' cellpadding='0' cellspacing='1' width='100%'>
<tr>
<td class='tbl2' align='center'><b>".$locale['498']."</b></td>
<td class='tbl2' align='center'><b>".$locale['499']."</b></td>
<td class='tbl2' align='center'><b>".$locale['501']."</b></td>
<td class='tbl2' align='center'><b>".$locale['502']."</b></td>
<td class='tbl2' colspan='3' align='center'><b>".$locale['488']."</b></td>
</tr>";
$result = dbquery("SELECT * FROM ".$db_prefix."ranks ORDER BY rank_special DESC, rank_id");
if(dbrows($result)!=0)
{
while($rdata2 = dbarray($result))
{
echo "<tr><td class='tbl1' align='center' valign='center' width='33%'>".$rdata2['rank_title']."</td>";
if($rdata2['rank_image'] != "")
{
echo "<td class='tbl1' align='center' width='33%'>".$rdata2['rank_title']."<br><img src='".IMAGES_R.$rdata2['rank_image']."' alt=''></td>";
}
else
{
echo "<td align='center' valign='center'>---</td>";
}
echo "<td class='tbl1' align='center' valign='center' width='10%'>".$rdata2['rank_post']."</td>
<td class='tbl1' align='center' valign='center' width='10%'>".($rdata2['rank_special'] ? $locale['504'] : $locale['505'])."</td>
<td class='tbl1' align='center' valign='center' width='7%'><a href='".FUSION_SELF.$aidlink."&action=redit&rank_id=".$rdata2['rank_id']."'>".$locale['481']."</a></td>
<td class='tbl1' align='center' valign='center' width='7%'><a href='".FUSION_SELF.$aidlink."&action=rdelete&rank_id=".$rdata2['rank_id']."'>".$locale['482']."</a></td>";
if($rdata2['rank_special'])
{
echo "<td class='tbl1' align='center' valign='center' width='7%'><a href='".FUSION_SELF.$aidlink."&action=rspecial&rank_id=".$rdata2['rank_id']."'>".$locale['506']."</a></td>";
}
echo "</tr>";
}
}
echo "<tr>
<td> </td>
</tr>
<tr>
<td colspan='6' align='center'><a href='".FUSION_SELF.$aidlink."&action=radd'>".$locale['497']."</a></td>
</tr></table></form>";
}
closetable();
}
require_once BASEDIR."footer.php";
?>
Kazkas cia negerai nes kai noriu paskirti i specialu ranga nary tai man raso: Unknown column 'user_rank' in 'field list'Unknown column 'user_rank' in 'field list'
ir buna tuscial laukelis kur reikia nari pasirinkti. Cia modas is modai.webdnd.com „Ne alkoholis sukelia girtumą ir alkoholizmą, bet neprotingas jo vartojimo būdas .“
Black psycho
Narys
Kapitonas
Pranešimai: 785
Įstojęs: 2007 Rugs. 29 10:09:40
Tai nieks nezinot? gal cia kazkas su mysql ? „Ne alkoholis sukelia girtumą ir alkoholizmą, bet neprotingas jo vartojimo būdas .“Redagavo
Black psycho 2008 Vas. 28 12:02:12
Giedrunskis
VIP narys
Tankas
Pranešimai: 1972
Įstojęs: 2007 Sau. 26 14:01:04
taip, negerai su mysql , tiksliau viskas gerai su ja, tiesiog tau reikia susikurti ta user_rank lentele joje
Black psycho
Narys
Kapitonas
Pranešimai: 785
Įstojęs: 2007 Rugs. 29 10:09:40
as sukuriau lentele kaip buvo parasyta bet vistiek nieko
„Ne alkoholis sukelia girtumą ir alkoholizmą, bet neprotingas jo vartojimo būdas .“
Black psycho
Narys
Kapitonas
Pranešimai: 785
Įstojęs: 2007 Rugs. 29 10:09:40
Man atrodo kad sql uzklausoje gali buti kazkas blogai va mano sql uzklausa:
CREATE TABLE IF NOT EXISTS fusion_ranks (
rank_id smallint(5) unsigned NOT NULL auto_increment,
rank_title varchar(50) NOT NULL default '',
rank_image varchar(255) NOT NULL default '',
rank_post smallint(5) unsigned NOT NULL default '0',
rank_special tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (rank_id)
) TYPE=MyISAM;
ALTER TABLE fusion_users ADD user_rank smallint(5) unsigned NOT NULL default '0';
Nes man ismeta:
Klaida
SQL užklausa:
ALTER TABLE fusion_users ADD user_rank smallint( 5 ) unsigned NOT NULL default '0';
MySQL atsakymas: ?
#1146 - Table 'marichuana.fusion_users' doesn't exist
„Ne alkoholis sukelia girtumą ir alkoholizmą, bet neprotingas jo vartojimo būdas .“
bruzgis
Narys
Ekspertas
Pranešimai: 3368
Įstojęs: 2006 Geg. 9 18:05:02
tai ziurek ar vienodi prefixai !!!
Peršokti į forumą:
Nebeegzistuojančios svetainės
Žaliems
Bendri PHP-F klausimai
WordPress
Kiti PHP, HTML, MySQL klausimai
Expert PHP, MySQL klausimai
Kitos TVS
C#, Python, Java, JS, C++ klausimai
Naujų modų pristatymai
Mods, Panels & Infusions
Themes
Jūsų saitai
Dalinuosi, dovanoju!
Klausimai apie domenus ir hostingus
VPS/DS serverių konfigūravimas ir valdymas
Viskas apie skaitliukus, top'us ir lankomumą
Dizaino konkursai
Parduodu - perku dizainą, banerį
Parduodu - perku - keičiuosi reklama
Parduodu - perku domeną, tinklapį
Siūlau - ieškau hostingo/VPS serverio
Parduodu - perku skriptą, modifikaciją, tvs
Socialiniai tinklai - Facebook ir kiti
Legalus verslas, teisiniai klausimai
Visa kita kas susiję su darbu ir pinigais
LTStartups.com - Lietuvos startuolių bendruomenė
Off-Topic diskusijos
IT naujienos
Portalo informacija
Narių pasiūlymai
Geležis ir programinė įranga
Grafika
Out Of Place
Su e-verslu nesusijęs darbas ir prekyba
Dalinuosi, dovanoju!