[SQL] Looking for fixed code

11/22/2011 01:06 Xijezu#1
null.

Want to do that, too. :D
11/22/2011 01:13 Raskim2000#2
Quote:
Originally Posted by Xijezu View Post
Heya,

Some confusing title, but I will explain it for ya.
I'm working on a GM/Admin-Panel in php, for example: Insert Items or Buffs.

Thats because most times I'm not able to connect ingame, because I'm not at home.

I'm going to release the finished script for sure. ;)

All was working fine expect inserting skillcards.

When I'm going to insert a skillcard via SQL/PHP, I will get it Ingame.
But if I relogg, either the skillcard disappears or it is +1 insteat of +10.

Raskim? ismoke? someone of NCarbon? someone who knows about SQL?
Try to find the issue.


First try:

Second try (just a general insert_item-procedure)

Thanks for reply.
Why don`t you try it on an other way. You try to insert them directly, this seem`s not to work. Try it with the ShopBox (dbo.paiditem)


Edit: Don`t forget, that the Launcher need the row "/cash".

My Launcher use this line. (It`s for official, so don`t waste your time trying to "Hack" it ;p)

11/22/2011 01:23 Xijezu#3
Well, sure, that would be an alternative way, but I'm confused about the columns, dont know what all of this does.

Magst mal skype on kommen und mich über die spalten aufklären? xD
11/24/2011 21:27 lawlywood#4
Danke Raskim :D Ich bau das Query noch n bissl schöner und dann poste ichs hier :D
11/25/2011 03:31 RoflcopterGoesSoiSoiSoi#5
you never fill out sid, it's auto-increment
11/25/2011 13:15 lawlywood#6
I got this working now :D
It won't set a time limit cause i don't need it. Feel free to add it, if you want.
Those items will appear in the item box. Look for the /cash flag in your launcher. Thank you Raskim for posting those infos about the paidItem thing :D

Users won't recieve a message in the chat, that they have recieved a new item!


Code:
Use Telecaster
DECLARE @id int; --accountid
DECLARE @itemcount int; --Anzahl der Items
DECLARE @item int;
DECLARE @avatarid int;

-----------Insert Settings here-----------------
SET @item = '' --INSERT ITEM ID (e.g. 2010764 R6 Cloak)
SET @itemcount = '1' --INSERT THE NUMBER OF ITEMS
SELECT @avatarid = sid FROM Character WHERE name = 'CHARNAME' --INSERT CHARACTER NAME
------------------------------------------------

SELECT @id = account_id FROM Character WHERE sid = @avatarid

--Warning
IF @id IS NULL
BEGIN
PRINT 'WARNING: This Character does not exist. No Rows affected!'
RETURN
END

--DB Update
INSERT INTO [telecaster].[dbo].[PaidItem]([account_id],[avatar_id],[avatar_name],[item_code],[item_count],[rest_item_count],[bought_time],[valid_time],[server_name],[taken_avatar_id],[taken_avatar_name],[taken_server_name],[taken_time],[taken_account_id],[confirmed],[confirmed_time]) VALUES (@id,@avatarid,NULL,@item,@itemcount,@itemcount,'2011-10-01 12:00:00.000',NULL,NULL,NULL,NULL,NULL,NULL,@id,NULL,NULL)
11/25/2011 13:24 Raskim2000#7
Quote:
Originally Posted by lawlywood View Post
I got this working now :D
It won't set a time limit cause i don't need it. Feel free to add it, if you want.
Those items will appear in the item box. Look for the /cash flag in your launcher. Thank you Raskim for posting those infos about the paidItem thing :D

Users won't recieve a message in the chat, that they have recieved a new item!


Code:
Use Telecaster
DECLARE @id int; --accountid
DECLARE @itemcount int; --Anzahl der Items
DECLARE @item int;
DECLARE @avatarid int;

-----------Insert Settings here-----------------
SET @item = '' --INSERT ITEM ID (e.g. 2010764 R6 Cloak)
SET @itemcount = '1' --INSERT THE NUMBER OF ITEMS
SELECT @avatarid = sid FROM Character WHERE name = '' --INSERT CHARACTER NAME
------------------------------------------------

SELECT @id = account_id FROM Character WHERE sid = @avatarid

--Warning
IF @id IS NULL
BEGIN
PRINT 'WARNING: This Character does not exist. No Rows affected!'
RETURN
END

--DB Update
INSERT INTO [telecaster].[dbo].[PaidItem]([account_id],[avatar_id],[avatar_name],[item_code],[item_count],[rest_item_count],[bought_time],[valid_time],[server_name],[taken_avatar_id],[taken_avatar_name],[taken_server_name],[taken_time],[taken_account_id],[confirmed],[confirmed_time]) VALUES (@id,@avatarid,NULL,@item,@itemcount,@itemcount,'2011-10-01 12:00:00.000',NULL,NULL,NULL,NULL,NULL,NULL,@id,NULL,NULL)
Ist doch im Prinzip nichts anderes wie mein Script? :D

Na gut, du hast noch die klausel reingehauen, das er dir anzeigt das die falsche id verwendet wurde. :D
11/25/2011 13:30 lawlywood#8
Nein ich habs einfacher gemacht, dass du nicht für jeden insert:
1. die character nummer suchen musst
2. die account nummer suchen musst
3. die blöcke abzählen musst
und 4. müll in der db drinnen steht ;)

Also ich finds so deutlich komfortabler event items zu verteilen...
11/25/2011 13:40 Raskim2000#9
Pardon, ich bin etwas verwirrt gewesen, aber ich merk gerade das du die items direkt ins inventar legen willst mit dem script, aber da fehlen doch noch die taken_time usw.

Edit: Vergiss was ich gesagt hab, nicht mein Tag heute :D:D
11/25/2011 13:53 lawlywood#10
lolz. ne ich will ja, dass man sich den char aussuchen kann, da manche items char-bound sind.
11/25/2011 16:24 Xijezu#11
Da ihr ja bestimmt gesehen habt, und ich mich just 4 fun an den Cashshop gesetzt habe, finde ich auch, das die normale Procedure um längen einfacher ist.
Man hat die ganzen Werte, sprich acc. id etc. in Variabeln gespeichert, und brauch dann nichts mehr machen, ...
Ich verzichte eigentlich so schon grundsätzlich auf die INSERT ITEM-Variante, ich mag die nicht. :/ xD
11/25/2011 16:32 lawlywood#12
nuja ich nutz immer ingame insert_item aber verschiedene items (donation wings oder event zeug) landet immer im eigenen inventar. dafür ist die box ganz nice