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

[Geisor AAC] Customized characters.php, screenshot!

error



what is this

PHP:
DROP TABLE IF EXISTS `player_advances`;

CREATE TABLE `player_advances` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `skill` int(11) DEFAULT NULL,
  `oldlevel` int(11) DEFAULT NULL,
  `newlevel` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `cid` (`cid`),
  CONSTRAINT `player_advances_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
 
.. aff please complete the code of he not posted in config.php

PHP:
$config['site']['show_skills_info'] = 1;
$config['site']['show_outfit'] = 1;
$config['site']['show_signature'] =1;
 
lol i have error
Fatal error: Call to undefined function parseubb() in F:\xampp\xampp\htdocs\characters.php on line 165
:/
 
i fix this but i have next error:
Code:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'field list'' in F:\xampp\xampp\htdocs\characters.php:308 Stack trace: #0 F:\xampp\xampp\htdocs\characters.php(308): PDO->query('SELECT `id`, `d...') #1 F:\xampp\xampp\htdocs\index.php(142): include('F:\xampp\xampp\...') #2 {main} thrown in F:\xampp\xampp\htdocs\characters.php on line 308
 
For me it does not show advances on website, maybe script for creaturescripts is wrong?
function onAdvance(cid, skill, oldLevel, newLevel)

db.executeQuery("INSERT INTO player_advances (cid, skill, oldlevel, newlevel, time) VALUES ('" .. getPlayerGUID(cid) .. "', '" .. skill .."', '" .. oldLevel .."', '" .. newLevel .."', '" .. os.time() .. "' )")

return true
end
 
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'where clause'' in C:\xampp\htdocs\characters.php:240 Stack trace: #0 C:\xampp\htdocs\characters.php(240): PDO->query('SELECT * FROM p...') #1 C:\xampp\htdocs\index.php(92): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\characters.php on line 240
 
Back
Top