Moduri

[ZooMLess]

Ajutatima pls cu asta! Deci cand vreau sa bag un mod prima oara trebuie sa fac ceva cu sql in databaze dar nu stiu unde sa bag textul acela : vreau sa instalez modul Forum_Icon_V1.1.0 si la sql este: ALTER TABLE phpbb_forums ADD forum_icon VARCHAR(255) DEFAULT NULL; cum o bag? si unde?

[Aliniuz]

Cod: Selectaţi tot

 ALTER TABLE phpbb_forums ADD forum_icon VARCHAR(255) DEFAULT NULL;

Este o comanda SQL ce trebuie executata in phpMyAdmin .

Afli URL-ul catre phpMyAdmin , te autentifici , selectezi baza de date din partea stanga , dai click pe butonul SQL din partea dreapta sus , copiezi comanda in acel camp dupa care dai GO sau Executare , depinde in ce limba e softul .

[ZooMLess]

Am vazut ca este in engleza!

[ZooMLess]

Este bine ?? Your SQL query has been executed successfully (Query took 0.1337 sec)
SQL query:
ALTER TABLE phpbb_forums ADD forum_icon VARCHAR( 255 ) DEFAULT NULL
[Edit] [Create PHP Code]

[Aliniuz]

Este foarte bine, ai executat corect comanda SQL .

Felicitari .

[ZooMLess]

Mersi mult! As vrea sa te inreb ceva!

Acesta este modul pe care vreau sa il instalez Forum_Icon_V1.1.0!
Dar aici <b>http://yourdomain/forum_path/images/for ... gif</b><br> then set it as <b>images/forum_icon/test.gif</b>'; // Forum Icon MODa pun exact cum e?


-----[ SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
ALTER TABLE phpbb_forums ADD forum_icon VARCHAR(255) DEFAULT NULL;
#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_admin.php
#
#-----[ FIND ]------------------------------------------
#
$lang['Forum_status']
#
#-----[ AFTER, ADD ]------------------------------------------
#
$lang['Forum_icon'] = 'Forum icon'; // Forum Icon MOD
$lang['Forum_icon_explain'] = 'e.g. If your image is at <b>http://yourdomain/forum_path/images/for ... gif</b><br> then set it as <b>images/forum_icon/test.gif</b>'; // Forum Icon MOD
#
#-----[ OPEN ]------------------------------------------
#
admin/admin_forums.php
#
#-----[ FIND ]------------------------------------------
#
$forumstatus = $row['forum_status'];
#
#-----[ AFTER, ADD ]------------------------------------------
#
$forumicon = $row['forum_icon']; // Forum Icon MOD
#
#-----[ FIND ]------------------------------------------
#
$forumstatus = FORUM_UNLOCKED;
#
#-----[ AFTER, ADD ]------------------------------------------
#
$forumicon = ''; // Forum Icon MOD
#
#-----[ FIND ]------------------------------------------
#
'L_FORUM_STATUS' => $lang['Forum_status'],
#
#-----[ AFTER, ADD ]------------------------------------------
#
'L_FORUM_ICON' => $lang['Forum_icon'], // Forum Icon MOD
'L_FORUM_ICON_EXPLAIN' => $lang['Forum_icon_explain'], // Forum Icon MOD
#
#-----[ FIND ]------------------------------------------
#
'DESCRIPTION' => $forumdesc)
#
#-----[ REPLACE WITH ]------------------------------------------
#
'DESCRIPTION' => $forumdesc,
'ICON' => ( $forumicon ) ? $forumicon : '', // Forum Icon MOD
'ICON_DISPLAY' => ( $forumicon ) ? '<img>' : '' // Forum Icon MOD
)
#
#-----[ FIND ]------------------------------------------
#
$sql = "INSERT INTO " . FORUMS_TABLE
#
#-----[ IN-LINE FIND ]------------------------------------------
#
, forum_status
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, forum_icon
#
#-----[ FIND ]------------------------------------------
#
VALUES ('" . $next_id . "', '" .
#
#-----[ IN-LINE FIND ]------------------------------------------
#
, " . intval($HTTP_POST_VARS['forumstatus']) . "
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "'
#
#-----[ FIND ]------------------------------------------
#
SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "'
#
#-----[ IN-LINE FIND ]------------------------------------------
#
, forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . "
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, forum_icon = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "'
#
#-----[ FIND ]------------------------------------------
#
'FORUM_DESC' => $forum_rows[$j]['forum_desc'],
#
#-----[ AFTER, ADD ]------------------------------------------
#
'FORUM_ICON_IMG' => ( $forum_rows[$j]['forum_icon'] ) ? '<img>' : '', // Forum Icon Mod
#
#-----[ OPEN ]------------------------------------------
#
index.php
#
#-----[ FIND ]------------------------------------------
#
$posts = $forum_data[$j]['forum_posts'];
$topics = $forum_data[$j]['forum_topics'];
#
#-----[ AFTER, ADD ]------------------------------------------
#
$icon = $forum_data[$j]['forum_icon']; // Forum Icon Mod
#
#-----[ FIND ]------------------------------------------
#
'FORUM_FOLDER_IMG' => $folder_image,
#
#-----[ AFTER, ADD ]------------------------------------------
#
'FORUM_ICON_IMG' => ($icon) ? '<img>' : '', // Forum Icon Mod
#
#-----[ OPEN ]------------------------------------------
#
viewforum.php
#
#-----[ FIND ]------------------------------------------
#
'FORUM_NAME' => $forum_row['forum_name'],
#
#-----[ AFTER, ADD ]------------------------------------------
#
'FORUM_ICON_IMG' => ($forum_row['forum_icon']) ? '<img>&nbsp;' : '', // Forum Icon Mod
#
#-----[ OPEN ]------------------------------------------
#
viewtopic.php
#
#-----[ FIND ]------------------------------------------
#
//
// End auth check
//
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Forum Icon Mod
$sql = "SELECT forum_icon
FROM " . FORUMS_TABLE . "
WHERE forum_id = $forum_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain forums information', '', __LINE__, __FILE__, $sql);
}
$forum_row = $db->sql_fetchrow($result);
$forum_icon = $forum_row['forum_icon'];
#
#-----[ FIND ]------------------------------------------
#
'FORUM_NAME' => $forum_name,
#
#-----[ AFTER, ADD ]------------------------------------------
#
'FORUM_ICON_IMG' => ($forum_icon) ? '<img>&nbsp;' : '', // Forum Icon Mod
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/admin/forum_edit_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<td><input></td>
</tr>
#
#-----[ AFTER, ADD ]------------------------------------------
#
<tr>
<td>{L_FORUM_ICON}<br><span>{L_FORUM_ICON_EXPLAIN}</span></td>
<td><input>&nbsp;&nbsp;&nbsp;{ICON_DISPLAY}</td>
</tr>
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/admin/forum_admin_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<td><span><a href="{catrow.forumrow.U_VIEWFORUM}" target="_new">{catrow.forumrow.FORUM_NAME}</a></span>
#
#-----[ IN-LINE FIND ]------------------------------------------
#
<td><span>
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
{catrow.forumrow.FORUM_ICON_IMG}&nbsp;&nbsp;
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/index_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<td><span> <a href="{catrow.forumrow.U_VIEWFORUM}" class="forumlink">{catrow.forumrow.FORUM_NAME}</a><br>
</span> <span>{catrow.forumrow.FORUM_DESC}<br>
</span><span>{catrow.forumrow.L_MODERATOR} {catrow.forumrow.MODERATORS}</span></td>
#
#-----[ REPLACE WITH ]------------------------------------------
#
<td><table>
<tr><td><a href="{catrow.forumrow.U_VIEWFORUM}" class="forumlink">{catrow.forumrow.FORUM_ICON_IMG}</a></td>
<td><span><a href="{catrow.forumrow.U_VIEWFORUM}" class="forumlink">{catrow.forumrow.FORUM_NAME}</a><br>
</span> <span>{catrow.forumrow.FORUM_DESC}<br>
</span><span>{catrow.forumrow.L_MODERATOR} {catrow.forumrow.MODERATORS}</span>
</td>
</tr>
</table></td>
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/viewforum_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<td><a class="maintitle" href="{U_VIEW_FORUM}">{FORUM_NAME}</a>
#
#-----[ IN-LINE FIND ]------------------------------------------
#
<td>
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
<a class="maintitle" href="{U_VIEW_FORUM}">{FORUM_ICON_IMG}</a>
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/viewtopic_body.tpl
#
#-----[ FIND ]------------------------------------------
#
-> <a href="{U_VIEW_FORUM}" class="nav">{FORUM_NAME}</a></span></td>
#
#-----[ IN-LINE FIND ]------------------------------------------
#
<a href="{U_VIEW_FORUM}" class="nav">
#
#-----[ IN-LINE BEFORE, ADD ]------------------------------------------
#
<a href="{U_VIEW_FORUM}" class="nav">{FORUM_ICON_IMG}</a>
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
#
# EoM

[Aliniuz]

Da, daca era ceva de lnlocuit ti se preciza , acolo ti se daduse doar un exemplu .

Si nu e nevoie sa postezi tot MODul .

[ZooMLess]

Ok,s deci copiez exact ce este acolo nu? fara sa modific? A am uitat si dami si mie un link de unde ai luat iconurile tale pt forum pls!

[Aliniuz]

Nu am fost destul de explicit in mesajul precedent ?

Ok,s deci copiez exact ce este acolo nu? fara sa modific?

DA !

[ZooMLess]

Da-mi si mie un link de unde sa iau iconuri ca ale tale ! De pe forumul tau!