->first() w pętli

[X3nO]

Witam, mam problem "No message", kompletnie nie wiem dlaczego nie działa:

Cytuj

UnderflowException thrown with message ""

Stacktrace:
#7 UnderflowException in /home/x3no/domains/x3no.pl/public_html/works/ips/system/Db/Select.php:333
#6 IPS\Db\_Select:first in /home/x3no/domains/x3no.pl/public_html/works/ips/applications/amxpanel/modules/front/main/index.php:131
#5 IPS\amxpanel\modules\front\main\_index:_addappelations in /home/x3no/domains/x3no.pl/public_html/works/ips/applications/amxpanel/modules/front/main/index.php:35
#4 call_user_func in /home/x3no/domains/x3no.pl/public_html/works/ips/applications/amxpanel/modules/front/main/index.php:35
#3 IPS\amxpanel\modules\front\main\_index:manage in /home/x3no/domains/x3no.pl/public_html/works/ips/system/Dispatcher/Controller.php:96
#2 IPS\Dispatcher\_Controller:execute in /home/x3no/domains/x3no.pl/public_html/works/ips/applications/amxpanel/modules/front/main/index.php:16
#1 IPS\amxpanel\modules\front\main\_index:execute in /home/x3no/domains/x3no.pl/public_html/works/ips/system/Dispatcher/Dispatcher.php:129
#0 IPS\_Dispatcher:run in /home/x3no/domains/x3no.pl/public_html/works/ips/index.php:13

Mój kod:

			foreach (\IPS\Db::i( 'amx_db' )->select('*', 'amx_bans', array('expired=?', 0), 'ban_created DESC') as $ban) {
				$ban['ips'] = \IPS\Db::i()->select( '*', 'amxpanel_appelations', array('bid=?', $ban['bid']))->first();

            	if ($ban['ban_length'] == 0) {
					$ban['time'] = 'Permanent';
				} elseif ($ban['ban_length'] == -1) {
					$ban['time'] = 'Permanent';
				} elseif ($ban['ban_length'] > 59) {
					$ban['__ban_length'] = floor($ban['ban_length'] / 60);
					$ban['time'] = ''.$ban['__ban_length'].' godzin';
					if ($ban['__ban_length'] == 168) {
						$ban['time'] = 'tydzień';
					}
				} else {
					$ban['time'] = $ban['ban_length'].' minut';
				}

				$ban['ban_created'] = gmdate("d.m.Y, H:i:s", $ban['ban_created']);

				if (empty($ban['ban_reason'])) {
					$ban['ban_reason'] = 'Brak informacji';
				}

				$bans[] = $ban;
			}

Zwracam się do Was o pomoc :/

[Macsch15]

Zapytanie bez first() wykonuje się poprawnie?

[DawPi]

Przede wszystkim to nie ma sensu tego rozbijać na dwa zapytania. Dodaj join z tą drugą tabelą i będzie OK.