[Adding more features as they pay more]

but it doesn't give me anymore errors xD for now that is hahahahaha

Well this update cleaned the guild's buff of your guild test. You can clean it with the npc now.

But if it works now forget it xD

 

 

The important part was

ALTER TABLE `guild` CHANGE `buff` `buff` varchar(255) NOT NULL default ''

Alright thanks! hahaha honestly thanks alot for your help xD dint really had the time to test it out during the weekends but i've managed hahaha.

 

so far it works great and fits the exact description of what i required! Thanks again capuche!

[Adding more features as they pay more]

i know i'm going to sound very stupid in this but i've searched quite some time yet i can't find it ._.

 

 

UPDATE `guild` set `buff` = '';

requires me to disable safe mode but i cant ._. i cant find that anywhere lol i've checked administration and everywhere i could think of!

 

 

but it doesn't give me anymore errors xD for now that is hahahahaha

 

thanks alot capuche!

[Adding more features as they pay more]

LOL I prefer this part

hahahahaha either way it works great as it is XD left only the SQL part i guess xD.

 

Anyway i will get back home and test it out as fast as i can xDD

 

Thanks again! Love the add-on to clear it off! xD

[Adding more features as they pay more]

Edit :

 

Just tested it out! This works AMAZING GREAT! i can't believe it lol thanks alot capuche! You're the best! hahaha thanks!

 

It works amazingly great! I tried breakguild and form guild and it resets normally thanks!!!!

 

This is exactly 100000% what i wanted!

 

There is one problem though

 

i keep getting this error once my agi is maxed level and upgrading the bless / kylie. it stays at lvl 5 also though while eating up the zeny.

 

: DB error - Data truncated for column 'buff' at row 1
[Debug]: at ..\src\map\script.c:14528 - update guild set buff = '1|1' where guild_id = 5

[Adding more features as they pay more]

0 2 22:23:00 alter table guild add column buff varchar(255) NOT NULL default '' after emblem_data, add index (buff) Error Code: 1060. Duplicate column name 'buff'

0.000 sec

 

 

I'm getting an error on mysql upon testing this. (i'm not really familiar with MySQL so it'd be great if you could guide me along the way) >_<

 

but seeing it's a duplicate name, i believe it should be done already? O_O

[Adding more features as they pay more]

Guild A can only possess 1 property. No worries on that part.

 

Currently i just need the healers to be seperated on this part based on the upgrading. If possible adding a reset would be good too xD in case let's say that guild becomes inactive or somewhat where we can dispose and cleanse everything xD

 

Hope it's not too much of a request that i'm asking

[Adding more features as they pay more]

errr cause this more like individual guilds have their own property. so... that's why the buff can't be shared.

 

if a new guild comes in and let's say buy's a property, they'll have to purchase the buff from scratch

[Adding more features as they pay more]

yeah that's correct xD,but just to confirm this works with multiple npcs right? o_O if i make a new one it wont be affected and they have to reupgrade it am i right? or... (sorry if i cant test cause nowadays i'm spending my time outside instead of home T_T) but i'll definitely test once i get back home

[Adding more features as they pay more]

Edit :

 

Hi there Capuche,

 

i've tested it out and let me tell you that it works AMAZINGLY great! it's definitely what i wanted haha, but there's one small issue though, if you don't mind, would it be possible to make the upgrades individual?

 

let's say he pays 10k to upgrade bless only. then agi and others are seperate basis.

 

is it possible? if not then i'm fine with this. It's has been great so far xD

[Adding more features as they pay more]

That means others guild couldn't warp on the map ?

 

Yup! I'll set an npc that warps the specific guilds to their specific places. Cause it's more or less kinda like a gathering point or their own "mini-castle" for them.

 

I have done something but it's a little weird, feel free to hate it xD

and it's global : all guild have access to the npc, but only the guildmaster can up the healer.

bwt if you want to test it

That's all i require hahah as long as only the guild master is able to upgrade the healer then that's all.  I'll be able to change it based on my part here XDDD.

Aside from that... I dont think it's weird hahaha XD the code is pretty easy to understand for me XD (although i can't write like this, at least not in another 2-3 years).

 

 

Thanks Capuche!

 

Currently i'm not with my computer at the moment so i can't really test it out but by the looks of it,

 

i dont think it'll be a problem xD.

 

i managed to understand most of the configurations except the SQL part. (Mainly cause i've yet to venture into SQL. but soon!)

 

Once i get home i'll test it out and let you know immediately! xD

 

Thanks again!

[Adding more features as they pay more]

errr, let me put it this way lol no worries on the harrassing part haha the fact that you're helping me is already too kind xD.

 

Example :

 

Currently buff level = 1

 

Agi level 1

Bless level 1

 

When anyone in that particular guild presses it, they'll receive this buff.

 

However, once the guild master and only the guild master upgrades it.

 

Let's say,

Buff level = 2

 

Agi level 2

Bless level 3

 

Then everyone inside that guild will get that buff.

 

This is meant solely to that guild only. Other guilds will not be able to access nor talk to the NPC. (I'll seperate them in a map so it wont conflict out in anyway)

 

if you require more information just let me know xD, sometimes my explaination might be a bit fuzzy and hard to understand lol

[Adding more features as they pay more]

it's support here haha !

 

woops haha i meant support question cause honestly i couldn't find any commands that relates back to only the guild master can use it lol. i couldn't find this in the wiki. Maybe the script_commands would have more info xD.

 

You mean the guildmaster make the exchange and he can get a superbuff or he allows his guildmember to get a superbuff too ?

 

Meaning the guildmaster can only upgrade the buff and not anyone else. but everyone is allowed to use the buff.

 

*explode(<dest_array>,<string>,<delimiter>)

Breaks a string up into substrings based on the specified delimiter. Substrings

will be stored within the specified string array. Only the 1st char of the

delimiter parameter will be used. If an empty string is passed as a delimiter,

the string will be placed in the array in it's original form.

 

i have no clue at all for this lol, i'm guessing this is high level scripting >_>

i'm still at junior level i guess xD.

 

On a side note, (Honestly i think this is becoming a request lol, perhaps it should be moved? apologize for the inconvenience lol)

[Adding more features as they pay more]

Sorry if i dint clarify, but yeah, it's actually permanent per upgrade.

 

one more side request if you dont mind, the guild master can only make the change.

 

I can't seem to find that script command anywhere >_>

not sure what explodes means here xD

 

if you dont mind can you explain about it?

 

edit: quote not working

[Adding more features as they pay more]

HI guys,

 

Having an issue with scripting at the moment.

 

Currently i have an npc that provides agi  & bless lvl 5 upon click the NPC.

 

However, if let's say i'd like to add a feature that allows them to use zeny to upgrade the agi / bless and adding more buffs like kylie elison and the rest, how do i do that?

 

The only method i could think of is putting 2 seperate npc and setting a variable each time they upgrade.

 

like set upgrade,1;  then it'll be agi lvl 6 and bless lvl 5

 

then set upgrade,2; will be agi lvl 6 and bless lvl 6.

 

But if they mix around then it'll be hard to maintain this. Is there anything i'm missing currently?

 

Thanks!

[Facing Computer Issues]

Hi there guys,

 

This questions is particularly for people who have slightly more experience in computer hardware as i'm currently facing one issue which is really really..... annoying me lol.

 

Well first off, here's my specs for starters.

 

Dell Vostro 3700

Processor : i5 450m 2.4ghz up to 2.6ghz

RAM : 3GB

GPU : GT 330m | Intel HD Graphics

 

So here's the problem, initially, my laptop is able to run crysis 2 smoothly and all, resident evil 5 DX 10 high settings without anti-aliasing was fine as well, no lag nor any spike at all.

 

However as time goes by, i believe dust was the issue here and i was right, my laptop starting shutting down by itself once it reaches a certain temperature, (I've tried stress testing it and it was 100C to be exact before it shuts down).

 

So, i was ignorant of this problem at first until it started happening more often till the point i couldn't play high end processing games. I needed a USB fan which was strong enough to blow at my ventilation to cool it down for me to play games. It worked for awhile but stopped in the future due to massive amounts of dust.

 

So i sent it to a laptop specialist, they managed to resolve the issue including the price of breaking my wi-fi card,

 

off topic:

(When i told them it wasn't working, they said "You din't let us check your hardware before sending it for us to repair) i was like "omg" and i suck it up and got a USB wifi instead, normal speed but wasn't as good as my internal wi-fi card but it was a necessity i guess)

 

Back To Topic:

 

Once i got it back, My laptop looked like a real beauty this time! I went and played all games high again and it din't shut down. It was great till today. Just 2 days ago i was playing Tomb Raider and finished the game with decent settings. And now, not sure what happened, but it just continued to shut-down very quickly compared to before without reaching the heat.

 

the problem has became so bad that, it wouldn't even allow to reach the main page before it shuts down! I've checked the Event Logs and it was "Unexpected Shutdown Occured".

 

I managed to alt+tab on my game before it shut down to check the temperature and it was only 75, and then poof it shuts down. I dont think it's the dust problem this time since i serviced it for about 4 months only. Even browedit crashes my laptop!

 

Again, this problem happened today. So i'm really at a loss here. Any advice from anyone? Should i do a reformat on my laptop or could it be a hardware issue?

 

(I've switched to Intel Graphics HD to make sure i dont shut down so right it's fine as long as i dont switch my graphic card)

 

ok, after really playing around i found out the cause lol,

 

seems that my wiring for my charger is faulty. needs to adjust around then only can get the power ._.

 

i feel kinda stupid after posting this lol. anyways, it's solved now lol

[Unable to change loop time]

Thanks Syouji! That worked lol i guess i must've forgotten to hit enter after hitting the values got din't notice i pressed enter for the first two that worked lol.

 

It's working now thanks !

[Unable to change loop time]

Hi there guys,

 

i seem to be facing an issue where when i'm editing my map and placing effects in,

 

The loop time doesn't change. Therefore it's always 40 and it makes the map laggy.

 

Therefore i've changed a few to 40000 which works great. but the rest can't be change.

 

I did try closing and opening browedit but it doesn't work, now i've deleted all effects and this time it doesn't allow me to change a single value inside it.

 

Any ideas? Thanks!

[IPB Forum]

not to mention the nulled boards have been modified, if you've gotten the wrong one and not sure how to use it,

 

backdoor viruses might happen and your database might be endangered.

 

Therefore, go legal! it's the best way!

[please help Adding a script]

Here's the wiki to help you out on adding custom NPCs

 

Adding_a_Script

[Error with Questid2Display]

bump for this!

 

If anyone does have any information on solving this that'd be great thanks !

[Error with Questid2Display]

Hi there guys, Here's a small problem with from the questid2display,

 

as you can see the image here shows 10/-856 where it should be 10.

 

Is there anything i'm doing wrong? This problem can be reproduced by relogging into the game. You'll see the 2nd value change.

if you accept a new quest it'll state correctly 0/10.

 

but if you relog, it becomes 0/-856.

 

Any help? Thanks

[Basic Hunting Quest NPC]

oh that's the purpose of quest_db.txt

yup hahaha, i'm using quest_db quite often for my quests xD.

adding a time limit would be easier from there also in my opinion xD

[Basic Hunting Quest NPC]

Here's how i do my quest scripts and an example xD

 

quest_db

// Quest Database
//
// Structure of Database:
// Quest ID,Time Limit,Target1,Val1,Target2,Val2,Target3,Val3,Quest Title
81000,0,1002,10,0,0,0,0,"Hunting Porings";

 

(This will give a small notification each time you kill a poring xD to know how many you've killed so far. (Not sure if it works for all client, i'm using 2012-04-10))

 

NPC side

-Usual header-
 
if (checkquest (81000,HUNTING) == 2) {
mes "[ToiletMaster]";
mes "You've done it! Congratulations!";
mes "Here's a great reward for you!";
next;
mes "[ToiletMaster]";
mes "Just Kidding! :D";
close; }
 
 
mes "[ToiletMaster]";
mes "I want you to kill 10 PORINGS!
setquest 80010;
close;

[Permanent Monster Spawning]

That works! Thanks alot  !

[[PvP] The Cell Games - Dragon Ball Z]

i'm more interested in seeing what's gonna happen next than getting the map xD