• 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!

How do I add samples to mysql?

Edling

Member
Joined
Mar 1, 2009
Messages
246
Reaction score
11
Hello. I have by mistaje deleted the samples for both my website and my server and I can't find anywhere how to add them again. I find the code but not how and where to place the code.
I know how to place it when the sql file ain't in phpadamin but when while its imported to the database I don't understand how to edit it. <_<

Code:
INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`, `exphist_lastexp`, `exphist1`, `exphist2`, `exphist3`, `exphist4`, `exphist5`, `exphist6`, `exphist7`, `onlinetimetoday`, `onlinetime1`, `onlinetime2`, `onlinetime3`, `onlinetime4`, `onlinetime5`, `onlinetime6`, `onlinetime7`, `onlinetimeall`) VALUES
 
Ok I created a new db and now finally it works with the samples and I can create characters but on creating I recive this error now. -.-

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\system\application\libraries\POT\OTS_Player.php:1898 Stack trace: #0 C:\xampp\htdocs\system\application\controllers\character.php(188): OTS_Player->getSkill(0) #1 [internal function]: Character->create_character('1') #2 C:\xampp\htdocs\system\codeigniter\CodeIgniter.php(236): call_user_func_array(Array, Array) #3 C:\xampp\htdocs\index.php(165): require_once('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\system\application\libraries\POT\OTS_Player.php on line 1898

OTS_Player.php

line 1885 to 1902

Code:
/**
 * Returns player's skill.
 * 
 * @version 0.0.2
 * @since 0.0.2
 * @param int $skill Skill ID.
 * @return int Skill value.
 * @throws E_OTS_NotLoaded If player is not loaded.
 */
    public function getSkill($skill)
    {
        if( !isset($this->skills[$skill]) )
        {
            throw new E_OTS_NotLoaded();
        }

        return $this->skills[$skill]['value'];
    }
 
Back
Top Bottom