Siege Pwer

Printable View

31-01-11
Casper112

Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

Hi there Dev's,

I finnaly managed to make my clan system working

Things that work :

- Creating clan
- Disband clan
- Expel Player
- Delegate Vice/Leader
- ClanList Ingame/Forum(sandurrs website)
- Clan Chat
- Clan Logo

- Sod register me as Sod Owner

- BC register me as BC Owner

Few things that dont work atm :

- Sod Tax
- Sod Ranks Ingame/Forum(Sandurrs Website)

- Level Ranks Forum ( Only work when i manually transfer the levellist from RPTDB to AccountDB )

- BlessCastle Tax

- Siege power ( I can select the power at the management but no power will load )

What also works :

SOD SYSTEM RELATED

When i run ClanSodManager I can connect to my database. The numbers are counting up 1,2,3,4,5 etc

http://i54.tinypic.com/2gw5nnn.png

When i enter & finish sod nothing happenends in the manager...
(If im correct it suppose to give information in the 2 fields below? )
The counting just continue... No score Registerd. (according to this manager..)

Secretary Karina

http://i52.tinypic.com/oj095f.png

When i check Karina i see the following

- GM Clan master ( Hmm did it record my sod run?? )
- Lets check the rank.. ( Strange.. No score.. How can i be SoD Owner? )
- Lets check the logs..

http://i53.tinypic.com/rbfspx.png

Hey! Event High Score! Why dont see i my score Ingame/Website?

Lets check the database..

Humm no log in the database... :S WTH... Whats wrong?

LevelList Related

When i run Multimanager, I setup my connection settings and get connected.
The account are transfer to ,''RPTDB'' Where the LevelList is located.

http://i52.tinypic.com/11rurnq.png

When i checked the website the level ranking wasnt there.. So i checked my database.

The website dont look for this database : RPTDB-> LevelList, it Looks for the AccountDB -> LevelList

So i manually transfer the list from RPTDB/LevelList -> ACCOUNTDB/LevelList

And the level ranking Shows at my website :
http://i55.tinypic.com/o0z5ah.png

I dont know any other solution fixing this, ( Im not a hero with scripts ), Maybe any1 here knows a solution?

Clan Manager 2.5

When i check clan manger 2.5
I can connect to the database :
I can load my clan, but here i see the SOD score isnt registerd...

http://i52.tinypic.com/24gruk7.png

When i check CLANDB / CL table Its empty...

When i manually add a random score there, it will be update in on my Wesbite and in-game Ranking..

-I guess after i finish sod, the score get registerd in the wrong place??
-Or not at all??
-How come Sod see me as SOD OWNER??

Bless Castle

Well i dinnt found much on this so any help would be welcome on the following things :

- Bless Castle Tax Money
- Bless Castle Siege Power

Maybe alot of questions, but your help is really needed here :thumbup::thumbup:

Thank you all
31-01-11
Casper112

Re: [HELP] Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

Update!

I remade my SodDB.. Now i have the following problem..

http://i55.tinypic.com/20jiz5u.jpg
02-02-11
Casper112

Re: [HELP] Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

Update 2:

Ok i renewed my sqldll.reg now i can collect tax money for karina..

The rank ingame still have the same error :

Char name [Img00000000001[TotalMoney].. etc etc

But when i check my logs now i see something is happening!!

---------------------------------------------------------------------------------------------------------------
204729|UPDATE CL SET ClanMoney=ClanMoney-150000000 WHERE Userid='casper'
204752|UPDATE CL SET ClanMoney=ClanMoney-12312323 WHERE Userid='casper'
204800|UPDATE CL SET ClanMoney=ClanMoney-1232321 WHERE Userid='casper'
204802|UPDATE CL SET ClanMoney=ClanMoney-1232323 WHERE Userid='casper'
204805|UPDATE CL SET ClanMoney=ClanMoney-1232312 WHERE Userid='casper'
204807|UPDATE CL SET ClanMoney=ClanMoney-223033 WHERE Userid='casper'
204810|UPDATE CL SET ClanMoney=ClanMoney-2100927 WHERE Userid='casper'
204939|insert into CharGameRecordLg (UserID, CharType, GameLogonID,GPCode, ServerName, IP, GameLevel, Exp, GameMoney, EditDay) values('casper',2, 'Cas','','OpT','127.0.0.1', 120, 1486549591616, 200284018, '02-02-2011 20:49:39')
210156|Login failed for user 'sa'.
210641|Login failed for user 'sa'.
210729|Login failed for user 'sa'.
210751|Login failed for user 'sa'.
212007|Login failed for user 'sa'.
212007|INSERT INTO SOD2RecBySandurr (UserID, CharName, CharType, Point, KillCount, GLevel, TotalPoint, TotalUser, SuccessUser, ServerName, PCRNo, GPCode, Contribute, RegistDay, BusinessName, BAddress1, PMNo, ServerTime) VALUES ('casper', 'Cas', 1, 681632, 103, 120, 681632, 1, 1, 'OpT', 0, '', 100, '02-02-2011 21:20:07', '','',0, 385875968)
212007|Login failed for user 'sa'.
212128|Login failed for user 'sa'.

------------------------------------------------------------------------------------------------------------------------------------------

I always logged in with sa, and never had problems..

The password + login ( sa ) are correct..

So how is it possible that login failed for user sa?
03-02-11
Rovarav

Re: Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

check your sod database code
04-02-11
Casper112

Re: Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

Well the problem is fixed..

- I did the following things and it worked straight away:

- Re-install sqlexpress/server
- Re-made databases
- Used the ''new'' sqldll.req i made before
- Created clean Sql.dll & Clan.dll

Now all working fine

Sod tax
sod crown
Sod ranking
BC tax
04-02-11
bobsobol

Re: Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

Thanks for sharing your final solution with us.
04-02-11
Casper112

Re: Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

Quote:

Originally Posted by bobsobol

Thanks for sharing your final solution with us.

No problem ;) It should be this way..!

Anyways i have to add the following to my solution..
Maybe it will help others in the future..

In the SqlDll.reg

edit the following :

Code:

"SODDbIP"="xxxx\SQLEXPRESS" "SODDbID"="sa" "SODDbPwd"=" password" "SODDbName"="Sod2DB" "SOD2DbIP"="xxxx\SQLEXPRESS" "SOD2DbID"="sa" "SOD2DbPwd"=" password" "SOD2DbName"="Sod2DB"

Into

Code:

"SODDbIP"="xxxx\SQLEXPRESS" "SODDbID"="sa" "SODDbPwd"="password" "SODDbName"="Sod2DB" "SOD2DbIP"="xxxx\SQLEXPRESS" "SOD2DbID"="sa" "SOD2DbPwd"=" password" "SOD2DbName"="SodDB"

This will make show up the Sod ranks on your website

Level Ranking Sandurss Website

When you use the multimanager, the data will be transfered to rPTDB-> Levellist

The website of sandurr is looking to AccountDB -> Levellist

So there will be no result on the website. unless...

1. You manually transfer the data from rPTDB -> LevelList TO AccountDB -> Levellist

2. You can also try to edit the website scripts to they read the data from AccountDB -> Levelist
09-02-11
Casper112

Re: Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

Hi again,

Well after i fixed the problem sod worked fine for a few days.

Only yesterday sod was bugged again, and i dont know what happenend :S

i got again this error

Code:

212007|INSERT INTO SOD2RecBySandurr (UserID, CharName, CharType, Point, KillCount, GLevel, TotalPoint, TotalUser, SuccessUser, ServerName, PCRNo, GPCode, Contribute, RegistDay, BusinessName, BAddress1, PMNo, ServerTime) VALUES ('casper', 'Cas', 1, 681632, 103, 120, 681632, 1, 1, 'OpT', 0, '', 100, '02-02-2011 21:20:07', '','',0, 385875968)

Thats the only message i got from BillingDBError

Before he gave me the message Login failed for user ''sa'' so i remake my sql.dll.reg and it worked, now thats not the case..

I remade my database ( like i did before ) but the error keep poppin up..

So i dont have any clue whats going on..

Hope any of you guys can help me out
09-02-11
Gregoo

Re: Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

Quote:

Originally Posted by Casper112

Code:

212007|INSERT INTO SOD2RecBySandurr (UserID, CharName, CharType, Point, KillCount, GLevel, TotalPoint, TotalUser, SuccessUser, ServerName, PCRNo, GPCode, Contribute, RegistDay, BusinessName, BAddress1, PMNo, ServerTime) VALUES ('casper', 'Cas', 1, 681632, 103, 120, 681632, 1, 1, 'OpT', 0, '', 100, '02-02-2011 21:20:07', '','',0, 385875968)

Copy the request and execute it directly on your SQL server, with a tool like SSMSE (SQL Server Management Studio Express).
It'll tell you exactly why it fails to insert it inside the database.
10-02-11
Casper112

Re: Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

Quote:

Originally Posted by Gregoory

Copy the request and execute it directly on your SQL server, with a tool like SSMSE (SQL Server Management Studio Express).
It'll tell you exactly why it fails to insert it inside the database.

Well i did that sod ranks are working now again, but now i have another weird problem..

When 2 characters see eachother one will dc, and sometimes both..

but that only happenends when they see eachother..
when they both in different maps no-one will dc...

I seen a post from vormav that he had this problem also with a jpt server..
His solution was open port, I tried every port i see poppin up ( tpc view) but i still get the dc, i dont have any clue, and maybe open ports isnt the solution for me..
Anyways i will make a movie recording my tcp view when i try to log with 2 character maybe you guys see something i miss..
10-02-11
Casper112

Re: Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

hehe While i was editing above msg, i though about refreshing my port forward table..
Because i tried alot and it was a bit messy...

Well.. It worked ^^ No more dc's ( Atleast for now )

Sod ranks etc also works again ^^
21-11-11
oracl3

Re: [HELP] Sod Ranks Forum/In-game & Tax SoD/Bless Castle / Siege Pwer

Quote:

Originally Posted by Casper112

Update 2:

Ok i renewed my sqldll.reg now i can collect tax money for karina..

The rank ingame still have the same error :

Char name [Img00000000001[TotalMoney].. etc etc

But when i check my logs now i see something is happening!!

---------------------------------------------------------------------------------------------------------------
204729|UPDATE CL SET ClanMoney=ClanMoney-150000000 WHERE Userid='casper'
204752|UPDATE CL SET ClanMoney=ClanMoney-12312323 WHERE Userid='casper'
204800|UPDATE CL SET ClanMoney=ClanMoney-1232321 WHERE Userid='casper'
204802|UPDATE CL SET ClanMoney=ClanMoney-1232323 WHERE Userid='casper'
204805|UPDATE CL SET ClanMoney=ClanMoney-1232312 WHERE Userid='casper'
204807|UPDATE CL SET ClanMoney=ClanMoney-223033 WHERE Userid='casper'
204810|UPDATE CL SET ClanMoney=ClanMoney-2100927 WHERE Userid='casper'
204939|insert into CharGameRecordLg (UserID, CharType, GameLogonID,GPCode, ServerName, IP, GameLevel, Exp, GameMoney, EditDay) values('casper',2, 'Cas','','OpT','127.0.0.1', 120, 1486549591616, 200284018, '02-02-2011 20:49:39')
210156|Login failed for user 'sa'.
210641|Login failed for user 'sa'.
210729|Login failed for user 'sa'.
210751|Login failed for user 'sa'.
212007|Login failed for user 'sa'.
212007|INSERT INTO SOD2RecBySandurr (UserID, CharName, CharType, Point, KillCount, GLevel, TotalPoint, TotalUser, SuccessUser, ServerName, PCRNo, GPCode, Contribute, RegistDay, BusinessName, BAddress1, PMNo, ServerTime) VALUES ('casper', 'Cas', 1, 681632, 103, 120, 681632, 1, 1, 'OpT', 0, '', 100, '02-02-2011 21:20:07', '','',0, 385875968)
212007|Login failed for user 'sa'.
212128|Login failed for user 'sa'.

------------------------------------------------------------------------------------------------------------------------------------------

I always logged in with sa, and never had problems..

The password + login ( sa ) are correct..

So how is it possible that login failed for user sa?

the date that is in the sample follows the pattern of Brazil Date

dd/mm/yyyy

different from the date the United States

mm/dd/yyyy

the most correct is to use Windows in English and English MsSQL to set up your server Priston

is certainly being used in windows and MsSQL in Portuguese Portuguese

to correct this problem

using windows in Portuguese and Portuguese in MsSQL

perform the following change in the database Sod2DB

SOD2RecBySandurr RegistDay field in the table is being used as datetime, change to varchar (50)

so the points will be inserted automatically