Search found 136 matches

by altalus
Wed Mar 05, 2014 10:01 am
Forum: Bugs
Topic: SQL: Missing Grounds Tome in npc_list.sql
Replies: 1
Views: 2299

SQL: Missing Grounds Tome in npc_list.sql

Hello all :) I do not currently have access to retail to get the information for the grounds tome and quite a few are missing from the npc_list.sql file. I would need someone to add them to the SQL file: SQL to get the list from your database: ========================================================...
by altalus
Wed Mar 05, 2014 8:59 am
Forum: Bugs
Topic: Spell interruption
Replies: 13
Views: 6750

Re: Spell interruption

I had the EXACT same issue and I finished by re-imaging the VPS that it was on with a 32bit version of Linux. Now there is no problem.

And I had tried everything to force the 32 build.

I am now using Ubuntu 12.10 (GNU/Linux 2.6.32-042stab084.17 i686) and I don't have a problem anymore.
by altalus
Wed Mar 05, 2014 8:57 am
Forum: Bugs
Topic: Field Manual in Yhoator
Replies: 2
Views: 2031

Re: Field Manual in Yhoator

You can see the books ? Then I have a problem with my npc_list.sql or the server.lua because mine does not complain about being spawned but no books to be seen.
by altalus
Mon Mar 03, 2014 10:48 am
Forum: Suggestions
Topic: can someone script ground tombs in
Replies: 13
Views: 8075

Re: can someone script ground tombs in

New post in the bugs section: viewtopic.php?f=15&t=1911
by altalus
Wed Feb 26, 2014 8:37 am
Forum: Bugs
Topic: Field Manual in Yhoator
Replies: 2
Views: 2031

Field Manual in Yhoator

Hello :) Can anybody else confirm that they can see and talk to the 3 Fields manuals in Yhoator Jungle ? I cannot find them on my server and yet the npc id are spawned in server.lua so either the ID have changed or something weird happens in my server :P

Thanks !
by altalus
Fri Feb 14, 2014 11:10 am
Forum: Suggestions
Topic: can someone script ground tombs in
Replies: 13
Views: 8075

Re: can someone script ground tombs in

[removed]
by altalus
Fri Feb 14, 2014 9:08 am
Forum: Suggestions
Topic: can someone script ground tombs in
Replies: 13
Views: 8075

Re: can someone script ground tombs in

all names should be changed to grounds_tome now. to get the id, polutils can help you i think Seems it is not the case. I just pulled to be sure I had the latest version and I still see lots of wrong named tomes :) I will edit the SQL and add it to my branch to make sure we have them all. I *am* mi...
by altalus
Sun Feb 02, 2014 4:39 pm
Forum: General Chat
Topic: Need help with SQL trigger :)
Replies: 1
Views: 1713

Re: Need help with SQL trigger :)

Fixed it, but posting solution here in case it helps someone else: DELIMITER $$ USE `dspdb`$$ DROP TRIGGER /*!50032 IF EXISTS */ `auction_house_cancel`$$ CREATE /*!50017 DEFINER = 'root'@'localhost' */ TRIGGER `auction_house_cancel` BEFORE DELETE ON `auction_house` FOR EACH ROW BEGIN DECLARE num_ite...
by altalus
Sun Feb 02, 2014 10:57 am
Forum: General Chat
Topic: Need help with SQL trigger :)
Replies: 1
Views: 1713

Need help with SQL trigger :)

Hello ! I want to allow my users to cancel a sale manually and it will also allow a bot to check for old sales. Now I created a trigger but something is wrong with it and I'm not quite sure what... any help ? :) DELIMITER $$ USE `dspdb`$$ DROP TRIGGER /*!50032 IF EXISTS */ `auction_house_cancel`$$ C...
by altalus
Thu Jan 30, 2014 3:43 pm
Forum: Suggestions
Topic: Trust/RoE?
Replies: 4
Views: 3956

Re: Trust/RoE?

Unless someone does it and create a pull request ;)