Membre
|
Bonsoir,
Alors voila j'ai créé un jeu, mais je rencontre un problème avec un système de commentaires sur les profils 
Ce qui est bizarre, c'est que je n'ai aucune erreur en local, mais quand c'est en ligne ça casse 
J'ai tenté de détecter le problème mais rien à faire :/
Voici l'erreur :
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mafiapar/public_html/viewuser.php on line 411
Voici mon code (désolé il est un peu long mais bon) :
<?php
include "globals.php";
$_GET['u'] = abs((int) $_GET['u']);
if(!$_GET['u'])
{
print "Utilisation invalide du fichier";
}
else
{
$q=$db->query("SELECT u.*,us.*,c.*,h.*,g.*,f.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN cities c ON u.location=c.cityid LEFT JOIN houses h ON u.maxwill=h.hWILL LEFT JOIN gangs g ON g.gangID=u.gang LEFT JOIN fedjail f ON f.fed_userid=u.userid WHERE u.userid={$_GET['u']}");
if($db->num_rows($q) == 0)
{
print "Désolé, nous n'avons pas pu trouver un utilisateur avec cette ID, vérifiez vos sources.";
}
else
{
$r=$db->fetch_row($q);
if($r['user_level'] == 1) { $userl="Membre"; } else if($r['user_level'] == 2) { $userl="Administrateur"; } else if ($r['user_level'] == 3) { $userl="Modérateur"; } else if($r['user_level'] == 0) { $userl="Bot"; } else {$userl="Support"; }
$lon=($r['laston'] > 0) ?date('F j, Y g:i:s a',$r['laston']) : "Never";
$sup=date('F j, Y g:i:s a',$r['signedup']);
$ts=$r['strength']+$r['agility']+$r['guard']+$r['labour']+$r['IQ'];
$d="";
if($r['laston'] > 0)
{
$la=time()-$r['laston'];
$unit="secondes";
if($la >= 60)
{
$la=(int) ($la/60);
$unit="minutes";
}
if($la >= 60)
{
$la=(int) ($la/60);
$unit="heures";
if($la >= 24)
{
$la=(int) ($la/24);
$unit="jours";
}
}
$str="il y a $la $unit";
}
else
{
$str="--";
}
if($r['last_login'] > 0)
{
$ll=time()-$r['last_login'];
$unit2="secondes";
if($ll >= 60)
{
$ll=(int) ($ll/60);
$unit2="minutes";
}
if($ll >= 60)
{
$ll=(int) ($ll/60);
$unit2="heures";
if($ll >= 24)
{
$ll=(int) ($ll/24);
$unit2="jours";
}
}
$str2="il y a $ll $unit2";
}
else
{
$str2="--";
}
$money=money_formatter($r['money']);
if($r['donatordays']) { $r['username'] = "<font color=green>{$r['username']}</font>";$d="<img src='donator.gif' alt='Donateur: {$r['donatordays']} jours restants' title='Donateur: {$r['donatordays']} jours restants' />"; }
if($r['laston'] >= time()-15*60) { $on="images/online.gif"; } else { $on="images/offline.gif"; }
if($r['laston'] >= time()-15*60) { $status="En ligne"; } else { $status="Hors-Ligne"; }
print "
<div class='icolumn2' id='mainContentDiv'>
<div class='gangpage_container' style='margin-left:0px;'>
<!-- Member Profile Page Starts -->
<div class='member_toppart'>
<div class='bluetxt'>{$r['username']}</div>
<div class='blueimg'><img src='images/profilepage_txt.jpg' alt='' /></div>
</div>
<!-- Member Content Part Starts -->
<div class='mem_conpart1'>
<div class='mem_conpart1_left'>
<div class='con_txt1'>{$r['username']} <span>[{$r['userid']}] $d </span> </div>
<div class='online_btn'> <img src='$on' alt='$status' title='$status' style='float: left' /> </div>
<div class='respart'>
<div class='resimg_bg' style='padding-top:2px;position:relative;'>
<img src='{$r['display_pic']}' width='168' height='140' alt='Avatar' title='Avatar' style='float: left' />
<p class='occlusion'><img src='images/ze.png' alt='' /></p>
</div>
</div> ";
if($r['donatordays'] > 0)
{
print "
<div class='res_txtpart'>
<div class='restxt_bg'></div> ";
}
else
print " <br/> <br/> ";
print "
<b> ".get_gameranks($r['level'],$r['hPRICE'],$r)." </b>
<div class='leveltxt' style='background:url(./images/exp_100.gif);' style='float: left'>Niveau {$r['level']}</div>
<br/>
<div class='caption_part'>
<div class='cap_txtpart'>
<div class='cap_txt1'>Niveau:</div>
<div class='cap_txt2'>$userl</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Sexe:</div>
<div class='cap_txt2'>{$r['gender']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Statut:</div>
<div class='cap_txt2'><span><font color='#70cb00'><b><img src='$on' alt='$status' title='$status' /></b></font></span></div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Dernière activité:</div>
<div class='cap_txt2'>$str</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Jours d'ancienneté:</div>
<div class='cap_txt2'>{$r['daysold']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Ville:</div>
<div class='cap_txt2'>{$r['cityname']} [<a href='travel.php' style='color:#7EE800;'>Voyager</a>]</div>
</div>
<div class='cap_txtpart cap_txtpart1'>
<div class='cap_txt1 cap_txt11'>Note:</div>
<div class='cap_txt2 cap_txt22'>
<div> <a href='rating.php?ID={$r['userid']}&action=goodrating'><img src='images/thumbsup.gif' title='Mettre une bonne note'></a> <strong> {$r['ratings']} </strong> <a href='rating.php?ID={$r['userid']}&action=badrating'><img src='images/thumbsdown.gif' title='Mettre une mauvaise note'></a><br /></div>
</div>
</div>
<div class='cap_txtpart' style='padding-top:10px;'>
<div class='cap_txt1'>Propriété:</div>
<div class='cap_txt2'> {$r['hNAME']} </div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Argent:</div>
<div class='cap_txt2'>{$money}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Cristals:</div>
<div class='cap_txt2'>{$r['crystals']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Niveau:</div>
<div class='cap_txt2'>{$r['level']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Santé:</div>
<div class='cap_txt2'>{$r['hp']}/{$r['maxhp']} </div>
</div> ";
$rr=$db->query("SELECT * FROM referals WHERE refREFER={$r['userid']}");
$referal=$db->num_rows($rr);
print "
<div class='cap_txtpart'>
<div class='cap_txt1'>Amis:</div>
<div class='cap_txt2'>{$r['friend_count']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Ennemis:</div>
<div class='cap_txt2'>{$r['enemy_count']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Filleuls:</div>
<div class='cap_txt2'>$referal</div>
</div>
</div>
</div>
</div>
<div class='mem_conpart1_right'>
<div class='mem_rightbg1' >
<div class='mem_gangtxt' style='padding-left: 85px;'><img src='images/mem_gangtxt.jpg' alt='' style=';'/></div>
<div class='mem_clicktxt'>
";
if($r['gang'])
{
print " <a href='gangs.php?action=gang_view&gang_id={$r['gang']}'>{$r['gangNAME']} </a> ";
}
else
{
print "Aucun";
}
print" </div>
<div class='mem_right_imgpart'>
<!--<div class='money_img' style='background: url(./images/money_img.jpg) no-repeat; overflow: hidden; width: 210px; padding-top:100px;padding-buttom:66px;text-align:center;color:red;font-weight:bold;'>$5,250</div>-->
<div class='money_img' style='text-align:center;'><a href='voting.php'>{$money}<br /><img src='images/money_img.jpg' /></a></div>
<div class='estate_img' style='text-align:center;'><a href='estate.php'>
{$r['hNAME']}<br /><img src='images/estate_img.jpg' alt='Agent immobilier'/>
</a>
</div>
</div>
</div>
<div class='mem_rightbg2'>
<div class='useraction_txt'><img src='images/useraction_txt.jpg' alt='' /></div>
<div class='user_imgpart'>
<div class='user_leftimgpart'>
<div class='user_leftimg1'> <div align='left'> <a href='sendcash.php?ID={$r['userid']}'>Envoyer argent</a></div> </div> <div class='user_leftimg2'> <div align='left'> <a href='sendcrys.php?ID={$r['userid']}'>Envoyer cristals</a></div> </div> <div class='user_leftimg3'> <div align='centre'> <a href='attack.php?ID={$r['userid']}'>Attaquer</a> </div> </div> <div class='user_leftimg4'><div align='left'><a href='friendslist.php?action=add&ID={$r['userid']}'>Ajouter en ami</a></div></div><div class='user_rightimg5'><div align='left'><a href='mailbox.php?action=compose&ID={$r['userid']}'>Envoyer mail</a></div></div>
</div>
<div class='user_rightimgpart'>
<div class='user_rightimg1'> <div align='left'> <a href='killer.php'>Assassiner</a></div> </div> <div class='user_rightimg3'><div align='left'><a href='burnhouse.php?ID={$r['userid']}'>Brûler</a></div></div><div class='user_rightimg5'><div align='left'><a href='contactlist.php?action=add&ID={$r['userid']}'>Ajouter contact</a></div></div><div class='user_leftimg4'><div align='left'><a href='blacklist.php?action=add&ID={$r['userid']}'>Ajouter ennemi</a></div></div>
</div>
</div>
</div>
</div>
</div>
<div id='bubble' class='float_con' style='display:none; left: 100px; top: 400px;'>
<div id='bubblecaption' style='color:#BC1134'>CALLOUT</div>
<div id='bubbledescription' style='color:#BC1134'><img id='imgshow' style='width:102px;height:75px' src='#' /></div>
</div>
<div id='spy_pop_out' style='padding: 10px; display: none; position: absolute; left: 10%; top: 200px; width: 400px; height: 60px; z-index: 100; background-color: #000000; border: 5px solid #222222' class='generalinfo_simple'>
</div> ";
if($r['fedjail'])
{
print "<br />
<div class='cmt_tittxt'> </div><div><img src='images/generalinfo_top.jpg' alt='' /></div>
<div class='generalinfo_simple'>
<b><font color=red>Dans la prison fédérale pour {$r['fed_days']} jour(s). {$r['fed_reason']}</font></b>
</div>
<div><img src='images/generalinfo_btm.jpg' alt='' /></div><br>";
}
if($r['hospital'])
{
print "<br />
<div class='cmt_tittxt'> </div><div><img src='images/generalinfo_top.jpg' alt='' /></div>
<div class='generalinfo_simple'>
<b><font color=red>A l'hopital pour {$r['hospital']} minutes. {$r['hospreason']}</font></b>
</div>
<div><img src='images/generalinfo_btm.jpg' alt='' /></div><br>";
}
if($r['jail'])
{
print "<br />
<div class='cmt_tittxt'> </div><div><img src='images/generalinfo_top.jpg' alt='' /></div>
<div class='generalinfo_simple'><b><font color=red>En prison pour {$r['jail']} minutes. {$r['jail_reason']}</font></b>
</div>
<div><img src='images/generalinfo_btm.jpg' alt='' /></div>";
}
if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5)
{
$r['lastiph']=@gethostbyaddr($r['lastip']);
$r['lastiph']=checkblank($r['lastiph']);
$r['lastip_loginh']=@gethostbyaddr($r['lastip_login']);
$r['lastip_loginh']=checkblank($r['lastip_loginh']);
$r['lastip_signuph']=@gethostbyaddr($r['lastip_signup']);
$r['lastip_signuph']=checkblank($r['lastip_signuph']);
print " <style type='text/css'>
.style1 { text-align: center;}</style>
<div class='style1'><br> <br><h2>IP informations </div></h3>
<table width='80%' border='2' cellspacing='1' class='table'>
<tr><td></td><td class='h'>IP</td><td class='h'>Hostname</td></tr>
<tr><td class='h'>Last Hit</td><td>$r[lastip]</td><td>$r[lastiph]</td></tr>
<tr><td class='h'>Last Login</td><td>$r[lastip_login]</td><td>$r[lastip_loginh]</td></tr>
<tr><td class='h'>Signup</td><td>$r[lastip_signup]</td><td>$r[lastip_signuph]</td></tr></table>";
print "<form action='staffnotes.php' method='post'>
Notes des staffs: <br />
<textarea rows=4 cols=40 name='staffnotes'>{$r['staffnotes']}</textarea>
<br /><input type='hidden' name='ID' value='{$_GET['u']}' />
<input type='submit' STYLE='color: black; background-color: white;' value='Changer' /></form></div> ";
}
if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5)
{
print "
<div class='mem_rightbg2'>
<div class='useraction_txt'><img src='images/staff_links.gif' alt='' /></div>
<div class='user_imgpart'>
<div class='user_leftimgpart'>
<div class='user_rightimg5'> <div align='left'> <a href='jailuser.php?userid={$r['userid']}'>Emprisonner</a></div> </div>
</div>
<div class='user_rightimgpart'>
<div class='user_rightimg5'> <div align='left'> <a href='mailban.php?userid={$r['userid']}'>Ban Mail</a></div> </div>
<br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br>
</div>
</div>
</div>
</div>
</div>
<!-- //Member Profile Page End -->
</div>
</div></div>
</div>
</div>
</div>";
}
print '
<div class="usercmtpart">
<div><img src="images/usercomment_left.jpg" alt="" /></div>
<div class="usercmt_txtpart">
<div class="usercmt_left">Commentaires de l\'utilisateur</div>
<div class="usercmt_right"><a href=Comments.php?ID='.$_GET['u'].' >Ajouter un commentaire</a></div>
</div>
<div><img src="images/usercomment_right.jpg" alt="" /></div>
</div>
';
$Data = mysql_query("SELECT g.`ID`,g.`SenderID`,g.`RecieverID`,g.`Comment`,u.`userid`,u.`username` FROM `gComments` g LEFT JOIN `users` u "."ON g.`SenderID` = u.`userid` WHERE (`RecieverID` = ".abs(intval($_GET['u'])).")");
if(!mysql_num_rows($Data))
{
print "<br />
<div class='cmt_tittxt'> </div><div><img src='images/generalinfo_top.jpg' alt='' /></div>
<div class='generalinfo_simple'><b><font color=green>Cet utilisateur n'a pas de commentaires</font></b>
</div>
<div><img src='images/generalinfo_btm.jpg' alt='' /></div>" ;
exit($h->endpage());
}
else
{
while($cData = mysql_fetch_array($Data))
{
print '
<div class="cmt_tittxt"><a href=viewuser.php?u='.stripslashes($cData['userid']).'> '.htmlentities($cData['username']).' </a> dit :</div>
<div class="cmtbox_part"> ';
if($_SESSION['userid'] === $cData['RecieverID'])
{
print'
<div class="cmtbox_top" style="text-indent:400px;"> <a href = "/Comments.php?Delete&ID='.$cData['ID'].'"> Supprimer commentaire </a> </div> ';
}
else
{
print'
<div class="cmtbox_top" style="text-indent:400px;"> </div> ';
}
print '
<div class="cmtbox_md">
<div class="cmtcontent">'.stripslashes(htmlentities($cData['Comment'], ENT_QUOTES)).' </div>
</div>
<div><img src="images/cmtbox_btm.jpg" alt="" /></div>
</div><br>
<div class="nosign_line"><img src="images/sign_line.jpg" alt="" /> </div>
';
}
}
if($_SESSION['userid'] === $cData['RecieverID'])
{
echo ('
<td width = "10%" align = "center"> <a href = "/Comments.php?Delete&ID='.$cData['ID'].'"> <span style = "color:#8B0000">Supprimer</span></a></td>');
}
print "</tr></table>";
}
}
function checkblank($in)
{
if(!$in) { return "N/A"; }
return $in;
}
$h->endpage();
?>
Merci d'avance. 
Cordialement.
|
Admin
|
Bonjour,
Je ne suis pas sûr que le problème vient de là, mais essaye ça:
<?php
include "globals.php";
$_GET['u'] = abs((int) $_GET['u']);
if(!$_GET['u'])
{
print "Utilisation invalide du fichier";
}
else
{
$q=$db->query("SELECT u.*,us.*,c.*,h.*,g.*,f.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN cities c ON u.location=c.cityid LEFT JOIN houses h ON u.maxwill=h.hWILL LEFT JOIN gangs g ON g.gangID=u.gang LEFT JOIN fedjail f ON f.fed_userid=u.userid WHERE u.userid={$_GET['u']}");
if($db->num_rows($q) == 0)
{
print "Désolé, nous n'avons pas pu trouver un utilisateur avec cette ID, vérifiez vos sources.";
}
else
{
$r=$db->fetch_row($q);
if($r['user_level'] == 1) { $userl="Membre"; } else if($r['user_level'] == 2) { $userl="Administrateur"; } else if ($r['user_level'] == 3) { $userl="Modérateur"; } else if($r['user_level'] == 0) { $userl="Bot"; } else {$userl="Support"; }
$lon=($r['laston'] > 0) ?date('F j, Y g:i:s a',$r['laston']) : "Never";
$sup=date('F j, Y g:i:s a',$r['signedup']);
$ts=$r['strength']+$r['agility']+$r['guard']+$r['labour']+$r['IQ'];
$d="";
if($r['laston'] > 0)
{
$la=time()-$r['laston'];
$unit="secondes";
if($la >= 60)
{
$la=(int) ($la/60);
$unit="minutes";
}
if($la >= 60)
{
$la=(int) ($la/60);
$unit="heures";
if($la >= 24)
{
$la=(int) ($la/24);
$unit="jours";
}
}
$str="il y a $la $unit";
}
else
{
$str="--";
}
if($r['last_login'] > 0)
{
$ll=time()-$r['last_login'];
$unit2="secondes";
if($ll >= 60)
{
$ll=(int) ($ll/60);
$unit2="minutes";
}
if($ll >= 60)
{
$ll=(int) ($ll/60);
$unit2="heures";
if($ll >= 24)
{
$ll=(int) ($ll/24);
$unit2="jours";
}
}
$str2="il y a $ll $unit2";
}
else
{
$str2="--";
}
$money=money_formatter($r['money']);
if($r['donatordays']) { $r['username'] = "<font color=green>{$r['username']}</font>";$d="<img src='donator.gif' alt='Donateur: {$r['donatordays']} jours restants' title='Donateur: {$r['donatordays']} jours restants' />"; }
if($r['laston'] >= time()-15*60) { $on="images/online.gif"; } else { $on="images/offline.gif"; }
if($r['laston'] >= time()-15*60) { $status="En ligne"; } else { $status="Hors-Ligne"; }
print "
<div class='icolumn2' id='mainContentDiv'>
<div class='gangpage_container' style='margin-left:0px;'>
<!-- Member Profile Page Starts -->
<div class='member_toppart'>
<div class='bluetxt'>{$r['username']}</div>
<div class='blueimg'><img src='images/profilepage_txt.jpg' alt='' /></div>
</div>
<!-- Member Content Part Starts -->
<div class='mem_conpart1'>
<div class='mem_conpart1_left'>
<div class='con_txt1'>{$r['username']} <span>[{$r['userid']}] $d </span> </div>
<div class='online_btn'> <img src='$on' alt='$status' title='$status' style='float: left' /> </div>
<div class='respart'>
<div class='resimg_bg' style='padding-top:2px;position:relative;'>
<img src='{$r['display_pic']}' width='168' height='140' alt='Avatar' title='Avatar' style='float: left' />
<p class='occlusion'><img src='images/ze.png' alt='' /></p>
</div>
</div> ";
if($r['donatordays'] > 0)
{
print "
<div class='res_txtpart'>
<div class='restxt_bg'></div> ";
}
else
print " <br/> <br/> ";
print "
<b> ".get_gameranks($r['level'],$r['hPRICE'],$r)." </b>
<div class='leveltxt' style='background:url(./images/exp_100.gif);' style='float: left'>Niveau {$r['level']}</div>
<br/>
<div class='caption_part'>
<div class='cap_txtpart'>
<div class='cap_txt1'>Niveau:</div>
<div class='cap_txt2'>$userl</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Sexe:</div>
<div class='cap_txt2'>{$r['gender']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Statut:</div>
<div class='cap_txt2'><span><font color='#70cb00'><b><img src='$on' alt='$status' title='$status' /></b></font></span></div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Dernière activité:</div>
<div class='cap_txt2'>$str</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Jours d'ancienneté:</div>
<div class='cap_txt2'>{$r['daysold']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Ville:</div>
<div class='cap_txt2'>{$r['cityname']} [<a href='travel.php' style='color:#7EE800;'>Voyager</a>]</div>
</div>
<div class='cap_txtpart cap_txtpart1'>
<div class='cap_txt1 cap_txt11'>Note:</div>
<div class='cap_txt2 cap_txt22'>
<div> <a href='rating.php?ID={$r['userid']}&action=goodrating'><img src='images/thumbsup.gif' title='Mettre une bonne note'></a> <strong> {$r['ratings']} </strong> <a href='rating.php?ID={$r['userid']}&action=badrating'><img src='images/thumbsdown.gif' title='Mettre une mauvaise note'></a><br /></div>
</div>
</div>
<div class='cap_txtpart' style='padding-top:10px;'>
<div class='cap_txt1'>Propriété:</div>
<div class='cap_txt2'> {$r['hNAME']} </div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Argent:</div>
<div class='cap_txt2'>{$money}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Cristals:</div>
<div class='cap_txt2'>{$r['crystals']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Niveau:</div>
<div class='cap_txt2'>{$r['level']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Santé:</div>
<div class='cap_txt2'>{$r['hp']}/{$r['maxhp']} </div>
</div> ";
$rr=$db->query("SELECT * FROM referals WHERE refREFER={$r['userid']}");
$referal=$db->num_rows($rr);
print "
<div class='cap_txtpart'>
<div class='cap_txt1'>Amis:</div>
<div class='cap_txt2'>{$r['friend_count']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Ennemis:</div>
<div class='cap_txt2'>{$r['enemy_count']}</div>
</div>
<div class='cap_txtpart'>
<div class='cap_txt1'>Filleuls:</div>
<div class='cap_txt2'>$referal</div>
</div>
</div>
</div>
</div>
<div class='mem_conpart1_right'>
<div class='mem_rightbg1' >
<div class='mem_gangtxt' style='padding-left: 85px;'><img src='images/mem_gangtxt.jpg' alt='' style=';'/></div>
<div class='mem_clicktxt'>
";
if($r['gang'])
{
print " <a href='gangs.php?action=gang_view&gang_id={$r['gang']}'>{$r['gangNAME']} </a> ";
}
else
{
print "Aucun";
}
print" </div>
<div class='mem_right_imgpart'>
<!--<div class='money_img' style='background: url(./images/money_img.jpg) no-repeat; overflow: hidden; width: 210px; padding-top:100px;padding-buttom:66px;text-align:center;color:red;font-weight:bold;'>$5,250</div>-->
<div class='money_img' style='text-align:center;'><a href='voting.php'>{$money}<br /><img src='images/money_img.jpg' /></a></div>
<div class='estate_img' style='text-align:center;'><a href='estate.php'>
{$r['hNAME']}<br /><img src='images/estate_img.jpg' alt='Agent immobilier'/>
</a>
</div>
</div>
</div>
<div class='mem_rightbg2'>
<div class='useraction_txt'><img src='images/useraction_txt.jpg' alt='' /></div>
<div class='user_imgpart'>
<div class='user_leftimgpart'>
<div class='user_leftimg1'> <div align='left'> <a href='sendcash.php?ID={$r['userid']}'>Envoyer argent</a></div> </div> <div class='user_leftimg2'> <div align='left'> <a href='sendcrys.php?ID={$r['userid']}'>Envoyer cristals</a></div> </div> <div class='user_leftimg3'> <div align='centre'> <a href='attack.php?ID={$r['userid']}'>Attaquer</a> </div> </div> <div class='user_leftimg4'><div align='left'><a href='friendslist.php?action=add&ID={$r['userid']}'>Ajouter en ami</a></div></div><div class='user_rightimg5'><div align='left'><a href='mailbox.php?action=compose&ID={$r['userid']}'>Envoyer mail</a></div></div>
</div>
<div class='user_rightimgpart'>
<div class='user_rightimg1'> <div align='left'> <a href='killer.php'>Assassiner</a></div> </div> <div class='user_rightimg3'><div align='left'><a href='burnhouse.php?ID={$r['userid']}'>Brûler</a></div></div><div class='user_rightimg5'><div align='left'><a href='contactlist.php?action=add&ID={$r['userid']}'>Ajouter contact</a></div></div><div class='user_leftimg4'><div align='left'><a href='blacklist.php?action=add&ID={$r['userid']}'>Ajouter ennemi</a></div></div>
</div>
</div>
</div>
</div>
</div>
<div id='bubble' class='float_con' style='display:none; left: 100px; top: 400px;'>
<div id='bubblecaption' style='color:#BC1134'>CALLOUT</div>
<div id='bubbledescription' style='color:#BC1134'><img id='imgshow' style='width:102px;height:75px' src='#' /></div>
</div>
<div id='spy_pop_out' style='padding: 10px; display: none; position: absolute; left: 10%; top: 200px; width: 400px; height: 60px; z-index: 100; background-color: #000000; border: 5px solid #222222' class='generalinfo_simple'>
</div> ";
if($r['fedjail'])
{
print "<br />
<div class='cmt_tittxt'> </div><div><img src='images/generalinfo_top.jpg' alt='' /></div>
<div class='generalinfo_simple'>
<b><font color=red>Dans la prison fédérale pour {$r['fed_days']} jour(s). {$r['fed_reason']}</font></b>
</div>
<div><img src='images/generalinfo_btm.jpg' alt='' /></div><br>";
}
if($r['hospital'])
{
print "<br />
<div class='cmt_tittxt'> </div><div><img src='images/generalinfo_top.jpg' alt='' /></div>
<div class='generalinfo_simple'>
<b><font color=red>A l'hopital pour {$r['hospital']} minutes. {$r['hospreason']}</font></b>
</div>
<div><img src='images/generalinfo_btm.jpg' alt='' /></div><br>";
}
if($r['jail'])
{
print "<br />
<div class='cmt_tittxt'> </div><div><img src='images/generalinfo_top.jpg' alt='' /></div>
<div class='generalinfo_simple'><b><font color=red>En prison pour {$r['jail']} minutes. {$r['jail_reason']}</font></b>
</div>
<div><img src='images/generalinfo_btm.jpg' alt='' /></div>";
}
if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5)
{
$r['lastiph']=@gethostbyaddr($r['lastip']);
$r['lastiph']=checkblank($r['lastiph']);
$r['lastip_loginh']=@gethostbyaddr($r['lastip_login']);
$r['lastip_loginh']=checkblank($r['lastip_loginh']);
$r['lastip_signuph']=@gethostbyaddr($r['lastip_signup']);
$r['lastip_signuph']=checkblank($r['lastip_signuph']);
print " <style type='text/css'>
.style1 { text-align: center;}</style>
<div class='style1'><br> <br><h2>IP informations </div></h3>
<table width='80%' border='2' cellspacing='1' class='table'>
<tr><td></td><td class='h'>IP</td><td class='h'>Hostname</td></tr>
<tr><td class='h'>Last Hit</td><td>$r[lastip]</td><td>$r[lastiph]</td></tr>
<tr><td class='h'>Last Login</td><td>$r[lastip_login]</td><td>$r[lastip_loginh]</td></tr>
<tr><td class='h'>Signup</td><td>$r[lastip_signup]</td><td>$r[lastip_signuph]</td></tr></table>";
print "<form action='staffnotes.php' method='post'>
Notes des staffs: <br />
<textarea rows=4 cols=40 name='staffnotes'>{$r['staffnotes']}</textarea>
<br /><input type='hidden' name='ID' value='{$_GET['u']}' />
<input type='submit' STYLE='color: black; background-color: white;' value='Changer' /></form></div> ";
}
if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5)
{
print "
<div class='mem_rightbg2'>
<div class='useraction_txt'><img src='images/staff_links.gif' alt='' /></div>
<div class='user_imgpart'>
<div class='user_leftimgpart'>
<div class='user_rightimg5'> <div align='left'> <a href='jailuser.php?userid={$r['userid']}'>Emprisonner</a></div> </div>
</div>
<div class='user_rightimgpart'>
<div class='user_rightimg5'> <div align='left'> <a href='mailban.php?userid={$r['userid']}'>Ban Mail</a></div> </div>
<br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br>
</div>
</div>
</div>
</div>
</div>
<!-- //Member Profile Page End -->
</div>
</div></div>
</div>
</div>
</div>";
}
print '
<div class="usercmtpart">
<div><img src="images/usercomment_left.jpg" alt="" /></div>
<div class="usercmt_txtpart">
<div class="usercmt_left">Commentaires de l\'utilisateur</div>
<div class="usercmt_right"><a href=Comments.php?ID='.$_GET['u'].' >Ajouter un commentaire</a></div>
</div>
<div><img src="images/usercomment_right.jpg" alt="" /></div>
</div>
';
$data = $db->query("SELECT g.`ID`,g.`SenderID`,g.`RecieverID`,g.`Comment`,u.`userid`,u.`username` FROM `gComments` g LEFT JOIN `users` u "."ON g.`SenderID` = u.`userid` WHERE (`RecieverID` = ".abs(intval($_GET['u'])).")");
if($db->num_rows($data)==0)
{
print "<br />
<div class='cmt_tittxt'> </div><div><img src='images/generalinfo_top.jpg' alt='' /></div>
<div class='generalinfo_simple'><b><font color=green>Cet utilisateur n'a pas de commentaires</font></b>
</div>
<div><img src='images/generalinfo_btm.jpg' alt='' /></div>" ;
exit($h->endpage());
}
else
{
while($cData = mysql_fetch_array($Data))
{
print '
<div class="cmt_tittxt"><a href=viewuser.php?u='.stripslashes($cData['userid']).'> '.htmlentities($cData['username']).' </a> dit :</div>
<div class="cmtbox_part"> ';
if($_SESSION['userid'] === $cData['RecieverID'])
{
print'
<div class="cmtbox_top" style="text-indent:400px;"> <a href = "/Comments.php?Delete&ID='.$cData['ID'].'"> Supprimer commentaire </a> </div> ';
}
else
{
print'
<div class="cmtbox_top" style="text-indent:400px;"> </div> ';
}
print '
<div class="cmtbox_md">
<div class="cmtcontent">'.stripslashes(htmlentities($cData['Comment'], ENT_QUOTES)).' </div>
</div>
<div><img src="images/cmtbox_btm.jpg" alt="" /></div>
</div><br>
<div class="nosign_line"><img src="images/sign_line.jpg" alt="" /> </div>
';
}
}
if($_SESSION['userid'] === $cData['RecieverID'])
{
echo ('
<td width = "10%" align = "center"> <a href = "/Comments.php?Delete&ID='.$cData['ID'].'"> <span style = "color:#8B0000">Supprimer</span></a></td>');
}
print "</tr></table>";
}
}
function checkblank($in)
{
if(!$in) { return "N/A"; }
return $in;
}
$h->endpage();
?>
Cordialement
 |
Membre
|
Bonjour,
Maintenant j'ai cette erreur :
QUERY ERROR: TABLE 'mafiapar_game.gComments' doesn't exist
Query was SELECT g.`ID`,g.`SenderID`,g.`RecieverID`,g.`Comment`,u.`userid`,u.`username` FROM `Comments` g LEFT JOIN `users` u ON g.`SenderID` = u.`userid` WHERE (`RecieverID` = 1)
|
Membre
|
QUERY ERROR: TABLE 'mafiapar_game.gComments' doesn't exist
LA table demander existe pas ..
https://guerredesgangs.net & http://www.bazinio.ca & http://www.thestreet2.ca
|
Membre
|
Sauf, que dans l'ancien script je n'avais pas cette erreur
Or, il contient FROM `gComments`
|
Membre
|
Bah la je saus pas dire je connais pas les joins j'en utulise pas mais je croit vais devoir apprendre pour un truk la que je bloke arf mdr
https://guerredesgangs.net & http://www.bazinio.ca & http://www.thestreet2.ca
|
