ich bin dabei verschiedene MODS von dir in mein RPG Forum einzubauen.
Hier der Link, am besten registrierst du dich um alle Probleme selber zu sehen:
http://www.naduma.de
Frage 1
In der char_settings.php soll ich folgendes finden:
Code: Alles auswählen
$preset_id = (isset($HTTP_POST_VARS['preset'])) ? intval($HTTP_POST_VARS['preset']) : intval($HTTP_GET_VARS['preset']);Code: Alles auswählen
$confirm = (isset($HTTP_POST_VARS['confirm'])) ? $HTTP_POST_VARS['confirm'] : '';
$cancel = (isset($HTTP_POST_VARS['cancel'])) ? $HTTP_POST_VARS['cancel'] : '';
$inv_id = (isset($HTTP_POST_VARS['inv_id'])) ? intval($HTTP_POST_VARS['inv_id']) : intval($HTTP_GET_VARS['inv_id']);
if ($cancel)
{
$confirm = 0;
$mode = '';
}
if ($inv_id)
{
$sql = "SELECT user_id FROM " . RPG_INVENTORY_TABLE . "
WHERE user_id = " . $userdata['user_id'] . "
AND inv_id = $inv_id";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not fetch item information', '', __LINE__, __FILE__, $sql);
}
$nums_items = $db->sql_numrows($result);
$row = $db->sql_fetchrow($result);
$item_user = $row['user_id'];
$db->sql_freeresult($result);
}
if ($mode == 'use_item' && $inv_id != 0 && $nums_items == 1 && $userdata['user_id'] == $item_user)
{
$sql = "SELECT a.usings, i.race_use_id, u.race_id,
i.power, i.defence, i.intelligence, i.vitality, i.increase_max,
u.power_max, u.defence_max, u.intelligence_max, u.vitality_max,
u.power_cur, u.defence_cur, u.intelligence_cur, u.vitality_cur
FROM " . RPG_INVENTORY_TABLE . " a,
" . RPG_ITEMS_TABLE . " i,
" . RPG_ITEMS_CAT_TABLE . " c,
" . RPG_USER_CHARS_TABLE . " u
WHERE u.user_id = " . $userdata['user_id'] . "
AND u.death_time = 0
AND u.user_id = a.user_id
AND c.cat_id = i.cat_id
AND c.placement = 0
AND i.item_id = a.item_id
AND a.inv_id = $inv_id";
if (!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not fetch item informations', '', __LINE__, __FILE__, $sql);
}
$nums_item = $db->sql_numrows($result);
if ($nums_item == 1)
{
$row = $db->sql_fetchrow($result);
$usings = $row['usings'];
$power = $row['power'];
$defence = $row['defence'];
$intelligence = $row['intelligence'];
$vitality = $row['vitality'];
$increase_max = $row['increase_max'];
$power_max = $row['power_max'];
$defence_max = $row['defence_max'];
$intelligence_max = $row['intelligence_max'];
$vitality_max = $row['vitality_max'];
$power_cur = $row['power_cur'];
$defence_cur = $row['defence_cur'];
$intelligence_cur = $row['intelligence_cur'];
$vitality_cur = $row['vitality_cur'];
$race_use_id = $row['race_use_id'];
$race_id = $row['race_id'];
if ($race_id == $race_use_id || $race_use_id == 0)
{
$power_cur += $power;
$defence_cur += $defence;
$intelligence_cur += $intelligence;
$vitality_cur += $vitality;
$usings--;
if ($increase_max == 1)
{
$power_max = ($power_cur > $power_max) ? $power_cur : $power_max;
$defence_max = ($defence_cur > $defence_max) ? $defence_cur : $defence_max;
$intelligence_max = ($intelligence_cur > $intelligence_max) ? $intelligence_cur : $intelligence_max;
$vitality_max = ($vitality_cur > $vitality_max) ? $vitality_cur : $vitality_max;
}
else
{
$power_cur = ($power_cur > $power_max) ? $power_max : $power_cur;
$defence_cur = ($defence_cur > $defence_max) ? $defence_max : $defence_cur;
$intelligence_cur = ($intelligence_cur > $intelligence_max) ? $intelligence_max : $intelligence_cur;
$vitality_cur = ($vitality_cur > $vitality_max) ? $vitality_max : $vitality_cur;
}
$sql = "UPDATE " . RPG_USER_CHARS_TABLE . " SET
power_max = $power_max,
defence_max = $defence_max,
intelligence_max = $intelligence_max,
vitality_max = $vitality_max,
power_cur = $power_cur,
defence_cur = $defence_cur,
intelligence_cur = $intelligence_cur,
vitality_cur = $vitality_cur,
last_reg_time = " . time() . "
WHERE user_id = " . $userdata['user_id'] . "
AND death_time = 0";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not update character values', '', __LINE__, __FILE__, $sql);
}
if ($usings == 0)
{
$sql = "DELETE FROM " . RPG_INVENTORY_TABLE . "
WHERE inv_id = $inv_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not drop character values', '', __LINE__, __FILE__, $sql);
}
}
else if ($usings > 0)
{
$sql = "UPDATE " . RPG_INVENTORY_TABLE . "
SET usings = $usings
WHERE inv_id = $inv_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not update character values', '', __LINE__, __FILE__, $sql);
}
}
}
}
$db->sql_freeresult($result);
$mode = '';
}
if ($mode == 'drop_item' && $inv_id != 0 && $nums_items == 1 && $userdata['user_id'] == $item_user)
{
if (!$confirm)
{
$s_hidden_fields = '<input type="hidden" name="mode" value="drop_item" />';
$s_hidden_fields .= '<input type="hidden" name="inv_id" value="'.$inv_id.'" />';
// Output confirmation page
$template->set_filenames(array(
'confirm_body' => 'confirm_body.tpl')
);
$template->assign_vars(array(
'MESSAGE_TITLE' => $lang['Information'],
'MESSAGE_TEXT' => $lang['rpg_confirm_drop_item'],
'L_YES' => $lang['Yes'],
'L_NO' => $lang['No'],
'S_CONFIRM_ACTION' => append_sid("char_settings.$phpEx"),
'S_HIDDEN_FIELDS' => $s_hidden_fields)
);
$template->pparse('confirm_body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
}
$sql = "DELETE FROM " . RPG_INVENTORY_TABLE . "
WHERE inv_id = $inv_id";
if (!$db->sql_query($sql))
{
mesasge_die(GENERAL_ERROR, 'Could not drop item from inventory', '', __LINE__, __FILE__, $sql);
}
}Code: Alles auswählen
if ($preset_id == 0)
{
$char_race_id = (isset($HTTP_POST_VARS['race'])) ? intval($HTTP_POST_VARS['race']) : 0;
$char_occupation_id = (isset($HTTP_POST_VARS['occupation'])) ? intval($HTTP_POST_VARS['occupation']) : 0;
$char_weapon_id = (isset($HTTP_POST_VARS['weapon'])) ? intval($HTTP_POST_VARS['weapon']) : 0;
$char_power = 0;
$char_defence = 0;
$char_intelligence = 0;
$char_vitality = 0;Im ACP bekomme ich folgende Fehker meldungen nach dem Einbau vom "Add-On Items and Events MOD"
Unter "Ereignisse" erscheint:
Unter Gegenstände erscheint:Could not fetch events
DEBUG MODE
SQL Error : 1146 Table 'usr_web45_1.RPG_EVENTS_TABLE' doesn't exist
SELECT * FROM RPG_EVENTS_TABLE WHERE type_id = 0 ORDER BY subject
Line : 227
File : admin_rpg_events.php
Frage 3Could not fetch items
DEBUG MODE
SQL Error : 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 'ORDER BY i.description LIMIT 0, 50' at line 6
SELECT i.*, rt.description as race_take, ru.description as race_use FROM ((rpg_rpg_items i LEFT JOIN rpg_rpg_race rt ON rt.race_id = i.race_take_id) LEFT JOIN rpg_rpg_race ru ON ru.race_id = i.race_use_id) WHERE i.cat_id = ORDER BY i.description LIMIT 0, 50
Line : 330
File : admin_rpg_items.php
Was mus ich einbauen um die Charaktere manuell zu löschen?
Am besten via ACP oder jeder User selber in seinem Charakter Profil, es steht ja auch da:
Aber bearbeiten ist ja nicht möglich...Hier kannst Du bestimmte Informationen für Deinen RPG Charakter einstellen und bearbeiten.
Frage 4
Wenn man sich einen "vorgefertigten" Charakter aus einer Vorlage auswählt und Speichern möchte erscheint:
gibt man seinem Charakter nun einen Namen so hat man den Charkter der als erstes in der Maske erschien...Beschreibung fehlt!
