Official Dragon's Dogma Pawn Sharing Club

0 and m.user_level <> 'X' and p.activity_status='A' "; $sql = $sql . " left join pawn_tag t on t.pawn_id = p.pawn_id and t.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; ?>

	  
GameFAQs Name | 
PSN Name | 
Pawn Name | 
Gender | 
Activity | 
Vocation | 
Level | 
Needs | 
Description / Additional Information | 
Date Added | 
Last Updated



   ";
		$counter = $counter + 1;
	}
endif; ?>