Questions that require answers, please.

~~karnyge~~ · 03/25/2012, 17:34

Ok i am finally ready to allow a few folks into what i been working on.

But i am having a little trouble getting this sorted out.
Would someone please -
a) tell what i need to do with what files to enable my friends to connect
b) please dont point me to x/y/z guides as i find them often confusing
c) maybe offer assistance via tv ver 7 or 1-2-1 on msn.

Ideally, I need an experienced coder, one who could at a later date join me in making my ideas a reality or even teaching me some more of the things i really need to know. Leave me a PM with your MSN if you want to help out in the future. I know the things i need to know, and the things i need help with.
Any person offering help, via PM, will be contacted.

Any posts answering my request for info to open the server will be thanked, if they lead to a solution.

Issue 2
All the totems are invisible. There are no totems for registering pets when you go into the legion area.
(Not looking forward to fixing this one because I bet it will require lots of work lol).
Been reading up on this matter and according to some the issue is in the Stress.ini file and others say its syntotempillar.ini, totempole.ini, totempower.ini and something not matching to the database. So the question is this-
If the syntotempillar.ini has 64 entries and the corresponding db file, cq_totem_pole_type has 70, is that the error? Or is it deeper? (I have no wish to change either file/table to match the other without some form of definitive answer)

Apparently, after comparing id numbers in the syntotempillar.ini (64 entries) and cq_totem_pole_type (70 Entries) there are 10 id numbers in the ini file that do not appear in the db table, even though there are more entries in the db table. Is this why there are no visible totems?
My mathmatical skills are quite good so would someone please explain how come 70 minus 64 equals 10 in this case?
Oh and I have checked the stress.ini as being the cause, editing the word eudemons causing the totems to disappear, they are wrong. This option doesnt work.

funhacker · 03/25/2012, 17:57

I can't name all the files to be exact.
But you need your external IP to be added to most of the config files, connection to the database can remain local however. As if memory serves right, players only need to connect to the account and msg servers, so all other connections can be local.

As for issue 2, best way to fix this is to either copy your ini file into a table or vice versa.

ini structure works like so:
[id] [type]

table structure works like so:
[id] [type] [eud_type]

So if you ignore the eud type and copy just the other two rows id/type and paste these into your totempole.ini, after doing this press ctrl+h now copy a "tab" character and paste it into the 'find what' text box and then put a "space" character in the 'replace with' text box. Hit replace all. You now have a matching totempole.ini

Now next is you have to fix your SynTotemPillar.ini

Best way is to make sure you have entries for each in the totempole.ini, to do this run the following sql
"Display Warrior Euds"
select * type from cq_totem_pole_type where eudemon_type = 1;
"Display Mage Euds"
select * type from cq_totem_pole_type where eudemon_type = 2;
"Display Special Euds"
select * type from cq_totem_pole_type where eudemon_type = 3;

Any extra entries - remove them
Any missing add them

~~karnyge~~ · 03/25/2012, 18:44

Just verifying-
The external is the one i can find from somewhere like whatsmyip ?
And it goes into the msg and account servers configs, (gameserverip, masterip, and serverip - yes?).
What about the oems?

Update
No connection between the servers, with the ip i found through whatsmyip.

With regards to the solution to issue 2.
I think I understand what you are saying. I had already considered the idea that it was due to the incorrect amounts in the file and db, comparatively.
But this db, Chaos/NortalQueen, has more than the original pets. There are several astrals, and some others. Will your method have an effect on them?

I will give both answers a go and see what happens. Obviously, thanks can only be given once so ................... I am sure ya understand dude.

Additional,
I had to change the query, kept getting syntax errors.
Anyways, got 36 ID's come up.
If i am reading your instructions right, i have to put in the rest from the ini file, complete with its type.
Cross fingers lol, cos i bound to screw up.

Update
Now i have 80 id numbers. I must be doing some thing wrong. And the totems are still invisible.

funhacker · 03/26/2012, 07:11

Quote:

Originally Posted by karnyge

Just verifying-
The external is the one i can find from somewhere like whatsmyip ?
And it goes into the msg and account servers configs, (gameserverip, masterip, and serverip - yes?).
What about the oems?

Update
No connection between the servers, with the ip i found through whatsmyip.

With regards to the solution to issue 2.
I think I understand what you are saying. I had already considered the idea that it was due to the incorrect amounts in the file and db, comparatively.
But this db, Chaos/NortalQueen, has more than the original pets. There are several astrals, and some others. Will your method have an effect on them?

I will give both answers a go and see what happens. Obviously, thanks can only be given once so ................... I am sure ya understand dude.

Additional,
I had to change the query, kept getting syntax errors.
Anyways, got 36 ID's come up.
If i am reading your instructions right, i have to put in the rest from the ini file, complete with its type.
Cross fingers lol, cos i bound to screw up.

Update
Now i have 80 id numbers. I must be doing some thing wrong. And the totems are still invisible.

You'll need to setup port forwarding for each port too, and yes the oem aswell.

As for the totem the ID and Types must match EXACTLY in the cq_totem_pole and totempole.ini
As for syntotempillar.ini, I don't think they need to match exactly but will cause a few errors if they don't.

~~karnyge~~ · 03/29/2012, 16:25

With regards to Issue 2
I have done as directed and discovered some duplicated numbers in cq_totem_pole_type, (column type numbers)

Question
There shouldnt be duplicated entries, should there?

UPDATE
Removed the duplicated, added the ''extras'', etc and stil no totems.

funhacker · 03/29/2012, 17:52

Paste your totempole.ini here and I will give you a query to fix your table
Also paste your syntotempillar.ini here too

~~karnyge~~ · 03/29/2012, 18:46

SYNTOTEMPILLAR.INI

Code:

;ITEMTYPE Ëõ·Å´óÐ¡ Ä£ÐÍ¿í¶È Ä£ÐÍ¸ß¶È XÎ»ÖÃÆ«ÒÆ YÎ»ÖÃÆ«ÒÆ ´ï³É°ÙÐÇ¹âÐ§Æ«ÒÆ ÎïÆ·Ãû³Æ
[WarriorEudemon]
Amount=17
1071000 40 60 100 -50 -30 80 Õ½Ê¿Îï¹¥ÐÍ
1071010 25 60 100 -50 -35 75 Õ½Ê¿Îï·ÀÐÍ
1071330 40 60 100 -50 -41 85 Ë®Æ¿ÐÇÄÎÂå
1071020 40 60 100 -50 -30 85 Õ½Ê¿¹¥·ÀÐÍ
1071160 45 60 100 -48 -50 85 Ê¨×ÓÐÇÀï°Â
1071150 45 60 100 -48 -50 85 ¾ÞÐ·ÐÇ¿*Éª
1071140 40 60 100 -51 -48 85 Ë«×ÓÐÇÈö¼Ó
1071130 40 60 100 -51 -48 85 ½ðÅ£ÐÇÂ³µÏ
1071120 45 60 100 -48 -40 85 °×ÑòÐÇÄÂ°Í
1071470 40 60 100 -50 -33 100 ²Ã¾öÆïÊ¿¿*Â¡
1071480 80 60 80 -48 -52 70 ÊØ»¤ÆïÊ¿¶ä¶ä
1071040 23 60 100 -50 -33 80 Ë«ÐÇÀ*ÄáÑÇ
1071050 20 60 60 -50 -65 75 Îï·ÀÄ§·ÀÐÍ
1071410 60 60 60 -50 -70 70 ¿ªÐÄ¹ûÄÈÄÈ
1071400 60 60 60 -50 -70 70 µ÷Æ¤¹í¼ª±È
1071080 37 60 100 -50 -50 80 Ê¥ÌìÊ¹À×Ë¹
1071090 37 60 100 -50 -49 80 Ê¥ÌìÊ¹ÄÎÀö

[MageEudemon]
Amount=15
1071200 50 60 60 -50 -70 80 ·¨Ê¦Ä§¹¥ÐÍ
1071210 23 60 100 -50 -33 80 ¹ÂÐÇµÙÄÈÑÇ
1071290 40 60 100 -50 -41 85 Ë®Æ¿ÐÇÀ*ç÷
1071220 35 60 60 -50 -70 90 ·¨Ê¦¹¥·ÀÐÍ
1071660 45 60 100 -48 -50 85 Ê¨×ÓÐÇÀï°º
1071650 45 60 100 -48 -50 85 ¾ÞÐ·ÐÇÀ³ÄÈ
1071640 40 60 100 -51 -48 85 Ë«×ÓÐÇ¼ÓÂ¡
1071630 40 60 100 -51 -50 85 ½ðÅ£ÐÇÑÇ¶û
1071620 45 60 100 -48 -46 85 °×ÑòÐÇ¿¨µÏ
1071300 55 60 100 -48 -37 100 Òì½ç¾«ÁéÈðÀ*
1071570 55 60 60 -45 -72 100 ²Ã¾öÆïÊ¿É¯·Æ
1071580 80 60 80 -48 -52 70 ÊØ»¤ÆïÊ¿·É·É
1071240 45 60 60 -50 -60 80 ·¨Ê¦Ä§·ÀÐÍ
1071510 60 60 60 -50 -70 70 Ð¡»úÁéÅåÅå
1071500 60 60 60 -50 -70 70 î§Ë¯³æÆ¤Æ¤

[SpecialEudemon]
Amount=36
1071380 43 60 100 -50 -38 90 FlameTiger
1071390 43 60 100 -50 -38 90 SnowTiger
1071370 43 60 100 -50 -38 90 GrrenFish
1071360 43 60 100 -50 -38 90 BlueFish
1071320 43 60 100 -50 -38 90 RedZycron
1071310 43 60 100 -50 -38 90 BlueZycron
1071700 43 60 100 -50 -38 90 ÊØ»¤Õß°ÂË¹Í¡
1071710 43 60 100 -50 -40 90 Ì÷ÍûÕß·ÆÀ*ÄÈ
1071720 48 60 100 -50 -45 90 EudemonAdam
1071730 50 60 100 -50 -52 90 EudemonDiana
1071930 40 60 100 -48 -38 85 ±ùÒíÓÈÃÖ¶û
1071920 40 60 100 -48 -38 85 ÑªÒí·ÒÀï¶û
1071280 32 60 100 -48 -41 85 ËªÁ¶÷è÷ëÊÞ
1071270 32 60 100 -48 -41 85 Ìì»ð÷è÷ëÊÞ
1071260 30 60 100 -48 -33 85 À×ÒíÐÁµÏË¹
1071250 30 60 100 -48 -33 85 ³ãÒí¹ÅÀ*Ë¹
1071190 45 60 100 -49 -36 85 ¹Ô¹Ô»¢±ù±ù
1071180 45 60 100 -49 -36 85 Ááçç»¢ÕæÕæ
1071170 45 60 100 -49 -36 85 ·¢Ìõ»¢´ï´ï
1071030 45 60 100 -49 -36 85 Åùö¨»¢Ò§Ò§
1071950 45 60 100 -48 -45 85 Ê¨×ÓÐÇÑ×»ªÊÞ
1071940 45 60 100 -48 -45 85 Ê¨×ÓÐÇ±ùÃ¢ÊÞ
1071900 45 60 100 -48 -45 85 ¾ÞÐ·ÐÇÑ×»ÊÊÞ
1071910 40 60 100 -48 -45 85 ¾ÞÐ·ÐÇÒø»ÊÊÞ
1071770 40 60 100 -51 -48 85 Ë«×ÓÐÇÇàó¤ÊÞ
1071760 40 60 100 -51 -48 85 Ë«×ÓÐÇ×ÏÚ¤ÊÞ
1071100 50 60 100 -50 -33 85 µÒ¿ËÅ£(ÌØ)
1071110 50 60 100 -50 -33 85 ºûµûÅ£ç÷ç÷
1071600 50 60 100 -50 -33 85 Îû¹þÅ£Æ¤Æ¤
1071610 50 60 100 -50 -33 85 ìÅÎèÅ£(ÌØ)
1071490 65 60 60 -50 -71 55 ÊóÀ´¸£¶¡¶¡
1071590 65 60 60 -50 -71 55 ÊóÀ´ÔËÆæÆæ
1071840 33 60 100 -50 -33 85 À×½Çºé»ÄÊÞ
1071850 33 60 100 -50 -33 85 À×½Ç·çÑÀÊÞ
1071420 80 60 50 -50 -80 55 ¼ªÏéàààà

TOTEMPOLE.INI

Code:

There ya go, as requested, and thx in advance

funhacker · 03/29/2012, 21:14

Fix your cq_totem_pole_type:

Code:

delete from cq_totem_pole_type;

insert into cq_totem_pole_type
values
(1,1071000,1),
(2,1071010,1),
(3,1071020,1),
(4,1071160,1),
(5,1071150,1),
(6,1071140,1),
(7,1071130,1),
(8,1071120,1),
(9,1071470,1),
(10,1071480,1),
(11,1071040,1),
(12,1071050,1),
(13,1071410,1),
(14,1071400,1),
(15,1071080,1),
(16,1071090,1),
(17,1071330,1),
(18,1071200,2),
(19,1071210,2),
(20,1071220,2),
(21,1071660,2),
(22,1071650,2),
(23,1071640,2),
(24,1071630,2),
(25,1071620,2),
(26,1071300,2),
(27,1071570,2),
(28,1071580,2),
(29,1071240,2),
(30,1071510,2),
(31,1071500,2),
(32,1071290,2),
(33,1071700,3),
(34,1071710,3),
(35,1071930,3),
(36,1071920,3),
(37,1071280,3),
(38,1071270,3),
(39,1071260,3),
(40,1071250,3),
(41,1071190,3),
(42,1071180,3),
(43,1071100,3),
(44,1071110,3),
(45,1071600,3),
(46,1071610,3),
(47,1071490,3),
(48,1071590,3),
(49,1071840,3),
(50,1071850,3),
(51,1071310,3),
(52,1071320,3),
(53,1071420,3),
(54,1071360,3),
(55,1071370,3),
(56,1071380,3),
(57,1071390,3),
(58,1071170,3),
(59,1071030,3),
(60,1071720,3),
(61,1071730,3),
(62,1071950,3),
(63,1071940,3),
(64,1071900,3),
(65,1071910,3),
(66,1071770,3),
(67,1071760,3);

New TotemPole.ini

Code:

~~karnyge~~ · 03/30/2012, 00:21

Thank you for that Funhacker, but its not fixed the totems.
They are all still invisible, the slider wont move and the tabs are unselectable.

funhacker · 03/30/2012, 01:56

Quote:

Originally Posted by karnyge

Thank you for that Funhacker, but its not fixed the totems.
They are all still invisible, the slider wont move and the tabs are unselectable.

Sadly I can't say for sure what's gone wrong with your client/server then, because it should work fine to the best of my knowledge with what I gave you

Sorry. Modify your SynTotemPillar.ini
You have Special Amount = 36 when it should be 35

~~karnyge~~ · 03/30/2012, 02:30

Nope, didnt work
Thanks for trying though.

I have TeamViewer7, if you wanna try that?

funhacker · 03/30/2012, 15:42

Quote:

Originally Posted by karnyge

Nope, didnt work
Thanks for trying though.

I have TeamViewer7, if you wanna try that?

mmm I can't see why it wouldn't work. Something must be very wrong with your client. I don't understand why you're not using an english client for starters.
Why not use a

instead?
You're free to use it if you wish

~~karnyge~~ · 03/30/2012, 17:37

Thanks again for the effort.

I redownloaded the client and Db. Did all the oems and configs etc, because i began to experience another issue. Both the totems and the other issues are now fixed.