Search the Community
Showing results for tags 'SQL'.
Found 16 results
-
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 need...
-
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...
-
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 compres...
-
DB error - Duplicate entry '4700' for key 'PRIMARY'
frotek posted a question in General Server Support
[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 (NOW(), 'O... -
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 i...
-
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 NUL...
-
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 ha...
-
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 appre...
-
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! -> insert...
