Jump to content

  •  

exi1992

Member Since 29 Jan 2014
Offline Last Active Feb 24 2014 12:06 PM
-----

Posts I've Made

In Topic: Proof of Donation?

03 February 2014 - 05:34 PM

no its not possible
you can't mess with player's online data with query_sql, Sql_Handle or mysqli_query
asking players to click on npc again is the correct method

if you inject items into an online player, the item sure lost, even after relog



if you need proof

prontera,158,185,5	script	kdjshfkjsf	100,{	query_sql "select id from storage where account_id = "+ getcharid(3) +" and nameid = 501", .@id;	if ( .@id )		query_sql "update storage set amount = amount + 1 where account_id = "+ getcharid(3) +" and nameid = 501";	else		query_sql "insert into storage ( account_id, nameid, amount, identify ) values ( "+ getcharid(3) +",501 , 1, 1, )";	mes "item successfully injected";	end;}
this script is bug
prontera,160,185,5	script	kdjshfkjsf2	100,{	.@origin = getcharid(3);	atcommand "@kick "+ strcharinfo(0);	sleep 1000;	query_sql "select id from storage where account_id = "+.@origin +" and nameid = 501", .@id;	if ( .@id )		query_sql "update storage set amount = amount + 1 where account_id = "+ .@origin +" and nameid = 501";	else		query_sql "insert into storage ( account_id, nameid, amount, identify ) values ( "+ .@origin +", 501, 1, 1 );";	end;}
this script is working

there is no way for fluxCP to kick an online player in a game, so its not possible

 

[color=rgb(62,69,76);font-family:'lucida grande', tahoma, verdana, arial, sans-serif;background-color:rgb(219,237,254);]thank you. so i changed the item id from your script into proof of donation. will people get proof of donation when they click it after relog if they already donated? is it connected to flux cp? or do i need add something to mysql?[/color]


In Topic: Proof of Donation?

03 February 2014 - 02:10 AM

then, when you log in to your account, you should find your proof of donations in your storage

doing like this should be discourage
because the players can still be login in the game while vote for your server

in the original script the fluxCP provided,
the query_sql is being read on the spot, so even if the player is online while voting
if the player click on the npc again, the points has been updated due to reading the sql table

but since you want to inject an item into storage, the sql query will only work if the player is offline
if you inject an item into storage while that player is online,
that player will not have the item because the character data is being processed inside char_server.exe

[color=rgb(62,69,76);font-family:'lucida grande', tahoma, verdana, arial, sans-serif;background-color:rgb(247,247,247);]then the users can get their proof of donations after a re-log. it's not a big deal. we can tell about this in the donation information. i just need to know how to make it. when they are done with "donation" (not voting) i want them to get proof of donation automaticly to their storage. is it possible?
Or normally, when they donate, do they get proof of donations to their storages?[/color]


In Topic: Proof of Donation?

02 February 2014 - 12:12 AM

Might probably want to use OnPCLoginEvent label?

i'm sorry, i didn't understand what you mean. i wonder if you get what is my problem. i only wonder if a donator automaticly gets proof of donation in game when he donate from flux cp. if not how can i do it.

You need to make an NPC that can Convert Ponts/Cash to Item/PODs
try this Utility: Points to Item Exchanger play with it. :)
(Moved to Script Request)

i already have a npc which gives items when you give proof of donations to him. my problem is with flux cp. and i dont thing it's about script request :)
for example you donate from the panel
then, when you log in to your account, you should find your proof of donations in your storage
this is what i want

In Topic: Quest Custom Npc Need Help !!

30 January 2014 - 01:07 PM

Thanks a lot bro


In Topic: Quest Custom Npc Need Help !!

30 January 2014 - 10:46 AM

Like this?

prontera,200,180,3	script	test	123,{if(countitem(7227) < 10 || countitem(7179) < 10) goto Lne;mes "Okay, here you go!";delitem 7227,10;delitem 7179,10;getitem 5135,1;close;Lne:mes "Do you want to make this item?";mes "You have to bring me these ingredients!";mes "10 TCG";mes "10 PODS";close;}

[color=rgb(62,69,76);font-family:'lucida grande', tahoma, verdana, arial, sans-serif;background-color:rgb(247,247,247);]Yeah, exactly like this. And i want this npc to shine for a second when you gave all requirements. And how to make an auto-announcement when someone done with one quest. Like "UserName has finished Megingjard Quest. Congratulations!"[/color]