Jump to content

Search the Community

Showing results for tags 'SQL'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Bulletin Centre
    • Community News
    • Repository News
    • Ragnarok News
  • Hercules Development Centre
    • Development Discussion
    • Suggestions
    • Development Centre Archives
  • Support & Releases
    • General Server Support
    • Database
    • Scripting
    • Source
    • Plugin
    • Client-Side
    • Graphic Enhancements
    • Other Support & Releases
  • Hercules Community
    • General Discussion
    • Projects
    • Employment
    • Server Advertisement
    • Arts & Writings
    • Off Topic
  • 3CeAM Centre
    • News and Development
    • Community
  • International Communities
    • Filipino Community
    • Portuguese Community
    • Spanish Community
    • Other Communities

Categories

  • Client Resources
  • Graphic Resources
    • Sprites & Palettes
    • Maps & Textures
    • Other Graphics
  • Server Resources
    • Server Managers / Editors Releases
    • Script Releases
    • Source Modifications
    • Plugins
    • Pre-Compiled Server
  • Web Resources

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Discord


Skype


IRC Nickname


Website URL


Location:


Interests


Github

Found 16 results

  1. 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 some help. The computer i'm using is in a domain (it's from my work) and the edits I made that are different from the tuto are only the IP (my hamachi one) for the (char and map)-server and the sql connection i left in localhost IP. char-server.conf (cut) // Server Communication username and password. userid: "server" passwd: "server" // Login Server IP // The character server connects to the login server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. login_ip: "25.25.148.64" // Character Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. char_ip: "25.25.148.64" map-server.conf (cut) // Information related to inter-server behavior inter: { // Interserver communication passwords, set in the login server database userid: "server" passwd: "server" // Map Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. map_ip: "25.25.148.64" // Character Server IP // The map server connects to the character server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. char_ip: "25.25.148.64" } sql-connection (cut) sql_connection: { // [INTER] You can specify the codepage to use in your mySQL tables here. // (Note that this feature requires MySQL 4.1+) //default_codepage: "" // [LOGIN] Is `userid` in account_db case sensitive? //case_sensitive: false // For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1. // Under windows, you want to use 127.0.0.1. If you see a message like // "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" // and you have localhost, switch it to 127.0.0.1 db_hostname: "127.0.0.1" db_port: 3306 db_username: "root" db_password: "1234" db_database: "hercules" //codepage:"" } Any one that could help me?
  2. 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 to the db) /src/common/mmo.h: - short nameid; + unsigned short nameid; /sql-files/main.sql: card0~ card3 from smallint to mediumint (at multiple places) BUT still: when i logout with an itemID over 32k, it gets deleted with following error: [SQL]: DB error - data of field 'nameid' was truncated [Debug]: column - 1 [Debug]: data - type=UNSIGNED MYSQL_TYPE_LONG, le [Debug]: buffer - type=MYSQL_TYPE_SHORT, length=2
  3. 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 stores them Uses filename format for easy retrieval [DatabaseName].YYYY-mm-dd.gz Removes backups older than 28 days (to keep it nice and clean) Writes log files You can configure it to run every 12 hours with cron (crazy server owners...) I run it every 3 days. Because, I don't give a damn about my players I'm confident in my Raspberry Pi server! Would like your feedback and if you can think of any other features I can develop, please speak up!
  4. [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', '0', '150011', '2000003', 'invek', '151', '158', ?, ?) i recently update my folder then suddenly i got errors like this, does anyone encountered this type of problems too? It shows up every time i kill monsters.
  5. 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
  6. 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
  7. 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 is a setting in the sql database. Kind Regards Henry
  8. 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 NULL DEFAULT '0', `name` VARCHAR(23) NOT NULL DEFAULT '', `str` INT(11) UNSIGNED NOT NULL DEFAULT '0', `agi` INT(11) UNSIGNED NOT NULL DEFAULT '0', `vit` INT(11) UNSIGNED NOT NULL DEFAULT '0', `INT` INT(11) UNSIGNED NOT NULL DEFAULT '0', `dex` INT(11) UNSIGNED NOT NULL DEFAULT '0', `luk` INT(11) UNSIGNED NOT NULL DEFAULT '0', `hair` TINYINT(4) NOT NULL DEFAULT '0', `hair_color` INT(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM MySQL said: #1067 - Invalid default value for 'time' If I change the value of time, I'm afraid it's gonna cause troubles with the clientside. Any thoughts?
  9. 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
  10. Can someone post any method how to delete cashpoint using sql or script? By the way, how to check player cashpoint in sql database?
  11. Hi, I just realized that I have this log on my map-server.exe
  12. 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 ask are there any main.sql that I can copy to be ready to use (including the latest database update) ? And if it possible the file ready for Renewal... Thank you
  13. 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 said in the past and you can find the information in this topic. Getting stuck on two aspects so far in (successfully) converting the databases if I have to stick with SQL due to the above not being (currently) possible: equip_locations at rA is set to mediumint(7) and at Herc to smallint(4), which prevents conversion due to certain values being out of range, at least as far as I've researched. ✓ Solved this one, had to use CHANGE instead of MODIFY and re-state the column name. The type of item where rA and Herc have opposite values for Weapon and Armor/Garment/Boots/Headgear/Accessory, updating the query to switch them yields either all weapons or all armor/etc. Is anyone able and willing to push me in the right direction? Naturally I'll publish the modifications I've done to jaBote's rA > Herc convertor when I get things are working the way it is intended to. Finally, I still haven't solved/received the answer I wanted from the topic I quoted above. It doesn't affect me or the server I'm working on, but it is for the sake of completion for the convertor for those who are affected by that specific table. Kind regards, Tranquility
  14. 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, thank you.
  15. 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 = 'Mission_Total' ORDER BY CAST(`value` AS SIGNED) DESC LIMIT 5",.@id,.@name$,.@val); for(set .@i,0; .@i<5; set .@i,.@i+1) mes " [Rank "+(.@i+1)+"] "+((.@name$[.@i] == "")?"^777777none":"^0055FF"+.@name$[.@i]+"^000000 : ^FF0000"+.@val[.@i]+" pt.")+"^000000"; close;
  16. 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 into tblX (colA, colB, .....) values (dataA, dataB, .....); character has deleted! -> delete from tblX where colA = dataA; there are conditions that NPC script is forbidden against this problem. need i modify .c/.h programs to solve this?
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.