Color Groups

[JOKERULLZ]

Sal, am instalat in sfarsit Color Groups , intru in panelul administratorului si la Administrare grupuri imi apare Color Groups , dau click ,fac add new group , ami apare acolo sus apoi dar cand intru pe forum nu mi apare jos grupul !

Si inca, cand ma loghez ami apare culoarea acolo la nick ca la ceilalti useri, desi sunt administrator, dc ?

[octaviansan]

reia instalarea in index_body.tpl .

[JOKERULLZ]

Ms mult man! Acuma merge perfect

[KenT]

tot nu inteleg ce fac ca m-am uitat peste tot si tot nik

[KenT]

imi da eroarea asta knd intru in Colo Groups

Error querying the users table.

DEBUG MODE

SQL Error : 1146 Table 'gamemania_lx_ro.COLOR_GROUPS_TABLE' doesn't exist

SELECT group_id, group_name FROM COLOR_GROUPS_TABLE

Line : 145
File : admin_color_groups.php

[octaviansan]

Ruleaza comenzile mysql in myphpadmin

[KenT]

msn sry sunt cam n00b
dar zimi si mie cum fac asta

[octaviansan]

Hostul tau are myphpadmin , intri in el , apesi pe baza de date pe care o folosesti , dau sql si rulezi comanda SQL din installul modului .

[KenT]

deci am intrt unde ai zis si am dat browse si am bagat install.txt din color_groups si uite ce imi zice

Pare sa fie o eroare in comanda SQL. Eroarea MySQL de mai jos, daca e vreuna, poate sa te ajute la diagnosticarea problemei

ERROR: Insiruire de punctuatie necunoscuta @ 1133
STR: ://
SQL: ################################################################
## COLOR GROUPS ##
## 1.2.1 ##
################################################################
##
## Description: This mod will replace the current
## name colorization with a group
## system. You may define your group
## name, group color, and group members.
##
## Compatibility: phpBB - 2.0.4 - 2.0.6, 2.0.13 - 2.0.17
## (probably works with any version above 2.0.5)
## php - 4.0.1 or above
################################################################
## This hack brought to you by donation support from Kozy. ##
## Visit him at Kozy Net (http://www.kozysplace.net) to ##
## offer your thanks. ##
################################################################
****************************************************************
** Author: Nivisec (support@nivisec.com) **
** http://www.nivisec.com **
** **
** Language **
** Files At: http://www.nivisec.com/phpbb.php?l=la **
****************************************************************
################################################################
## Installation Level: Fairly Easy
## Installation Time: 10-15 minutes
##
## Author Notes:
## Once installed, you will have a new admin panel
## option called "Color Groups" under the "Group Admin"
## area.
##
## Support: http://www.phpbbhacks.com/forums
## Copyright: �2002-2003 Nivisec.com
##
################################################################
## ********* UPDATING *********
## Please see the goodies/updating/ directory
## for information on upgrading from a previous
## version.
################################################################
#
#-----[ UPLOAD ]------------------------------------------
# If you are having trouble understanding this section, read
# the goodies/understanding_upload.txt file.
#
nivisec_install.php to /
nivisec_schema/*.* to nivisec_schema/
admin/admin_color_groups.php to admin/
language/lang_english/lang_color_groups.php to language/lang_english/
includes/functions_color_groups.php to includes/
templates/subSilver/admin/*.* to templates/subSilver/admin/

#
#-----[ RUN ]------------------------------------------
#
nivisec_install.php

#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]------------------------------------------
#
define('CATEGORIES_TABLE', $table_prefix.'categories');

#
#-----[ AFTER, ADD ]------------------------------------------
#
define('COLOR_GROUPS_TABLE', $table_prefix.'color_groups');

#
#-----[ OPEN ]------------------------------------------
#
index.php

#
#-----[ FIND ]------------------------------------------
#
//
// End session management
//

#
#-----[ AFTER, ADD ]------------------------------------------
#
include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx);
color_groups_setup_list();

#
#-----[ FIND ]------------------------------------------
#
$last_post .= ( $forum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != '' ) ? $forum_data[$j]['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a href="' . append_sid(" POST_USERS_URL=' . $forum_data[$j]['>' . $forum_data[$j]['username'] . '</a> ';

#
#-----[REPLACE WITH ]------------------------------------------
#
$last_post .= ( $forum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != '' ) ? $forum_data[$j]['post_username'] . ' ' : $lang['Guest'] . ' ' ) : color_group_colorize_name($forum_data[$j]['user_id']);
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/index_body.tpl

#
#-----[ FIND ]------------------------------------------
#
[ {L_WHOSONLINE_ADMIN} ] &nbsp; [ {L_WHOSONLINE_MOD} ]

#
#-----[ REPLACE WITH ]------------------------------------------
#
{COLOR_GROUPS_LIST}

#
#-----[ OPEN ]------------------------------------------
#
includes/page_header.php

#
#-----[ FIND ]------------------------------------------
#
if (defined('SHOW_ONLINE'))
{


#
#-----[ AFTER, ADD ]------------------------------------------
#
include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx);

#
#-----[ FIND ]------------------------------------------
#
$style_color = '';
if ( $row['user_level'] == ADMIN )
{
$row['username'] = '<b>' . $row['username'] . '</b>';
$style_color = 'style="color:#' . $theme['fontcolor3'] . '"';
}
else if ( $row['user_level'] == MOD )
{
$row['username'] = '<b>' . $row['username'] . '</b>';
$style_color = 'style="color:#' . $theme['fontcolor2'] . '"';
}
if ( $row['user_allow_viewonline'] )
{
$user_online_link = '<a href="' . append_sid(" POST_USERS_URL=" . $row['user_id']) . '">' . $row['username'] . '</a>';
$logged_visible_online++;
}
else
{
$user_online_link = '<a href="' . append_sid(" POST_USERS_URL=" . $row['user_id']) . '"><i>' . $row['username'] . '</i></a>';
$logged_hidden_online++;
}

#
#-----[ REPLACE WITH ]------------------------------------------
#
$user_online_link = color_group_colorize_name($row['user_id']);
if ( $row['user_allow_viewonline'] )
{
$logged_visible_online++;
}
else
{
$logged_hidden_online++;
}

#
#-----[ OPEN ]------------------------------------------
#
viewonline.php

#
#-----[ FIND ]------------------------------------------
#
$username = $row['username'];

$style_color = '';
if ( $row['user_level'] == ADMIN )
{
$username = '<b>' . $username . '</b>';
}
else if ( $row['user_level'] == MOD )
{
$username = '<b>' . $username . '</b>';
}

#
#-----[ REPLACE WITH ]------------------------------------------
#
include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx);
$username = color_group_colorize_name($user_id, true);

#
#-----[ OPEN ]------------------------------------------
#
viewtopic.php

#
#-----[ FIND ]------------------------------------------
#
include($phpbb_root_path . 'includes/bbcode.'.$phpEx);

#
#-----[ AFTER, ADD ]------------------------------------------
#
include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx);

#
#-----[ FIND ]------------------------------------------
#
'POSTER_NAME' => $poster,

#
#-----[ REPLACE WITH ]------------------------------------------
#
'POSTER_NAME' => ($poster_name = color_group_colorize_name($poster_id, true)) ? $poster_name : $poster,

#
#-----[ OPEN ]------------------------------------------
#
memberlist.php

#
#-----[ FIND ]------------------------------------------
#
include($phpbb_root_path . 'common.'.$phpEx);

#
#-----[ AFTER, ADD ]------------------------------------------
#
include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx);

#
#-----[ FIND ]------------------------------------------
#
'USERNAME' => $username,

#
#-----[ REPLACE WITH ]------------------------------------------
#
'USERNAME' => color_group_colorize_name($user_id, true),

#
#-----[ OPEN ]------------------------------------------
#
privmsg.php

#
#-----[ FIND ]------------------------------------------
#
include($phpbb_root_path . 'includes/functions_post.'.$phpEx);

#
#-----[ AFTER, ADD ]------------------------------------------
#
include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx);

#
#-----[ FIND ]------------------------------------------
#
$username_from = $privmsg['username_1'];

#
#-----[ REPLACE WITH ]------------------------------------------
#
$username_from = color_group_colorize_name($privmsg['user_id_1'], true);

#
#-----[ FIND ]------------------------------------------
#
$username_to = $privmsg['username_2'];

#
#-----[ REPLACE WITH ]------------------------------------------
#
$username_to = color_group_colorize_name($privmsg['user_id_2'], true);

#
#-----[ FIND ]------------------------------------------
#
'FROM' => $msg_username,

#
#-----[ REPLACE WITH ]------------------------------------------
#
'FROM' => color_group_colorize_name($msg_userid, true),

#
#-----[ OPEN ]------------------------------------------
#
viewforum.php

#
#-----[ FIND ]------------------------------------------
#
include($phpbb_root_path . 'common.'.$phpEx);

#
#-----[ AFTER, ADD ]------------------------------------------
#
include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx);

#
#-----[ FIND ]------------------------------------------
#
$moderators[] = '<a href="' . append_sid(" POST_USERS_URL=" . $row['user_id']) . '">' . $row['username'] . '</a>';

#
#-----[ REPLACE WITH ]------------------------------------------
#
$moderators[] = color_group_colorize_name($row['user_id']);

#
#-----[ FIND ]------------------------------------------
#
$topic_author = ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? '<a href="' . append_sid(" POST_USERS_URL=' . $topic_rowset[$i]['>' : '';
$topic_author .= ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? $topic_rowset[$i]['username'] : ( ( $topic_rowset[$i]['post_username'] != '' ) ? $topic_rowset[$i]['post_username'] : $lang['Guest'] );

$topic_author .= ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? '</a>' : '';

#
#-----[ REPLACE WITH ]------------------------------------------
#
$topic_author = ($topic_rowset[$i]['user_id'] == ANONYMOUS ) ? (($topic_rowset[$i]['post_username'] != '' ) ? $topic_rowset[$i]['post_username'] : $lang['Guest'] ) : color_group_colorize_name($topic_rowset[$i]['user_id']);

#
#-----[ SAVE & CLOSE ALL FILES ]--------------------------
#
#End

Comanda SQL:

################################################################ ## COLOR GROUPS ## ## 1.2.1 ## ################################################################ ## ## Description: This mod will replace the current ## name colorization with a group ## system. You may define your group ## name, group color, and group members. ## ## Compatibility: phpBB - 2.0.4 - 2.0.6, 2.0.13 - 2.0.17 ## (probably works with any version above 2.0.5) ## php - 4.0.1 or above ################################################################ ## This hack brought to you by donation support from Kozy. ## ## Visit him at Kozy Net (http://www.kozysplace.net) to ## ## offer your thanks. ## ################################################################ **************************************************************** ** Author: Nivisec (support@nivisec.com) ** ** http://www.nivisec.com ** ** ** ** Language ** ** Files At: http://www.nivisec.com/phpbb.php?l=la ** **************************************************************** ################################################################ ## Installation Level: Fairly Easy ## Installation Time: 10-15 minutes ## ## Author Notes: ## Once installed, you will have a new admin panel ## option called "Color Groups" under the "Group Admin" ## area. ## ## Support: http://www.phpbbhacks.com/forums ## Copyright: �2002-2003 Nivisec.com ## ################################################################ ## ********* UPDATING ********* ## Please see the goodies/updating/ directory ## for information on upgrading from a previous ## version. ################################################################ # #-----[ UPLOAD ]------------------------------------------ # If you are having trouble understanding this section, read # the goodies/understanding_upload.txt file. # nivisec_install.php to / nivisec_schema/*.* to nivisec_schema/ admin/admin_color_groups.php to admin/ language/lang_english/lang_color_groups.php to language/lang_english/ includes/functions_color_groups.php to includes/ templates/subSilver/admin/*.* to templates/subSilver/admin/ # #-----[ RUN ]------------------------------------------ # nivisec_install.php # #-----[ OPEN ]------------------------------------------ # includes/constants.php # #-----[ FIND ]------------------------------------------ # define('CATEGORIES_TABLE', $table_prefix.'categories'); # #-----[ AFTER, ADD ]------------------------------------------ # define('COLOR_GROUPS_TABLE', $table_prefix.'color_groups'); # #-----[ OPEN ]------------------------------------------ # index.php # #-----[ FIND ]------------------------------------------ # // // End session management // # #-----[ AFTER, ADD ]------------------------------------------ # include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx); color_groups_setup_list(); # #-----[ FIND ]------------------------------------------ # $last_post .= ( $forum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != '' ) ? $forum_data[$j]['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a href="' . append_sid(" POST_USERS_URL=' . $forum_data[$j]['>' . $forum_data[$j]['username'] . '</a> '; # #-----[REPLACE WITH ]------------------------------------------ # $last_post .= ( $forum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != '' ) ? $forum_data[$j]['post_username'] . ' ' : $lang['Guest'] . ' ' ) : color_group_colorize_name($forum_data[$j]['user_id']); # #-----[ OPEN ]------------------------------------------ # templates/subSilver/index_body.tpl # #-----[ FIND ]------------------------------------------ # [ {L_WHOSONLINE_ADMIN} ] &nbsp; [ {L_WHOSONLINE_MOD} ] # #-----[ REPLACE WITH ]------------------------------------------ # {COLOR_GROUPS_LIST} # #-----[ OPEN ]------------------------------------------ # includes/page_header.php # #-----[ FIND ]------------------------------------------ # if (defined('SHOW_ONLINE')) { # #-----[ AFTER, ADD ]------------------------------------------ # include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx); # #-----[ FIND ]------------------------------------------ # $style_color = ''; if ( $row['user_level'] == ADMIN ) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'style="color:#' . $theme['fontcolor3'] . '"'; } else if ( $row['user_level'] == MOD ) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'style="color:#' . $theme['fontcolor2'] . '"'; } if ( $row['user_allow_viewonline'] ) { $user_online_link = '<a href="' . append_sid(" POST_USERS_URL=" . $row['user_id']) . '">' . $row['username'] . '</a>'; $logged_visible_online++; } else { $user_online_link = '<a href="' . append_sid(" POST_USERS_URL=" . $row['user_id']) . '"><i>' . $row['username'] . '</i></a>'; $logged_hidden_online++; } # #-----[ REPLACE WITH ]------------------------------------------ # $user_online_link = color_group_colorize_name($row['user_id']); if ( $row['user_allow_viewonline'] ) { $logged_visible_online++; } else { $logged_hidden_online++; } # #-----[ OPEN ]------------------------------------------ # viewonline.php # #-----[ FIND ]------------------------------------------ # $username = $row['username']; $style_color = ''; if ( $row['user_level'] == ADMIN ) { $username = '<b>' . $username . '</b>'; } else if ( $row['user_level'] == MOD ) { $username = '<b>' . $username . '</b>'; } # #-----[ REPLACE WITH ]------------------------------------------ # include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx); $username = color_group_colorize_name($user_id, true); # #-----[ OPEN ]------------------------------------------ # viewtopic.php # #-----[ FIND ]------------------------------------------ # include($phpbb_root_path . 'includes/bbcode.'.$phpEx); # #-----[ AFTER, ADD ]------------------------------------------ # include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx); # #-----[ FIND ]------------------------------------------ # 'POSTER_NAME' => $poster, # #-----[ REPLACE WITH ]------------------------------------------ # 'POSTER_NAME' => ($poster_name = color_group_colorize_name($poster_id, true)) ? $poster_name : $poster, # #-----[ OPEN ]------------------------------------------ # memberlist.php # #-----[ FIND ]------------------------------------------ # include($phpbb_root_path . 'common.'.$phpEx); # #-----[ AFTER, ADD ]------------------------------------------ # include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx); # #-----[ FIND ]------------------------------------------ # 'USERNAME' => $username, # #-----[ REPLACE WITH ]------------------------------------------ # 'USERNAME' => color_group_colorize_name($user_id, true), # #-----[ OPEN ]------------------------------------------ # privmsg.php # #-----[ FIND ]------------------------------------------ # include($phpbb_root_path . 'includes/functions_post.'.$phpEx); # #-----[ AFTER, ADD ]------------------------------------------ # include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx); # #-----[ FIND ]------------------------------------------ # $username_from = $privmsg['username_1']; # #-----[ REPLACE WITH ]------------------------------------------ # $username_from = color_group_colorize_name($privmsg['user_id_1'], true); # #-----[ FIND ]------------------------------------------ # $username_to = $privmsg['username_2']; # #-----[ REPLACE WITH ]------------------------------------------ # $username_to = color_group_colorize_name($privmsg['user_id_2'], true); # #-----[ FIND ]------------------------------------------ # 'FROM' => $msg_username, # #-----[ REPLACE WITH ]------------------------------------------ # 'FROM' => color_group_colorize_name($msg_userid, true), # #-----[ OPEN ]------------------------------------------ # viewforum.php # #-----[ FIND ]------------------------------------------ # include($phpbb_root_path . 'common.'.$phpEx); # #-----[ AFTER, ADD ]------------------------------------------ # include_once($phpbb_root_path.'includes/functions_color_groups.'.$phpEx); # #-----[ FIND ]------------------------------------------ # $moderators[] = '<a href="' . append_sid(" POST_USERS_URL=" . $row['user_id']) . '">' . $row['username'] . '</a>'; # #-----[ REPLACE WITH ]------------------------------------------ # $moderators[] = color_group_colorize_name($row['user_id']); # #-----[ FIND ]------------------------------------------ # $topic_author = ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? '<a href="' . append_sid(" POST_USERS_URL=' . $topic_rowset[$i]['>' : ''; $topic_author .= ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? $topic_rowset[$i]['username'] : ( ( $topic_rowset[$i]['post_username'] != '' ) ? $topic_rowset[$i]['post_username'] : $lang['Guest'] ); $topic_author .= ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? '</a>' : ''; # #-----[ REPLACE WITH ]------------------------------------------ # $topic_author = ($topic_rowset[$i]['user_id'] == ANONYMOUS ) ? (($topic_rowset[$i]['post_username'] != '' ) ? $topic_rowset[$i]['post_username'] : $lang['Guest'] ) : color_group_colorize_name($topic_rowset[$i]['user_id']); # #-----[ SAVE & CLOSE ALL FILES ]-------------------------- # #End


Iar dupaia

MySQL zice: Documentatie
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '****************************************************************
** Author: ' at line 19

[octaviansan]

Nu, deci uita cu myphpadmin . Uplodeaza nivisec_install.php in root si ruleaza http://foumultau/nivisec_install.php