phpBB.nl

## MOD Title:          Country
## MOD Author:         Hartois < hartois@pisem.net > 
## MOD Description:    This mod will add a Country field into
##                     users' profile. It display "Country: |flag_image|"
##                     in posts.

Ik heb ergens een foutje gemaakt maar ik niet vinden waar. Iemand anders wel?

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '0, user_setbm = 0, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1' at line 2

UPDATE phpbb_users SET user_email = 'm.ruiter4@chello.nl', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 0, 0, user_setbm = 0, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 0, user_dateformat = 'd M Y h:i a', user_lang = 'dutch', user_style = 1, user_active = 1, user_actkey = '', user_country = 'belgium' WHERE user_id = 2

Line : 548
File : usercp_register.php

Regel 543-549

Code: Selecteer alles

$sql = "UPDATE " . USERS_TABLE . "
				SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, $setbm, user_setbm = $setbm, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . ", user_country = '" . str_replace("\'", "''", $user_country) . "'
				WHERE user_id = $user_id";
			if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
			}

Haal , $setbm eens weg uit die querrie.

Luuk schreef:Haal , $setbm eens weg uit die querrie.

Dat werkt, vreemd is wel dat dat niet gewijzigd is voor de mod

Je moest het origineel uitvoeren c.q plakken in phpMyAdmin, niet ertussendoor invullen. Zoals je mail en zo.

Hoe zorg ik dat in viewtopic de naam van het land verdwijnt en alleen de vlag blijft staan?

Code: Selecteer alles

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

#
#-----[ FIND ]---------------------------------------------
#
$sql = "SELECT u.username, u.user_id,

#
#-----[ IN-LINE FIND ]-------------------------------------
#
, p.*

#
#-----[ IN-LINE BEFORE, ADD ]-------------------------------
#
, u.user_country

#
#-----[ FIND ]---------------------------------------------
#
$poster_from = ( $postrow[$i]['user_from'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Location'] . ': ' . $postrow[$i]['user_from'] : '';

#
#-----[ AFTER, ADD ]---------------------------------------
#
$poster_country = ( $postrow[$i]['user_country'] && $postrow[$i]['user_id'] != ANONYMOUS ) ?   $postrow[$i]['user_country'] . "<br />&nbsp;&nbsp;&nbsp;<img SRC=" . $phpbb_root_path . "images/flags/" . $postrow[$i]['user_country'] . ".gif align=ABSMIDDLE> " : "Íå âûáðàíà";

#
#-----[ FIND ]---------------------------------------------
#
'POSTER_FROM' => $poster_from,

#
#-----[ AFTER, ADD ]---------------------------------------
#
'POSTER_COUNTRY' => $poster_country,

Haal bij $poster_country

Code: Selecteer alles

$postrow[$i]['user_country'] . "<br />&nbsp;&nbsp;&nbsp;

eens weg en zet er een " voor in de plaats.

Luuk schreef:Haal bij $poster_country
Code: Selecteer alles
$postrow[$i]['user_country'] . "<br />&nbsp;&nbsp;&nbsp;
eens weg en zet er een " voor in de plaats.

Werkt helaas niet.

phpBB.nl

Vlaggen foutje

Vlaggen foutje