Tarih: 2008-10-21, 12:49:11 Mesaj konusu: NG Kimler Bağlı Bloğunda Puan Gösterme
s.a
ben sitenizde olan NG_Userinfo bloğunu kullanıyorum.Bir sorum olacak
bu bloğa üye giriş yaptığında üyenin puanının yazmasını istiyorum nasıl yapabiliriz?
yönetim panelinden kullanıcı gruplarından paunları ayarladım mesela ankete oy vermeye 1 puan verdim.Ama oy kullanınca puan vermiyor sistem Blok sorunsuz çalışıyor ama puanlama sistemide sorun var galiba?
if (eregi("block-User_Info.php", $_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}
global $admin, $user, $prefix, $user_prefix, $c o o k i e, $anonymous, $gfx_chk;
global $bgcolor1, $bgcolor2, $bgcolor3, $txtcolor1, $txtcolor2, $uname, $nukeurl, $db, $sitename;
$ip = getenv("REMOTE_ADDR");
if (is_user($user)){
c o o k i edecode($user);
$uname = $c o o k i e[1];
$user_id = $c o o k i e[0];
$guest=0;
}
else {
$uname = "$ip";
$guest=1;
$showscrollist=0;
}
$db->sql_query("DELETE FROM ".$prefix."_session WHERE time < $past");
$result = $db->sql_query("SELECT time FROM ".$prefix."_session WHERE uname='$uname'");
if ($row = $db->sql_fetchrow($result)) {
$db->sql_query("UPDATE ".$prefix."_session SET uname='$uname', time='$ctime', host_addr='$ip', guest='$guest' WHERE uname='$uname'");
}
else {
$db->sql_query("INSERT INTO ".$prefix."_session (uname, time, host_addr, guest) VALUES ('$uname', '$ctime', '$ip', '$guest')");
}
$db->sql_freeresult($result);
$qry="select COUNT(user_id) from ".$user_prefix."_users";
list($totalmembers) = $db->sql_fetchrow($db->sql_query($qry));
$result = $db->sql_query("select username from ".$user_prefix."_users order by user_id DESC limit 0,1");
list($lastuser) = $db->sql_fetchrow($result);
$result2 = $db->sql_query("SELECT DISTINCT guest, uname FROM ".$prefix."_session where (guest=0 or guest=1) order by uname");
while (list($sesionguest, $uname2) = $db->sql_fetchrow($result2)) {
if ($sesionguest==0) {
if(isset($uname))
if(strtolower($uname2)==strtolower($uname)) {$sel="selected";} else{$sel="";}
else
if(strtolower($uname2)==strtolower($username)) {$sel="selected";} else{$sel="";}
$uname3 = substr("$uname2", 0, 20);
$whoonlineselect.="<option value=\"$uname2\" $sel>$uname3</OPTION>\n";
$member_online_num++;
}
else{
$guest_online_num++;
}
}
// Puan gösterme kod başlangıcı
global $sitepoints, $userinfo;
$sitepoints = "points";
$userpoints = number_format($userinfo[$sitepoints]);
// Puan gösterme kod bitişi
if (eregi("block-User_Info.php", $_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}
global $admin, $user, $prefix, $user_prefix, $c o o k i e, $anonymous, $gfx_chk;
global $bgcolor1, $bgcolor2, $bgcolor3, $txtcolor1, $txtcolor2, $uname, $nukeurl, $db, $sitename;
$ip = getenv("REMOTE_ADDR");
if (is_user($user)){
c o o k i edecode($user);
$uname = $c o o k i e[1];
$user_id = $c o o k i e[0];
$guest=0;
}
else {
$uname = "$ip";
$guest=1;
$showscrollist=0;
}
$db->sql_query("DELETE FROM ".$prefix."_session WHERE time < $past");
$result = $db->sql_query("SELECT time FROM ".$prefix."_session WHERE uname='$uname'");
if ($row = $db->sql_fetchrow($result)) {
$db->sql_query("UPDATE ".$prefix."_session SET uname='$uname', time='$ctime', host_addr='$ip', guest='$guest' WHERE uname='$uname'");
}
else {
$db->sql_query("INSERT INTO ".$prefix."_session (uname, time, host_addr, guest) VALUES ('$uname', '$ctime', '$ip', '$guest')");
}
$db->sql_freeresult($result);
$qry="select COUNT(user_id) from ".$user_prefix."_users";
list($totalmembers) = $db->sql_fetchrow($db->sql_query($qry));
$result = $db->sql_query("select username from ".$user_prefix."_users order by user_id DESC limit 0,1");
list($lastuser) = $db->sql_fetchrow($result);
$result2 = $db->sql_query("SELECT DISTINCT guest, uname FROM ".$prefix."_session where (guest=0 or guest=1) order by uname");
while (list($sesionguest, $uname2) = $db->sql_fetchrow($result2)) {
if ($sesionguest==0) {
if(isset($uname))
if(strtolower($uname2)==strtolower($uname)) {$sel="selected";} else{$sel="";}
else
if(strtolower($uname2)==strtolower($username)) {$sel="selected";} else{$sel="";}
$uname3 = substr("$uname2", 0, 20);
$whoonlineselect.="<option value=\"$uname2\" $sel>$uname3</OPTION>\n";
$member_online_num++;
}
else{
$guest_online_num++;
}
}
// Puan gösterme
global $sitepoints, $userinfo;
$sitepoints = "points";
$userpoints = number_format($userinfo[$sitepoints]);
// Puan gösterme kod bitişi
ben de sorunsuz çalıştı ancak ben aşağıdaki userinfo bloğunu kullanıyorum puan sistemi bu blokta çalışırmı.
yada nasıl çalışır..
Kod:
</s>sql_query("CREATE TABLE IF NOT EXISTS $prefix"._mostonline." (total int(10) NOT NULL default '0', members int(10) NOT NULL default '0', nonmembers int(10) NOT NULL default '0',PRIMARY KEY (`total`))");
//Avatar Inicio
mt_srand ((double)microtime()*1000000);
$maxran = 1000000;
$random_num = mt_rand(0, $maxran);
$datekey = date("F j");
$rcode = hexdec(md5($_SERVER[HTTP_USER_AGENT] . $sitekey . $random_num . $datekey));
$code = substr($rcode, 2, 6);
getusrinfo($user);
c o o k i edecode($user);
$uname = $c o o k i e[1];
// If you have too many groups on your site limit how many will be listed in the block
// set $grpcount to 0 if all groups are to be displayed.
$grpcount = 0;
if ($grpcount != 0) {
$grplimit = "LIMIT 0,$grpcount";
} else {
$grplimit = "";
}
$lasturow = $db->sql_fetchrow($db->sql_query("SELECT username FROM $user_prefix"._users." ORDER BY user_id DESC LIMIT 0,1"));
$lastuser = $lasturow['username'];
$numrows = $db->sql_numrows($db->sql_query("SELECT user_id FROM $user_prefix"._users.""));
$result = $db->sql_query("SELECT uname, guest FROM $prefix"._session." WHERE guest='0'");
$member_online_num = $db->sql_numrows($result);
$who_online_now = "";
$i = 1;
while ($session = $db->sql_fetchrow($result)) {
if (isset($session["guest"]) and $session["guest"] == 0) {
if ($i </a>sql_fetchrow($db->sql_query("SELECT COUNT(user_id) AS userCount FROM $user_prefix"._users." WHERE user_regdate LIKE '$curDate2'"));
$userCount = $row['userCount'];
//end
//Executing SQL Today
$row2 = $db->sql_fetchrow($db->sql_query("SELECT COUNT(user_id) AS userCount FROM $user_prefix"._users." WHERE user_regdate LIKE '$curDateP'"));
$userCount2 = $row2['userCount'];
//end
$guest_online_num = $db->sql_numrows($db->sql_query("SELECT uname FROM ".$prefix."_session WHERE guest='1'"));
$member_online_num = $db->sql_numrows($db->sql_query("SELECT uname FROM ".$prefix."_session WHERE guest='0'"));
$who_online_num = $guest_online_num + $member_online_num;
$grpcnt = "";
$i = 1;
$gresult = $db->sql_query("SELECT name, points FROM " . $prefix . "_groups ORDER BY points $grplimit");
while ($grow = $db->sql_fetchrow($gresult)) {
$grname = $grow['name'];
$grpoints = intval($grow['points']);
$users_num = $db->sql_numrows($db->sql_query("SELECT * FROM " . $user_prefix . "_users WHERE points>='$grpoints'"));
if ($i </u>sql_fetchrow($db->sql_query("SELECT points FROM ".$user_prefix."_users WHERE username='$uname'"));
if (is_user($user)) {
$content .="<i><center><b><a href="modules.php?name=Your_Account\">"._TU_CUENTA."</a></i></center></b>";
//Avatar Fin
// Display PM information for User Only
global $user;
if (is_user($user)) {
//Greet User
global $user, $userinfo, $c o o k i e;
c o o k i edecode($user);
$urname = $c o o k i e[1];
$date = date ("H");
if ($date < 11) {
$gr = "$urname\n";
} else if ($date < 17) {
$gr = "$urname\n";
} else if ($date </a>sql_fetchrow($db->sql_query("SELECT user_id FROM $user_prefix"._users." WHERE username='$uname'"));
$uid = $row3['user_id'];
$newpms = $db->sql_numrows($db->sql_query("SELECT privmsgs_to_userid FROM $prefix"._bbprivmsgs." WHERE privmsgs_to_userid='$uid' AND (privmsgs_type='5' OR privmsgs_type='1')"));
$oldpms = $db->sql_numrows($db->sql_query("SELECT privmsgs_to_userid FROM $prefix"._bbprivmsgs." WHERE privmsgs_to_userid='$uid' AND privmsgs_type='0'"));
$content .= "<img src=\"blocks/K-N_user_info/images/email-y.gif\" height=\"10\" width=\"14\"> <a href="modules.php?name=Private_Messages\"><b>"._BPM."</b></a><br>\n";
$content .= "<img src=\"blocks/K-N_user_info/images/email-r.gif\" height=\"10\" width=\"14\"> "._BUNREAD.": <b>$newpms</b><br>\n";
$content .= "<img src=\"blocks/K-N_user_info/images/email-g.gif\" height=\"10\" width=\"14\"> "._BREAD.": <b>$oldpms</b><br>\n\n";
//Line to separate
$content .= "<hr>";
}//Show PM'S
} else {
//Display LOGIN information for Guests Only
mt_srand ((double)microtime()*1000000);
$maxran = 1000000;
$random_num = mt_rand(0, $maxran);
//Greet Guest
if ($date < 11) {
$grg = ""._GOODMORNINGGUEST."\n";
} else if ($date < 17) {
$grg = ""._GOODAFTERNOONGUEST."\n";
} else if ($date </a>sql_fetchrow($db->sql_query($sql));
return $lastuser;
}
//Total Members
function numusers() {
global $prefix, $db;
$sql = "SELECT COUNT(*) FROM ".$prefix."_users WHERE user_id > 1";
list($numrows) = $db->sql_fetchrow($db->sql_query($sql));
return $numrows;
}
//Total Waiting
function waiting_users() {
global $prefix, $db;
$sql = "SELECT COUNT(*) FROM ".$prefix."_users_temp";
list($numrowswaiting) = $db->sql_fetchrow($db->sql_query($sql));
return $numrowswaiting;
}
//New Users Today and Yesterday
function new_users() {
global $prefix, $db;
$sql = "SELECT COUNT(*) FROM ".$prefix."_users WHERE user_regdate='".date("M d, Y")."'";
list($userCount[0]) = $db->sql_fetchrow($db->sql_query($sql));
$sql = "SELECT COUNT(*) FROM ".$prefix."_users WHERE user_regdate='".date("M d, Y", time()-86400)."'";
list($userCount[1]) = $db->sql_fetchrow($db->sql_query($sql));
return $userCount;
}
if ($dopmpopup == 1){
getusrinfo($user);
if ($userinfo['user_popup_pm'] && $userinfo['user_new_privmsg']) {
$content .= "<s>
<window>
</s>";
}
}
//Registered users online
$members = $db->sql_query("SELECT w.uname, u.user_id, u.user_level, u.user_allow_viewonline FROM ".$prefix."_session AS w LEFT JOIN ".$prefix."_users AS u ON u.username = w.uname WHERE guest = '0' ORDER by u.user_id ASC");
$guests = $db->sql_query("SELECT uname FROM ".$prefix."_session WHERE guest ='1'");
//Online Total data
$online_num[0] = $db->sql_numrows($members);
$online_num[1] = $db->sql_numrows($guests);
$online_num[2] = $online_num[0] + $online_num[1];
$en_linea = $db->sql_numrows($members);
//Assemble the online registered users
$who_online_now = "";
$i = 1;
while ($session = $db->sql_fetchrow($members)) {
//Allow View?
if ($session['user_allow_viewonline'] || is_admin($admin)) {
if ($i </a>sql_freeresult($members);
//Break Mostonline Total?
if ($total <online_num>sql_query("DELETE FROM ".$prefix."_mostonline WHERE total='$total' LIMIT 1");
$db->sql_query("INSERT INTO ".$prefix."_mostonline VALUES ('$online_num[2]','$online_num[0]','$online_num[1]')");
}
// Info for users who are logged in AND Guests
$last = new_users();
$lastuser = last_user();
bendede çaıştı teşekkür ederim.sanırım daha evvel benimde yazdığım ve hala devam eden oto puan sisteminin çalışmadığı için sıkıntı oluyor.blok çalışıyor puanıda gösteriyor tabi varsa
arkadaşın dediği gibi Forumlarda olan ziyaretçilerin sayısını bu block içerisinde göstermek mümkünmü, mümkünse nasıl yapabiliriz. yada buna benzer bir block varmı mesela; Şuan sitede 150 ziyaretçi var; 3 ü kayıtlı, 7 si forumlarda v.s. gibi
Bu forumda yeni başlıklar açamazsınız Bu forumdaki başlıklara cevap veremezsiniz Bu forumdaki mesajlarınızı değiştiremezsiniz Bu forumdaki mesajlarınızı silemezsiniz Bu forumdaki anketlerde oy kullanamazsınız