Top Duel [ 4FUNer coding request ]

Quote:

---

Originally Posted by 4FUNer

No comment, i talk about TABLE not stored procedure.
http://i39.tinypic.com/s2zkgl.png

Stored procedure already appear on list, so execute fkn query for TABLE

Code:

---

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DUEL_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DUEL_INFO]
GO

CREATE TABLE [dbo].[DUEL_INFO] (
        [ID] [int] IDENTITY (1, 1) NOT NULL ,
        [ServerCode] [int] NOT NULL ,
        [Account] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,
        [Name] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,
        [Win] [int] NOT NULL ,
        [Lost] [int] NOT NULL ,
        [Average] [int] NOT NULL
) ON [PRIMARY]
GO

---

and don't touch anything, just restart sql manager & check if duel data will apear IN TABLE DUEL INFO!!

if you don't understand then fk it.

---

DONE !!!

http://img834.imageshack.us/img834/2787/270s.png

Can I have the MuCore module now ?

PS : I did that 1000x times but I don't know what I was doing wrong.

Not done, who said it's working, so bored to explain for the 1000 time

Go in-game do 2 duels, then close fkn game & check DUEL_INFO if data will appear like

1 0 acc nick 1 0 XXX
2 0 acc nick 0 1 XXX

anw back to home take my ranking & test
http://i40.tinypic.com/2qun5ef.png
(my average isn't based on tt one, so i removed to read from DB)

Add in Custom_Rankings_cfg.php -->

Code:

---

$corecr['TopDuelTop'] = "15";
$corecr['TDCronJobID'] = "26"; // Cron Job ID
$corecr['TDCronJobStatus'] = "0"; // 1 = ON, 0 = OFF
$corecr['TopDuelStyle'] = "1";

---

& add topduel.php in page_modules

Download
Top Duel.rar download - 2shared

Sad to say it DID NOT WORK ! [ I had some free time today to test duels in game ]

Made 3 duels in game :

http://img856.imageshack.us/img856/8751/rg8x.png

And more details :

http://img812.imageshack.us/img812/3827/ifsk.png

&

http://img855.imageshack.us/img855/2140/rbzt.png

Where is the problem, Martin ? Can we still make this module work ?

Thank you in advance !

Are you sure ur dataservers use Ranking DB ?

Anw request was for ranking, so you have ranking, about rest i don't care to check since i don't use TT files anymore.

Contact betox or wait for some1 who use tt files with top duel rank.

Quote:

---

Originally Posted by 4FUNer

Are you sure ur dataservers use Ranking DB ?

Anw request was for ranking, so you have ranking, about rest i don't care to check since i don't use TT files anymore.

Contact betox or wait for some1 who use tt files with top duel rank.

---

So the module won't work if the only thing I get in duel_info is null ... ?

http://img703.imageshack.us/img703/6396/gck7.png

So how can I describe this, Martin, the duels are not saved on my duel_info table in Ranking database ? So the module cannot extract data from database.

PS : Martin, send me a private message with your Skype name / Yahoo / MSN / Email or something where I can contact you, maybe give you team viewer ID and PASS so you can check my files if you don't have it anymore. I really want to add this module.

PS 2 : I'm not the type of guy spamming or sending multiple help requests so you are safe :))

PS 3 : I've fount the DUEL_INFO file in MuOnline database too :

http://img51.imageshack.us/img51/2162/wsg5.png

So I can find DUEL_INFO in Ranking database / tables & MuOnline database / tables.

Read x times, i said are u sure if ur dataservers use Ranking DB, since Original TT DB Updater install

DUEL_INFO + Procedure in Ranking DB...
http://i40.tinypic.com/i6h9o6.png

Here you have original scripts to install with TT DB Updater.exe
TitanDBUpdater.rar download - 2shared

Not my fault if you can't make it work.

abt duelinfo in MuOnline db
a) you've executed query on this db
b) maybe ur dataservers use MuOnline DB instead of Ranking so check

I don't have time for teamviewers, i have my own life.

Quote:

---

Originally Posted by 4FUNer

Read x times, i said are u sure if ur dataservers use Ranking DB, since Original TT DB Updater install

DUEL_INFO + Procedure in Ranking DB...
http://i40.tinypic.com/i6h9o6.png

Here you have original scripts to install with TT DB Updater.exe
TitanDBUpdater.rar download - 2shared

Not my fault if you can't make it work.

abt duelinfo in MuOnline db
a) you've executed query on this db
b) maybe ur dataservers use MuOnline DB instead of Ranking so check

I don't have time for teamviewers, i have my own life.

---

I am not sure if my dataserver uses Ranking database, because I don't know how to check !

You give me advance things to do and I have more to learn, that's why ... I can't make it work but I will.

Yes I think I've executed the query to MuOnline DB too, to be sure so I have it in Ranking DB and in MuOnline DB.

About that .tdu files you gave me, what do I do with them ? How to use them ?

Please answer when you're not that nervous as today :D Have a nice day, Martin.

EDIT :

1. I did remove duel_info form MuOnline DB & Ranking DB.

2. Removed the TT_DuelScore from Ranking DB / Stored procedures.

3. Restarted SQL

4. Started SQL and went to Query Executions, selected Ranking DB.

5. Pasted the DUEL_INFO query, hit EXECUTE, MSG Successful.

6. SAVED ALL

7. Started SQL and went to Query Executions, selected Ranking DB.

8. Pasted the PROCEDURE query, hit EXECUTE, MSG Successful.

9. SAVED ALL

10. Restart SQL

11. Made 2 duels in game.

12. Check the DUEL_INFO table, all NULL - NOT WORKING

13. Read all your info 10x times and did it all again - Still NOT WORKING.

:(

About DUEL_INFO in MuOnline , check it and got NULLED too so its the same.

About Original TT DB Updater install , what is this ? I don't have it !

About " are u sure if ur dataservers use Ranking DB ? " - I DON'T KNOW BECAUSE I DON'T KNOW HOW TO CHECK !

DS db usage -> TitanLinkServer config for newest versions, tt db updater come in original tt package, shud be in some repack.

anw fk it

Downloaded TT repack to check if there's some cfg for duel & found one

Check SCFData/SCF_Ranking

SCFIsDuelSaveInDB=0

Must be set to 1 (SCFIsDuelSaveInDB=1)

also remember about
SCFIsDuelLevelDiferenceForSaveCheck=0
SCFDuelLevelDiferenceForSave=20
SCFIsDuelResetDiferenceForSaveCheck=0
SCFDuelResetDiferenceForSave=20

then test again.

Quote:

---

Originally Posted by 4FUNer

DS db usage -> TitanLinkServer config for newest versions, tt db updater come in original tt package, shud be in some repack.

anw fk it

Downloaded TT repack to check if there's some cfg for duel & found one

Check SCFData/SCF_Ranking

SCFIsDuelSaveInDB=0

Must be set to 1 (SCFIsDuelSaveInDB=1)

also remember about
SCFIsDuelLevelDiferenceForSaveCheck=0
SCFDuelLevelDiferenceForSave=20
SCFIsDuelResetDiferenceForSaveCheck=0
SCFDuelResetDiferenceForSave=20

then test again.

---

That's my pro Martin ! working !

Everything looks ok ?

http://img69.imageshack.us/img69/8477/8mcp.png

Thank you !

Quote:

---

Originally Posted by epocal

That's my pro Martin ! working !

Everything looks ok ?

Thank you !

---

Glad it works & yea everything is ok, next time check configs i dun like to search for shit :)

HF