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

Some GEISOR HELP :(!

Teddy

Teddy

SweStream.se
Joined
Oct 2, 2008
Messages
3,797
Reaction score
10
Location
Sweden 172
Hello i need some help whit this guys..
how to i change geisor to sha1 i have sha1 in config.lua and its not working .. when i look in phpmyadmin the arent like this : f7sfdfjdf7fekre (=sha1) its Password(Plain)

that was the first question the nr 2 question are when i make a char this error come
Code: 
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '9-0' for key 1' in C:\xampp\htdocs\tibia1\pot\OTS_Player.php:187 Stack trace: #0 C:\xampp\htdocs\tibia1\pot\OTS_Player.php(187): PDO->query('INSERT INTO `pl...') #1 C:\xampp\htdocs\tibia1\accountmanagement.php(797): OTS_Player->save() #2 C:\xampp\htdocs\tibia1\index.php(176): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\tibia1\pot\OTS_Player.php on line 187
but my char works good ..? i can login to it and its saves
 
Last edited:
Sort by date Sort by votes
1. Fix password_ency function in config-and-functions.php
2. It's clearly said 1062 Duplicate entry '9-0' for key 1'
 
Upvote 0 Downvote
i have a new error when i creat a char
Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\tibia1\pot\OTS_Player.php:1786 Stack trace: #0 C:\xampp\htdocs\tibia1\accountmanagement.php(804): OTS_Player->getSkill(0) #1 C:\xampp\htdocs\tibia1\index.php(176): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\tibia1\pot\OTS_Player.php on line 1786
Click to expand...
 
Upvote 0 Downvote
your Sample characters don't have their own skill rows in player_skills table :p

Try these SQL queries:
SQL: 
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Sorcerer Sample" LIMIT 1;), 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Sorcerer Sample" LIMIT 1;), 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Sorcerer Sample" LIMIT 1;), 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Sorcerer Sample" LIMIT 1;), 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Sorcerer Sample" LIMIT 1;), 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Sorcerer Sample" LIMIT 1;), 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Sorcerer Sample" LIMIT 1;), 6, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Druid Sample" LIMIT 1;), 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Druid Sample" LIMIT 1;), 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Druid Sample" LIMIT 1;), 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Druid Sample" LIMIT 1;), 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Druid Sample" LIMIT 1;), 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Druid Sample" LIMIT 1;), 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Druid Sample" LIMIT 1;), 6, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Paladin Sample" LIMIT 1;), 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Paladin Sample" LIMIT 1;), 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Paladin Sample" LIMIT 1;), 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Paladin Sample" LIMIT 1;), 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Paladin Sample" LIMIT 1;), 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Paladin Sample" LIMIT 1;), 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Paladin Sample" LIMIT 1;), 6, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Knight Sample" LIMIT 1;), 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Knight Sample" LIMIT 1;), 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Knight Sample" LIMIT 1;), 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Knight Sample" LIMIT 1;), 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Knight Sample" LIMIT 1;), 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Knight Sample" LIMIT 1;), 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES ((SELECT `id` FROM `players` WHERE `name` = "Knight Sample" LIMIT 1;), 6, 10);
 
Upvote 0 Downvote
fixed that but still have this problem when i make a char
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '27-105' for key 1' in C:\xampp\htdocs\accountmanagement.php:814 Stack trace: #0 C:\xampp\htdocs\accountmanagement.php(814): PDO->query('INSERT INTO `pl...') #1 C:\xampp\htdocs\index.php(176): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\accountmanagement.php on line 814
Click to expand...
 
Upvote 0 Downvote
Back
Top