Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 08:21

  • Please register to post and access all features, it's quick, easy and FREE!

 

[SQL] Looking for fixed code

Reply
 
Old   #1


 
elite*gold: 30
Join Date: May 2011
Posts: 4,801
Received Thanks: 3,181
[SQL] Looking for fixed code

null.

Want to do that, too.



Xijezu is offline  
Old   #2
 
elite*gold: 0
Join Date: Jul 2009
Posts: 508
Received Thanks: 294
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)



Raskim2000 is offline  
Thanks
2 Users
Old   #3


 
elite*gold: 30
Join Date: May 2011
Posts: 4,801
Received Thanks: 3,181
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
Xijezu is offline  
Old   #4
 
elite*gold: 0
Join Date: Mar 2011
Posts: 448
Received Thanks: 54
Danke Raskim Ich bau das Query noch n bissl schöner und dann poste ichs hier


lawlywood is offline  
Old   #5
 
elite*gold: 0
Join Date: Dec 2010
Posts: 664
Received Thanks: 189
you never fill out sid, it's auto-increment
RoflcopterGoesSoiSoiSoi is offline  
Old   #6
 
elite*gold: 0
Join Date: Mar 2011
Posts: 448
Received Thanks: 54
I got this working now
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

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)
lawlywood is offline  
Old   #7
 
elite*gold: 0
Join Date: Jul 2009
Posts: 508
Received Thanks: 294
Quote:
Originally Posted by lawlywood View Post
I got this working now
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

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?

Na gut, du hast noch die klausel reingehauen, das er dir anzeigt das die falsche id verwendet wurde.
Raskim2000 is offline  
Old   #8
 
elite*gold: 0
Join Date: Mar 2011
Posts: 448
Received Thanks: 54
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...
lawlywood is offline  
Old   #9
 
elite*gold: 0
Join Date: Jul 2009
Posts: 508
Received Thanks: 294
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
Raskim2000 is offline  
Old   #10
 
elite*gold: 0
Join Date: Mar 2011
Posts: 448
Received Thanks: 54
lolz. ne ich will ja, dass man sich den char aussuchen kann, da manche items char-bound sind.
lawlywood is offline  
Old   #11


 
elite*gold: 30
Join Date: May 2011
Posts: 4,801
Received Thanks: 3,181
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
Xijezu is offline  
Old   #12
 
elite*gold: 0
Join Date: Mar 2011
Posts: 448
Received Thanks: 54
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


lawlywood is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[26.03]Geoning D3D V5.2 Beta - Chams, Fixed OPK, 2 vesion menu, Fixed SpeedHack
Od autora... OPK, SVP, wymaga szybkiego procesora. Menu zmieniamy za pomocą klawiszy PageUp i PageDown Mam nadzieje, że hack się wam spodoba :) ...
10 Replies - WarRock Hacks, Bots, Cheats & Exploits
VIP HACK @@@@@ 02.03.2011 by Geoning. Many Fixed PLAYERS OPK, FIXED NFD
Cześć, hack mojej produkcji ^^ Na 64bitowym Windowsie 7 hack działa bez lagowania ponad 3 godzin (dalej nie testowałem ^^) Warning! If you want...
1 Replies - WarRock Hacks, Bots, Cheats & Exploits



All times are GMT +2. The time now is 08:21.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.