Questions that require answers, please.

03/25/2012 17:34 karnyge#1
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.
03/25/2012 17:57 funhacker#2
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
03/25/2012 18:44 karnyge#3
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.
03/26/2012 07:11 funhacker#4
Quote:
Originally Posted by karnyge View Post
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.
03/29/2012 16:25 karnyge#5
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.
03/29/2012 17:52 funhacker#6
Paste your totempole.ini here and I will give you a query to fix your table
Also paste your syntotempillar.ini here too
03/29/2012 18:46 karnyge#7
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 ½ðÅ£ÐdzµÏ
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 ʨ×ÓÐDZùâÊÞ
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:
1	1071000	
2	1071010	
3	1071020	
4	1071160	
5	1071150	
6	1071140	
7	1071130	
8	1071120	
9	1071470	
10	1071480	
11	1071040	
12	1071050	
13	1071410	
14	1071400	
15	1071080	
16	1071090	
17	1071330	
18	1071200	
19	1071210	
20	1071220	
21	1071660	
22	1071650	
23	1071640	
24	1071630	
25	1071620	
26	1071300	
27	1071570	
28	1071580	
29	1071240	
30	1071510	
31	1071500	
32	1071290	
33	1071700	
34	1071710	
35	1071930	
36	1071920	
37	1071280	
38	1071270	
39	1071260	
40	1071250	
41	1071190	
42	1071180	
43	1071100	
44	1071110	
45	1071600	
46	1071610	
47	1071490	
48	1071590	
49	1071840	
50	1071850	
51	1071310	
52	1071320	
53	1071420	
54	1071520	
55	1071360	
56	1071370	
57	1071380	
58	1071390	
59	1071170	
60	1071030	
61	1071720	
62	1071730	
63	1071950	
64	1071940	
65	1071900	
66	1071910	
67	1071770	
68	1071760
There ya go, as requested, and thx in advance
03/29/2012 21:14 funhacker#8
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:
1 1071000 
2 1071010 
3 1071020 
4 1071160 
5 1071150 
6 1071140 
7 1071130 
8 1071120 
9 1071470 
10 1071480 
11 1071040 
12 1071050 
13 1071410 
14 1071400 
15 1071080 
16 1071090 
17 1071330 
18 1071200 
19 1071210 
20 1071220 
21 1071660 
22 1071650 
23 1071640 
24 1071630 
25 1071620 
26 1071300 
27 1071570 
28 1071580 
29 1071240 
30 1071510 
31 1071500 
32 1071290 
33 1071700 
34 1071710 
35 1071930 
36 1071920 
37 1071280 
38 1071270 
39 1071260 
40 1071250 
41 1071190 
42 1071180 
43 1071100 
44 1071110 
45 1071600 
46 1071610 
47 1071490 
48 1071590 
49 1071840 
50 1071850 
51 1071310 
52 1071320 
53 1071420 
54 1071360 
55 1071370 
56 1071380 
57 1071390 
58 1071170 
59 1071030 
60 1071720 
61 1071730 
62 1071950 
63 1071940 
64 1071900 
65 1071910 
66 1071770 
67 1071760
03/30/2012 00:21 karnyge#9
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.
03/30/2012 01:56 funhacker#10
Quote:
Originally Posted by karnyge View Post
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
03/30/2012 02:30 karnyge#11
Nope, didnt work
Thanks for trying though.

I have TeamViewer7, if you wanna try that?
03/30/2012 15:42 funhacker#12
Quote:
Originally Posted by karnyge View Post
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 [Only registered and activated users can see links. Click Here To Register...] instead?
You're free to use it if you wish
03/30/2012 17:37 karnyge#13
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.