Gallery For Lavalair (converted To Wml)

**thanatos** · 08.03.07, 10:40

in genproc.php put this...

Code:

else if($action=="useav")
{
    $gid = $_GET["gid"];
  addonline(getuid_sid($sid),"Updating Avatar","");
 echo "<card id=\"main\" title=\"Natasu\">";
  echo "<p align=\"center\">";
$getimg = mysql_fetch_array(mysql_query("SELECT itemurl FROM fun_gallery WHERE id=&#39;".$gid."&#39;"));

$avatar = $getimg[0];
  $uid = getuid_sid($sid);

    $res = mysql_query("Update ibwf_users SET avatar=&#39;".$avatar."&#39; WHERE id=&#39;".$uid."&#39;");
    if($res)
        {
            echo "<img src=\"images/ok.gif\" alt=\"o\"/>Avatar was successfully updated
";
        }else{
          echo "<img src=\"images/notok.gif\" alt=\"x\"/>Database Error!
";
        }
    echo "
";
  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
  echo "</p>";
echo "</card>";

}

else if($action=="delgal")
{
    $gid = $_GET["gid"];
  addonline(getuid_sid($sid),"Deleting Gallery Photo","");
  echo "<card id=\"main\" title=\"Natasu\">";
  echo "<p align=\"center\">";
  $itemowner = mysql_fetch_array(mysql_query("SELECT uid FROM fun_gallery WHERE id=&#39;".$gid."&#39;"));
  if(ismod(getuid_sid($sid))||getuid_sid($sid)==$itemowner[0])
  {
    $res = mysql_query("DELETE FROM fun_gallery WHERE id=&#39;".$gid."&#39;");
$res2 = mysql_query("DELETE FROM fun_galcomments WHERE pid=&#39;".$gid."&#39;");
$res3 = mysql_query("DELETE FROM fun_prate WHERE pid=&#39;".$gid."&#39;");
    if($res||res2||res3)
        {
            echo "<img src=\"images/ok.gif\" alt=\"o\"/>Photo Deleted From Gallery
";
        }else{
          echo "<img src=\"images/notok.gif\" alt=\"x\"/>Database Error!
";
        }
  }else{
    echo "<img src=\"images/notok.gif\" alt=\"X\"/>You can&#39;t delete this Photo";
  }
  echo "

";
  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
  echo "</p>";
echo "</card>";

}

else if($action=="addgal")
{
   

  $itemurl = $_POST["itemurl"];

   $uid = getuid_sid($sid);
echo "<card id=\"main\" title=\"Natasu\">";
echo "<p align=\"center\">";
  $nopl = mysql_fetch_array(mysql_query("SELECT sex FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  if($nopl[0]==&#39;M&#39;)
  {
    $usex = "M";
  }else if($nopl[0]==&#39;F&#39;){
    $usex = "F";
  }else{
    $usex = "M";
  }
    
      $res = mysql_query("INSERT INTO fun_gallery SET uid=&#39;".$uid."&#39;, itemurl=&#39;".$itemurl."&#39;, sex=&#39;".$usex."&#39;");
      if($res)
      {
        echo "<img src=\"images/ok.gif\" alt=\"O\"/>User Photo Added
";
      }else{
        echo "<img src=\"images/notok.gif\" alt=\"X\"/>Database Error
";
      }
      
      echo "<a href=\"gallery.php?action=main&amp;sid=$sid\">User Gallery</a>
";
  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
  echo "Home</a>";
  echo "</p></card>";
}

else if($action=="commentadd")
{
    $text = $_POST["text"];
   $prate = $_POST["prate"];

  $gid = $_GET["gid"];
  addonline(getuid_sid($sid),"Adding Photo Comment","");
  echo "<card id=\"main\" title=\"Natasu\">";
      echo "<p align=\"center\">";
      $crdate = time();
      $uid = getuid_sid($sid);
      $res = false;

      if(trim($text)!="")
      {
        
      $res = mysql_query("INSERT INTO fun_galcomments SET text=&#39;".$text."&#39;, byuser=&#39;".$uid."&#39;, time=&#39;".$crdate."&#39;, pid=&#39;".$gid."&#39;");
      }
      if($res)
      {
        echo "<img src=\"images/ok.gif\" alt=\"O\"/>Comment Added Successfully
";
      }else{
        echo "<img src=\"images/notok.gif\" alt=\"X\"/>Error Adding Comment";
      }
if($prate!="") {
$res2 = mysql_query("INSERT INTO fun_prate SET uid=&#39;".$uid."&#39;, pid=&#39;".$gid."&#39;, prate=&#39;".$prate."&#39;");
    if($res2)
    {
        echo "<img src=\"images/ok.gif\" alt=\"o\"/>Photo rated successfully
";
    }else{
        echo "<img src=\"images/notok.gif\" alt=\"x\"/>Database Error!
";
    }
  }      

      echo "

";
      echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
      echo "</p>";
      
echo "</card>";

}

**thanatos** · 08.03.07, 10:42

in modproc.php

Code:

MODPROC.PHP

else if($action=="delcmt")
{
  $id = $_GET["id"];
   echo "<card id=\"main\" title=\"Natasu\">";
  echo "<p align=\"center\">";

  $res = mysql_query("DELETE FROM fun_galcomments WHERE id =&#39;".$id."&#39;");
  if($res)
          {
          mysql_query("INSERT INTO fun_mlog SET action=&#39;comment&#39;, details=&#39;[b]".getnick_uid(getuid_sid($sid))."[/b] Deleted a Photo Comment&#39;, actdt=&#39;".time()."&#39;");
            echo "<img src=\"images/ok.gif\" alt=\"O\"/>Comment deleted";
          }else{
            echo "<img src=\"images/notok.gif\" alt=\"X\"/>Database Error";
          }
  echo "

";


  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
  echo "</p>";
echo "</card>";

}

**thanatos** · 08.03.07, 10:43

core.php

Code:

function candelgal($uid, $item)
{
  $candoit = mysql_fetch_array(mysql_query("SELECT  uid FROM fun_gallery WHERE id=&#39;".$item."&#39;"));
  if($uid==$candoit[0]||ismod($uid))
  {
    return true;
  }
  return false;
}

**thanatos** · 08.03.07, 10:45

max.php

Code:

<?php
$height= 100;
$width= 100;
// Content type
header(&#39;Content-type: image/jpeg&#39;);
if(!$filename)
$filename="./images/nopic.jpg";
// Get new dimensions
list($width_orig, $height_orig) = getimagesize($filename);

if ($width && ($width_orig < $height_orig)) {
   $width = ($height / $height_orig) * $width_orig;
} else {
   $height = ($width / $width_orig) * $height_orig;
}

// Resample
$image_p = imagecreatetruecolor($width, $height);
$image = imagecreatefromjpeg($filename);
imagecopyresampled($image_p, $image, 0, 0, 0, 0, $width, $height, $width_orig, $height_orig);

// Output
imagejpeg($image_p, null, 100);
ImageDestroy ($image_p);
?>

**thanatos** · 08.03.07, 10:47

admincp.php

Code:

else if($action=="addgal")
{
    echo "<card id=\"main\" title=\"Natasu\">";
    echo "<p align=\"center\">";
echo "Username: <input name=\"user\" maxlength=\"100\"/>
";
echo "Image URL: <input name=\"itemurl\" maxlength=\"100\"/>
";
echo "<anchor>Add Photo";
echo "<go href=\"admproc.php?action=addgal&amp;sid=$sid\" method=\"post\">";
echo "<postfield name=\"user\" value=\"$(user)\"/>";
echo "<postfield name=\"itemurl\" value=\"$(itemurl)\"/>";
echo "</go></anchor>";
    echo "</p>";
    echo "<p align=\"center\">";
    
  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
  echo "Home</a>";
  echo "</p>";
  echo "</card>"; 
}

**thanatos** · 08.03.07, 10:48

adminproc.php

Code:

else if($action=="addgal")
{
    $user = $_POST["user"];
  $itemurl = $_POST["itemurl"];

   $uid = getuid_nick($user);
      echo "<card id=\"main\" title=\"Natasu\">";
      echo "<p align=\"center\">";
$nopl = mysql_fetch_array(mysql_query("SELECT sex FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  if($nopl[0]==&#39;M&#39;)
  {
    $usex = "M";
  }else if($nopl[0]==&#39;F&#39;){
    $usex = "F";
  }else{
    $usex = "M";
  }

      $res = mysql_query("INSERT INTO fun_gallery SET uid=&#39;".$uid."&#39;, itemurl=&#39;".$itemurl."&#39;, sex=&#39;".$usex."&#39;");
      if($res)
      {
        echo "<img src=\"images/ok.gif\" alt=\"O\"/>User Photo Added
";
      }else{
        echo "<img src=\"images/notok.gif\" alt=\"X\"/>Database Error
";
      }
      
      echo "<a href=\"index.php?action=admincp&amp;sid=$sid\"><img src=\"images/admn.gif\" alt=\"*\"/>";
  echo "Admin CP</a>
";
  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
  echo "Home</a>";
  echo "</p>";
  echo "</card>";
}

**thanatos** · 08.03.07, 10:50

SQL

Code:

SQL

CREATE TABLE fun_galcomments (
  id int(99) NOT NULL auto_increment,
  pid int(99) NOT NULL,
  `text` varchar(200) NOT NULL,
  byuser varchar(100) NOT NULL,
  `time` varchar(99) NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY `text` (`text`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table &#39;fun_gallery&#39;
-- 

CREATE TABLE fun_gallery (
  id int(100) NOT NULL auto_increment,
  uid int(100) NOT NULL,
  sex varchar(255) NOT NULL,
  itemurl varchar(255) NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY `name` (itemurl)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- Table structure for table &#39;fun_prate&#39;
-- 

CREATE TABLE fun_prate (
  id int(100) NOT NULL auto_increment,
  pid int(100) NOT NULL default &#39;0&#39;,
  uid int(100) NOT NULL default &#39;0&#39;,
  prate char(1) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

**thanatos** · 08.03.07, 10:52

if there's something wrong with this... post it here... i just converted this manually...

**wizard** · 08.03.07, 11:43

u need a blank jpg image in ur images folder

Code:

$filename="./images/nopic.jpg";

upload one there

**thanatos** · 08.03.07, 12:05

u need a blank jpg image in ur images folder

Code:

$filename="./images/nopic.jpg";

upload one there[/b]

it should be in jpg format.. right? tnx wizard.. but i have a question about this script... why is it that when i add comment on the user pic my rating doesn't show... what's wrong with the script?

**Guest** · 08.03.07, 12:10

if there's something wrong with this... post it here... i just converted this manually...[/b]

well done, it is working:D

**thanatos** · 08.03.07, 12:13

well done, it is working:D[/b]

tnx...

**wizard** · 08.03.07, 12:27

it should be in jpg format.. right? tnx wizard.. but i have a question about this script... why is it that when i add comment on the user pic my rating doesn't show... what's wrong with the script?[/b]

u must av done something wrong. it works in my xhtml. ill look@ it later. i gotta get ready for school now

**Guest** · 08.03.07, 12:39

Thanks guys...altho i am yet to test it myself but i'm still appreciative of the script!