Adding +21 gear (not fully working)

silverstryfe · 03/07/2016, 15:35

Hi,

I have added +13 to +21 on my server, I can spawn them, I can see the stats on the weapon and on the attack details. The damage on mobs is the same, though...

I don't think the issue is client-side, I have all the files.

Server side I added in itemtype.dat and itemadd.txt. Am I missing something?

~~pro4never~~ · 03/07/2016, 15:40

Does your server not have a database at all? I only ask cause a lot of sources seem to use flat files (reading from itemadd/itemtype) but most would need you to add the updated data to your actual server side database for it to work.

silverstryfe · 03/07/2016, 16:01

Quote:

Originally Posted by pro4never

Does your server not have a database at all? I only ask cause a lot of sources seem to use flat files (reading from itemadd/itemtype) but most would need you to add the updated data to your actual server side database for it to work.

It does have a database.

There is a table "items" which are just the items that accounts have, and there is itemtype, where I already added the item manually. Without that added I wouldn't be able to spawn the item.

I'm actually using your source, redux.

I think I might have found it.. I didn't add anything in the itemadd table.
Though, It would take days to add that stuff manually. Is there a way to just copy-paste everything from the itemadd.ini file into a query or something? I'm realy new to that so If u could give me an example on how to do it that would be great!

Thanks.

CrimsonFart · 03/07/2016, 16:11

Why +21 gear, holy ****.

silverstryfe · 03/07/2016, 19:06

Quote:

Originally Posted by CrimsonFart

Why +21 gear, holy ****.

No no, the question is, why only +12?

Anyways, do you know how I can import my itemadd.ini into the itemadd table?

~~pro4never~~ · 03/07/2016, 19:11

Quote:

Originally Posted by silverstryfe

It does have a database.

There is a table "items" which are just the items that accounts have, and there is itemtype, where I already added the item manually. Without that added I wouldn't be able to spawn the item.

I'm actually using your source, redux.

I think I might have found it.. I didn't add anything in the itemadd table.
Though, It would take days to add that stuff manually. Is there a way to just copy-paste everything from the itemadd.ini file into a query or something? I'm realy new to that so If u could give me an example on how to do it that would be great!

Thanks.

Write a program to write the necessary SQL queries to insert it into the database. That's the quickest way IMO. Should take 5 minutes to do a basic string formatter to do the job.

silverstryfe · 03/07/2016, 19:20

Quote:

Originally Posted by pro4never

Write a program to write the necessary SQL queries to insert it into the database. That's the quickest way IMO. Should take 5 minutes to do a basic string formatter to do the job.

Eh, thanks for your replies but, can u simplify that? I'm not that smart

Can't I import wizard it with navicat?
Like copy paste the itemadd.ini into a .txt file and then import wizard.

Nevermind.. There is also a KEY colum which needs to be added manually i suppose..
Not willing to do this for 1000 items :/

pintinho12 · 03/07/2016, 22:12

1. Create a program to read every line of the Itemadd.ini
2. Transform every line into an SQL line
3. Execute it at Mysql

not that hard
10 minutes of code to save hours of work

Spirited · 03/07/2016, 22:37

This was one thing Navicat did well that I miss in MySQL Workbench. In Navicat, you can import data from any file format using file delimiters and a predefined table structure. I'm not saying go pirate Navicat, but if you chose to make a program to read in a file, make it generic enough to repeat the same process on multiple files, similarly to how Navicat did it.

silverstryfe · 03/07/2016, 22:53

I edited my itemadd.txt with office word to replace every space with a tab so it imports correctly into navicat, but the problem is that it doesn't have the KEY colum.. It just puts 0 as KEY and it gives me an error.

silverstryfe · 03/09/2016, 12:56

can someone help me how the Key id works?

turk55 · 03/09/2016, 13:19

silverstryfe · 03/09/2016, 14:36

Not realy helped but okay, thanks.

Would it work like what I read here?

I added it to my program.cs but got an error.. Maybe because I didn't delete my itemadd table in the databse?
I'm afraid to do so because I don't want to screw up

EDIT:

I added everything to the itemadd table in the database. But the +21's still don't work..? :s

silverstryfe · 03/11/2016, 17:09

Someone?

Spirited · 03/11/2016, 18:00

This is some really simple ****. Add to client file, add to server database. That is all folks. If you're struggling this hard to do this, trying to modify the source and creating errors... hell, trying to even add +21 in the first place, then maybe you shouldn't be running a private server? We don't need more ****** servers like the one your friend is also trying to make. I'll say to you what I said to him: Nobody wants this ****. People want to see progress and an actual game out of Conquer Online - and adding things from 2009 private servers isn't going to do that. Having absolutely zero knowledge on database management and programming is a huge red flag as well. It all just points to a shitfest, so give up. Go learn how to program in a general case.