بسم الله الرحمن الرحيم


رمز Code:
Database error in vBulletin 3.8.3:

Invalid SQL:
SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=36;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, August 16th 2009 @ 12:43:53 PM
Error Date : Sunday, August 16th 2009 @ 12:45:10 PM
Script : http://www.tnahed5.com/vb/showthread.php?t=1485
Referrer :
IP Address : xx.xx.xx.xx
Username : admin
Classname : vB_Database
MySQL Version :
جربت حل

هاك عداد المواضيع والردود والزيارات والمرفقات للعضو


بــــ


رمز Code:
//arabdeaf.net###
global $db;
$this_hack_userid = $this->post[userid];
if($post[userid] !=0){
$user_theard_query = $db->query_read("SELECT COUNT(threadid) AS total FROM " . TABLE_PREFIX . "thread WHERE postuserid=$this_hack_userid");
$personal1=$db->query_first("SELECT SUM(views) AS personalviews FROM thread WHERE postuserid=$post[userid] AND open!='10'");
$personal= 2*$post[posts]+$personal1[personalviews];
if ($personal1 == ""):
$personal1 = "0";endif;
global $db;$personal1=$db->query_first("SELECT SUM(views) AS personalviews FROM thread WHERE postuserid=$post[userid] AND open!='10'");
$personal= 2*$post[posts]+$personal1[personalviews];
if ($personal1 == ""):
$personal1 = "0";endif;
$attachment = $db->query_first("SELECT COUNT(attachmentid) AS total FROM attachment WHERE userid=$post[userid] ");
$attachcoun = $attachment[total];
$usertherd_pro_fetch = $db->fetch_array($user_theard_query);
$usertherdcoun = $usertherd_pro_fetch[total];
$userpostdcoun = $post[posts] - $usertherdcoun ;}
//arabdeaf.net###



أو



بـــــ


رمز Code:
global $db;

$this_hack_userid = $this->post[userid];

if ($this_hack_userid != '')
{

$user_theard_query = $db->query_read("SELECT COUNT(threadid) AS total FROM " . TABLE_PREFIX . "thread WHERE postuserid=$this_hack_userid");
$usertherd_pro_fetch = $db->fetch_array($user_theard_query);

$usertherdcoun = $usertherd_pro_fetch[total];

$userpostdcoun = $post[posts] - $usertherdcoun ;

}
ومانفع

أرجو الحل :no: