V3ct0r
-
Content Count
2,889 -
Joined
-
Last visited
-
Days Won
519
Everything posted by V3ct0r
-
@BETEP/macs509 спасибо! Обновил ссылку в шапке
-
Привет, @kiberhack! Тут кроме знания PHP нужно знать SQL - язык структурированных запросов. Чтобы вытащить GM-персонажей, которые онлайн, можно использовать такой запрос: SELECT c.cha_name FROM character AS c LEFT JOIN account AS a ON (a.act_id = c.act_id) WHERE c.mem_addr > 0 AND a.gm > 0 В связке с PHP это будет выглядеть например так: <?php // Данные для соединения с MSSQL-сервером $db_host = 'AMD'; $db_user = 'MDuser'; $db_pass = 'maindevru'; // Подключаемся к MSSQL-серверу... if (mssql_connect($db_host, $db_user, $db_pass) == false) { die('<b>Ошибка:</b> Невозможно подключиться к MSSQL-серверу!'); } // Выбираем базу данных GameDB if (mssql_select_db('GameDB') == false) { die('<b>Ошибка:</b> Не удалось открыть базу данных GameDB!'); } // Делаем SQL-запрос к базе данных $sql = 'SELECT c.cha_name FROM character AS c LEFT JOIN account AS a ON (a.act_id = c.act_id) WHERE c.mem_addr > 0 AND a.gm > 0'; $query = mssql_query($sql); if ($query == false) { die('<b>Ошибка:</b> Не удалось выполнить SQL-запрос на получение списка онлайн GM-персонажей!'); } // Формируем список персонажей $cha_online = array(); while ($cha = mssql_fetch_object($query)) { $cha_online[] = $cha->cha_name; } // Закрываем соединение с MSSQL-сервером (необязательно) mssql_close(); ?> <html> <head> <title>Список GM онлайн</title> </head> <body> <h1>Список GM онлайн</h1> <?php // Печатаем список персонажей foreach ($cha_online as $cha_name) { echo $cha_name . '<br />'; } ?> </body> </html>
-
Hello @Juan! Thank you for your suggestion, but we have decided to do not make sections in other languages for a while. Because our community is not too big and there is no necessity to divide it.
-
They are very useful. There is no any public repository. You can make it by yourself if you want. No, the source code is "pre" 2.4. It is closer to PKO server and client.
-
@zzzritdzzz First of all, you need web server with PHP. You can use XAMPP. Then put script from 1st post to web server folder (htdocs for XAMPP) and go in web browser to localhost/lgo and localhost/objlgo.
-
Has anyone from you got an idea how to Decompile StringSet.bin?
V3ct0r replied to Vasil's topic in Questions & Help
@Dimitrov you can find VS 2015 on MS site or google it -
Hello @xiangxhuwang! It is not easy to do. First, you have to patch server (GameServer.exe) to make it apply guild name for Navy Guilds. Then you have to patch client (Game.exe) to enable guild name edit form for Navy.
-
Hi @Jelly It is not enough memory for many maps. So you should run garner, magicsea and darkblue on different GameServer.exe, as @InuYasha said.
- 1 reply
-
- 1
-
-
Hello @Angelix! You can compile source code in Visual Studio/C++ 2008. Also you can use VS 2015 but with some fixes
-
Hello @crusadel! Show us ctrl.lua from server\resource\mapname
-
How I Can Make This Hairs With Many Colors Like Others
V3ct0r replied to InuYasha's topic in Questions & Help
@InuYasha check file hairs.txt. It is list of hairs -
@InuYasha Tell more about Guild vs Guild system. There is already one in original server files (secretgarden map)
-
@DangThao the same as official PKO 1.38 server
-
Fixed. To the future just replace daylight-online.ru to pkodev.net and let me know about broken link.
-
Maybe .exe file is damaged
-
@Kyren GameServer.zip
-
@Kyren ask @wolfenx
-
GameServer.exe from PKO 1.38 files (2088 KB) SkillEff = 0x00098841 GameServer.exe version 1.36 (2040 KB) SkillEff - 0x0009137B
-
@Kyren other 32-bit programs work?
-
-
@soilder12 Do SQL Query in MSSQL Management Studio / Query Analyzer USE [AccountServer] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[account_pending]( [acc_id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NOT NULL, [password] [varchar](50) NOT NULL, [squestion] [varchar](100) NOT NULL, [answer] [varchar](100) NOT NULL, [email] [varchar](100) NOT NULL, [gender] [int] NOT NULL, [credit] [int] NULL, [truename] [varchar](100) NOT NULL, [birthday] [datetime] NOT NULL, [contact] [varchar](50) NOT NULL, [country] [varchar](50) NOT NULL, [ipaddr] [varchar](50) NOT NULL, [ip2country] [varchar](50) NOT NULL, [actcode] [varchar](50) NULL, [invtcode] [varchar](50) NULL, [create_time] [varchar](50) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[account_pending] ADD CONSTRAINT [DF_account_pending_gender] DEFAULT ((0)) FOR [gender] GO
-
@Dimitrov any modifications and new scripts in server files? You need to find where from this function calls.
-
@Emiliano Install Visual C++ Redistributable for Visual Studio 2015