sietse11

January 16, 2014

Can't reproduce this.

Make sure the sql account used by flux has all the rights needed to replace passwords.

Replace would probably be the right needed to change passwords

January 15, 2014

Hey folks,

I need some help.

I am trying to test the paypal sandbox.

But when I go to the itemshop I get the following error.

Message: Failed to import/replace rows from table 'ragnarok.item_db2'

now this table is called item_db2_re

I tried to fix it like this,

modules/itemshop/add.php

($server->isRenewal) {
	$fromTables = array("{$server->charMapDatabase}.item_db_re", "{$server->charMapDatabase}.item_db2_re");
} //else {
	//$fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db2");
}

I removed the if statement and secured the else statement for future reference.

Saved

Reloaded the page same error.

-------------------------------------------------------------

fixed by doing this

Modules/itemshop/add.php

if ($server->isRenewal) {
	$fromTables = array("{$server->charMapDatabase}.item_db_re", "{$server->charMapDatabase}.item_db2_re");
}       else {
	$fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db2");
}

added the _re behind "{$server->charMapDatabase}.item_db2_re")

and

lib/flux/itemshop.php

if($this->server->isRenewal) {
			$fromTables = array("$db.item_db_re", "$db.item_db2");
		} else {
			$fromTables = array("$db.item_db", "$db.item_db2");
		}

TO

if($this->server->isRenewal) {
			$fromTables = array("$db.item_db_re", "$db.item_db2_re");
		} else {
			$fromTables = array("$db.item_db", "$db.item_db2");
		}

January 15, 2014

No more errors, mob is working. You are however limited to around 750 custom mobs

Without editing the luas, there is no more warnings from your client?

did that answer your question?

January 15, 2014

if your client version is the same as mine try adding

4294967294

to your

equip_jobs column

I had the same problem with ma wings

January 15, 2014

Can't you fine tune the query_sql to exclude their ID's?

Im no good at sql commands but something like

query_sql "Select account_id from char where (gmlvl/groupID) =< 20 ", @aid; detachRID.@aid

I dunno if the scripting is accurate, but in essence this should find all account id's with a group id equal to or greater then 20. and then remove em with the DetachRID like for the venders.

Btw lemme know if that even remotely worked XD

January 15, 2014

Check it again. Your pic is telling us telling the user and password you used does not have access.

Also make sure you give the user all the rights needed to add and drop tables etc.

Smart thing to do would be creating a new user for xantara's flux.

You should never use root!

January 15, 2014

Hey guys,

So I took a look at the custom mob wiki page. And I believe it hasn't been updated for the new clients. On a side note, custom item wiki still shows 4 for weapon 5 for armor.

Now to my problem.

Once I add an entry to jobname.lub and NPCidentity using mob ID30000.

I get an error list that is out of this world.

Shadow tabel errors

nill errors

and about 5 errors more from different files.

Can anyone tell me which files in the data folder need editing?

Because apart from the old files I used there's now,

jobidentity.lub/lua which doesnt correspond to NPCidentity. Being as one of them is bigger.

And all the error messages I get lead me to believe I need to edit like 10 files to add one mob?!

Help would be greatly appreciated

-----------------------------------------------------------------------------------------

go to your data/luafiles514/lua files/datainfo folder

open up,

jobidentity.lub

jobname.lub

NPCIdentity.lub

jobidentity.lub, find

JT_RECON_ROBOT = 3154,
  JT_REPAIR_ROBOT = 3155,
  JT_EXPLORATION_ROVER = 3156,
  JT_MONSTER_LAST = 3157,

CHANGE TO

JT_RECON_ROBOT = 3154,
  JT_REPAIR_ROBOT = 3155,
  JT_EXPLORATION_ROVER = 3156,
  JT_CUSTOM_MOB = 3998,
  JT_MONSTER_LAST = 3999,

jobname.lub, find

  [jobtbl.JT_4_M_REBELLION] = "4_M_REBELLION",
  [jobtbl.JT_4_F_REBELLION] = "4_F_REBELLION",
  [jobtbl.JT_4_CHN_SHAOTH] = "4_CHN_SHAOTH",
  [jobtbl.JT_4_SHOAL] = "4_SHOAL"

CHANGE TOO

  [jobtbl.JT_4_M_REBELLION] = "4_M_REBELLION",
  [jobtbl.JT_4_F_REBELLION] = "4_F_REBELLION",
  [jobtbl.JT_4_CHN_SHAOTH] = "4_CHN_SHAOTH",
  [jobtbl.JT_4_SHOAL] = "4_SHOAL",
  [jobtbl.JT_SKELING] = "CUSTOM_MOB_SORITE_NAME_HERE"

NPCIdentity.lub, find

  JT_POURING_SEA_FES = 3168,
  JT_J_REB_SHECIL1 = 3169,
  JT_J_REB_SHECIL2 = 3170,
  JT_MONSTER_LAST = 3999,
  JT_MER_LIF = 6001,

CHANGE TO

  JT_POURING_SEA_FES = 3168,
  JT_J_REB_SHECIL1 = 3169,
  JT_J_REB_SHECIL2 = 3170,
  JT_CUSTOM_MOB = 3998,
  JT_MONSTER_LAST = 3999,
  JT_MER_LIF = 6001,

January 15, 2014

just use a launcher and your good to go.

January 15, 2014

Ok heres what I did. (no more spoiler tags?)

I created the item Fairy Wings in the SQL item_db2_re

That part works.

@ii finds the item

I changed iteminfo.lua to state this;

        [30000] = {
		unidentifiedDisplayName = "",
		unidentifiedResourceName = "_fairywings",
		unidentifiedDescriptionName = {
		},
		identifiedDisplayName = "Fairy Wings",
		identifiedResourceName = "_fairywings",
		identifiedDescriptionName = {
		},
		slotCount = 0,
		ClassNum = 1082
	},

I changed accname.lub to state this;

  [ACCESSORY_IDs.ACCESSORY_GOLDEN_FISH] = "_ÀÔ¿¡¹®È²±Ý¹°°í±â",
  [ACCESSORY_IDs.ACCESSORY_FAIRY_WINGS] = "_fairywings"
}

I changed accessoryid.lub to state this

  ACCESSORY_GOLDEN_FISH = 1081,
  ACCESSORY_FAIRY_WINGS = 1082
}

Headgear view id to 5000 and load lua before lub diffs checked.

Here's what happens,

ingame I use @item to create itemID30000 (Fairy_Wings)

in my inventory equipment tab Fairy Wings pop up with corresponding _fairywings.bmp.

I equip Fairy Wings.

Fairy wings are not seen ingame THATS A PROBLEM Solved after below fix -> re-equiping did the trick

when I press alt+Q game crashes THATS A PROBLEM Solved (³²) folder did not have _ infront of the fairywings name.

Data folder paths bmp files

Data - sprite - ¾ÆÀÌÅÛ - _fairywings.act/fairywings.spr present

Data - sprite - ¾Ç¼¼»ç¸® - ¿© / ³² - _fairywings.act/fairywings.spr present

Data - texture -À¯ÀúÀÎÅÍÆäÀÌ½º - collection / item - _fairywings.act/fairywings.spr present

What did I forget?

January 13, 2014

Hey I just did a clean check out from the git repository.

And I got the following errors after enabling SQL database.

Some sql files I imported with a re value now create a table with a re value where they used to drop the re

example;

BUG1

item_db2_re used to create the table item_db2 now it creates the table item_db2_re

resulting in the following error.

[SQL] DB error - Table 'ragnarok.item_db2' doesn't excist
[DEBUG] at ..\src\map\itemd.c:1444 - select * from 'item_db2'

I want to fix this by editing the sql file to state 'drop table if excist item_db2_re -- create table item_db2

If I am right this will remove the faulthy item_db2_re table and recreate the table as item_db2. Effectively removing the bug while keeping the renewel settings.

would this assumption be a correct fix with no future problems? Or does the current git release need to be followed up with an update?

BUG2

[ERROR]:
script error on item_db_re line 5783
unexpected end of script
* 5783 : if < checkmadogear<> > <itemheal rand<200,300>,0;

same error for lines 5784 and 5785 with <itemheal rand<*,*>,0; displaying 300,400 and 400,500 in that order.

Now I tried finding items 5783-5 do not seem to be the right items. So ill have to check that with notepad++.

I am going to fix this by finding the items in item_db_re.sql

BUG3

[SQL] DB error - Table 'ragnarok.mob_db2' doesn't excist
[DEBUG] at ..\src\map\moc.c:3958 - select * from 'mob_db2'

I am asuming the sql file did the same as in bug1

[SQL] DB error - Table 'ragnarok.mob_skill_db2' doesn't excist
[DEBUG] at ..\src\map\mob.c:4460 - select * from 'mob_skill_db2'

bug 1 again?

Did I miss something in the update sql's?

Or do I simply need to make a change in inter_athena.conf?

Was making some video tuto's when I came across this stuff, the few visitors I have wont be pleased XD.

Also posted in wrong section I presume.

Bug 1 and 3 fixed by making changes to inter_Athena.conf. for some reason "// Map Database Tables" had those db's quoted. and for some reason had 4 more entries then the same file on ma test server. I can only asume thats because of the different versions of visual studio im using between my test server and live server.

January 5, 2014

My suggestion is this,

0 = Usable : healing2 = Usable : other3 = Misc4 = Weapon5 = Armor6 = Card7 = Pet Egg8 = Pet Equipment10 = Arrow/Ammunition11 = Usable : delayed consumption (items with script "pet" or "itemskill")18 = Another delayed consume that requires user confirmation before using item.

Add an item type to create useable items that wont be consumed to this list. For instance,

36 = Usable delayed consumption that won't be consumed upon use (items with script "pet" or "itemskill")

Personally I'd use this for gm skills without giving gm's access to all skills and rental items

January 5, 2014

So, I have been googeling this for hours now and can't find much to explain how this works.

Intended use on private server using 2013 client (not talking about cash shop NPC) -- Shop for donors.

At least I think this is what private servers would want to use it for.

Now we have free cash and cash points.

How do we obtain cash and free cash? From what I've read you get points for logging in, being active for an hour, events and pvp. Assuming this is vanilla, where would the scripts for these files be located?

Lets say we remove all passive gains of cash, since even this is hard to find.

Again assuming this is vanilla, how is this even done?

Now how would we add items to the cash shop, and what limitations would we face? From what I've read you need to have the same amount of items in each tab or it will bug out on you.

And last but not least, how would donors obtain there cash points? Is there a PHP script available? Is there a predefined item for cash point npc script?

Now as for answers I would prefer links to existing threads that explain these questions, just so I can edit em in this post more easily. But any helpful comments will do. Please no remarks about using the search function, it's a redundant and useless remark.

January 4, 2014

Point made /meh

January 4, 2014

So if I scrolled over this right. You are saying it is not possible to delete entries from stuff like mob_branch?

Why not just tell people to copy the file they want to change to said directory, and them have them change that file.

This way you can update all original files as much as you want, as long as the server would always prioritize the import folder.

Now did this make any sense, or did I completely miss the point here?

Anyways, back to looking for ai4rei's guide on 9 digit damage...(I don't even know how I got here)

January 3, 2014

I don't wanne be a prick, but I used the search box. And it found you telling me to use the search box. Oh and for some reason, Rytechs client tools.

January 1, 2014

If you could provide me with your "modem" details,

brand and model number.

I can probably tell you how to port forward.

Send me a PM with a link to this forum thread if you want some personal help.

December 31, 2013

Hey peeps,

This tutorial will be implemented on REROWIKIA.

The guide will be turned into what I call proper english.

Currently I'm following the steps in this guide, but I'm finding that there is a lot of stuff missing and or wrong.

ReroWikia only uses the rAthena server so if you are on Hercules don't expect to much help.

Once I figure out how to get the client translated fully, I'll start copy pasting my guides to ReroWikia.

ETA -48 Hours

December 29, 2013

Question about the LOKI Launcher.

~~It requires you to enter a user name.. any username.~~

~~And it requires you to enter a password.. any password.~~

~~I then get the select server window.~~

~~And need to login with the old fashion login window.~~

~~Client will connect to the servers and everything so that parts working I guess.~~

Fixed -- Had restore login window diff checked....

Also, why is it the process of LokiLauncher is not closed when closing the program?

I have enabled and disabled autorun. There is no tray icon in either mode nor is there an empty space.

I can't and wont use Loki if these 2 problems can't be resolved.

April 15, 2013

well, thats the problem.
flux is running on a host, mysql in my local machine.

I checked and my host doenst block any traffic on ports.

And I opened up port 80 in my router for my second router, which also has port 80 open for my server.

-----------------------

I tried using Wamp, disabled its sql. Copied flux to the www folder, redirected my site to my desktop. Flux installed but after the installation of the queries I couldnt log in or create accounts. And my domain name got replaced by my WAN.

-----------------------

So I cant get flux to run properly using my domain or wamp.

Which is stupid cause it worked perfectly when my host also had mysql database.

But since the server runs on my desktop I had huge lags whenever a change was made in the sql database

April 13, 2013

Isnt it obvious,

A rewritten kafra located in all major cities preferably near the @go spots which saves you on either a predetermined location near the kafra, or saves you in the spot your standing on.

For instance, in prontera you have to walk down for ages and when you let that kafra save you, you have to walk up for ages everytime you die.

April 10, 2013

I am trying to connect xantara flux to my local server.

However, everything I try comes back with a QLSTATE[HY000] [2003] Can't connect to MySQL server on '85.#.#.#(4)

I am using the ip adress my client uses to connect to the server

With the second sql user(so not root)

In application.php i put this

'ServerAddress'        => 'web.host.IP:and port',
'BaseURI'              => '  ', //located in root so I dont have to write a redirect

In my servers.php I changed 127.0.0.1 to my WAN address (85.#.#.#)

In my router I opened up ports 3306 and the port specified by my webhost(not sure if i need this since my ftp client doesnt)

Firewalls are off

Any ideas why I cant connect to my mysql server?

April 4, 2013

Hey,

I have tried dozens of custom hom ai files.

And they all dont work.

All your Homs will do this.

support type - follows you does nothing unless told by the player

attack type - auto attacks everything

S type - follows you around, does nothing unless told by the player

I copied all custom AI files to ai and ai sakray

then copied them to user ai

making sure I deleted all pre-existing files.

And the AI fails to respond.

Has any1 been able to solve this ?

April 4, 2013

This problem only happens to me when I create an error in the SQL DB.

Map server should show an SQL error.

like for me sql,s int table died on me and gave me a syntax error.

Making everybody with a hom crash.

Had to delete the table and recreate it to fix the error

April 4, 2013

I am using no custom scripts from the internet. All the custom scripts im using are already suplied by the svn release of the rathena server files. and can be found in the npc/ customscripts.txt

April 1, 2013

Well at 1st I thought it was a gm trolling, then he logged off.

I restarted the server and it kept on going.

The only custom scripts im using so far are included in the rathena download, and I believe almost all of them are from euphy.

So I trust its not that.

Also this only started happening after I increased max lvl to 170

Enabled day/night cycle

And implemented my custom palette which doesnt actually hold any scripts.

To make sure its not a gm trolling I checked whos online and this happens when no gm accounts are logged in

Sign In

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by sietse11