Special Monarch System + Fixx

~~TheDestroyer™~~ · 09/15/2011, 08:22

Hello com ,
First we'll open navicat,
And open player database
Then look at the right side
And change : monarch_candidicy replace that table name to monarch_candid
And add dif code to db
------------
1866er :
------------

Code:

This difference file is created by aNNdii and Hazel

db_1866
00092873: 65 61
00092874: 6D 2E
00092875: 70 65
00092876: 69 6D
00092877: 72 70
00092878: 65 69
00092879: 2C 72
0009287A: 20 65
0009287B: 70 2C
0009287C: 69 61
0009287D: 64 2E
0009287E: 2C 70
0009287F: 20 69
00092880: 6E 64
00092881: 61 2C
00092882: 6D 62
00092883: 65 2E
00092884: 2C 6E
00092885: 20 61
00092887: 6F 65
00092888: 6E 2C
00092889: 65 61
0009288A: 79 2E
0009288B: 2C 6D
0009288C: 20 6F
0009288D: 77 6E
0009288E: 69 65
0009288F: 6E 79
00092890: 64 2C
00092892: 74 2E
00092893: 65 77
00092894: 20 69
00092895: 46 6E
00092896: 52 64
00092897: 4F 61
00092898: 4D 74
00092899: 20 65
0009289A: 6D 20
0009289B: 6F 46
0009289C: 6E 52
0009289D: 61 4F
0009289E: 72 4D
0009289F: 63 20
000928A0: 68 6D
000928A1: 20 6F
000928A2: 61 6E
000928A3: 2C 61
000928A4: 20 72
000928A5: 70 63
000928A6: 6C 68
000928A7: 61 20
000928A8: 79 61
000928A9: 65 2C
000928AA: 72 20
000928AB: 25 70
000928AC: 73 6C
000928AD: 20 61
000928AE: 62 79
000928AF: 20 65
000928B0: 77 72
000928B1: 68 25
000928B2: 65 73
000928B3: 72 20
000928B4: 65 62
000928B6: 61 57
000928B7: 2E 48
000928B8: 70 45
000928B9: 69 52
000928BA: 64 45
000928BB: 3D 20
000928BC: 62 61
000928BE: 69 70
000928BF: 64 69
000928C0: 00 64
000928C1: 00 20
000928C2: 00 3D
000928C3: 00 20
000928C4: 5B 62
000928C5: 4C 2E
000928C6: 4F 69
000928C7: 41 64
000928C8: 44 00
000928C9: 5F 5B
000929C7: 70 61
000929C8: 69 2E
000929C9: 64 70
000929CA: 2C 69
000929CB: 20 64
000929CC: 6E 2C
000929CD: 61 62
000929CE: 6D 2E
000929CF: 65 6E
000929D0: 2C 61
000929D1: 20 6D
000929D2: 64 65
000929D3: 61 2C
000929D4: 74 61
000929D5: 65 2E
000929D6: 20 64
000929D7: 46 61
000929D8: 52 74
000929D9: 4F 65
000929DA: 4D 20
000929DB: 20 46
000929DC: 6D 52
000929DD: 6F 4F
000929DE: 6E 4D
000929DF: 61 20
000929E0: 72 6D
000929E1: 63 6F
000929E2: 68 6E
000929E3: 5F 61
000929E4: 63 72
000929E5: 61 63
000929E6: 6E 68
000929E7: 64 5F
000929E8: 69 63
000929E9: 64 61
000929EA: 61 6E
000929EB: 63 64
000929EC: 79 69
000929ED: 20 64
000929EF: 2C 63
000929F0: 20 79
000929F1: 70 20
000929F2: 6C 61
000929F3: 61 2C
000929F4: 79 70
000929F5: 65 6C
000929F6: 72 61
000929F7: 25 79
000929F8: 73 65
000929F9: 20 72
000929FA: 62 25
000929FB: 20 73
000929FC: 77 20
000929FD: 68 62
000929FE: 65 20
000929FF: 72 57
00092A00: 65 48
00092A01: 20 45
00092A02: 61 52
00092A03: 2E 45
00092A04: 70 20
00092A05: 69 61
00092A06: 64 2E
00092A07: 20 70
00092A08: 3D 69
00092A09: 20 64
00092A0A: 62 20
00092A0B: 2E 3D
00092A0C: 69 20
00092A0D: 64 62
00092A0E: 00 2E
00092A0F: 00 69
00092A10: 5B 64
00092A11: 4C 00
00092A12: 4F 5B
00092A13: 41 4D
00092A14: 44 4F

------------
1667er
------------

Code:

This difference file is created by aNNdii

db_r1667
0009298B: 65 61
0009298C: 6D 2E
0009298D: 70 65
0009298E: 69 6D
0009298F: 72 70
00092990: 65 69
00092991: 2C 72
00092992: 20 65
00092993: 70 2C
00092994: 69 61
00092995: 64 2E
00092996: 2C 70
00092997: 20 69
00092998: 6E 64
00092999: 61 2C
0009299A: 6D 62
0009299B: 65 2E
0009299C: 2C 6E
0009299D: 20 61
0009299F: 6F 65
000929A0: 6E 2C
000929A1: 65 61
000929A2: 79 2E
000929A3: 2C 6D
000929A4: 20 6F
000929A5: 77 6E
000929A6: 69 65
000929A7: 6E 79
000929A8: 64 2C
000929AA: 74 2E
000929AB: 65 77
000929AC: 20 69
000929AD: 46 6E
000929AE: 52 64
000929AF: 4F 61
000929B0: 4D 74
000929B1: 20 65
000929B2: 6D 20
000929B3: 6F 46
000929B4: 6E 52
000929B5: 61 4F
000929B6: 72 4D
000929B7: 63 20
000929B8: 68 6D
000929B9: 20 6F
000929BA: 61 6E
000929BB: 2C 61
000929BC: 20 72
000929BD: 70 63
000929BE: 6C 68
000929BF: 61 20
000929C0: 79 61
000929C1: 65 2C
000929C2: 72 20
000929C3: 25 70
000929C4: 73 6C
000929C5: 20 61
000929C6: 62 79
000929C7: 20 65
000929C8: 77 72
000929C9: 68 25
000929CA: 65 73
000929CB: 72 20
000929CC: 65 62
000929CE: 61 57
000929CF: 2E 48
000929D0: 70 45
000929D1: 69 52
000929D2: 64 45
000929D3: 3D 20
000929D4: 62 61
000929D6: 69 70
000929D7: 64 69
000929D8: 00 64
000929D9: 00 20
000929DA: 00 3D
000929DB: 00 20
000929DC: 5B 62
000929DD: 4C 2E
000929DE: 4F 69
000929DF: 41 64
000929E0: 44 00
000929E1: 5F 5B
00092ADF: 70 61
00092AE0: 69 2E
00092AE1: 64 70
00092AE2: 2C 69
00092AE3: 20 64
00092AE4: 6E 2C
00092AE5: 61 62
00092AE6: 6D 2E
00092AE7: 65 6E
00092AE8: 2C 61
00092AE9: 20 6D
00092AEA: 64 65
00092AEB: 61 2C
00092AEC: 74 61
00092AED: 65 2E
00092AEE: 20 64
00092AEF: 46 61
00092AF0: 52 74
00092AF1: 4F 65
00092AF2: 4D 20
00092AF3: 20 46
00092AF4: 6D 52
00092AF5: 6F 4F
00092AF6: 6E 4D
00092AF7: 61 20
00092AF8: 72 6D
00092AF9: 63 6F
00092AFA: 68 6E
00092AFB: 5F 61
00092AFC: 63 72
00092AFD: 61 63
00092AFE: 6E 68
00092AFF: 64 5F
00092B00: 69 63
00092B01: 64 61
00092B02: 61 6E
00092B03: 63 64
00092B04: 79 69
00092B05: 20 64
00092B07: 2C 63
00092B08: 20 79
00092B09: 70 20
00092B0A: 6C 61
00092B0B: 61 2C
00092B0C: 79 20
00092B0D: 65 70
00092B0E: 72 6C
00092B0F: 25 61
00092B10: 73 79
00092B11: 20 65
00092B12: 62 72
00092B13: 20 25
00092B14: 77 73
00092B15: 68 20
00092B16: 65 62
00092B17: 72 20
00092B18: 65 57
00092B19: 20 48
00092B1A: 61 45
00092B1B: 2E 52
00092B1C: 70 45
00092B1D: 69 20
00092B1E: 64 61
00092B1F: 20 2E
00092B20: 3D 70
00092B21: 20 69
00092B22: 62 64
00092B23: 2E 20
00092B24: 69 3D
00092B25: 64 20
00092B26: 00 62
00092B27: 00 2E
00092B28: 5B 69
00092B29: 4C 64
00092B2A: 4F 00
00092B2B: 41 00
00092B2C: 44 00
00092B2D: 5F 5B

Dif codes by :.aNNdii# and .Hazel
Thank you .aNNdii# and .Hazel

That's New Monarch Quest :

PHP Code:


			
quest monarch begin
        state start begin

                when electionman1.chat."GM: Emperor election adjustments"
                or  electionman2.chat."GM: Emperor election adjustments"
                or electionman3.chat."GM: Emperor election adjustments" with pc.is_gm()  begin

                        if game.get_event_flag("Emperor Election") == 1 then
                                say("Here you can end the Emperor election.")
                                say("Do you want to end the Emperor election now?")
                                local s = select("End.","Don't end")

                                if s == 1 then
                                        game.set_event_flag("Emperor",0)
                                end
                        else
                                say("Here you can start the Emperor election.")
                                say("Do you want to start the Emperor election now?")
                                local s = select("Start","Don't start")

                                if s == 1 then
                                        game.set_event_flag("Emperor",1)
                                end

                        end

                end

                when electionman1.chat."GM: Emperor election adjustments"
                or  electionman2.chat."GM: Emperor election adjustments"
                or electionman3.chat."GM: Emperor election adjustments" with pc.is_gm()  begin

                        if game.get_event_flag("Emperor election") == 1 then
                                say("Here you can end the Emperor election.")
                                say("Do you want to end the Emperor election now?")
                                local s = select("End.","Don't end")

                                if s == 1 then
                                        game.set_event_flag("Emperor election",0)
                                end
                        else
                                say("Here you can start the Emperor election.")
                                say("Do you want to start the Emperor election now?")
                                local s = select("Start","Don't start")

                                if s == 1 then
                                        game.set_event_flag("Emperor election",1)
                                end

                        end

                end


                when electionman1.chat."Select an Emperor"
                or electionman2.chat."Select an Emperor"
                or electionman3.chat."Select an Emperor"  begin


                        if  game.get_event_flag("Emperor election") != 1 then


                                say("The election has not started yet.")
                                say("Please try again when the elections have started.")
                                return
                        end
                        local g = oh.candidacy_list()
                        local gname_table = {}

                        table.foreachi(g,
                        function(n, p)
                                gname_table[n] = n.."."..oh.candidacy_name(n-1)
                        end)

                        if table.getn(g) == 0 then
                                -- no currently war
                                say("There are no candidates")
                        else
                                gname_table[table.getn(g)+1] = locale.cancel
                                say("Here you can vote for an Emperor.")
                                say("During the Emperor elections the nations leave aside their own differences.")
                                say("Please vote carefully.")
                                say("You can only vote once.")
                                say("Please vote on one of the candidates")
                                wait()
                                local s = select_table(gname_table)

                                if s == table.getn(gname_table) then
                                        return;
                                else
                                        ret = oh.election( s -1 )

                                        say(oh.candidacy_name(s-1).."You voted")
                                end
                        end
                end
                when electionman1.chat."Show the Emperor candidates"
                or electionman2.chat."Show the Emperor candidates"
                or electionman3.chat."Show the Emperor candidates"  begin

                        if  game.get_event_flag("Emperor") != 1 then
                                say("The following requirements are necessary for")
                                say("an Emperor.")
                                say("")
                                say_reward("1. An election fee of 1 million Gold.")
                                say_reward("2. You have to be Guild leader or 2nd Guild leader")
                                say_reward("3. Level 50 must be reached.")

                                say("")
                                say("But the election period has not yet started.")
                                say("Return when it has begun.")
                                return
                        end
                        say("You are able to participate in the elections,")
                        say("but as a candidate you need the following requirements:")
                        say("")
                        say_reward("1. An election fee of 1 million Gold.")
                        say_reward("2. You have to be Guild leader or 2nd Guild leader")
                        say_reward("3. Level 50 must be reached.")

                        say("")
                        say("Do you want to participate in the election?")

                    local s = select("Yes, I want to participate. ","No thanks")

                        local NEED_MONEY = 100000000

                        if s == 1 then
                                if oh.candidacycount() >= 8 then
                                        say("We are sorry.")
                                        say("We have enough candidates.")
                                        say("Try again at the next election.")
                                        return
                                end
                                if pc.get_gold() >= NEED_MONEY and pc.get_level() >= 50 and oh.isguildmaster() == 1 then

                                        pc.change_gold(-NEED_MONEY);
                                        oh.candidacy();
                                end
                        end
                end
        end
end

TheDestroyer™ ~ Please click thanks button!

~LuckyStrike~ · 09/15/2011, 08:33

I dont use this but its helpfull for other people ty.

~~TheDestroyer™~~ · 09/15/2011, 08:34

no problem ^^
its official ymir monarch quest

~~lautlosertot~~ · 09/15/2011, 08:35

pls translate the quest ti german xD

Ramblow · 09/15/2011, 08:37

sieht nice aus..

Quote:

pls translate the quest ti german xD

^this

~~TheDestroyer™~~ · 09/15/2011, 08:41

Quote:

Originally Posted by lautlosertot

pls translate the quest ti german xD

My German's language is very bad ^^

.Risan. · 09/15/2011, 09:21

Does not get Lua Error ..
If I choose to imagine or want to show the voters.

Db syserror:

PHP Code:


			
SYSERR: Sep 15 09:17:27 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Sep 15 09:17:27 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.monarch_candidacy' doesn't exist
query: SELECT a.pid,b.name,a.date FROM monarch_candidacy a, player b WHERE a.pid = b.id
SYSERR: Sep 15 09:17:27 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT a.pid,b.name,a.date FROM monarch_candidacy a, player b WHERE a.pid = b.id)

And Yes.
to Navicat
monarch_candidacy change that table name to monarch_candid

~~TheDestroyer™~~ · 09/15/2011, 09:32

its work to my files

.Risan. · 09/15/2011, 09:35

have game 2019 revision and db 1667 revision.

Can you send me you Navicat SQL Monarch?

~~TheDestroyer™~~ · 09/15/2011, 10:24

sorry no just solve it!

~~[TM]SixSense~~ · 09/15/2011, 10:46

This can help?

ZyoX · 09/15/2011, 16:30

Does anyone test it?
I'll hope it works.

~~.Alessa~~ · 09/15/2011, 16:39

I'll try it. It's easy to fix the syserr. Just replace "name" in the query with "user" and rename it in your table. It's quite easy when you know the error: Mysql doesn't know how it should interpret "name" because it can be more things than just the colum.

.Nagato · 09/15/2011, 16:40

Man muss den Leuten doch nicht alles in den ***** schieben.
Pls mach nichtmehr so viel pub, ich habs mir nicht ganz genau angeguckt, aber ich hoffe, dass es nicht funktioniert, wenn ich ehrlich bin.

.Flynn. · 09/15/2011, 23:04

wie starte ich das Monarch System?
mfg
Flynn