strlen($return)) $return .= $addEllipsis; return $return; } $sql = "select m.gfaq_name, m.activity_level, p.psn_name, p.pawn_name, p.pawn_vocation, p.pawn_level, p.inclination1, p.inclination2, p.pawn_description, p.other_information, p.creation_date"; $sql = $sql . ", p.last_update_date, t.tag_color, p.pawn_id, show_image_flag, internal_image_name, top_need, lurker_flag "; $sql = $sql . ", p.pawn_rank, m.motley_flag, DATEDIFF(CURDATE(),p.creation_date) pawn_age, p.gender, p.image_name, p.member_id, h.hire_tag_color, p.platform, p.steam_profile from pawn p inner join member m on p.member_id = m.member_id and m.activity_level > 0 and m.user_level <> 'X' and p.activity_status='A' "; if ( $platform_filter != null ) { $sql = $sql . " and p.platform = '" . $platform_filter . "' "; } $sql = $sql . " left join pawn_tag t on t.pawn_id = p.pawn_id and t.member_id = $login_id "; $sql = $sql . " left join hire_tag h on h.hire_pawn_id = p.pawn_id and h.hire_member_id = $login_id "; $sqlsort = " order by m.creation_date, m.member_id, p.pawn_id"; /* if ($sortby == "gfaqname"): $sqlsort = " order by m.gfaq_name " . $sortbydir . " ,p.pawn_id "; elseif ($sortby == "psnname"): $sqlsort = " order by p.psn_name " . $sortbydir; elseif ($sortby == "activity"): $sqlsort = " order by m.activity_level " . $sortbydir . " ,p.pawn_id" ; elseif ($sortby == "level"): $sqlsort = " order by CONVERT(p.pawn_level, SIGNED INTEGER) " . $sortbydir . " ,p.pawn_id"; elseif ($sortby == "created"): $sqlsort = " order by m.creation_date " . $sortbydir . ", m.member_id " . $sortbydir . ", p.pawn_id "; elseif ($sortby == "pawnname"): $sqlsort = " order by p.pawn_name " . $sortbydir; elseif ($sortby == "lastupdated"): $sqlsort = " order by p.last_update_date " . $sortbydir . " ,p.pawn_id" ; endif; */ $sql = $sql . $sqlsort; $result = mysqli_query($link, $sql ); endif; ?>

"; elseif ($row[12] != ""): $hiddencolor=$row[12]; $color = $row[12]; $tagged = "Yes"; echo "style='vertical-align: top; font-weight: normal; background-color: $color; color: black;'>"; else: // if ( $color=="#C0C0C0" ): // echo "class='evenrow'>"; // else: // echo "class='oddrow'>"; // endif; echo "style='vertical-align: top; font-weight: normal;'>"; endif; if ($login_id != 0): echo ""; echo ""; echo ""; $steam_profile = $row[26]; if ( $row[25] == "PC" && $steam_profile != "" ) { echo ""; } else { echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $counter = $counter + 1; } endif; ?>

 
Site Tools:

EXP / RC Calculator   Computer Formatted Club List   Admin Tools   Static Pawnlist