ustalar YARDIM

blackwhiteeagle · Mesaj: 300+ Kayıt: Jun 20, 2006 Mesajlar: 301

<?php

if (eregi("block-Content.php", $_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}

global $prefix, $db;
$content = "";

$result = $db->sql_query("select * from ".$prefix."_pages where active='1'");
$pages = $db->sql_numrows($result);

$result = $db->sql_query("select * from ".$prefix."_pages_categories");
$cats = $db->sql_numrows($result);

$result = $db->sql_query("select counter from ".$prefix."_pages where active='1'");
$a = 1;
while(list($counter) = $db->sql_fetchrow($result)) {
$total_hits = $total_hits + $counter;
$a++;
}

$content .="Toplam Yazı: $pages Toplam Kategori: $cats Toplam Okuma: $total_hits ";

$content .="<hr>";
$content .="<img src=\"images/yenidersler.gif\" border=0> ";
$result = $db->sql_query("select pid, title from ".$prefix."_pages WHERE active='1' order by date DESC limit 0,10");
while(list($pid, $title) = $db->sql_fetchrow($result)) {
$title2= substr($title,0,20);
$content .= "<img src=\"images/icon_dot.gif\" border=0 valign=absmiddle> <a href=\"modules.php?name=Content&pa=showpage&pid=$pid\" title=\"$title\">$title2..</a> ";
}

$content .="<img src=\"images/populerdersler.gif\" border=0> ";
$result = $db->sql_query("select pid, title from ".$prefix."_pages WHERE active='1' order by counter DESC limit 0,10");
while(list($pid, $title) = $db->sql_fetchrow($result)) {
$title2= substr($title,0,20);
$content .= "<img src=\"images/icon_dot.gif\" border=0 valign=absmiddle> <a href=\"modules.php?name=Content&pa=showpage&pid=$pid\" title=\"$title\">$title2..</a> ";
}

$content.="";
mysql_free_result($result);
$blockfiletitle = "Dersler";

?>

arkadaşlar yukarıda yazan dersler bloğu. ben bunu kulklanıyorum. 4 tane içerik modülüm var. concent3 modülüne eklediklerimi bu blokta kayan yukarı kayan şekilde olarak nasıl gösterebilirim.

Bu Site Google Adsense ile Gelir Elde Ediyor · Tarih: 2024-07-08, 23:01:25 Mesaj konusu: Forum Arası Reklamlar

aslanonur · Tarih: 2006-07-28, 23:35:32 Mesaj konusu:

Content yazan yerleri Content3 yapıcaksın sql tablolarının adı neyse sql kodlarınıda öyle derliyeceksin sen sql tablolarının adını yaz istersen ben yapıyım yapamazsan

blackwhiteeagle · Mesaj: 300+ Kayıt: Jun 20, 2006 Mesajlar: 301

# Tabellenstruktur für Tabelle `nuke_pages_categories3`
#

CREATE TABLE `nuke_pages_categories3` (
`cid` int(10) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
PRIMARY KEY (`cid`),
KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Daten für Tabelle `nuke_pages_categories3`
#

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `nuke_pages_categories4`
#

CREATE TABLE `nuke_pages_categories4` (
`cid` int(10) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
PRIMARY KEY (`cid`),
KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Daten für Tabelle `nuke_pages_categories4`
#

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `nuke_pages_categories5`
#

CREATE TABLE `nuke_pages_categories5` (
`cid` int(10) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
PRIMARY KEY (`cid`),
KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Daten für Tabelle `nuke_pages_categories5`
#

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `nuke_pages_categories6`
#

CREATE TABLE `nuke_pages_categories6` (
`cid` int(10) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
PRIMARY KEY (`cid`),
KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Daten für Tabelle `nuke_pages_categories6`
#

# Tabellenstruktur für Tabelle `nuke_pages3`
#

CREATE TABLE `nuke_pages3` (
`pid` int(10) NOT NULL auto_increment,
`cid` int(10) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`subtitle` varchar(255) NOT NULL default '',
`active` int(1) NOT NULL default '0',
`page_header` text NOT NULL,
`text` text NOT NULL,
`page_footer` text NOT NULL,
`signature` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`counter` int(10) NOT NULL default '0',
`clanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`pid`),
KEY `pid` (`pid`),
KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Daten für Tabelle `nuke_pages3`
#

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `nuke_pages4`
#

CREATE TABLE `nuke_pages4` (
`pid` int(10) NOT NULL auto_increment,
`cid` int(10) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`subtitle` varchar(255) NOT NULL default '',
`active` int(1) NOT NULL default '0',
`page_header` text NOT NULL,
`text` text NOT NULL,
`page_footer` text NOT NULL,
`signature` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`counter` int(10) NOT NULL default '0',
`clanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`pid`),
KEY `pid` (`pid`),
KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Daten für Tabelle `nuke_pages4`
#

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `nuke_pages5`
#

CREATE TABLE `nuke_pages5` (
`pid` int(10) NOT NULL auto_increment,
`cid` int(10) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`subtitle` varchar(255) NOT NULL default '',
`active` int(1) NOT NULL default '0',
`page_header` text NOT NULL,
`text` text NOT NULL,
`page_footer` text NOT NULL,
`signature` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`counter` int(10) NOT NULL default '0',
`clanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`pid`),
KEY `pid` (`pid`),
KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Daten für Tabelle `nuke_pages5`
#

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `nuke_pages6`
#

CREATE TABLE `nuke_pages6` (
`pid` int(10) NOT NULL auto_increment,
`cid` int(10) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`subtitle` varchar(255) NOT NULL default '',
`active` int(1) NOT NULL default '0',
`page_header` text NOT NULL,
`text` text NOT NULL,
`page_footer` text NOT NULL,
`signature` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`counter` int(10) NOT NULL default '0',
`clanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`pid`),
KEY `pid` (`pid`),
KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Daten für Tabelle `nuke_pages6`
#

Sakal · Tarih: 2006-07-28, 23:49:32 Mesaj konusu:

tek yaptığım ".$prefix."_pages ve ".$prefix."_pages_categories in sonuna 3 ekledim

aslanonur · Tarih: 2006-07-28, 23:54:08 Mesaj konusu:

blackwhiteeagle · Mesaj: 300+ Kayıt: Jun 20, 2006 Mesajlar: 301

çok teşekkürler arkadaşlar.sağolun

aslanonur · Tarih: 2006-07-29, 00:01:49 Mesaj konusu:

Biz teşekkür ederiz çalıştıysa hayırlı çalışmalar diliyorum