| 165 | | $res = DBQuery::queryRow("SELECT * FROM ".$database['prefix']."Teamblog |
| 166 | | WHERE teams='$owner' AND userid='$owner' " ); |
| 167 | | |
| 168 | | $name = array(4); |
| 169 | | $name[0] = ''; |
| 170 | | $name[1] = ''; |
| 171 | | $name[2] = 0; |
| 172 | | $name[3] = ''; |
| 173 | | |
| 174 | | $styleS = ''; |
| 175 | | $styleE = ''; |
| 176 | | if(!isset($_SESSION['admin'])) $_SESSION['admin'] = $owner; |
| 177 | | |
| 178 | | $ttmp = DBQuery::queryRow("SELECT * |
| 179 | | FROM ".$database['prefix']."Teamblog |
| 180 | | WHERE teams='".$owner."' |
| 181 | | and userid='".$_SESSION['admin']."'"); |
| 182 | | $stmp = DBQuery::queryRow("SELECT * |
| | 165 | // Read userId of entry from relation table. |
| | 166 | $userId = DBQuery::queryCell("SELECT team |
| 184 | | WHERE owner='".$owner."' |
| 185 | | and id='".$entry['id']."'"); |
| 186 | | $itmp = DBQuery::queryRow("SELECT a.*, b.name |
| 187 | | FROM {$database['prefix']}Teamblog a, |
| 188 | | {$database['prefix']}Users b |
| 189 | | WHERE a.teams='".$owner."' |
| 190 | | AND a.userid='".$stmp['team']."' |
| 191 | | AND a.userid=b.userid"); |
| 192 | | |
| 193 | | if(empty($font_style)){ |
| 194 | | if(empty($is_style)){ |
| 195 | | if(empty($is_admin)) $ures = $itmp; |
| 196 | | else $ures = $res; |
| 197 | | |
| 198 | | $font_bold = $ures['font_bold'] & 1; |
| 199 | | if(empty($font_bold)) $font_bold = ''; |
| 200 | | else $font_bold = 'bold'; |
| 201 | | |
| 202 | | $font_italic = $ures['font_bold'] & 2; |
| 203 | | if(empty($font_italic)) $font_italic = ''; |
| 204 | | else $font_italic = 'italic'; |
| 205 | | |
| 206 | | |
| 207 | | $styleS = '<font style="font-Weight:'.$font_bold.';font-Style:'.$font_italic.';font-Size:'.$ures['font_size'].'pt;color:'.$ures['font_color'].';">'; |
| 208 | | $styleE = '</font>'; |
| 209 | | } |
| 210 | | if(empty($is_ch)){ |
| 211 | | if(empty($isname)) $name[0] = ' by ' . $styleS . $itmp['name'] . $styleE; |
| 212 | | else $name[1] = ' by ' . $styleS . $itmp['name'] . $styleE; |
| 213 | | } else { |
| 214 | | $name[3] = $styleS . $itmp['name'] . $styleE; |
| 215 | | } |
| 216 | | } |
| 217 | | |
| 218 | | if(($ttmp['posting'] == 1) || ($stmp['team'] == $_SESSION['admin'])) $name[2] = 1; |
| 219 | | |
| 220 | | return $name; |
| 221 | | } |
| 222 | | |
| 223 | | function PC(){ |
| 224 | | global $database, $owner; |
| 225 | | $itmp = DBQuery::queryRow("SELECT * FROM ".$database['prefix']."Teamblog WHERE teams='".$owner."' and userid='".$_SESSION['admin']."'"); |
| 226 | | $access = 0; |
| 227 | | if(!empty($itmp['posting'])) $access = 1; |
| 228 | | return $access; |
| 229 | | } |
| 230 | | |
| 231 | | function AC(){ |
| 232 | | global $database, $owner; |
| 233 | | $itmp = DBQuery::queryRow("SELECT * FROM ".$database['prefix']."Teamblog WHERE teams='".$owner."' and userid='".$_SESSION['admin']."'"); |
| 234 | | $access = 0; |
| 235 | | if(!empty($itmp['admin'])) $access = 1; |
| 236 | | if(($itmp['userid'] == $itmp['teams']) && ($itmp['enduser'] !=0)) $access = 2; |
| 237 | | return $access; |
| 238 | | } |
| 239 | | |
| 240 | | function myBlog(){ |
| | 168 | WHERE owner =".$owner." |
| | 169 | AND id = ".$entryId); |
| | 170 | if(isset($userId)) { |
| | 171 | $author = DBQuery::queryCell("SELECT profile |
| | 172 | FROM {$database['prefix']}Teamblog |
| | 173 | WHERE teams=".$owner." |
| | 174 | AND userid = ".$userId); |
| | 175 | return $author; |
| | 176 | } else { |
| | 177 | return false; |
| | 178 | } |
| | 179 | } |
| | 180 | |
| | 181 | function myBlog(){ |
