• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[G****r AAC] QuestStatus wroted by Averatec optimized by Victor (1.1.2)

Victor

New Member
Joined
Feb 1, 2008
Messages
222
Reaction score
1
Hi! I optimized Averatec script. Averatec gived this script version 1.1 and I gived version 2 - now it's 1.1.2 :).

Screenie:


Code:
PHP:
/*
 * Quest Status was wroted by Averatec from otland.net and recoded (optimized) by Victor.
 * For help ask at otland.net thread.
 * You can also read blog of Victor at victor.org.pl.
 * Thank you for use it and regarding license.
 */

$quests = array(100 => "Annihilator", 5050 => "Pits of Inferno", 2645 => "Demon Helmet Quest", 42361 => "Svargrond Arena Greenhorn", 42371 => "Svargrond Arena Scrapper", 42381 => "Svargrond Arena Warlord", 2415 => "Warlock Quest", 8883 => "Fury Quest", 8891 => "Barbarian Quest", 8887 => "Ice Witch Quest", 8858 => "Frost Dragon Quest I", 7429 => "Frost Dragon Quest II", 8903 => "Wyrm Quest", 2498 => "Black Knight Quest", 2407 => "Hero Quest", 2476 => "Orc Fortress Quest");

$main_content .= '<br />
    <table border="0" cellspacing="1" cellpadding="4" width="100%">
        <tr bgcolor="'.$config['site']['vdarkborder'].'">
            <td colspan="3" class="white">
                <b>Quests Information</b>
            </td>
        </tr>';
$i = 0;

if ($i % 2 == 1) { 
    $bgcolor = $config['site']['darkborder']; 
} 
else { 
    $bgcolor = $config['site']['lightborder']; 
}
    
$main_content .= '
        <tr bgcolor="'.$bgcolor.'">
            <td width="5%" style="text-align: center;"><b>Id.</b></td>
            <td width="87%"><b>Quest</b></td>
            <td width="8%"><b><center>Status</center></b></td>
        </tr>';

$i++;

foreach ($quests as $sid => $name){
    if ($i % 2 == 1) { 
        $bgcolor = $config['site']['darkborder']; 
    } 
    else { 
        $bgcolor = $config['site']['lightborder']; 
    }

    if ($player->getStorage($sid) == 1) {
        $main_content .= '
        <tr bgcolor="'.$bgcolor.'">
            <td width="5%" style="text-align: center;">'.$i.'.</td>
            <td width="87%">'.$name.'</td>
            <td align="center" width="8%"><img src="images/queststatus/true.png" title="Done" /></td>
        </tr>';
    }
    else {
        $main_content .= '
        <tr bgcolor="'.$bgcolor.'">
            <td width="5%" style="text-align: center;">'.$i.'.</td>
            <td width="87%">'.$name.'</td>
            <td align="center" width="8%"><img src="images/queststatus/false.png" title="Not done" /></td>
        </tr>';
    }
        
    $i++;

}
$main_content .= "</table>";

Folder queststatus paste into images/:
QUESTSTATUS.RAR - OdSiebie.com

Syntax version of script:
NoPASTE

Instalation:
Add code above
//deaths list

Thanks Averatec for wrote first version of script.

Thankzzz for using,
Victor
 
ah, its still makes 16x queries (In your screen example)

Optimize so it will just retrieve all these storages in 1 query.
 
Noob. wtf?
PHP:
if ($i % 2 == 1) {
    $bgcolor = $config['site']['darkborder'];
}
else {
    $bgcolor = $config['site']['lightborder'];
}
PHP:
$bgcolor = ($i % 2) ? $config['site']['darkborder'] : $config['site']['lightborder'];
 
Noob. wtf?
PHP:
if ($i % 2 == 1) {
    $bgcolor = $config['site']['darkborder'];
}
else {
    $bgcolor = $config['site']['lightborder'];
}
PHP:
$bgcolor = ($i % 2) ? $config['site']['darkborder'] : $config['site']['lightborder'];

What's the f*****g difference?!

It does the same sh** and Victor's one is more 'user-friendly' much more easier to read.
 
It's ready-to-use query.
Code:
$query = 'SELECT `value` FROM `player_storage` WHERE `player_id` = '.$player->getId().' AND';
foreach ($quests as $id => $name) {
    $query .=' `key` = '.$id.' OR';
}
$query =substr($query, 0,-2);
$query .= ';';
 
#Up
Dude. King, describe me your's code! I don't know, why your small drain can write big part of scripts. EVUL!

At real: dont f*ck up. This expression (something : true ? false) is noot good when you must return string in the echo. Yeah - I should optimize it to yours version, but I didn't do it.

And for my god i write:
Sorry Pitrusiu (it's optimize version of Piotrek) for my english!
 
Noob. wtf?
PHP:
if ($i % 2 == 1) {
    $bgcolor = $config['site']['darkborder'];
}
else {
    $bgcolor = $config['site']['lightborder'];
}
PHP:
$bgcolor = ($i % 2) ? $config['site']['darkborder'] : $config['site']['lightborder'];
Noob wtf? x2!

PHP:
.table-striped {
    background-color: #F1E0C6;
}
.table-striped thead>tr>th {
    color: #fff;
    font-weight: bold;
    background: #212121;
}
.table-striped tbody tr:nth-of-type(odd) {
    background-color: #d4c0a1;
}

PHP:
<table class="table-striped" width="500px">
  <thead>
    <tr>
      <th>Name</th>
      <th>Level</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>John</td>
      <td>153</td>
    </tr>
    <tr>
      <td>Alice</td>
      <td>73</td>
    </tr>
    <tr>
      <td>Robert</td>
      <td>302</td>
    </tr>
    <tr>
      <td>Bob</td>
      <td>122</td>
    </tr>
  </tbody>
</table>

And here you have pen to see how it looks.
 
Back
Top