Recover default player skills [Gesior]

[freddzor11]

When I enter a character at my website I get this error, I use Gesior

 

[Greypaw]

doesn't matter only this error removes

Then delete the database and re-create it.

 

[freddzor11]

Then delete the database and re-create it.

just made this database-.- :/ do you think it's gonna work if I delete the whole database?

 

[Greypaw]

just made this database-.- :/ do you think it's gonna work if I delete the whole database?

Well, obviously something is wrong with the database, either that or you downloaded the wrong Gesior for your client version.

 

[freddzor11]

Well, obviously something is wrong with the database, either that or you downloaded the wrong Gesior for your client version.

it worked before, with same gesior, then I guess it's the database, I've made a new database and it's still same problem -.-'

 

[seleo]

try this sql command

DROP TRIGGER IF EXISTS `oncreate_players`;
DELIMITER //
CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players`
 FOR EACH ROW BEGIN
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END

 

[freddzor11]

try this sql command

DROP TRIGGER IF EXISTS `oncreate_players`;
DELIMITER //
CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players`
FOR EACH ROW BEGIN
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END

doesn't work :/

 

[freddzor11]

I also found this in config.inc.php

/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';

but when I tried to change it to mysql only it didn't work either

 

[Gesior.pl]

First execute this:

DROP TRIGGER IF EXISTS `oncreate_players`;
DELIMITER //
CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players`
 FOR EACH ROW BEGIN
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END

If it show error, ignore it (it means that it's already installed).

Then add new file in acc. maker in 'pages' named 'fix.php' and paste in it:

<?php
foreach($SQL->query('SELECT `id` FROM `players`') as $player)
{
    for($i=0;$i <= 6; $i++)
    {
        $SQL->query("INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES (" . $player['id'] . ", " . $i . ", '10', '0');");
    }
}

Then open that page:
http://127.0.0.1/?subtopic=fix

 

[freddzor11]

First execute this:

DROP TRIGGER IF EXISTS `oncreate_players`;
DELIMITER //
CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players`
FOR EACH ROW BEGIN
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END

If it show error, ignore it (it means that it's already installed).

Then add new file in acc. maker in 'pages' named 'fix.php' and paste in it:

<?php
foreach($SQL->query('SELECT `id` FROM `players`') as $player)
{
    for($i=0;$i <= 6; $i++)
    {
        $SQL->query("INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES (" . $player['id'] . ", " . $i . ", '10', '0');");
    }
}

Then open that page:
http://127.0.0.1/?subtopic=fix

Thank you man! but I using your gesior 2012 now instead and now it works perfectly!