Very helpful ty :D
Printable View
Very helpful ty :D
A Max level script ? please :)
Quote:
Originally Posted by GroundZ
The max lvl is coded in to the GameServer. Maybe you can edit it in gameserver configs.
hi.....how do i use this script to be able to use it???
do i need a program to be able to use those script???
just asking because im a noob. sorry for being noob :closedeyes:
You need SQL Query Analizer to run these scripts.Quote:
Originally Posted by -=meow=-
UPDATE Character
SET Strength='65000'
WHERE Strength<1
UPDATE Character
SET Dexterity='65000'
WHERE Dexterity<1
UPDATE Character
SET Vitality='65000'
WHERE Vitality<1
UPDATE Character
SET Energy='65000'
WHERE Energy<1
UPDATE Character
SET Leadership='65000'
WHERE Leadership<1
Server: Msg 244, Level 16, State 2, Line 1
The conversion of the varchar value '65000' overflowed an INT2 column. Use a larger integer column.
The statement has been terminated.
Server: Msg 244, Level 16, State 2, Line 1
The conversion of the varchar value '65000' overflowed an INT2 column. Use a larger integer column.
The statement has been terminated.
Server: Msg 244, Level 16, State 2, Line 1
The conversion of the varchar value '65000' overflowed an INT2 column. Use a larger integer column.
The statement has been terminated.
Server: Msg 244, Level 16, State 2, Line 1
The conversion of the varchar value '65000' overflowed an INT2 column. Use a larger integer column.
The statement has been terminated.
Server: Msg 244, Level 16, State 2, Line 1
The conversion of the varchar value '65000' overflowed an INT2 column. Use a larger integer column.
The statement has been terminated.
how to fix?
cant u read ? :DDD Use a larger integer column. (lol)
not bad
I got a question how would you change beginner gear .. like upon char creation it added different beginner items
tehfire10, you shold rewrite GameServer, coz the default values is in it. (idk, maybe it's Dataserver, not GS).
oh i thought you could change the db's didnt know it would be something in the server filesQuote:
Originally Posted by Jahte
Where to put this scripts ? :O
you have script for making guild in website?
how about if the character already gained max stat in all atrributes of his character which is (str 32767, agi 32767, Vit 32767, energy 32767 and command of 32767) and this character is making resets and gaining level up points even he already got the max stats in all attributes. how can i stop this character gaining levelup points when he still likes to make more resets if he already reach max stat in all field? let say he can gain more resets but no more levelup points to gain :), hope that good and brilliant scripters can help in this matter. More power to all :D
Nice Job :D
Thanks!!
Quote:
Originally Posted by rammerz
update Character set leveluppoint='0'
where
Strength+Dexterity+Vitality+Energy='131068'
OR
Strength+Dexterity+Vitality+Energy+Leadership='163835'
if you like to implement build system for different character classes, and you like to give them different max points for their characters class upon reaching their max resets : like 65k for DL, 55k for MG and SM, 75k for Summoner and Elf and 50K for BK. what is the script do i need to encode just to do this kind of build system? help me with this one please. God Bless and more power.
Please Help Only Code
Grand Reset Code Please help me
500 Reset Only 1 Grand Reset
1 Grand Reset = Auto 10000 Kredi Free Please Code
İm Wait Please Code Only Quazer...
Thzx.
i know it exist a script to reduce the size of the DataBase... my database size is 6GB lol.. cand someone give me that script?
UPDATE Character
SET LevelUpPoint=('') + 1500
WHERE cLevel<=1 and Resets<=1
this script aint working .... i put it in SQL it shows me that i put it coreect but when i make a new char... Nothing :| No start up points
You got 2 make a procedure in ur sqlQuote:
Originally Posted by PunxPhobia
thx , i just updated my db. :DQuote:
Originally Posted by Jahte
Hi guyz
how can i make a script for cashshop
i want give 1cashshop point every 1Minute noline
and disconnect all afk players after 15min
can i make it?:mellow::mellow:
---------- Post added at 12:33 PM ---------- Previous post was at 10:47 AM ----------
i make it and run like thisQuote:
Originally Posted by dartor
UPDATE MEMB_INFO
SET cspoints = cspoints + 1
FROM MEMB_INFO JOIN MEMB_STAT ON MEMB_INFO.memb___id = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS
WHERE ConnectStat = 1
and schedule like auto reset :thumbup1:
ciao! :D
Hi!
If I want to add this in my server :
UPDATE Character
SET cLevel=('1') , experience=('0')
WHERE cLevel>349
where do it put it? SQL of txt file?
Thanks!
And also, what do I do if i wat to remove the script?
Thanks!