eXtreamCS.com

Totul despre Counter-Strike, Resurse si Servere
https://www.extreamcs.com/forum/

Cum sa-ti incepi un proiect de boost ? Tutorial

https://www.extreamcs.com/forum/viewtopic.php?f=15&t=339315

Page 1 of 3

Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 27 Apr 2017, 21:45
by blackgate
TUTORIALUL E FACUT PENTRU DEBIAN FIINDCA VA E MULT MAI USOR ! RECOMAND DEBIAN PENTRU TOATA TREABA ASTA
Vad prea multi ***** in ultimul timp care nu au bani de paine si incearca sa isi vanda ,,serviciile" - masterserver/metoda de furt etc. - ***** (london si inca cativa)
Cerinte: vps linux 512 mb ram minim

Code: Select all

apt-get update && apt-get upgrade && apt-get install screen && apt-get install apache2 && apt-get install php5 php-pear php5-mysql && apt-get install mysql-server && mysql_secure_installation
Dupa va cere sa introduceti parola setata de voi la mysql, dati allow la remote login si dati stergere la baza de date si userul creat de ei

Code: Select all

apt-get install php5-mysqlnd && apt-get install python-mysqldb && apt-get install phpmyadmin
Dupa trebuie sa editati fisierul: /etc/apache2/apache2.conf
Jos de tot pe ultima linie adaugati: Include /etc/phpmyadmin/apache.conf
Dupa scrieti:

Code: Select all

service apache2 restart
Accesati acum ip-ul de la vps http://ip/phpmyadmin
Introduceti datele pe care le-ati pus cand s-a instalat mysql, creati database: master
Dupa asta, apasati pe SQL command si puneti asta:
sql | Afiseaza codul
-- Adminer 4.0.3 MySQL dump

SET NAMES utf8;
SET foreign_key_checks = 0;
SET time_zone = '+02:00';
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `mslog`;
CREATE TABLE `mslog` (
  `timeyear` varchar(255) DEFAULT NULL,
  `timemonth` varchar(255) DEFAULT NULL,
  `timeday` varchar(255) DEFAULT NULL,
  `timehour` varchar(255) DEFAULT NULL,
  `timeminute` varchar(255) DEFAULT NULL,
  `timesecond` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `port` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `mslog` (`timeyear`, `timemonth`, `timeday`, `timehour`, `timeminute`, `timesecond`, `ip`, `port`, `type`) VALUES
('2017',	'03',	'13',	'00',	'17',	'42',	'5.13.232.1',	'54234',	'cs'),
('2017',	'04',	'27',	'00',	'35',	'52',	'88.158.149.121',	'49621',	'cs');

DROP TABLE IF EXISTS `server_list`;
CREATE TABLE `server_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `server` varchar(255) DEFAULT NULL,
  `ipserver` int(11) DEFAULT NULL,
  `time` int(11) NOT NULL,
  `country` varchar(4) DEFAULT NULL,
  `weekly` tinyint(1) NOT NULL DEFAULT '0',
  `monthly` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `server_list` (`id`, `server`, `ipserver`, `time`, `country`, `weekly`, `monthly`) VALUES
(1,	'93.119.26.30:27015',	NULL,	1517847138,	'ro',	0,	1),
(2,	'94.176.2.165:27015',	NULL,	1517847138,	'ro',	0,	1),
(5,	'93.115.80.110:27015',	NULL,	1517847138,	'ro',	0,	1),
(7,	'89.34.25.30:27015',	NULL,	1517847138,	'ro',	0,	1),
(66,	'89.44.246.86:27015',	NULL,	0,	'ro',	0,	1),
(67,	'93.119.26.141:27015',	NULL,	0,	'ro',	0,	1),
(68,	'89.33.242.173:27015',	NULL,	0,	NULL,	0,	0),
(69,	'93.119.25.52:27015',	NULL,	0,	NULL,	0,	0),
(70,	'89.40.233.56:27015',	NULL,	0,	NULL,	0,	0),
(72,	'89.40.70.169:27015',	NULL,	0,	NULL,	0,	0),
(73,	'188.214.88.231:27015',	NULL,	0,	NULL,	0,	0),
(74,	'89.40.104.61:27015',	NULL,	0,	NULL,	0,	0),
(76,	'5.83.43.197:28015',	NULL,	0,	NULL,	0,	0),
(78,	'89.40.233.55:27015',	8940,	1495622461,	'ro',	1,	0);

-- 2017-04-26 23:36:02
Alta comanda necesara la SQL:

Code: Select all

GRANT ALL PRIVILEGES ON master.* TO root@'ipvostru' IDENTIFIED BY 'parola';
master.* = database, daca e pus master cum v-am spus mai sus, lasati asa
root@'ipvostru' = user@ip de la vps
IDENTIFIED BY 'parola'; = e clar aici ce e

Optional, daca nu functioneaza cum trebuie statistica, bagati si @localhost

Mai aveti de editat fisierul: /etc/mysql/my.conf , cautati linia cu bind-address si stergeti-o

Dupa introduceti comanda:

Code: Select all

service mysql restart
NU AVETI TREABA CU URMATOARELE: tabelu server_list , coloanele : ipserver,time,country,weekly,monthly
La id nu puneti nimic, e auto increment, la server puneti adresa serverului.
Puteti dupa sa dati empty la tabela server list si sa va bagati voi serverele.
Pentru statistica masterserver va duceti in: /var/www/html/ si creati fisierul urmator numit index.php sau cum vreti voi:
fisier | Afiseaza codul
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script src="//ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> 
<script type="text/javascript">
    google.charts.load("current", {packages:['corechart']});
    google.charts.setOnLoadCallback(startstuff); 
	var date = new Array(7);
	var quant = new Array(7);
<?php
error_reporting(-1);
ini_set('display_errors', 'On');
date_default_timezone_set('Europe/Bucharest');
	$db_adddress = 'localhost';
	$db_user = 'user';
	$db_pass = 'parola';
	$db_database = 'master';
	
	$localConnectionSC = new mysqli($db_adddress, $db_user, $db_pass, $db_database);
	if($localConnectionSC->connect_error)
	{
	  $this->last_error = 'Cannot connect to database. ' . $localConnectionSC->connect_error;
	}

	for ($x=6; $x>=0; $x--)
	{
		$m = (date("m", strtotime("-".$x." day")));
		$m2 = (date("Y", strtotime("-".$x." day"))); 
		$m3 = (date("d", strtotime("-".$x." day")));
		echo "date[" . $x . "]='" . $m3 . "-" . $m . "-" . $m2 . "';";

		$localSqlSC = 'SELECT COUNT(DISTINCT (`ip`)) AS `unique` FROM `mslog` WHERE timeyear = ? and timemonth = ? and timeday = ? and type = ?';
		$localStatementSC = $localConnectionSC->prepare($localSqlSC);
		$localType = "cs";
		$localStatementSC->bind_param('ssss', $m2, $m, $m3, $localType);
		$localStatementSC->execute();
		$localResSC = $localStatementSC->get_result();
		$localRowSC = $localResSC->fetch_assoc();
		echo "quant[" . $x . "]=" . $localRowSC['unique'] . ";";
	}
	mysqli_close($localConnectionSC);
?>
      function drawChart() {
      var data = google.visualization.arrayToDataTable([
        ["Data", "Jucatori unici"],
		[date[6], quant[6]],
		[date[5], quant[5]],
		[date[4], quant[4]],
		[date[3], quant[3]],
		[date[2], quant[2]],
		[date[1], quant[1]],
		[date[0], quant[0]]
		]);
		
		
		
      var view = new google.visualization.DataView(data);
      view.setColumns([0, 1,
                       { calc: "stringify",
                         sourceColumn: 1,
                         type: "string",
                         role: "annotation" }]);

      var options = {
		 titleTextStyle:{color:'white'},
		  hAxis: {
    textStyle:{color: '#FFFFFF'}
},
vAxis: {
    textStyle:{color: '#FFFFFF'},
	minValue: 0
},
        title: "Master Server # Interogari unice (bazat pe ip).", 
        height: 300,
		backgroundColor: '#464646',
		colors:['red','#004411'],
        bar: {groupWidth: "95%"},
        legend: { position: "none" },
      };
      var chart = new google.visualization.ColumnChart(document.getElementById("columnchart_values"));
      chart.draw(view, options);

	  
  }
  
  function startstuff()
  {
	  drawChart();
  }
</script>

<div id="columnchart_values" style="min-width: 500px; height: 300px; margin: 0 auto;background-color:black"></div>
De modificat astea:

Code: Select all

	$db_adddress = 'localhost';
	$db_user = 'user';
	$db_pass = 'parola';
	$db_database = 'master';
Fisierele pentru masterserver:
http://www108.zippyshare.com/v/AfPFSQk0/file.html

[OPTIONS]
# IP адрес
HOST = ip
# Порт для игр на движке Gold Source(CS 1.6, HL1), use OFF to off support of this protocol
PORTGS = 27010

Portgs = 27010 , asta va fi portul la master
HOST = ip-ul de la vps


Ce mai aveti de editat:
[LOG]
# 1 - Лоигировать запросы/обращения в файл ms.log, 0 - отключить
LOG = 1
LOGERR = 1
# 1 - Включить отображение запросов в консоле, 0 - отключить
CONSOLE = 1
# режим записи логов в MYSQL или FILE
MODE = MYSQL
HOST = ip
NAME = master
USER = root
PASSWORD = parola
# Имя таблицы для логов(не менять имя...)
TABLE = mslog

[BOOSTBYMIRROR]
HOST = ip
NAME = master
USER = root
PASSWORD = parola
# Имя таблицы где хранятся списки серверов
TABLE = server_list

Ca sa porniti masterul:

Code: Select all

screen && python ms.py
--------------
Asta e doar partea de masterserver, pentru plugin de repartizare jucatori si alte prostii, daca vreti lasati reply, altfel nu ma obosesc

Re: Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 27 Apr 2017, 21:50
by eu.Blizz
Imi poți lasa si mie intr-un mesaj privat plugin-ul de repartizare?
Mersi.

Re: Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 27 Apr 2017, 21:52
by The Kalu
Le-ai luat painea :(

Re: Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 27 Apr 2017, 21:57
by blackgate
http://www44.zippyshare.com/v/C5PIhJEo/file.html
plugin repartizare jucatori si statistica
imi e lene acuma sa scriu tutorial, cine nu se pricepe sa scrie si poate-l fac maine

Re: Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 27 Apr 2017, 22:01
by KeNny. FRN
Multumim blackgate

Re: Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 27 Apr 2017, 22:29
by Bodybuilding God
GG acum London beleste coclenderu, nu mai ia 0.10 PayPal pe boost =))

Re: Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 28 Apr 2017, 01:22
by hadi
blackgate wrote:http://www44.zippyshare.com/v/C5PIhJEo/file.html
plugin repartizare jucatori si statistica
imi e lene acuma sa scriu tutorial, cine nu se pricepe sa scrie si poate-l fac maine
Bravo omule, stiu ca era unu mr vasea care cerea vreo 40 euro pentru chestia asta .
Ar fi bun si un tutorial la asta, london are un topic `creez platforma boost` ceva de genul .

Re: Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 28 Apr 2017, 02:28
by laurwtf
Te-ai rugat 2 ore de mine sa te invat si acu vii si postezi pe extream

Re: Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 28 Apr 2017, 14:56
by blackgate
laurwtf wrote:Te-ai rugat 2 ore de mine sa te invat si acu vii si postezi pe extream
:)))))))))))))))))))

Re: Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 30 Apr 2017, 13:28
by CCiuculan(c)Maimuta
blackgate wrote: imi e lene acuma sa scriu tutorial, cine nu se pricepe sa scrie si poate-l fac maine
poti face un tutorial si pentru asta :D este bine venit ...

Re: Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 03 May 2017, 02:31
by SnitchBitch
blackgate wrote:
laurwtf wrote:Te-ai rugat 2 ore de mine sa te invat si acu vii si postezi pe extream
:)))))))))))))))))))

Ba ce rau esti ma :((

Acuma toti kinderi o sa vina "Vand boost CS 1.6" :troll

Re: Cum sa-ti incepi un proiect de boost ? Tutorial

Posted: 15 Dec 2017, 22:52
by Marrian.^
Mai merge metoda asta ? Sau investesc banii degeaba ?
All times are UTC+03:00
Page 1 of 3
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/