Multiple rows in mysql

  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

Well first there's no use a parameter to pass in delete comment function.

$database->DeleteComment("del"); (in the call)

function DeleteProfileComment($del){ (in the class)

you can do this

$database->DeleteComment("del"); )

function DeleteProfileComment($del){ ()

Because $_GET is a superglobal and can be accesses from any where and any context.

just do this :

PHP Code: [ Select ]
 
$q = "DELETE FROM ".TBL_COMMENTS." WHERE ID_FIELD = ".$_GET["del"]." LIMIT 1";  
 
 
  1.  
  2. $q = "DELETE FROM ".TBL_COMMENTS." WHERE ID_FIELD = ".$_GET["del"]." LIMIT 1";  
  3.  
  4.  

and no parameter for the function , that'll be enough.

Anyway that's not the problem that can work.

In fact the problem seems to be in the comment deleting link .

You use $data["id_comment"] but that was just a generic example, in fact you told be that you had an ID system for the comment but I've got no idea of how you get it just before that's why I put $data["id_comment"] as an example.
I assumed that you retrieved in the same query that retrieves the comments informations.
You should do so anyway, and change my example $data[« id_comment »] by the right value something like $req_user_postusername['something'] (something =>name of the id field)

Ask any question ;-)
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

you have lost me. i am confused on what you are saying. from the code that i put on here can you give me the code to put in?
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

here, see I replaced $data["id_comment"] in that part by $req_user_postusername['comment_id'].
But all is left to do, is replace comment_id by the real name of the ID field in the comment table. In fact I've got no idea of the name you gave to it in the database.
SO the right value will be in that link so that the right value will be passed $_GET["del"]
PHP Code: [ Select ]
 
//...  
 
if(isset($_GET["del"]))  
 
$database->DeleteComment("del");
 
 ?> <?php  
 
          while($req_user_postusername = mysql_fetch_array($rs_pointer))  
 
          {  
 
echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>
 
 <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />
 
   <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br><a href=\"".$_SERVER["PHP_SELF"]."?del=".$req_user_postusername['comment_id']."\">Delete Comment</a></span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>
 
 
 
 
 
";
 
 
 
           }  
 
 
  1.  
  2. //...  
  3.  
  4. if(isset($_GET["del"]))  
  5.  
  6. $database->DeleteComment("del");
  7.  
  8.  ?> <?php  
  9.  
  10.           while($req_user_postusername = mysql_fetch_array($rs_pointer))  
  11.  
  12.           {  
  13.  
  14. echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>
  15.  
  16.  <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />
  17.  
  18.    <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br><a href=\"".$_SERVER["PHP_SELF"]."?del=".$req_user_postusername['comment_id']."\">Delete Comment</a></span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>
  19.  
  20.  
  21.  
  22.  
  23.  
  24. ";
  25.  
  26.  
  27.  
  28.            }  
  29.  
  30.  
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

ok it will come up with the comment id number but when i click on delete it does nothing and comes up to http://www.gothicgreenwire.com/mycomments.php?del=114 and it says username not registured because it need to say http://www.gothicgreenwire.com/mycommen ... user=admin or what ever there username is.

here is the database php
PHP Code: [ Select ]
function DeleteProfileComment($del){
 
      $q = "DELETE FROM ".TBL_COMMENTS." WHERE id = ".$_GET[$del]." LIMIT 1";  
 
       return mysql_query($q, $this->connection);  
 
      }
  1. function DeleteProfileComment($del){
  2.  
  3.       $q = "DELETE FROM ".TBL_COMMENTS." WHERE id = ".$_GET[$del]." LIMIT 1";  
  4.  
  5.        return mysql_query($q, $this->connection);  
  6.  
  7.       }


here is the mycomments php
PHP Code: [ Select ]
<?php //...  
 
if(isset($_GET["del"]))  
 
$database->DeleteComment("del");  
 
 ?> <?php  
 
          while($req_user_postusername = mysql_fetch_array($rs_pointer))  
 
          {  
 
echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>  
 
 <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />  
 
   <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br><a href=\"".$_SERVER["PHP_SELF"]."?del=".$req_user_postusername['id']."\">Delete Comment</a></span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>  
 
 
 
 
 
";  
 
 
 
           } ?>
  1. <?php //...  
  2.  
  3. if(isset($_GET["del"]))  
  4.  
  5. $database->DeleteComment("del");  
  6.  
  7.  ?> <?php  
  8.  
  9.           while($req_user_postusername = mysql_fetch_array($rs_pointer))  
  10.  
  11.           {  
  12.  
  13. echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>  
  14.  
  15.  <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />  
  16.  
  17.    <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br><a href=\"".$_SERVER["PHP_SELF"]."?del=".$req_user_postusername['id']."\">Delete Comment</a></span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>  
  18.  
  19.  
  20.  
  21.  
  22.  
  23. ";  
  24.  
  25.  
  26.  
  27.            } ?>
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

So no problem just add also this parameter in the target url :
PHP Code: [ Select ]
 
//...  
 
if(isset($_GET["del"]))  
 
$database->DeleteComment("del");
 
 ?> <?php  
 
          while($req_user_postusername = mysql_fetch_array($rs_pointer))  
 
          {  
 
echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>
 
 <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />
 
   <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br><a href=\"".$_SERVER["PHP_SELF"]."?user=".$req_user_postusername['username']."&amp;del=".$req_user_postusername['comment_id']."\">Delete Comment</a></span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>
 
 
 
 
 
";
 
 
 
           }  
 
 
  1.  
  2. //...  
  3.  
  4. if(isset($_GET["del"]))  
  5.  
  6. $database->DeleteComment("del");
  7.  
  8.  ?> <?php  
  9.  
  10.           while($req_user_postusername = mysql_fetch_array($rs_pointer))  
  11.  
  12.           {  
  13.  
  14. echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>
  15.  
  16.  <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />
  17.  
  18.    <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br><a href=\"".$_SERVER["PHP_SELF"]."?user=".$req_user_postusername['username']."&amp;del=".$req_user_postusername['comment_id']."\">Delete Comment</a></span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>
  19.  
  20.  
  21.  
  22.  
  23.  
  24. ";
  25.  
  26.  
  27.  
  28.            }  
  29.  
  30.  
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

still did not work. why wont you take a look on there http://www.gothicgreenwire.com
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

argh!
sorry it couldn't work,
I did not take you last script with $req_user_postusername['id'] :-)
I cannot test since can't login

try this :

PHP Code: [ Select ]
 
//...    
 
if(isset($_GET["del"]))    
 
$database->DeleteComment("del");  
 
 ?> <?php    
 
          while($req_user_postusername = mysql_fetch_array($rs_pointer))    
 
          {    
 
echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>  
 
 <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />  
 
   <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br><a href=\"".$_SERVER["PHP_SELF"]."?user=".$req_user_postusername['username']."&amp;del=".$req_user_postusername['id']."\">Delete Comment</a></span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>  
 
 
 
 
 
";  
 
 
 
           }
 
 
  1.  
  2. //...    
  3.  
  4. if(isset($_GET["del"]))    
  5.  
  6. $database->DeleteComment("del");  
  7.  
  8.  ?> <?php    
  9.  
  10.           while($req_user_postusername = mysql_fetch_array($rs_pointer))    
  11.  
  12.           {    
  13.  
  14. echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>  
  15.  
  16.  <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />  
  17.  
  18.    <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br><a href=\"".$_SERVER["PHP_SELF"]."?user=".$req_user_postusername['username']."&amp;del=".$req_user_postusername['id']."\">Delete Comment</a></span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>  
  19.  
  20.  
  21.  
  22.  
  23.  
  24. ";  
  25.  
  26.  
  27.  
  28.            }
  29.  
  30.  


by the way, you should put the user name in the url,
once it'll work you should think about session in PHP.
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

It's geting late here, I go to bed, I'll check this thread tomorow morning :-)
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

here is the new code i added where you have to be loged in also but i still cant figure out why its not working.

PHP Code: [ Select ]
<?php //...  
 
if(isset($_GET["del"]))  
 
$database->DeleteComment("del");  
 
 ?> <?php  
 
          while($req_user_postusername = mysql_fetch_array($rs_pointer))  
 
          {  
 
echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>  
 
 <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />  
 
   <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br>";
 
   if($session->logged_in){ echo"<a href=\"".$_SERVER["PHP_SELF"]."?user=".$req_user_postusername['username']."&amp;del=".$req_user_postusername['comment_id']."\">Delete Comment</a>";}
 
   echo "</span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>";  
 
 
 
           } ?>
  1. <?php //...  
  2.  
  3. if(isset($_GET["del"]))  
  4.  
  5. $database->DeleteComment("del");  
  6.  
  7.  ?> <?php  
  8.  
  9.           while($req_user_postusername = mysql_fetch_array($rs_pointer))  
  10.  
  11.           {  
  12.  
  13. echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>  
  14.  
  15.  <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />  
  16.  
  17.    <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br>";
  18.  
  19.    if($session->logged_in){ echo"<a href=\"".$_SERVER["PHP_SELF"]."?user=".$req_user_postusername['username']."&amp;del=".$req_user_postusername['comment_id']."\">Delete Comment</a>";}
  20.  
  21.    echo "</span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>";  
  22.  
  23.  
  24.  
  25.            } ?>
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

noooooo !

The new code you added isn't the last corrected one ! :-)
in fact this code is wrong because it kept "del=".$data["id_comment"]." instead in "del=".$req_user_postusername["id"]."

So the right code is :

PHP Code: [ Select ]
 
//...    
 
if(isset($_GET["del"]))    
 
$database->DeleteComment("del");    
 
 ?> <?php    
 
          while($req_user_postusername = mysql_fetch_array($rs_pointer))    
 
          {    
 
echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>    
 
 <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />    
 
   <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br><a href=\"".$_SERVER["PHP_SELF"]."?user=".$req_user_postusername['username']."&amp;del=".$req_user_postusername['id']."\">Delete Comment</a></span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>    
 
 
 
 
 
";    
 
 
 
           }
 
 
  1.  
  2. //...    
  3.  
  4. if(isset($_GET["del"]))    
  5.  
  6. $database->DeleteComment("del");    
  7.  
  8.  ?> <?php    
  9.  
  10.           while($req_user_postusername = mysql_fetch_array($rs_pointer))    
  11.  
  12.           {    
  13.  
  14. echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>    
  15.  
  16.  <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />    
  17.  
  18.    <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br><a href=\"".$_SERVER["PHP_SELF"]."?user=".$req_user_postusername['username']."&amp;del=".$req_user_postusername['id']."\">Delete Comment</a></span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>    
  19.  
  20.  
  21.  
  22.  
  23.  
  24. ";    
  25.  
  26.  
  27.  
  28.            }
  29.  
  30.  
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

actually i fixed it and i ment to post that but for some reason you have to click the link twice to get the comment to delete..

PHP Code: [ Select ]
<?php //...    
 
if(isset($_GET["del"]))
 
$database->DeleteProfileComment("del");  
 
   
 
          while($req_user_postusername = mysql_fetch_array($rs_pointer))    
 
          {    
 
echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>  
 
 <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />  
 
   <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br>";
 
    if($session->logged_in){ echo"<a href=\"".$_SERVER["PHP_SELF"]."?del=".$req_user_postusername['id']."\">Delete Comment</a>";}
 
    echo "</span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>";  
 
 
 
           } ?>  
  1. <?php //...    
  2.  
  3. if(isset($_GET["del"]))
  4.  
  5. $database->DeleteProfileComment("del");  
  6.  
  7.    
  8.  
  9.           while($req_user_postusername = mysql_fetch_array($rs_pointer))    
  10.  
  11.           {    
  12.  
  13. echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>  
  14.  
  15.  <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />  
  16.  
  17.    <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br>";
  18.  
  19.     if($session->logged_in){ echo"<a href=\"".$_SERVER["PHP_SELF"]."?del=".$req_user_postusername['id']."\">Delete Comment</a>";}
  20.  
  21.     echo "</span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>";  
  22.  
  23.  
  24.  
  25.            } ?>  
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

No in fact that works but the delete function call is between the comment querying stuff and the comments displaying stuff.

SO when you retrived the comments, the delete hasn't been done yet.
And when you click for the second time, the delete stuff was done thow the delete comment is still displayed.

Well in fact I don't know if you get what I try to explain, but anyway you just have to move :

PHP Code: [ Select ]
 
if(isset($_GET["del"]))  
 
$database->DeleteProfileComment("del");
 
 
  1.  
  2. if(isset($_GET["del"]))  
  3.  
  4. $database->DeleteProfileComment("del");
  5.  
  6.  

just before
PHP Code: [ Select ]
 
$rs_pointer = $database->getUserComments($req_user);
 
 
  1.  
  2. $rs_pointer = $database->getUserComments($req_user);
  3.  
  4.  


so that the delete stuff is called before the query that retrieves the comments ;-)

did you get that?
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

it is befor it no?

PHP Code: [ Select ]
<?php //...    
 
if(isset($_GET["del"]))  
 
$database->DeleteProfileComment("del");    
 
   
 
          while($req_user_postusername = mysql_fetch_array($rs_pointer))    
 
          {    
 
echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>    
 
 <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />    
 
   <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br>";  
 
    if($session->logged_in){ echo"<a href=\"".$_SERVER["PHP_SELF"]."?del=".$req_user_postusername['id']."\">Delete Comment</a>";}  
 
    echo "</span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>";    
 
 
 
           } ?>
  1. <?php //...    
  2.  
  3. if(isset($_GET["del"]))  
  4.  
  5. $database->DeleteProfileComment("del");    
  6.  
  7.    
  8.  
  9.           while($req_user_postusername = mysql_fetch_array($rs_pointer))    
  10.  
  11.           {    
  12.  
  13. echo "<table width='100%' border='1' cellpadding='1' cellspacing='1' class=main>    
  14.  
  15.  <tr><td width='24%' align='center' valign='middle' bordercolor='#000000'><div align='center'><span class='main'><a href='userinfo.php?user=".$req_user_postusername['username']."'>".$req_user_postusername['username']."</a><br />    
  16.  
  17.    <br /><a href='comment.php?user=".$req_user_postusername['username']."'>Reply to post!</a><br>";  
  18.  
  19.     if($session->logged_in){ echo"<a href=\"".$_SERVER["PHP_SELF"]."?del=".$req_user_postusername['id']."\">Delete Comment</a>";}  
  20.  
  21.     echo "</span></div></td><td width='74%' bordercolor='#000000'><table width='100%' border='0'><tr><td align='right'>".$req_user_postusername['date']."</span><span class='main'></td></tr><tr><td>".preg_replace('#(\n)#', "<br />", $req_user_postusername['comment'])."</td></tr></table></td></tr></table>";    
  22.  
  23.  
  24.  
  25.            } ?>
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

HI,

not at all, like it is, when you call the comment delete function, the query to retrieve the comments has been yet submitted with :
$rs_pointer = $database->getUserComments($req_user);

and while($req_user_postusername = mysql_fetch_array($rs_pointer)) ...etc. is nothing but a loop that browse the yet built up results set.

so this is like you should order the statments :


PHP Code: [ Select ]
 
//first comment delete stuff :
 
if(isset($_GET["del"]))  
 
   $database->DeleteProfileComment("del");
 
//then querying the comments in the database :  
 
$rs_pointer = $database->getUserComments($req_user);
 
 
  1.  
  2. //first comment delete stuff :
  3.  
  4. if(isset($_GET["del"]))  
  5.  
  6.    $database->DeleteProfileComment("del");
  7.  
  8. //then querying the comments in the database :  
  9.  
  10. $rs_pointer = $database->getUserComments($req_user);
  11.  
  12.  


and then you can do the displaying stuff ( links and comments )


If you're not sure, just show all the entire comment script and I'll do the changes.
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

so basically you are telling me to take out while($req_user_postusername = mysql_fetch_array($rs_pointer))?
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

No

keep it like it is, I just tell you to move

if(isset($_GET["del"]))
$database->DeleteProfileComment("del");

just above
$rs_pointer = $database->getUserComments($req_user);
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

ok actually i like it on how it was where you have to click it twice just to make sute that the user had the right comment that they wanted to delete and also say the user deletes all there comments and then it comes up with this error

Code: [ Select ]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/happykj/public_html/mycomments.php on line 75



why is that. and also do you know how to do picture uploading and showing in a database or do you know what i mean? also because i want to do more then just one picture


This is a edited post

I am having the user do a photobucket account and take the url for this picture thing but the problem is is that its streching out the users pictures how can i make that stop but have it some how in thies demensions

Code: [ Select ]
<tr class="mainpic_title">
     <td >
      <div align="center"><? echo "<img src='".$req_user_info['mainpic']."' width='500' height='375'>"; ?></div>     
             </td>
     </tr>
  1. <tr class="mainpic_title">
  2.      <td >
  3.       <div align="center"><? echo "<img src='".$req_user_info['mainpic']."' width='500' height='375'>"; ?></div>     
  4.              </td>
  5.      </tr>
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

might anybody know?
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

HI,

I'm very sorry I didn't understand the post.
(you probably reached my english limits :-))
is the double click problem fixed?

What have you a php error for?

can you show more about the code around the line 75 code?

Yes, I know how to do picture dowloading :-)

What kind of streching? if you force the displaying dimension (width and height) that'll stretch the picture.
maybe you talk about horizontal/vertical stretching that you want to correct?
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

Also how can i do the downloading of pictures for a user with a limit number of alloud pictures..

i fixed the error in the comments
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

HI,

this is the kind of form for uploading files :
Code: [ Select ]
<html>
  <body>
    <form enctype="multipart/form-data" action="fileupload.php" method="post">
      <input type="hidden" name="MAX_FILE_SIZE" value="100000" />
      File to upload : <input type="file" name="my_file" />
      <input type="submit" Value="upload" />
    </form>
  </body>
</html>
  1. <html>
  2.   <body>
  3.     <form enctype="multipart/form-data" action="fileupload.php" method="post">
  4.       <input type="hidden" name="MAX_FILE_SIZE" value="100000" />
  5.       File to upload : <input type="file" name="my_file" />
  6.       <input type="submit" Value="upload" />
  7.     </form>
  8.   </body>
  9. </html>


See I put "fileupload.php" but you'll put the name of the script that treat the form.

And then in the action script you can use/check those main values around the dowloaded file :
THey are acceesed with the associative array FILE[], the name in [] is the field name of your form (I call it "my_file" in the form)
$_FILES["my_file"]["tmp_name"] give you the temporary path and and name of the file on the server once dowloaded (you see like the stanges path and name of dowloaded files of your mail application or whatelse)

$_FILES["my_file"]["name"] Name of the file when the client uploaded it.(for example you can check and limit the allowed extentions)
$_FILES["my_file"]["size"] size of the file (bytes) so that you can check and limit the size
$_FILES["my_file"]["type"]"MIME type" of the file (ex: text/html, image/gif, etc.)

And then you can copy the file in a choosen directory :

copy($_FILES["my_file"]["name"], "$destination_path.$name_of_the_file");

So you can have a table that stores all the paths and name with a field that is a reference on user id.


About your question, If you want to check if the limit of dowloaded file is reached make a query that counts the rows in this table with the given user_id :

SELECT COUNT(*) AS 'DL_COUNT' FROM image_table WHERE user_id = given_value

Then this will return a unique row with the COUNT of yet dowloaded file.

Feel free to ask any question on the above.
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

i am a total noobie when it comes to uploading files. can you create me a full working script maybe? and also when you upload the file it is going to send it to that username?
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

Ok, I'll try do to a little something, but you have to give me a little time, now it's 10:05 am And I'm workin at my job (yeak it doesn't feel like I'm :-).

But later I'll try to show here an example of picture managment for the users ( form + treatment + pictures tables creating).
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

well basically on how i want it is where a user can upload there picture and have it show on a page called userpictures.php. and where they can delete there pictures if they want to. Also I want it where they have a limited about of pictures like for free account they have 15 and so on.
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

Hey man how long do you think it will take you?
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

Hi,

Sorry i've got a life outside Ozzu :-)

your table will look like that :
Code: [ Select ]
#Structure de la table `picture`


CREATE TABLE `picture` (
 `picture_id` int(11) NOT NULL auto_increment,
 `name` varchar(100) NOT NULL,
 `size` mediumint(9) NOT NULL,
 `user_id` int(11) NOT NULL,
 PRIMARY KEY (`picture_id`)
) ENGINE=InnoDB;
  1. #Structure de la table `picture`
  2. CREATE TABLE `picture` (
  3.  `picture_id` int(11) NOT NULL auto_increment,
  4.  `name` varchar(100) NOT NULL,
  5.  `size` mediumint(9) NOT NULL,
  6.  `user_id` int(11) NOT NULL,
  7.  PRIMARY KEY (`picture_id`)
  8. ) ENGINE=InnoDB;


Create a directory just beside userpictures.php in the same directory and name it "pict" you will store the files in it.


In fact, I made a class, album.

PHP Code: [ Select ]
 
class album
 
{
 
   var $user_id;
 
   var $size_limit = 100000;
 
   var $nb_limit;
 
   var $stored_pictures;
 
   function album($user_id, $nb_limit = 5)
 
   {
 
      $this->user_id = $user_id;
 
      $this->nb_limit = $nb_limit;
 
      $this->size_limit = $size_limit;
 
   }
 
   function display_album()
 
   {
 
      $q = "SELECT picture_id, name, size FROM picture WHERE user_id=".$this->user_id;
 
      $this->stored_pictures = mysql_query($q) or die(mysql_error()."<br />".$q);
 
      if(mysql_num_rows($this->stored_pictures))
 
      {
 
         print "<table border=\"1\">\n<tr><td align=\"center\"><b>Name</b></td><td align=\"center\"><b>Size</b></td><td align=\"center\"><b>Picture</b></td><td align=\"center\"><b>Action</b></td></tr>\n";
 
         while($d = mysql_fetch_row($this->stored_pictures))
 
         {
 
            print "<tr><td>".$d[1]."</td><td align=\"center\">".$d[2]."</td><td align=\"center\"><img src=\"pict/".$d[1]."\" /></td>";
 
            print "<td align=\"center\"><a href=\"".$_SERVER["PHP_SELF"]."?del_pict_id=".$d[0]."\">Delete</a></td></tr>\n";
 
         }
 
         print "</table>\n";
 
      }
 
      else
 
         print "<p>No picture ! </p>\n";
 
   }
 
   function store_picture()
 
   {
 
      //$_FILE is a superglobal so you can get it from there
 
      foreach ($_FILES as $file)
 
      {
 
         print "<p>".$file['name']."<br />";
 
         print "temp :".$file['tmp_name']."<br />";
 
         print "type :".$file['type'] ."<br />";
 
         print "size :".$file['size'] ."<br />";
 
         print "error :".$file['error'] ."</p>";
 
         if($file['size'] >= $this->size_limit)
 
         {
 
            print "<p>failed ".$file['name']." ".$file['size']." bytes : picture too heavy !</p>";
 
            return false;
 
         }
 
         if(preg_match("#^([a-z0-9_]+[.](jpg|gif))#i", $file['name']))
 
         {
 
            $q = "INSERT INTO picture (picture_id, name, size, user_id) VALUES ('', '".$file['name']."', '".$file['size']."', ".$this->user_id.")";
 
            mysql_query($q) or die(mysql_error()."<br />".$q);
 
         }
 
         else
 
         {
 
            print "<p>failed ".$file['name']." : Wrong picture name or extention !</p>";
 
            return false;
 
         }
 
         if(file_exists("pict/".$file['name']))
 
            $file['name'] .= $this->user_id;
 
         copy($file['tmp_name'], "pict/".$file['name']);
 
      }          
 
   }
 
   function delete_picture()
 
   {
 
      $q = "SELECT name FROM picture WHERE picture_id=".$_GET["del_pict_id"];
 
      $r = mysql_query($q) or die(mysql_error()."<br />".$q);
 
      $d = mysql_fetch_row($r);
 
      $file = "pict/".$d[0];
 
      $q = "DELETE FROM Picture WHERE picture_id=".$_GET["del_pict_id"]." LIMIT 1";
 
      mysql_query($q) or die(mysql_error()."<br />".$q);
 
      if(file_exists($file))
 
         unlink($file);
 
   }
 
   function display_upload_form($nb_file = 1)
 
   {
 
      if(!$this->nb_limit <= mysql_num_rows($this->stored_pictures))
 
      {
 
         print "<form method=\"post\" enctype=\"multipart/form-data\" action=\"".$_SERVER["PHP_SELF"]."?up=1\">\n";
 
         for($i = 0;$i < $nb_file;$i++)
 
            print "<p>\nPicucture N°".($i + 1)." : <input type=\"file\" name=\"file".$i."\" size=\"30\"></p>";
 
         print "<input type=\"submit\" value=\"upload\" />\n";
 
      }
 
      else
 
         print "<p>no more upload allowed !</p>";
 
   }
 
}
 
 
  1.  
  2. class album
  3.  
  4. {
  5.  
  6.    var $user_id;
  7.  
  8.    var $size_limit = 100000;
  9.  
  10.    var $nb_limit;
  11.  
  12.    var $stored_pictures;
  13.  
  14.    function album($user_id, $nb_limit = 5)
  15.  
  16.    {
  17.  
  18.       $this->user_id = $user_id;
  19.  
  20.       $this->nb_limit = $nb_limit;
  21.  
  22.       $this->size_limit = $size_limit;
  23.  
  24.    }
  25.  
  26.    function display_album()
  27.  
  28.    {
  29.  
  30.       $q = "SELECT picture_id, name, size FROM picture WHERE user_id=".$this->user_id;
  31.  
  32.       $this->stored_pictures = mysql_query($q) or die(mysql_error()."<br />".$q);
  33.  
  34.       if(mysql_num_rows($this->stored_pictures))
  35.  
  36.       {
  37.  
  38.          print "<table border=\"1\">\n<tr><td align=\"center\"><b>Name</b></td><td align=\"center\"><b>Size</b></td><td align=\"center\"><b>Picture</b></td><td align=\"center\"><b>Action</b></td></tr>\n";
  39.  
  40.          while($d = mysql_fetch_row($this->stored_pictures))
  41.  
  42.          {
  43.  
  44.             print "<tr><td>".$d[1]."</td><td align=\"center\">".$d[2]."</td><td align=\"center\"><img src=\"pict/".$d[1]."\" /></td>";
  45.  
  46.             print "<td align=\"center\"><a href=\"".$_SERVER["PHP_SELF"]."?del_pict_id=".$d[0]."\">Delete</a></td></tr>\n";
  47.  
  48.          }
  49.  
  50.          print "</table>\n";
  51.  
  52.       }
  53.  
  54.       else
  55.  
  56.          print "<p>No picture ! </p>\n";
  57.  
  58.    }
  59.  
  60.    function store_picture()
  61.  
  62.    {
  63.  
  64.       //$_FILE is a superglobal so you can get it from there
  65.  
  66.       foreach ($_FILES as $file)
  67.  
  68.       {
  69.  
  70.          print "<p>".$file['name']."<br />";
  71.  
  72.          print "temp :".$file['tmp_name']."<br />";
  73.  
  74.          print "type :".$file['type'] ."<br />";
  75.  
  76.          print "size :".$file['size'] ."<br />";
  77.  
  78.          print "error :".$file['error'] ."</p>";
  79.  
  80.          if($file['size'] >= $this->size_limit)
  81.  
  82.          {
  83.  
  84.             print "<p>failed ".$file['name']." ".$file['size']." bytes : picture too heavy !</p>";
  85.  
  86.             return false;
  87.  
  88.          }
  89.  
  90.          if(preg_match("#^([a-z0-9_]+[.](jpg|gif))#i", $file['name']))
  91.  
  92.          {
  93.  
  94.             $q = "INSERT INTO picture (picture_id, name, size, user_id) VALUES ('', '".$file['name']."', '".$file['size']."', ".$this->user_id.")";
  95.  
  96.             mysql_query($q) or die(mysql_error()."<br />".$q);
  97.  
  98.          }
  99.  
  100.          else
  101.  
  102.          {
  103.  
  104.             print "<p>failed ".$file['name']." : Wrong picture name or extention !</p>";
  105.  
  106.             return false;
  107.  
  108.          }
  109.  
  110.          if(file_exists("pict/".$file['name']))
  111.  
  112.             $file['name'] .= $this->user_id;
  113.  
  114.          copy($file['tmp_name'], "pict/".$file['name']);
  115.  
  116.       }          
  117.  
  118.    }
  119.  
  120.    function delete_picture()
  121.  
  122.    {
  123.  
  124.       $q = "SELECT name FROM picture WHERE picture_id=".$_GET["del_pict_id"];
  125.  
  126.       $r = mysql_query($q) or die(mysql_error()."<br />".$q);
  127.  
  128.       $d = mysql_fetch_row($r);
  129.  
  130.       $file = "pict/".$d[0];
  131.  
  132.       $q = "DELETE FROM Picture WHERE picture_id=".$_GET["del_pict_id"]." LIMIT 1";
  133.  
  134.       mysql_query($q) or die(mysql_error()."<br />".$q);
  135.  
  136.       if(file_exists($file))
  137.  
  138.          unlink($file);
  139.  
  140.    }
  141.  
  142.    function display_upload_form($nb_file = 1)
  143.  
  144.    {
  145.  
  146.       if(!$this->nb_limit <= mysql_num_rows($this->stored_pictures))
  147.  
  148.       {
  149.  
  150.          print "<form method=\"post\" enctype=\"multipart/form-data\" action=\"".$_SERVER["PHP_SELF"]."?up=1\">\n";
  151.  
  152.          for($i = 0;$i < $nb_file;$i++)
  153.  
  154.             print "<p>\nPicucture N°".($i + 1)." : <input type=\"file\" name=\"file".$i."\" size=\"30\"></p>";
  155.  
  156.          print "<input type=\"submit\" value=\"upload\" />\n";
  157.  
  158.       }
  159.  
  160.       else
  161.  
  162.          print "<p>no more upload allowed !</p>";
  163.  
  164.    }
  165.  
  166. }
  167.  
  168.  


then userpictures.php.

You can create an object album with 2 parameters
- user identiiant (id)
- max picture number (I 've got no idea about how you get it so just pass it here and it'll be managed).
$album = new album($user_id, $max_upload);

so the file will look like this:
PHP Code: [ Select ]
//...
 
//include the class and connects to the DB
 
$album = new album($user_id, $max_upload);
 
//check if he user clicked for removing and call the delete function
 
if($_GET["del_pict_id"])
 
   $album->delete_picture();
 
//check if user is uploading right now and   call the function that treat uploaded files
 
if($_GET["up"])
 
   $album->store_picture();
 
//query and display the user files call ths function.
 
$album->display_album();
 
//this function will display the form for uploading the files
 
$album->display_upload_form($nb_file = 1);
 
 
  1. //...
  2.  
  3. //include the class and connects to the DB
  4.  
  5. $album = new album($user_id, $max_upload);
  6.  
  7. //check if he user clicked for removing and call the delete function
  8.  
  9. if($_GET["del_pict_id"])
  10.  
  11.    $album->delete_picture();
  12.  
  13. //check if user is uploading right now and   call the function that treat uploaded files
  14.  
  15. if($_GET["up"])
  16.  
  17.    $album->store_picture();
  18.  
  19. //query and display the user files call ths function.
  20.  
  21. $album->display_album();
  22.  
  23. //this function will display the form for uploading the files
  24.  
  25. $album->display_upload_form($nb_file = 1);
  26.  
  27.  

check in each function and add what you need.

feel free to ask question.
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

so where does
PHP Code: [ Select ]
<?php //...
 
//include the class and connects to the DB
 
$album = new album($user_id, $max_upload);
 
//check if he user clicked for removing and call the delete function
 
if($_GET["del_pict_id"])
 
    $album->delete_picture();
 
//check if user is uploading right now and   call the function that treat uploaded files
 
if($_GET["up"])
 
    $album->store_picture();
 
//query and display the user files call ths function.
 
$album->display_album();
 
//this function will display the form for uploading the files
 
$album->display_upload_form($nb_file = 1); ?>
  1. <?php //...
  2.  
  3. //include the class and connects to the DB
  4.  
  5. $album = new album($user_id, $max_upload);
  6.  
  7. //check if he user clicked for removing and call the delete function
  8.  
  9. if($_GET["del_pict_id"])
  10.  
  11.     $album->delete_picture();
  12.  
  13. //check if user is uploading right now and   call the function that treat uploaded files
  14.  
  15. if($_GET["up"])
  16.  
  17.     $album->store_picture();
  18.  
  19. //query and display the user files call ths function.
  20.  
  21. $album->display_album();
  22.  
  23. //this function will display the form for uploading the files
  24.  
  25. $album->display_upload_form($nb_file = 1); ?>
go?

and if it goes in where the other code goes it give me a error saying
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
SELECT picture_id, name, size FROM picture WHERE user_id=
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

HI,

Ok this goes into your userpictures.php, and this file must include the files that holds the "album" class definition.

And this query has failed because when you call the constructor:

PHP Code: [ Select ]
//...
 
$album = new album($user_id, $max_upload);  
 
 
  1. //...
  2.  
  3. $album = new album($user_id, $max_upload);  
  4.  
  5.  


$user_id is probably empty.

In fact I know that you hold a variable is the URL user, somewhere you give it $req_user_postusername['username'].

If you haven't any id system for user, and are sure that this value is unique for each user that is connecting on the site, give this value instead of $user_id.

But you have to know that this value must match in the pictures table (there is a field for unique values that identify users).
So think about the type of this field.

Where you insert rows picture tables, for this field you have to get the value that'll identify the user, so that you can query on is own pictures each time he comes to userpictures.php.

Well it's very hard for me to be clear in English words but you just have to know that in the call above, $user_id must hold the value that identifies the user so that we are able to query on his own pictures in pictures tables.
And $max_upload the max number of pictures allowed for a user on the server.

Feel free to ask more questions
  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Posts: 651
  • Loc: Conroe, Texas

Post 3+ Months Ago

umm you kinda lost me there but its ok.

so say that user just joined and dont have there name in the picture database. how would that person upload there picture to the database? and i want it where it goes under there username and bty most of where it gets the username is
Code: [ Select ]
username = '$username'
  • gisele
  • Expert
  • Expert
  • User avatar
  • Posts: 585
  • Loc: Nimes (France)

Post 3+ Months Ago

Yeah, that's what I want to say.

Of course change the field "picture_id", in the pictures table so that it can store those $username (is it numéric(keep int)? or string (change to varchar)? .

if you passed this value $username in the constructor :
PHP Code: [ Select ]
//.
 
$album = new album($username , $max_upload); ?>
 
 
  1. //.
  2.  
  3. $album = new album($username , $max_upload); ?>
  4.  
  5.  

It will be hold and used in the class for insert and select statments.

But just check the insert query in store_picture() function, if the field name for the user is correct (if you've have changed it), actually it is called user user_id.

And also the SELECT query in display_album()

That's how we link uploaded pictures with the user, $username value will be sored in the field "user_id" (or whatelse if you change the field name).
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

Post Information

  • Total Posts in this topic: 97 posts
  • Users browsing this forum: No registered users and 124 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.