Jump to content
MakeWebGames

[v1]Need abit of help with anouncements


TheMafia!
 Share

Recommended Posts

I need abit of help with anouncements on mainmenu

 

• <a href='ann.php' title='See the announcements.'>";
@$d=mysql_query("SELECT * FROM annoucements WHERE id={$ir['id']} AND id=0",$c);
if (@mysql_num_rows($d) > 0)
{
print "<font color=red>[b]Anouncements (".mysql_num_rows($d).")</font>[/b]";
}
else
{
print "Anouncements(0)";
}
print "</a>

 

i want it so when i post an announcement it turns red

i think its the query...

any help appreciated

Link to comment
Share on other sites

Re: [v1]Need abit of help with anouncements

 

wtf are the @ for?

take those out.......

and thats if your code is right.....

If I'm right, the @ operator is to echo errors if the code is unable to do it's job properly (could be wrong)..

 

<?php
/*
For this method, you would have to make an edit to the Admin Panel and the announcement.php.
*/

// Admin Panel edit
// Add under the query that inserts the announcement into the database.
mysql_query("UPDATE users SET new_announcements = new_announcements + 1") or die(mysql_error());

// Add in the announcement.php, underneath "print $content;"
$sql = sprintf("UPDATE users SET new_announcements = 0 WHERE (userid = %u)", $userid);
mysql_query($sql) or die(mysql_error());

// Then, the mainmenu edit is the same as the v2 version (posted below)
?>

 

<?php
// To be honest, I don't know.. I don't have a v1 source. That's on my 8gb pendrive.
// If anyone finds my pendrive, I'll give you ?10! xD
?>

 

<?php
echo sprintf("[url='ann.php']%s (%u)[/url]", $ir['new_announcements'] ? "<span style='color:red;'>Announcements</span>" : "Announcements", $ir['new_announcements']);
?>
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...