Cum conectez panelul cu serverul de samp?
Panelul merge pe host numai k nu il pot conecta cu serevrul
Asta am in config
<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'rayzenro_panel');
define('DB_PASSWORD', '');
define('DB_DATABASE', 'rayzenro_panel');
$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
$csfr = getToken(24);
date_default_timezone_set('Europe/Bucharest');
$author = "Bogdan";
$serverURL = "http://rayzen.ro/panel/";
$serverName = "Rayzen";
$result = $db->query("SELECT COUNT(*) FROM `users` WHERE Status='1'");
$online = $result->fetch_row();
$result1 = $db->query("SELECT COUNT(*) FROM `users`");
$accountCreated = $result1->fetch_row();
$result2 = $db->query("SELECT COUNT(*) FROM `houses`");
$houses = $result2->fetch_row();
$result3 = $db->query("SELECT COUNT(*) FROM `bizz`");
$bizz = $result3->fetch_row();
$result4 = $db->query("SELECT COUNT(*) FROM `users` WHERE Admin > 0");
$adminson = $result4->fetch_row();
$result5 = $db->query("SELECT COUNT(*) FROM `users` WHERE Helper > 0");
$helperson = $result5->fetch_row();
$result6 = $db->query("SELECT COUNT(*) FROM `users` WHERE Leader > 0");
$leaderson = $result6->fetch_row();
$result7 = $db->query("SELECT COUNT(*) FROM `factions`");
$factionsCount = $result7->fetch_row();
$result8 = $db->query("SELECT COUNT(*) FROM `faction_apply` WHERE Status='2'");
$factionsCount8 = $result8->fetch_row();
$result9 = $db->query("SELECT COUNT(*) FROM `faction_apply` WHERE Status='3'");
$factionsCount9 = $result9->fetch_row();
$result10 = $db->query("SELECT COUNT(*) FROM `faction_apply`");
$factionsCount10 = $result10->fetch_row();
$result13 = $db->query("SELECT COUNT(*) FROM `complaints`");
$factionsCount13 = $result13->fetch_row();
$result11 = $db->query("SELECT COUNT(*) FROM `complaints` WHERE status='0'");
$complaintscount = $result11->fetch_row();
$result12 = $db->query("SELECT COUNT(*) FROM `complaints` WHERE status='1'");
$factionsCount12 = $result12->fetch_row();
$result14 = $db->query("SELECT COUNT(*) FROM `tickets` WHERE Status='0'");
$ticketsactive = $result14->fetch_row();
$result15 = $db->query("SELECT COUNT(*) FROM `tickets`");
$totaltickets = $result15->fetch_row();
$result16 = $db->query("SELECT COUNT(*) FROM `tickets` WHERE Status='1'");
$ticketerezolvate = $result16->fetch_row();
$result17 = $db->query("SELECT COUNT(*) FROM `unban-panel` WHERE Now='0'");
$countdebanari = $result17->fetch_row();
function time_elapsed_string($datetime, $full = false) {
$now = new DateTime;
$ago = new DateTime($datetime);
$diff = $now->diff($ago);
$diff->w = floor($diff->d / 7);
$diff->d -= $diff->w * 7;
$string = array(
'y' => 'year',
'm' => 'month',
'w' => 'week',
'd' => 'day',
'h' => 'hour',
'i' => 'minute',
's' => 'second',
);
foreach ($string as $k => &$v) {
if ($diff->$k) {
$v = $diff->$k . ' ' . $v . ($diff->$k > 1 ? 's' : '');
} else {
unset($string[$k]);
}
}
if (!$full) $string = array_slice($string, 0, 1);
return $string ? implode(', ', $string) . ' ago' : 'just now';
}
function calculeazabani($numar) {
$numar1 = number_format($numar);
echo $numar1;
}
function get_faction($id, $c) {
global $db;
if($c == 0) { ?> Civilian <?php } else {
$result4 = $db->query("SELECT * from `factions` WHERE ID = ".$id."");
$factionName = $result4->fetch_assoc();
echo $factionName["Name"];
}
}
function get_job($id) {
if($id == 0) {
echo "N/A";
}else{
$url = "./json/jobs.json";
$data = file_get_contents($url);
$character = json_decode($data);
echo $character->{$id};
}
}
function crypto_rand_secure($min, $max)
{
$range = $max - $min;
if ($range < 1) return $min; // not so random...
$log = ceil(log($range, 2));
$bytes = (int) ($log / 8) + 1; // length in bytes
$bits = (int) $log + 1; // length in bits
$filter = (int) (1 << $bits) - 1; // set all lower bits to 1
do {
$rnd = hexdec(bin2hex(openssl_random_pseudo_bytes($bytes)));
$rnd = $rnd & $filter; // discard irrelevant bits
} while ($rnd > $range);
return $min + $rnd;
}
function getToken($length)
{
$token = "";
$codeAlphabet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
$codeAlphabet.= "abcdefghijklmnopqrstuvwxyz";
$codeAlphabet.= "0123456789";
$max = strlen($codeAlphabet); // edited
for ($i=0; $i < $length; $i++) {
$token .= $codeAlphabet[crypto_rand_secure(0, $max-1)];
}
return $token;
}
function get_faction_count_members($params) {
global $db;
$rezultat = $db->query("SELECT COUNT(*) FROM `users` WHERE Member='".$params."'");
$factionsCount = $rezultat->fetch_row();
echo $factionsCount[0];
}
function check_if_user_have_leader($params) {
global $db;
global $serverURL;
$rezultat = $db->query("SELECT Leader from `users` WHERE name='".$params."'");
$grad = $rezultat->fetch_assoc();
if($grad["Leader"] > 0) {
?>
<li><a class="" href="<?php echo $serverURL;?>leader.php?id=<?=$grad["Leader"]?>" aria-expanded="false">
<i class="mdi mdi-account-multiple"></i><span class="hide-menu">Leader Panel</span></a></li>
<?php
}
}
function check_if_user_have_acces_to_leader_panel($params) {
global $db;
$rezultat = $db->query("SELECT Leader from `users` WHERE name='".$params."'");
$grad = $rezultat->fetch_assoc();
if($grad["Leader"] == 0) {
go("/");
}
}
function check_if_user_is_leader_to_x_faction($params) {
global $db;
$rezultat = $db->query("SELECT Leader from `users` WHERE name='".$params."'");
$grad = $rezultat->fetch_assoc();
if($grad["Leader"] != mysqli_real_escape_string($db, $_GET['id'])) {
go("/");
die;
}
}
function check_if_user_is_leader_to_x_faction1($params, $params1) {
global $db;
$rezultat = $db->query("SELECT Leader from `users` WHERE name='".$params."'");
$grad = $rezultat->fetch_assoc();
if($grad["Leader"] != $params1) {
go("/");
die;
}
}
function select_name_faction() {
global $db;
$rezultat = $db->query("SELECT Name from `factions` where ID='".mysqli_real_escape_string($db, $_GET['factionID'])."'");
$numefactiune = $rezultat->fetch_assoc();
echo $numefactiune["Name"];
}
function select_info_user($params, $valuewant) {
global $db;
$rezultat = $db->query("SELECT * FROM `users` WHERE name='".$params."'");
$numefactiune = $rezultat->fetch_assoc();
echo $numefactiune[$valuewant];
}
function select_info_user_from_id($params, $valuewant) {
global $db;
$rezultat = $db->query("SELECT * FROM `users` WHERE id='".$params."'");
$numefactiune = $rezultat->fetch_assoc();
echo $numefactiune[$valuewant];
}
function check_app($params) {
global $db;
$rezultat = $db->query("SELECT * FROM `faction_apply` WHERE ID='".$params."'");
$rezultatfac = $rezultat->fetch_assoc();
if($rezultatfac["Status"] == 1) {
echo "Un-answered";
}
if($rezultatfac["Status"] == 2) {
echo "Accepted for tests";
}
if($rezultatfac["Status"] == 3) {
echo "Rejected";
}
}
function go($params) {
echo "<meta http-equiv=\"refresh\" content=\"0; url=".$params."\">";
}
//cod suplimentar
$VehicleName = Array(
400 => 'Landstalker', 401 => 'Bravura', 402 => 'buffalo', 403 => 'linerunner', 404 => 'perenail', 405 => 'sentinel', 406 => 'dumper', 407 => 'firetruck', 408 => 'trashmaster', 409 => 'stretch', 410 => 'manana', 411 => 'infernus', 412 => 'voodoo', 413 => 'pony', 414 => 'mule', 415 => 'cheetah', 416 => 'ambulance', 417 => 'levetian', 418 => 'moonbeam', 419 => 'esperanto', 420 => 'taxi', 421 => 'washington', 422 => 'bobcat', 423 => 'mr whoopee', 424 => 'bf injection', 425 => 'hunter', 426 => 'premier', 427 => 'enforcer', 428 => 'securicar', 429 => 'banshee', 430 => 'predator', 431 => 'bus', 432 => 'rhino', 433 => 'barracks', 434 => 'hotknife', 435 => 'artic trailer 1', 436 => 'previon', 437 => 'coach', 438 => 'cabbie', 439 => 'stallion', 440 => 'rumpo', 441 => 'rc bandit',
442 => 'Romero', 443 => 'packer', 444 => 'monster', 445 => 'admiral', 446 => 'squalo', 447 => 'seasparrow', 448 => 'pizza boy', 449 => 'tram', 450 => 'artic trailer 2', 451 => 'turismo', 452 => 'speeder', 453 => 'reefer', 454 => 'tropic', 455 => 'flatbed', 456 => 'yankee', 457 => 'caddy', 458 => 'solair', 459 => 'top fun', 460 => 'skimmer', 461 => 'pcj 600', 462 => 'faggio', 463 => 'freeway', 464 => 'rc baron', 465 => 'rc raider', 466 => 'glendale', 467 => 'oceanic', 468 => 'sanchez', 469 => 'sparrow', 470 => 'patriot', 471 => 'quad', 472 => 'coastgaurd', 473 => 'dinghy', 474 => 'hermes', 475 => 'sabre', 476 => 'rustler', 477 => 'zr 350', 478 => 'walton', 479 => 'regina', 480 => 'comet', 481 => 'bmx', 482 => 'burriro', 483 => 'camper', 484 => 'marquis', 485 => 'baggage',
486 => 'Dozer', 487 => 'maverick', 488 => 'vcn maverick', 489 => 'rancher', 490 => 'fbi rancher', 491 => 'virgo', 492 => 'greenwood', 493 => 'jetmax', 494 => 'hotring', 495 => 'sandking', 496 => 'blistac', 497 => 'police maverick', 498 => 'boxville', 499 => 'benson', 500 => 'mesa', 501 => 'rc goblin', 502 => 'hotring a', 503 => 'hotring b', 504 => 'blood ring banger', 505 => 'rancher (lure)', 506 => 'super gt', 507 => 'elegant', 508 => 'journey', 509 => 'bike', 510 => 'mountain bike', 511 => 'beagle', 512 => 'cropduster', 513 => 'stuntplane', 514 => 'petrol', 515 => 'roadtrain', 516 => 'nebula', 517 => 'majestic', 518 => 'buccaneer', 519 => 'shamal', 520 => 'hydra', 521 => 'fcr 900', 522 => 'nrg 500', 523 => 'hpv 1000', 524 => 'cement', 525 => 'towtruck', 526 => 'fortune',
527 => 'Cadrona', 528 => 'fbi truck', 529 => 'williard', 530 => 'fork lift', 531 => 'tractor', 532 => 'combine', 533 => 'feltzer', 534 => 'remington', 535 => 'slamvan', 536 => 'blade', 537 => 'freight', 538 => 'streak', 539 => 'vortex', 540 => 'vincent', 541 => 'bullet', 542 => 'clover', 543 => 'sadler', 544 => 'firetruck la', 545 => 'hustler', 546 => 'intruder', 547 => 'primo', 548 => 'cargobob', 549 => 'tampa', 550 => 'sunrise', 551 => 'merit', 552 => 'utility van', 553 => 'nevada', 554 => 'yosemite', 555 => 'windsor', 556 => 'monster a', 557 => 'monster b', 558 => 'uranus', 559 => 'jester', 560 => 'sultan', 561 => 'stratum', 562 => 'elegy', 563 => 'raindance', 564 => 'rc tiger', 565 => 'flash', 566 => 'tahoma', 567 => 'savanna', 568 => 'bandito', 569 => 'freight flat',
570 => 'Streak', 571 => 'kart', 572 => 'mower', 573 => 'duneride', 574 => 'sweeper', 575 => 'broadway', 576 => 'tornado', 577 => 'at 400', 578 => 'dft 30', 579 => 'huntley', 580 => 'stafford', 581 => 'bf 400', 582 => 'news van', 583 => 'tug', 584 => 'petrol tanker', 585 => 'emperor', 586 => 'wayfarer', 587 => 'euros', 588 => 'hotdog', 589 => 'club', 590 => 'freight box', 591 => 'artic trailer 3', 592 => 'andromada', 593 => 'dodo', 594 => 'rc cam', 595 => 'launch', 596 => 'cop car ls', 597 => 'cop car sf', 598 => 'cop car lv', 599 => 'ranger', 600 => 'picador', 601 => 'swat tank', 602 => 'alpha', 603 => 'phoenix', 604 => 'glendale (damage)', 605 => 'sadler (damage)', 606 => 'bag box a', 607 => 'bag box b', 608 => 'stairs', 609 => 'boxville (black)', 610 => 'farm trailer', 611 => 'utility van trailer'
);
?>