Posts by xxx

xxx

Post je login en je loggedin eens

xxx

Lars, kijk mijn hoofdpost

xxx

Ik ben bezig met een familiebericht script. Aan het ombouwen vanuit Messages. Ik heb tot nu toe dit:

PHP

<?
$mededeling1 = mysql_query("SELECT * FROM `messages` WHERE `to`='$data->login' AND `inbox`='1' AND `read`='0'");
$mededeling = mysql_num_rows($mededeling1);
$inbox1 = mysql_query("SELECT * FROM `messages` WHERE `to`='$data->login' AND `inbox`='1' AND `read`='0'");
$inbox = mysql_num_rows($inbox1);
if(!isset($_GET['box'])){
$box = 1;
}
if($_GET['box'] == system){
$box = 2;
}
if($_GET['box'] == sent){
$box = 3;
}
?>
<?
if($data->gast == 1){
?>
<table width="100%">
    <tr>
        <td align="center">
            <br><br><br><br>
            <table class="div_popup_error" align="center">
                <tr>
                    <td style="color:red">
                        <b>FOUT!</b><br><br>Je bent een gast, om berichten te sturen moet je een account maken!                    </td>
                </tr>
                <tr>
                    <td>
                        <br><br>
                                                    <a href="#" onclick="history.go(-1); return false" class="error_ok">OK</a>
                                            </td>
                </tr>
            </table>
        </td>
    </tr>
</table>
        </div>
    </td>
    </tr>


    </table>
    </td>
<? } ?>


<? if($data->gast == 0) { ?>
            <div class="title_bg">
            <div class="title">Privé berichten</div>
        </div>


        <div style="background-color:#dbd2b7; padding:10px; padding-top:4px;">
        <table cellpadding="0" cellspacing="0" width="100%"><tr><td>
            <table width="97%">
        <tr>
            <td width="20%" align="center">
                <img src="images/mail_new.png" border="0px" align="absmiddle">
                <a href="index.php?a=familiepb&box=new"><b>Nieuw bericht</b></a>
            </td>


        </tr>
        <tr>
            <td colspan="5">
                <hr>
                <!-- INBOX -->
<?
if(isset($_GET['sendmessage'])){
?>
                                <table width="100%">
                    <tr>
                        <td>
<?
if(isset($_POST['verzenden'])){
$blacklist1                = mysql_query("SELECT * FROM `contacts` WHERE `level`='0' AND `owner`='{$_POST['to']}' AND `person`='$data->login'");
$blacklist = mysql_num_rows($blacklist1);
if($blacklist < 1){
$date2 = (date('m/d H:i'));
$to = $_POST['to'];
$subject = $_POST['subject'];
$content = $_POST['content'];
$_SESSION['mission'] = "Stuur iemand een Privé bericht";
        mysql_query("INSERT INTO `messages`(`date`,`echo $data3->username;`,`from`,`ip`,`title`,`content`,`date2`,`read`,`inbox`,`reply`) values(NOW(),'' ','$data->login','$data->ip','$subject','$content','$date2','0','1','{$_GET['reply']}')");
        mysql_query("INSERT INTO `messages`(`date`,`echo $data3->username;`,`from`,`ip`,`title`,`content`,`date2`,`read`,`inbox`,`reply`) values(NOW(),'$to','$data->login','$data->ip','$subject','$content','$date2','0','3','{$_GET['reply']}')");
$contact1 = mysql_query("SELECT * FROM `contacts` WHERE `owner`='$data->login' AND `person`='{$_POST['to']}'");
$contact = mysql_num_rows($contact1);
if($contact < 1){
if(isset($_POST['add_friend'])){
        mysql_query("INSERT INTO `contacts`(`person`,`owner`) values( '{$_POST['to']}','$data->login')");
}
}
}
}
if($blacklist < 1){
?>


                            Het bericht is verstuurd.
<?
}
else{
?>


       <? echo $_POST['to']; ?> heeft jou in zijn blacklist staan!
<?
}
if(!isset($_POST['verzenden'])){
?>
                            Het bericht is<b> niet</b> verstuurd.
<?
}
?>
                                           </td>
                    </tr>
                </table>


            </td>
<?
}
if(isset($_GET['del'])){
mysql_query("DELETE FROM `messages` WHERE `id`='{$_GET['del']}' AND `to`='$data->login'");
mysql_query("DELETE FROM `messages` WHERE `id`='{$_GET['del']}' AND `from`='$data->login' AND `inbox`='3'");
}
if(isset($_GET['clear'])){
mysql_query("DELETE FROM `messages` WHERE `to`='$data->login'");
mysql_query("DELETE FROM `messages` WHERE `from`='$data->login' AND `inbox`='3'");}
if($_GET['box'] != "new"){
if(!isset($_GET['sendmessage'])){
if(!isset($_GET['x']))
{
?>
                                <table width='100%' border='0' class='mod_list' cellspacing='2' cellpadding='2' align='center'>
                    <tr>
                        <td width='5%' align='center'>#</td>
                        <td width=5%></td>
                        <td width='50%' align='left'><b>Onderwerp</b></td>
                        <td width='20%' align='left'><b>Verzender</b></td>
                        <td width='15%' align='left'><b>Datum</b></td>
                        <td width=5%></td>
                    </tr>
<?
$begin = ($_GET['p'] >= 0) ? $_GET['p']*15 : 0;
if($_GET['box'] == ""){
$message1 = mysql_query("SELECT * FROM `messages` WHERE `to`='$data->login'");
$msg1 = mysql_query("SELECT * FROM `messages` WHERE `to`='$data->login' AND `inbox`='1'");
    $dbres                = mysql_query("SELECT * FROM `messages` WHERE `to`='$data->login' AND `inbox`='1' ORDER BY `date` LIMIT $begin,15");
}
if($_GET['box'] == "system"){
$message1 = mysql_query("SELECT * FROM `messages` WHERE `to`='$data->login'");
$msg1 = mysql_query("SELECT * FROM `messages` WHERE `to`='$data->login' AND `inbox`='2'");
    $dbres                = mysql_query("SELECT * FROM `messages` WHERE `to`='$data->login' AND `inbox`='2' ORDER BY `date` LIMIT $begin,15");
}
if($_GET['box'] == "sent"){
$message1 = mysql_query("SELECT * FROM `messages` WHERE `from`='$data->login'");
$msg1 = mysql_query("SELECT * FROM `messages` WHERE `from`='$data->login' AND `inbox`='3'");
    $dbres                = mysql_query("SELECT * FROM `messages` WHERE `from`='$data->login' AND `inbox`='3' ORDER BY `date` LIMIT $begin,15");
}
  for($j=$begin+1; $info = mysql_fetch_object($dbres); $j++)
{
$message = mysql_fetch_object($message1);
$msgcount = mysql_num_rows($message1);
$mscountfix = $message1;
$msg = mysql_num_rows($msg1);
$pages = floor($msg/15+1);
$poster1 = mysql_query("SELECT * FROM `users` WHERE `login`='$info->from'");
$poster = mysql_fetch_object($poster1);
$schammel                = mysql_query("SELECT * FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 AND `login`='$poster->login'");
$online = mysql_fetch_object($schammel);
?>
                                        <tr>
                        <td align="center"><? echo $j; ?></td>
                        <td align="center">
<?if($info->read == 0){?>
                                                            <img title="Niet gelezen" src="images/icons_gif/email_open.gif">
<?
}
if($info->read == 1){?>
                                                            <img title="Gelezen" src="images/mail.png">
<?
}
?>


                                                    </td>
                        <td><a href="index.php?a=familiepb&x=<? echo $info->id; ?>"><? echo $info->title; ?></a></td>
                        <td>
<?if($online->login == $poster->login){?><img src="images/icons_gif/status_online.gif" title="Online"><?}?><?if($online->login != $poster->login){?><img src="images/icons_gif/status_offline.gif" title="Offline"><?}?> <a href="index.php?a=profile&x=<? echo $poster->id; ?>"><? echo $poster->login; ?></a>
                                                    </td>
                        <td><? echo $info->date2; ?></td>
                        <td align="center">
                            <a href="index.php?a=familiepb&del=<? echo $info->id; ?>"><img src='images/delete.png' border='0' alt='Verwijderen'></a>
                        </td>
<?
}
?>
                    </tr>
                                    </table>
<?
}else{
$openmessage3 = mysql_query("SELECT * FROM `messages` WHERE `from`='$data->login' AND `id`='{$_GET['x']}'");
$openmessage2 = mysql_fetch_object($openmessage3);
if($openmessage2->inbox != 3){
$openmessage1 = mysql_query("SELECT * FROM `messages` WHERE `to`='$data->login' AND `id`='{$_GET['x']}'");
}
else{
$openmessage1 = mysql_query("SELECT * FROM `messages` WHERE `from`='$data->login' AND `id`='{$_GET['x']}'");
}
$openmessage = mysql_fetch_object($openmessage1);
$sentuser1 = mysql_query("SELECT * FROM `users` WHERE `login`='$openmessage->from'");
$sentuser = mysql_fetch_object($sentuser1);
if($openmessage2->inbox != 3){
mysql_query("UPDATE `messages` SET `read`='1' WHERE `id`='{$_GET['x']}' AND `to`='$data->login'");
}
else{
mysql_query("UPDATE `messages` SET `read`='1' WHERE `id`='{$_GET['x']}' AND `from`='$data->login'");
}
?>


                <!-- MEDEDELINGEN -->


                <!-- VERZONDEN -->


                <!-- OPEN BERICHT -->
<br>
                <table width="100%">
                    <tr>
                        <td><b>Van</b>:</td>
                        <td>
                            <? echo $openmessage->from; ?>                                    [<a href="index.php?a=blacklist&x=<? echo $sentuser->id; ?>">Blacklist</a>]


                    </tr>
                    <tr>
                        <td><b>Datum</b>:</td>
                        <td><? echo $openmessage->date; ?></td>
                    </tr>
                    <tr>
                        <td><b>Aan</b>:</td>
<td><?if($openmessage->inbox != 3){echo $openmessage->to;}else{echo $openmessage->to2;}?></td>
                    </tr>
                    <tr>
                        <td><b>Onderwerp</b>:</td>
                        <td>
                            <? echo $openmessage->title; ?>                        </td>
                    </tr>
                    <tr>
                        <td colspan="2"><hr></td>
                    </tr>


                    <tr>
                        <td colspan="2">
                        <? echo $openmessage->content; ?>
                        </td>
                    </tr>
<?if($openmessage->reply != -1){?>
                                        <tr>
                        <td colspan="2" align="right">
                    <form method="POST" action="index.php?a=familiepb&box=new&reply=<? echo $openmessage->id; ?>" onsubmit="return checkError(this);">
                            <input type="submit" class="mod_submit" value="Antwoorden" name="answer">
                    </form>
                        </td>
                    </tr>
<?}?>
                                    </table>


            </td>
        </tr>
<?}}}?>
                <!-- NIEUW BERICHT -->
<?
if($_GET['box'] == "new"){
if(isset($_POST['answer'])){
if(!isset($_GET['reply'])){
$isreply = 0;
}
if(isset($_GET['reply'])){
$isreply = 1;
$reply1 = mysql_query("SELECT * FROM `messages` WHERE `id`='{$_GET['reply']}'");
$reply = mysql_fetch_object($reply1);
}
}
else{
$isreply = 0;
}
$data0            = mysql_query("SELECT `familie` FROM `users` WHERE `login`='$data->login'");
$data1            = mysql_fetch_object($data0);


$data2            = mysql_query("SELECT `username` FROM `users` WHERE `familie`='$data1->familie'");


while($data3=mysql_fetch_object($data2)){


}
?>


                <script language="javascript">
                    var contact_book;


                    function check_contact(){
                        if(document.getElementById('contact').value != '') document.getElementById('to').value = document.getElementById('contact')[document.getElementById('contact').options.selectedIndex].text;
                        document.getElementById('to').readOnly = (document.getElementById('contact').value != '');
                    }


                    function select_user_popup(pUser){
                        document.getElementById('to').value = pUser;
                        contact_book.close();
                        document.getElementById('contact').options.selectedIndex = 0;
                        document.getElementById('to').readOnly = false;
                    }


                </script>
                <table width="100%">
                    <form method="POST" action="index.php?a=familiepb&sendmessage&reply=<? echo $isreply; ?>" onsubmit="return checkError(this);">
<?
$dbres = mysql_query("SELECT * FROM `contacts` WHERE `owner`='$data->login' AND `level`='1'");
?>


                        </td>
                        <td>


<?
  for($j=$begin+1; $info = mysql_fetch_object($dbres); $j++)
{
$friend1 = mysql_query("SELECT * FROM `users` WHERE `login`='$info->person'");
$friend = mysql_fetch_object($friend1);
?>


<?
}
?>
                                                            </select>
                                                    </td>
                    </tr>
                    <tr>
                        <td>Onderwerp:</td>
                        <td>
<?
if($isreply == 1){?>
                            <input type="text" name="subject" size="25" value="Re: <? echo $reply->title; ?>">
<?
}
else{?>
                            <input type="text" name="subject" size="25" value="">
<?
}
?>
                        </td>
                        <td>&nbsp;</td>
                    </tr>
                    <tr>
                        <td colspan="3">
                            <hr>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="3">
<?
if($isreply == 1){
        $reply->content         = str_replace("[quote]", "",$reply->content);
        $reply->content         = str_replace("[/quote]", "",$reply->content);
?>
                            <textarea name="content" style="width:100%" rows="7">[quote]<? echo $reply->content; ?>[/quote]</textarea>
<?
}
else{?>
                            <textarea name="content" style="width:100%" rows="7"></textarea>
<?
}
?>


                        </td>
                    </tr>
                    <tr>
                        <td colspan="3">


                    </tr>
                    <tr>
                        <td colspan="3">
                            <input type="submit" class="mod_submit" name="verzenden" value="Versturen">
                        </td>
                    </tr>
                    </form>
                </table>
<?
}
?>


                <script language="javascript">
                    function checkError(pForm){
                        var errormsg = '';


                        if(pForm.subject.value == '') errormsg += 'Er is geen onderwerp ingevuld!<br>';
                        if(pForm.to.value == '') errormsg += 'Er is geen ontvanger ingevuld!<br>';
                        if(pForm.content.value == '') errormsg += 'Er is geen inhoud ingevuld!<br>';


                        if(errormsg != ''){
                            showError(errormsg);
                            return false;
                        }
                        return true;
                    }
                </script>










                <!-- BERICHT COMMUNICATIE -->
            </td>
        </tr>










<?
if(!isset($_GET['x']))
{
if($_GET['box'] != "new"){
if($pages > 1){
$prev = $_GET['p']-1;
$next = $_GET['p']+1;
if($_GET['box'] == ""){
$dbres = mysql_query("SELECT * FROM `messages` WHERE `to`='$data->login' AND `inbox`='1'");
}
if($_GET['box'] == system){
$dbres = mysql_query("SELECT * FROM `messages` WHERE `to`='$data->login' AND `inbox`='2'");
}
if($_GET['box'] == sent){
$dbres = mysql_query("SELECT * FROM `messages` WHERE `from`='$data->login' AND `inbox`='3'");
}
  print "</table>nn<table width=100%>n  <tr><td class=\"mainTxt\" align=\"center\">";
  if(mysql_num_rows($dbres) <= -1) {
    print "< 1 ></td></tr></table>n";
    }
  else {
    if($begin/15 == 0) {
      print "<< Vorige | ";
      }
    else {
      print "<a href=\"index.php?a=message&box={$_GET['box']}&p=". ($begin/15-1) ."\"><< Vorige</a> | ";
}
    for($i=0; $i<mysql_num_rows($dbres)/15; $i++) {
$j = $i+1;
      print "<a href=\"index.php?a=familiepb&box={$_GET['box']}&p=$i\">$j</a> | ";
    }


    if($begin+15 >= mysql_num_rows($dbres)) {
      print "Volgende >> ";
      }
    else {
      print "<a href=\"index.php?a=familiepb&box={$_GET['box']}&p=". ($begin/15+1) ."\">Volgende >></a>";
  }
  }
  }
  }
  }
?>


                                                </td>
            </tr>
    </table>
        </td></tr></table>
        </div>


        <table width='100%' cellspacing='2' cellpadding='2'>
            <tr>


                <td class='content_bottom'></td>
            </tr>
        </table>
                </div>
    </td>
    </tr>




    </td>
<? } ?>


</table>

Toon Meer

Lars ik heb dat van jou gebruikt maar dan werkt het nog niet.

xxx

Nice!
Die ga ik zeker gebruiken!

xxx

Ik zou de downloadlink even goedmaken en zal ook even kijken of ik de andere kan unbuggen.

xxx

Lees mijn script die ik hier al een keer gepost heb, staat onder scripts. Dat is het familiebeheer zonder +- bugs

xxx

beetje weg te

xxx

weer terug naar

xxx

Daarna ga je

xxx

Sorry dan kan ik je niet helpen:cheer:
Succes nog!

xxx

Ik weet niet wat er fout aan is maar in welk bestandje staat dit? Dan kan ik je de goede geven

xxx

[offtopic]

Citaat van Frenzo

Zo iets had ik al eens gemaakt

Dat vind ik een knap lullige reactie. Iemand probeert een keer wat leuks te doen, dan krijg je een reactie van: Zo iets had ik ook al gemakt. Als ik zo'n reactie kreeg dan zou ik denken van: Ow, iemand anders heeft het vast al gemaakt. Hoef ik het ook niet meer te doen [/offtopic]

Ik zal het downloaden. Kijken of hij leuk staat op mijn site!

xxx

Ik vind er niks doms aan. Het kan best zo zijn hoor.

xxx

Bestaan je tabellen in je database?

xxx

Nee, nog niet ben nog zoekende(a)

xxx

Jammer dat jullie weggaan. Dat is altijd jammer als er iemand weggaat

xxx

@ YVMdesign,
Dat is als je bijvoorbeeld -99999 invult dan 99999 krijgt

Nieuwe reactie samengevoegd met originele reactie op 20.01.10 17:12:47:

Citaat van Duvelke

rangen verrander bug zit er nog in
en als je nu doneert staat er niet bijvoorbeeld je hebt het bedrag naar de familieover gemaakt
dat is ook vrij irri
mvg Duveke

Over dat rangen veranderen bug,
wat is de bug en hoe gebruik je hem? Dan weet ik waar hij zit

xxx

@ Duvelke, zal zometeen wel even kijken.

xxx

Ohja, heb ik er ook nog bijgezet op regel 16 ipv isset

xxx

Sorry Db-maffia, over het hoofd gezien.
Dit is er toegevoegd op rij 21,22 en 23

PHP

}
if($data->contant <= $doneer){
$error = 1;}