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

Gesior 2012 TFS 1.2 Character.php (frag list)

oualid6496

oualid6496

Well-Known Member
Joined
Aug 24, 2014
Messages
408
Solutions
4
Reaction score
78
Location
Dordrecht, The Netherlands
I was wondering if there is a script that shows the frags that were made by the person for gesior 2012?

There used to be a script on the old gesior version of Xampy
PHP: 
            //frags list by Xampy
            
            $frags_limit = 10; // frags limit to show? // default: 10
            $player_frags = $SQL->query('SELECT `player_deaths`.*, `players`.`name`, `killers`.`unjustified` FROM `player_deaths` LEFT JOIN `killers` ON `killers`.`death_id` = `player_deaths`.`id` LEFT JOIN `player_killers` ON `player_killers`.`kill_id` = `killers`.`id` LEFT JOIN `players` ON `players`.`id` = `player_deaths`.`player_id` WHERE `player_killers`.`player_id` = '.$player->getId().' ORDER BY `date` DESC LIMIT 0,'.$frags_limit.';');
            if(count($player_frags))
            {
                $frags = 0;
                $frag_add_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><br><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Frags</B></TD></TR>';
                foreach($player_frags as $frag)
                {
                $frags++;
                    if(is_int($number_of_rows / 2)) $bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder'];
                    $number_of_rows++;
                    $frag_add_content .= "<tr bgcolor=\"".$bgcolor."\">
                    <td width=\"20%\" align=\"center\">".date("j M Y, H:i", $frag['date'])."</td>
                    <td>".(($player->getSex() == 0) ? 'She' : 'He')." fragged <a href=\"index.php?subtopic=characters&name=".$frag[name]."\">".$frag[name]."</a> at level ".$frag[level]."";

                    $frag_add_content .= ". (".(($frag[unjustified] == 0) ? "<font size=\"1\" color=\"green\">Justified</font>" : "<font size=\"1\" color=\"red\">Unjustified</font>").")</td></tr>";
                }
            if($frags >= 1)
                $main_content .= $frag_add_content . '</TABLE>';
            }
            // end of frags list by Xampy

Here is an example of what I mean:
25hidc4.jpg
 
Last edited by a moderator:
Sort by date Sort by votes
StreamSide said:
select * from player_kills
Click to expand...
i try change to:
PHP: 
 $player_frags = $SQL->query('SELECT `player_deaths`.*, `players`.`name`, `killers`.`unjustified` FROM `player_deaths` LEFT JOIN `killers` ON `killers`.`death_id` = `player_deaths`.`id` LEFT JOIN `player_kills` ON `player_kills`.`kill_id` = `killers`.`id` LEFT JOIN `players` ON `players`.`id` = `player_deaths`.`player_id` WHERE `player_kills`.`player_id` = '.$player->getId().' ORDER BY `date` DESC LIMIT 0,'.$frags_limit.';');

but dont work xD
 
Last edited by a moderator:
Upvote 0 Downvote
Try to use the old script and post the bugs / error messages insted.
If nothing shows up go to index.php and set DEBUG_DATABASE to true, then reload the page and take an SS
 
Upvote 0 Downvote
WibbenZ said:
Try to use the old script and post the bugs / error messages insted.
If nothing shows up go to index.php and set DEBUG_DATABASE to true, then reload the page and take an SS
Click to expand...
Did that it didn't give any errors as you said so I set DEBUG_DATABASE to true and got these errors:

Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'OUALID THE DRUID'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `create_ip`, `creation`, `coins`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `id` = '47'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `player_id` FROM `players_online`
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `account_bans`.`account_id`, `account_bans`.`reason`, `account_bans`.`banned_at`, `account_bans`.`expires_at`, `account_bans`.`banned_by` FROM `account_bans` WHERE `account_id` = '47'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '58'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `guild_id`, `name`, `level` FROM `guild_ranks` WHERE `id` = '11'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `name`, `ownerid`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo` FROM `guilds` WHERE `id` = '4'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `player_items`.`player_id`, `player_items`.`pid`, `player_items`.`sid`, `player_items`.`itemtype`, `player_items`.`count`, `player_items`.`attributes` FROM `player_items` WHERE `player_items`.`player_id` = '58'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 20279;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 1014;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 12176;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 102504;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `player_deaths`.*, `players`.`name`, `killers`.`unjustified` FROM `player_deaths` LEFT JOIN `killers` ON `killers`.`death_id` = `player_deaths`.`id` LEFT JOIN `player_killers` ON `player_killers`.`kill_id` = `killers`.`id` LEFT JOIN `players` ON `players`.`id` = `player_deaths`.`player_id` WHERE `player_killers`.`player_id` = 58 ORDER BY `date` DESC LIMIT 0,10;
SQLSTATE: 42S02
Driver code: 1146
Error message: Table 'oujdaot.killers' doesn't exist
Query: SELECT `player_deaths`.`player_id`, `player_deaths`.`time`, `player_deaths`.`level`, `player_deaths`.`killed_by`, `player_deaths`.`is_player`, `player_deaths`.`mostdamage_by`, `player_deaths`.`mostdamage_is_player`, `player_deaths`.`unjustified`, `player_deaths`.`mostdamage_unjustified`, `players`.`id`, `players`.`name` FROM `players`, `player_deaths` WHERE `player_id` = '58' AND `players`.`id` = `player_deaths`.`player_id` ORDER BY `time` DESC LIMIT 20
SQLSTATE: 00000
Driver code:
Error message:

Query: SELECT `players`.`id`, `players`.`name`, `players`.`group_id`, `players`.`account_id`, `players`.`level`, `players`.`vocation`, `players`.`health`, `players`.`healthmax`, `players`.`experience`, `players`.`lookbody`, `players`.`lookfeet`, `players`.`lookhead`, `players`.`looklegs`, `players`.`looktype`, `players`.`lookaddons`, `players`.`maglevel`, `players`.`mana`, `players`.`manamax`, `players`.`manaspent`, `players`.`soul`, `players`.`town_id`, `players`.`posx`, `players`.`posy`, `players`.`posz`, `players`.`conditions`, `players`.`cap`, `players`.`sex`, `players`.`lastlogin`, `players`.`lastip`, `players`.`save`, `players`.`skull`, `players`.`skulltime`, `players`.`lastlogout`, `players`.`blessings`, `players`.`balance`, `players`.`stamina`, `players`.`skill_fist`, `players`.`skill_fist_tries`, `players`.`skill_club`, `players`.`skill_club_tries`, `players`.`skill_sword`, `players`.`skill_sword_tries`, `players`.`skill_axe`, `players`.`skill_axe_tries`, `players`.`skill_dist`, `players`.`skill_dist_tries`, `players`.`skill_shielding`, `players`.`skill_shielding_tries`, `players`.`skill_fishing`, `players`.`skill_fishing_tries`, `players`.`deleted`, `players`.`create_ip`, `players`.`create_date`, `players`.`comment`, `players`.`hide_char` FROM `players` WHERE `account_id` = '47' ORDER BY `name` ASC
SQLSTATE: 00000
Driver code:
Error message:[/spoiler

WibbenZ said:
Try to use the old script and post the bugs / error messages insted.
If nothing shows up go to index.php and set DEBUG_DATABASE to true, then reload the page and take an SS
Click to expand...


I also tried here with the original code of this topic and I had these errors:

HTML: 
Query:    SELECT `id`, `guild_points`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `create_ip`, `creation`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `name` = 'teste2'
SQLSTATE:    00000
Driver code:  
Error message:  
Query:    SELECT `account_bans`.`account_id`, `account_bans`.`reason`, `account_bans`.`banned_at`, `account_bans`.`expires_at`, `account_bans`.`banned_by` FROM `account_bans` WHERE `account_id` = '91'
SQLSTATE:    00000
Driver code:  
Error message:

I think the above errors are not referred to the script, we're putting in the wrong spot maybe.
 
Last edited by a moderator:
Upvote 0 Downvote
Oualid said:
Did that it didn't give any errors as you said so I set DEBUG_DATABASE to true and got these errors:

Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'OUALID THE DRUID'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `create_ip`, `creation`, `coins`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `id` = '47'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `player_id` FROM `players_online`
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `account_bans`.`account_id`, `account_bans`.`reason`, `account_bans`.`banned_at`, `account_bans`.`expires_at`, `account_bans`.`banned_by` FROM `account_bans` WHERE `account_id` = '47'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '58'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `guild_id`, `name`, `level` FROM `guild_ranks` WHERE `id` = '11'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `name`, `ownerid`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo` FROM `guilds` WHERE `id` = '4'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `player_items`.`player_id`, `player_items`.`pid`, `player_items`.`sid`, `player_items`.`itemtype`, `player_items`.`count`, `player_items`.`attributes` FROM `player_items` WHERE `player_items`.`player_id` = '58'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 20279;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 1014;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 12176;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 102504;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `player_deaths`.*, `players`.`name`, `killers`.`unjustified` FROM `player_deaths` LEFT JOIN `killers` ON `killers`.`death_id` = `player_deaths`.`id` LEFT JOIN `player_killers` ON `player_killers`.`kill_id` = `killers`.`id` LEFT JOIN `players` ON `players`.`id` = `player_deaths`.`player_id` WHERE `player_killers`.`player_id` = 58 ORDER BY `date` DESC LIMIT 0,10;
SQLSTATE: 42S02
Driver code: 1146
Error message: Table 'oujdaot.killers' doesn't exist
Query: SELECT `player_deaths`.`player_id`, `player_deaths`.`time`, `player_deaths`.`level`, `player_deaths`.`killed_by`, `player_deaths`.`is_player`, `player_deaths`.`mostdamage_by`, `player_deaths`.`mostdamage_is_player`, `player_deaths`.`unjustified`, `player_deaths`.`mostdamage_unjustified`, `players`.`id`, `players`.`name` FROM `players`, `player_deaths` WHERE `player_id` = '58' AND `players`.`id` = `player_deaths`.`player_id` ORDER BY `time` DESC LIMIT 20
SQLSTATE: 00000
Driver code:
Error message:

Query: SELECT `players`.`id`, `players`.`name`, `players`.`group_id`, `players`.`account_id`, `players`.`level`, `players`.`vocation`, `players`.`health`, `players`.`healthmax`, `players`.`experience`, `players`.`lookbody`, `players`.`lookfeet`, `players`.`lookhead`, `players`.`looklegs`, `players`.`looktype`, `players`.`lookaddons`, `players`.`maglevel`, `players`.`mana`, `players`.`manamax`, `players`.`manaspent`, `players`.`soul`, `players`.`town_id`, `players`.`posx`, `players`.`posy`, `players`.`posz`, `players`.`conditions`, `players`.`cap`, `players`.`sex`, `players`.`lastlogin`, `players`.`lastip`, `players`.`save`, `players`.`skull`, `players`.`skulltime`, `players`.`lastlogout`, `players`.`blessings`, `players`.`balance`, `players`.`stamina`, `players`.`skill_fist`, `players`.`skill_fist_tries`, `players`.`skill_club`, `players`.`skill_club_tries`, `players`.`skill_sword`, `players`.`skill_sword_tries`, `players`.`skill_axe`, `players`.`skill_axe_tries`, `players`.`skill_dist`, `players`.`skill_dist_tries`, `players`.`skill_shielding`, `players`.`skill_shielding_tries`, `players`.`skill_fishing`, `players`.`skill_fishing_tries`, `players`.`deleted`, `players`.`create_ip`, `players`.`create_date`, `players`.`comment`, `players`.`hide_char` FROM `players` WHERE `account_id` = '47' ORDER BY `name` ASC
SQLSTATE: 00000
Driver code:
Error message:[/spoiler




I also tried here with the original code of this topic and I had these errors:

HTML: 
Query:    SELECT `id`, `guild_points`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `create_ip`, `creation`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `name` = 'teste2'
SQLSTATE:    00000
Driver code: 
Error message: 
Query:    SELECT `account_bans`.`account_id`, `account_bans`.`reason`, `account_bans`.`banned_at`, `account_bans`.`expires_at`, `account_bans`.`banned_by` FROM `account_bans` WHERE `account_id` = '91'
SQLSTATE:    00000
Driver code: 
Error message:

I think the above errors are not referred to the script, we're putting in the wrong spot maybe.
Click to expand...


Code: 
Query: SELECT `player_deaths`.*, `players`.`name`, `killers`.`unjustified` FROM `player_deaths` LEFT JOIN `killers` ON `killers`.`death_id` = `player_deaths`.`id` LEFT JOIN `player_killers` ON `player_killers`.`kill_id` = `killers`.`id` LEFT JOIN `players` ON `players`.`id` = `player_deaths`.`player_id` WHERE `player_killers`.`player_id` = 58 ORDER BY `date` DESC LIMIT 0,10;
SQLSTATE: 42S02
Driver code: 1146
Error message: Table 'oujdaot.killers' doesn't exist

The database schema is diffrent check the queries and see what you need to change.

Also please read the rules; Rules for the Support board
#2
 
Upvote 0 Downvote
WibbenZ said:
Code: 
Query: SELECT `player_deaths`.*, `players`.`name`, `killers`.`unjustified` FROM `player_deaths` LEFT JOIN `killers` ON `killers`.`death_id` = `player_deaths`.`id` LEFT JOIN `player_killers` ON `player_killers`.`kill_id` = `killers`.`id` LEFT JOIN `players` ON `players`.`id` = `player_deaths`.`player_id` WHERE `player_killers`.`player_id` = 58 ORDER BY `date` DESC LIMIT 0,10;
SQLSTATE: 42S02
Driver code: 1146
Error message: Table 'oujdaot.killers' doesn't exist

The database schema is diffrent check the queries and see what you need to change.

Also please read the rules; Rules for the Support board
#2
Click to expand...
What did I do wrong? :p I didn't post again within 24 hours
 
Upvote 0 Downvote
Oualid said:
What did I do wrong? :p I didn't post again within 24 hours
Click to expand...

Your first post was made at; Oualid, Yesterday at 12:29 AM
I edited the post at; Last edited by a moderator: Yesterday at 6:03 PM

Did you check the schema?
 
Upvote 0 Downvote
Oualid said:
Did that it didn't give any errors as you said so I set DEBUG_DATABASE to true and got these errors:

Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'OUALID THE DRUID'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `create_ip`, `creation`, `coins`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `id` = '47'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `player_id` FROM `players_online`
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `account_bans`.`account_id`, `account_bans`.`reason`, `account_bans`.`banned_at`, `account_bans`.`expires_at`, `account_bans`.`banned_by` FROM `account_bans` WHERE `account_id` = '47'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '58'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `guild_id`, `name`, `level` FROM `guild_ranks` WHERE `id` = '11'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `id`, `name`, `ownerid`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo` FROM `guilds` WHERE `id` = '4'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `player_items`.`player_id`, `player_items`.`pid`, `player_items`.`sid`, `player_items`.`itemtype`, `player_items`.`count`, `player_items`.`attributes` FROM `player_items` WHERE `player_items`.`player_id` = '58'
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 20279;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 1014;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 12176;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 2645;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT * FROM `player_storage` WHERE `player_id` = 58 AND `key` = 102504;
SQLSTATE: 00000
Driver code:
Error message:
Query: SELECT `player_deaths`.*, `players`.`name`, `killers`.`unjustified` FROM `player_deaths` LEFT JOIN `killers` ON `killers`.`death_id` = `player_deaths`.`id` LEFT JOIN `player_killers` ON `player_killers`.`kill_id` = `killers`.`id` LEFT JOIN `players` ON `players`.`id` = `player_deaths`.`player_id` WHERE `player_killers`.`player_id` = 58 ORDER BY `date` DESC LIMIT 0,10;
SQLSTATE: 42S02
Driver code: 1146
Error message: Table 'oujdaot.killers' doesn't exist
Query: SELECT `player_deaths`.`player_id`, `player_deaths`.`time`, `player_deaths`.`level`, `player_deaths`.`killed_by`, `player_deaths`.`is_player`, `player_deaths`.`mostdamage_by`, `player_deaths`.`mostdamage_is_player`, `player_deaths`.`unjustified`, `player_deaths`.`mostdamage_unjustified`, `players`.`id`, `players`.`name` FROM `players`, `player_deaths` WHERE `player_id` = '58' AND `players`.`id` = `player_deaths`.`player_id` ORDER BY `time` DESC LIMIT 20
SQLSTATE: 00000
Driver code:
Error message:

Query: SELECT `players`.`id`, `players`.`name`, `players`.`group_id`, `players`.`account_id`, `players`.`level`, `players`.`vocation`, `players`.`health`, `players`.`healthmax`, `players`.`experience`, `players`.`lookbody`, `players`.`lookfeet`, `players`.`lookhead`, `players`.`looklegs`, `players`.`looktype`, `players`.`lookaddons`, `players`.`maglevel`, `players`.`mana`, `players`.`manamax`, `players`.`manaspent`, `players`.`soul`, `players`.`town_id`, `players`.`posx`, `players`.`posy`, `players`.`posz`, `players`.`conditions`, `players`.`cap`, `players`.`sex`, `players`.`lastlogin`, `players`.`lastip`, `players`.`save`, `players`.`skull`, `players`.`skulltime`, `players`.`lastlogout`, `players`.`blessings`, `players`.`balance`, `players`.`stamina`, `players`.`skill_fist`, `players`.`skill_fist_tries`, `players`.`skill_club`, `players`.`skill_club_tries`, `players`.`skill_sword`, `players`.`skill_sword_tries`, `players`.`skill_axe`, `players`.`skill_axe_tries`, `players`.`skill_dist`, `players`.`skill_dist_tries`, `players`.`skill_shielding`, `players`.`skill_shielding_tries`, `players`.`skill_fishing`, `players`.`skill_fishing_tries`, `players`.`deleted`, `players`.`create_ip`, `players`.`create_date`, `players`.`comment`, `players`.`hide_char` FROM `players` WHERE `account_id` = '47' ORDER BY `name` ASC
SQLSTATE: 00000
Driver code:
Error message:[/spoiler




I also tried here with the original code of this topic and I had these errors:

HTML: 
Query:    SELECT `id`, `guild_points`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `create_ip`, `creation`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `name` = 'teste2'
SQLSTATE:    00000
Driver code: 
Error message: 
Query:    SELECT `account_bans`.`account_id`, `account_bans`.`reason`, `account_bans`.`banned_at`, `account_bans`.`expires_at`, `account_bans`.`banned_by` FROM `account_bans` WHERE `account_id` = '91'
SQLSTATE:    00000
Driver code: 
Error message:

I think the above errors are not referred to the script, we're putting in the wrong spot maybe.
Click to expand...

Which SQL are you using? or platform? Xampp/Uniform server?
 
Upvote 0 Downvote
WibbenZ said:
Your first post was made at; Oualid, Yesterday at 12:29 AM
I edited the post at; Last edited by a moderator: Yesterday at 6:03 PM

Did you check the schema?
Click to expand...
Yes I see that im missing "killers", "kill_id", "unjustified" and "player_killers".

Imereth Popis said:
Which SQL are you using? or platform? Xampp/Uniform server?
Click to expand...
Im using Uniserver
 
Upvote 0 Downvote

Similar threads

Izaack
  • Solved
Linux HTTP ERROR 500 WHILE DISPLAYING CHARACTER ON WEBPAGE GESIOR ACC 2012
Replies
5
Views
464
Izaack
Izaack
T
  • Question
TFS 1.X+ Already set up a 10.98 server, need help with 12.87
Replies
1
Views
810
traussio
T
Back
Top