• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Myacc tfs 1.5 problem

J

jareczekjsp

Member
Joined
Jan 30, 2023
Messages
188
Reaction score
9
GitHub
Jarek123
Hello Guys I have problem ,when I click on Character in on my website Because I wouldlike see What have eq skills etc I have error like that

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'field list'
Click to expand...

How I can Fix It ?
Post automatically merged:

I use this sql

Lua: 
CREATE TABLE IF NOT EXISTS `player_deaths` (
  `player_id` int NOT NULL,
  `time` bigint unsigned NOT NULL DEFAULT '0',
  `date` bigint unsigned NOT NULL DEFAULT '0',
  `level` int NOT NULL DEFAULT '1',
  `killed_by` varchar(255) NOT NULL,
  `is_player` tinyint NOT NULL DEFAULT '1',
  `mostdamage_by` varchar(100) NOT NULL,
  `mostdamage_is_player` tinyint NOT NULL DEFAULT '0',
  `unjustified` tinyint NOT NULL DEFAULT '0',
  `mostdamage_unjustified` tinyint NOT NULL DEFAULT '0',
  FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
  KEY `killed_by` (`killed_by`),
  KEY `mostdamage_by` (`mostdamage_by`)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;

and in characters.php is

SELECT player_deaths.*, players.name, killers.unjustified FROM player_deaths LEFT JOIN killers ON killers.death_id = player_deaths.id LEFT JOIN player_killers ON player_killers.kill_id = killers.id LEFT JOIN players ON players.id = player_deaths.player_id WHERE player_killers.player_id
Click to expand...
How I can change in characters.php?
Post automatically merged:

I try change from sql but no working I do something wrong
 
Last edited:
Sort by date Sort by votes
tobi132 said:
Post your characters.php

I cannot seem to find that query.
Click to expand...
Lua: 
<?php
/**
 * Characters
 *
 * @package   MyAAC
 * @author    Gesior <[email protected]>
 * @author    Slawkens <[email protected]>
 * @copyright 2019 MyAAC
 * @link      https://my-aac.org
 */
defined('MYAAC') or die('Direct access not allowed!');
$title = 'Characters';

require_once SYSTEM . 'item.php';

$groups = new OTS_Groups_List();
function generate_search_form($autofocus = false)
{
    global $config, $twig;
    return $twig->render('characters.form.html.twig', array(
        'link' => getLink('characters'),
        'autofocus' => $autofocus
    ));
}

function retrieve_former_name($name)
{
    global $oldName, $db;

    if($db->hasTable('player_namelocks') && $db->hasColumn('player_namelocks', 'name')) {
        $newNameSql = $db->query('SELECT `name`, `new_name` FROM `player_namelocks` WHERE `name` = ' . $db->quote($name));
        if($newNameSql->rowCount() > 0) // namelocked
        {
            $newNameSql = $newNameSql->fetch();
            $oldName = ' (<small><b>Former name:</b> ' . $newNameSql['name'] . '</small>)';
            return $newNameSql['new_name'];
        }
    }

    return '';
}

$name = '';
if(isset($_REQUEST['name']))
    $name = urldecode(stripslashes(ucwords(strtolower($_REQUEST['name']))));

if(empty($name))
{
    $tmp_link = getPlayerLink($name);
    echo 'Here you can get detailed information about a certain player on ' . $config['lua']['serverName'] . '.<BR>';
    echo generate_search_form(true);
    return;
}

$name = str_replace('/', '', $name);

$oldName = '';

$player = new OTS_Player();
$player->find($name);
if(!$player->isLoaded())
{
    $tmp_zmienna = "";
    $tmp_name = retrieve_former_name($name);
    while(!empty($tmp_name))
    {
        $tmp_zmienna = $tmp_name;
        $tmp_name = retrieve_former_name($tmp_zmienna);
    }

    if(!empty($tmp_zmienna))
        $player->find($tmp_zmienna);
}

if($player->isLoaded() && !$player->isDeleted())
{
    $title = $player->getName() . ' - ' . $title;
    $account = $player->getAccount();
    $rows = 0;

    if($config['characters']['outfit'])
        $outfit = $config['outfit_images_url'] . '?id=' . $player->getLookType() . ($db->hasColumn('players', 'lookaddons') ? '&addons=' . $player->getLookAddons() : '') . '&head=' . $player->getLookHead() . '&body=' . $player->getLookBody() . '&legs=' . $player->getLookLegs() . '&feet=' . $player->getLookFeet();

    $flag = '';
    if($config['account_country'])
        $flag = getFlagImage($account->getCountry());

    $player_sex = 'Unknown';
    if(isset($config['genders'][$player->getSex()]))
        $player_sex = strtolower($config['genders'][$player->getSex()]);

    $marital_status = 'single';
    $marriage_id = $player->getMarriage();
    if($marriage_id > 0) {
        $marriage = new OTS_Player();
        $marriage->load($player->getMarriage(), array('id', 'name'), false);
        if($marriage->isLoaded()) {
            $marital_status = 'married to ' . getPlayerLink($marriage->getName());
        }
    }

    $frags_enabled = $db->hasTable('player_killers') && $config['characters']['frags'];
    $frags_count = 0;
    if($frags_enabled) {
        $query = $db->query(
            'SELECT COUNT(`player_id`) as `frags`' .
            'FROM `player_killers`' .
            'WHERE `player_id` = ' .$player->getId() . ' ' .
            'GROUP BY `player_id`' .
            'ORDER BY COUNT(`player_id`) DESC');

        if($query->rowCount() > 0)
        {
            $query = $query->fetch();
            $frags_count = $query['frags'];
        }
    }

    $town_field = 'town';
    if($db->hasColumn('houses', 'town_id'))
        $town_field = 'town_id';
    else if($db->hasColumn('houses', 'townid'))
        $town_field = 'townid';
    else if(!$db->hasColumn('houses', 'town'))
        $town_field = false;

    if($db->hasColumn('houses', 'name')) {
        $house = $db->query('SELECT `id`, `paid`, `name`' . ($town_field != false ? ', `' . $town_field . '` as `town`' : '') . ' FROM `houses` WHERE `owner` = '.$player->getId())->fetch();
        if(isset($house['id']))
        {
            $add = '';
            if($house['paid'] > 0)
                $add = ' is paid until '.date("M d Y", $house['paid']);
        }
    }

    $rank_of_player = $player->getRank();
    if($rank_of_player->isLoaded()) {
        $guild = $rank_of_player->getGuild();
        if($guild->isLoaded()) {
            $guild_name = $guild->getName();
        }
    }

    $comment = $player->getComment();

    if($config['characters']['skills'])
    {
        if($db->hasColumn('players', 'skill_fist')) {// tfs 1.0+
            $skills_db = $db->query('SELECT `maglevel`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing` FROM `players` WHERE `id` = ' . $player->getId())->fetch();

            $skill_ids = array(
                POT::SKILL_MAGIC => 'maglevel',
                POT::SKILL_FIST => 'skill_fist',
                POT::SKILL_CLUB => 'skill_club',
                POT::SKILL_SWORD => 'skill_sword',
                POT::SKILL_AXE => 'skill_axe',
                POT::SKILL_DIST => 'skill_dist',
                POT::SKILL_SHIELD => 'skill_shielding',
                POT::SKILL_FISH => 'skill_fishing',
            );

            $skills = array();
            foreach($skill_ids as $skillid => $field_name) {
                $skills[] = array('skillid' => $skillid, 'value' => $skills_db[$field_name]);
            }
        }
        else {
            $skills_db = $db->query('SELECT `skillid`, `value` FROM `player_skills` WHERE `player_id` = ' . $player->getId() . ' LIMIT 7');
            $skills = $skills_db->fetchAll();
        }

        foreach($skills as &$skill) {
            $skill['name'] = getSkillName($skill['skillid']);
        }
    }

    $quests_enabled = $config['characters']['quests'] && !empty($config['quests']);
    if($quests_enabled)
    {
        $quests = $config['quests'];
        $sql_query_in = '';
        $i = 0;
        foreach($quests as $quest_name => $quest_storage)
        {
            if($i != 0)
                $sql_query_in .= ', ';

            $sql_query_in .= $quest_storage;
            $i++;
        }

        $storage_sql = $db->query('SELECT `key`, `value` FROM `player_storage` WHERE `player_id` = '.$player->getId().' AND `key` IN (' . $sql_query_in . ')');
        $player_storage = array();
        foreach($storage_sql as $storage)
            $player_storage[$storage['key']] = $storage['value'];

        foreach($quests as &$storage) {
            $storage = isset($player_storage[$storage]) && $player_storage[$storage] > 0;
        }
        unset($storage);
    }

    if($config['characters']['equipment'] && $db->hasTable('player_items') && $db->hasColumn('player_items', 'pid') && $db->hasColumn('player_items', 'sid') && $db->hasColumn('player_items', 'itemtype')) {
        $eq_sql = $db->query('SELECT `pid`, `itemtype` FROM player_items WHERE player_id = '.$player->getId().' AND (`pid` >= 1 and `pid` <= 10)');
        $equipment = array();
        foreach($eq_sql as $eq)
            $equipment[$eq['pid']] = $eq['itemtype'];

        $empty_slots = array("", "no_helmet", "no_necklace", "no_backpack", "no_armor", "no_handleft", "no_handright", "no_legs", "no_boots", "no_ring", "no_ammo");
        for($i = 0; $i <= 10; $i++)
        {
            if(!isset($equipment[$i]) || $equipment[$i] == 0)
                $equipment[$i] = $empty_slots[$i];
        }

        for($i = 1; $i < 11; $i++)
        {
            if(Validator::number($equipment[$i]))
                $equipment[$i] = getItemImage($equipment[$i]);
            else
                $equipment[$i] = '<img src="images/items/' . $equipment[$i] . '.gif" width="32" height="32" border="0" alt=" ' . $equipment[$i] . '" />';
        }

        $skulls = array(
            1 => 'yellow_skull',
            2 => 'green_skull',
            3 => 'white_skull',
            4 => 'red_skull',
            5 => 'black_skull'
        );
    }

    $dead_add_content = '';
    $deaths = array();
    if($db->hasTable('killers')) {
        $player_deaths = $db->query('SELECT `player_id`, `date`, `level` FROM `player_deaths` WHERE `player_id` = '.$player->getId().' ORDER BY `date` DESC LIMIT 0,10;')->fetchAll();
        if(count($player_deaths))
        {
            $number_of_rows = 0;
            foreach($player_deaths as $death)
            {
                $killers = $db->query("SELECT environment_killers.name AS monster_name, players.name AS player_name, players.deleted AS player_exists FROM killers LEFT JOIN environment_killers ON killers.id = environment_killers.kill_id
LEFT JOIN player_killers ON killers.id = player_killers.kill_id LEFT JOIN players ON players.id = player_killers.player_id
WHERE killers.death_id = '".$death['id']."' ORDER BY killers.final_hit DESC, killers.id ASC")->fetchAll();

                $description = '';
                $i = 0;
                $count = count($killers);
                foreach($killers as $killer)
                {
                    $i++;
                    if($killer['player_name'] != "")
                    {
                        if($i == 1)
                            $description .= "Killed at level <b>".$death['level']."</b>";
                        else if($i == $count)
                            $description .= " and";
                        else
                            $description .= ",";

                        $description .= " by ";
                        if($killer['monster_name'] != "")
                            $description .= $killer['monster_name']." summoned by ";

                        if($killer['player_exists'] == 0)
                            $description .= getPlayerLink($killer['player_name']);
                        else
                            $description .= $killer['player_name'];
                    }
                    else
                    {
                        if($i == 1)
                            $description .= "Died at level <b>".$death['level']."</b>";
                        else if($i == $count)
                            $description .= " and";
                        else
                            $description .= ",";

                        $description .= " by ".$killer['monster_name'];
                    }
                }

                $deaths[] = array('time' => $death['date'], 'description' => $description . '.');
            }
        }
    }
    else if ($db->hasColumn('player_deaths', 'time') && $db->hasColumn('player_deaths', 'level') && $db->hasColumn('player_deaths', 'killed_by') && $db->hasColumn('player_deaths', 'is_player')) {
        $mostdamage = '';
        if($db->hasColumn('player_deaths', 'mostdamage_by'))
            $mostdamage = ', `mostdamage_by`, `mostdamage_is_player`, `unjustified`, `mostdamage_unjustified`';
        $deaths_db = $db->query('SELECT
                `player_id`, `time`, `level`, `killed_by`, `is_player`' . $mostdamage . '
                FROM `player_deaths`
                WHERE `player_id` = ' . $player->getId() . ' ORDER BY `time` DESC LIMIT 10;')->fetchAll();

        if(count($deaths_db))
        {
            $number_of_rows = 0;
            foreach($deaths_db as $death)
            {
                $lasthit = ($death['is_player']) ? getPlayerLink($death['killed_by']) : $death['killed_by'];
                $description =  'Killed at level ' . $death['level'] . ' by ' . $lasthit;
                if($death['unjustified']) {
                    $description .=  ' <span style="color: red; font-style: italic;">(unjustified)</span>';
                }

                $mostdmg = ($death['mostdamage_by'] !== $death['killed_by']) ? true : false;
                if($mostdmg)
                {
                    $mostdmg = ($death['mostdamage_is_player']) ? getPlayerLink($death['mostdamage_by']) : $death['mostdamage_by'];
                    $description .=  ' and by ' . $mostdmg;

                    if ($death['mostdamage_unjustified']) {
                        $description .=  ' <span style="color: red; font-style: italic;">(unjustified)</span>';
                    }
                }
                else {
                    $description .=  " <b>(soloed)</b>";
                }

                $deaths[] = array('time' => $death['time'], 'description' => $description);
            }
        }
    }

    $frags = array();
    $frag_add_content = '';
    if($config['characters']['frags'] && $db->hasTable('killers'))
    {
        //frags list by Xampy
        $i = 0;
        $frags_limit = 10; // frags limit to show? // default: 10
        $player_frags = $db->query('SELECT `player_deaths`.*, `players`.`name`, `killers`.`unjustified` FROM `player_deaths` LEFT JOIN `killers` ON `killers`.`death_id` = `player_deaths`.`id` LEFT JOIN `player_killers` ON `player_killers`.`kill_id` = `killers`.`id` LEFT JOIN `players` ON `players`.`id` = `player_deaths`.`player_id` WHERE `player_killers`.`player_id` = '.$player->getId().' ORDER BY `date` DESC LIMIT 0,'.$frags_limit.';')->fetchAll();
        if(count($player_frags))
        {
            $row_count = 0;
            foreach($player_frags as $frag)
            {
                $description = 'Fragged <a href="' . getPlayerLink($frag['name'], false) . '">' . $frag['name'] . '</a> at level ' . $frag['level'];
                $frags[] = array('time' => $frag['date'], 'description' => $description, 'unjustified' => $frag['unjustified'] != 0);
            }
        }
    }

    // signature
    if($config['signature_enabled']) {
        $signature_url = BASE_URL . ($config['friendly_urls'] ? '' : '?') . urlencode($player->getName()) . '.png';
    }

    $hidden = $player->isHidden();
    if(!$hidden) {
        // check if account has been banned
        $bannedUntil = '';
        $banned = array();
        if($db->hasTable('account_bans'))
            $banned = $db->query('SELECT `expires_at` as `expires` FROM `account_bans` WHERE `account_id` = ' . $account->getId() . ' and (`expires_at` > ' . time() . ' OR `expires_at` = -1);');
        else if ($db->hasTable('bans')) {
            if ($db->hasColumn('bans', 'expires'))
                $banned = $db->query('SELECT `expires` FROM `bans` WHERE (`value` = ' . $account->getId() . ' or `value` = ' . $player->getId() . ') and `active` = 1 and `type` != 2 and `type` != 4 and (`expires` > ' . time() . ' OR `expires` = -1);');
            else
                $banned = $db->query('SELECT `time` as `time` FROM `bans` WHERE (`account` = ' . $account->getId() . ' or `player` = ' . $player->getId() . ') and `type` != 2 and `type` != 4 and (`time` > ' . time() . ' OR `time` = -1);');
        }
        foreach($banned as $ban) {
            $bannedUntil = $ban['expires'];
        }

        $account_players = array();
        $query = $db->query('SELECT `id` FROM `players` WHERE `account_id` = ' . $account->getId() . ' ORDER BY `name`')->fetchAll();
        foreach($query as $p) {
            $_player = new OTS_Player();
            $fields = array('id', 'name', 'vocation', 'level', 'online', 'deleted', 'hidden');
            $_player->load($p['id'], $fields, false);
            if($_player->isLoaded() && !$_player->isHidden()) {
                $account_players[] = $_player;
            }
        }
    }

    $twig->display('characters.html.twig', array(
        'outfit' => isset($outfit) ? $outfit : null,
        'player' => $player,
        'account' => $account,
        'flag' => $flag,
        'oldName' => $oldName,
        'sex' => $player_sex,
        'marriage_enabled' => $config['characters']['marriage_info'] && $db->hasColumn('players', 'marriage'),
        'marital_status' => $marital_status,
        'vocation' => $player->getVocationName(),
        'frags_enabled' => $frags_enabled,
        'frags_count' => $frags_count,
        'town' => isset($config['towns'][$player->getTownId()]) ? $config['towns'][$player->getTownId()] : null,
        'house' => array(
            'found' => isset($house['id']),
            'add' => isset($house['id']) ? $add : null,
            'name' => isset($house['id']) ? (isset($house['name']) ? $house['name'] : $house['id']) : null,
            'town' => isset($house['town']) ? ' (' . $config['towns'][$house['town']] . ')' : ''
        ),
        'guild' => array(
            'rank' => isset($guild_name) ? $rank_of_player->getName() : null,
            'link' => isset($guild_name) ? getGuildLink($guild_name) : null
        ),
        'comment' => !empty($comment) ? wordwrap(nl2br($comment), 60, "<br/>", true) : null,
        'skills' => isset($skills) ? $skills : null,
        'quests_enabled' => $quests_enabled,
        'quests' => isset($quests) ? $quests : null,
        'equipment' => isset($equipment) ? $equipment : null,
        'skull' => $player->getSkullTime() > 0 && ($player->getSkull() == 4 || $player->getSkull() == 5) ? $skulls[$player->getSkull()] : null,
        'deaths' => $deaths,
        'frags' => $frags,
        'signature_url' => isset($signature_url) ? $signature_url : null,
        'player_link' => getPlayerLink($player->getName(), false),
        'hidden' => $hidden,
        'bannedUntil' => isset($bannedUntil) ? $bannedUntil : null,
        'characters_link' => getLink('characters'),
        'account_players' => isset($account_players) ? $account_players : null,
        'search_form' => generate_search_form(),
        'canEdit' => hasFlag(FLAG_CONTENT_PLAYERS) || superAdmin()
    ));
}
else
{
    $search_errors[] = 'Character <b>' . $name . '</b> does not exist or has been deleted.';
    $twig->display('error_box.html.twig', array('errors' => $search_errors));
    $search_errors = array();

    $promotion = '';
    if($db->hasColumn('players', 'promotion'))
        $promotion = ', `promotion`';

    $deleted = 'deleted';
    if($db->hasColumn('players', 'deletion'))
        $deleted = 'deletion';

    $query = $db->query('SELECT `name`, `level`, `vocation`' . $promotion . ' FROM `players` WHERE `name` LIKE  ' . $db->quote('%' . $name . '%') . ' AND ' . $deleted . ' != 1 LIMIT ' . (int)config('characters_search_limit') . ';');
    if($query->rowCount() > 0)
    {
        echo 'Did you mean:<ul>';
        foreach($query as $player) {
            if(isset($player['promotion'])) {
                if((int)$player['promotion'] > 0)
                    $player['vocation'] += ($player['promotion'] * $config['vocations_amount']);
            }
            echo '<li>' . getPlayerLink($player['name']) . ' (<small><strong>level ' . $player['level'] . ', ' . $config['vocations'][$player['vocation']] . '</strong></small>)</li>';
        }
        echo '</ul>';
    }

    echo generate_search_form(true);
}

if(!empty($search_errors))
    $twig->display('error_box.html.twig', array('errors' => $search_errors));
 
Upvote 0 Downvote
Lua: 
Exception class: PDOException()

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'date' in 'field list'


Backtrace:

#0 /var/www/html/telara/system/libs/pot/OTS_Base_DB.php(86): PDO->query()
#1 /var/www/html/telara/system/libs/pot/OTS_DB_PDOQuery_PHP71.php(10): OTS_Base_DB->doQuery()
#2 /var/www/html/telara/system/pages/characters.php(237): OTS_Base_DB->query()
#3 /var/www/html/telara/index.php(353): require('...')
#4 {main}
Post automatically merged:

I use this website on tfs 0.4 and all working but I Move my server t TFS 1.5 by nekiro and I have problem With character.php and guild war.
I see Schema from 0.4 to 1.5 is deffrend
 
Upvote 0 Downvote
Yeah that's because of cache. When you moved it thinks that you have old schema from tfs 0.4.

What version of myaac is that? You can see in common.php for VERSION.
 
Upvote 0 Downvote
meybe install MyAAC v0.8.12 ?
Post automatically merged:

I'm install but now I dont se on website Most powerful guilds xD
Post automatically merged:

Guild Is done ,now I have problem with shop when I try buy something I have error

Lua: 
Exception class: PDOException()

SQLSTATE[HY000]: General error: 1364 Field 'login' doesn't have a default value

File: /var/www/html/telara/system/libs/pot/OTS_Base_DB.php
Line: 86


Backtrace:

#0 /var/www/html/ots/system/libs/pot/OTS_Base_DB.php(86): PDO->query()
#1 /var/www/html/ots/system/libs/pot/OTS_DB_PDOQuery_PHP71.php(10): OTS_Base_DB->doQuery()
#2 /var/www/html/ots/system/libs/shop-system.php(168): OTS_Base_DB->query()
#3 /var/www/html/ots/system/pages/gifts.php(113): GesiorShop::confirmTransactionAction()
#4 /var/www/html/ots/index.php(362): require('...')
#5 {main}
Post automatically merged:

Lua: 
<?php

/**#@+
 * @version 0.1.3
 * @since 0.1.3
 */

/**
 * @package POT
 * @author Wrzasq <[email protected]>
 * @copyright 2007 (C) by Wrzasq
 * @license http://www.gnu.org/licenses/lgpl-3.0.txt GNU Lesser General Public License, Version 3
 */

/**
 * Base class for all database drivers.
 *
 * <p>
 * It defines additional rotines required by database driver for POT using default SQL standard-compliant method.
 * </p>
 *
 * @package POT
 */
abstract class OTS_Base_DB extends PDO implements IOTS_DB
{
    use OTS_DB_PDOQuery;
/**
 * Tables prefix.
 *
 * @var string
 */
    protected $prefix = '';

/**
 * Query counter
 *
 * @var int
 */
    private $queries = 0;

    protected $logged = false;
    private $log = '';

/**
 * Query-quoted field name.
 *
 * @param string $name Field name.
 * @return string Quoted name.
 */
    public function fieldName($name)
    {
        return '"' . $name . '"';
    }

    public function fieldNames()
    {
        $ret = '';

        foreach(func_get_args() as $v) {
            $ret .= $this->fieldName($v) . ',';
        }

        $ret[strlen($ret) - 1] = '';
        return $ret;
    }

/**
 * Query-quoted table name.
 *
 * @param string $name Table name.
 * @return string Quoted name.
 */
    public function tableName($name)
    {
        return $this->fieldName($this->prefix . $name);
    }

    private function doQuery(...$args)
    {
        $this->queries++;

        if($this->logged) {
            $startTime = microtime(false);
        }

        $ret = parent::query(...$args);
        if($this->logged) {
            $totalTime = microtime(true) - $startTime;
            $this->log .= round($totalTime, 4) . ' ms - ' . $args[0] . PHP_EOL;
        }

        return $ret;
    }

    public function select($table, $data)
    {
        $fields = array_keys($data);
        $values = array_values($data);
        $query = 'SELECT * FROM ' . $this->tableName($table) . ' WHERE (';

        $count = count($fields);
        for ($i = 0; $i < $count; $i++)
            $query.= $this->fieldName($fields[$i]).' = '.$this->quote($values[$i]).' AND ';
        $query = substr($query, 0, -4);
        $query.=');';

        $query = $this->query($query);
        if($query->rowCount() != 1) return false;
        return $query->fetch();
    }

    public function insert($table, $data)
    {
        $fields = array_keys($data);
        $values = array_values($data);
        $query = 'INSERT INTO ' . $this->tableName($table) . ' (';
        foreach ($fields as $field) {
            $query.= $this->fieldName($field).',';
        }

        $query = substr($query, 0, -1);
        $query .= ') VALUES (';
        foreach ($values as $value) {
            if ($value === null) {
                $query .= 'NULL,';
            }
            else {
                $query .= $this->quote($value).',';
            }
        }

        $query = substr($query, 0, -1);
        $query .= ')';

        $this->exec($query);
        return true;
    }

    public function replace($table, $data)
    {
        $fields = array_keys($data);
        $values = array_values($data);
        $query = 'REPLACE INTO '.$this->tableName($table).' (';
        foreach ($fields as $field)
            $query.= $this->fieldName($field).',';

        $query = substr($query, 0, -1);
        $query.= ') VALUES (';
        foreach ($values as $value)
            if ($value === null)
                $query.= 'NULL,';
            else
                $query.= $this->quote($value).',';

        $query = substr($query, 0, -1);
        $query .= ')';

        $this->query($query);
        return true;
    }

    public function update($table, $data, $where, $limit = 1)
    {
        $fields = array_keys($data);
        $values = array_values($data);

        $query = 'UPDATE '.$this->tableName($table).' SET ';

        $count = count($fields);
        for ($i = 0; $i < $count; $i++)
            $query.= $this->fieldName($fields[$i]).' = '.$this->quote($values[$i]).', ';

        $query = substr($query, 0, -2);
        $query.=' WHERE (';
        $fields = array_keys($where);
        $values = array_values($where);

        $count = count($fields);
        for ($i = 0; $i < $count; $i++)
            $query.= $this->fieldName($fields[$i]).' = '.$this->quote($values[$i]).' AND ';

        $query = substr($query, 0, -4);
        if (isset($limit))
            $query .=') LIMIT '.$limit.';';
        else
            $query .=');';

        $this->exec($query);
        return true;
    }

    public function delete($table, $data, $limit = 1)
    {
        $fields = array_keys($data);
        $values = array_values($data);

        $query = 'DELETE FROM ' . $this->tableName($table) . ' WHERE (';

        $count = count($fields);
        for ($i = 0; $i < $count; $i++) {
            $query .= $this->fieldName($fields[$i]) . ' = ' . $this->quote($values[$i]) . ' AND ';
        }

        $query = substr($query, 0, -4);
        if ($limit > 0) {
            $query.=') LIMIT '.$limit.';';
        }
        else {
            $query.=');';
        }

        $this->exec($query);
        return true;
    }
/**
 * LIMIT/OFFSET clause for queries.
 *
 * @param int|bool $limit Limit of rows to be affected by query (false if no limit).
 * @param int|bool $offset Number of rows to be skipped before applying query effects (false if no offset).
 * @return string LIMIT/OFFSET SQL clause for query.
 */
    public function limit($limit = false, $offset = false)
    {
        // by default this is empty part
        $sql = '';

        if($limit !== false)
        {
            $sql = ' LIMIT ' . $limit;

            // OFFSET has no effect if there is no LIMIT
            if($offset !== false)
            {
                $sql .= ' OFFSET ' . $offset;
            }
        }

        return $sql;
    }

    public function queries() {
        return $this->queries;
    }

    public function getLog() {
        return $this->log;
    }
}

/**#@-*/

?>
Click to expand...
Post automatically merged:

Ca you help me ?please
 
Last edited:
Upvote 0 Downvote

Similar threads

A
  • Question
House dont saved when purchased
Replies
0
Views
175
Azerty
A
abdala ragab
  • Question
TFS 1.X+ I'm trying to add a VIP system Tfs 1.5
Replies
5
Views
278
Evalor
Evalor
A
  • Question
Bounty Hunter System mysql error
Replies
1
Views
270
Dakos
D
J
  • Question
how to solve these errors that has appeared in my database
Replies
2
Views
588
johnsamir
J
J
  • Question
Myacc tfs1.5 shop problem
Replies
8
Views
443
tobi132
T
Back
Top