uazxPkt8

1<?php
2
3require 'config.php'; // Settings
4
5// Establish connection
6$link = mysql_connect($_sql_host, $_sql_user, $_sql_pass); 
7if (!$link) { 
8	die('Could not connect to MySQL: ' . mysql_error()); 
9} 
10// Connect to database
11mysql_select_db($_sql_db);
12
13$q = isset($_POST['monster']) ? $_POST['monster'] : null;
14
15$sql = "DROP VIEW IF EXISTS MONSTERS_VIEW";
16$res = mysql_query($sql) OR die(mysql_error());
17
18$sql = "CREATE VIEW MONSTERS_VIEW as SELECT * FROM `mob_db` UNION SELECT * FROM `mob_db2`";
19$res = mysql_query($sql) OR die(mysql_error());
20
21$sql   = "SELECT `kname` AS `name`, `id` FROM MONSTERS_VIEW ";
22$sql  .= "WHERE `kname` LIKE '$q%' OR `iname` LIKE '$q%' LIMIT 10";
23$res   = mysql_query($sql);
24$mobs =  array();
25
26while ($row = mysql_fetch_array($res)) {
27	$mobs[] = $row;
28}
29
30?>
31
32<?php if ($mobs): ?>
33	<table width="100%" cellspacing="0" cellpadding="0">
34	<?php foreach ($mobs as $mob): ?>
35		<!--<tr class="subs" onclick="location.href='<?php echo $_base_dir . "/monster/view/?id=" . $mob['id'] ?>'" onmouseover="loadqry('<?php echo $mob['name'] ?>', '<?php echo $mob['id'] ?>')">
36			<td align="right" style="color:#777;"><?php echo $mob['id'] ?></td>
37			<td><?php echo $mob['name'] ?></td>
38		</tr>-->
39		<tr class="subs" onclick="loadqry('<?php echo $mob['name'] ?>', '<?php echo $mob['id'] ?>', '<?php echo $_base_dir . "/monster/view/?id=" . $mob['id'] ?>'); ">
40			<!--<td align="right" style="color:#777;"><?php echo $mob['id'] ?></td>-->
41			<td><?php echo $mob['name'] ?></td>
42		</tr>
43	<?php endforeach ?>
44	</table>
45<?php else: ?>
46	no monster found
47<?php endif ?>