logical request for some probs :)

Amenovis · Nov 22, 2007

i have some request and hope someone can help me

As first on LoM2 servers was a Unbundlelist.txt to use bundles like potions talis poison shape 31. does that work also in mir3 ? And if does it work... if i create a unbundlelist.txt same way like at LoM2 (i mean the LoM2 server had a hand full of *.txt in the mud folder beside the envir folder and the server self see it and accept it. does LoM3 servers see that also and accept it and work with it ?)

as next a friend give me a script from a guildwar system from another server. i looked that script and wow i understand it *hihi without one prob
the guildwar system create a point count system that points he write in a list.txt the results (Same place like unbundle.txt and envir folder) but i cant find somewhere a link or sql command that say do that! write the results there and there and count it... so how that works ( is it hardcoded in the server and if... what kind of *.txt files also work with LoM3?) the script is from a EI server i use CD3.38

As next i saw a nice list of items shapes from LoM2 there i saw as example a multi para ring (or somethin like that) BUT as i checked that shape i saw in my DB that the shapes are in use for others. in that case it was crazywarr ring or xianwuring (one of them). So WeMade changed it i believe.. is there a possibility to get those kind of items in LoM3 working also??

ohh at least i saw also a way to make items usable as npc/or direct command like townteleport. so i ask me how i can use a gem /orb example for storing npc (I know its possible on LoM3) the request is how. i saw on LoM2 that there is a qfunction.txt there u can say what item do. LoM3 have not that *.txt file the quest is does it have a new name (00default.txt) or does LoM3 must have it other? Sure i can use d menue to make item usable

if
checkitem gem
say
iam the store what can i do for u
act
take gem
call xyz
elsesay
u have no gem blablub blablub blablub

but i prefer it with doubleclick like townteleport

so i hope someone have the knowledge and wanna split a bit with me

thx in advance

ameno

chimera · Nov 22, 2007

Line from SQL:

idxnumber itemname 61 20 0 0 0 0 0 3 1551 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 5 0 0 0

62 for next number, etc.....

In 00Default.txt

#ACT
goto @clickme_ItemClick

[@clickme_ItemClick]
#CALL [System\ItemScripts\ItemEvents.txt] @EventItem_AllItems
break

In system\itemscripts\itemevents.txt

[@EventItem_AllItems]
{
#ACT
SetItemEvent 61 20 @items1_Main
SetItemEvent 62 20 @items2_Main
SetItemEvent 63 20 @items3_Main
etc......

[@items1_Main]
#IF
CheckItem itemname 1
#ACT
TAKE itemname 1
GIVE itemname 1
Break
#ELSEACT
Break

[@items2_Main]
#IF
CheckItem itemname 1
#ACT
TAKE itemname 1
GIVE itemname 1
Break
#ELSEACT
Break

[@items3_Main]
#IF
CheckItem itemname 1
#ACT
TAKE itemname 1
GIVE itemname 1
Break
#ELSEACT
Break

}

idaBigA · Nov 22, 2007

If you stick with 61, and increment the Shape, 20, 21, etc you can then ensure that all items that have Item Events are under the same StdMode.

Amenovis · Nov 22, 2007

kk nice so if i understand it right its the answer for 1st and 4th request thx a lot m8´s so than are still missing answer for 2nd and 3rd request how it looks with that ??

lg

ameno

idaBigA · Nov 22, 2007

Amenovis said:
as next a friend give me a script from a guildwar system from another server. i looked that script and wow i understand it *hihi without one prob
the guildwar system create a point count system that points he write in a list.txt the results (Same place like unbundle.txt and envir folder) but i cant find somewhere a link or sql command that say do that! write the results there and there and count it... so how that works ( is it hardcoded in the server and if... what kind of *.txt files also work with LoM3?) the script is from a EI server i use CD3.38

Make a table in Game3G with the data you want to save.. i.e. as below taken from Sting's Integral System...

TBL_INTEGRAL
FLD_CHARACTER (VARCHAR), FLD_INTEGRAL (INT)

To Write a new line in the table use the following...

Code:

#ACT
    FormatStr "'%s',%s" %USERNAME 0
    mov A8 %A9
    FormatStr "FLD_CHARACTER='%s'" %USERNAME
    MOV A2 %A9
    WriteValueSql "TBL_INTEGRAL" %A2 "FLD_CHARACTER,FLD_INTEGRAL" %A8

To retrieve data from it.. use the following..

Code:

[@Main]
#ACT
    FormatStr "FLD_CHARACTER='%s'" %USERNAME
    ReadValueSql  "TBL_INTEGRAL"  %A9  "FLD_CHARACTER,FLD_INTEGRAL" [@CheckExInt1]

[@CheckExInt1()]
#IF
#ACT
   Mov    D2      %ARG(2)

D2 now contains the Quantity in FLD_INTEGRAL for that Char

To update the data in the table..

Code:

#ACT
   Mov  D4  10
   FormatStr "FLD_CHARACTER='%s'" %USERNAME
   Mov   A8     %A9
   FormatStr "FLD_INTEGRAL='%s'" %D4
   UPDATEVALUESQL "TBL_INTEGRAL" %A8 %A9

Hope that makes sense, now just add whatever code you want to do whatever it is you want to do.. In your case, you would store GuildNames and store GuildPoints..

Should be easy enough.

Amenovis said:
As next i saw a nice list of items shapes from LoM2 there i saw as example a multi para ring (or somethin like that) BUT as i checked that shape i saw in my DB that the shapes are in use for others. in that case it was crazywarr ring or xianwuring (one of them). So WeMade changed it i believe.. is there a possibility to get those kind of items in LoM3 working also??

No idea what a "MultiParaRing" is or does..

Amenovis · Nov 22, 2007

mhh it makes sense i miss only one point the Count Self for upgrade .
As example if i use FP System

[@kelch]
#IF
CheckFame //There he check how much i have (For Points ur script read value)
#ACT
Mov N4 %P9
Goto @kelch1

[@kelch1]
#if
ELarge N4 5000
#act
Dec N4 5000 //Here is the prob i mean example one user got 1 point. wich line from ur script say how much points get added to the points that are existing?
SetFame %N4 //Write sql (Update it in ur script)

chimera · Nov 23, 2007

If it's fame you are using you can

CheckFame
SetFame
IncFame
DecFame

no need to use an SQLWrite

Amenovis · Nov 23, 2007

nahhh m8 *hihi

i have used the fame system only as example to show what i dont understand.
There must be somewhere in the scriptparts (SQL) a part where it says INC with 1 point or something like that.

Example rebirth there the server make it automatic each use from the HLScriptCom set +1 rebirt/titel for fame u must say Inc but how is it with sql did he make it automatically or must there be a part that say "INC +1" for count and safe ?

chimera · Nov 23, 2007

HLScripts are limited to those that are built-in I believe.

I think your only option is as Sting said, make a table or add a column to character table (that's that I use if it's character specific) and use the read and updatesql commands.

Amenovis · Nov 23, 2007

ehm lol I HAVE CREATE THAT SQL TABLE LIKE HE SAID AND I WANNA DO IT LIKE HE SAID*roflllllllll the only prob is i dont understand where stay add+1 on counter

example:
i kill one player i got 1point
1 kill 2nd player i got 1point
exactly i have 2 points

the 2 points comes with read out first and add +1 but where stay add+1 in that sql commands ??

idaBigA · Nov 23, 2007

Make a Table in Game3G database called TBL_GUILD

Fields -

FLD_GUILD (VARCHAR)
FLD_GPOINTS (INT)

To Create a New Guild in the table.. use the following

Code:

[@CheckGuild]
#IF
    HasGuild
#ACT
    FormatStr "FLD_GUILD='%s'" %GUILDNAME
    ReadValueSql  "TBL_GUILDPOINTS"  %A9  "FLD_GUILD" [@CheckGuild1]
#ELSESAY
You are not in a Guild\
<[ Exit  ]/@exit>\\\

[@CheckGuild1()]
#IF
#ACT
   Mov    A1      %ARG(1)                  ; < < If your guild is in the table its name will be in here... if not this will equal ""
#IF
   Equal  A1   ""
#ACT
    FormatStr "'%s',%s" %GUILDNAME 0
    Mov A8 %A9
    FormatStr "FLD_GUILD='%s'" %GUILDNAME 
    Mov A2 %A9
    WriteValueSql "TBL_GUILDPOINTS" %A2 "FLD_GUILD,FLD_GPOINTS" %A8
#ELSESAY
This Guild has already been added\
<[ Exit  ]/@exit>\\\

To Add a Point - Use This

Code:

[@AddPoint]
#IF
    HasGuild
#ACT
    FormatStr "FLD_GUILD='%s'" %GUILDNAME
    ReadValueSql  "TBL_GUILDPOINTS"  %A9  "FLD_GUILD,FLD_GPOINTS" [@AddPoint1]
#ELSESAY
You are not in a Guild\
<[ Exit  ]/@exit>\\\

[@AddPoint1()]
#IF
#ACT
   Mov    D2      %ARG(2)              ; < < How many points your guild has ATM
   Inc    D2   1                       ; < < How many points you want to add on
   FormatStr "FLD_GUILD='%s'" %GUILDNAME
   Mov   A8     %A9
   FormatStr "FLD_GPOINTS='%s'" %D2
   UPDATEVALUESQL "TBL_GUILDPOINTS" %A8 %A9
#SAY
I have added you 1 Point, you now have <$OUTPUT(D2)> GuildPoints\
<[ Exit  ]/@exit>\\\

I have not checked that, but it should work fine..

Amenovis · Nov 23, 2007

yessa that was what i meaned thx m8 (i know i have often probs to explain what i mean directly lol in other language it isnt that easy

)

chimera · Nov 23, 2007

Sting beat me to it lol

idaBigA · Nov 23, 2007

Amenovis said:
yessa that was what i meaned thx m8 (i know i have often probs to explain what i mean directly lol in other language it isnt that easy )

Np's m8

chimera said:
Sting beat me to it lol

:P

Amenovis · Nov 26, 2007

mhh me again :P

so to change one item for another work cool i play now the last two days with call system but it doesnt work and i ask me why the normal command for npc to store is @storage so i write a script to the part with

#if
clickitem 1
#act
take clickitem1
#call

but that dont work anyone know is there a speziel part that i have overseen?

Amenovis · Nov 27, 2007

mhh noone ? i have sit the full night on it changed here and there and the result is ever the same

he took the item with doubleclick but he dont open a window

so pls help

thx in advance

ameno

EDIT: now it works a bit i have put the storage command directly in the script the cd.exe shows me no error. i build item to double click the window open now and say "What u wanna store?" also the bag funktion work with the button to store but now....EVER if i marking an item (Example MPPOTION) he say me new window "U Can not Store"

that message comes ever if i try to put in 1 item or 100 i have test normal store script there i can store all without denied storing ?? so hwat can it be pls give me a link i dont need the result how to make i need only a link wich way i have to look

cause i have still no idea how to fix it

lg

ameno

Amenovis · Nov 27, 2007

noone ? (i have edited my post)

i cant give up so pls anyone i dont understand it really

Amenovis · Nov 29, 2007

ok i know now what is the prob

its my server files with 3.55 it works on my way.. with my 3.38 files it dont work so its the same **** like ever but thx for help to all that tried it i give it up

Inflikted · Dec 26, 2007

refering to your guildpoints script idabiga, i got the 'concept' of the script itself to work fine. however I am a bit unsure where to add the 2nd part of the script. at first i thought it would be a userdie script, but that would add points to the player who died. is there a way to retrieve or give the point to the person who killed you. if it isnt too much trouble to ask

tried to hunt down something about that.. all i came up with is a logdataserver.exe program that would analyze your logs. but i guess that isnt what im looking for.

Amenovis · Dec 27, 2007

mhh im asking myself if u cant use the holy msg for that

holy msg say ever u where killed by "XYZ" if u use that XYZ in same way as variable dont u can use it as ehm namelist or somethin???

logical request for some probs :)

Golden Oldie

LOMCN VIP

Holley Mir 3!!

Golden Oldie

Holley Mir 3!!

Golden Oldie

LOMCN VIP

Golden Oldie

LOMCN VIP

Golden Oldie

Holley Mir 3!!

Golden Oldie

LOMCN VIP

Holley Mir 3!!

Golden Oldie

Golden Oldie

Golden Oldie

Golden Oldie

LOMCN Veteran

Golden Oldie