another sql query

why did u put a return between the 2 messages?

o thats a hint ;)

Quote:

Originally Posted by pieter why did u put a return between the 2 messages? o thats a hint ;)

coz i dont know sql

thanks for hint , got it work

but i send 20% exp for 1 day , but it get removed when i put it , just stay 2 mins

why ?

GUYS I KNOW THIS IS OLD AS HELL BUT THERE ARE STILL PEOPLE OUT TRYING TO FIGURE THIS OUT SO I WAS PLAYING AROUND ON MY TEST SERVER AND FIGURED IT OUT


COMMIT TRANSACTION
declare @itemnum INT
SET @itemnum = 9901
EXEC character.dbo.SP_POST_SEND_OP @character_no,'WHO IT'S FROM',1,'THERE MESSAGE YOU WANT THEM TO READ',@itemnum,'0',0
SET @itemnum = 9901
EXEC character.dbo.SP_POST_SEND_OP @character_no,'WHO IT'S FROM',1,'THERE MESSAGE YOU WANT THEM TO READ',@itemnum,'0',0
SET @sp_rtn = 0
RETURN

THIS WILL CREATE 2 DIFFERENT MESSAGES AND ITEMS

actually there arent any PEOPLE trying to figure this out, and your sql is retarded.

Then run 4 times this query LOL

You can use this on web

[Only registered and activated users can see links. Click Here To Register...]

@baica123 Janvier was released a script for send a msg in mailbox by php :) Just look on his releases

yeah, I know. I think it can help some1 ^^

I was only trying to help someone that didn't know what the fuck they was doing Decima so keep your big fat mouth shut, there is always people out there trying to learn new things god people like you need to get a life so shut up sit back and let new people who are first starting out learn how to do shit just cause you know how don't mean other people do and idc if you reply back I am not going to read your post no point I got my point out

you replied to a 5 year old post tiger, the only one trying to figure this out is you, otherwise someone would had replied to this in the 5 years is had been dead, but i digress, apparently your arent the brightest crayon in the box.

next time you try to help someone and dont want someone to say something about it, try replying to a post made recently, with info that everyone else doesnt already have, otherwise dont start throwing a temper tantrum when someone posts something you dont want to hear, and while you are at it, at least check to see if the information you provide in the 5 year old post is proper instead of helping ppl with bad information, i dont think thats very fair to the ppl 'first starting out' to start out with some bad information, if you care so much about the ppl that first start out, maybe you should care more for the information you are providing to them rather that looking awesome on the forums.

The only time you reply to a thread Decima is to flame someone. This is elitepvpers not Decima's flame forum. Stop pushing your "rules" and the way you "think" people should reply to threads. At least someone is posting in this section to keep it active. If they didn't, then you wouldn't be able to satisfy your weekly requirement to flame someone here.

the only time you reply on here is to advertise ur server and flame ppl you dont like.

i didnt reply to flame, i was stating a fact, just becus you dont like something i say doesnt mean its flaming, fyi if you dont like what i say in a post, you dont have to read it, nor do u have to reply to it, its fine you dont like what i say, but just becus you dont like it doesnt mean its not true. i came on here to reply with a reply that was pertinent to the post before it, only reason you replied was to give me crap for my post, your reply doesnt even have anything to do with the actual post so stop calling the kettle black.

and ur right, this is elitepvpers, not freeze's personal advertising section to up up his search engine ranking, practice what u preach.

Quote:

Originally Posted by Decima the only time you reply on here is to advertise ur server and flame ppl you dont like.

I haven't advertised since last year lmao. Read my last post in the thread.

Quote:

Originally Posted by Decima i didnt reply to flame, i was stating a fact, just becus you dont like something i say doesnt mean its flaming,

This isn't flaming:

Quote:

Originally Posted by Decima actually there arent any PEOPLE trying to figure this out, and your sql is retarded

Quote:

Originally Posted by Decima fyi if you dont like what i say in a post, you dont have to read it, nor do u have to reply to it, its fine you dont like what i say, but just becus you dont like it doesnt mean its not true. i came on here to reply with a reply that was pertinent to the post before it,

Good advice! Maybe you should follow your own advice?

Quote:

Originally Posted by Decima only reason you replied was to give me crap for my post, your reply doesnt even have anything to do with the actual post so stop calling the kettle black.

Yup, because you're telling people what and how to post in a thread. The person was trying to help. Who care's if it's an old thread.

Quote:

Originally Posted by Decima and ur right, this is elitepvpers, not freeze's personal advertising section to up up his search engine ranking, practice what u preach.

That's freez (No e at the end). My thread is like 2 pages down now there sport, so take a chill pill. Better yet, go pray to satan. He's such an awesome role model, no wonder you are the way you are!

lmfao, u about done?

last year was 20 days ago

no it wasnt flaming, it was a fact, if you knew anything about sql u would agree

again, calling the kettle black, u jumped on my post, not the other way around

i wasnt ' telling people what and how to post in a thread' the person wasnt helping anyone, his sql was bad, he was replying to a 5 year old post that no one had replied to in 5 years, there was nothing about his post that was helpful in anyway, especially for anyone beginning, if anything it was hindering beginners with bad sql and setting a bad example by grave digging a 5 year old post

its cute you cant spell such a simple word, and fyi einstein, my sig is a movie quote, not a confirmation that i worship satan, of course if you had half a brain and any inkling of a life you would had known that, but again, i digress, seems no matter what i say you think you have a clue what you are talking about when u obviously do not, and every post you make continually backs that up, ignorance must be bliss.

if you are about done making urself look even more retarded than ppl already think you are, i actually have stuff to do rather than school a self absorbed noob

Hey Einstein, my last post was Dec 9th, that's 42 days ago. You're only wrong by 22 days. I know your sig is a movie quote, but the shout under your avatar was over the top, it still says a lot about someone's character.
And yes it's Freez no e because it's taken from my old DJ name MrFreez but that handle was taken already. I know QQ.

I haven't even resorted to calling you names or insulting you yet. Yet, I'm retarded. Hahaha, shows that I am getting my point across and easily aggravating you without resulting to 3rd grade schoolyard name-calling. Perhaps that's the level of your education in which case I feel sorry for you. I'm right, you do flame on this forum and you flame because it makes you feel good. So go ahead and get your daily dose of self-confidence. I get mine when I walk into a classroom to teach high-level government officials and law enforcement. No, I don't work for the government, I'm the guy they hire to teach them because they don't have resources that can do what I can. But hey, thanks for making me laugh. I haven't been called a retard since 3rd grade. Brings back memories of re-arranging that kid's attitude and sending him home bleeding. Perfect end to a long day!