hi leute ich glaub ich habs ich hab jetzt nur das problem das er die installation nicht mehr abschliest
das ist jetzt das was er macht
Nicht-verarbeitete Befehle
SAVE AND CLOSE ALL FILES line #454
ADD FILE line #460
charmod_functions.php --> phpbb-root/charmod_functions.php
SQL EXECUTE line #469
EasyMOD hat folgende Befehle erfolgreich verarbeitet:
Befehle verarbeitet
OPEN line #59
includes/usercp_viewprofile.php
FIND line #64
//
// Generate page
//
BEFOREADD line #72
//
// CHARMOD BY MONTE
//
//
if($charmod_sort_item=="")$charmod_sort_item="my_charname";
if($dir=="")$dir="ASC";
$sql = "SELECT *, charmod_chars.charname AS my_charname, charmod_servers.name AS charmod_servername FROM charmod_guilds, charmod_chars, charmod_servers, charmod_characters WHERE charmod_guilds.guildnr=charmod_chars.guildnr AND charmod_guilds.server_id=charmod_chars.server AND charmod_characters.name=charmod_chars.charname AND charmod_servers.id=charmod_characters.server AND charmod_chars.guildnr=charmod_characters.guildnr AND charmod_servers.id=charmod_chars.server AND user_id = ".$profiledata['user_id']." ORDER BY ".$charmod_sort_item." ".$dir;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain character information', '', __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
$topic_rowset[] = $row;
}
$db->sql_freeresult($result);
for($index_counter = 0; $index_counter < count($topic_rowset); $index_counter++)
{
$charmod_charname = $topic_rowset[$index_counter]['my_charname'];
if(strpos (trim($charmod_charname)," "))
{
$char_first_name=substr($charmod_charname, 0, strpos ($charmod_charname," "));
}
else
{
$char_first_name=$charmod_charname;
}
$sql2 = "SELECT *, charmod_characters.lastname AS charlastname, charmod_servers.name AS charmod_servername, charmod_guilds.name AS charmod_guildname FROM charmod_characters, charmod_servers, charmod_chars, charmod_guilds WHERE charmod_guilds.guildnr=charmod_characters.guildnr AND charmod_characters.guildnr=charmod_chars.guildnr AND charmod_characters.server = charmod_servers.id AND charmod_guilds.server_id = charmod_servers.id AND charmod_servers.id=charmod_chars.server AND charmod_servers.id = ".$topic_rowset[$index_counter]['server']." AND charmod_guilds.guildnr = ".$topic_rowset[$index_counter]['guildnr']." AND charmod_characters.name = charmod_chars.charname AND charmod_characters.name = \"".$char_first_name."\"";
if ( !($result2 = $db->sql_query($sql2)) )
{
message_die(GENERAL_ERROR, 'Could not obtain character information', '', __LINE__, __FILE__, $sql2);
}
while( $row2 = $db->sql_fetchrow($result2) )
{
$charname=$row2['charname']." ".$row2['charlastname'];
$charmod_charlevel=$row2['level'];
$charmod_charclass=$row2['class'];
$charmod_charrace=$row2['race'];
$charmod_charrp=$row2['rp'];
$charmod_charrr=$row2['rr'];
$charmod_chargrank="<a href=\"http://".$row2['url']."\" target=\"_blank\">".utf8_decode($row2['charmod_guildname'])."</a>";
$charmod_charloc1=$row2['charmod_servername'];
$charmod_charloc2=$row2['realm'];
}
if($charname=="")$charname=$charmod_charname;
$template->assign_block_vars('charmod_show_chars', array(
'CHARMOD_CHARNAME' => $charname,
'CHARMOD_CHARLEVEL' => $charmod_charlevel,
'CHARMOD_CHARCLASS' => $charmod_charclass,
'CHARMOD_CHARRACE' => $charmod_charrace,
'CHARMOD_CHARRP' => $charmod_charrp,
'CHARMOD_CHARLOC1' => $charmod_charloc1,
'CHARMOD_CHARLOC2' => $charmod_charloc2,
'CHARMOD_CHARRR' => $charmod_charrr,
'CHARMOD_CHARGRANK' => $charmod_chargrank,
'U_VIEW_TOPIC' => $view_topic_url)
);
$charname="";
$charmod_charlevel="";
$charmod_charclass="";
$charmod_charrace="";
$charmod_charrp="";
$charmod_charrank="";
$charmod_charrr="";
$charmod_chargrank="";
$charmod_charloc="";
}
function charsort_link($sortby)
{
global $u, $dir;
//echo $sortby." lala <br>";
if($dir=="DESC")$direction="ASC";
if($dir=="ASC")$direction="DESC";
if($dir=="")$direction="ASC";
return "<a href=\"profile.php?mode=viewprofile&u=".$u."&charmod_sort_item=".$sortby."&dir=".$direction."#chars\">";
}
function charsort_link_e($sortby)
{
global $charmod_sort_item, $dir;
if($sortby==$charmod_sort_item)
{
if($dir=="DESC")return "</a> <img src=\"images/dirdown.gif\" border=\"0\" />";
else return "</a> <img src=\"images/dirup.gif\" border=\"0\" />";
}
else
{
return "</a>";
}
}
FIND line #193
'U_SEARCH_USER' => append_sid("search.$phpEx?search_author=" . urlencode($profiledata['username'])),
AFTERADD line #199
//
// CHARMOD BY MONTE
//
'L_CHARMOD_USER_CHARS_TITLE' => sprintf($lang['Charmod_View_Title'], $profiledata['username']),
'L_CHARMOD_CHARNAME' => charsort_link("my_charname").$lang['Charmod_Charname'].charsort_link_e("my_charname"),
'L_CHARMOD_CHARLEVEL' => charsort_link("charmod_characters.level").$lang['Charmod_Charlevel'].charsort_link_e("charmod_characters.level"),
'L_CHARMOD_CHARCLASS' => charsort_link("class").$lang['Charmod_Charclass'].charsort_link_e("class"),
'L_CHARMOD_CHARRACE' => charsort_link("race").$lang['Charmod_Charrace'].charsort_link_e("race"),
'L_CHARMOD_CHARLOC1' => charsort_link("charmod_servers.name").$lang['Charmod_Charloc1'].charsort_link_e("charmod_servers.name"),
'L_CHARMOD_CHARLOC2' => charsort_link("realm").$lang['Charmod_Charloc2'].charsort_link_e("realm"),
'L_CHARMOD_CHARRR' => charsort_link("rr").$lang['Charmod_Charrr'].charsort_link_e("rr"),
'L_CHARMOD_CHARGUILD' => charsort_link("charmod_guilds.name").$lang['Charmod_Charguild'].charsort_link_e("charmod_guilds.name"),
'L_CHARMOD_CHARRP' => charsort_link("rp").$lang['Charmod_Charrp'].charsort_link_e("rp"),
OPEN line #217
includes/usercp_register.php
FIND line #222
$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, 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 . "
WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
}
AFTERADD line #234
//
//CHARMOD INSERT BY MONTE
//
if($charmod_charname!="" && $charmod_guildnr!="")
{
if(strpos (trim($charmod_charname)," "))
{
$v_name=utf8_decode(substr($charmod_charname, 0, strpos ($charmod_charname," ")));
$n_name=utf8_decode(trim(substr($charmod_charname, strpos ($charmod_charname," "), 100)));
}
else
{
$v_name=utf8_decode($charmod_charname);
$n_name="";
}
$sql = "INSERT INTO charmod_chars (user_id, charname, lastname, server, guildnr) VALUES (".$user_id.", '".ucfirst($v_name)."', '".$n_name."', ".$server.", ".$charmod_guildnr." )";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not update character table', '', __LINE__, __FILE__, $sql);
}
}
//
//CHARMOD DELETE BY MONTE
//
//echo count($user_char);
if(count($user_char)>0)
{
foreach($user_char AS $key => $value)
{
$sql = "SELECT * FROM charmod_chars WHERE id = $value AND user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not find characterdata', '', __LINE__, __FILE__, $sql);
}
else
{
if(count($result)>0)
{
$sql = "DELETE FROM charmod_chars WHERE id = $value";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not delete character', '', __LINE__, __FILE__, $sql);
}
}
}
}
}
FIND line #293
'L_EMAIL_ADDRESS' => $lang['Email_address'],
AFTERADD line #299
'L_CHARMOD_ENTER_CHAR' => $lang['charmod_enter_char'],
'L_CHARMOD_EXPLAIN' => sprintf($lang['charmod_explain'],""),
'L_CHARMOD_SERVER' => $lang['charmod_server'],
'L_CHARMOD_REALM' => $lang['charmod_realm'],
'L_CHARMOD_GUILDNR' => $lang['charmod_guildnr'],
'L_CHARMOD_CHAR_NAME' => $lang['charmod_char_name'],
'L_CHARMOD_USER_CHARS_TITLE' => sprintf($lang['Charmod_View_Title'], $profiledata['username']),
'L_CHARMOD_CHARNAME' => $lang['Charmod_Charname'],
'L_CHARMOD_CHARLEVEL' => $lang['Charmod_Charlevel'],
'L_CHARMOD_CHARCLASS' => $lang['Charmod_Charclass'],
'L_CHARMOD_CHARRACE' => $lang['Charmod_Charrace'],
'L_CHARMOD_CHARLOC' => $lang['Charmod_Charloc'],
'L_CHARMOD_CHARRR' => $lang['Charmod_Charrr'],
'L_CHARMOD_CHARGUILD' => $lang['Charmod_Charguild'],
'L_CHARMOD_CHARRP' => $lang['Charmod_Charrp'],
'L_CHARMOD_DELETE' => $lang['Charmod_Delete'],
FIND line #320
'S_PROFILE_ACTION' => append_sid("profile.$phpEx"))
);
AFTERADD line #328
//
// CHARMOD BY MONTE
//
//
if ( $mode != 'register' )
{
$sql = "SELECT *, charmod_chars.id AS charid FROM charmod_chars, charmod_servers WHERE charmod_servers.id=charmod_chars.server AND user_id = ".$user_id;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain character information', '', __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
$topic_rowset[] = $row;
}
$db->sql_freeresult($result);
for($i = 0; $i < count($topic_rowset); $i++)
{
$charmod_charname = $topic_rowset[$i]['charname'];
if($topic_rowset[$i]['lastname']!="")
{
$charmod_charname = $charmod_charname." ".$topic_rowset[$i]['lastname'];
}
$charmod_server = $topic_rowset[$i]['name'];
$charmod_id = $topic_rowset[$i]['charid'];
$charmod_chardelete = "<input type=\"checkbox\" name=\"user_char[$i]\" value=\"$charmod_id\">";
$template->assign_block_vars('charmod_show_chars', array(
'CHARMOD_CHARNAME' => $charmod_charname,
'CHARMOD_CHARSERVER' => $charmod_server,
'CHARMOD_CHARDELETE' => $charmod_chardelete)
);
}
}
OPEN line #378
language/lang_german/lang_main.php
FIND line #383
$lang['datetime']['Dec'] = 'Dez';
AFTERADD line #389
//
// CHARMOD BY MONTE
//
$lang['Charmod_View_Title'] = 'Chars of %s';
$lang['Charmod_Charname'] = 'Name';
$lang['Charmod_Charlevel'] = 'Level';
$lang['Charmod_Charclass'] = 'Class';
$lang['Charmod_Charrace'] = 'Race';
$lang['Charmod_Charloc1'] = 'Server';
$lang['Charmod_Charloc2'] = 'Realm';
$lang['Charmod_Charrr'] = 'RR';
$lang['Charmod_Charguild'] = 'Guild';
$lang['Charmod_Charrp'] = 'RP';
$lang['Charmod_Charcraft'] = 'Crafter';
$lang['charmod_enter_char'] = 'Insert Character';
$lang['charmod_explain'] = 'Insert the name of your character, an the corresponding server/guild combination<br><b>The guildnumber is important to access the right guild-xml file.<br>If you don't know your number, ask your guildleader</b><br><br>';
$lang['charmod_server'] = 'Server';
$lang['charmod_realm'] = 'Realm';
$lang['charmod_guildnr'] = 'Guildnumber';
$lang['charmod_char_name'] = 'Charactername';
$lang['Charmod_Delete'] = 'Delete';
OPEN line #415
includes/functions_selects.php
FIND line #420
?>
BEFOREADD line #426
//
// Pick a Server
//
function charmod_select_server($user_id_char, $select_name = "charmod_server")
{
global $db;
$sql = "SELECT * FROM charmod_servers ORDER BY name";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Couldn't query charmod table", "", __LINE__, __FILE__, $sql);
}
$server_select = '<select name="' . $select_name . '">';
while ( $row = $db->sql_fetchrow($result) )
{
$server_select .= '<option value="' . $row['id'] . '">' . $row['name'] . '</option>';
}
$server_select .= "</select>";
return $server_select;
}
hoffe ihr könnt mir helfen wer super
