sql

I was using the offline guide from AnnieRuRu to set up a server. I am actually trying to make it LAN in order to play in hamachi with some colleagues. I know that tuto wasn't made for that but I figured if I edited a little I could pull it through. My mistake. Still I would want to do it, but I...

Hey guys, I've read any topic about this out there, but I am still not able to make it work. This is what I've done: /src/map/itemdb.h: -#define MAX_ITEMDB 0x8000 // 32k array entries in array (the rest goes to the db) +#define MAX_ITEMDB 0x10000 // 64k array entries in array (the rest goes...

Hello guys I wrote an article lately about automatic SQL database backup For Linux Systems (Sorry Wind0z guys and gals...) This is the one I'm using for my projects https://habilisbest.com/sql-database-automatic-backups Features: Backups database names specified in a list compresses and...

[SQL]: DB error - Duplicate entry '4700' for key 'PRIMARY' [Debug]: at c:\users\frt54ree4\desktop\ro\hercules\src\map\log.c:396 - INSERT DELAYED INTO `chatlog` (`time`, `type`, `type_id`, `src_charid`, `src_accountid`, `src_map`, `src_map_x`, `src_map_y`, `dst_charname`, `message`) VALUES...

Its show error 1265. Data truncated for column 'equip_jobs' at row 1 i am using the latest sql file. how to fix it? Mysql Workbench57

I just install hercules in my pc following this guide http://herc.ws/wiki/Installation_(CentOS) why item db and mob db still reference to db/pre-re/mob_db.conf and db/pre-re/item_db.conf i want to use sql database thanks

Hello, Normaly when people make a account on the server the ID goes from 200000 to 200001 etc. Now i changed 1 account to test to 3000020 and i changed it back now. Now if there is a new account it keeps counting from 3000021 and up.. Is there a way to set the count back to normal. Maybe there...

Error SQL query:  CREATE TABLE IF NOT EXISTS `charlog` ( `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `char_msg` VARCHAR(255) NOT NULL DEFAULT 'char select', `account_id` INT(11) NOT NULL DEFAULT '0', `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `char_num` TINYINT(4) NOT...

Hi everyone, I am facing a big problem about the Hercules cannot support some Chinese words in player's name. Therefore, I have to make a script for player change their name. How to identify is the player's name used? Thank you

Can someone post any method how to delete cashpoint using sql or script? By the way, how to check player cashpoint in sql database? 

Hi,  I just realized that I have this log on my map-server.exe

Hi,  I am new in Hercules, and I wanted to installed ti so I can play on LAN with my friends. I just checked out the Hercules from github, and upon processing the database (from /trunk/sql-files) I met sooo many error when importing the upgrades (/trunk/sql-files/upgrades). So, I wanted to...

Greetings, Regarding Hercules' almost demanding way of using text-based database files. Having developed mainly item and mobs in SQL on rAthena, is there's no swift way to import SQL queries to convert them to text? Because of that I have been working on the database conversion, which I have...

Hello guys, I moved to Hercules emulator system; I have issue with this npc which was perfectly working in rAthena. As long as I know, Hercules doesnt have this table "global_reg_value" anymore and it was splitted in 6 tables now. http://pastebin.com/ACBTKCpN Your help is very appreciated...

there are no more global_reg_value on the sql database. please help how to fix , hunting mission quest   ase 6: mes "[Hunting Missions]"; mes "The top hunters are:"; query_sql("SELECT char_id AS id, (SELECT `name` FROM `char` WHERE char_id = id),`value` FROM `global_reg_value` WHERE str =...

it's a fine day & i need your great wisdom. i need to throw a SQL query when character is created/deleted. i wanna insert new data into some tables when new character is created. similarly, deletion from tables is needed when character is deleted. like: character has created! -&gt...