aakarsh98

link broken

is there any guides on how to create skins for mounts and character ?

oh not this, i didnt mean that. I meant the In game Bot chars that can do everything.

Who we’re looking for Role What you’ll do Ideal fit Game Masters (GM) • Patrol the realm for rule-breakers • Host live events & contests • Work with devs on bug reports Veteran players with calm, fair judgement & solid game knowledge Game Counselors (GC) • Provide first-line player support • Moderate chat & forums • Write how-to guides / FAQs Helpful, patient communicators who enjoy solving problems Community Promoters • Grow our social channels & Discord • Create highlight videos & memes • Drive traffic to our new commercial marketplace Content creators & influencers who love sharing epic moments In-game rewards & perks Benefit GM/GC Promoters Guild-Leader / Migrating Guild Legendary Title & Costume ✔ – Guild Master gets a unique banner skin Monthly DivineCoins stipend 2 000 1 000 (tiered by reach) 5 000 coins to shared guild vault Event-host commands (safe, non-P2W) ✔ – Private launch event for your guild Early access to test realms ✔ ✔ ✔ Affiliate revenue share (commercial site) – Up to 10 % on item sales 2 % bonus on guild members’ purchases for 60 days Fast-track support channel ✔ ✔ ✔ Moving your crew from another MMORPG? Bring 10 + active members and we’ll: Summon a dedicated NPC in Armia—only your Guild Leader can speak to this herald to reserve your guild name + emblem before public release. Outfit every founding member with an exclusive, permanent “Pioneer” costume that can’t be obtained any other way. Sponsor a server-wide showcase event starring your guild: one epic PvE raid and one headline PvP tournament with broadcast coverage and loot prizes. This server is not built on a public source code, built completely ground up with custom framework and systems. DM me to connect!

so i was working on some game economy balancing scripts , i had this idea to implement a bot char in game to play the game just as a regular player, fully functional decision making tree and such. its a mega project on its own i suppose. But has anyone else thought about it before and worked on it? if so what roadblocks did you face.

if (pMob[arg2].DropBonus > 0 && pMob[arg2].DropBonus < 100) LOCAL_203 -= (LOCAL_203 * pMob[arg2].DropBonus / 100); I came across this part of the code that deals with drop bonus, interestingly the more bonus items you equip the lower the bonus rates become, for example i use a 40% fairy, the drop rate becomes 60 from 100 instead of 140 from 100. can anyone explain how this is working the way it is.

check rankings and the other bin files.

very interesting, i will take into consideration of the different approaches now.

void sendranking2(const int conn) { if (pMob[conn].MOB.CurrentScore.Level < 1000) { auto mob = GetMobFromIndex(conn); auto user = GetUserFromIndex(conn); int totalkill = GetTotKill(conn); int curkill = GetCurKill(conn); int altar = pMob[conn].extra.score; int wins = pMob[conn].extra.scorewins; if (wins <= 0) wins = 0; char dir[100]; time_t now = time(0); tm when; localtime_s(&when, &now); int score = 0; FILE* fp; if (mob->extra.ClassMaster == MORTAL) { sprintf_s(dir, "../../Common/RankingApp/Ranking2/%s.txt", mob->MOB.MobName); } else { sprintf_s(dir, "../../Common/RankingApp/Ranking2/%s_.txt", mob->MOB.MobName); } fopen_s(&fp, dir, "w"); int Evolucao = 0; int sub = 0; int slot = pUser[conn].Slot; if (mob->extra.ClassMaster == MORTAL) Evolucao = 0; if (mob->extra.ClassMaster == ARCH) Evolucao = 1; if (mob->extra.ClassMaster == CELESTIAL) Evolucao = 2; if (mob->extra.ClassMaster == CELESTIALCS || mob->extra.ClassMaster == SCELESTIAL) { Evolucao = 3; sub = 1; } int levelranking = mob->MOB.CurrentScore.Level * 3 + 1; score = wins + altar; if (Evolucao == 2) score += 0; if (Evolucao == 3) score += 0; if (Evolucao == 4) score += 0; int mobclan = mob->MOB.Clan; if (pMob[conn].extra.clanmode == 1) { mobclan = 9; } else if (pMob[conn].extra.clanmode == 2) { mobclan = 10; } if (fp == NULL) { printf("[Erro ao gerar ranking \n"); return; } else { fprintf_s(fp, "%s,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d", mob->MOB.MobName, mob->MOB.CurrentScore.Level, mob->MOB.Class, Evolucao, mobclan, mob->MOB.Guild, mob->MOB.GuildLevel, score, totalkill, sub, mob->extra.QuestInfo.Celestial.SubCelestialLevel, mob->extra.QuestInfo.Celestial.CelestialLevel, slot); fclose(fp); return; } } return; } trying to implement this to send data to me website need help. also how do i use the mysql functions to actively update data between db server and my sql data base.

can you share that tool please.

unfortunately its not that simple.

I have been trying to figure out how to change/set item icon for various items in the item list, one example is item 751 which is the dragon emblem, in the itemlist.csv its associated to icon 47 in the csv document, when i open the itemicon.bin its set to 132 when i open itemicon01.wyt, the icon is situated in 2nd row 7th column, i am confused, if someone can help me understand this better, it will be helpful.

i am interested in one as well.

wish that is possible in all the client versions, finding source codes is so tough.

nvm, the function calls were using API, thank you all for the suggestions.

I think i did not communicate correctly, I did run and test the Telnet command on both my personal pc and vps, its connecting and receiving data from the hosting site. so now i am debugging the MySQL function within the source code to see how the functions are called and how its responding.

great, so i tested this and everything works, i even tested this on my own pc trying to connect and access the database. i think its the problem with the code or how it references it. this is the mysql.h header file #include <mysql.h> #include <stdint.h> #pragma comment(lib, "libmysql.lib") #include "singleton.h" #define HOST "localhost" #define USER "root" #define PASS "123456" #define PORT 3306 #define DB "wydsite" extern int contador; extern char xQuery[1000]; extern char mQuery[1000]; extern char hQuery[1000]; extern char xMsg[1000]; extern char xRow[400]; extern char xMAC[400]; extern char xIP[400]; extern char* xPass; class cSQL : public Singleton<cSQL> { protected: friend class Singleton<cSQL>; cSQL() {} virtual ~cSQL() {} cSQL(const cSQL&) = delete; cSQL& operator=(const cSQL&) = delete; public: static MYSQL* wStart(); static MYSQL_RES* wRes(MYSQL* sql, char* query); static bool wQuery(char* query); static char* wInfo(char* query); static int iInfo(char* query); static int Cont(char* query); static void wLog(char* acc, char* pers, char* mensagem, char* type); static long long lInfo(char* query); }; uint32_t convert(const char* name); lets assume that i have replaced the database values correctly. this file below is the .cpp that defines the function, i think its not efficently reading and updating data from the datbase when its hosted on another server, however when i was testing on local machine, it seems to work fine. so if anyone has suggestions on how to fix it , that would be nice. #include "Basedef.h" #include <Windows.h> #include <stdio.h> #include <fcntl.h> #include <time.h> #include <math.h> #include <io.h> #include <errno.h> #include "wMySQL.h" HANDLE hThread; HANDLE ThreadLog; unsigned long iID; int contador = 0; char xQuery[1000]; char mQuery[1000]; char hQuery[1000]; char xMsg[1000]; char xRow[400]; char xMAC[400]; char xIP[400]; char* xPass; unsigned long lID; MYSQL* cSQL::wStart() { MYSQL* wSQL = mysql_init(NULL); try { my_bool reconnect = 1; mysql_options(wSQL, MYSQL_OPT_RECONNECT, &reconnect); mysql_options(wSQL, MYSQL_OPT_COMPRESS, 0); mysql_options(wSQL, MYSQL_OPT_CONNECT_TIMEOUT, "300"); if (!mysql_real_connect(wSQL, HOST, USER, PASS, DB, PORT, NULL, 0)) { printf("[wMySQL][TMSVR] Ocorreu um erro na conexão.\n\t\tErro: %s\n", mysql_error(wSQL)); return wSQL; } return wSQL; } catch (...) { return wSQL; } } MYSQL_RES* cSQL::wRes(MYSQL* sql, char* query) { try { if (mysql_query(sql, query)) { printf("[wMySQL][wRes] Erro na execução da wRes.\nQuery: %s\n\t\tErro: %s\n", query, mysql_error(sql)); mysql_close(sql); return NULL; } MYSQL_RES* result = mysql_store_result(sql); mysql_close(sql); if (result) return result; return NULL; } catch (...) { return NULL; } } void cSQL::wLog(char* acc, char* pers, char* mensagem, char* type) { time_t rawtime; struct tm* timeinfo; time(&rawtime); timeinfo = localtime(&rawtime); sprintf(logQuery, "INSERT INTO `log` (`ID`, `Conta`, `Char`, `Mensagem`, `Data`, `Tipo`) VALUES(NULL, '%s', '%s', '%s', '%d/%d/%d %d:%d:%d', '%s')", acc, pers, mensagem, timeinfo->tm_mday, (timeinfo->tm_mon + 1), (timeinfo->tm_year + 1900), timeinfo->tm_hour, timeinfo->tm_min, timeinfo->tm_sec, type); ////ThreadLog = CreateThread(NULL, 0, (LPTHREAD_START_ROUTINE)wQuery, (void*)logQuery, 0, &lID); //cSQL::wQuery(xQuery); auto& pc = cSQL::instance(); MYSQL* wSQL = pc.wStart(); if (mysql_query(wSQL, logQuery)) { printf("[wMySQL][Log] Erro na execução da wQuery.\n\t\tErro: %s\n", mysql_error(wSQL)); mysql_close(wSQL); //ExitThread(0); return; } mysql_close(wSQL); printf("[%02d/%02d/%d][%02d:%02d:%02d][%s - %s] %s\n", timeinfo->tm_mday, (timeinfo->tm_mon + 1), (timeinfo->tm_year + 1900), timeinfo->tm_hour, timeinfo->tm_min, timeinfo->tm_sec, acc, pers, mensagem); return; } /// Executes a query. bool cSQL::wQuery(char* query) { try { auto& pc = cSQL::instance(); MYSQL* wSQL = pc.wStart(); if (mysql_query(wSQL, query)) { printf("[wMySQL][wQuery] Erro na execução da wQuery.\n\t\tErro: %s\n", mysql_error(wSQL)); mysql_close(wSQL); //ExitThread(0); return FALSE; } mysql_close(wSQL); //ExitThread(0); return TRUE; } catch (...) { return FALSE; } } int cSQL::Cont(char* query) { int res = 0; auto& cnt = cSQL::instance(); MYSQL* wSQL = cnt.wStart(); MYSQL_RES* result = cnt.wRes(wSQL, query); if (result == NULL) { printf("[wMySQL][wInfo]: Ocorreu um erro ao retornar Dados.\n"); //mysql_free_result(sq.result); //mysql_close(sq.wSQL); return res; } res = (int)mysql_num_rows(result); mysql_free_result(result); mysql_close(wSQL); return res; } int cSQL::iInfo(char* query) { int res = 0; MYSQL_ROW row; auto& cnt = cSQL::instance(); MYSQL* wSQL = cnt.wStart(); MYSQL_RES* result = cnt.wRes(wSQL, query); if (result == NULL) { printf("[wMySQL][wInfo]: Ocorreu um erro ao retornar Dados.\n"); //mysql_free_result(sq.result); //mysql_close(sq.wSQL); return res; } while ((row = mysql_fetch_row(result)) != NULL) res = atoi(row[0]); mysql_free_result(result); mysql_close(wSQL); return res; } long long cSQL::lInfo(char* query) { long long res = 0; MYSQL_ROW row; auto& cnt = cSQL::instance(); MYSQL* wSQL = cnt.wStart(); MYSQL_RES* result = cnt.wRes(wSQL, query); if (result == NULL) { printf("[wMySQL][wInfo]: Ocorreu um erro ao retornar Dados.\n"); //mysql_free_result(sq.result); //mysql_close(sq.wSQL); return res; } while ((row = mysql_fetch_row(result)) != NULL) res = atoll(row[0]); mysql_free_result(result); mysql_close(wSQL); return res; } char* cSQL::wInfo(char* query) { MYSQL_ROW row; auto& cnt = cSQL::instance(); MYSQL* wSQL = cnt.wStart(); MYSQL_RES* result = cnt.wRes(wSQL, query); if (result == NULL) { printf("[wMySQL][wInfo]: Ocorreu um erro ao retornar Dados.\n"); //mysql_free_result(sq.result); //mysql_close(sq.wSQL); return (char*)"0"; } char res[1000]; memset(res, 0, sizeof(char)); while ((row = mysql_fetch_row(result)) != NULL) strcpy(res, row[0]); mysql_free_result(result); mysql_close(wSQL); return res; } uint32_t convert(const char* name) { uint32_t val = uint32_t(name[3]) + (uint32_t(name[2]) << 8) + (uint32_t(name[1]) << 16) + (uint32_t(name[0]) << 24); return val; }

can you help me out in pvt, i have put in the details correctly, but the main tm/db server doesnt seem to call and utilize it.

//#define HOST "localhost" //#define USER "root" //#define PASS "123456" //#define PORT 3306 //#define DB "wydsite" what should be the values when using a hosting service, through cpanel and myphp. need help setting this when the main server is on a different device/ip/vps adn the website/database is hosted on a different IP/domain.

This happens on server reset, and sometimes in the source code based on the date its set to reset.

ItemList editor.

i dont know how not to do that.

can you share the source code if possible please, its missing the bin to txt and txt to bin.

Not needed , you can try .

import struct import tkinter as tk from tkinter import filedialog, messagebox, simpledialog, ttk # Constants NUM_STRINGS = 2000 CHARS_PER_STRING = 128 # Read the binary file and return list of strings def read_strdef_bin(filepath): with open(filepath, 'rb') as f: data = f.read(NUM_STRINGS * CHARS_PER_STRING) strings = [data[i*CHARS_PER_STRING:(i+1)*CHARS_PER_STRING].decode('latin1').rstrip('\x00') for i in range(NUM_STRINGS)] return strings # Write the list of strings back to binary format def write_strdef_bin(filepath, strings): with open(filepath, 'wb') as f: for s in strings: encoded = s.encode('latin1')[:CHARS_PER_STRING] padded = encoded + b'\x00' * (CHARS_PER_STRING - len(encoded)) f.write(padded) # GUI application class class StrDefEditorApp: def __init__(self, root): self.root = root self.root.title("STRDEF.BIN Editor") self.file_path = "" self.strings = [] self.create_widgets() def create_widgets(self): frame = ttk.Frame(self.root) frame.pack(fill='both', expand=True) self.listbox = tk.Listbox(frame, font=('Courier', 10)) self.listbox.pack(side='left', fill='both', expand=True) self.listbox.bind('<<ListboxSelect>>', self.edit_string) scrollbar = tk.Scrollbar(frame) scrollbar.pack(side='right', fill='y') self.listbox.config(yscrollcommand=scrollbar.set) scrollbar.config(command=self.listbox.yview) menubar = tk.Menu(self.root) filemenu = tk.Menu(menubar, tearoff=0) filemenu.add_command(label="Open", command=self.open_file) filemenu.add_command(label="Save", command=self.save_file) menubar.add_cascade(label="File", menu=filemenu) self.root.config(menu=menubar) def open_file(self): path = filedialog.askopenfilename(filetypes=[("BIN files", "*.bin")]) if not path: return self.file_path = path self.strings = read_strdef_bin(path) self.listbox.delete(0, tk.END) for i, s in enumerate(self.strings): self.listbox.insert(tk.END, f"{i:04}: {s}") def save_file(self): if not self.file_path or not self.strings: return write_strdef_bin(self.file_path, self.strings) messagebox.showinfo("Saved", "Changes saved to file.") def edit_string(self, event): selection = self.listbox.curselection() if not selection: return index = selection[0] old_value = self.strings[index] new_value = simpledialog.askstring("Edit String", f"Edit string at index {index}:", initialvalue=old_value) if new_value is not None: self.strings[index] = new_value self.listbox.delete(index) self.listbox.insert(index, f"{index:04}: {new_value}") # Run the app def run_app(): root = tk.Tk() app = StrDefEditorApp(root) root.mainloop() run_app()