Reply to thread

Message

<blockquote data-quote="Cookiez38" data-source="post: 309131" data-attributes="member: 51350">Hellow,can someone tell me what wrong with this? because i get &quot;ERROR in command &quot;trois&quot; : fatal error encountered during command execution[PHP] case &quot;trois&quot;:&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; Session TargetSession = SessionManager.GetSessionByCharacterId(CharacterResolverCache.GetUidFromName(Session.CharacterInfo.Username));&nbsp; &nbsp; &nbsp; &nbsp; if (TargetSession == null || !TargetSession.InRoom)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendData(RoomChatComposer.Compose(Actor.Id, &quot;Could not find &quot; + Session.CharacterInfo.Username + &quot; in this room!&quot;, 0, ChatType.Whisper));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; int num1 = 0;&nbsp; &nbsp; &nbsp; &nbsp; int num2 = 0;&nbsp; &nbsp; &nbsp; &nbsp; string str1 = string.Empty;&nbsp; &nbsp; &nbsp; &nbsp; int num3 = 0;&nbsp; &nbsp; &nbsp; &nbsp; string Message = string.Empty;&nbsp; &nbsp; &nbsp; &nbsp; string string2 = MergeParams(@params, 1);&nbsp; &nbsp; &nbsp; &nbsp; int num4 = Session.CharacterInfo.CreditsBalance;&nbsp; &nbsp; &nbsp; &nbsp; if (string2 == null &amp;&amp; string.IsNullOrEmpty(string2))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DataRow row1 = MySqlClient.ExecuteQueryRow(&quot;SELECT a.*,b.* FROM zaprp_weapons AS a JOIN zaprp_user_weapons AS b ON (a.weapon_id = b.weapon_id) WHERE a.weapon_name = @wepname AND b.user_id = @userid&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlClient.SetParameter(&quot;wepname&quot;, (object)string2);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlClient.SetParameter(&quot;userid&quot;, (object)Session.CharacterInfo.Id);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (row1 == null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DataRow row = MySqlClient.ExecuteQueryRow(&quot;SELECT weapon_id, weapon_name, cost_credits, clip_size, type FROM zaprp_weapons WHERE weapon_name = @wepname LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlClient.SetParameter(&quot;wepname&quot;, (object)string2);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (row != null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; num1 = (int)row[&quot;weapon_id&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; num2 = (int)row[&quot;cost_credits&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; str1 = (string)row[&quot;type&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string2 = (string)row[&quot;weapon_name&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; num3 = (int)row[&quot;clip_size&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendData(NotificationMessageComposer.Compose(&quot;That is an invalid weapon, please type :listweapons to view what is available!&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendData(NotificationMessageComposer.Compose(&quot;You already own this weapon!&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; if (num4 &gt;= num2)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlClient.ExecuteNonQuery(&quot;REPLACE INTO zaprp_user_weapons (user_id, weapon_id, ammo_loaded, ammo_inventory) VALUES (@userid, @weaponid, @ammoloaded, @ammoinv)&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlClient.SetParameter(&quot;userid&quot;, (object)Session.CharacterInfo.Id);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlClient.SetParameter(&quot;weaponid&quot;, (object)num1);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (str1 == &quot;gun&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlClient.SetParameter(&quot;ammoinv&quot;, (object)num3);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlClient.SetParameter(&quot;ammoloaded&quot;, (object)0);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Message = &quot;You have successfully purchased a &quot; + string2 + &quot;! You get one clip of &quot; + num3.ToString() + &quot; bullets on the house.&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlClient.SetParameter(&quot;ammoinv&quot;, (object)0);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MySqlClient.SetParameter(&quot;ammoloaded&quot;, (object)0);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Message = &quot;You have successfully purchased a &quot; + string2 + &quot;, enjoy it!&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlDatabaseClient MySqlClients = SqlDatabaseManager.GetClient();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int newcoins = Session.CharacterInfo.CreditsBalance - num2;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendData(CreditsBalanceComposer.Compose(newcoins));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.CharacterInfo.UpdateCreditsBalance(MySqlClients, -num2);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendData(RoomChatComposer.Compose(Actor.Id, &quot;*Buys a &quot; + string2 + &quot;*&quot;, 0, ChatType.Whisper));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendData(NotificationMessageComposer.Compose((Message)));&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendData(NotificationMessageComposer.Compose(&quot;You cannot afford to purchase a &quot; + string2 + &quot;!&quot;));&nbsp; &nbsp; }&nbsp; &nbsp; return true;[/PHP]i use REALITYEMU edit i ppay if someone fixe me it.</blockquote>

[QUOTE="Cookiez38, post: 309131, member: 51350"] Hellow, can someone tell me what wrong with this? because i get "ERROR in command "trois" : fatal error encountered during command execution [PHP] case "trois": { Session TargetSession = SessionManager.GetSessionByCharacterId(CharacterResolverCache.GetUidFromName(Session.CharacterInfo.Username)); if (TargetSession == null || !TargetSession.InRoom) { Session.SendData(RoomChatComposer.Compose(Actor.Id, "Could not find " + Session.CharacterInfo.Username + " in this room!", 0, ChatType.Whisper)); return true; } int num1 = 0; int num2 = 0; string str1 = string.Empty; int num3 = 0; string Message = string.Empty; string string2 = MergeParams(@params, 1); int num4 = Session.CharacterInfo.CreditsBalance; if (string2 == null && string.IsNullOrEmpty(string2)) return true; using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient()) { DataRow row1 = MySqlClient.ExecuteQueryRow("SELECT a.*,b.* FROM zaprp_weapons AS a JOIN zaprp_user_weapons AS b ON (a.weapon_id = b.weapon_id) WHERE a.weapon_name = @wepname AND b.user_id = @userid"); MySqlClient.SetParameter("wepname", (object)string2); MySqlClient.SetParameter("userid", (object)Session.CharacterInfo.Id); if (row1 == null) { DataRow row = MySqlClient.ExecuteQueryRow("SELECT weapon_id, weapon_name, cost_credits, clip_size, type FROM zaprp_weapons WHERE weapon_name = @wepname LIMIT 1"); MySqlClient.SetParameter("wepname", (object)string2); if (row != null) { num1 = (int)row["weapon_id"]; num2 = (int)row["cost_credits"]; str1 = (string)row["type"]; string2 = (string)row["weapon_name"]; num3 = (int)row["clip_size"]; } else { Session.SendData(NotificationMessageComposer.Compose("That is an invalid weapon, please type :listweapons to view what is available!")); return true; } } else { Session.SendData(NotificationMessageComposer.Compose("You already own this weapon!")); return true; } } if (num4 >= num2) { using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient()) { MySqlClient.ExecuteNonQuery("REPLACE INTO zaprp_user_weapons (user_id, weapon_id, ammo_loaded, ammo_inventory) VALUES (@userid, @weaponid, @ammoloaded, @ammoinv)"); MySqlClient.SetParameter("userid", (object)Session.CharacterInfo.Id); MySqlClient.SetParameter("weaponid", (object)num1); if (str1 == "gun") { MySqlClient.SetParameter("ammoinv", (object)num3); MySqlClient.SetParameter("ammoloaded", (object)0); Message = "You have successfully purchased a " + string2 + "! You get one clip of " + num3.ToString() + " bullets on the house."; } else { MySqlClient.SetParameter("ammoinv", (object)0); MySqlClient.SetParameter("ammoloaded", (object)0); Message = "You have successfully purchased a " + string2 + ", enjoy it!"; } return true; } SqlDatabaseClient MySqlClients = SqlDatabaseManager.GetClient(); int newcoins = Session.CharacterInfo.CreditsBalance - num2; Session.SendData(CreditsBalanceComposer.Compose(newcoins)); Session.CharacterInfo.UpdateCreditsBalance(MySqlClients, -num2); Session.SendData(RoomChatComposer.Compose(Actor.Id, "*Buys a " + string2 + "*", 0, ChatType.Whisper)); Session.SendData(NotificationMessageComposer.Compose((Message))); } else Session.SendData(NotificationMessageComposer.Compose("You cannot afford to purchase a " + string2 + "!")); } return true;[/PHP] i use REALITYEMU edit i ppay if someone fixe me it. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members