Search:

If(select count(*) from sk_silk = 0)
Begin
Insert into sk_silk(jid, silk_own) values (@UserJid, '500')
End else
begin
Update sk_silk set silk_own = silk_own + 500 where jid = @UserJid
End
...

so i took arabicat's unique monster spot add query and changed it abit so u can set more that 1 monster to spawn:


USE SRO_VT_SHARD /* Add Unique Spot By Arabianfox */

DECLARE @UNIQUE VARCHAR...

Ima contribute abit to this release: if ur using php based panel u should disable error reporting from php.ini, make a include page to check the url for bad ipit ()[]{} etc' same check for all input...

huh, yes i can actuly just found a way to remove the zone threw interface editing, it takes a shitload of time but its rather possible. ^^

yes i do know that the zone wont work, but it still shows ingame, i have disabled Consta and Samark and i still see them ingame also i can't go there / tp there.
so ye, i just want them to dissapear...

so, disabling zones server side is rather easy, but my question is how u can remove em from world map client side.
i have tried to change WorldMap_XXX.txt didnt work, tryed to mess with Interface ->...

bump, any1 got any thoughts on the metter?

ye, figured that out myself just now xD its abit tricky but easy once u get ur head around it,
still lookin for a way to change the place it tp u to.
and if its not possible, atleast how to create...

well, i have been tryin to change the level of wich u can enter ship wreck, other than that, i have also been tryin to change the distanation of the Wreck_hole crystals. so far without success.
i...

please learn to read:

fix ur ODBC -.-'

seek_n_destroy stored procedure.

so what? he made it much more understandable and noobie-friendly than the disccussion. so say thnx and shut-up

no offence, but i lol'd really hard over this topic xD

ye i did, i appear and try no move but the client crashes. nvm i fixed the issue with a different client.. some map txt files were facked i sepose.

how can u change the items that u get from an item after disassembling it (with destraction rondo i mean)Thnx for any hits. ^_^

bump, any1 got any clues?

can u post the media files for that map? seems i dont have it, crashes constantly when i try to tp there.

Aiight, i had the same error while i was tryin to add new crafting items for a craft.system i was building, didnt really got my head around what was causing that issue but, i managed to fix it by...

Please post here the acript from the page ill see what I can do, and please don't use any tags just poat it as plain text, my mobile phone can't read it otherwizw ^_^

Ddos?

Hmp, just a suggestion bugmt, wouldn't it make more sence to make a tutorial about 'making any mob a pet' eather than just releasing new pets every day?

Hmp, 33 is the value for item mall items, 0 is for regular shops if I'm not misstaken, but that dosent sepose to give errors, u just wouldn't see it ingame, there must be something weong with price?...

Lol web unique ranking. . . So old, like a 1000 ppl released there version of the ranking including me, this isnt ur advertise zone gtfo -.-

Just open the bloody file with hex editor and look for missing files, if all files exist, I doubt it will work, btw, where did u rip this pet from?

U must disable all special characters in the url to prevent injections, furthermore, it is recommended to disable error reports. ( search for error_report in php.ini and set it to off.)

hmp, added the npc and everythin is fine, but i cant seem to add items to that npc.. im getting crashed each time i try.

u need to specify the folder...
fo e.g:
c:\\server files\\evalog\\
i even wrote it there xD

Aiight so here's the deal: Fatallogs aint logging unique kills since ur probably using evagilion patch to gm, in witch case the logs are being saved inside a txt file in evalog folder. Log them and...

The differenve between item and cos usualy that they have different trade parameters for the same item for e.g item might be untradeable while coz is tradeable and stall able, joymax did it with a...

S_objectindex, play with it ^_^

Refpricepolicy / itemdata_xxxxx good luck.

Its a php file there are some out there, I released1 a while back u can find it in the release section 2nd page i think.

just add an auto refresh script using javascript and itll be fine. Goohle it

FileFlyer - Хранить и Пересылать Ваши файлы - это быстро!
here u go this is the sro_ad.exe
its currently set to my server (been meaning to do a "Account Manager" with it, but never really got...

do u want to give that program to the players to use?
coz if so, u gonna incounter some issues like having to open ur SQL connection... and such
better make it in PHP and take the Ad_Sro.exe from...

U can see all the refobjcommon and refobjitems inside itemdata. Just need to know where to look and meh?:not same structures? Just copy the rows of the pets into ur files, edit the ids and ur done,...

U wanna be paranoid, well that's fine, but u will have to finish the code urself:


$max = '1000' // max users the server can hold. . . //

$percent = $onlineusers * 100 / $max;
If ($percent <=...

Ty this is a rather usefull post, now I got some ideas on why the blue soul avatar might not be working, I will test my new theory and post results here ^_^

P.s only I have noticed this or this is...

Hmp gimi the variable for users online (for e.g $onlineusers) and ill make ya a simple acript.

Well I'm on my mobile phone so I can't see the pics but ill take a wild guess, the config files or rhe dlls might be wrong.

Hmp nice, I will have to check that, still, looking for more info about this sybjects, like, where the sr_gmX values are stored, I mean, how does amc knows what this spesific setting does.

I'm on my phone, and its an annoying query to wite. Just take alook at _items and _inventory tables u will figure it out its easy.

That's why I never share anything important with ppl i dont trust xD
Don't get me wrong, I'm for sharing but just releasing full works aint 'contributing' ots just another reason for leechers to...

Take alook in gameserver and gateway for any errors and post them here, I would siggest that ur billing is wrongly configured but I don't think its the case.

Just copt some d1 item row or w.e and change the package and id number, that's how i did it and it work fine.

I think he's talking about ingame payment. Like silk/gold coints etc' am I right? If not than yea, payment wall, or u can use doupay directly, less taxes for the transaction and it supports all...

shopgoods refpricepolicyofitem refpackadge and another1 I can't rememmber, check guides in the guide section.

Look if gateway giving amy errors when u try to login.

Go take an english course than come back.

Dafaqu did I just read? O.o

Its just a missing attack file. I sepose to can remove his auto attack and make him attack with skills instead, I'm guessing it qont cause crash, or u can just remake him as a grab pet and call it a...