ROZWIĄZANY: Pomoc z aplikacją

**Julcio** · 8 Stycznia 2012

Witam!

Potrzebuję kogoś, kto mógłby przejrzeć aplikację, którą posiadam i powiedzieć mi, dlaczego nie działa i gdy wchodzę w jej zakładkę wyskakuję taki błąd:

Jeśli jest ktoś chętny mogę ewentualnie wysłać pliki na PW.

Pozdrawiam!

**Amfidiusz** · 8 Stycznia 2012

Działów nie pomyliłeś przypadkiem? Takie tematy bardziej pasują do Giełdy...

Aplikacja autorska? Pokaż logi z folderu cache.

**Julcio** · 8 Stycznia 2012

Tutaj logi z pliku "sql_error_log_01_08_12.cgi":

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:20:22 +0000
Error: 1146 - Table 'julcio_rp.irp_players' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=members&section=load&module=ajax&member_id=1&tab=perfect-rp:characters&md5check=28fdade97aad4af6ffc3502c0d5e348f
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT ID, Name, GlobalAcc, Skin, Hours, Minutes FROM irp_players WHERE GlobalAcc = 1 ORDER BY ID
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/members/modules_public/ajax/load.php					| [profile_characters].return_html_block										| 192			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [public_members_ajax_load].doExecute										  | 832			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [ipsAjaxCommand].execute													  | 239			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:20:26 +0000
Error: 1146 - Table 'julcio_rp.irp_players' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=members&section=load&module=ajax&member_id=1&tab=perfect-rp:characters&md5check=28fdade97aad4af6ffc3502c0d5e348f
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT ID, Name, GlobalAcc, Skin, Hours, Minutes FROM irp_players WHERE GlobalAcc = 1 ORDER BY ID
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/members/modules_public/ajax/load.php					| [profile_characters].return_html_block										| 192			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [public_members_ajax_load].doExecute										  | 832			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [ipsAjaxCommand].execute													  | 239			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:35:50 +0000
Error: 1146 - Table 'julcio_rp.hrp_online' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=hrp
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT p.nick,o.time,u.member_id,u.member_group_id,u.members_seo_name,u.members_display_name,u.gs,u.hpr FROM hrp_online o,hrp_players p, members u WHERE o.uid=p.player_uid and p.owner=u.member_id ORDER BY p.nick
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsController.php									   | [public_hrp_online_onlinePlayers].doExecute								   | 601			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:36:00 +0000
Error: 1146 - Table 'julcio_rp.hrp_online' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=hrp
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT p.nick,o.time,u.member_id,u.member_group_id,u.members_seo_name,u.members_display_name,u.gs,u.hpr FROM hrp_online o,hrp_players p, members u WHERE o.uid=p.player_uid and p.owner=u.member_id ORDER BY p.nick
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsController.php									   | [public_hrp_online_onlinePlayers].doExecute								   | 601			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:36:01 +0000
Error: 1146 - Table 'julcio_rp.hrp_online' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=hrp
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT p.nick,o.time,u.member_id,u.member_group_id,u.members_seo_name,u.members_display_name,u.gs,u.hpr FROM hrp_online o,hrp_players p, members u WHERE o.uid=p.player_uid and p.owner=u.member_id ORDER BY p.nick
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsController.php									   | [public_hrp_online_onlinePlayers].doExecute								   | 601			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:37:17 +0000
Error: 1146 - Table 'julcio_rp.hrp_players' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=members&section=load&module=ajax&member_id=1&tab=hrp:chars&md5check=28fdade97aad4af6ffc3502c0d5e348f
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT player_uid,nick,seen,skin,lskin,playedhours,ban,blockacc FROM hrp_players WHERE owner=1
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/hrp/extensions/profileTabs/chars.php		| [hrPLib].getMemberCharacters												  | 15				|
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_public/ajax/load.php					| [profile_chars].return_html_block											 | 192			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [public_members_ajax_load].doExecute										  | 832			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [ipsAjaxCommand].execute													  | 239			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:37:20 +0000
Error: 1146 - Table 'julcio_rp.hrp_players' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=members&section=load&module=ajax&member_id=1&tab=hrp:chars&md5check=28fdade97aad4af6ffc3502c0d5e348f
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT player_uid,nick,seen,skin,lskin,playedhours,ban,blockacc FROM hrp_players WHERE owner=1
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/hrp/extensions/profileTabs/chars.php		| [hrPLib].getMemberCharacters												  | 15				|
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_public/ajax/load.php					| [profile_chars].return_html_block											 | 192			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [public_members_ajax_load].doExecute										  | 832			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [ipsAjaxCommand].execute													  | 239			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:37:24 +0000
Error: 1146 - Table 'julcio_rp.hrp_players' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=members&section=load&module=ajax&member_id=1&tab=hrp:adminRecord&md5check=28fdade97aad4af6ffc3502c0d5e348f
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT player_uid FROM hrp_players WHERE owner=1
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/hrp/extensions/profileTabs/adminRecord.php  | [hrPLib].getMemberCharacters												  | 15				|
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_public/ajax/load.php					| [profile_adminRecord].return_html_block									   | 192			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [public_members_ajax_load].doExecute										  | 832			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [ipsAjaxCommand].execute													  | 239			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:37:25 +0000
Error: 1146 - Table 'julcio_rp.hrp_players' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=members&section=load&module=ajax&member_id=1&tab=hrp:adminRecord&md5check=28fdade97aad4af6ffc3502c0d5e348f
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT player_uid FROM hrp_players WHERE owner=1
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/hrp/extensions/profileTabs/adminRecord.php  | [hrPLib].getMemberCharacters												  | 15				|
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_public/ajax/load.php					| [profile_adminRecord].return_html_block									   | 192			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [public_members_ajax_load].doExecute										  | 832			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [ipsAjaxCommand].execute													  | 239			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:37:41 +0000
Error: 1146 - Table 'julcio_rp.hrp_online' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=hrp
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT p.nick,o.time,u.member_id,u.member_group_id,u.members_seo_name,u.members_display_name,u.gs,u.hpr FROM hrp_online o,hrp_players p, members u WHERE o.uid=p.player_uid and p.owner=u.member_id ORDER BY p.nick
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsController.php									   | [public_hrp_online_onlinePlayers].doExecute								   | 601			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:37:53 +0000
Error: 1146 - Table 'julcio_rp.hrp_players' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=members&section=load&module=ajax&member_id=1&tab=hrp:chars&md5check=28fdade97aad4af6ffc3502c0d5e348f
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT player_uid,nick,seen,skin,lskin,playedhours,ban,blockacc FROM hrp_players WHERE owner=1
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/hrp/extensions/profileTabs/chars.php		| [hrPLib].getMemberCharacters												  | 15				|
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_public/ajax/load.php					| [profile_chars].return_html_block											 | 192			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [public_members_ajax_load].doExecute										  | 832			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [ipsAjaxCommand].execute													  | 239			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:37:54 +0000
Error: 1146 - Table 'julcio_rp.hrp_players' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=members&section=load&module=ajax&member_id=1&tab=hrp:adminRecord&md5check=28fdade97aad4af6ffc3502c0d5e348f
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT player_uid FROM hrp_players WHERE owner=1
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/hrp/extensions/profileTabs/adminRecord.php  | [hrPLib].getMemberCharacters												  | 15				|
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_public/ajax/load.php					| [profile_adminRecord].return_html_block									   | 192			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [public_members_ajax_load].doExecute										  | 832			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [ipsAjaxCommand].execute													  | 239			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:38:51 +0000
Error: 1146 - Table 'julcio_rp.hrp_players' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=members&section=load&module=ajax&member_id=1&tab=hrp:chars&md5check=28fdade97aad4af6ffc3502c0d5e348f
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT player_uid,nick,seen,skin,lskin,playedhours,ban,blockacc FROM hrp_players WHERE owner=1
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/hrp/extensions/profileTabs/chars.php		| [hrPLib].getMemberCharacters												  | 15				|
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_public/ajax/load.php					| [profile_chars].return_html_block											 | 192			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [public_members_ajax_load].doExecute										  | 832			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [ipsAjaxCommand].execute													  | 239			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:38:53 +0000
Error: 1146 - Table 'julcio_rp.hrp_players' doesn't exist
IP Address: 89.72.236.243 - /forum/index.php?app=members&section=load&module=ajax&member_id=1&tab=hrp:adminRecord&md5check=28fdade97aad4af6ffc3502c0d5e348f
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT player_uid FROM hrp_players WHERE owner=1
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/hrp/extensions/profileTabs/adminRecord.php  | [hrPLib].getMemberCharacters												  | 15				|
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/members/modules_public/ajax/load.php					| [profile_adminRecord].return_html_block									   | 192			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [public_members_ajax_load].doExecute										  | 832			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									   | [ipsAjaxCommand].execute													  | 239			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 01:42:25 +0000
Error: 1054 - Unknown column 'u.gs' in 'field list'
IP Address: 89.72.236.243 - /forum/index.php?app=hrp
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT p.nick,o.time,u.member_id,u.member_group_id,u.members_seo_name,u.members_display_name,u.gs,u.hpr FROM hrp_online o,hrp_players p, members u WHERE o.uid=p.player_uid and p.owner=u.member_id ORDER BY p.nick
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsController.php									   | [public_hrp_online_onlinePlayers].doExecute								   | 601			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 07:07:48 +0000
Error: 1054 - Unknown column 'u.gs' in 'field list'
IP Address: 89.72.236.243 - /forum/index.php?app=hrp
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT p.nick,o.time,u.member_id,u.member_group_id,u.members_seo_name,u.members_display_name,u.gs,u.hpr FROM hrp_online o,hrp_players p, members u WHERE o.uid=p.player_uid and p.owner=u.member_id ORDER BY p.nick
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsController.php									   | [public_hrp_online_onlinePlayers].doExecute								   | 601			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 08 Jan 2012 07:16:49 +0000
Error: 1054 - Unknown column 'u.gs' in 'field list'
IP Address: 89.72.236.243 - /forum/index.php?app=hrp
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT p.nick,o.time,u.member_id,u.member_group_id,u.members_seo_name,u.members_display_name,u.gs,u.hpr FROM hrp_online o,hrp_players p, members u WHERE o.uid=p.player_uid and p.owner=u.member_id ORDER BY p.nick
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	   | Function																	  | Line No.		  |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsController.php									   | [public_hrp_online_onlinePlayers].doExecute								   | 601			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Edytowane 8 Stycznia 2012 przez Julcio

**Julcio** · 8 Stycznia 2012

Te logi z irp.players się nie tyczą, tylko hrp_players.. etc.

Link do bazy:

http://speedy.sh/qgP5X/hrpserwer.sql

Ups.. Sorry za double :<<

Edytowane 8 Stycznia 2012 przez Julcio

**Amfidiusz** · 8 Stycznia 2012

W bazie brakuje tabeli, do której odwołuje się aplikacja.

Aplikacja autorska?

**Julcio** · 8 Stycznia 2012

Tak aplikacja autorska, ale baza jest, tylko zauważyłem, że w bazie jest np.

pole "GS", a tutaj w logach pisze

"Unknown column 'u.gs' in 'field list'"

**Amfidiusz** · 8 Stycznia 2012

Tak aplikacja autorska

Pozostaje Ci więc czekanie na któregoś z koderów oraz przeniesienie tematu do Zaawansowanego programowania IPB. Chociaż nie liczyłbym na to, że spędzą kilka godzin na debugowanie tej aplikacji w ramach dobrej zabawy

**Julcio** · 8 Stycznia 2012

A jak np. mam onlinePlayers.php

<?php 
class public_hrp_online_onlinePlayers extends ipsCommand
{
public function doExecute( ipsRegistry $registry ) 
{
$onlineList1 = array();
$onlineList2 = array();


$this->DB->query('SELECT p.nick,o.time,u.member_id,u.member_group_id,u.members_seo_name,u.members_display_name,u.gs,u.hpr FROM hrp_online o,hrp_players p, '.$this->DB->obj['sql_tbl_prefix'].'members u WHERE o.uid=p.player_uid and p.owner=u.member_id ORDER BY p.nick');
$this->DB->execute();

while( $r = $this->DB->fetch() )
{
$i++;

$r['_time'] = $this->registry->getClass('class_localization')->getDate( $r['time'], 'TINY', 0, 1 );
$r['_premium'] = HRPLib::isPremium($r);

$onlineList[] = $r;
}

$template = $this->registry->output->getTemplate('hrp')->onlinePlayers($onlineList,count($onlineList));

$this->registry->getClass('output')->addContent($template);
$this->registry->output->setTitle('Gracze online');
$this->registry->output->addNavigation( 'Gracze online', 'app=hrp&module=online' );
$this->registry->getClass('output')->sendOutput();
}
}
?>

A struktura bazy hrp_players i hrp_online taką:

hrp_players:

--
-- Struktura tabeli dla  `hrp_players`
--

CREATE TABLE IF NOT EXISTS `hrp_players` (
 `player_uid` int(11) NOT NULL auto_increment,
 `nick` varchar(20) collate utf8_polish_ci NOT NULL,
 `blockacc` int(10) unsigned NOT NULL default '0',
 `aj` smallint(5) unsigned NOT NULL default '0',
 `bw` tinyint(3) unsigned NOT NULL default '0',
 `skin` smallint(3) unsigned NOT NULL default '0',
 `lskin` smallint(5) unsigned NOT NULL default '0',
 `seen` int(10) unsigned NOT NULL default '0',
 `sex` tinyint(1) unsigned NOT NULL default '0',
 `age` tinyint(2) unsigned NOT NULL default '18',
 `pdp` smallint(3) unsigned NOT NULL default '0',
 `prtime` int(5) unsigned NOT NULL default '0',
 `prcell` tinyint(3) unsigned NOT NULL default '0',
 `cash` int(11) NOT NULL default '0',
 `cashinbank` int(11) NOT NULL default '0',
 `lpc` tinyint(1) unsigned NOT NULL default '0',
 `lpx` float NOT NULL default '0',
 `lpy` float NOT NULL default '0',
 `lpz` float NOT NULL default '0',
 `lpa` float NOT NULL default '0',
 `lpd` smallint(5) unsigned NOT NULL default '0',
 `phonenr` mediumint(6) unsigned NOT NULL default '0',
 `phonet` smallint(5) unsigned NOT NULL default '0',
 `playedhours` mediumint(8) unsigned NOT NULL default '0',
 `ban` int(10) unsigned NOT NULL default '0',
 `toggles` varchar(24) collate utf8_polish_ci NOT NULL default '-',
 `tog` tinyint(3) unsigned NOT NULL default '0',
 `hp` float unsigned NOT NULL default '100',
 `owner` mediumint(8) unsigned NOT NULL default '0',
 `blocks` tinyint(3) unsigned NOT NULL default '0',
 `force` smallint(5) unsigned NOT NULL default '3000',
 `defv` mediumint(8) unsigned NOT NULL default '0',
 `work` tinyint(3) unsigned NOT NULL default '0',
 `workt` int(10) unsigned NOT NULL default '0',
 `cstate` tinyint(3) unsigned NOT NULL default '0',
 `drunk` smallint(5) unsigned NOT NULL default '0',
 `obj` tinyint(3) unsigned NOT NULL default '0',
 `achiev` int(10) unsigned NOT NULL default '0',
 `fs` tinyint(3) unsigned NOT NULL default '0',
 `fss` tinyint(4) NOT NULL default '0',
 `fst` int(10) unsigned NOT NULL default '0',
 `chat` tinyint(4) NOT NULL default '1',
 `anim` tinyint(3) unsigned NOT NULL default '0',
 `hotel` mediumint(8) unsigned NOT NULL default '0',
 PRIMARY KEY  (`player_uid`),
 UNIQUE KEY `nick` (`nick`),
 KEY `owner` (`owner`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=30127 ;

hrp_online:

--
-- Struktura tabeli dla  `hrp_online`
--

CREATE TABLE IF NOT EXISTS `hrp_online` (
 `uid` mediumint(10) unsigned NOT NULL,
 `time` int(10) unsigned NOT NULL,
 UNIQUE KEY `online_uid` (`uid`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

To w takim razie gdzie jest błąd?

DawPi · 8 Stycznia 2012

Ty wiesz o czym piszesz i masz sprawdzić? Wywala, że brak tabeli w bazie, więc ją dodaj - widzę, że dostęp do struktury bazy i tabel masz, więc nie widzę problemu naprawić ten błąd. Jeśli koder tej autorskiej aplikacji zrobił to jak trzeba to powinieneś mieć również możliwość naprawienia tego z poziomu ACP:

ACP Zaawansowane Diagnostyka :a: Baza danych

**Julcio** · 8 Stycznia 2012

Ale wygląda na to, że tabele są, podałem strukturę i treść jednego pliku i tam jest pole gs, nick etc.

A w diagnostyce nie ma tego :/

DawPi · 8 Stycznia 2012

No to jakiś inny jest błąd.. Niech autor sprawdzi kod skoro wypluwa takie błędy mimo tego, że nie powinny się pojawiać. Co my tu możemy, jak nie ma wglądu do kodu tej aplikacji. Jak chcesz to wrzuć to do giełdy jeśli nie masz kontaktu z autorem czy coś..

**Julcio** · 8 Stycznia 2012

DawPi, a jak dałbym Ci wgląd do kodu? ;d

DawPi · 8 Stycznia 2012

No i wtedy co? Myślę, że stawka za jedną godzinę powinna to pokryć. Jesteś gotowy zapłacić za mój prywatny czas oraz wiedzę?

**Julcio** · 8 Stycznia 2012

Jestem w stanie, a ile kosztuje godzina Twojego czasu i wiedzy?

**Julcio** · 10 Stycznia 2012

A jednak nie dopatrzyłem i brakowało pól w tabeli members od IP.Board,

Ale teraz po porobieniu pól kolejny problem, mianowicie:

Warning: Invalid argument supplied for foreach() in /home/julcio/public_html/forum/admin/sources/base/core.php on line 5350


Fatal error: Call to a member function onlinePlayers() on a non-object in
/home/julcio/public_html/forum/admin/applications_addon/other/hrp/modules_public/online/onlinePlayers.php on line 23

Linijka 23 w onlinePlayers.php:

$template = $this->registry->output->getTemplate('hrp')->onlinePlayers($onlineList,count($onlineList));

Edytowane 10 Stycznia 2012 przez Julcio

DawPi · 10 Stycznia 2012

Brak bitów w skinie. W grupie 'hrp' brak onlinePlayers.

**Julcio** · 10 Stycznia 2012

No to d*pa... Bo nie ma w ogóle grupy 'hrp' w skinie...

DawPi, ile chciałbyś za przerobienie tej aplikacji pod IPB 3.2.3, bo jest pod 3.0.4 i debugowanie jej?

Edytowane 10 Stycznia 2012 przez Julcio

DawPi · 10 Stycznia 2012

Takie zapytania składaj proszę nie na forum, a na stronie http://support.ipslink.pl - dzięki!

**Julcio** · 10 Stycznia 2012

Proszę zamknąć temat, zgłosiłem się do IPSLink.

DawPi · 10 Stycznia 2012

Problem ROZWIĄZANY. Jeśli są jakiekolwiek wątpliwości, pytania proszę o założenie nowego tematu.

Wszelkie uzasadnione reklamacje/pretensje/sugestie/rady przyjmuje ekipa forum.

ROZWIĄZANY: Pomoc z aplikacją

Rekomendowane odpowiedzi

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Odnośnik do komentarza

Udostępnij na innych stronach

Ostatnio przeglądający 0 użytkowników

Powiadomienie o plikach cookie