Castle Control Script

[trellos]

I have the same issue regarding downloading the file. Could you please upload again the file ?



Thank you

[DareStrike]

Code: Select all

 <?php //---------------// Made by Daedalus email : daedalus at hotmail dot fr//--------------- $db_serv = 'x';         //the address of the database goes here $db_user = 'x';             //your sql username goes here$db_pass = 'x';                 //your sql password goes here $db_name = 'l2jgs';             //your database name goes here $filename = './helios.js';      //generated javascript file you need to put attribute 777 in your folder 

this problem :S

Code: Select all

 $filename = './helios.js';      //generated javascript file you need to put attribute 777 in your folder$filename = '7777./helios.js';      //generated javascript file you need to put attribute 777 in your folder 

[darknessneo]

hello,
i added this features for my website, but i needed to edit a little the generator:

here is my patch

Code: Select all

   $req =  @mysql_query("SELECT `name`, `seed_price` FROM `etcitem`, `castle_manor_production` WHERE `seed_id` = `item_id` AND `castle_id` = '$castle[id]' UNION (SELECT `name`, `c`.`price` FROM `etcitem` e, `castle_manor_procure` c WHERE `crop_id` = `item_id` AND `castle_id` = '$castle[id]') ORDER BY `name`");     $i = 1;    while ($row = mysql_fetch_array($req, MYSQL_NUM)) {        $gen .= '<tr>';        $gen .= '<td style="background-color: #'.( ($i % 2) ? 'EEE' : 'DDD' ).'">'.$row[0].'</td>';        $gen .= '<td style="background-color: #'.( ($i % 2) ? 'EEE' : 'DDD' ).'">'.$row[1].'</td>';        $gen .= '</tr>';        $i++;    }

what i edited?

'$castle[id]' in the sql request.

without this edit, i eat a Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given.....

Oh, and, ofc, i needed to reput the table etcitem in the database with a old backup, cuz now, l2jserver use xml.

[Eray]

thanks.

[VeNoML2]

so i have 1 problem

i have my server on my PC and if i make this script on my pc with Xampp work fine
and if i add script on website host say this "Coudn't connect to host"


anyone can help me pls

[VeNoML2]

someone?

[gmakhs]

you have to give remote acces on your database

[busta]

Does any php guru know why the script doesnt rewrite the helios.js again, after the sieges timestamp change in mysql table castle on column siegeDate ?
For example I have this problem:
the generator writen once the siege date and time first time, but after the time expire, it didnt rewrite with the new timestamp for the next siege. I think it doesnt check MySQL anymore.
2 castles which has not been sieged Gludio and Schuttgart get new timestamp same as all the rest in MySQL, but in the website I still see them with the same old date Feb 9, all others are Feb 23. All others were Feb 23 before too, only Gludio and Schuttgart were on Feb 9 for siege. Why is this happening?

[xban1x]

Post the code that was "supposed to rewrite helios.js"

[busta]

This is the script I use:

Code: Select all

<?php //---------------// Made by Daedalus email : daedalus at hotmail dot fr//--------------- $db_serv = '****';          //the address of the database goes here $db_user = 'root';              //your sql username goes here$db_pass = '****';              //your sql password goes here $db_name = 'l2jgs';             //your database name goes here $filename = './gen/helios.js';          //generated javascript file you need to put attribute 777 in your folder //----------------------------------------------------------------------------------------------- mysql_connect ( $db_serv, $db_user, $db_pass ) or die ('Coudn\'t connect to host');mysql_select_db( $db_name ) or die ('Couldn\'t select database'); $sql = mysql_query('SELECT id,name,taxPercent,siegeDate FROM `castle`') or die('Query failed!'); $gen = "\n"; while ($castle = mysql_fetch_array($sql)){    $gen .= "\n".strtolower($castle['name']) . 'info = \'<div class="castleWrapper">';    $gen .= '<div class="castlePic" id="' . ucfirst(strtolower($castle['name'])) . 'Pic"></div>';    $gen .= '<div class="castleInfo">';    $gen .= '<div class="castleName"><strong>' . ucfirst(strtolower($castle['name'])) . ' Castle</strong></div>';        $clan = mysql_fetch_array(mysql_query('SELECT clan_name,hasCastle FROM `clan_data` WHERE hasCastle = ' . $castle['id']));    $clan_name = (isset($clan['clan_name'])) ? htmlspecialchars($clan['clan_name'], ENT_QUOTES) : '<font color="22FF22">Unclaimed</font>';        $gen .= '<div><strong>Controlled by:</strong> ' . $clan_name . '</div>';        if (isset($clan['clan_name'])) $gen .= '<div><strong>Tax Rate:</strong> ' . $castle['taxPercent'] . '%</div>';        $gen .= '<div><strong>Next Siege:</strong> ' . date('M d Y ',$castle['siegeDate']/1000) . '</div>';    $gen .= '</div></div>\';'."\n\n";} $handle = fopen($filename, 'w+');fwrite($handle, $gen);fclose($handle); ?>

I believe the last 3 rows do the rewrite, but it seems that somehow they dont rewrite it.

Code: Select all

$handle = fopen($filename, 'w+');fwrite($handle, $gen);fclose($handle);

./gen/ is the location of generator.php and helios.js in my site.

P.S. I try to make a cronjob on 1 hours for this castle manager, but I cant really make it work. Dont know how to setup it correctly.

[xban1x]

cron job on linux ?

Tell me which linux

[busta]

I cant see from the cPanel which version is Linux.
How to define the cronjob command so to be able to refresh the content of helios.js?

P.S. Nevermind, I figured it out and it works.

Now I will explain where I was wrong.
First I have put a path for $filename which was wrong. My folder containing generator.php and helios.js is /gen just like I mention. So inside $filename must be writen this:

Code: Select all

$filename = 'helios.js';

Second and very important just like deadalus said, you must put attribute to helios.js, but the attribute must be 755. You dont need to make it 777. This can be done by clicking in your cPannel on file helios.js and clicking the key icon "Change Permissions", or by right mouse click and again "Change Permissions". After this operation it will be opened a new window with many boxes:

Click on them so in row Permissions to be 755.
Now on the question how to automate the castle script, so to have regular update.
Go into your cPannel and find the Cronjob button. Its usually near MIME Types or Index Manager. Click on it. Sellect on what interval of time you wish the script generator.php to update helios.js. This can be made on Add New Cron Job table. Its enought to choose from Common Settings: sub-menu "Once an hour(0****)"
This choice will run the script and update it on every hour.
After that go to Command: field and write this for a php file(which generator.php is):

Code: Select all

php /home/[user name]/public_html/gen/generator.php

This is it!
Further more, the webhost will send to your main email of your site mail for each cronjob which has been done. If you dont want it to spam your mail simply add this after the command you previously put: >/dev/null 2>&1
It should look like this:

Code: Select all

php /home/[user name]/public_html/gen/generator.php >/dev/null 2>&1

And there will be no more mails. Dont worry, cronjob will continue to run, this disable only the email notification.
If you wish to stop this cronjob you must delete it from the Cronjob manager.
I hope this little guide will help to someone!

[KaTSiKa]

seems like a quite usefull thing. i will sure take a look

[OrcBubba]

Hi guys. I am getting this error:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in generator.php on line 57

Any suggestions? Thanks

[jurchiks]

Means the query failed to execute and returned FALSE on mysql_query(), possibly a typo somewhere.
Also, mysql_* is deprecated, time to switch to mysqli/PDO.