- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
$SQL = "SELECT rq.*, c.login, r.name as raceName,
IF(rq.status = 1, '<span style=\'color:green\'>".$this->kernel->msg->get('raceRequest.status.done')."</span>',
IF(rq.status = -1, '<span style=\'color:red\'>".$this->kernel->msg->get('raceRequest.status.cancel')."</span>',
'".$this->kernel->msg->get('raceRequest.status.request')."')) as statusMsg,
IF(rq.currentLevel = 1, '<span style=\'color:#eeb300\'>".$this->kernel->msg->get('raceRequest.level.gold')."</span>',
IF(rq.currentLevel = 2, '<span style=\'color:#c6cccd\'>".$this->kernel->msg->get('raceRequest.level.silver')."</span>',
'<span style=\'color:#d58b72\'>".$this->kernel->msg->get('raceRequest.level.bronzet')."</span>')) as currentLevelMsg,
IF(rq.requestLevel = 1, '<span style=\'color:#eeb300\'>".$this->kernel->msg->get('raceRequest.level.gold')."</span>',
IF(rq.requestLevel = 2, '<span style=\'color:#c6cccd\'>".$this->kernel->msg->get('raceRequest.level.silver')."</span>',
'<span style=\'color:#d58b72\'>".$this->kernel->msg->get('raceRequest.level.bronzet')."</span>')) as requestLevelMsg
FROM raceRequests rq
LEFT JOIN customers c ON c.ID = rq.customerID
LEFT JOIN races r ON r.ID = rq.raceID
WHERE rq.ID = '%ID'";
blaster999 01.06.2010 22:54 # 0
Webkill 01.06.2010 22:55 # −1
blaster999 01.06.2010 23:04 # 0
guest 02.06.2010 03:19 # +6
guest 02.06.2010 03:18 # +1
заметно
Webkill 01.06.2010 22:57 # 0
Aryan, Nigger, Rags, Cross-Eyed?
guest 02.06.2010 02:56 # +6
blaster999 02.06.2010 10:15 # 0
striker 02.06.2010 03:27 # 0
telnet 02.06.2010 07:59 # +1
striker 02.06.2010 08:33 # +1
guest 02.06.2010 09:17 # −2
guest6 12.06.2023 14:38 # 0
striker 02.06.2010 13:46 # +2
в личных настройках ищите
Din 02.06.2010 13:49 # +1
striker 02.06.2010 13:53 # 0
guest 02.06.2010 13:58 # −1
telnet 02.06.2010 14:05 # +1
This is obvious 02.06.2010 14:12 # 0
Din 02.06.2010 13:50 # 0
wwwguru 02.06.2010 07:12 # 0
Error Loading Kernel. You Must Reinstall PHP.
guest 02.06.2010 10:19 # +5
Задача программиста - написать такой запрос, что его резалт-сет как раз и представит нужный HTML! Это будет истинное дао!
Din 02.06.2010 13:47 # 0
guest 02.06.2010 20:37 # 0
mrbig66 02.06.2010 22:45 # 0
guest 03.06.2010 04:00 # +3
INSERT INTO registers (ax) values (...)
INSERT INTO ineterrups (interrupt) values (...)
INSERT INTO ioports (ioport) values (....)
guest 03.06.2010 09:56 # 0
Хаскелем! Хаскелем!
guest 03.06.2010 15:01 # −2
Lure Of Chaos 03.06.2010 18:42 # 0
guest 04.06.2010 09:08 # 0
This is obvious 04.06.2010 12:59 # 0
guest 05.06.2010 03:51 # −1