Nevoie urgenta de ajutor
Reguli forum
Aveti o problema si vreti sa primiti ajutor? Click aici ! Nu uitati si de regulamentul forumului !
Aveti o problema si vreti sa primiti ajutor? Click aici ! Nu uitati si de regulamentul forumului !
- octaviansan
- Utilizator înregistrat
- Mesaje: 1124
- Membru din: 28-Iun-2006, 13:56:23
- Ext: Nu
- Server: Windows
- Nivel phpBB: Mediu
- Nivel php: Mediu
- Localitate: Bucureşti, RO
- Contact:
uite aici , citeste :
#########################################################################
## Title: Banlist For phpBB2 ....
## Author: ThE DrAgOn'S <orna_h@012.net.il>
## Description : This Mod Will Give You a Page Of All The User's That
## Have Been Ban From Your Board ....... Including Reason Option And
## "Band by" & "Band date" <@:-)
##
## Mod Version : 1.0.3 Finel !
##
## Installation Level: Easy
## Installation Time: 7 Minutes
##
## Files To Edit: 5
## language/lang_english/lang_main.php
## admin/admin_user_ban.php
## includes/page_header.php
## templates/SubSilver/user_ban_body.tpl
## templates/SubSilver/overall_header.tpl
##
## Included Files: 4
## banlist.php
## templates/SubSilver/banlist_body.tpl
## templates/SubSilver/images/icon_mini_out.gif
## ban_update.php
##
#########################################################################
##
## Author Note ::
##
## Copyright's © ThE DrAgOn'S, 2003
##
## For Any Concerns Please Contact Me At orna_h@012.net.il Or Icq 2233432
##
## Spicel Thanx To Acyd Burn, And Morpheus2matrix For Helping Me
##
#########################################################################
##
## Installation Note:
## First Upload banlist.php To phpBB2/
## Then Upload banlist_body.tpl To templates/subsilver/banlist_body.tpl
## And templates/subsilver/images/icon_mini_out.gif
##
#########################################################################
#
#-----[ First Upload ... ]-------------------------------------
#
ban_update.php To /phpBB2
And Run It In Order To Run It Go To Your Internet Explorer And
In www.yourdomin.com/phpbb2/index.php Just Do
www.yourdomin.com/phpbb2/ban_update.php Dont Forget
To Delete The File Once You Done
#
#-----[ OPEN ]-------------------------------------
#
admin/admin_user_ban.php
#
#-----[ FIND ]--------------------------------------
#
$sql = "INSERT INTO " . BANLIST_TABLE . " (ban_userid)
VALUES (" . $user_list[$i] . ")";
#
#-----[ REPLACE BY ]-------------------------
#
$sql = "SELECT username FROM " . USERS_TABLE . " WHERE user_id = " . $user_list[$i];
if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Unable to get username', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$user_name = trim($row['username']); // for mssql compatibility
$sql = "INSERT INTO " . BANLIST_TABLE . " (ban_userid, user_name, reason, baned_by, date, time) VALUES (" . $user_list[$i] . ", '" . addslashes($user_name) . "', '" . addslashes($reason) . "', '" . addslashes($userdata['username']) . "', '". date("m.d.y") . "', '".date("H:i")."')";
#
#-----[ FIND ]--------------------------------------
#
'L_USERNAME' => $lang['Username']
#
#-----[ AFTER ADD ]-------------------------------------
#
'L_REASON' => $lang['Reason'],
#
#-----[ OPEN ]---------------------------------------------
#
includes/page_header.php
#
#-----[ FIND ]------------------------------------------------
#
$template->assign_vars(array(
#
#-----[ AFTER ADD ]-------------------------------------
#
'BAN_NAME' => $lang['Ban_Name'],
'BAN_REASON' => $lang['Reason'],
'BAN_BY' => $lang['Ban_By'],
'BAN_DATE' => $lang['Ban_Date'],
'L_BAN' => $lang['Ban'],
'U_BAN' => append_sid('banlist.'.$phpEx),
#
#-----[ OPEN ]-------------------------------------
#
templates/subsilver/user_ban_body.tpl
#
#-----[ FIND ]-------------------------------------
#
<tr>
<td class="row1">{L_USERNAME}:</td>
<td class="row2"><input type="text" class="post" name="username" maxlength="50" size="20" /> <input type="hidden" name="mode" value="edit" />{S_HIDDEN_FIELDS} <input type="submit" name="usersubmit" value="{L_FIND_USERNAME}" class="liteoption" onClick="window.open('{U_SEARCH_USER}', '_phpbbsearch', 'HEIGHT=250,resizable=yes,WIDTH=400');return false;" /></td>
</tr>
#
#-----[ ADD AFTER ]-------------------------------------
#
<tr>
<td class="row1">{L_REASON}:</td>
<td class="row2"><input type="text" class="post" name="reason" maxlength="75" size="35"></td>
</tr>
#
#-----[ OPEN ]-------------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]----------------------------------------
#
//
// Common, these terms are used
// extensively on several pages
//
#
#-----[ ADD AFTER ]----------------------------------------
#
$lang['Ban'] = "Ban List";
$lang['Ban_Name'] = "User Name";
$lang['Reason'] = "Ban Reason";
$lang['Ban_By'] = "Ban By : ";
$lang['Ban_Date'] = "Ban Time ";
#
#-----[ FIND ]----------------------------------------
#
$lang['Memberlist'] = 'Memberlist';
#
#-----[ AFTER ADD ]-----------------------------
#
$lang['Banlist'] = 'Banlist';
#
#-----[ OPEN ]--------------------------------------
#
templates/subsilver/overall_header.tpl
#
#-----[ FIND ]----------------------------------------
#
<a href="{U_MEMBERLIST}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_members.gif" width="12" height="13" border="0" alt="{L_MEMBERLIST}" hspace="3" />
{L_MEMBERLIST}</a> </span></td>
#
#-----[ BEFORE ADD ]-----------------------------
#
<a href="{U_BANLIST}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_out.gif" width="12" height="13" border="0" alt="{L_BANLIST}" hspace="3" />{L_BANLIST}</a></span><span class="mainmenu">
#---------[ Save Close All Files ]-------------------------
#
# EoM
daca nu intelegi ceva intreaba-ma
#########################################################################
## Title: Banlist For phpBB2 ....
## Author: ThE DrAgOn'S <orna_h@012.net.il>
## Description : This Mod Will Give You a Page Of All The User's That
## Have Been Ban From Your Board ....... Including Reason Option And
## "Band by" & "Band date" <@:-)
##
## Mod Version : 1.0.3 Finel !
##
## Installation Level: Easy
## Installation Time: 7 Minutes
##
## Files To Edit: 5
## language/lang_english/lang_main.php
## admin/admin_user_ban.php
## includes/page_header.php
## templates/SubSilver/user_ban_body.tpl
## templates/SubSilver/overall_header.tpl
##
## Included Files: 4
## banlist.php
## templates/SubSilver/banlist_body.tpl
## templates/SubSilver/images/icon_mini_out.gif
## ban_update.php
##
#########################################################################
##
## Author Note ::
##
## Copyright's © ThE DrAgOn'S, 2003
##
## For Any Concerns Please Contact Me At orna_h@012.net.il Or Icq 2233432
##
## Spicel Thanx To Acyd Burn, And Morpheus2matrix For Helping Me
##
#########################################################################
##
## Installation Note:
## First Upload banlist.php To phpBB2/
## Then Upload banlist_body.tpl To templates/subsilver/banlist_body.tpl
## And templates/subsilver/images/icon_mini_out.gif
##
#########################################################################
#
#-----[ First Upload ... ]-------------------------------------
#
ban_update.php To /phpBB2
And Run It In Order To Run It Go To Your Internet Explorer And
In www.yourdomin.com/phpbb2/index.php Just Do
www.yourdomin.com/phpbb2/ban_update.php Dont Forget
To Delete The File Once You Done
#
#-----[ OPEN ]-------------------------------------
#
admin/admin_user_ban.php
#
#-----[ FIND ]--------------------------------------
#
$sql = "INSERT INTO " . BANLIST_TABLE . " (ban_userid)
VALUES (" . $user_list[$i] . ")";
#
#-----[ REPLACE BY ]-------------------------
#
$sql = "SELECT username FROM " . USERS_TABLE . " WHERE user_id = " . $user_list[$i];
if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Unable to get username', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$user_name = trim($row['username']); // for mssql compatibility
$sql = "INSERT INTO " . BANLIST_TABLE . " (ban_userid, user_name, reason, baned_by, date, time) VALUES (" . $user_list[$i] . ", '" . addslashes($user_name) . "', '" . addslashes($reason) . "', '" . addslashes($userdata['username']) . "', '". date("m.d.y") . "', '".date("H:i")."')";
#
#-----[ FIND ]--------------------------------------
#
'L_USERNAME' => $lang['Username']
#
#-----[ AFTER ADD ]-------------------------------------
#
'L_REASON' => $lang['Reason'],
#
#-----[ OPEN ]---------------------------------------------
#
includes/page_header.php
#
#-----[ FIND ]------------------------------------------------
#
$template->assign_vars(array(
#
#-----[ AFTER ADD ]-------------------------------------
#
'BAN_NAME' => $lang['Ban_Name'],
'BAN_REASON' => $lang['Reason'],
'BAN_BY' => $lang['Ban_By'],
'BAN_DATE' => $lang['Ban_Date'],
'L_BAN' => $lang['Ban'],
'U_BAN' => append_sid('banlist.'.$phpEx),
#
#-----[ OPEN ]-------------------------------------
#
templates/subsilver/user_ban_body.tpl
#
#-----[ FIND ]-------------------------------------
#
<tr>
<td class="row1">{L_USERNAME}:</td>
<td class="row2"><input type="text" class="post" name="username" maxlength="50" size="20" /> <input type="hidden" name="mode" value="edit" />{S_HIDDEN_FIELDS} <input type="submit" name="usersubmit" value="{L_FIND_USERNAME}" class="liteoption" onClick="window.open('{U_SEARCH_USER}', '_phpbbsearch', 'HEIGHT=250,resizable=yes,WIDTH=400');return false;" /></td>
</tr>
#
#-----[ ADD AFTER ]-------------------------------------
#
<tr>
<td class="row1">{L_REASON}:</td>
<td class="row2"><input type="text" class="post" name="reason" maxlength="75" size="35"></td>
</tr>
#
#-----[ OPEN ]-------------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]----------------------------------------
#
//
// Common, these terms are used
// extensively on several pages
//
#
#-----[ ADD AFTER ]----------------------------------------
#
$lang['Ban'] = "Ban List";
$lang['Ban_Name'] = "User Name";
$lang['Reason'] = "Ban Reason";
$lang['Ban_By'] = "Ban By : ";
$lang['Ban_Date'] = "Ban Time ";
#
#-----[ FIND ]----------------------------------------
#
$lang['Memberlist'] = 'Memberlist';
#
#-----[ AFTER ADD ]-----------------------------
#
$lang['Banlist'] = 'Banlist';
#
#-----[ OPEN ]--------------------------------------
#
templates/subsilver/overall_header.tpl
#
#-----[ FIND ]----------------------------------------
#
<a href="{U_MEMBERLIST}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_members.gif" width="12" height="13" border="0" alt="{L_MEMBERLIST}" hspace="3" />
{L_MEMBERLIST}</a> </span></td>
#
#-----[ BEFORE ADD ]-----------------------------
#
<a href="{U_BANLIST}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_out.gif" width="12" height="13" border="0" alt="{L_BANLIST}" hspace="3" />{L_BANLIST}</a></span><span class="mainmenu">
#---------[ Save Close All Files ]-------------------------
#
# EoM
daca nu intelegi ceva intreaba-ma
- Trask Konoda
- Utilizator înregistrat
- Mesaje: 192
- Membru din: 05-Aug-2006, 18:13:57
- Ext: Nu
- Server: Windows
- Nivel phpBB: Mediu
- Nivel php: Mediu
- Contact:
el vrea instructiunile in romana. Nu cred ca se oboseste cineva sa-l e traduca. Hmm...de fapt, nici nu trebuie tradus in totalitate
Files To Edit: >>> Fisiere care trebuiesc editate
Included Files >>> fisiere pe care le contine mod-ul si trebuie sa le uploadezi pe server.
first - intai
open - deschide
find - gaseste
replace by - inlocuieste cu
after add - adauga dupa
before add - adauga inainte
Files To Edit: >>> Fisiere care trebuiesc editate
Included Files >>> fisiere pe care le contine mod-ul si trebuie sa le uploadezi pe server.
first - intai
open - deschide
find - gaseste
replace by - inlocuieste cu
after add - adauga dupa
before add - adauga inainte
<a href="http://www.plodul-gandirii.blogspot.com" title="Cugetari">Cugetari</a>
- Trask Konoda
- Utilizator înregistrat
- Mesaje: 192
- Membru din: 05-Aug-2006, 18:13:57
- Ext: Nu
- Server: Windows
- Nivel phpBB: Mediu
- Nivel php: Mediu
- Contact:
pai si daca stii limba engleza pentru ce mai ceri instructiunile in romana?
Daca zice "replace by", inlocuiesti.
Daca zice "replace by", inlocuiesti.
<a href="http://www.plodul-gandirii.blogspot.com" title="Cugetari">Cugetari</a>
- octaviansan
- Utilizator înregistrat
- Mesaje: 1124
- Membru din: 28-Iun-2006, 13:56:23
- Ext: Nu
- Server: Windows
- Nivel phpBB: Mediu
- Nivel php: Mediu
- Localitate: Bucureşti, RO
- Contact:
- Trask Konoda
- Utilizator înregistrat
- Mesaje: 192
- Membru din: 05-Aug-2006, 18:13:57
- Ext: Nu
- Server: Windows
- Nivel phpBB: Mediu
- Nivel php: Mediu
- Contact:
asta nu inseamna ca nu a mers tot. Deschide in browser fisierul banlist.php si vezi daca merge. Daca merge, inseamna ca nu ai reusit sa pui banlist-ul in meniu din cauza templateului. Cauta meniul din template si adauga acolo si linkul catre banlist.
<a href="http://www.plodul-gandirii.blogspot.com" title="Cugetari">Cugetari</a>
- octaviansan
- Utilizator înregistrat
- Mesaje: 1124
- Membru din: 28-Iun-2006, 13:56:23
- Ext: Nu
- Server: Windows
- Nivel phpBB: Mediu
- Nivel php: Mediu
- Localitate: Bucureşti, RO
- Contact:
- J4cK
- Utilizator înregistrat
- Mesaje: 210
- Membru din: 14-Aug-2006, 10:45:27
- Ext: Nu
- Server: Windows
- Nivel phpBB: Mediu
- Nivel php: Mediu
- Localitate: Iasi
- Contact:
Man am facut asha si mia dat urmatoarea eroare
Cod: Selectaţi tot
Could not query users
DEBUG MODE
SQL Error : 1146 Table 'designj_z1_ro.phpbb_banlist' doesn't exist
SELECT ban_userid,user_name,reason,baned_by,date,time FROM phpbb_banlist WHERE ban_userid <> 0 ORDER BY ban_id DESC LIMIT 0, 900
Line : 56
File : banlist.php
Cine este conectat
Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 1 vizitator