dbo.dailyzen2

Does anyone have stored procedures dbo.dailyzen2 or dbo.dailyzen in ur MSSQL what can share ?
Or if anyone have working php code for add daily zen , restrict on date and ip addesses.

I m finish all for runing local server, translate WoI on my language, make web part :register/login also i make to get zen for loged account but can't restrict on curent date and IP

At this moment i have runing 8 realms on 2 dedicated DELL server with 36GB RAM-s and 5 TB space
+ 1 machine with not that high preformace for linux side.

I really would be appreciate if anyone can help me with this WEB part for finish server.

Anyone ?

First of all, you won't need 5 TB space, waste of money. In fact you wouldn't even need more than like 100GB (even that would last for months until Logs fill it up).

Secondly, there's no MSSQL/MySQL Stored Procedures made for the soul purpose of "Daily ZEN". That's genuinely a web-based Script using PHP & MySQL OR MSSQL depending on what kind of authd you are using. It's quite simple to do, but also requires you to know how to block out abusers etc.

Quote:

---

Originally Posted by LeRaz0r

First of all, you won't need 5 TB space, waste of money. In fact you wouldn't even need more than like 100GB (even that would last for months until Logs fill it up).

---

First ty for answer :)
I know its alot then i needed for woi server, but i already have this servers what just colect dust after i finish one sms capaing (btw i m CEO of one advertising agency).

Quote:

---

Originally Posted by LeRaz0r

Secondly, there's no MSSQL/MySQL Stored Procedures made for the soul purpose of "Daily ZEN". That's genuinely a web-based Script using PHP & MySQL OR MSSQL depending on what kind of authd you are using. It's quite simple to do, but also requires you to know how to block out abusers etc.

---

Yup i know that to i just named like example "dbo.dailyzen" its missunderstunding . I really would be appreciate if you show me part of code how i can make this.

It's really easy tbh...

When a user logs in (with correct credentials), connect to MSSQL Database (I'm guessing you're using MSSQL Authd) and just assign the SESSION variables such as $_SESSION['AccountID'] = $grabData['AccountID']; and then by default you can just use

$Amount = 100000;
$AccountID = $_SESSION['AccountID'];

exec PassportBOI.dbo.pipiload_addcashbyid $AccountID, $Amount

It's just simple queries really.

Yes i have this to work adding zen its easy like you said, my code its similar to you example, but i have problem with checking did someone got zen today or not.

Thats why i want to make one more table for storing/geting data from her , with ip , date, id of account.
What i need ?
need procedure what will be stored data after player got zen and later check that data for player can not use more for today on that account and from same IP.

done!