Log in

View Full Version : Account rewards via /claim


Maze_EQ
10-02-2012, 12:13 PM
http://www.eqemulator.org/forums/showthread.php?t=31258&highlight=account+rewards


Viewed here, and yes it is possible to make the claims appear by manually entering them.


Is there any function to making this work via perl, or any other automated means.

It just seems illogical to manually update this every time you want to add someone to a reward.

image
10-02-2012, 02:59 PM
Client::SendRewards (client.cpp) handles all the loading from the DB and pushing it to the client through OP_VetRewardsAvaliable. As-is we load a DB ID for each claim from the database. This is passed between client and server so the DB ID's need to be unique.

query ran:
SELECT reward_id, amount FROM account_rewards WHERE account_id=%i ORDER by reward_id;

you could check for existing and insert new entries

SQL in perl:

http://eqemulator.org/forums/showthread.php?t=35216

Maze_EQ
10-03-2012, 09:05 AM
Thank you Image.

This is EXACTLY what I needed. Appreciate your help!

Jejukin
03-10-2015, 03:38 PM
Realize I'm replying three years later and maybe no one will see this, but I've just set up a working private server and I'm interested in making /claim work for all new accounts.

I suspect that some of the code above relates to this endeavor, but it's completely over my head.

If anyone happens to still be active on this board and willing to explain it, that'd be very, very cool. In the mean time I will tinker in hopes of spontaneous enlightenment. :)