Sql help (Gallery)

**~~riderz~~** · 29.09.09, 17:55

ok ive made this but now the images dnt display

Code:

--
-- Table structure for table `ibwf_prate`
--

CREATE TABLE IF NOT EXISTS `ibwf_prate` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `blogid` int(100) NOT NULL DEFAULT '0',
  `uid` int(100) NOT NULL DEFAULT '0',
 `pid` int(100) NOT NULL DEFAULT '0',
  `prate` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2095 ;

--
-- Dumping data for table `ibwf_prate`
--
-- Table structure for table `ibwf_galcom`
--

CREATE TABLE IF NOT EXISTS `ibwf_galcom` (
  `id` int(11) NOT NULL DEFAULT '0',
  `uid` int(11) NOT NULL DEFAULT '0',
   `pid` int(100) NOT NULL DEFAULT '0'
 `text' blob NOT NULL,
 `byuser` int(100) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ibwf_galcom`
--

**lee27** · 30.09.09, 16:23

this is what i use on mine

Code:

-- 
-- Table structure for table `ibwf_prate`
-- 
CREATE TABLE `ibwf_prate` (
  `id` int(100) NOT NULL auto_increment,
  `pid` int(100) NOT NULL default '0',
  `uid` int(100) NOT NULL default '0',
  `prate` char(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- 
-- Dumping data for table `ibwf_prate`
--

Code:

-- 
-- Table structure for table `ibwf_galcomments`
-- 
CREATE TABLE `ibwf_galcomments` (
  `id` int(99) NOT NULL auto_increment,
  `pid` int(99) NOT NULL default '0',
  `text` varchar(200) NOT NULL default '',
  `byuser` varchar(100) NOT NULL default '',
  `time` varchar(99) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- 
-- Dumping data for table `ibwf_galcomments`
--

**spiderwebs** · 30.09.09, 17:11

change auto_increment to 1 it will work

Originally posted by riderz View Post

ok ive made this but now the images dnt display

Code:

--
-- Table structure for table `ibwf_prate`
--

CREATE TABLE IF NOT EXISTS `ibwf_prate` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `blogid` int(100) NOT NULL DEFAULT '0',
  `uid` int(100) NOT NULL DEFAULT '0',
 `pid` int(100) NOT NULL DEFAULT '0',
  `prate` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2095 ;

--
-- Dumping data for table `ibwf_prate`
--
-- Table structure for table `ibwf_galcom`
--

CREATE TABLE IF NOT EXISTS `ibwf_galcom` (
  `id` int(11) NOT NULL DEFAULT '0',
  `uid` int(11) NOT NULL DEFAULT '0',
   `pid` int(100) NOT NULL DEFAULT '0'
 `text' blob NOT NULL,
 `byuser` int(100) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ibwf_galcom`
--

**crazybrumi** · 30.09.09, 17:14

from when io briefly look over it yesterday and was speaking to u i couldnt actully see an image source in there

**~~riderz~~** · 30.09.09, 17:21

yea i see also it give link like this

http://site.com/0 so it dnt fetch the image from correct place

**~~riderz~~** · 30.09.09, 20:05

who can help me with this part this part are suppose to show the image but it doesnt

Code:

 if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
      $id = $item[0];
        $img = $item[2];


        $lnk = "<img src=\"$img\" alt=\"$id\" width=\"100\" height=\"80\"/><br/>";
    $rinfo = mysql_fetch_array(mysql_query("SELECT COUNT(*) as nofr, SUM(prate) as nofp FROM ibwf_prate WHERE pid='".$id."'"));
$counts = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_prate WHERE pid='".$id."'"));
if($counts[0]>0) {
    $ther = $rinfo[1]/$rinfo[0];
    $rating = "Rating: $ther/$rinfo[1] votes <b>($counts[0])</b><br/>";
}else{
$rating = "";
}

**WhiteWarrior** · 30.09.09, 23:52

the $lnk part is the photo if its grabbing i from the right place...

echo "$lnk"; will show the photo, but we cant see if your already doing that because it looks like a few lines of a whole file

**icen01** · 03.10.09, 03:29

can anyone repost the sql of that ibwf_galcom cause theres an error when i put in my phpmyadmin thanks

**Mysterio** · 04.10.09, 01:49

the mistake is not in the sql, bro. I had the same problem, but i corrected it. I must know in which directory are your images being uploaded. So, in the upload.php (or where the sql updates are being done), modify the code, so, let be updated only the filename. Then, change the src image to <img src=\"(the-images-dir)/$filename\">

Sql help (Gallery)

Sql help (Gallery)

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment