Pełna wersja: Unofficial modifications

**KnofeL** Wysłany: Nie 01 Lip, 2007

Table 'db4184.ADS_TABLE' doesn't exist = Tabela nie istnieje
#1062 - Duplicate entry 'ad_after_post' for key 1 = Wpis znajduj? si? ju? w tabeli.

**zelgadiss** Wysłany: Nie 01 Lip, 2007

tyle to sie domyslilem, ale co mam teraz zrobic?
robie wszystko od poczatku i znowu to samo.
jak mam ta tabele zrobic? wykonuje zapytanie do sql

KodCREATE TABLE `phpbb_ads` (
`ad_type` VARCHAR( 10 ) NOT NULL ,
`ad_id` TINYINT( 5 ) NOT NULL ,
`ad_code` TEXT NOT NULL ,
`ad_name` TINYINT( 25 ) NOT NULL,
UNIQUE (
`ad_id`
)
);

i pozniej

KodINSERT INTO `phpbb_ads` ( `ad_type` , `ad_id` , `ad_code`, `ad_name` )
VALUES (
'first_post', '1', '<script type="text/javascript"></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>', 'Defualt'
);

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_after_post', '1'
);

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_every_post', '0'
);

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_who', 'all'
);

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_forums', 'all'
);

**KnofeL** Wysłany: Pon 02 Lip, 2007

SQL Error : 1146 Table 'db4184.ADS_TABLE' doesn't exist

INSERT INTO `phpbb_ads` ( `ad_type` ,

**ShaveX** Wysłany: Pon 13 Sie, 2007

KnofeL, ja mam ten sam problem cozelgadiss :( trzeba wykona? te zapytanie?

KodINSERT INTO `phpbb_ads` ( `ad_type` ,

**KnofeL** Wysłany: Pon 13 Sie, 2007

ShaveX, a jaki jest prefix Twojej bazy danych ??

**ShaveX** Wysłany: Pon 13 Sie, 2007

KnofeL, phpbb_przemo :]

**KnofeL** Wysłany: Wto 14 Sie, 2007

Ok no to w takim razie, oznacza to ?e ta tabela ju? istnieje (mozesz to sprawdzi? w PhpMyAdminie) wi?c teraz wykonaj pozosta?e zapytania

**InTWO** Wysłany: Sob 29 Wrz, 2007

Jest OK.

Brakuj?ce pliki czyli

admin_firstpost_ad.php
firstpost_ad_body.tpl

do??czy?em do tego postu. Nikt nie wpad?, ?eby to zrobi? wcze?niej. Ech...

Przy uwzgl?dnieniu wskaz?wek, wsio jest OK.

Je?li kto? chce pe?ny tekst dzia?aj?cego moda w wersji udaj?cej bota na forum, prosz? bardzo:

Wiadomo?? ukryta / Hidden messageAby zobaczy? wiadomo?? postaw piwo autorowi piwo.

###################################################################
## Installation Level: Easy
## Installation Time: 11 minutes
## Files To Edit: viewtopic.php
## includes/constants.php
## templates/subSilver/overall_header.tpl
## templates/subSilver/viewtopic_body.tpl
## language/lang_english/lang_admin.php
## Included Files: (admin_firstpost_ad.php, firstpost_ad_body.tpl)
###################################################################

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE `phpbb_ads` (
`ad_type` VARCHAR( 10 ) NOT NULL ,
`ad_id` TINYINT( 5 ) NOT NULL ,
`ad_code` TEXT NOT NULL ,
`ad_name` TINYINT( 25 ) NOT NULL,
UNIQUE (
`ad_id`
)
);

INSERT INTO `phpbb_ads` ( `ad_type` , `ad_id` , `ad_code`, `ad_name` )
VALUES ( 'first_post', '1', 'tresc testowa - potem to edytujesz to w PA', 'Defualt' );

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES ( 'ad_after_post', '1' );

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES ( 'ad_every_post', '0' );

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES ( 'ad_who', 'all' );

INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES ( 'ad_forums', 'all' );

#
#-----[ SKOPIUJ ]------------------------------------------
#
kopiuj firstpost_ad_body.tpl do templates/subSilver/admin/firstpost_ad_body.tpl
kopiuj admin_firstpost_ad.php do admin/admin_firstpost_ad.php
#
#-----[ Otworz ]------------------------------------------
#

viewtopic.php
#
#-----[ Znajdz ]------------------------------------------
#
// Helped end

#
#-----[ Dodaj po ]------------------------------------------
#
$display_ad = false;
if ($board_config['ad_forums'] == 'all'){
$display_ad = true;
}else{
$ad_forums = explode(",", $board_config['ad_forums']);
for ($a=0; $a < count($ad_forums); $a++){
if ($forum_id == $ad_forums[$a]){
$display_ad = true;
break;
}
}
}
if ($display_ad){
if ($board_config['ad_who'] == 'all' || ($board_config['ad_who'] == 'guest' && $userdata['user_id'] == -1) || ($board_config['ad_who'] == 'reg' && $userdata['user_id'] != -1))
{
if (($board_config['ad_after_post'] != 0 && $i == $board_config['ad_after_post'] - 1)||($board_config['ad_every_post'] != 0 && ($i + 1) % $board_config['ad_every_post'] == 0))
{
$sql = "SELECT a.ad_code
FROM " . ADS_TABLE . " a
WHERE a.ad_id=1";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query ad information', '', __LINE__, __FILE__, $sql);
}
$adRow = array();
while( $row = $db->sql_fetchrow($result) )
{
$adRow[] = $row;
}
$db->sql_freeresult($result);
//

// wersja bez modyfikacji z botem :
// $post_ad = '<tr><td colspan=2 class="firstPostAd">' . $adRow[0]['ad_code'] . '</td></tr>';

// ####################
// # wersja udaj±ca bota na forum
// ####################

$post_ad = '<tr>
<td align="left" valign="top" class="row2" nowrap="nowrap" width="150">
<span class="name"><a name="1703">
</a><b><a href=" class="gensmall" style="font-size: 12">Reklama Bot</a></b> <img src="templates/subSilver/images/icon_minigender_male.gif" width="11" height="11" alt="" border="0" /> <br />
</span>
<span class="postdetails"><br />
<br /><br /><br><br><br><br>
Posty: 0<br />Sk?d: Graffik.biz<br />Nr U?ytkownika: 0<br /><br />Status: <a href=viewonline.php style="text-decoration: none"><font color="green"><b>Online</b></font></a><br /><br /></span>
</td>
<td class="row2" width="100%" height="100%" valign="top">
<table width="100%" style="height: 100%;" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top" align="left">
</span></td>
<td valign="top" align="right" nowrap="nowrap"></span><br></td>
</tr>
<tr>
<td colspan="2"><span class="gensmall"><object><hr></object></span></td>
</tr>
<tr>
<td height="100%" valign="top" colspan="2" ><span class="postbody">

'. $adRow[0]['ad_code'] . '

<img src="images/smiles/icon_cool.gif" alt="8-)" title="8-)" border="0" align="top" /> </span></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="row2" align="left" valign="middle">
<a href="#top"><img src="templates/subSilver/images/topic_move.gif" width="20" height="20" alt="" border="0" /></a> </td>
<td class="row2" width="100%" valign="top" nowrap="nowrap">
<table cellspacing="0" cellpadding="0" border="0" width="100%">
<tr>
<td valign="top" nowrap="nowrap">
</td>
<td valign="top" align="left" width="177">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse">
<tr> <td> </td>
<td width="59" height="19" valign="top">
</td> <td> </td>
<td nowrap="nowrap"> </td>
</tr>
</table>
</td>
<td width="100%" align="right"><span class="nav">
<img src="templates/subSilver/images/user_agent/icon_linux_freebsd.gif" alt="" /> <img src="templates/subSilver/images/user_agent/icon_qnx.gif" alt="" title="Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; pl) Opera 8.54" /></span>
</td>
</tr>
</table>
</td>
</tr>

<tr>
<td class="spaceRow" colspan="2" height="1"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td>
</tr>';

}
else
{
$post_ad = ' ';
}
}
}
#
#-----[ Znajdz ]------------------------------------------
#
'DELETE' => $delpost,

#
#-----[ Dodaj po ]------------------------------------------
#
'POST_AD' => $post_ad,
#
#-----[ Otworz ]------------------------------------------
#

includes/constants.php
#
#-----[ Znajdz ]------------------------------------------
#
define('VOTE_USERS_TABLE', $table_prefix . 'vote_voters');
#
#-----[ Dodaj po ]------------------------------------------
#
define('ADS_TABLE', $table_prefix.'ads');

#
#-----[ Otworz ]------------------------------------------
#

templates/subSilver/subSilver.css
#
#-----[ Znajdz ]------------------------------------------
#
.helpline { background-color: {T_TR_COLOR2}; border-style: none; }
#
#-----[ Dodaj po ]------------------------------------------
#
td.firstPostAd {
background-color: {T_TR_COLOR3}; border: {T_TH_COLOR3}; border-style: solid; border-width: 1px; text-align: center;
}
#
#-----[ Otworz ]------------------------------------------
#

templates/subSilver/viewtopic_body.tpl
#
#-----[ Znajdz ]------------------------------------------
#


#
#-----[ Dodaj przed ]------------------------------------------
#
{postrow.POST_AD}

#
#-----[ Otworz ]------------------------------------------
#

language/lang_polish/lang_admin.php
#
#-----[ Znajdz ]------------------------------------------
#
//
// That's all Folks!
// -------------------------------------------------
#
#-----[ Dodaj przed ]------------------------------------------
#
$lang['ad_managment'] = 'Banner po poscie';
$lang['first_post_ad'] = 'Konfiguracja';
$lang['firstpost_ad'] = 'Konfiguracja modulu.';
$lang['Click_return_firstpost'] = 'Kliknij %stutaj%s by powrocic do konfiguracji';
$lang['ad_after_post'] = 'Dodawaj zawsze po x poscie';
$lang['ad_every_post'] = 'Dodawaj zawsze po x postach';
$lang['ad_display'] = 'Pokazuj';
$lang['ad_all'] = 'Wszystkim';
$lang['ad_reg'] = 'Zarejestrowanym';
$lang['ad_guest'] = 'Goscia';
$lang['ad_forums'] = 'Wyswietlaj w forach';
$lang['ad_code'] = 'Kod';

#
#-----[ Otworz ]------------------------------------------
#
admin/modules_data.php

#
#-----[ Znajdz ]------------------------------------------
#

'Poll Admin' => array(
'Poll Results' => array("admin_voting.$phpEx", 55),
),

#
#-----[ Dodaj po ]------------------------------------------
#
'Banner pod X postem' => array(
'ad_managment' => array("admin_firstpost_ad.$phpEx", 80),
),

#
#-----[ Otworz ]------------------------------------------
#
admin/admin_firstpost_ad.php

#
#-----[ Znajdz ]------------------------------------------
#
define('IN_PHPBB', 1);

#
#-----[ Dodaj przed ]------------------------------------------
#
define('MODULE_ID', 80);

##############
## Zapisz i zamknij wszystkie pliki

Ma?a uwaga: nale?y zabezpieczy? w PA mo?liwo?? rejestracji usera o nazwie wpisanej jako bot. Ale to juz drobnostka... ;)

**They** Wysłany: Nie 21 Paź, 2007

tobiasty napisał/awszystko dziala ok ;) tylko jak sie pozbyc tej beleczki (ze screena) nad postem niby bota google :] w pliku css masz kod koloru beleczki w linii
Kod.forumline { background-color: