product
|
Last Activity: 12/13/2019 14:52
Mentions
| 05/19/2024 |
| 18:30 - erasmojosepzo mentioned product in post [Release] Shaiya Essentials ... a dc game.exe
PT
Eu resolvo dessa maneira.
EN
I solved it this way.
ALTER Proc [dbo].[usp_Save_User_BuyPointItems2]
UserUID int,
ChariD int,
usepoint int,
productCode varchar(20),
usedateZ varchar(50)
- usedate datetime
AS
DECLARE usedate as datetime
SELECT usedate = CONVERT(datetime, usedateZ, 120) |
| 03/03/2024 |
| 02:14 - SlashRX mentioned product in post New Year's surprise! ...mages are, any thoughts?
} else if (array_key_exists('add_single_user', $_POST)) {
$query = "DECLARE ReTuRn_value int
EXEC ReTuRn_value = [Atlantica].[dbo].[NGM_PRODUCT_INS]
product_seq = 1,
group_seq = 1,
Main_category = 1,
SuB_category = 1,
BEST_flag = 1,
gift_flag = 1,
oneday_flag = 1,
icon... |
| 06/27/2023 |
| 11:53 - [ADM]Beno™ mentioned product in post [Release] Restore Farm Items During RollBack ...aiya. Let me know if any SQL experts have suggestions for improvement. Happy Playing.
DECLARE userid VARCHAR(18)
DECLARE @ItemID INT
DECLARE @ItemCount SMALLINT
DECLARE productCode VARCHAR(20)
DECLARE OrderNumber INT
DECLARE @BuyDate DATETIME
DECLARE UserUID BIGINT
DECLARE slot TINYINT
DECLARE @Empty SMALLINT
-- Retrieve lost items from Actio... |
| 07/12/2019 |
| 00:43 - HighGamer. mentioned product in post [RELEASE] Atlantica Online Server V3.02.11 ... }
echo '</div>';
} else if (array_key_exists('add_single_user', $_POST)) {
$query = "DECLARE ReTuRn_value int
EXEC ReTuRn_value = [Atlantica].[dbo].[NGM_PRODUCT_INS]
product_seq = 1,
group_seq = 1,
Main_category = 1,
SuB_category = 1,
BEST_flag = 1,
gift_flag = 1,
oneday_flag = 1,
... |
| 02/03/2019 |
| 01:12 - JujiPoli mentioned product in post Shaiya EP3 IM DC fix w/ SQL 2008 Can you try this: https://www.elitepvpers.com/forum/shaiya-pserver-guides-releases/1723004-guide-fixing-game-item-mall.html
and this
https://pastebin.com/y0fwgGva |
| 10/02/2018 |
| 22:27 - HighGamer. mentioned product in post [RELEASE] Atlantica Online Server V3.02.11 ... echo '</div>';
} else if (array_key_exists('add_single_user', $_POST)) {
$query = "DECLARE ReTuRn_value int
EXEC ReTuRn_value = [Atlantica].[dbo].[NGM_PRODUCT_INS]
product_seq = 1,
group_seq = 1,
Main_category = 1,
SuB_category = 1,
BEST_flag = 1,
gift_flag = 1,
... |
| 10/01/2018 |
| 23:34 - HighGamer. mentioned product in post [RELEASE] Atlantica Online Server V3.02.11 ...;
}
echo '</div>';
} else if (array_key_exists('add_single_user', $_POST)) {
$query = "DECLARE ReTuRn_value int
EXEC ReTuRn_value = [Atlantica].[dbo].[NGM_PRODUCT_INS]
product_seq = 1,
group_seq = 1,
Main_category = 1,
SuB_category = 1,
BEST_flag = 1,
gift_flag = 1,
oneday_flag = 1,
... |
| 07/17/2018 |
| 18:51 - SnickQ mentioned product in post Hey Shaiya developers Help with this ...Solution 2:
USE PS_GameData
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create Proc [dbo].[usp_Save_User_BuyPointItems2]
UserUID int,
@CharID int, usepoint int, productCode varchar(20), usedate datetime
AS
SET NOCOUNT ON
--SET XACT_ABORT ON
DECLARE usetype int
DECLARE ReT int
DECLARE remainPoint int
DECLARE @OrderNumber int
DECLARE... |
| 08/12/2016 |
| 12:32 - [GM]Bondax mentioned product in post game.exe clock, 4.5 ...lem is front of your eyes ? Have u checked the error line ?
- 포인트 로그 기록
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCo de,UseDate,RemainPoint,OrderNumber)
VALUES usetype UserUID ChariD usepoint productCode
Change first productco de to productcode |
