Changeset 307 for minimanager/mail.php
- Timestamp:
- Mar 13, 2008, 8:18:42 PM (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
minimanager/mail.php
r304 r307 211 211 212 212 if($to){ //single Recipient 213 $result = $sql->query("SELECT guid FROM `character ` WHERE name ='$to'");213 $result = $sql->query("SELECT guid FROM `characters` WHERE name ='$to'"); 214 214 if ($sql->num_rows($result) == 1) { 215 215 $receiver = $sql->result($result, 0, 'guid'); 216 216 217 $result = $sql->query("SELECT guid FROM `character ` WHERE name ='$user_name'");217 $result = $sql->query("SELECT guid FROM `characters` WHERE name ='$user_name'"); 218 218 219 219 $sender = 0; … … 240 240 $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']); 241 241 while($acc = $sql->fetch_row($result)){ 242 $result_2 = $sql->query("SELECT guid FROM `character ` WHERE account = '$acc[0]'");242 $result_2 = $sql->query("SELECT guid FROM `characters` WHERE account = '$acc[0]'"); 243 243 while($char = $sql->fetch_row($result_2)) array_push($char_array, $char[0]); 244 244 } … … 247 247 case "online": 248 248 $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']); 249 $result = $sql->query("SELECT guid FROM `character ` WHERE online $group_sign '$group_value'");249 $result = $sql->query("SELECT guid FROM `characters` WHERE online $group_sign '$group_value'"); 250 250 while($user = $sql->fetch_row($result)) array_push($char_array, $user[0]); 251 251 break; … … 253 253 case "char_level": 254 254 $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']); 255 $result = $sql->query("SELECT guid FROM `character ` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) $group_sign '$group_value'");255 $result = $sql->query("SELECT guid FROM `characters` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) $group_sign '$group_value'"); 256 256 while($user = $sql->fetch_row($result)) array_push($char_array, $user[0]); 257 257 break;
Note:
See TracChangeset
for help on using the changeset viewer.