Newbie Spellweaver
- Joined
- Dec 7, 2009
- Messages
- 73
- Reaction score
- 13
Folders - 777, scripts - 777, uploads - 775.
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!Failing SQL: SELECT COUNT(`id`) AS `exist`,`banned` FROM `zapping_worlds_m1`.`users` WHERE `id`='1'
Error: SELECT command denied to user 'a1395409_testmysql'@'10.1.1.36' for table 'users'
Any idea on how to fix this? I am hosting on 000webhost so I am using their MySQL database.
have the same problem
<?php
function msec(){
list($msec, $sec) = explode(' ', microtime());
return ($sec%3600)*1000+$msec*1000;
}
function gets_ms($a){
global $load_msec;
echo "$a: ".(msec()-$load_msec)."<br />";
}
$start = microtime(true);
set_time_limit(60);
for ($i = 0; $i < 59; ++$i) {
error_reporting(E_ALL ^ E_NOTICE);
$time = time();
$load_msec = msec();
define("PATH", str_replace(PATH_SEPARATOR, "/", dirname(dirname(__FILE__))));
require_once(PATH."/include/config.php");
require_once(PATH."/lib/functions.php");
require_once(PATH."/lib/DB_MySQL.php");
$db = new DB_MySQL();
$db->connect($config['db_host'], $config['db_user'], $config['db_pw'], $config['db_name']);
if($time+5 < time()){
exit("Sem resposta do MySQL! Verifique a conexao!");
}
require_once(PATH."/lib/GetVillageData.php");
require_once(PATH."/lib/GetUserData.php");
require_once(PATH."/lib/login.php");
require_once(PATH."/lib/sid.php");
require_once(PATH."/lib/map.php");
require_once(PATH."/lib/builds.php");
require_once(PATH."/lib/units.php");
require_once(PATH."/lib/techs.php");
require_once(PATH."/lib/add_report.php");
require_once(PATH."/lib/do_action.php");
require_once(PATH."/lib/awards.php");
require_once(PATH."/lib/train.php");
require_once(PATH."/lib/events.php");
require_once(PATH."/lib/knight_items.php");
require_once(PATH."/include/configs/buildings.php");
require_once(PATH."/include/configs/raw_material_production.php");
require_once(PATH."/include/configs/farm_limits.php");
require_once(PATH."/include/configs/max_storage.php");
require_once(PATH."/include/configs/max_hide.php");
require_once(PATH."/include/configs/units.php");
require_once(PATH."/include/configs/techs.php");
require_once(PATH."/include/configs/max_wall_bonus.php");
require_once(PATH."/include/configs/dealers.php");
require_once(PATH."/include/configs/awards.php");
require_once(PATH."/include/configs/knight_items.php");
$run_key = generate_key();
$cl_reports = new add_report();
print("Os eventos estao funcionando... Nao feche esta janela pois aqui a magica de servidor acontece =D");
// for($i = 0; $i < (2 << 15); ++$i){
// $last = time();
check_events();
check();
// if($last == time()){
// sleep(1);
// }
// }
time_sleep_until($start + $i + 1);
}
?>
In your database there is a table called: Config, change it to your data ;-)
About the cronjob thing, i got a fix for that.
Replace the whole event.php with this:
PHP:<?php function msec(){ list($msec, $sec) = explode(' ', microtime()); return ($sec%3600)*1000+$msec*1000; } function gets_ms($a){ global $load_msec; echo "$a: ".(msec()-$load_msec)."<br />"; } $start = microtime(true); set_time_limit(60); for ($i = 0; $i < 59; ++$i) { error_reporting(E_ALL ^ E_NOTICE); $time = time(); $load_msec = msec(); define("PATH", str_replace(PATH_SEPARATOR, "/", dirname(dirname(__FILE__)))); require_once(PATH."/include/config.php"); require_once(PATH."/lib/functions.php"); require_once(PATH."/lib/DB_MySQL.php"); $db = new DB_MySQL(); $db->connect($config['db_host'], $config['db_user'], $config['db_pw'], $config['db_name']); if($time+5 < time()){ exit("Sem resposta do MySQL! Verifique a conexao!"); } require_once(PATH."/lib/GetVillageData.php"); require_once(PATH."/lib/GetUserData.php"); require_once(PATH."/lib/login.php"); require_once(PATH."/lib/sid.php"); require_once(PATH."/lib/map.php"); require_once(PATH."/lib/builds.php"); require_once(PATH."/lib/units.php"); require_once(PATH."/lib/techs.php"); require_once(PATH."/lib/add_report.php"); require_once(PATH."/lib/do_action.php"); require_once(PATH."/lib/awards.php"); require_once(PATH."/lib/train.php"); require_once(PATH."/lib/events.php"); require_once(PATH."/lib/knight_items.php"); require_once(PATH."/include/configs/buildings.php"); require_once(PATH."/include/configs/raw_material_production.php"); require_once(PATH."/include/configs/farm_limits.php"); require_once(PATH."/include/configs/max_storage.php"); require_once(PATH."/include/configs/max_hide.php"); require_once(PATH."/include/configs/units.php"); require_once(PATH."/include/configs/techs.php"); require_once(PATH."/include/configs/max_wall_bonus.php"); require_once(PATH."/include/configs/dealers.php"); require_once(PATH."/include/configs/awards.php"); require_once(PATH."/include/configs/knight_items.php"); $run_key = generate_key(); $cl_reports = new add_report(); print("Os eventos estao funcionando... Nao feche esta janela pois aqui a magica de servidor acontece =D"); // for($i = 0; $i < (2 << 15); ++$i){ // $last = time(); check_events(); check(); // if($last == time()){ // sleep(1); // } // } time_sleep_until($start + $i + 1); } ?>
In your database there is a table called: Config, change it to your data ;-)