Title System// Job System

[nybo94]

Hey Ragezone

I am looking for someone the job system and title system sold or can give me tips.

thank you for your attention

[MentaL]

[Royalblade]

Normally I would say.. add me on skype:akasch93 and I'll sell you one. But since that's not allowed here, let me help ya.

Check the table _CharTrijob. You will find a column called Contribution. The contribution that you get is equal to the amount of gold that you get.
Just let people trade and go jobbing as usual.
At logoff you check the contribution column and divide it by XXXX. That will be your rate simply. For example... Char: ABC has 100 Contribution. You make the XXXX (Divider) = 50. Then the char will receive 2 coins or w/e. You can OFC make a custom rate for each job. _CharTrijob has a column called JobType.
1 = Trader,
2 = Thief,
3 = Hunter.

That way you can distinguish between them and set a different rate for each one based on the jobtype. Should be pretty easy to do and pretty easily cheatable by thieves. however, its the basic idea for a "job system".

For a title system its similiar...
For Dummies... use evangelion or srzor made by Chernobyl, available for free if you search around. They both have a uniquekill logger. On the unique kill table.. create a trigger and do a IF statement for each unique and give a title that way. Pretty easy and hard to fail at.

That's the BASIC idea meaning that its CRAP and will be SLOW as fuck. I dont recommend it. BUT it will work.

[Molten]

@Royalblade, I see what you did there

[nybo94]

Thanks Royalblade

[OutOfMemory]

Normally I would say.. add me on skype:akasch93 and I'll sell you one. But since that's not allowed here, let me help ya.

You already did :D

[mostafakajo10]

The King RoyalBlade :)

[Mixizi]

Normally I would say.. add me on skype:akasch93 and I'll sell you one. But since that's not allowed here, let me help ya.

Check the table _CharTrijob. You will find a column called Contribution. The contribution that you get is equal to the amount of gold that you get.
Just let people trade and go jobbing as usual.
At logoff you check the contribution column and divide it by XXXX. That will be your rate simply. For example... Char: ABC has 100 Contribution. You make the XXXX (Divider) = 50. Then the char will receive 2 coins or w/e. You can OFC make a custom rate for each job. _CharTrijob has a column called JobType.
1 = Trader,
2 = Thief,
3 = Hunter.

That way you can distinguish between them and set a different rate for each one based on the jobtype. Should be pretty easy to do and pretty easily cheatable by thieves. however, its the basic idea for a "job system".

For a title system its similiar...
For Dummies... use evangelion or srzor made by Chernobyl, available for free if you search around. They both have a uniquekill logger. On the unique kill table.. create a trigger and do a IF statement for each unique and give a title that way. Pretty easy and hard to fail at.

That's the BASIC idea meaning that its CRAP and will be SLOW as fuck. I dont recommend it. BUT it will work.

If they know what is a trigger in SQL hehe..

[nybo94]

USE [SRO_VT_Mixizi]
GO
/****** Object: Trigger [dbo].[_Mixizi] Script Date: 14.04.2014 13:26:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[_Mixizi]
ON [dbo].[_Cocksize]
FOR INSERT
AS
DECLARE @B1tchname VARCHAR(32),
@cocksize VARCHAR(64);

SELECT @Charname = CharName,
@cocksize = cocksize
FROM inserted


EXEC SRO_VT_SHARD.dbo.[_Mixizib1tch] @B1tchname, @cocksize

nice day :)

[Mixizi]

nice day :)

Haha I liked ! Really ! It wasn't specially for you, it was for all the server who pretend to have "developper" and they don't even know how is a trigger.

[nybo94]

Haha I liked ! Really ! It wasn't specially for you, it was for all the server who pretend to have "developper" and they don't even know how is a trigger.

I hope you understand fun