Solved Known bug in 0.3.4 beta acc manager! Does fix exist?

[richux]

ACC MAKER FOR TFS 0.3.4!
it's beta vesion, known bugs:
- doesn't show 'position' (tutor/gm/god) of player on 'search player' page
- page 'support list'/'game masters' doesn't work (show error)

Does someone know fix for it? The error you will get if visiting "Support list" is :

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tibia.groups' doesn't exist' in C:\xampp\htdocs\pot\OTS_Base_List.php:238 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Base_List.php(238): PDO->query('SELECT `groups`...') #1 C:\xampp\htdocs\team.php(14): OTS_Base_List->rewind() #2 C:\xampp\htdocs\index.php(166): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Base_List.php on line 238

SOLVED!

 

[Skylinx]

Either you dont have your sql tables existant, OR your pot folder is just fked.
Try re installing.

 

[richux]

sql tables existant? What does that mean? Everything is fine with my pot folder, and yes I've tried reninstalling it, still the same error. I wonder, has someone made support list work on 0.3.4?

 

[Chris]

Pretty self-explanatory if you ask me ;- )

Table 'tibia.groups' doesn't exist'

 

[Skylinx]

Exactly xD

 

[richux]

WEll yeah, I understand that too, but can someone tell me how to add it?

 

[Pvls]

Download the latest mysql scheme from TFS and take only part with CREATE TABLE 'groups' than insert it to query.

 

[Norix]

No, not the latest, because they removed it from DB and too it to XML. Just insert this:

CREATE TABLE `groups`
(
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL COMMENT 'group name',
  `flags` BIGINT UNSIGNED NOT NULL DEFAULT 0,
  `customflags` BIGINT UNSIGNED NOT NULL DEFAULT 0,
  `access` INT NOT NULL,
  `violationaccess` INT NOT NULL,
  `maxdepotitems` INT NOT NULL,
  `maxviplist` INT NOT NULL,
  `outfit` INT NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB;

INSERT INTO `groups` VALUES (1, 'Player', 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `groups` VALUES (2, 'Tutor', 16809984, 524291, 1, 0, 0, 0, 0);
INSERT INTO `groups` VALUES (3, 'Senior Tutor', 68736352256, 524303, 2, 1, 0, 0, 0);
INSERT INTO `groups` VALUES (4, 'Gamemaster', 510024081247, 4189375, 3, 3, 4000, 200, 75);
INSERT INTO `groups` VALUES (5, 'Community Manager', 542239465466, 4189695, 4, 4, 6000, 300, 266);
INSERT INTO `groups` VALUES (6, 'God', 546534563834, 4194303, 5, 4, 8000, 400, 302);

 

[Shadows]

To make the support list work with the most recent version of TFS replace team.php with:

<?php 
$list = $SQL->query('SELECT name,online,group_id,world_id FROM players WHERE players.group_id > 1 ORDER BY group_id DESC'); 
$groups = simplexml_load_file($config['site']['server_path'].'/data/XML/groups.xml') or die('<b>Could not load groups!</b>');  
        foreach($groups->group as $g)  
            $groupList[(int)$g['id']] = $g['name'];  

$main_content .= '<center><h2>Support in game</h2></center>'; 
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%> 
    <tr bgcolor=\"".$config['site']['vdarkborder']."\"> 
    <td width=\"20%\"><font class=white><b>Group</b></font></td> 
    <td width=\"45%\"><font class=white><b>Name</b></font></td> 
    <td width=\"15%\"><font class=white><b>Status</b></font></td> 
    <td width=\"20%\"><font class=white><b>World</b></font></td>"; 
foreach($list as $gm) { 
    if($gm['online'] == 0) 
        $player_list_status = '<font color="red">Offline</font>'; 
    else 
        $player_list_status = '<font color="green">Online</font>'; 

$main_content .= '<tr bgcolor=\'#888888\'><td>' . $groupList[(int)$gm['group_id']] . '</td><td>'.$gm['name'].'</td><td>'.$player_list_status.'</td><td>'.$config['site']['worlds'][$gm['world_id']].'</td></tr>'; 
} 

$main_content .= "</table>"; 
?>

Credits to ballack13

 

[Norix]

aff didnt saw that he got the bug in support page xd otherwise i could post my script too xd

 

[Shadows]

Hehe sometimes you gotta read their posts 2-3 times.

 

[Norix]

I just read the error msg xd thought that he got it on creating characters. I got this error there too xd

 

[richux]

Shadows FTW! Reputation for you and ballack13:thumbup:

Hehe sometimes you gotta read their posts 2-3 times.

My bad! used code tags instead of php