Markyieee

: DB error - BIGINT UNSIGNED value is out of range in '(`ragnarok`.`cp_votes`.`credits` - 10)' Error. Only 10 cash got by the players but they already have 200 Sir I figure out that the converter convert it like 10 vote points = 2 csh points only

Make sure to put the proper sprites in Drop Folder / Sex Folder ( male and female ) :-)

maybe you need convert it to variable #CASHPOINTS and using OnPCLoginEvent to convert it to cash shop in the game in my private server using this script to convert it . - script VotePointConvert -1,{ OnPCLoginEvent: query_sql("SELECT `YOURCOLUMNPOINTS` FROM `YOURTABLEVOTE` WHERE account_id="+getcharid(3)+" LIMIT 1",.@points); if (!.@points) end; query_sql("UPDATE `COLUMNUSER` SET YOURCOLUMNPOINTS=(YOURCOLUMNPOINTS-"+.@points+") WHERE account_id='"+getcharid(3)+"'"); set #CASHPOINTS, #CASHPOINTS+.@points; //set #VOTEPOINTS, 0; dispbottom "Cash Points updated! Total: "+#CASHPOINTS; end; } maybe it can help you sir What will be the COLUMNUSER ? YOURCOLUMNPOINTS? and YOURTABLEVOTE? this is table from your vote database , like this : CREATE TABLE `vote_point` ( `account_id` int(11) NOT NULL default '0', `point` int(11) NOT NULL default '0', `last_vote1` int(11) NOT NULL default '0', `last_vote2` int(11) NOT NULL default '0', `last_vote3` int(11) NOT NULL default '0', `last_vote4` int(11) NOT NULL default '0', `last_vote5` int(11) NOT NULL default '0', `date` text NOT NULL, PRIMARY KEY (`account_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; i use this query for save my vote points - script RewardPointConvertnew -1,{ OnPCLoginEvent: query_sql("SELECT `point` FROM `vote_point` WHERE account_id="+getcharid(3)+" LIMIT 1",.@rewards); if (!.@rewards) end; query_sql("UPDATE `vote_point` SET point=(point-"+.@rewards+") WHERE account_id='"+getcharid(3)+"'"); set #CASHPOINTS, #CASHPOINTS+.@rewards; dispbottom "Cash Point updated! Total: "+#CASHPOINTS; dispbottom "Harap Relogin kembali ~"; end; } and use this for convert it to cash point , maybe it different with you database, so i use the COLUMNUSER, YOURCOLUMNPOINTS and YOURTABLEVOTE for example row in database note : first script its wrong sir , sorry my mistake post here your database where it save the vote from flux.. CREATE TABLE IF NOT EXISTS `cp_votes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `banner_id` int(10) unsigned NOT NULL, `account_id` int(10) unsigned NOT NULL, `credits` int(10) unsigned NOT NULL, `vote_date` datetime NOT NULL, `vote_ip` varchar(15) NOT NULL, PRIMARY KEY (`id`), KEY `banner_id` (`banner_id`,`account_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=563 ; Here :-) Can you make one for me :-) @rewards - what does this mean? Is it the command to convert? or can i use @cash?

maybe you need convert it to variable #CASHPOINTS and using OnPCLoginEvent to convert it to cash shop in the game in my private server using this script to convert it . - script VotePointConvert -1,{ OnPCLoginEvent: query_sql("SELECT `YOURCOLUMNPOINTS` FROM `YOURTABLEVOTE` WHERE account_id="+getcharid(3)+" LIMIT 1",.@points); if (!.@points) end; query_sql("UPDATE `COLUMNUSER` SET YOURCOLUMNPOINTS=(YOURCOLUMNPOINTS-"+.@points+") WHERE account_id='"+getcharid(3)+"'"); set #CASHPOINTS, #CASHPOINTS+.@points; //set #VOTEPOINTS, 0; dispbottom "Cash Points updated! Total: "+#CASHPOINTS; end; } maybe it can help you sir What will be the COLUMNUSER ? YOURCOLUMNPOINTS? and YOURTABLEVOTE?

Are you using iteminfo.lub?

After voting in flux there is a remark that the players gained 10 Votes But during in game when using votes to buy on vote shop, It does say that the player doesn't have any vote/cash What is the problem here thank you

I don't know what happen. After i update my svn this just pop out

A source modification that allows player to use @hatredreset. Thank you. I already tried the one in eAthena. but i think its a little more different :-) Thank you for those who will share :-)

The web now have the properties of ankle snare but the problem is this in this picture.

Is it possible to change the amount of cart available on the Change Cart skill of merchant. My client only support 5 carts and the remaining other cart causes error, Can i make change cart to only change into those 5 carts and disregard the other cart? or even completely remove the other carts that are not supported by the clients Thank you.

I did try this one. But the web does not work players just walk on the web. Is there any src mod for this?

Awesome :-) Thank You

Requesting for source mod ) Spider Web works like Ankle Snare :-) Web can be deploy on the ground Thank you

My problem is when i tried to @item all my custom items to check the sprites. The server crash on the 115th Item. Is there any conclusion regarding this? What might be the problem? Also what should i do as a solution? Thank you ! Please Help

Insufficient collumns for skill_db.txt need at least 18 sir, whats missing?

BUMP! How do you fixed the problem I already tried this : And yet i can deploy the spider web on the ground Howd you fixed it?

But i already did that </aid> <loading> <image>loading00.jpg</image> <image>loading01.jpg</image> <image>loading02.jpg</image> <image>loading03.jpg</image> <image>loading04.jpg</image> <image>loading05.jpg</image> <image>loading06.jpg</image> <image>loading07.jpg</image> <image>loading08.jpg</image> <image>loading09.jpg</image> <image>loading10.jpg</image> SOLVED

My problem is not that quite rough but somehow disappoints me. I uploaded 10 Loading Screens and yet they are not always showing when changing map or whatever when loading client. Rather a black screen will always appear than the loading screens. What must be the problem and the solution for this? Thank you

Check the picture I uploaded. Don't mind the Red Circle and arrow. Once again. I can't get out of that circled blocks. got stock there. What can be the problem?

How to replace the prontera map with a custom one?

Awesome :-)

So youre saying that on the default lua files you have to continue the view id Example my Accessoryid look like this one ACCESSORY_DEVIL_SCHOOLHAT = 928, ACCESSORY_H_ANGEL_SCHOOLHAT = 929, ACCESSORY_H_DEVIL_SCHOOLHAT = 930, ACCESSORY_MOUTH_RED_PENCIL = 931, ACCESSORY_MOUTH_BLUE_PENCIL = 932, ACCESSORY_ELDERCROWN = 933, ACCESSORY_FIVE_COLOR_FEATHER = 934, --935-999 ACCESSORY_ANGELBAG = 1000, ACCESSORY_ARCHBAG = 1001, ACCESSORY_ARTICWINGS = 1002, You're sying it should be like this ACCESSORY_ELDERCROWN = 933, ACCESSORY_FIVE_COLOR_FEATHER = 934, ACCESSORY_ANGELBAG = 935, ACCESSORY_ARCHBAG = 936, Yes exactly that. see wat the last view ID is and then continue from that number. in this case, if five colour feather is the last number(934) then start ur custom ones from 935. I have already done this but still it doesnt fix. I can't seem to find out whats wrong :/

So youre saying that on the default lua files you have to continue the view id Example my Accessoryid look like this one ACCESSORY_DEVIL_SCHOOLHAT = 928, ACCESSORY_H_ANGEL_SCHOOLHAT = 929, ACCESSORY_H_DEVIL_SCHOOLHAT = 930, ACCESSORY_MOUTH_RED_PENCIL = 931, ACCESSORY_MOUTH_BLUE_PENCIL = 932, ACCESSORY_ELDERCROWN = 933, ACCESSORY_FIVE_COLOR_FEATHER = 934, --935-999 ACCESSORY_ANGELBAG = 1000, ACCESSORY_ARCHBAG = 1001, ACCESSORY_ARTICWINGS = 1002, You're sying it should be like this ACCESSORY_ELDERCROWN = 933, ACCESSORY_FIVE_COLOR_FEATHER = 934, ACCESSORY_ANGELBAG = 935, ACCESSORY_ARCHBAG = 936,

I cant still seem to find out whats wrong. But not all the items i add causes the crash. Some items causes crash

Thank you!