Skip to content

[Help] from php to sql (i got files just need edit the php, Pauler? :D <3 here!)

Featured Replies

oly.php

<?php
include("Connection.php");

$FORM1 = "<table width=400 style=\"font-size:11px; font-family:verdana;\" cellspacing=\"0\" cellpadding=\"0\" align=center>
<tr>
<td width=100% height=34 colspan=4 align=center style=\"font-size:12px; font-family:verdana; color:#000000;\"><b>Duelist</b></td>
</tr>
<tr>
<td style=\"font-size:12px; border:1px #999999 solid;\"><center><b>Character Name</b></center></td>
<td style=\"font-size:12px; border:1px #999999 solid;\"><center><b>Points</b></center></td>
<td style=\"font-size:12px; border:1px #999999 solid;\"><center><b>Match</b></center></td>
</tr>";


$chr1 = mysql_query("SELECT olympiad_nobles.char_name,olympiad_nobles.olympiad_points,olympiad_nobles.competitions_done,olympiad_nobles.class_id,class_list.class_name,class_list.id
FROM class_list,olympiad_nobles
WHERE ((olympiad_nobles.competitions_done >=1) AND (class_list.id=88) AND (olympiad_nobles.class_id=88))
ORDER BY olympiad_nobles.olympiad_points DESC");

while($row1 = mysql_fetch_array($chr1))

{
   
$FORM1 .= '<tr valign=top>
    <td style=\"font-size:10px; font-family:verdana; color:#999999;\" class=content align=center valign=top>'.$row1['char_name'].'</td>
<td style=\"font-size:10px; font-family:verdana; color:#999999;\" class=content align=center valign=top>'.$row1['olympiad_points'].'</td>
<td style=\"font-size:10px; font-family:verdana; color:#999999;\" class=content align=center valign=top>'.$row1['competitions_done'].'</td>
  </tr>';

}

echo $FORM1;

?>

 

 

and sql

 

 
  `char_id` int(10) unsigned NOT NULL DEFAULT '0',
  `class_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `olympiad_points` int(10) NOT NULL DEFAULT '0',
  `competitions_done` smallint(3) NOT NULL DEFAULT '0',
  `competitions_won` smallint(3) NOT NULL DEFAULT '0',
  `competitions_lost` smallint(3) NOT NULL DEFAULT '0',
  `competitions_drawn` smallint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`char_id`)

 

the error :

 

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\Program Files (x86)\Ampps\www\Lineage 2 Olympous\iframe-oly.php on line 20

 

 

what i have to do?

what i had done!

changed the char_name to char_id and didn't worked :/

any suggestion?

i can give teamviewer if someone want to see it full :)

Add

or die(mysql_error());

into your code in order to get full explanation regarding the error you are getting from mysql

 

so replace your query with the following code

 

$chr1 = mysql_query("SELECT olympiad_nobles.char_name,olympiad_nobles.olympiad_points,olympiad_nobles.competitions_done,olympiad_nobles.class_id,class_list.class_name,class_list.id
FROM class_list,olympiad_nobles
WHERE ((olympiad_nobles.competitions_done >=1) AND (class_list.id=88) AND (olympiad_nobles.class_id=88))
ORDER BY olympiad_nobles.olympiad_points DESC") or die(mysql_error());

  • Author

Add

or die(mysql_error());

into your code in order to get full explanation regarding the error you are getting from mysql

 

so replace your query with the following code

 

$chr1 = mysql_query("SELECT olympiad_nobles.char_name,olympiad_nobles.olympiad_points,olympiad_nobles.competitions_done,olympiad_nobles.class_id,class_list.class_name,class_list.id
FROM class_list,olympiad_nobles
WHERE ((olympiad_nobles.competitions_done >=1) AND (class_list.id=88) AND (olympiad_nobles.class_id=88))
ORDER BY olympiad_nobles.olympiad_points DESC") or die(mysql_error());

 

thank you really much for your reply but i forgot to report my topic it was my fault on connection of mysql ;p

also about your code it say me Table 'acis.class_list' doesn't exist but it doesn't matter bcuz last night i fixed :)

 

Request to lock after fdLP reply (if he want :P)

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.