I've read here somewhere about running the install file first then uploading the edits? I'm not sure what that means.
That was easier than I would have imagined. This just made this mod one of the best. Thank you!oddfish wrote:nice. you can adjust it yourself with accesss to your database and one edit.azzurri wrote:I find the code thing a bit annoying. I remove flags to put in team logos instead and I have a couple of hundred logos. Since the "code" is only 2 characters I can go up to 99 and then I have to use various combinations like a1, a2, a3 and so on. Hard to keep track because if you add two of the same codes it will mess up your logos. It would be much, much better if the codes where 3 or 4 characters so I could go up to at least 999.
mysql:Open adm/style/acp_flags.htmlCode: Select all
ALTER TABLE `phpbb_flags` CHANGE `flag_code` `flag_code` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; ALTER TABLE `phpbb_users` CHANGE `user_flag` `user_flag` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
FINDchange maxlength="2" to maxlength="32" and refresh.Code: Select all
<dd><input name="flag_code" type="text" id="flag_code" value="{FLAG_CODE}" maxlength="2" /></dd>
But an already registered user can choose this flag without problems.The value you entered is too long
Code: Select all
'flag' => array('string', !$config['require_flag'], 2, 2),// ISO 3166-1 alpha-2 (2 letters format)
Code: Select all
'flag' => array('string', !$config['require_flag'], 2, 32),// ISO 3166-1 alpha-2 (2 letters format)
Did you run the cf_install.php file?nicolass wrote:Hi
Very keen on using the "Country Flag User Edition" , I installed it using Automod, all seem ed to be fine until I tried to select a user. The message below popped up on the screen:
SQL ERROR [ mysql4 ]
Table 'web101-a-foru-66.phpbb_flags' doesn't exist [1146]
SQL
SELECT * FROM phpbb_flags ORDER BY flag_country
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/cache.php
LINE: 151
CALL: dbal_mysql->sql_query()
FILE: memberlist.php
LINE: 68
CALL: cache->obtain_flags()
Tried other operations with the same result with the same issue and so I uninstalled the MOD using Automod, this was eventually achieved but there were errors:
Find
'SELECT' => 'u.user_id, u.group_id as default_group, u.username, u.username_clean, u.user_colour, u.user_flag, u.user_rank, u.user_posts, u.user_allow_pm, g.group_id, g.group_name, g.group_colour, g.group_type, ug.user_id as ug_user_id',
In-Line Find
in-line-replace
The In-Line Find specified by the MOD could not be found.The Find specified by the MOD could not be found
Find
$user_row['flag_country'] = $user_row['flag_code'] = $user_row['flag_img'] = $user_row['flag_img_src'] = $user_row['rank_title'] = $user_row['rank_image'] = $user_row['rank_image_src'] = $user_row['email'] = '';
In-Line Find
in-line-replace
The In-Line Find specified by the MOD could not be found.The Find specified by the MOD could not be found
Find
<th class="info"><a href="{U_SORT_WEBSITE}#memberlist">{L_WEBSITE}</a>{L_COMMA_SEPARATOR}<a href="{U_SORT_LOCATION}">{L_LOCATION}</a>{L_COMMA_SEPARATOR}<a href="{U_SORT_FLAG}">{L_COUNTRY}</a></th>
In-Line Find
in-line-replace
The In-Line Find specified by the MOD could not be found.The Find specified by the MOD could not be found
It may be a problem with the database, please let me know if you require anymore information.
Thanks